Informed Schema Design for Column Store-based Database Services

被引：9

作者：

Bermbach, David ^{[1
]}

Mueller, Steffen ^{[2
]}

Eberhardt, Jacob ^{[1
]}

Tai, Stefan ^{[1
]}

机构：

[1] TU Berlin, Informat Syst Engn Res Grp, Berlin, Germany

[2] Karlsruhe Inst Technol, Inst Appl Informat, Karlsruhe, Germany

来源：

2015 IEEE 8TH INTERNATIONAL CONFERENCE ON SERVICE-ORIENTED COMPUTING AND APPLICATIONS (SOCA) | 2015年

关键词：

NoSQL Systems; Column Stores; Schema Design;

D O I：

10.1109/SOCA.2015.29

中图分类号：

TP301 [理论、方法];

学科分类号：

081202 ;

摘要：

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.

引用

页码：163 / 172

页数：10

共 50 条

[1] rePivot - Developing analysis services with column store database
Simha, Jay B.
Suresh, L.
Velur, Rajappa
[J]. 2009 SECOND INTERNATIONAL CONFERENCE ON EMERGING TRENDS IN ENGINEERING AND TECHNOLOGY (ICETET 2009), 2009, : 1049 - +
[2] A Study of Data Store-based Home Automation
Kafle, Kaushal
Moran, Kevin
Manandhar, Sunil
Nadkarni, Adwait
Poshyvanyk, Denys
[J]. PROCEEDINGS OF THE NINTH ACM CONFERENCE ON DATA AND APPLICATION SECURITY AND PRIVACY (CODASPY '19), 2019, : 73 - 84
[3] Design of automatic database schema generator based on XML schema
Lim, JongSeon
Joo, KyungSoo
Kim, KyungSoo
Choi, Munyoung
[J]. CIS: 2007 INTERNATIONAL CONFERENCE ON COMPUTATIONAL INTELLIGENCE AND SECURITY, PROCEEDINGS, 2007, : 1039 - +
[4] Research on store XML data in relational database based on XML schema
Yi-Wu, Xie
Chen-Yang, Wang
Zhi-Ying, Cao
Yan, Chen
[J]. 2007 IFIP INTERNATIONAL CONFERENCE ON NETWORK AND PARALLEL COMPUTING WORKSHOPS, PROCEEDINGS, 2007, : 1001 - +
[5] Design of Database Schema by Conversion of UML-based Register Schema
Park, Daewon
Yeo, Jimin
Lee, Seojeong
Park, Suhyun
[J]. 2014 INTERNATIONAL CONFERENCE ON INFORMATION SCIENCE AND APPLICATIONS (ICISA), 2014,
[6] The Transformation of Relational Database to Wide Column Store Database
Chen, Jeang-Kuo
Lee, Wei-Zhe
[J]. 2020 INTERNATIONAL SYMPOSIUM ON COMPUTER, CONSUMER AND CONTROL (IS3C 2020), 2021, : 384 - 386
[7] Comment: accuracy of store-based blood pressure monitors
Hoffman, G
Force, RW
[J]. ANNALS OF PHARMACOTHERAPY, 2001, 35 (12) : 1676 - 1676
[8] The relevance of shopper logistics for consumers of store-based retail formats
Teller, Christoph
Kotzab, Herbert
Grant, David B.
[J]. JOURNAL OF RETAILING AND CONSUMER SERVICES, 2012, 19 (01) : 59 - 66
[9] Imperative Polymorphism by Store-Based Types as Abstract Interpretations
Poulsen, Casper Bach
Mosses, Peter D.
Torrini, Paolo
[J]. PROCEEDINGS OF THE 2015 ACM SIGPLAN WORKSHOP ON PARTIAL EVALUATION AND PROGRAM MANIPULATION (PEPM'15), 2015, : 3 - 8
[10] CONCEPTUAL DATABASE SCHEMA DESIGN
PANGALOS, G
[J]. INFORMATION AGE, 1986, 8 (03): : 162 - 167

← 1 2 3 4 5 →