CACM logo

This Article

BLOG@CACM

My Top 10 Assertions About Data Warehouses

[article image]

Michael Stonebraker

August 26, 2010

Data warehouses, business intelligence, business analytics, and complex analytics are the subject of increasingly intense marketing wars, seemingly accelerated by Oracle’s recent introduction of the Exadata appliance. Here is my spin on the situation, organized as my top 10 assertions about this topic.

User Comments

 (3)

Forgive a noob question, but when "column oriented" data storage is discussed, is this referring to something like Microsoft SSAS, or is this something else entirely?

   — John Jablonski, August 31, 2010

Regarding assertion 5: I'm so happy that a prominent DB researcher is calling attention to this problem. The majority of DB software is still too hard to install, run, and maintain. Migration of data from one DB to another is often a painful process. Installation and configuration is almost always by hand-tuning over multiple hours, if not days. When are vendors or open source folks going to really pay attention to the user experience?

   — Ed Chi, September 1, 2010

Data Warehouse Intelligence is a term to describe a system used in an organization to collect data, most of which are transactional data, such as purchase records and etc., from one or more data sources, such as the database of a transactional system, into a central data location, the Data Warehouse, and later report those data, generally in an aggregated way, to business users in the organization. This system generally consists of an ETL tool, a Database, a Reporting tool and other facilitating tools, such as a Data Modeling tool.

A Data Warehouse (DW) is a database used for reporting. The data is offloaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the DW for reporting.

   — Anonymous, March 10, 2011
Post a comment...
Name: Anonymous

Signed and anonymous comments submitted to this site are moderated and will appear if they are relevant to the topic and not abusive. Your comment will appear with your username if you are signed into the site, and will be anonymous if you are not signed in. View our policy on comments

Tools For Readers

Bookmark and Share
Default Font Size Large Font Size X-Large Font Size Text Size

Related ACM Resources

Conferences:

Courses:

  • Project Cost Management - In this course you will review the basics of project cost management, and be introduced to estimating and budgeting. After completing this course, you will …
More About ACM Resources

In The Digital Library

About Communications | Join ACM External Link | Renew External Link | Subscribe External Link | Sign In | For Authors | For Advertisers External Link | Privacy | Site Map | Help | Contact Us | Mobile Site

Copyright © 2012 by the ACM. All rights reserved.

Back to Top