On Data Management Optimization Strategies in Software as Service Systems
Linfeng Yin, Xiaocong Zhou · 2019
Two data management optimization strategies in Software as Service (SaaS) Systems are presented in this paper, adding index fields to the table structure of the Universal Table Layout schema-mapping technique for maintaining the logical table indexes, and dividing data into different data storage infrastructure when a tenant's access is unaffordable. A method based on the foreign key of the logical table is proposed to partition data into different data storage infrastructures, which can partition joining operation tables into one data storage infrastructure as much as possible. Experimental results show that the table structure with logical index fields and the above data partition method effectively improve the performance of data management in SaaS systems.