|
Trudy SPIIRAN, 2013, Issue 30, Pages 204–222
(Mi trspy682)
|
|
|
|
This article is cited in 2 scientific papers (total in 2 papers)
Physical design approaches for column-stores
G. A. Chernishev Saint Petersburg State University
Abstract:
In this paper we survey column-store database technology. We describe column-store database management system and point out the distinctions from the classical row-store DBMS. We present strong and weak points of the column-stores, the reasons of their appearance and success. We survey a variety of technical solutions, which provide these systems with the advantage. We also describe workloads which benefit this approach the most and thus constitute the area of application of commercial column-store DBMS systems. Then, we present a brief introduction into the problem of DBMS physical design. We analyze the perspectives of various classical approaches (allocation, partitioning etc), as well as column-store specific ones (column sort orders and join index application).
Keywords:
databases, physical database design, database tuning, column-stores, vertical partitioning, horizontal partitioning, allocation.
Received: 18.09.2013
Citation:
G. A. Chernishev, “Physical design approaches for column-stores”, Tr. SPIIRAN, 30 (2013), 204–222
Linking options:
https://www.mathnet.ru/eng/trspy682 https://www.mathnet.ru/eng/trspy/v30/p204
|
Statistics & downloads: |
Abstract page: | 507 | Full-text PDF : | 221 | References: | 54 | First page: | 1 |
|