Method and equipment for managing database in multi-tenant system

A multi-tenant and database technology, applied in the field of data processing, can solve problems such as difficult to synchronize data, waste, affect performance and concurrency, and achieve the effect of data storage space

Inactive Publication Date: 2014-12-03
IBM CORP
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] There are generally two common solutions: one is that each tenant copies a copy of the original data to the private space, and the data of each tenant is isolated from each other and does not affect each other. However, in the case of a large number of users, a large amount of database storage space is required, resulting in waste , and it is difficult to synchronize data between all tenants when the provider updates the data
The second solution is to use the application to isolate data between tenants, and to associate the updated data with the existing data through the application. On the one hand, the development and maintenance of this solution is very heavy and the scope of application Also affected, on the other hand, due to excessive data interaction between the database and the application affects the overall performance and concurrency

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and equipment for managing database in multi-tenant system
  • Method and equipment for managing database in multi-tenant system
  • Method and equipment for managing database in multi-tenant system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] Preferred embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although preferred embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0013] Those skilled in the art know that the present invention can be implemented as a system, method or computer program product. Therefore, the present disclosure can be specifically implemented in the following forms, namely: it can be complete hardware, it can also be complete software (including firmware, resident software, microcode, etc.), and it can also be a combination of hardware and software. Called a "circuit", "module" or "sy...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to data processing, and particularly discloses a method for managing database in a multi-tenant system. The method comprises the following steps of providing public data, wherein the public data is read-only for tenants; providing tenant data, wherein the tenant data is established based on the public data and is private for the tenants; providing a data structure for recording metadata information of the tenant data; responding to the operation of the tenants on the tenant data, recording the metadata information of the tenant data corresponding to the operation in the data structure, wherein the operation at least comprises one of update or delete. According to the method provided by the invention, on the premise that database performance and concurrency are not influenced, less data storage space is utilized for realizing support for multiple tenants.

Description

technical field [0001] The present invention relates to data processing, and more precisely, the present invention relates to a method and device for managing databases in a multi-tenant system. Background technique [0002] In a multi-tenant system, especially a multi-tenant-based software-as-a-service (SaaS) system, the multi-tenant provider will publish or periodically update some public information for all tenants to use. Tenants may modify or delete these data or add new data according to their own conditions to meet their own needs. How to efficiently save and display these data in the database system, and how to process these data is a key issue. [0003] There are generally two common solutions: one is that each tenant copies a copy of the original data to the private space, and the data of each tenant is isolated from each other and does not affect each other. However, in the case of a large number of users, a large amount of database storage space is required, res...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/27G06F16/2358
Inventor 王启荣窦志彤王宁李蕾
Owner IBM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap