Title :
Query based performance analysis of row and column storage data warehouse
Author :
Kamal, Archana ; Gupta, Suresh C.
Author_Institution :
Dept. of Electr. Eng., Indian Inst. of Technol. (BHU), Varanasi, India
Abstract :
Row based relational database management systems (R-RDBMS) are the most common choice for data warehouse implementations. Row based storage is useful in online transaction processing (OLTP) to insert and update data while column oriented RDBMS (C-RDBMS) in online analytical processing (OLAP) to access data from data warehouse. This paper analyses the best suited mode of storage (row or column based storage) for different type of data manipulation language (DML) queries in data warehouse. It also evaluates and compares the performance of row and column oriented data structures based on elapsed time, CPU, I/O and operator costs; for different types of DML queries. A data warehouse has been designed for simulation purpose using Red Gate Data Generator tool along with Microsoft SQL Server 2012.
Keywords :
data mining; data structures; data warehouses; database languages; query processing; relational databases; storage management; transaction processing; C-RDBMS; CPU; DML queries; Microsoft SQL Server 2012; OLAP; OLTP; R-RDBMS; access data; column oriented RDBMS; column oriented data structures; column storage; data column oriented data; data manipulation language queries; data warehouse; online analytical processing; online transaction processing; query-based performance analysis; red gate data generator tool; row-based-relational database management system; row-based-storage; Data models; Data warehouses; Generators; Histograms; Indexes; Servers; DML queries; Microsoft SQL Server 2012; Row and columnar storage data warehouse; Star Schema Benchmark (SSB);
Conference_Titel :
Industrial and Information Systems (ICIIS), 2014 9th International Conference on
Conference_Location :
Gwalior
Print_ISBN :
978-1-4799-6499-4
DOI :
10.1109/ICIINFS.2014.7036537
