A multi-tenant data management method and its application in intelligent transportation

A multi-tenant data management method and its application in intelligent transportation

North China University of Technology Wang Jinquan

The main work and research results of this paper are as follows: 1. This paper analyzes the mainstream multi-tenant data storage and extension mechanism, and puts forward a hierarchical model of multi tenant data management, which masks the implementation of the underlying MULTI-TENANT data management system. 2. The characteristics of common table storage data are analyzed, and the method of single general table storage is improved, In this paper, we propose to replace a single universal table with a number of common tables with different number of columns, and allocate the tenant's data to the corresponding common table according to the pattern requirement of tenant data, which improves the efficiency of storage space, reduces the existence of NULL value and the influence on data query. 3. This paper analyzes the migration problem arising from the change of tenant data pattern, and proposes a storage mode combining multiple universal table and key value pair to solve tenant data migration problem. 4. Designed and implemented a traffic-aware data platform for Multi-Tenant data Management application, analyzed the overall frame and function structure of the platform, described the realization of writing and querying function, and finally verified the data model has high storage density and good query performance.

A multi-tenant data management method and its application in intelligent transportation