A New Table Structure based on Universal Table Layout Schema-Mapping Technique
Linfeng Yin, Xiaocong Zhou, Xinming Wang
Available Online April 2019.
- https://doi.org/10.2991/icmeit-19.2019.86How to use a DOI?
- SaaS System, Universal Table Layout, valid index, database performance.
- 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.
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 -