A Comparative Study of Database Systems

Data stored in databases keep growing as a result of businesses requirements for more information. A big portion of the cost of keeping large amounts of data is in the cost of disk systems, and the resources utilized in managing that data (9). This paper throws a light on basic difference between column-oriented databases and traditional row- oriented databases and describes how Column oriented DBMS's are better than traditional row-oriented DBMSs. As applications require higher storage and easier availability of data, the demands are satisfied by better and faster techniques (1). Column-oriented database systems (Column-stores) have attracted a lot of attention in the past few years. In this paper, we discuss how Column oriented Database performs better than traditional row-oriented DBMSs.