58312305

Seminar: Columnar Databases
Seminar: Columnar Databases
Seminar: Columnar Databases
58312305
3
Software Systems
Advanced studies
A column-oriented DBMS is a database management system (DBMS) that stores data tables as sections of columns of data rather than as rows of data, like most relational DBMSs. This has advantages for data warehouses, customer relationship management (CRM) systems, and library card catalogs, and other ad-hoc inquiry systems[1] where aggregates are computed over large numbers of similar data items. It is possible to achieve some of the benefits of column-oriented and row-oriented organization with any DBMSs. By denoting one as column-oriented, we are referring to both the ease of expression of a column-oriented structure and the focus on optimizations for column-oriented workloads. This approach is in contrast to row-oriented or row store databases and with correlation databases, which use a value-based storage structure. This seminar examines different column-oriented database systems and what kind of benefits column-oriented databases provide for a different kind of workloads.

Upcoming separate exams

No exams.

Course pages