Device for processing materialized table in multi-tenancy (MT) application system

一种应用系统、物化表的技术，应用在多租户应用领域，能够解决物化表刷新机率大、被锁定的频率高、租户不可能物化表查询效率等问题

Active Publication Date: 2012-02-08
INT BUSINESS MASCH CORP
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

As a result, materialized tables have a high chance of being refreshed and locked frequently, which makes it almost impossible for tenants to use materialized tables to improve query efficiency, thereby affecting the speed of tenants' business operations

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
  • Device for processing materialized table in multi-tenancy (MT) application system
  • Device for processing materialized table in multi-tenancy (MT) application system
  • Device for processing materialized table in multi-tenancy (MT) application system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] Embodiments of the present invention will be described below with reference to the drawings. In the following description, numerous specific details are set forth in order to provide a more complete understanding of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced without these specific details. Furthermore, it should be understood that the invention is not limited to the particular embodiments described. Rather, any combination of the following features and elements can be considered to implement and practice the present invention. regardless of whether they relate to different embodiments. Accordingly, the following aspects, features, embodiments and advantages are by way of illustration only and should not be considered as elements or limitations of the appended claims unless expressly stated in the claims.

[0027] see figure 1 , the figure exemplarily shows the relationship between the ba...

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 a multi-tenancy (MT) application system, and discloses a device and a method for processing a materialized table in a MT application system. In the MT application system, a plurality of tenants share one or more than one of basic tables (BTs). The device comprises an update mode analyzer, a tenant grouping device and a materialized table constructor, wherein, the update mode analyzer is used for analyzing the similarity degree of the update modes of one or more than one of the BTs for the plurality of the tenants according to data access historical information of the plurality of the tenants; the tenant grouping device is used for dividing the plurality of the tenants into a plurality of tenant groups according to the similarity degree analyzed by the update mode analyzer; and the materialized table constructor is used for constructing the tenant group materialized table corresponding to the tenant groups by one or more than one of the BTs according to the tenant groups divided by the tenant grouping device.

Description

technical field [0001] The present invention relates to multi-tenant applications, in particular to database management in multi-tenant applications, and more specifically, to a device for processing materialized tables in a multi-tenant application system. Background technique [0002] The multi-tenant application system provides multi-tenant applications to software users through multi-tenant MT (Multi-Tenancy) technology, that is, a single instance of the software application runs on the server of the service provider to serve multiple tenants (such as enterprises, etc.) organization) provides software application services, thereby reducing the cost of developing, deploying, and operating software applications. [0003] A database is a systematic data organization for efficient and reliable storage, retrieval, and processing of data. A database is made up of tables, which contain rows of related data. Access and manipulation of data is done through queries. [0004] Th...

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/213G06F16/28
Inventor 安文豪王芝虎郭常杰高波段宁
Owner INT BUSINESS MASCH 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