Discussion

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…

Are You Making this Costly Database Mistake?

Thomas_Head_Geekx350

by Thomas LaRock Imagine the beginning of a typical office worker’s day: After getting a cup of coffee and logging in on their computer, they’ll most likely open up whatever applications they use throughout the work day—email, chat, internal CRM systems and maybe the company intranet. This time, however, one or more of the applications…

Enterprise Data World: What’s Your Data Story?

Enterprise Data World

I’m confident that just about everyone who works in data management today has a story to tell. The field has been so active in recent years, and the application areas so innovative and diverse, that every data management practitioner has acquired unique and interesting experiences. My request to all of you is to consider sharing…

October 2014 DATAVERSITY Letter from the Editor

Letter from the Editor

If you’re in the northern hemisphere, happy fall! If in the southern, happy spring! Either way, the climate is changing, but things remain hopping here at DATAVERSITY. Two big things to bring to your immediate attention: Data Governance Winter 2014 Conference: we have launched the agenda and opened registration for this event happening December 8-12,…

Myth 2 – Meaningless Normalization

?NF

by Karen Lopez Does this happen to you: someone gives you a table structure and asks you to say what normal form it’s in?  You look at it, see something that looks like repeating groups and some columns that look like they aren’t supposed to be mixed up with all those other columns (lets say…

Business Users Don’t Know What They Want When It Comes to BI

Saar

by Saar Bitner It’s a typical starting point: Business users give IT a set of data, questions and requirements at the beginning of a BI project. But as they investigate and explore data, users return with a request for more data, deeper questions, and new requirements. Frustrating? Maybe. But the fact that business users do…

Machine Learning and Big Data: What you Need to Know

Gil

by Gil Allouche Needless to say, big data is hot in tech right now. And it has a right to be. Understanding and acting on large quantities of data lets companies make business decisions more accurately and cheaply than ever. Consumers leave digital footprints through every view, click, and save. With big data, consumer preferences…

Specify the Data Model and the Database Design

Michael Blaha

by Michael Blaha Many organizations today outsource software development. You, the customer, specify your requirements and the vendor is supposed to build software that meets your requirements. But requirements are not sufficient as a specification. With this common scenario, you have no control over the quality of the software being built. Furthermore, you have no…

Database Modernization: Treat It Like an Evolution, Not a Revolution

Evaldo Photo

by Evaldo Horn De Oliveira Most of today’s industries require the ability to store data while simultaneously allowing end-user access. However, the modern concept of a database hasn’t always been the main technology used to store data. A wide selection of alternative methods has been used over the years to store and retrieve data, such…