Method and system for extending database table under multi-tenant environment

A database and tenant technology, applied in the database field, can solve problems such as affecting system performance, consuming computing resources, and wasting space.

Inactive Publication Date: 2011-09-28
IBM CORP
View PDF3 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The obvious disadvantage of this solution is that if the developer only provides fewer expandable empty table columns when designing the system, then the needs of a large number of tenants to expand the database table may not be met
And if the developer provides a large number of expandable empty table columns when designing the system, the database table will occupy and waste a lot of space, because there are many expandable table columns that may only be required by very few tenants
In some cases, the above two disadvantages may occur at the same time: there are some tenants whose needs cannot be met, and there are a large number of scalable table columns with extremely low usage, resulting in a lot of space being wasted
Another disadvantage of this solution is: since the pre-defined expandable empty table columns do not contain relevant information such as data type (suc

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 system for extending database table under multi-tenant environment
  • Method and system for extending database table under multi-tenant environment
  • Method and system for extending database table under multi-tenant environment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] Hereinafter, the method and system for determining the node to be materialized provided by the present invention will be described in detail through embodiments with reference to the accompanying drawings.

[0020] figure 1 A flowchart of a method for expanding a database table according to an embodiment of the present invention is shown. First of all, it needs to be pointed out that anywhere in this specification, claims and drawings, "extended database table" does not necessarily mean that the database table is actually expanded physically or in fact, but may mean that although There is no real physical or actual expansion of database tables, but for tenants in a multi-tenant system, the effect or user experience of expanding database tables is produced.

[0021] In step 101, a request from a tenant to expand a database table is received. According to an embodiment of the present invention, the tenant's request for an extended database table may be an SQL statement such a...

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 the technology of databases, and particularly relates to a technology of extending a database table in a multi-tenant environment. The invention provides a method for extending the database table, which comprises the following steps: receiving a request of a tenant about database table extension; and generating a description document corresponding to the tenant according to the received request, wherein the description document describes extended fields defined by the database table into at least one extension column.

Description

Technical field [0001] The present invention relates to database technology, in particular to a technology for expanding database tables in a multi-tenant environment. Background technique [0002] Due to the emergence of SaaS (Software as a Service, software as a service), the software industry is undergoing a profound transformation. SaaS has become popular in many countries and has entered the popularization stage. The security technology of SaaS changes with each passing day, and more and more companies are beginning to recognize the security and reliability of SaaS. Based on the characteristics of the Internet, SaaS software has many unique features that are different from the previous generation of software. Many new technologies have emerged from server-side software and databases, data transmission, to client browsers. [0003] When developing SaaS software systems, they are all built on the basis of Multi-Tenant, also known as “multi-tenant”, which is a set of software a...

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
CPCG06F17/30575G06F16/27
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