Database Performance Innovations

by Kevin S
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.

One thought on “Database Performance Innovations

  • October 28, 2012 at 1:53 am
    Permalink

    I think it is good to read about how to improve database performance innovations so that when we deal with databases at large scale we know how to make sure that we are making the system as efficient as possible. It is equally important to get insight on how to develop databases and also how to maintain and improve them. It certainly tights in with the article that I read this week about the importance of keeping up with new inventions and learning how to work with big data since its something that will be generating millions of new jobs in the upcoming years and need to get prepared to take over them.

Comments are closed.