Database system performance is directly related to the efficiency of the system at storing data on primary storage (for example, disk) and moving it into CPU registers for processing. For this reason, there is a long history in the database community of research exploring physical storage alternatives, including sophisticated indexing, materialized views, and vertical and horizontal partitioning.
In recent years, there has been renewed interest in so-called column-oriented systems, sometimes also called column-stores. Column-store systems completely vertically partition a database into a collection of individual columns that are stored separately. By storing each column separately on disk, these column-based systems enable queries to readjust the attributes they need, rather than having to read entire rows from disk and discard unneeded attributes once they are in memory.
The Design and Implementation of Modern Column-Oriented Database Systems discusses modern column-stores, their architecture and evolution as well the benefits they can bring in data analytics. There is a specific focus on three influential research prototypes, MonetDB, MonetDB/X100, and C-Store. These systems have formed the basis for several well-known commercial column-store implementations. Their similarities and differences are described and they are discussed in terms of their specific architectural features for compression, late materialization, join processing, vectorization and adaptive indexing (database cracking).
This is an excellent reference on the topic for database researchers and practitioners.
- ISBN:
- 9781601987549
- 9781601987549
-
Category:
- Database design & theory
- Format:
- Paperback
- Publication Date:
-
04-12-2013
- Publisher:
- now publishers Inc
- Country of origin:
- United States
- Pages:
- 102
- Dimensions (mm):
- 234x156x5mm
- Weight:
- 0.16kg
This title is in stock with our Australian supplier and should arrive at our Sydney warehouse within 1-2 weeks of you placing an order.
Once received into our warehouse we will despatch it to you with a Shipping Notification which includes online tracking.
Please check the estimated delivery times below for your region, for after your order is despatched from our warehouse:
ACT Metro 2 working days
NSW Metro 2 working days
NSW Rural 2-3 working days
NSW Remote 2-5 working days
NT Metro 3-6 working days
NT Remote 4-10 working days
QLD Metro 2-4 working days
QLD Rural 2-5 working days
QLD Remote 2-7 working days
SA Metro 2-5 working days
SA Rural 3-6 working days
SA Remote 3-7 working days
TAS Metro 3-6 working days
TAS Rural 3-6 working days
VIC Metro 2-3 working days
VIC Rural 2-4 working days
VIC Remote 2-5 working days
WA Metro 3-6 working days
WA Rural 4-8 working days
WA Remote 4-12 working days
Share This Book: