CN105718539A - Database application method and apparatus - Google Patents
Database application method and apparatus Download PDFInfo
- Publication number
- CN105718539A CN105718539A CN201610031033.1A CN201610031033A CN105718539A CN 105718539 A CN105718539 A CN 105718539A CN 201610031033 A CN201610031033 A CN 201610031033A CN 105718539 A CN105718539 A CN 105718539A
- Authority
- CN
- China
- Prior art keywords
- logical partition
- database table
- database
- data base
- divided
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a database application method and apparatus. The method comprises: dividing a database into at least two logical partitions; acquiring a permission allocation information table from the database, and constructing a logical partition table separately in the at least two logical partition according to the permission allocation information table, wherein the logical partition table is used for recording permission allocation information corresponding to each database table in a current logical partition; recording a correspondence relation between each database table and the at least two logical partition tables; receiving an access request instruction corresponding to a target database table, and determining a target logical partition table corresponding to the target database table according to the correspondence relation; and accessing the target logical partition table to acquire permission allocation information of the target database table. By means of the method and apparatus provided by the present invention, the corresponding speed of the database is improved.
Description
Technical field
The present invention relates to technical field of information management, particularly to a kind of database application method and device.
Background technology
Comprehensively universal today is obtained at information technology, user gets used to utilizing database purchase corresponding information, and the information exporting correspondence in corresponding service scene is in progress with promotion, in order to improve the safety of information in data base, it usually needs the information in data base is arranged corresponding access rights.
At present, in a data base, generally utilize different database tables to store different types of business information, the authority distribution information that disparate databases table is corresponding respectively is stored by an authority allocation information table, namely store each database table and the scope of business datum is provided to different business objects respectively, when there is target service object accesses target database table to obtain target service data, firstly the need of access rights allocation information table to obtain the authority distribution information of corresponding target database table, and then distribute target database table corresponding to message reference to obtain target service data according to authority.
But, in technique scheme, to distribute information due to the authority of each database table and be stored in same authority allocation information table, single table data volume is relatively big, and meanwhile, authority allocation information table is accessed frequently, it is possible to cause that database response speed is slower.
Summary of the invention
The invention provides a kind of database application method and device, improve database response speed.
First aspect, the invention provides a kind of database application method, including:
S1: data base is divided at least two logical partition；
S2: obtain authority allocation information table from described data base, according to described authority allocation information table difference construction logic partition table in described at least two logical partition, wherein, logical partition table is for recording the authority distribution information that in current logic subregion, each database table is corresponding respectively；
S3: record the corresponding relation of each database table and described at least two logical partition table；
S4: receive the access request instruction of corresponding target database table, determine the target logical partition table of corresponding described target database table according to described corresponding relation；
S5: access described target logical partition table and distribute information with the authority obtaining described target database table.
Further, also include:
Pre-set standard frequency threshold values；
Obtain the accessed frequency of each database table；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the accessed frequency according to each database table, and wherein, in each logical partition, in current logic subregion, the summation of the accessed frequency that all database table is corresponding is not more than described standard frequency threshold values.
Further, also include:
Pre-set normal capacity threshold values；
Obtain the metadata quantity that each database table stores respectively；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the metadata quantity stored respectively according to each database table, wherein, in each logical partition, in current logic subregion, the metadata quantity summation of all database table storage is not more than described normal capacity threshold values.
Further, also include:
Obtain the classification information of each database table；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the classification information according to each database table, and wherein, in each logical partition, all database table in current logic subregion possesses identical classification information.
Further, the described corresponding relation recording each database table and described at least two logical partition table, including:
Record the corresponding relation between the physical table title of each database table in the physical table title of logical partition table in each logical partition and current logic subregion.
Second aspect, the invention provides a kind of database application device, including:
Subregion arranges unit, for data base is divided at least two logical partition；
Construction unit, for obtaining authority allocation information table from described data base, according to described authority allocation information table difference construction logic partition table in described at least two logical partition, wherein, logical partition table is for recording the authority distribution information that in current logic subregion, each database table is corresponding respectively；
Memory element, for recording the corresponding relation of each database table and described at least two logical partition table；
Instruction reception unit, for receiving the access request instruction of corresponding target database table；
Determining unit, the corresponding relation for storing according to described memory element determines the target logical partition table of corresponding described target database table；
Processing unit, distributes information for accessing described target logical partition table with the authority obtaining described target database table.
Further, also include:
The frequency arranges unit, is used for pre-setting standard frequency threshold values；
First acquiring unit, for obtaining the accessed frequency of each database table；
Described subregion arranges unit, for data base being divided at least two logical partition according to the accessed frequency of each database table, wherein, in each logical partition, in current logic subregion, the summation of the accessed frequency that all database table is corresponding is not more than described standard frequency threshold values.
Further, also include:
Capacity setting unit, is used for pre-setting normal capacity threshold values；
Second acquisition unit, for obtaining the metadata quantity that each database table stores respectively；
Described subregion arranges unit, for the metadata quantity that stores respectively according to each database table, data base is divided at least two logical partition, wherein, in each logical partition, in current logic subregion, the metadata quantity summation of all database table storage is not more than described normal capacity threshold values.
Further, also include:
3rd acquiring unit, for obtaining the classification information of each database table；
Described subregion arranges unit, for the classification information according to each database table, data base is divided at least two logical partition, and wherein, in each logical partition, all database table in current logic subregion possesses identical classification information.
Further,
Described memory element, is used for the corresponding relation recording between the physical table title of each database table in the physical table title of the logical partition table in each logical partition and current logic subregion.
The invention provides a kind of database application method and device, by data base being divided into multiple logical partition, and in each logical partition, build a logical partition table respectively, each logical partition table is respectively used to record the authority distribution information of each database table in current logic subregion, realize authority distribution information corresponding respectively for each database table is carried out submeter storage, when accessing the target database table in Different Logic subregion, then need to access the logical partition table in Different Logic subregion, authority to obtain current logic intrapartition destination mark database table distributes information, it is relatively low that each logical partition table is accessed for the frequency, simultaneously, data volume in each logical partition table is relatively low, accordingly, each logical partition table all can quickly provide the authority distribution information of target database table, namely improve database response speed.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, the accompanying drawing used required in embodiment or description of the prior art will be briefly described below, apparently, accompanying drawing in the following describes is some embodiments of the present invention, for those of ordinary skill in the art, under the premise not paying creative work, it is also possible to obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the flow chart of a kind of database application method that one embodiment of the invention provides；
Fig. 2 is the flow chart of the another kind of database application method that one embodiment of the invention provides；
Fig. 3 is the structure chart of a kind of database application device that one embodiment of the invention provides；
Fig. 4 is the structure chart of the another kind of database application device that one embodiment of the invention provides.
Detailed description of the invention
For making the purpose of the embodiment of the present invention, technical scheme and advantage clearly; below in conjunction with the accompanying drawing in the embodiment of the present invention; technical scheme in the embodiment of the present invention is clearly and completely described; obviously; described embodiment is a part of embodiment of the present invention, rather than whole embodiments, based on the embodiment in the present invention; the every other embodiment that those of ordinary skill in the art obtain under the premise not making creative work, broadly falls into the scope of protection of the invention.
As it is shown in figure 1, embodiments provide a kind of database application method, the method may comprise steps of:
S1: data base is divided at least two logical partition；
S2: obtain authority allocation information table from described data base, according to described authority allocation information table difference construction logic partition table in described at least two logical partition, wherein, logical partition table is for recording the authority distribution information that in current logic subregion, each database table is corresponding respectively；
S3: record the corresponding relation of each database table and described at least two logical partition table；
S4: receive the access request instruction of corresponding target database table, determine the target logical partition table of corresponding described target database table according to described corresponding relation；
S5: access described target logical partition table and distribute information with the authority obtaining described target database table.
In one embodiment of the invention, by data base being divided into multiple logical partition, and in each logical partition, build a logical partition table respectively, each logical partition table is respectively used to store the authority distribution information of each database table in current logic subregion, realize authority distribution information corresponding respectively for each database table is carried out submeter storage, when accessing the target database table in Different Logic subregion, then need to access the logical partition table in Different Logic subregion, authority to obtain current logic intrapartition destination mark database table distributes information, it is relatively low that each logical partition table is accessed for the frequency, simultaneously, data volume in each logical partition table is relatively low, accordingly, each logical partition table all can quickly provide the authority distribution information of target database table, namely improve database response speed.
Further, in order to avoid each logical partition table is accessed frequently, it is prevented that logical partition table occur lock performance as, in a preferred embodiment of the invention, also include:
Pre-set standard frequency threshold values；
Obtain the accessed frequency of each database table；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the accessed frequency according to each database table, and wherein, in each logical partition, in current logic subregion, the summation of the accessed frequency that all database table is corresponding is not more than described standard frequency threshold values.
In one embodiment of the invention, when accessing the database table in current logic subregion every time, all need the logical partition table first accessing in current logic subregion, therefore, in current logic subregion, the accessed frequency of logical partition table in the summation correspondence current logic subregion of each the accessed frequency of database table, here it is possible to by obtaining each the database table average accessed frequency in the special time period accessed frequency as current database table.
It should be noted that standard frequency threshold values rationally can be arranged in conjunction with the actual performance of described data base, it is only necessary to guarantee the accessed frequency of each logical partition table will not occur when being not more than this standard frequency threshold values lock performance as.
Further, in order to improve the response speed of data base further, in a preferred embodiment of the invention, also include:
Pre-set normal capacity threshold values；
Obtain the metadata quantity that each database table stores respectively；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the metadata quantity stored respectively according to each database table, wherein, in each logical partition, in current logic subregion, the metadata quantity summation of all database table storage is not more than described normal capacity threshold values.
Further, in order to convenient, database table is managed, in a preferred embodiment of the invention, also includes:
Obtain the classification information of each database table；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the classification information according to each database table, and wherein, in each logical partition, all database table in current logic subregion possesses identical classification information.
For example, when the data base of a company is used for the business datum storing multiple department, the business datum of different departments can be left in different logical partition, be about in the database table of the business datum for storing same department is divided in same logical partition, convenient management.
It should be noted that, the method that data base is divided into described in the present invention each embodiment above-mentioned at least two logical partition can be combined with each other according to practical business demand, for example, when the accessed frequency of a database table is higher and metadata quantity under this database table is more, can individually divide a logical partition for this database table；And for example, for the database table under multiple classification information, if the metadata negligible amounts of the accessed frequency of each database table and correspondence, it is also possible to the database table under multiple classification information is divided in same logical partition, possesses stronger motility.
Further, in a preferred embodiment of the invention, the described corresponding relation recording each database table and described at least two logical partition table, including:
Record the corresponding relation between the physical table title of each database table in the physical table title of logical partition table in each logical partition and current logic subregion.
It should be noted that the corresponding relation of each database table and described at least two logical partition table can also be set up by other identification informations, such as, logical partition table numbering and database table numbering.
For making the object, technical solutions and advantages of the present invention clearly, below in conjunction with drawings and the specific embodiments, the present invention is described in further detail.
As shown in Figure 2, embodiments provide another kind of database application method, data base is divided at least two logical partition according to the accessed frequency of database table, and realize the target database table from data base obtains target service data instance, the method may comprise steps of:
Step 201, obtains the accessed frequency that each database table is corresponding respectively in special time period.
Here, by corresponding supervising device or detecting device, data base can be monitored accordingly, to obtain each database table in this data base accessed frequency in special time period, using the accessed frequency of each the database table got as the foundation that data base is divided into multiple logical partition.
Step 202, tests the performance of described data base, it is determined that the authority allocation information table of described data base occur lock performance as time, the accessed frequency that this table is corresponding.
Step 203, arranges standard frequency threshold values.
In step 202 and step 203, the performance of self of data base can be tested, the i.e. concurrency performance of test database, specifically, owing in data base, the authority distribution information of each database table is stored in same authority allocation information table, when needing to access the target database table for storage service data, firstly the need of access rights allocation information table to obtain the authority distribution information of corresponding target database table, and then from target database table, obtain target service data according to authority distribution information；Visible, authority allocation information table would is that the table that in data base, the accessed frequency is the highest, and, this table stores the authority distribution information of each database table, and the metadata quantity of storage is bigger；Therefore, during test database concurrency performance, it is only necessary to test authority allocation information table.
In one embodiment of the invention, the concurrency performance of test database, namely test database it may happen that lock performance as time the corresponding maximum accessed frequency, for example, when test to authority allocation information table occur lock show as time the corresponding accessed frequency be not less than a, accordingly, can using a as standard frequency threshold values；Certainly, in actual application, standard frequency threshold values can much smaller than it may happen that lock performance as time the corresponding maximum accessed frequency.
In one embodiment of the invention, it is directed to the data processing performance of data base, can pass through following steps to realize the authority distribution information being originally stored in each database table in same authority allocation information table corresponding respectively is carried out submeter storage, it is respectively stored in multiple logical partition table, the metadata quantity of each logical partition table storage is less, can quickly provide corresponding authority distribution information when accessed.
Step 204, the accessed frequency corresponding respectively according to each database table and the standard frequency threshold values of setting, be divided at least two logical partition by described data base.
Here, in order to adapt to the concurrency performance of data base, in each logical partition, the summation of the accessed frequency that all database table is corresponding should be not more than standard frequency threshold values；And, the quantity of logic region rationally can also be arranged in conjunction with practical business demand.
Step 205, obtains the authority allocation information table of described data base.
Step 206, builds the logical partition table of correspondence respectively according to described authority allocation information table in each logical partition.
Step 205 is to step 206, namely realizing the authority distribution information being originally stored in each database table in same authority allocation information table corresponding respectively is carried out submeter storage, the logical partition table in each logical partition only stores the authority distribution information that each database table in current logic subregion is corresponding respectively.
Step 207, records the corresponding relation between each logical partition table and each database table.
For example, it is possible to record the corresponding relation between the physical table title of each database table in the physical table title of logical partition table in each logical partition and current logic subregion.
Step 208, receives the access request instruction of corresponding target database table.
Step 209, the corresponding relation of inquiry record, it is determined that the target logical partition table of corresponding described target database table.
Step 208 is to step 209, and in general, the access request instruction received carries the identification information of target database table, such as, and the physical table title etc. of target database table；Here it is possible to determine that the authority for storing target database table distributes the target logical partition table of information according to the corresponding relation between physical table title and the physical table title of logical partition table of target database table.
Step 210, accesses described target logical partition table, obtains the authority distribution information of corresponding described target database table.
Step 211, distributes message reference target database table according to described authority, to obtain target service data from described target database table.
As it is shown on figure 3, the invention provides a kind of database application device, including:
Subregion arranges unit 301, for data base is divided at least two logical partition；
Construction unit 302, for obtaining authority allocation information table from described data base, according to described authority allocation information table difference construction logic partition table in described at least two logical partition, wherein, logical partition table is for recording the authority distribution information that in current logic subregion, each database table is corresponding respectively；
Memory element 303, for recording the corresponding relation of each database table and described at least two logical partition table；
Instruction reception unit 304, for receiving the service request instruction of corresponding target database table；
Determining unit 305, the corresponding relation for storing according to described memory element determines the target logical partition table of corresponding described target database table；
Processing unit 306, distributes information for accessing described logical partition table with the authority obtaining described target database table.
Further, in order to avoid each logical partition table is accessed frequently, it is prevented that logical partition table occur lock performance as, as shown in Figure 4, in a preferred embodiment of the invention, also include:
The frequency arranges unit 401, is used for pre-setting standard frequency threshold values；
First acquiring unit 402, for obtaining the accessed frequency of each database table；
Described subregion arranges unit 301, for data base being divided at least two logical partition according to the accessed frequency of each database table, wherein, in each logical partition, in current logic subregion, the summation of the accessed frequency that all database table is corresponding is not more than described standard frequency threshold values.
In order to improve the response speed of data base further, in a preferred embodiment of the invention, also include:
Capacity setting unit (attached not shown), is used for pre-setting normal capacity threshold values；
Second acquisition unit (attached not shown), for obtaining the metadata quantity that each database table stores respectively；
Described subregion arranges unit 301, for the metadata quantity that stores respectively according to each database table, data base is divided at least two logical partition, wherein, in each logical partition, in current logic subregion, the metadata quantity summation of all database table storage is not more than described normal capacity threshold values.
Further, in order to convenient, database table in data base is managed, in a preferred embodiment of the invention, also includes:
3rd acquiring unit (attached not shown), for obtaining the classification information of each database table；
Described subregion arranges unit 301, for the classification information according to each database table, data base is divided at least two logical partition, and wherein, in each logical partition, all database table in current logic subregion possesses identical classification information.
Further, in a preferred embodiment of the invention, described memory element 303, it is used for the corresponding relation recording between the physical table title of each database table in the physical table title of the logical partition table in each logical partition and current logic subregion.
The contents such as the information between each unit in said apparatus is mutual, execution process, due to the inventive method embodiment based on same design, particular content referring to the narration in the inventive method embodiment, can repeat no more herein.
Each embodiment of the present invention at least has the advantages that
1, by data base being divided into multiple logical partition, and in each logical partition, build a logical partition table respectively, each logical partition table is respectively used to store the authority distribution information of each database table in current logic subregion, realize authority distribution information corresponding respectively for each database table is carried out submeter storage, when accessing the target database table in Different Logic subregion, then need to access the logical partition table in Different Logic subregion, authority to obtain current logic intrapartition destination mark database table distributes information, it is relatively low that each logical partition table is accessed for the frequency, simultaneously, data volume in each logical partition table is relatively low, accordingly, each logical partition table all can quickly provide the authority distribution information of target database table, namely improve database response speed.
2, by arranging standard frequency threshold values, according to each the database table accessed frequency in special time period, data base is divided at least two logical partition, logical partition table can be avoided to be accessed frequently and occur lock performance as.
3, will be provided with the database table of same category information according to the classification information that each database table is corresponding respectively and be divided in same logical partition, conveniently database table is managed, simultaneously, for the database table under multiple classification information, if the metadata negligible amounts of the accessed frequency of each database table and correspondence, database table under multiple classification information can also be divided in same logical partition, possess stronger motility.
It should be noted that, in this article, the relational terms of such as first and second etc is used merely to separate an entity or operation with another entity or operating space, and not necessarily requires or imply the relation that there is any this reality between these entities or operation or sequentially.And, term " includes ", " comprising " or its any other variant are intended to comprising of nonexcludability, so that include the process of a series of key element, method, article or equipment not only include those key elements, but also include other key elements being not expressly set out, or also include the key element intrinsic for this process, method, article or equipment.When there is no more restriction, statement " including ... " key element limited, it is not excluded that there is also other same factor in including the process of described key element, method, article or equipment.
Last it should be understood that the foregoing is only presently preferred embodiments of the present invention, it is merely to illustrate technical scheme, is not intended to limit protection scope of the present invention.All make within the spirit and principles in the present invention any amendment, equivalent replacement, improvement etc., be all contained in protection scope of the present invention.
Claims (10)
1. a database application method, it is characterised in that including:
Data base is divided at least two logical partition；
Authority allocation information table is obtained from described data base, according to described authority allocation information table difference construction logic partition table in described at least two logical partition, wherein, logical partition table is for recording the authority distribution information that in current logic subregion, each database table is corresponding respectively；
Record the corresponding relation of each database table and described at least two logical partition table；
Receive the access request instruction of corresponding target database table, determine the target logical partition table of corresponding described target database table according to described corresponding relation；
Access described target logical partition table and distribute information with the authority obtaining described target database table.
2. database application method according to claim 1, it is characterised in that also include:
Pre-set standard frequency threshold values；
Obtain the accessed frequency of each database table；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the accessed frequency according to each database table, and wherein, in each logical partition, in current logic subregion, the summation of the accessed frequency that all database table is corresponding is not more than described standard frequency threshold values.
3. database application method according to claim 1, it is characterised in that also include:
Pre-set normal capacity threshold values；
Obtain the metadata quantity that each database table stores respectively；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the metadata quantity stored respectively according to each database table, wherein, in each logical partition, in current logic subregion, the metadata quantity summation of all database table storage is not more than described normal capacity threshold values.
4. database application method according to claim 1, it is characterised in that also include:
Obtain the classification information of each database table；
Described data base is divided at least two logical partition, including:
Data base is divided at least two logical partition by the classification information according to each database table, and wherein, in each logical partition, all database table in current logic subregion possesses identical classification information.
5. according to described database application method arbitrary in Claims 1-4, it is characterised in that the described corresponding relation recording each database table and described at least two logical partition table, including:
Record the corresponding relation between the physical table title of each database table in the physical table title of logical partition table in each logical partition and current logic subregion.
6. a database application device, it is characterised in that including:
Subregion arranges unit, for data base is divided at least two logical partition；
Construction unit, for obtaining authority allocation information table from described data base, according to described authority allocation information table difference construction logic partition table in described at least two logical partition, wherein, logical partition table is for recording the authority distribution information that in current logic subregion, each database table is corresponding respectively；
Memory element, for recording the corresponding relation of each database table and described at least two logical partition table；
Instruction reception unit, for receiving the access request instruction of corresponding target database table；
Determining unit, the corresponding relation for storing according to described memory element determines the target logical partition table of corresponding described target database table；
Processing unit, distributes information for accessing described target logical partition table with the authority obtaining described target database table.
7. database application device according to claim 6, it is characterised in that also include:
The frequency arranges unit, is used for pre-setting standard frequency threshold values；
First acquiring unit, for obtaining the accessed frequency of each database table；
Described subregion arranges unit, for data base being divided at least two logical partition according to the accessed frequency of each database table, wherein, in each logical partition, in current logic subregion, the summation of the accessed frequency that all database table is corresponding is not more than described standard frequency threshold values.
8. database application device according to claim 6, it is characterised in that also include:
Capacity setting unit, is used for pre-setting normal capacity threshold values；
Second acquisition unit, for obtaining the metadata quantity that each database table stores respectively；
Described subregion arranges unit, for the metadata quantity that stores respectively according to each database table, data base is divided at least two logical partition, wherein, in each logical partition, in current logic subregion, the metadata quantity summation of all database table storage is not more than described normal capacity threshold values.
9. database application device according to claim 6, it is characterised in that also include:
3rd acquiring unit, for obtaining the classification information of each database table；
Described subregion arranges unit, for the classification information according to each database table, data base is divided at least two logical partition, and wherein, in each logical partition, all database table in current logic subregion possesses identical classification information.
10. according to described database application device arbitrary in claim 6 to 9, it is characterised in that
Described memory element, is used for the corresponding relation recording between the physical table title of each database table in the physical table title of the logical partition table in each logical partition and current logic subregion.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610031033.1A CN105718539B (en) | 2016-01-18 | 2016-01-18 | A kind of database application method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610031033.1A CN105718539B (en) | 2016-01-18 | 2016-01-18 | A kind of database application method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105718539A true CN105718539A (en) | 2016-06-29 |
| CN105718539B CN105718539B (en) | 2019-02-19 |
Family
ID=56147725
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610031033.1A Active CN105718539B (en) | 2016-01-18 | 2016-01-18 | A kind of database application method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105718539B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107609870A (en) * | 2017-09-02 | 2018-01-19 | 福建新大陆支付技术有限公司 | More application key management method, system and POS terminals for POS |
| CN109299613A (en) * | 2018-09-03 | 2019-02-01 | 中国平安人寿保险股份有限公司 | The setting method and terminal device of partitions of database permission |
| CN110298189A (en) * | 2018-03-23 | 2019-10-01 | 华为技术有限公司 | Data base authority management method and equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6680917B1 (en) * | 1999-01-15 | 2004-01-20 | 3Com Corporation | Spanning tree with rapid propagation of topology changes |
| CN101276293A (en) * | 2007-03-28 | 2008-10-01 | 国际商业机器公司 | Method and system for balancing physical system resource access between logic partitions |
| CN101404013A (en) * | 2008-11-13 | 2009-04-08 | 山东浪潮齐鲁软件产业股份有限公司 | Storage and query method for large data volume table of database |
| CN103473321A (en) * | 2013-09-12 | 2013-12-25 | 华为技术有限公司 | Database management method and system |
| CN103620616A (en) * | 2013-03-28 | 2014-03-05 | 华为技术有限公司 | Access control right management method and device |
-
2016
- 2016-01-18 CN CN201610031033.1A patent/CN105718539B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6680917B1 (en) * | 1999-01-15 | 2004-01-20 | 3Com Corporation | Spanning tree with rapid propagation of topology changes |
| CN101276293A (en) * | 2007-03-28 | 2008-10-01 | 国际商业机器公司 | Method and system for balancing physical system resource access between logic partitions |
| CN101404013A (en) * | 2008-11-13 | 2009-04-08 | 山东浪潮齐鲁软件产业股份有限公司 | Storage and query method for large data volume table of database |
| CN103620616A (en) * | 2013-03-28 | 2014-03-05 | 华为技术有限公司 | Access control right management method and device |
| CN103473321A (en) * | 2013-09-12 | 2013-12-25 | 华为技术有限公司 | Database management method and system |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107609870A (en) * | 2017-09-02 | 2018-01-19 | 福建新大陆支付技术有限公司 | More application key management method, system and POS terminals for POS |
| CN107609870B (en) * | 2017-09-02 | 2023-05-30 | 福建新大陆支付技术有限公司 | Multi-application key management method and system for POS (point of sale) and POS terminal |
| CN110298189A (en) * | 2018-03-23 | 2019-10-01 | 华为技术有限公司 | Data base authority management method and equipment |
| CN110298189B (en) * | 2018-03-23 | 2021-06-22 | 华为技术有限公司 | Database authority management method and device |
| CN109299613A (en) * | 2018-09-03 | 2019-02-01 | 中国平安人寿保险股份有限公司 | The setting method and terminal device of partitions of database permission |
| CN109299613B (en) * | 2018-09-03 | 2023-07-21 | 中国平安人寿保险股份有限公司 | Database partition authority setting method and terminal equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105718539B (en) | 2019-02-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103177061B (en) | Unique value estimation in partition table | |
| US6578039B1 (en) | Database management methods and equipment, and database management program storage media | |
| US5237681A (en) | Relational data base memory utilization analyzer | |
| CN107015985B (en) | Data storage and acquisition method and device | |
| RU2546317C2 (en) | System and method for aggregation and association of professional affiliation data with commercial data content | |
| CN102725753B (en) | Method and apparatus for optimizing data access, method and apparatus for optimizing data storage | |
| EP1667062A1 (en) | Resource reconciliation | |
| CN105868421A (en) | Data management method and data management device | |
| US7263520B2 (en) | Fast aggregation of compressed data using full table scans | |
| EP3251033B1 (en) | Hybrid data distribution in a massively parallel processing architecture | |
| CN110209686A (en) | Storage, querying method and the device of data | |
| CN102456028A (en) | Multi-tenant-oriented data acquisition method, device and system | |
| US20200250192A1 (en) | Processing queries associated with multiple file formats based on identified partition and data container objects | |
| CN103995879A (en) | Data query method, device and system based on OLAP system | |
| KR101546333B1 (en) | Apparatus for processing query in database with hybrid storages | |
| CN103942209A (en) | Data processing method | |
| CN105447030A (en) | Index processing method and equipment | |
| CN110427364A (en) | A kind of data processing method, device, electronic equipment and storage medium | |
| CN105718539A (en) | Database application method and apparatus | |
| CN111475105A (en) | Monitoring data storage method, device, server and storage medium | |
| CN107704475B (en) | Multilayer distributed unstructured data storage method, query method and device | |
| CN110716990A (en) | Multi-data-source management system applied to data transaction | |
| CN106503260A (en) | A kind of method and apparatus of the effective memory space for improving data base | |
| CN112650748A (en) | Business clue distribution method and device, electronic equipment and readable storage medium | |
| CN110019229B (en) | Database configuration system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |