A New Table Structure based on Universal Table Layout Schema-Mapping Technique

DOI

10.2991/icmeit-19.2019.86How to use a DOI?

Keywords

SaaS System, Universal Table Layout, valid index, database performance.

Abstract

In SaaS(Software-as-a-Service) systems, the database is typically implemented using the Universal Table Layout schema-mapping technique, in which all tenant data is mapped to a table, thus valid indexes cannot be created directly in the table. To enable to create valid indexes directly in the table, this paper proposes a new table structure for better database performance. In this paper, the experiments are designed to verify the conclusions of this paper. The experimental results show that the table structure of this paper can obtain better database performance.

Copyright

© 2019, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Linfeng Yin
AU  - Xiaocong Zhou
AU  - Xinming Wang
PY  - 2019/04
DA  - 2019/04
TI  - A New Table Structure based on Universal Table Layout Schema-Mapping Technique
BT  - Proceedings of the 3rd International Conference on Mechatronics Engineering and Information Technology (ICMEIT 2019)
PB  - Atlantis Press
SP  - 542
EP  - 549
SN  - 2352-538X
UR  - https://doi.org/10.2991/icmeit-19.2019.86
DO  - 10.2991/icmeit-19.2019.86
ID  - Yin2019/04
ER  -