Indices

Hasso Plattner
Additional contact information
Hasso Plattner: Hasso Plattner Institute

Chapter Chapter 18 in A Course in In-Memory Data Management, 2014, pp 125-133 from Springer

Abstract: Abstract In row-oriented database systems indices are used to speed up access on columns that are often used for data selection (e.g. primary key attributes). Without indices a full table scan has to be performed when the data is stored row-wise. In column-oriented databases systems a data select operation on any attribute only requires a column scan. This is performed much faster than a complete table scan. Consequently, in many use cases additional indices are not required. The following chapter describes the usage of additional index structures in column-oriented tables, called inverted indices.

Keywords: Inverted Index; Additional Index Structures; Full Table Scan; Column-oriented Database Systems; City Column (search for similar items in EconPapers)
Date: 2014
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-3-642-55270-0_18

Ordering information: This item can be ordered from
http://www.springer.com/9783642552700

DOI: 10.1007/978-3-642-55270-0_18

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().