Automated schema design for NoSQL databases
Open Access
- 18 June 2014
- conference paper
- Published by Association for Computing Machinery (ACM)
- p. 41-45
Abstract
Selecting appropriate indices and materialized views is critical for high performance in relational databases. By example, we show that the problem of schema optimization is also highly relevant for NoSQL databases. We explore the problem of schema design in NoSQL databases with a goal of optimizing query performance while minimizing storage overhead. Our suggested approach uses the cost of executing a given workload for a given schema to guide the mapping from the application data model to a physical schema. We propose a cost-driven approach for optimization and discuss its usefulness as part of an automated schema design tool.Keywords
This publication has 9 references indexed in Scilit:
- On the necessity of model checking NoSQL database schemas when building SaaS applications2013
- An automatic physical design tool for clustered column-stores2013
- Static and dynamic semantics of NoSQL languages2013
- The vertica analytic databaseProceedings of the VLDB Endowment, 2012
- SimpleSQL: A Relational Layer for SimpleDB2012
- JaqlProceedings of the VLDB Endowment, 2011
- Scalable SQL and NoSQL data storesACM SIGMOD Record, 2011
- CassandraACM SIGOPS Operating Systems Review, 2010
- The GMAP: a versatile tool for physical data independenceThe VLDB Journal, 1996