THE MATHEMATICAL ANALYSIS OF COLUMN ORIENTED DATABASE

There are two obvious ways to map a two-dimension relational database table onto a one-dimensional storage interface: store the table row-by-row, or store the table column-by-column. Historically, database system implementations and research have focused on the row-by row data layout, since it performs best on the most common application for database systems: business transactional data processing. However, there are a set of emerging applications for database systems for which the row-by-row layout performs poorly. These applications are more analytical in nature, whose goal is to read through the data to gain new insight and use it to drive decision making and planning. In this paper, we study about the facts responsible for making Column Oriented database when traditional Row-oriented databases are already present, analysis of generation of Column Oriented databases, etc. Finally It will be conclude by giving a probabilistic analysis of Column Oriented database. Keywords-Data warehouses, Database systems, Databases, Performance analysis