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 条

[11] CONCEPTUAL DATABASE SCHEMA DESIGN
PANGALOS, G
[J]. INFORMATION AGE, 1986, 8 (03): : 162 - 167
[12] Internet or store? An ethnographic study of consumers' internet and store-based grocery shopping practices
Elms, Jonathan
de Kervenoael, Ronan
Hallsworth, Alan
[J]. JOURNAL OF RETAILING AND CONSUMER SERVICES, 2016, 32 : 234 - 243
[13] Covid management strategies for Reliance Retail store-based employees
Koyande, Rantakar
Rallapalli, Rajesh
[J]. SAFETY AND HEALTH AT WORK, 2022, 13 : S183 - S183
[14] An Efficient Content Store-Based Forwarding Scheme for Internet of Things
Dinh, Ngoc-Thanh
Kim, Younghan
[J]. SENSORS, 2021, 21 (22)
[15] A database schema design algorithm based on data relatability dependencies
Cavanaugh, CD
King, RS
[J]. TEXAS JOURNAL OF SCIENCE, 1999, 51 (01): : 81 - 104
[16] A Cluster Based Schema Design for Multi-tenant Database
Ni, Jiacai
Feng, Jianhua
[J]. WEB-AGE INFORMATION MANAGEMENT, WAIM 2014, 2014, 8485 : 397 - 401
[17] Store-based Demand Forecasting of a Company via Ensemble Learning
Tekin, Ahmet Tezcan
Sari, Cem
[J]. INTELLIGENT AND FUZZY SYSTEMS: DIGITAL ACCELERATION AND THE NEW NORMAL, INFUS 2022, VOL 2, 2022, 505 : 14 - 23
[18] Database schema design for a web services supply chain manager: Requirements and proposed infrastructure
Goul, M
Corral, K
Demirkan, H
[J]. INFORMATION SYSTEMS FRONTIERS, 2005, 7 (03) : 257 - 271
[19] Database Schema Design for a Web Services Supply Chain Manager: Requirements and Proposed Infrastructure
Michael Goul
Karen Corral
Haluk Demirkan
[J]. Information Systems Frontiers, 2005, 7 : 257 - 271
[20] DATABASE SCHEMA DESIGN IN THE RELATIONAL MODEL
WONG, SKM
TSOU, MYL
JING, XH
[J]. INFOR, 1985, 23 (01) : 3 - 19

← 1 2 3 4 5 →