CN103544319B - A kind of method of many tenants shared data bank and multi-tenant database i.e. service system - Google Patents
A kind of method of many tenants shared data bank and multi-tenant database i.e. service system Download PDFInfo
- Publication number
- CN103544319B CN103544319B CN201310544688.5A CN201310544688A CN103544319B CN 103544319 B CN103544319 B CN 103544319B CN 201310544688 A CN201310544688 A CN 201310544688A CN 103544319 B CN103544319 B CN 103544319B
- Authority
- CN
- China
- Prior art keywords
- information
- instruction
- database instance
- physical database
- tenant
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 238000013507 mapping Methods 0.000 claims abstract description 45
- 238000013523 data management Methods 0.000 claims abstract description 44
- 238000012423 maintenance Methods 0.000 claims abstract description 23
- 238000012217 deletion Methods 0.000 claims description 6
- 230000037430 deletion Effects 0.000 claims description 6
- 230000005540 biological transmission Effects 0.000 claims description 4
- 238000002955 isolation Methods 0.000 abstract description 5
- 238000005516 engineering process Methods 0.000 description 4
- 238000007726 management method Methods 0.000 description 3
- 238000013500 data storage Methods 0.000 description 2
- 230000004927 fusion Effects 0.000 description 2
- 230000004888 barrier function Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 239000011800 void material Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5005—Allocation of resources, e.g. of the central processing unit [CPU] to service a request
- G06F9/5027—Allocation of resources, e.g. of the central processing unit [CPU] to service a request the resource being a machine, e.g. CPUs, Servers, Terminals
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2209/00—Indexing scheme relating to G06F9/00
- G06F2209/50—Indexing scheme relating to G06F9/50
- G06F2209/504—Resource capping
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2209/00—Indexing scheme relating to G06F9/00
- G06F2209/50—Indexing scheme relating to G06F9/50
- G06F2209/508—Monitor
Abstract
The invention discloses a kind of multi-tenant database i.e. service system, this system includes: application layer module, for receiving the instruction of client, sets up in application layer and safeguards the logical data base information of tenant, sending the first instruction to data management layer module；Data management layer module, for setting up the mapping to the physical database instance information of infrastructure layer of the logical data base information with maintenance application layer according to described first instruction, sends the second instruction to infrastructure layer module；Infrastructure layer module, for the instruction physical database instance based on virtual machine creating infrastructure layer according to described second instruction, or carries out data manipulation according to the instruction of described second instruction to described physical database instance.The present invention is capable of the performance isolation between tenant, ensures the performance requirement of tenant.A kind of method that present invention also offers many tenants shared data bank.
Description
Technical field
The present invention relates to field of cloud computer technology, the side of a kind of many tenants shared data bank
Method and multi-tenant database i.e. service DBaaS (Database as a Service) system.
Background technology
Along with the development of cloud computing technology, operating system, middleware and the application in traditional software level stack
In cloud, have found position one after another, occur in that infrastructure i.e. services (IaaS), platform i.e. services (PaaS)
(SaaS) pattern is i.e. serviced with software.It practice, the data base of carrying information is also very suitable for building
Cloud data center.The data base of tenant is disposed in traditional database trusteeship service in units of physical machine, along with
Going deep into of application, exposes that the utilization of resources is unbalanced and the problem such as maintenance management difficulty.I.e. take with data base
The centralized database trustship of each tenant is got up by business (Database as a Service, DBaaS) pattern,
Realized the Optimum utilization of resource by shared server, reduce hardware and software cost and maintenance management expense, be
Solve the ideal scheme of the problems referred to above.
Between multiple tenant databases, shared server is DBaaS mould to improve resource utilization ratio
The core of formula is pursued.Existing shared data bank scheme makes the data base of multiple tenant co-exist in same clothes
On the same database engine of business device, although can improve the utilization rate of resource, but the property of tenant database
Can isolation can not get ensureing, the request load of some tenant may take major part system resource, causes money
Source is kidnapped.
Therefore, existing multi-tenant database i.e. services in DBaaS system, interacts between tenant,
The performance requirement of tenant is the most effectively ensured.
Summary of the invention
The technical problem to be solved is to provide a kind of method of many tenants shared data bank with many
Tenant database i.e. services DBaaS system, it is possible to realize the performance isolation between tenant, ensures tenant
Performance requirement.
In order to solve above-mentioned technical problem, the invention provides a kind of multi-tenant database i.e. service system,
This system includes:
Application layer module, for receiving the instruction of client, sets up in application layer and safeguards the logic of tenant
Database information, sends the first instruction to data management layer module；
Data management layer module, for setting up and the logical data of maintenance application layer according to described first instruction
Storehouse information, to the mapping of the physical database instance information of infrastructure layer, sends to infrastructure layer module
Second instruction；
Infrastructure layer module, for setting based on virtual machine creating basis according to the instruction of described second instruction
Execute the physical database instance of layer, or the instruction according to described second instruction is real to described physical database
Example carries out data manipulation.
Further, this system also includes following feature:
Described physical database instance information includes one or more of following information: physical database instance
IP address, the port of physical database instance, physical database instance mark, tenant identification, thing
Reason database instance password or host's virtual machine information.
Further, this system also includes following feature:
Described first instruction, including with give an order any one: create physical database instance, deletion
Physical database instance, storage data or inquiry data.
Further, this system also includes following feature:
Data management layer module, for receiving the establishment physical database instance of application layer module transmission
After first instruction, set up the physical data to infrastructure layer of the logical data base information with maintenance application layer
The mapping of storehouse example information, including:
According to the idle degrees of infrastructure layer physical server resource, preferentially at the physics that idle degrees is high
Virtual machine is created on server；
Logical data base information according to tenant creates physical database instance on a virtual machine；
Preserve the mapping relations of the logical data base of physical database instance and the tenant created.
Further, this system also includes following feature:
Data management layer module, for receiving the first of inquiry/storage data that application layer module sends
After instruction, set up and the logical data base information of maintenance application layer is real to the physical database of infrastructure layer
The mapping of example information, including:
Logical data base information according to tenant selects physical database instance list, and father's thread is according to described
Mapping relations select the physical database instance that logical data base is corresponding, for each physical database instance
Start a son and carry out thread-data inquiry/storage.
Further, this system also includes following feature:
The type of described mapping includes: Hash route maps or binary chop route maps.
Further, this system also includes following feature:
The logical data base of tenant is set up based on relational model, including the one or many of following metadata information
Kind: tenant's information, database description information, tables of data describe information, data list structure information or data
Table relation information.
In order to solve above-mentioned technical problem, present invention also offers the side of a kind of many tenants shared data bank
Method, the method includes:
Application layer module receives the instruction of client, sets up in application layer and safeguards the logical data base of tenant
Information, sends the first instruction to data management layer module；
Data management layer module is set up according to described first instruction and the logical data base letter of maintenance application layer
Breath, to the mapping of the physical database instance information of infrastructure layer, sends second to infrastructure layer module
Instruction；
Infrastructure layer module according to described second instruction instruction based on virtual machine creating infrastructure layer
Physical database instance, or according to described second instruction instruction described physical database instance is entered
Row data manipulation.
Further, the method also includes following feature:
Described physical database instance information includes one or more of following information: physical database instance
IP address, the port of physical database instance, physical database instance mark, tenant identification, thing
Reason database instance password or host's virtual machine information.
Further, the method also includes following feature:
Described first instruction, including with give an order any one: create physical database instance, deletion
Physical database instance, storage data or inquiry data.
Further, the method also includes following feature:
Data management layer module receives the first of the establishment physical database instance that application layer module sends
After instruction, set up and the logical data base information of maintenance application layer is real to the physical database of infrastructure layer
The mapping of example information, including:
According to the idle degrees of infrastructure layer physical server resource, preferentially at the physics that idle degrees is high
Virtual machine is created on server；
Logical data base information according to tenant creates physical database instance on a virtual machine；
Preserve the mapping relations of the logical data base of physical database instance and the tenant created.
Further, the method also includes following feature:
Data management layer module receives the first instruction of inquiry/storage data that application layer module sends
After, set up the physical database instance letter to infrastructure layer of the logical data base information with maintenance application layer
The mapping of breath, including:
Logical data base information according to tenant selects physical database instance list, and father's thread is according to described
Mapping relations select the physical database instance that logical data base is corresponding, for each physical database instance
Start a sub-thread and carry out data query.
Further, the method also includes following feature:
The type of described mapping includes: Hash route maps or binary chop route maps.
Further, the method also includes following feature:
The logical data base of tenant is set up based on relational model, including the one or many of following metadata information
Kind: tenant's information, database description information, tables of data describe information, data list structure information or data
Table relation information.
Compared with prior art, the present invention provides a kind of method of many tenants shared data bank and many tenants
Data base i.e. services DBaaS system, by each tenant being converted to the operation of logical data base to void
The virtualization operations of the physical database instance on plan machine, it is possible to realize the performance isolation between tenant, protects
The performance requirement of barrier tenant.
Accompanying drawing explanation
Fig. 1 is a kind of multi-tenant database i.e. structural representation of service system of the embodiment of the present invention.
Fig. 2 is the detailed construction signal of the i.e. service system of a kind of multi-tenant database of the embodiment of the present invention
Figure.
Fig. 3 is the flow chart of the method for a kind of many tenants shared data bank of the embodiment of the present invention.
Detailed description of the invention
For making the object, technical solutions and advantages of the present invention clearer, below in conjunction with accompanying drawing
Embodiments of the invention are described in detail.It should be noted that in the case of not conflicting, this Shen
Embodiment in please and the feature in embodiment can mutual combination in any.
For ensureing that multi-tenant database i.e. services the performance requirement of tenant in DBaaS system, based on virtual
Machine technology, such as VMware, Xen etc., it is possible to physical server systems resource is (CPU time, interior
Deposit capacity and I/O bandwidth etc.) it is proportionately distributed to non-interfering virtual machine, realized by relational model
The logical data base of each tenant represents, logical data base operates the physical database being mapped on virtual machine
Operation, it is possible to realize the performance isolation between tenant.
As it is shown in figure 1, embodiments provide a kind of many tenants of based on virtual machine DBaaS system
System, including application layer module, data management layer module and infrastructure layer module；Wherein,
Application layer module, for receiving the instruction of client, sets up in application layer and safeguards the logic of tenant
Database information, sends the first instruction to data management layer module；
Data management layer module, for setting up and the logical data of maintenance application layer according to described first instruction
Storehouse information, to the mapping of the physical database instance information of infrastructure layer, sends to infrastructure layer module
Second instruction；
Infrastructure layer module, for setting based on virtual machine creating basis according to the instruction of described second instruction
Execute the physical database instance of layer, or the instruction according to described second instruction is real to described physical database
Example carries out data manipulation.
Fig. 2 shows a kind of many tenants DBaaS system.Wherein, data management layer module is by application
Interface (1) between layer and data management layer receives the data manipulation instruction that application layer sends, and is carrying out
It is sent to basis by the interface (3) between data management layer and infrastructure layer after resolving and processing set
Execute layer and carry out the operation of physical database；Data management layer module is by between application layer and data management layer
Interface (2) obtain tenant in the logical data base information of application layer, to indicate infrastructure layer module
Create physical database instance；Data management layer module is by between data management layer and infrastructure layer
Interface (3) obtains the physical database instance information of infrastructure layer；
In Fig. 2, device clusters refers to carry various calculating, storage and network physical cluster tool, also referred to as
For physical resource pond.Virtual machine refers to mark off virtual the setting of a part of resource formation from physical resource pond
Standby.Physical database instance refers to the physics realization of application-level logic data base, relies on a virtual machine
The data base management system dispose, run or database engine, by Physical data model (table, field etc.)
Constitute.The logical data base of one tenant may need multiple physical database instance to realize, a thing
Reason database instance runs on a virtual machine.
Above-mentioned many tenants DBaaS system, it is also possible to there is following feature:
Preferably, the logical data base of tenant is set up based on relational model, can include that following metadata is believed
One or more of breath: tenant's information, database description information, tables of data describe information, tables of data knot
Structure information or tables of data relation information；
Described physical database instance is set up based on virtual machine, can include the one of following information or many
Kind: the IP address of physical database instance, the port of physical database instance, physical database instance
Mark, tenant identification, physical database instance password or host's virtual machine information；
The logical data base information of application layer is to the mapping of the physical database instance information of infrastructure layer
Information, can include following information: the logical data base mark of tenant, physical database instance mark and
Mapping ruler.
Wherein, a logical data base can include multiple tables of data, the adduction relationship note between tables of data
Record in tables of data relation information.The logical data base mark of tenant can comprise the mark of tenant, such as,
The logical data base mark of tenant is designated as " tenant identification _ logical database name "；Such as, if tenant is A
Establish logical data base a, then this logical data base named " A_a ", if tenant B establishes patrols
Collect data base b, then this logical data base named " B_b "；
Preferably, described first instruction, including with give an order any one: create physical database real
Example, deletion of physically database instance, storage data or inquiry data.
Preferably, data management layer module receives the establishment physical database instance that application layer module sends
The first instruction after, set up and the logical data base information of maintenance application layer be to the physics number of infrastructure layer
According to the mapping of storehouse example information, including:
According to the idle degrees of infrastructure layer physical server resource, preferentially at the physics that idle degrees is high
Virtual machine is created on server；
Logical data base information according to tenant creates physical database instance on a virtual machine；
Preserve the mapping relations of the logical data base of physical database instance and the tenant created.
Preferably, data management layer module receives the first instruction of the inquiry data that application layer module sends
After, set up the physical database instance letter to infrastructure layer of the logical data base information with maintenance application layer
The mapping of breath, including:
Logical data base information according to tenant selects physical database instance list, and father's thread is according to data
Storehouse mapping ruler selects the physical database instance that logical data base is corresponding, real for each physical database
Example starts a sub-thread and carries out data query, and father's thread Fusion query result also returns；
Preferably, data management layer module receives the first instruction of the storage data that application layer module sends
After, set up the physical database instance letter to infrastructure layer of the logical data base information with maintenance application layer
The mapping of breath, including:
Logical data base information according to tenant selects physical database instance list, and father's thread is according to data
Storehouse mapping ruler selects the physical database instance that logical data base is corresponding, real for each physical database
Example starts a son and carries out thread-data storage；
Wherein, the type of described mapping includes: Hash (Hash) route maps or binary chop route is reflected
Penetrate；
Preferably, data management layer module also sets up, safeguards physical database connection pool；Data management
Layer module receives application layer module by JDBC (Java Data Base Connectivity, Java number
According to storehouse connect) drive send first instruction after, from physical database connection pool select a connection make
With, thus save physical connection set up expense；
Preferably, data management layer module also sets up, safeguards client connection pool；Data management layer mould
After block receives the first instruction that application layer module drives transmission by JDBC, from client connection pool
Select one to connect to use, thus save the establishment expense of thread.
As it is shown on figure 3, a kind of method embodiments providing many tenants shared data bank, the party
Method includes:
S10, application layer module receives the instruction of client, sets up in application layer and safeguards the logic of tenant
Database information, sends the first instruction to data management layer module；
S20, data management layer module is set up and the logical data of maintenance application layer according to described first instruction
Storehouse information, to the mapping of the physical database instance information of infrastructure layer, sends to infrastructure layer module
Second instruction；
S30, infrastructure layer module sets based on virtual machine creating basis according to the instruction of described second instruction
Execute the physical database instance of layer, or the instruction according to described second instruction is real to described physical database
Example carries out data manipulation；
Wherein, the method for described many tenants shared data bank, it is also possible to include following feature:
Preferably, the logical data base of tenant is set up based on relational model, can include that following metadata is believed
One or more of breath: tenant's information, database description information, tables of data describe information, tables of data knot
Structure information or tables of data relation information；
Described physical database instance is set up based on virtual machine, can include the one of following information or many
Kind: the IP address of physical database instance, the port of physical database instance, physical database instance
Mark, tenant identification, physical database instance password or host's virtual machine information；
The logical data base information of application layer is to the mapping of the physical database instance information of infrastructure layer
Information, including following information: the logical data base mark of tenant, physical database instance mark and mapping
Rule.
Preferably, described first instruction, including with give an order any one: create physical database real
Example, deletion of physically database instance, storage data or inquiry data；
Data management layer module receives the first of the establishment physical database instance that application layer module sends
After instruction, set up and the logical data base information of maintenance application layer is real to the physical database of infrastructure layer
The mapping of example information, including:
According to the idle degrees of infrastructure layer physical server resource, preferentially at the physics that idle degrees is high
Virtual machine is created on server；
Logical data base information according to tenant creates physical database instance on a virtual machine；
Preserve the mapping relations of the logical data base of physical database instance and the tenant created.
Preferably, data management layer module receives the first instruction of the inquiry data that application layer module sends
After, set up the physical database instance letter to infrastructure layer of the logical data base information with maintenance application layer
The mapping of breath, including:
Logical data base information according to tenant selects physical database instance list, and father's thread is according to data
Storehouse mapping ruler selects the physical database instance that logical data base is corresponding, real for each physical database
Example starts a sub-thread and carries out data query, and father's thread Fusion query result also returns；
Preferably, data management layer module receives the first instruction of the storage data that application layer module sends
After, set up the physical database instance letter to infrastructure layer of the logical data base information with maintenance application layer
The mapping of breath, including:
Logical data base information according to tenant selects physical database instance list, and father's thread is according to data
Storehouse mapping ruler selects the physical database instance that logical data base is corresponding, real for each physical database
Example starts a sub-thread and carries out data storage；
Wherein, the type of described mapping includes: Hash (Hash) route maps or binary chop route is reflected
Penetrate；
Preferably, data management layer module also sets up, safeguards physical database connection pool；Data management
Layer module receives application layer module by JDBC (Java Data Base Connectivity, Java number
According to storehouse connect) drive send first instruction after, from physical database connection pool select a connection make
With, thus save physical connection set up expense；
Preferably, data management layer module also sets up, safeguards client connection pool；Data management layer mould
After block receives the first instruction that application layer module drives transmission by JDBC, from client connection pool
Select one to connect to use, thus save the establishment expense of thread.
The method of a kind of many tenants shared data bank that above-described embodiment provides and many tenants DBaaS system,
By effective relational model of tenant's logical data base information is represented, by each tenant logic to application layer
The physical database operation that database manipulation is mapped on the virtual machine of infrastructure layer, is held by virtual machine
Loading reason database realizing virtualizes conversion efficiently, performance when meeting each tenant's shared data bank every
From.
One of ordinary skill in the art will appreciate that all or part of step in said method can pass through journey
Sequence instructs related hardware and completes, and described program can be stored in computer-readable recording medium, as only
Read memorizer, disk or CD etc..Alternatively, all or part of step of above-described embodiment can also make
Realizing with one or more integrated circuits, correspondingly, each module/unit in above-described embodiment is permissible
The form using hardware realizes, it would however also be possible to employ the form of software function module realizes.The present invention is not intended to
Combination in the hardware and software of any particular form.
It should be noted that the present invention also can have other various embodiments, without departing substantially from the present invention spirit and
In the case of its essence, those of ordinary skill in the art can make various corresponding change according to the present invention
And deformation, but these change accordingly and deform the protection model that all should belong to appended claims of the invention
Enclose.
Claims (12)
1. a multi-tenant database i.e. service system, this system includes:
Application layer module, for receiving the instruction of client, sets up in application layer and safeguards the logic of tenant
Database information, sends the first instruction to data management layer module；
Data management layer module, for setting up and the logical data of maintenance application layer according to described first instruction
Storehouse information, to the mapping of the physical database instance information of infrastructure layer, sends to infrastructure layer module
Second instruction；
Infrastructure layer module, for setting based on virtual machine creating basis according to the instruction of described second instruction
Execute the physical database instance of layer, or the instruction according to described second instruction is real to described physical database
Example carries out data manipulation；
Data management layer module, for receiving the first of inquiry/storage data that application layer module sends
After instruction, set up and the logical data base information of maintenance application layer is real to the physical database of infrastructure layer
The mapping of example information, including:
Logical data base information according to tenant selects physical database instance list, and father's thread is according to described
Mapping relations select the physical database instance that logical data base is corresponding, for each physical database instance
Start a sub-thread and carry out data query/storage.
2. the system as claimed in claim 1, it is characterised in that:
Described physical database instance information includes one or more of following information: physical database instance
IP address, the port of physical database instance, physical database instance mark, tenant identification, thing
Reason database instance password or host's virtual machine information.
3. system as claimed in claim 1 or 2, it is characterised in that:
Described first instruction, including with give an order any one: create physical database instance, deletion
Physical database instance, storage data or inquiry data.
4. system as claimed in claim 3, it is characterised in that:
Data management layer module, for receiving the establishment physical database instance of application layer module transmission
After first instruction, set up the physical data to infrastructure layer of the logical data base information with maintenance application layer
The mapping of storehouse example information, including:
According to the idle degrees of infrastructure layer physical server resource, preferentially at the physics that idle degrees is high
Virtual machine is created on server；
Logical data base information according to tenant creates physical database instance on a virtual machine；
Preserve the mapping relations of the logical data base of physical database instance and the tenant created.
5. system as claimed in claim 3, it is characterised in that:
The type of described mapping includes: Hash route maps or binary chop route maps.
6. system as claimed in claim 1 or 2, it is characterised in that:
The logical data base of tenant is set up based on relational model, including the one or many of following metadata information
Kind: tenant's information, database description information, tables of data describe information, data list structure information or data
Table relation information.
7. a method for the shared data bank of tenant more than, the method includes:
Application layer module receives the instruction of client, sets up in application layer and safeguards the logical data base of tenant
Information, sends the first instruction to data management layer module；
Data management layer module is set up according to described first instruction and the logical data base letter of maintenance application layer
Breath, to the mapping of the physical database instance information of infrastructure layer, sends second to infrastructure layer module
Instruction；
Infrastructure layer module according to described second instruction instruction based on virtual machine creating infrastructure layer
Physical database instance, or according to described second instruction instruction described physical database instance is entered
Row data manipulation；
Data management layer module receives the first instruction of inquiry/storage data that application layer module sends
After, set up the physical database instance letter to infrastructure layer of the logical data base information with maintenance application layer
The mapping of breath, including:
Logical data base information according to tenant selects physical database instance list, and father's thread is according to described
Mapping relations select the physical database instance that logical data base is corresponding, for each physical database instance
Start a sub-thread and carry out data query/storage.
8. method as claimed in claim 7, it is characterised in that:
Described physical database instance information includes one or more of following information: physical database instance
IP address, the port of physical database instance, physical database instance mark, tenant identification, thing
Reason database instance password or host's virtual machine information.
9. method as claimed in claim 7 or 8, it is characterised in that:
Described first instruction, including with give an order any one: create physical database instance, deletion
Physical database instance, storage data or inquiry data.
10. method as claimed in claim 9, it is characterised in that:
Data management layer module receives the first of the establishment physical database instance that application layer module sends
After instruction, set up and the logical data base information of maintenance application layer is real to the physical database of infrastructure layer
The mapping of example information, including:
According to the idle degrees of infrastructure layer physical server resource, preferentially at the physics that idle degrees is high
Virtual machine is created on server；
Logical data base information according to tenant creates physical database instance on a virtual machine；
Preserve the mapping relations of the logical data base of physical database instance and the tenant created.
11. methods as claimed in claim 9, it is characterised in that:
The type of described mapping includes: Hash route maps or binary chop route maps.
12. methods as claimed in claim 7 or 8, it is characterised in that:
The logical data base of tenant is set up based on relational model, including the one or many of following metadata information
Kind: tenant's information, database description information, tables of data describe information, data list structure information or data
Table relation information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310544688.5A CN103544319B (en) | 2013-11-06 | 2013-11-06 | A kind of method of many tenants shared data bank and multi-tenant database i.e. service system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310544688.5A CN103544319B (en) | 2013-11-06 | 2013-11-06 | A kind of method of many tenants shared data bank and multi-tenant database i.e. service system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103544319A CN103544319A (en) | 2014-01-29 |
| CN103544319B true CN103544319B (en) | 2016-09-21 |
Family
ID=49967771
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310544688.5A Active CN103544319B (en) | 2013-11-06 | 2013-11-06 | A kind of method of many tenants shared data bank and multi-tenant database i.e. service system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103544319B (en) |
Families Citing this family (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104468805B (en) * | 2014-12-12 | 2018-08-28 | 用友网络科技股份有限公司 | Message routing apparatus and method |
| CN104484473A (en) * | 2014-12-31 | 2015-04-01 | 北京海量数据技术股份有限公司 | Database monitoring platform based on database cloud and monitoring method |
| CN104679886A (en) * | 2015-03-17 | 2015-06-03 | 浪潮集团有限公司 | Method and device for Hive data isolation under multi-tenant mode |
| CN106202084A (en) * | 2015-04-30 | 2016-12-07 | 阿里巴巴集团控股有限公司 | Date storage method and data storage device |
| CN104881749A (en) * | 2015-06-01 | 2015-09-02 | 北京圆通慧达管理软件开发有限公司 | Data management method and data storage system for multiple tenants |
| CN105577675A (en) * | 2015-12-31 | 2016-05-11 | 深圳前海微众银行股份有限公司 | Multi-tenant resource management method and device |
| CN107203575B (en) * | 2016-03-18 | 2021-02-26 | 北京京东尚科信息技术有限公司 | System, equipment and method for isolating multi-tenant data |
| CN106874371A (en) * | 2016-12-30 | 2017-06-20 | 新华三技术有限公司 | A kind of data processing method and device |
| CN106897947A (en) * | 2017-01-04 | 2017-06-27 | 上海易谷网络科技有限公司 | A kind of multi-tenant service quick deployment method based on cloud platform |
| CN108667886B (en) * | 2017-04-01 | 2020-07-28 | 华为技术有限公司 | Method for providing PaaS service, management system and cloud computing service architecture |
| CN107247905A (en) * | 2017-05-14 | 2017-10-13 | 上海美迪索科电子科技有限公司 | A kind of safe mandatory system of position data based on virtual machine |
| US10657276B2 (en) * | 2017-10-26 | 2020-05-19 | Sap Se | System sharing types in multi-tenancy database systems |
| CN108108227A (en) * | 2018-01-04 | 2018-06-01 | 郑州云海信息技术有限公司 | A kind of cloud computing management system and its method for managing virtual machine |
| CN108520004B (en) * | 2018-03-12 | 2021-11-19 | 舟谱数据技术南京有限公司 | Multi-tenant data source switching system based on method parameter section |
| CN108768890B (en) * | 2018-05-28 | 2022-01-04 | 郑州云海信息技术有限公司 | Multi-tenant resource multiplexing method and device in SDN network and controller |
| CN109165135B (en) * | 2018-07-18 | 2021-05-04 | 平安科技（深圳）有限公司 | Data management method, computer readable storage medium and terminal equipment |
| CN109254847B (en) * | 2018-08-22 | 2022-04-19 | 创新先进技术有限公司 | Tenant mapping information acquisition method and device |
| CN109951530A (en) * | 2019-02-27 | 2019-06-28 | 上海浪潮云计算服务有限公司 | A kind of Implementation Technology of multi-tenant mode |
| CN112328387A (en) * | 2020-09-04 | 2021-02-05 | 广东电力信息科技有限公司 | Multi-tenant-oriented micro-service resource scheduling method |
| CN113377784B (en) * | 2021-08-13 | 2021-12-03 | 成都市维思凡科技有限公司 | Data processing method, system and storage medium based on middleware |
| CN114490749A (en) * | 2021-12-28 | 2022-05-13 | 珠海大横琴科技发展有限公司 | Resource access method and device |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103023986A (en) * | 2012-11-27 | 2013-04-03 | 中国电信股份有限公司云计算分公司 | System and method for providing relational database management system (RDBMS) services for multiple users |
| CN103235725A (en) * | 2013-05-16 | 2013-08-07 | 浪潮通信信息系统有限公司 | Linux-based rapid deployment method for Oracle database in cloud computing |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136055B (en) * | 2011-11-25 | 2016-08-03 | 国际商业机器公司 | For controlling the method and apparatus to the use calculating resource in database service |
-
2013
- 2013-11-06 CN CN201310544688.5A patent/CN103544319B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103023986A (en) * | 2012-11-27 | 2013-04-03 | 中国电信股份有限公司云计算分公司 | System and method for providing relational database management system (RDBMS) services for multiple users |
| CN103235725A (en) * | 2013-05-16 | 2013-08-07 | 浪潮通信信息系统有限公司 | Linux-based rapid deployment method for Oracle database in cloud computing |
Non-Patent Citations (1)
| Title |
|---|
| 《面向托管的数据库即服务系统及资源优化技术》;王卓昊等;《计算机工程与应用》;20110921;第47卷(第27期);第19-23页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103544319A (en) | 2014-01-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103544319B (en) | A kind of method of many tenants shared data bank and multi-tenant database i.e. service system | |
| CN107066319B (en) | Multi-dimensional scheduling system for heterogeneous resources | |
| US11700296B2 (en) | Client-directed placement of remotely-configured service instances | |
| US10394611B2 (en) | Scaling computing clusters in a distributed computing system | |
| CN103218175B (en) | The cloud storage platform access control system of many tenants | |
| US11075991B2 (en) | Partitioning data according to relative differences indicated by a cover tree | |
| US10157214B1 (en) | Process for data migration between document stores | |
| CN105242872B (en) | A kind of shared memory systems of Virtual cluster | |
| US20140310287A1 (en) | Method and system for storing data in commodity computing | |
| CN104283959B (en) | A kind of memory mechanism based on grading performance suitable for cloud platform | |
| US10158709B1 (en) | Identifying data store requests for asynchronous processing | |
| CN105765578A (en) | Parallel access to data in a distributed file system | |
| CN102262680A (en) | Distributed database proxy system based on massive data access requirement | |
| US9654582B2 (en) | Enhanced shared memory based communication driver for improved performance and scalability | |
| US10742748B2 (en) | System and method for supporting live addition of a tenant in a connection pool environment | |
| CN105635311A (en) | Method for synchronizing resource pool information in cloud management platform | |
| CN104794150A (en) | Cloud storage model and management method based on space knowledge cloud environment | |
| US11711369B2 (en) | Controlling access to secure information resources using rotational datasets and dynamically configurable data containers | |
| CN113190529A (en) | Multi-tenant data sharing storage system suitable for MongoDB database | |
| US8732200B2 (en) | System and method for controlling access to a database object | |
| CN107451246B (en) | Information resource integrated processing system suitable for large-scale city | |
| US9590839B2 (en) | Controlling access to a shared storage system | |
| US9898614B1 (en) | Implicit prioritization to rate-limit secondary index creation for an online table | |
| US20200382505A1 (en) | Controlling Access to Secure Information Resources Using Rotational Datasets and Dynamically Configurable Data Containers | |
| US11488115B1 (en) | Efficient meeting room reservation and scheduling |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |