Database Performance Innovations{1}

This week I read the journal article called “Revolutionize Database Performance”. This article focuses on 7 innovations that the author feels will revolutionize data warehousing. These 7 innovations are important because RDBMS platforms, which had worked well in the past, have struggled since they were not designed to query against the large amount of data that businesses have today. The seven innovations he discusses include: column store architecture, aggressive compression, multiple sort orders, automatic database design, recovery by query, concurrent data loading and querying, and standards-based appliances. According the author, adopting new approaches to RDBMS design will allow detailed searches to be processed 50 or 100 times faster and at a fraction of the cost.

I chose this article since our book didn’t give very much detail on the performance aspects of databases. Reading about all of the 7 different DBMS architectures that are being deployed was very informative. He threw in a little bit of history as well, since it is important to understand where we have come from and where we are going.

It is interesting to see the real business solution examples given in the article. This article is yet another reminder that every business is unique and must have a database designed for their specific needs. And keeping the databases running as quickly as possible is definitely crucial for some businesses and the decisions they make.

Zdonik, S. (2008). Revolutionize database performance. DM Review, 18(1), 20-19.