Partitioned management method for multi-tenant shared data table, server and system

A shared data table, multi-tenant technology, applied in the database field, can solve the problems of unbalanced data load, affecting query efficiency, centralized to another partition, etc., to achieve the effect of improving performance and achieving load balancing

Active Publication Date: 2014-12-17
CHINA TELECOM CORP LTD
View PDF2 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Partitioning according to the tenant ID may cause small tenants to be concentrated in one partition and large tenants to be concentrated in another partition, resulting in unbalanced data load between partitions
However, according to the non-tenant ID, it will cause the data of a tenant to be distributed to multiple partitions, and a large number of cross-partition queries will occur, which will affect the query efficie

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
  • Partitioned management method for multi-tenant shared data table, server and system
  • Partitioned management method for multi-tenant shared data table, server and system
  • Partitioned management method for multi-tenant shared data table, server and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. It should be noted that the relative arrangement of components and steps set forth in these embodiments does not limit the scope of the invention unless specifically stated otherwise.

[0037] The following description of at least one exemplary embodiment is merely illustrative in nature and in no way taken as limiting the invention, its application or uses. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0038] Techniques, methods and devices known to those of ordinary skill in the relevant art may not be discu...

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 partitioned management method for a multi-tenant shared data table, a server and a system. The method includes the steps that the inquiry expenditure for data of each tenant in the shared data table is recorded, wherein the data of each tenant are stored in one partition in the shared data table; statistics is conducted on the inquiry expenditure of each partition in the shared data table within a preset time period; the average inquiry expenditure of each partition is calculated according to the corresponding inquiry expenditure and the preset time period; whether the average inquiry expenditures exceed a preset inquiry expenditure threshold value or not is identified; a new partition is built for the shared data table to migrate the data of one or more tenants to the newly built partition by responding to the condition that the average inquiry expenditure exceeds the preset inquiry expenditure threshold value. According to the technical scheme, load balance of the partition data is achieved according to the data scale and inquiry frequency of tenant differentiation, and the data inquiry performance is promoted.

Description

technical field [0001] The invention relates to the field of databases, in particular to a partition management method, server and system for multi-tenant shared data tables. Background technique [0002] A multi-tenant application is a single software instance running on the server of the service provider, which can provide software services for multiple customers (ie tenants) at the same time, and allows tenants to customize the services provided by the application. At present, multi-tenant applications mainly use relational databases to store tenant data. The data storage or sharing methods include: independent database, shared database independent mode, and shared database shared mode. [0003] The first two modes are suitable for small and medium-scale multi-tenant application scenarios. In the shared database sharing mode, all tenants share the same data schema in the same database, making this mode the highest degree of database resource sharing and the least resourc...

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
CPCG06F16/2453G06F16/24553G06F16/24554G06F16/955
Inventor 何震苇杨新章陆钢胡文胜陈力李慧云梁柏青陈珣
Owner CHINA TELECOM CORP LTD
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