Data processing system and processing method in cloud computing multi-tenant architecture

Abstract

The invention discloses a data processing system in cloud computing multi-tenant architecture. The data processing system in the cloud computing multi-tenant architecture comprises a data bank used to store cloud computing multi-tenant data, and is characterized in that a database table used to store the cloud computing multi-tenant data and a predistribution field configuration table used to configure fields of the database table are set inside the data bank. The database table comprises a tenant identification (ID) field, a plurality of reserved extension fields and an extensive makeup language (XML) field, wherein the tenant ID field is used to identify tenant data, the reserved extension fields are used to store extended data of tenant users, and the XML field is used to store data of users when the a reserved field can not meet continuously extended field requirements of the users. The predistribution field configuration table is matched with field names in the database table and used to record field information, and the field information comprises tenant ID, a table name, an adding position, a field type and a field name. In the process of data process, the predistribution field configuration table constructed in the step 2 processes data in the database table constructed in the step 1. When the data processing system carries out query operation, end efficiency of query is close to efficiency of the reserved field.

Description

technical field [0001] The invention belongs to the technical field of data processing of cloud computing, and in particular relates to a data processing system and processing method in a cloud computing multi-tenant architecture. Background technique [0002] With the increasing popularity of cloud computing, the research on cloud computing related applications is also deepening. Multi-tenant technology is an important reason why cloud computing can make costs lower. It makes it possible for multiple users to share the same system or program components. [0003] In a multi-tenant architecture, the data of different users needs to be differentiated. In order to cooperate with the scalability of cloud computing, it is also necessary to provide a flexible expansion method. Fundamentally, it is to provide a flexible expansion method for the fields of the database table. This is more prominent in SaaS, that is, the expansion of table fields for multi-tenancy. [0004] So far,...

AI Technical Summary

Problems solved by technology

[0011] The purpose of the present invention is to provide a data processing system in a cloud computing multi-tenant architecture, which solves the problem that data storage, extraction, query and other operations cannot be provided in terms of space and time complexity when performing data processing in a cloud computing multi-tenant architecture in the prior art. The balance between efficiency and space leads to problems such as waste of space or unsatisfactory access speed

Images