Browsing articles tagged with " data quality"

Your #1 Job….

Jan 6, 2015   //   by Karen Lopez   //   Blog, Data Governance, Data Modeling, Database Design, DLBlog  //  4 Comments

Tim Berners-Le Quote on CEO connect data

I hear frequently, especially from the DBA groups, that our number one job as a data professional is performance.  That typically includes making sure database queries run fast, that systems have expected uptimes, and that developers/DBAs can do their jobs as fast as possible without slowing down to consider whether or not they are doing the right thing for the data. In fact, I’ve been told many times that data quality is Job NULL, meaning that we shouldn’t care as much about data quality as we do about performance.  The crazy things I’ve read: query running slow? Delete some rows and see if anyone notices.  Assign numeric datatypes to number-like columns so they will be smaller (and missing leading zeros).  Make columns small, even if it means losing data. Shove data in a column with comma delimiters so that you don’t have to change the database.  Re-use a column for something it was never intended for.

Developers and DBAs start thinking this way, for the most part, because they are measured and rewarded based on all kinds of factors other than data quality.  And yet management expects systems to support exactly what Tim Berners-Lee says in this quote.  Sure, making systems purr is one part of allowing data to be connected across sources.  But misleading data, mis-understoood data and plain old bad data means that CEOs can’t run a company effectively. 

Any enterprise CEO really ought to be able to ask a question that involves connecting data across the organization, be able to run a company effectively, and especially to be able to respond to unexpected events.

Most organizations are missing this ability to connect all the data together.

There are all kinds of presentations and blog posts about how to make systems run fast.  There are so few about how to love your data so that the CEO can rely on it. The first person that needs to fix this mismatch of incentives and actions is the CEO.  She needs to ensure that IT professionals are properly evaluated and motivated to produce both fast data and correct data.  And to stop providing incentives for IT professionals to work against data quality.

DBAs and Developers want to do the right thing. It’s just that we are paying them to do the wrong things over the right things.  

It’s Just a Hardware Problem…

Jul 16, 2014   //   by Karen Lopez   //   Blog, Data, Fun, Snark  //  No Comments

image

Data Will Confess to Anything….

Jan 10, 2014   //   by Karen Lopez   //   Blog, Data, Data Governance, Fun, Snark  //  No Comments

Star Trek Data being interrogated

via Thomas LaRock ( blog | @sqlrockstar )

Remember this the next time you see some statistics.  Or a report.  Or anything that appears on Wikipedia.

Stuff Their Databases Say

Jul 7, 2013   //   by Karen Lopez   //   Blog, Data, Data Stewardship, Snark, Travel  //  1 Comment

If you’ve been to one of my “Stuff Your Database Says” sessions, you know I collect photos of how my data is messed up by information systems.

Many of my frequent flyer friends can confirm that integration between airlines, even alliance partners, is plagued with problems.

Here’s today’s boarding pass. I call this my “secret international alias”.

20130707-162131.jpg

Einstein on Data

Sep 20, 2012   //   by Karen Lopez   //   Blog, Data, Fun, Snark  //  2 Comments

Einstein on Data

…can you read the formulae?

Podcast: NoSQL and PeopleTalkingTech

Sep 17, 2012   //   by Karen Lopez   //   Blog, Data, Database, NoSQL, Professional Development, Speaking  //  No Comments

I recently talked with my good friend Denny Cherry (@mrdenny | blog) about my experience at the NoSQL Now! conference and working with NoSQL technologies.  Denny’s new podcast series is called People Talking Tech and he has other interesting topics and people coming up soon.

http://peopletalkingtech.com/eposide-001-karen-lopez

My comments focused on how at the NoSQL professionals understand that it means "Not Only SQL" and can’t mean "No SQL" and have much of a future.  Using the right tool for the right job.  Cost, benefit, risk and all.

One of the things we talked about on the closing panel is "how do you find somebody that is a good architect who can tell you which types of technologies you can use for which use cases…"

Even though many people talk about NoSQL needing no architecture, we still need people to help choose when and what NoSQL technologies to use.  Seems to me that having experience working hands-on with relational and NoSQL technologies is going to be hugely valuable in the next couple of years.  If you have relational experience, now is the time to start learning about non-relational ones.

Securing SQL Server, Second Edition: Protecting Your Database from AttackersBy the way, we talked a bit about database security.  Denny’s new edition of his book Securing SQL Server, Second Edition: Protecting Your Database from Attackers has recently been released.  Check it out.

Pages:12»

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to blog.infoadvisors.com by Email


Facebook Flickr foursquare Google+ LinkedIn Skype StumbleUpon Twitter YouTube

Categories

Archive

UA-356944-2