Proceedings of the 3rd International Conference on Mechatronics Engineering and Information Technology (ICMEIT 2019)

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

Authors
Linfeng Yin, Xiaocong Zhou, Xinming Wang
Corresponding Author
Linfeng Yin
Available Online April 2019.
DOI
https://doi.org/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.
Open Access
This is an open access article distributed under the CC BY-NC license.

Download article (PDF)

Proceedings
Part of series
Advances in Computer Science Research
Publication Date
April 2019
ISBN
978-94-6252-708-9
ISSN
2352-538X
DOI
https://doi.org/10.2991/icmeit-19.2019.86How to use a DOI?
Open Access
This is an open access article distributed under the CC BY-NC license.

Cite this article

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
PB  - Atlantis Press
SP  - 542
EP  - 549
SN  - 2352-538X
UR  - https://doi.org/10.2991/icmeit-19.2019.86
DO  - https://doi.org/10.2991/icmeit-19.2019.86
ID  - Yin2019/04
ER  -