Optimization of Database Management System

In recent business fields are developing very rapidly, so it needs of access and analyze data in effectively. In information technology systems are more intensive to answer the numerous and complex demands for taking critical decision. Data analyzing and reporting is plays an important role in business fields. Traditional way is using database management system. But there are many obstacles are made by using traditional way, therefore the faster, better, and efficient alternative way is to be found. The columnar database management system is used. This paper gives the brief explanation of columnar database and gives the implementation of column store and row-store. The result is obtained by the comparison of both type.