Informed Schema Design for Column Store-Based Database Services
Authors:
- David BermbachDBDavid Bermbach
- Steffen MullerSMSteffen Muller
- Jacob EberhardtJEJacob Eberhardt
- Stefan TaiSTStefan Tai
- 1 October 2015
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 163-172
Abstract
While database schema options in relational database management systems are few and have been studied for decades, little effort has so far been devoted to NoSQL column stores. Today, schema design for column stores is still based on the gut feeling of the application developer instead of being approached systematically. This is even more critical as "good" schemas in column stores do not only depend on the data model of the application but also on the queries on that data: Poor schema design will either lead to a situation where not all queries can be answered or where some queries will show really poor performance. In this paper, we propose a systematic and informed approach to database schema design in NoSQL column stores by means of automated schema generation and application-specific schema ranking.Keywords
This publication has 18 references indexed in Scilit:
- Automated schema design for NoSQL databases2014
- Benchmarking Eventual Consistency: Lessons Learned from Long-Term Experimental Studies2014
- Denormalizing data into schema-free databases2013
- On the necessity of model checking NoSQL database schemas when building SaaS applications2013
- Automatic NoSQL Schema Development: A Case Study2013
- Consistency Tradeoffs in Modern Distributed Database System Design: CAP is Only Part of the StoryComputer, 2012
- A Survey of Large Scale Data Management Approaches in Cloud EnvironmentsIEEE Communications Surveys & Tutorials, 2011
- Conflict-Free Replicated Data Types2011
- CassandraACM SIGOPS Operating Systems Review, 2010
- Service-oriented data denormalization for scalable web applications2008