tailieunhanh - Column oriented DBMS an approach

This data base differs from the traditional databases with regards to performance, storage requirements and ease of modification of the schema. This new technology for high performance was introduced to data warehousing by Sybase. Sybase IQ is leading the industry over other rivals , one such emerging rival is Vertica . | ISSN:2249-5789 Anuradha Bhatia et al, International Journal of Computer Science & Communication Networks,Vol 1(2), 111-116 Column Oriented DBMS an Approach Anuradha Bhatia 1. Shefali Patil 2 Lecturer ,VES Polytecnic. anubhatia31@ 2. Lecturer , Vidyalankar COE, Abstract A column oriented DBMS is a database management system that stores its content by column rather than the row. This has advantages for data warehouses and library catalogues where aggregates are computed over large number of similar data items. Column stores are well suited for OLAP like workloads warehouses which typically involve a smaller number of highly complex queries over all data mostly terabytes. Column data is of uniform type, there are some opportunities for storage size optimizations available in column oriented data that are not available in row oriented data. This data base differs from the traditional databases with regards to performance, storage requirements and ease of modification of the schema. This new technology for high performance was introduced to data warehousing by Sybase. Sybase IQ is leading the industry over other rivals , one such emerging rival is Vertica . Sybase IQ uses SMP and grids for scale-up and scale-out and independent storage and compute scaling where as Vertica uses MPP grids for scale-out. Through this paper we compare the two technologies with advantages , disadvantages and its application in the teradata handling INTRODUCTION Columnar database column-based structure [1] The newer column structure has gained interest as the indexing and data transfer problems associated with record structures have proved problematic for analytics applications. The column-based DBMS stores all of the values from one column of a table in a contiguous data set. This allows the reading and/or writing of parts of records. It conserves I/O bandwidth by transferring only the values that may be used in the query. Since most data

• Cơ sở dữ liệu
• International Journal of Computer Science and Communication Networks
• Column oriented DBMS an approach
• Column oriented DBMS
• Data warehousing by Sybase
• Emerging rival is Vertica