Flexs - A Logical Model for Physical Data Layout

Research output: Contribution to book/Conference proceedings/Anthology/ReportConference contributionContributedpeer-review

Contributors

Abstract

Driven by novel application domains and hardware trends database research and development set off to many novel and specialized architectures. Particularly in the area of physical data layout, specialized solutions have shown exceptional performance for specific applications. This trend is great for research and development and for those in need of top-level performance first and foremost. For those with moderate performance needs, however, a universal but flexible database system has the benefit of lower TCO. Regarding physical data layout, the more general systems are fairly inflexible compared to the variety of physical data layouts available in specialized systems. Particularly, the macroscopic characteristics, i.e., how the data is grouped and clustered, are generally hard-coded and cannot be changed by configuration. We present Flexs, a declarative storage description language for the macroscopic characteristics of physical data layouts. Flexs allows describing physical data layouts ranging from the row and column store layouts to data layouts for irregular data such as vertical schema. Using Flexs, a storage engine can be configured to use a specific physical data layout. Flexs contributes to make specialized physical data layouts available to the broad majority of universal database systems.

Details

Original languageEnglish
Title of host publicationNew Trends in Database and Inf. Systems II
PublisherSpringer-Verlag
Pages85-95
Number of pages11
ISBN (electronic)978-3-319-10518-5
ISBN (print)978-3-319-10517-8
Publication statusPublished - 2015
Peer-reviewedYes

Publication series

SeriesAdvances in Intelligent Systems and Computing
Volume312
ISSN2194-5357

Conference

Title18th East European Conference on Advances in Databases and Information Systems and Associated Satellite Events, ADBIS 2014
Duration7 - 10 September 2014
CityOhrid
CountryMacedonia, The Former Yugoslav Republic of

External IDs

ORCID /0000-0001-8107-2775/work/199215565

Keywords

Research priority areas of TU Dresden

DFG Classification of Subject Areas according to Review Boards

Subject groups, research areas, subject areas according to Destatis