Multi-tenant database sharing method and multi-tenant database as-a-service system

A service system and database technology, applied in the field of multi-tenant shared databases, can solve the problems of resource hijacking, occupation of system resources, and insufficient guarantee of tenant performance requirements, and achieve the effect of guaranteeing performance requirements

Active Publication Date: 2014-01-29
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF3 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The existing shared database solution enables the databases of multiple tenants to coexist on the same database engine on the same server. Although it can improve resource utilization, the performance isolation of tenant databases cannot be guaranteed, and the request load of some tenants may occupy most of the system resources, causing resource hijacking
[0004] Therefore, in the existing multi-tenant database as a service DBaaS system, tenants interact with each other, and the performance requirements of tenants are not effectively guaranteed

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
  • Multi-tenant database sharing method and multi-tenant database as-a-service system
  • Multi-tenant database sharing method and multi-tenant database as-a-service system
  • Multi-tenant database sharing method and multi-tenant database as-a-service system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] In order to make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0051] In order to ensure the performance requirements of tenants in the multi-tenant database as a service DBaaS system, based on virtual machine technology, such as VMware, Xen, etc., physical server system resources (CPU time, memory capacity, and I / O bandwidth, etc.) can be allocated to each other in proportion. The non-interfering virtual machine realizes the logical database representation of each tenant through the relational model, maps the logical database operation to the physical database operation on the virtual machine, and can realize performance isolation betwee...

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 discloses a multi-tenant database as-a-service system. The multi-tenant database as-a-service system comprises an application layer module for receiving a client-side instruction, establishing and maintaining logical database information of tenants and sending a first instruction to a data management layer module, the data management layer module for establishing and maintaining mapping of the logical database information of an application layer to physical database instance information of an infrastructure layer according the first instruction and sending a second instruction to an infrastructure layer module, and the infrastructure layer module for establishing physical database instances of the infrastructure layer according to indication of the second instruction based on a virtual machine or performing data operation on the physical database instances according to the indication of the second instruction. The multi-tenant database as-a-service system can achieve performance isolation of the tenants and ensures the performance demands of the tenants. The invention further provides a multi-tenant database sharing method.

Description

technical field [0001] The present invention relates to the technical field of cloud computing, in particular to a multi-tenant shared database method and a multi-tenant Database as a Service DBaaS (Database as a Service) system. Background technique [0002] With the development of cloud computing technology, operating systems, middleware and applications in the traditional software layer stack have found their place in the cloud, and infrastructure as a service (IaaS), platform as a service (PaaS) and software as a service (Software as a Service) have emerged. SaaS) model. In fact, databases that carry information are also very suitable for building in cloud data centers. Traditional database hosting services deploy tenants' databases in units of physical machines. With the deepening of applications, problems such as unbalanced resource utilization and difficult maintenance and management are exposed. Using the database as a service (DBaaS) model to centrally host the da...

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
IPC IPC(8): G06F17/30
CPCG06F9/5027G06F2209/504G06F2209/508
Inventor 亓开元张东刘正伟
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND
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