Columnar Databases{Comments Off on Columnar Databases}


by Tuyen H

http://t2.gstatic.com/images?q=tbn:ANd9GcSo0jamE 67QBxzCzgkcvWlK4H9LyVJCaU1kpeslA5cqghbFhkwZrg

Recently, the Oracle introduced its new product based on NoSQL technology. When we talk about NoSQL we think about Columnar Database. In the article “The Value Proposition for Columnar Databases: Columnar databases are an essential component of enterprise infrastructure for the storage of data needing specific workloads,” William McKnight writes about the Columnar Databases and their relationship with SQL and NoSQL movements. Although they are heaving with the NoSQL movement, they belong on both SQL and NoSQL movements depending on what perspective. Under SQL perspective, some columnar databases have been around for two decades and used SQL as the main language. On the other hand, NoSQL is defined as having a different data layer from the relational “all columns successively” row-based layout, so columnar databases are NoSQL. In this article the author also compares the columnar databases with the row-based stores. The major difference between them is all the columns of a table are not stored successively in storage. In conclusion, the columnar databases provide many benefits such as improving performance of the database.

This article relates to our class topic because it talks about Database structure. It also talks about the new NoSQL technology. I work on the Database field more than five years, and I do not have any opportunity to work on the columnar databases. After reading this article, I think that the columnar database and NoSQL are future of database industry because of their benefits.

In my opinion, it does not matter that columnar databases are SQL or NoSQL; their benefits are valuables. Especially, when we apply databases into the web environment, the performance of the database directly affects to the user experiences. Moreover, columnar databases support the large amounts of data, large scans and I/O bound queries.

William McKnight.  (2011). The Value Proposition for Columnar Databases :Columnar databases are an essential component of enterprise infrastructure for the storage of data needing specific workloads. Information Management, 21(6), 21.  Retrieved November 8, 2011, from ProQuest Computing. (Document ID: 2499854021).
https://libris.mtsac.edu/login?url=http://proquest.umi.com/pqdweb?did=2499854021&sid=3&Fmt=3&clientId=132&RQT=309&VName=PQD