Karen Lopez

Where Does the Line Between Data Modeler and DBA Fall?

Question Mark

by Karen Lopez Where Should the Division of Responsibilities Lie Between Data Modeler and DBA? In the past, data architects/modelers have been primarily responsible for preparing logical data models, then they threw models over the wall to the DBAs who said “what the heck is this?” and then did their own physical models (or reasonable facsimile…

Data Model Bloggers: NULL

Get Blogging!

by Karen Lopez Last year I hosted a session on Getting Started in Blogging for Data Professionals at Enterprise Data World. I had a great turnout considering the topic and time (I think 50+ people). We had a good discussion about blogging, social media and how most of the discussions on the Internet had moved from…

7 Tips for Staying Relevant and Valued as a Data Modeler

Modeling with Graeme

by Karen Lopez 1. Learn about NoSQL database technologies You aren’t going to get any warning when your company’s first NoSQL project shows up.  It might be the result of a 19th-hole acquisition project (when C-level executives are wined and dined by a software vendor) or it might be part of a package solution that…

Frequently Asked Questions about Data Modeling, Part One

Karen Lopez

by Karen Lopez @datachick I deemed last year The Year of Data.  Big Data, Data Analytics, Open Data, Data Breaches, etc. were topics of discussion everywhere, even outside the IT world.  Heck, data management even made it into the US State of the Union Address. I think all this added focus on data has given us a…

Size Doesn’t Matter. Or Does It? A Rant on Big Data Terms

Rant sign

By Karen Lopez @datachick Last week at Enterprise Data World, I gave a lightning talk (a strictly-enforced time-limited five minute presentation).  Since I can barely manage to fit meaningful presentations in one hour given how much I talk, I decided to go for a rant.  That may not come as a surprise to you.  If…

Outliers, Charts and Data Visualizations

Karen Lopez

by Karen Lopez @datachick I posted that Tweet last week while attending the NASA 2013 Fiscal Budget Briefing at NASA Headquarters. It did well, being retweeted 200+ times and had the prospect of reaching 1.9 million people. I say prospect because not everyone who follows someone reads all their tweets. But 1.9 million isn’t such a…

11 Things I Should Have Done in 2011

Karen Lopez

by Karen Lopez Rather than write about my accomplishments over the last year, I’m going to write about all the things I should have been working on, but didn’t. I have lots of excuses: not enough hours, not enough days or too many other things to take care of. These are the types of things…

Fly the Dang Plane

Karen Lopez

by Karen Lopez Last week I flew from Washington, DC to Toronto via Philadelphia. This was at the end of about 3 weeks of many flights, having done a DAMA speaking tour, a class and two SQLSaturdays. I’ve been known to Tweet my travel experiences along the way, but usually these are first world problems…

Myth 1 – Normalization: Friend or Foe The Slogan

by Karen Lopez This is the third post in a series on Normalization Myths.  You’ll want to read the prior posts first. Normalization Myths that Really Make Me Crazy – Introduction to a Rant Myth 1 – Normalization: Friend, Foe, or Frenemy The Survey In my survey of Twitter users on their feelings about normalization,…