Call For Papers
Contact Us

  Column Database - An Acute Choice for Data Warehouses  
  Authors : Mekhala
  Cite as:


The use of Computer-based systems is increasing day by day and in due to many numbers and so critical demands we require making such complex business decisions so that we can bring many progressive changes in this field. To obtain this victoriously this data analysis and business reporting systems require additional resources for progress. Therefore, we need better, speeder and solely effective substitutes to correct and improve these issues. Former few years, the Column-oriented database systems are developing very quickly in demand and it is in progress also. We have found by peer-reviewing that unlike a row-oriented database there is another database in terms of technology which is much better and faster for data warehousing. In this paper, we are providing a review of many papers by saying that a column-oriented database is faster for data warehousing because the magnetically spinning platters use to read or write heads such move around to find the data and the drive performs the fewer heads have to move. Consequently, the time is lessened and the data can be delivered faster.


Published In : IJCSN Journal Volume 9, Issue 2

Date of Publication : April 2020

Pages : 28-31

Figures :01

Tables : --


Mekhala : obtained M.Tech and B.Tech., in Computer Science from Uttarakhand Technical University. Her research areas include process mining and database. She has published research papers and review paper in international journals.


Database, DBMS, Warehousing, Column-oriented system

In this paper, we can conclude that in DBMS a columnoriented store needs fewer improvements as compared to another database in terms of warehousing. This improvement in database leads to expansion of large databases and need very less performance-based elaborations. Because of this, we can also conclude that data warehousing is predominantly read-oriented.


[1] L. Nirmal, "International Journal of Advancements in Research & Technology", Volume 2 Issue4, April- 2013. [2] Mohsen Darabian, Abolfaz "International Journal of Automation and Power Engineering (IJAPE)", Volume 2 Issue 5, July 2013. [3] Vaibhav Donde, M. A. Pailan A. Hiskens, "Simulation and Optimization in an AGC System after Deregulation" IEEE Transactions on Power Systems, Vol. 16, No. 3, ISSN: 0885-8950, August 2001, 481- 489. [4] S. Khosla, H. Boral, and P. Valduriez, "A query processing strategy for the decomposed storage model" 636-643, 1987. [5] D. J. Abadi,s S. R. Madden "Integrating Compression and Execution in Column-Oriented Database Systems" SIGMOD, 671-682, 2006. [6] A. Ailamaki, D. J. DeWitt, M. D. Hill, and M. Skounakis, "Weaving relations for cache performance" In VLDB, 169-180, 2001. [7] Zach Pratt "A Review of Column-oriented Datastores", attackofzach.com [8] S.G. Yaman "Introduction to Column- Oriented Database Systems", cs.helsinki.fi