In-memory Column-Oriented Database Management System

From GM-RKB
Jump to navigation Jump to search

An In-memory Column-Oriented Database Management System is a Column-Oriented Database Management System that is an In-memory DBMS.

References

2013

  • http://en.wikipedia.org/wiki/Column-oriented_DBMS
    • 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. In comparison, most relational DBMSs store data in rows. 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.[2] This approach is in contrast to row-oriented or row store databases and with correlation databases, which use a value-based storage structure.

</references/>

  1. ↑ C-Store: A column-oriented DBMS, Stonebraker et al., Proceedings of the 31st VLDB Conference, Trondheim, Norway, 2005
  2. ↑ A decomposition storage model, Copeland, George P. and Khoshafian, Setrag N., SIGMOD '85, 1985.
Retrieved from "http://www.gabormelli.com/RKB/index.php?title=In-memory_Column-Oriented_Database_Management_System&oldid=745259"