Data Blogs | Information From Enterprise Leaders

SQL Is More than Just Store and Retrieve

Michael Blaha

by Michael Blaha I often work with programmers to build applications. It never ceases to amaze me that many programmers look at SQL as a store and retrieve mechanism and see nothing more. Their approach is to write programming code for all their logic. It’s not just a matter of programmers being unable to write…

Are APIs going to push legacy technology into the 21st century?

Evaldo Photo

by Evaldo Horn de Oliveira If you’re like me, you attend numerous IT shows (in fact, I’m writing this while attending a show right now). Although many shows are worth more for the contacts than the content, some offer valuable insights, particularly those focused on trends and directions. Those shows are almost mandatory if you…

November 2014 Letter from the Editor

Letter from the Editor

As we round the corner well into the fourth quarter of 2014, past Halloween and into the holiday season, companies are talking strategy for 2015. DATAVERSITY is no exception. We are finalizing talks of what we are going to focus on next year and how we are going to improve the quality and quantity of…

10 Tips for Data Modeling in a Hybrid NoSQL/Relational World

Modern Data Warehouse Architecture Components

by Karen Lopez During my Big Challenges in Data Modeling; NoSQL webinar, Dan McCreary and I talked about how data modelers should approach NoSQL on development projects.  At the end, I shared these ten tips for working in a hybrid (NoSQL + relational) world.  You can listen to the webinar recording for more details about each.…

Do You Know Where Your Data Is Tonight?

Ian Rowlands x300 green

by Ian Rowlands A while ago I set up a Google alert to track data breaches. Thanks Google – it saves me a lot of trawling. When I started I was getting one, or at most two, hits a day. Now I’m getting three or four every day. Over just the past few days my…

Big Data Is Not the Death Knell of ETL

OFFICIAL IBM PHOTO FOR JAMES KOBIELUS

by James Kobielus Data is useless if it lacks structure or if there is no opportunity to add structure downstream so that it can be processed, analyzed, and delivered into real-world applications. Structure is the contextual matrix within which data’s value is realized. It refers to the formats, schemas, models, tags, ontologies, patterns, and other…

To SQL, or to NoSQL …: That is STILL the Database Question

Evaldo Photo

by Evaldo Horn de Oliveira All right, Hamlet database aficionados — we get it. You’re having a hard time deciding what path to take your company down in terms of choosing the right database infrastructure. You spend endless days and nights ruthlessly seeking the answer, and although it may not be as drama-filled a decision…

Please Index Foreign Keys!

Michael Blaha

by Michael Blaha In the database literature, the lore has been to first design a schema and then predict the query mix to decide on a tuning strategy. This approach can work, but it is risky and error prone. A small misjudgment of the query mix can lead to vastly inferior performance. For many applications…

Who is Collecting and Marketing Your Personal Data?

cathy-nolan300dv

by Cathy Nolan The Wall Street Journal conducted a study that found that the nation’s 50 top websites installed, on average, 64 pieces of tracking technology onto the computers of visitors, usually with no warning. A dozen sites each installed more than a hundred. Tracking isn’t new, but the technology is growing so powerful and…