CN104112008A - Multi-table data association inquiry optimizing method and device - Google Patents
Multi-table data association inquiry optimizing method and device Download PDFInfo
- Publication number
- CN104112008A CN104112008A CN201410339632.0A CN201410339632A CN104112008A CN 104112008 A CN104112008 A CN 104112008A CN 201410339632 A CN201410339632 A CN 201410339632A CN 104112008 A CN104112008 A CN 104112008A
- Authority
- CN
- China
- Prior art keywords
- data
- inquiry
- database
- query
- group
- 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.)
- Pending
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
- G06F16/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
- G06F16/24556—Aggregation; Duplicate elimination
-
- 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
Abstract
The invention discloses a multi-table data association inquiry optimizing method and device. The multi-table data association inquiry optimizing method comprises the following steps: if data requested to be inquired involve more than two data tables, grouping the data requested to be inquired, dividing data belonging to the same data table into the same inquiry group and dividing data belonging to different data tables into different inquiry groups; for each inquiry group, determining databases correspondingly used during inquiry of the data of the inquiry groups, and inquiring the data of the inquiry groups from the databases; combining the inquired data of all the inquiry groups to generate an inquiry result. By adopting the technical scheme, the stress of the databases can be effectively reduced, and the data inquiry speed is increased.
Description
Technical field
The present invention relates to database application technical field, be specifically related to a kind of multilist data correlation enquiring and optimizing method and device.
Background technology
Database be according to data structure organize, the warehouse of store and management data, database has number of different types, for example database is divided into hierarchical data storehouse, reticular pattern database and relevant database conventionally.
In the Database Systems of prior art, data are stored in a database, when user needs data query, by writing structureization query language (SQL, Structured Query Language) statement sends inquiry request to Database Systems, Database Systems merge after obtaining corresponding data according to SQL statement from this database, and the data after merging are returned to user.
When cargo tracer table data, such scheme by prior art can obtain the data that need inquiry quickly, yet, growth along with data volume, data relationship in database also becomes increasingly complex, a data query tends to relate to multiple tables of data, and query logic can become along with the increasing of number of the tables of data of needs inquiries and becomes increasingly complex, now, during such scheme data query by prior art, to cause no small pressure to database, meanwhile, the inquiry velocity of data also will be affected.
Summary of the invention
The invention provides a kind of multilist data correlation enquiring and optimizing method and device, for reducing the pressure of database, improve the speed of data query.
First aspect present invention provides a kind of multilist data correlation enquiring and optimizing method, is applied to comprise in two above wide area information server systems, and above-mentioned data enquire method comprises:
If the data of requesting query relate to two above tables of data, the data of requesting query are divided into groups, the data that belong to same tables of data are divided in same inquiry group, wherein, belong to the data of different pieces of information table in different inquiry groups;
For each inquiry group, the corresponding database using while determining the data of inquiring about above-mentioned inquiry group, from the data of the above-mentioned inquiry group of above-mentioned data base querying;
The data that inquire all inquiry groups are merged to generated query result.
Second aspect present invention provides a kind of data query device, is applied to comprise in two above wide area information server systems, and above-mentioned database inquiry device comprises:
Inquiry split cells, when relating to more than two tables of data when the data of requesting query, the data of requesting query are divided into groups, the data that belong to same tables of data are divided in same inquiry group, wherein, the data that belong to different pieces of information table are in different inquiry groups;
Determining unit, for each the inquiry group splitting for above-mentioned inquiry split cells, the corresponding database using while determining the data of inquiring about above-mentioned inquiry group;
Query execution unit, for each the inquiry group splitting for above-mentioned inquiry split cells, that from above-mentioned determining unit, determines organizes corresponding database with inquiry, inquires about the data of above-mentioned inquiry group;
Merge cells, merges generated query result for the data of all inquiry groups that above-mentioned query execution unit is inquired.
Therefore, Database Systems in the present invention comprise plural database, when data query, the data of requesting query are divided into groups and determined the corresponding database using of each inquiry group, from established data storehouse, inquire about respectively the data of respective queries group, finally the data of all inquiry groups that inquire are merged, generated query result, on the one hand, based on technical scheme of the present invention, mass data separately can be left in a plurality of databases, reduce the pressure in individual data storehouse, on the other hand, technical scheme of the present invention is divided into a plurality of single table inquiries by multi-table query, simplified query logic, can obtain quickly Query Result, improved the speed of data query.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is embodiment schematic flow sheet of multilist data correlation enquiring and optimizing method provided by the invention;
Fig. 2 is another embodiment schematic flow sheet of multilist data correlation enquiring and optimizing method provided by the invention;
Fig. 3 is example structure schematic diagram of a kind of data query device provided by the invention.
Embodiment
For making goal of the invention of the present invention, feature, advantage can be more obvious and understandable, 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 only the present invention's part embodiment, but not whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
First explanation is, a kind of multilist data correlation enquiring and optimizing method in the embodiment of the present invention and data query application of installation are in Database Systems, these Database Systems comprise two above databases, user can be according to data type, data frequency of utilization, data are used distribution situation, the factors such as the size of data volume are carried out flexible distributed deployment to depositing of data, for example, tentation data storehouse system comprises database A and database B, the handling capacity of database A is higher than the handling capacity of database B, the larger tables of data of data volume can be left in database A, the less tables of data of data volume is left in database B, again for example, hot spot data (as the data of nearest 2 years) can be stored in database A, non-hot spot data (as the data before 2 years) is stored in database B, by rational deposit data, configure further Optimized Database System.
Below a kind of multilist data correlation enquiring and optimizing method in the embodiment of the present invention is described, refers to Fig. 1, the multilist data correlation enquiring and optimizing method in the embodiment of the present invention, comprising:
If the data of 101 requesting queries relate to two above tables of data,, the data of requesting query are divided into groups, the data that belong to same tables of data are divided in same inquiry group, wherein, belong to the data of different pieces of information table in different inquiry groups;
In the embodiment of the present invention, data query device is according to the tables of data under data, data to requesting query are divided into groups, the data that belong to same tables of data are divided in same inquiry group, and the data that belong to different pieces of information table are divided in different inquiry groups, to multi-table query is split as to a plurality of single table inquiries.
The embodiment of the present invention, data query device can be according to the tables of data under the allocation list data query in Database Systems and the stored database of each tables of data, concrete, the corresponding relation that allocation list comprises data rows sign and tables of data sign, the data rows of each data is designated known, therefore, data query device can be known the data rows under each data according to the data rows sign of the data of requesting query, further, according to the corresponding relation of the data rows sign comprising in allocation list and tables of data sign, know the tables of data that each data are affiliated, the data that belong to same tables of data are divided in same inquiry group, the data that belong to different pieces of information table are divided in different inquiry groups.It should be noted that, for some data, it may only belong to a tables of data, or, also may belong to a plurality of tables of data.
102,, for each inquiry group, the corresponding database using while determining the data of inquiring about this inquiry group, from the data of this inquiry group of this data base querying;
In the embodiment of the present invention, the different pieces of information of same tables of data can leave in disparate databases, for example, the data that in certain tables of data, frequency of utilization is high or recent data (as the data of nearest 1 month) can be left in memory database, by other deposit data for example, in other database (relevant database), therefore, after step 101, data query device is the corresponding database using while further determining the data of inquiring about this inquiry group, inquires about the data of this inquiry group from associated databases.
Alternatively, in one implementation, data query device is according to the enquiry frequency of the data of inquiry group, the corresponding database using while determining the data of the above-mentioned inquiry group of inquiry.Illustrate, tentation data storehouse system by enquiry frequency higher than the deposit data of certain predetermined frequency value in database A, by enquiry frequency not higher than the deposit data of this predetermined frequency value in database B, for enquiry frequency in inquiry group higher than the data of this predetermined frequency value, when data query device is determined these data of inquiry, the database of corresponding use is database A, for enquiry frequency in inquiry group, lower than the data of this predetermined frequency value, when data query device is determined these data of inquiry, the database of corresponding use is database B.
Alternatively, in another kind of implementation, data query device is according to the time interval scope of the data of inquiry group, the corresponding database using while determining the data of the above-mentioned inquiry group of inquiry.Illustrate, tentation data storehouse system by the deposit data before 2000 in certain tables of data in database A, by the deposit data of 2000 to 2010 in this tables of data in database B, by later deposit data in 2010 in database C, for the data of time interval scope before 2000 in inquiry group, when data query device is determined these data of inquiry, the database of corresponding use is database A, for the data of time interval scope between 2000 to 2010 in inquiry group, when data query device is determined these data of inquiry, the database of corresponding use is database B, for the data of time interval scope after 2010 in inquiry group, when data query device is determined these data of inquiry, the database of corresponding use is database C.It should be noted that, the time interval scope of data was determined according to the time of these data that record in Database Systems.
Alternatively, in another implementation, data query device is according to preset tables of data and the corresponding relation of database, the corresponding database using while determining the data of the above-mentioned inquiry group of inquiry.Illustrate, tentation data storehouse system leaves the larger tables of data (being assumed to be table 1) of data volume in database A in, the less tables of data of data volume (being assumed to be table 2) is left in database B, and at the preset table 1 of Database Systems and the corresponding relation of database A and the corresponding relation of table 2 and database B, for example, in the allocation list that can mention in step 101, configure 1 with the corresponding relation of database A and the corresponding relation of table 2 and database B, data query device is according to the corresponding relation of table 1 and database A, in the time of can determining the data in question blank 1, the corresponding database using is database B, according to the corresponding relation of table 2 and database B, while determining the data in question blank 2, the corresponding database using is database B.
When determine with the corresponding use of inquiry group database time, data query device can be according to the type of database, for example, after the assembled good query statement of data query algorithm (Oracle or SQL Server) that uses this database to support, send to this database, to inquire about the data of this inquiry group from this database, database, when receiving query statement, returns to the Query Result of this inquiry group to data query device according to this query statement.
In the embodiment of the present invention, can enable multithreading to the parallel processing of multiple queries group, multiple queries group is performed step to the operation in 102 simultaneously.
103, the data that inquire all inquiry groups are merged to generated query result;
Alternatively, in one implementation, the data rows that data query device contains according to the packet of requesting query generates ranks matrix bitmap, and wherein, the data rows that the row of above line column matrix bitmap contain with the packet of above-mentioned requesting query is corresponding one by one; According to default major key, by the data stuffing of each inquiry group inquiring, in above line column matrix bitmap, wherein, the row of above line column matrix bitmap is corresponding one by one with the data of above-mentioned default major key; Ranks matrix bitmap after padding data is defined as to above-mentioned Query Result.In the embodiment of the present invention, above-mentioned major key is also primary key, the one or more fields in tables of data, the value of major key is used for a certain record of identification data table uniquely, above-mentioned major key can be the major key of Database Systems acquiescence, or, also can be configured by User Defined, be not construed as limiting herein.
In above-mentioned implementation, the content pointers of data of each record of ranks matrix bitmap, optionally, for each position of ranks matrix bitmap arranges Data Identification position, for example, when certain Data Identification position of ranks matrix bitmap is invalid value (being 0), show that this position does not have padding data, for example, when certain Data Identification position of ranks matrix bitmap is effective value (being 1), show this position padding data.Data query device is according to default major key, the data stuffing of each inquiry group inquiring is in above line column matrix bitmap, concrete, in merging process, when the value of major key does not appear in ranks matrix bitmap, it in this ranks matrix bitmap, is newly-built a line of value of this major key.
In embodiments of the present invention, data query device also can merge the data that inquire all inquiry groups by alternate manner, for example, obstructed space column matrix bitmap and directly according to default major key, the data that inquire all inquiry groups being merged does not limit herein.
Further, after step 103, data query device outputs to display interface by the Query Result of generation and shows, or, if being upper layer application, data query initiates, data query device sends to this upper layer application by the Query Result of generation, so that this upper layer application utilizes Query Result to carry out data analysis or other operation.
It should be noted that, the type of database that the Database Systems in the embodiment of the present invention comprise includes but not limited to hierarchical data storehouse, reticular pattern database and relevant database.
Therefore, Database Systems in the present invention comprise plural database, when data query, the data of requesting query are divided into groups and determined the corresponding database using of each inquiry group, from established data storehouse, inquire about respectively the data of respective queries group, finally the data of all inquiry groups that inquire are merged, generated query result, on the one hand, based on technical scheme of the present invention, mass data separately can be left in a plurality of databases, reduce the pressure in individual data storehouse, on the other hand, technical scheme of the present invention is divided into a plurality of single table inquiries by multi-table query, simplified query logic, can obtain quickly Query Result, improved the speed of data query.
For ease of understanding better the multilist data correlation enquiring and optimizing method in the embodiment of the present invention, with an application scenarios, the multilist data correlation enquiring and optimizing method in the embodiment of the present invention is described below, refer to Fig. 2, comprising:
201, receive data query request;
Data query device receives data query request, and wherein, above-mentioned data query request may be from user, also may be from upper layer application.
Above-mentioned data query request comprises: the data rows sign of the data of requesting query.
Whether the data that 202, judge above-mentioned data query request requesting query relate to two above tables of data;
Data query device is the corresponding relation with tables of data according to data rows sign, whether the data that judge above-mentioned data query request requesting query relate to two above tables of data, if do not relate to two above tables of data, perform step 203 and step 207, if relate to two above tables of data, perform step 204 to 207.
203, fill order shows inquiry;
Particularly, single table inquiry can, with reference to the single table query scheme in existing database, repeat no more herein.
204, the data of requesting query are divided into groups, the data that belong to same tables of data are divided in same inquiry group, wherein, belong to the data of different pieces of information table in different inquiry groups;
Data query device divides into groups the data to requesting query, to multi-table query is split as to a plurality of single table inquiries.
The embodiment of the present invention, data query device can be according to the tables of data under the allocation list data query in Database Systems and the stored database of each tables of data, concrete, the corresponding relation that allocation list comprises data rows sign and tables of data sign, the data rows of each data is designated known, therefore, data query device can be known the data rows under each data according to the data rows sign of the data of requesting query, further, according to the corresponding relation of the data rows sign comprising in allocation list and tables of data sign, know the tables of data that each data are affiliated, the data that belong to same tables of data are divided in same inquiry group, the data that belong to different pieces of information table are divided in different inquiry groups.It should be noted that, for some data, it may only belong to a tables of data, or, also may belong to a plurality of tables of data.
205,, for each inquiry group, the corresponding database using while determining the data of inquiring about this inquiry group, from the data of this inquiry group of this data base querying;
The specific implementation of step 205 can, with reference to the description in step 102 embodiment illustrated in fig. 1, repeat no more herein.
206, the data that inquire all inquiry groups are merged to generated query result;
The specific implementation of step 206 can, with reference to the description in step 103 embodiment illustrated in fig. 1, repeat no more herein.
207, output Query Result;
Data query device outputs to display interface by final Query Result and shows, or, if data query is upper layer application, initiate, data query device sends to this upper layer application by final Query Result, so that this upper layer application utilizes Query Result to carry out data analysis or other operation.
It should be noted that, the type of database that the Database Systems in the embodiment of the present invention comprise includes but not limited to hierarchical data storehouse, reticular pattern database and relevant database.
Therefore, Database Systems in the present invention comprise plural database, when data query, the data of requesting query are divided into groups and determined the corresponding database using of each inquiry group, from established data storehouse, inquire about respectively the data of respective queries group, finally the data of all inquiry groups that inquire are merged, generated query result, on the one hand, based on technical scheme of the present invention, mass data separately can be left in a plurality of databases, reduce the pressure in individual data storehouse, on the other hand, technical scheme of the present invention is divided into a plurality of single table inquiries by multi-table query, simplified query logic, can obtain quickly Query Result, improved the speed of data query.
The embodiment of the present invention also provides a kind of data query device, and as shown in Figure 3, the data query device 300 in the embodiment of the present invention comprises:
Inquiry split cells 301, when relating to more than two tables of data when the data of requesting query, the data of requesting query are divided into groups, the data that belong to same tables of data are divided in same inquiry group, wherein, the data that belong to different pieces of information table are in different inquiry groups;
Determining unit 302, for each the inquiry group splitting for inquiry split cells 301, the corresponding database using while determining the data of inquiring about above-mentioned inquiry group;
Query execution unit 303, for each the inquiry group splitting for above-mentioned inquiry split cells, that from determining unit 302, determines organizes corresponding database with inquiry, inquires about the data of above-mentioned inquiry group;
Merge cells 304, merges generated query result for the data of all inquiry groups that query execution unit 303 is inquired.
Alternatively, determining unit 302 specifically for: according to the enquiry frequency of the data of inquiry group, the corresponding database using while determining the data of the above-mentioned inquiry group of inquiry.
Alternatively, determining unit 302 specifically for: according to the time interval scope of the data of inquiry group, the corresponding database using while determining the data of the above-mentioned inquiry group of inquiry.
Alternatively, determining unit 302 specifically for: according to preset tables of data and the corresponding relation of database, the corresponding database using while determining the data of the above-mentioned inquiry group of inquiry.
Alternatively, on basis embodiment illustrated in fig. 3, merge cells 304 comprises: generation unit, generates ranks matrix bitmap for the data rows containing according to the packet of above-mentioned requesting query, wherein, the data rows that the row of above line column matrix bitmap and the packet of above-mentioned requesting query contain is corresponding one by one; Data stuffing unit, for according to default major key, by the data stuffing of each inquiry group inquiring, in above line column matrix bitmap, wherein, the row of above line column matrix bitmap is corresponding one by one with the value of above-mentioned default major key; Sub-determining unit, for being defined as above-mentioned Query Result by the ranks matrix bitmap after padding data.
It should be noted that, data query device in the embodiment of the present invention can be as the data query device in above-mentioned embodiment of the method, can be for realizing the whole technical schemes in said method embodiment, the function of its each functional module can be according to the method specific implementation in said method embodiment, its specific implementation process can, with reference to the associated description in above-described embodiment, repeat no more herein.
In the several embodiment that provide in the application, should be understood that disclosed apparatus and method can realize by another way.For example, device embodiment described above is only schematic, for example, the division of described unit, be only that a kind of logic function is divided, during actual realization, can have other dividing mode, for example a plurality of unit or assembly can in conjunction with or can be integrated into another system, or some features can ignore, or do not carry out.Another point, shown or discussed coupling each other or direct-coupling or communication connection can be by some interfaces, indirect coupling or the communication connection of device or unit can be electrically, machinery or other form.
The described unit as separating component explanation can or can not be also physically to separate, and the parts that show as unit can be or can not be also physical locations, can be positioned at a place, or also can be distributed in a plurality of network element.Can select according to the actual needs some or all of unit wherein to realize the object of the present embodiment scheme.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, can be also that the independent physics of unit exists, and also can be integrated in a unit two or more unit.Above-mentioned integrated unit both can adopt the form of hardware to realize, and also can adopt the form of SFU software functional unit to realize.
If the form of SFU software functional unit of usining described integrated unit realizes and during as production marketing independently or use, can be stored in a computer read/write memory medium.Understanding based on such, the all or part of of the part that technical scheme of the present invention contributes to prior art in essence in other words or this technical scheme can embody with the form of software product, this computer software product is stored in a storage medium, comprise that some instructions are with so that a computer equipment (can be personal computer, server, or the network equipment etc.) carry out all or part of step of method described in each embodiment of the present invention.And aforesaid storage medium comprises: USB flash disk, portable hard drive, ROM (read-only memory) (ROM, Read-Only Memory), the various media that can be program code stored such as random access memory (RAM, Random Access Memory), magnetic disc or CD.
It should be noted that, for aforesaid each embodiment of the method, for easy description, therefore it is all expressed as to a series of combination of actions, but those skilled in the art should know, the present invention is not subject to the restriction of described sequence of movement, because according to the present invention, some step can adopt other order or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in instructions all belongs to preferred embodiment, and related action and module might not be all that the present invention is necessary.
In the above-described embodiments, the description of each embodiment is all emphasized particularly on different fields, in certain embodiment, there is no the part of detailed description, can be referring to the associated description of other embodiment.
It is more than the description of a kind of multilist data correlation enquiring and optimizing method provided by the present invention and device, for one of ordinary skill in the art, thought according to the embodiment of the present invention, all will change in specific embodiments and applications, to sum up, this description should not be construed as limitation of the present invention.
Claims (10)
1. a multilist data correlation enquiring and optimizing method, is characterized in that, is applied to comprise in two above wide area information server systems, and described data enquire method comprises:
If the data of requesting query relate to two above tables of data, the data of requesting query are divided into groups, the data that belong to same tables of data are divided in same inquiry group, wherein, belong to the data of different pieces of information table in different inquiry groups;
For each inquiry group, the corresponding database using while determining the data of inquiring about described inquiry group, from the data of inquiry group described in described data base querying;
The data that inquire all inquiry groups are merged to generated query result.
2. method according to claim 1, is characterized in that,
The corresponding database the using during data of the described inquiry group of described definite inquiry, comprising:
According to the enquiry frequency of the data of described inquiry group, the corresponding database using while determining the data of inquiring about described inquiry group.
3. method according to claim 1, is characterized in that,
The corresponding database the using during data of the described inquiry group of described definite inquiry, comprising:
According to the time interval scope of the data of described inquiry group, the corresponding database using while determining the data of inquiring about described inquiry group.
4. method according to claim 1, is characterized in that,
The corresponding database the using during data of the described inquiry group of described definite inquiry, comprising:
According to preset tables of data and the corresponding relation of database, the corresponding database using while determining the data of inquiring about described inquiry group.
5. according to the method described in claim 1 to 4 any one, it is characterized in that, described the data that inquire all inquiry groups are merged, generated query result, comprising:
The data rows containing according to the packet of described request inquiry generates ranks matrix bitmap, and wherein, the row of described ranks matrix bitmap are corresponding one by one with the data rows that the packet of described request inquiry contains;
According to default major key, by the data stuffing of each inquiry group inquiring, in described ranks matrix bitmap, wherein, the row of described ranks matrix bitmap is corresponding one by one with the value of described default major key;
Ranks matrix bitmap after padding data is defined as to described Query Result.
6. a data query device, is characterized in that, is applied to comprise in two above wide area information server systems, and described database inquiry device comprises:
Inquiry split cells, when relating to more than two tables of data when the data of requesting query, the data of requesting query are divided into groups, the data that belong to same tables of data are divided in same inquiry group, wherein, the data that belong to different pieces of information table are in different inquiry groups;
Determining unit, for each the inquiry group splitting for described inquiry split cells, the corresponding database using while determining the data of inquiring about described inquiry group;
Query execution unit, for each the inquiry group splitting for described inquiry split cells, that from described determining unit, determines organizes corresponding database with inquiry, inquires about the data of described inquiry group;
Merge cells, merges generated query result for the data of all inquiry groups that described query execution unit is inquired.
7. data query device according to claim 6, is characterized in that,
Described determining unit specifically for: according to the enquiry frequency of the data of inquiry group, the corresponding database using while determining the data of the described inquiry group of inquiry.
8. data query device according to claim 6, is characterized in that,
Described determining unit specifically for: according to the time interval scope of the data of inquiry group, the corresponding database using while determining the data of the described inquiry group of inquiry.
9. data query device according to claim 6, is characterized in that,
Described determining unit specifically for: according to preset tables of data and the corresponding relation of database, the corresponding database using while determining the data of the described inquiry group of inquiry.
10. according to the data query device described in claim 6 to 9 any one, it is characterized in that, described merge cells comprises:
Generation unit, generates ranks matrix bitmap for the data rows containing according to the packet of described request inquiry, and wherein, the row of described ranks matrix bitmap are corresponding one by one with the data rows that the packet of described request inquiry contains;
Data stuffing unit, for according to default major key, by the data stuffing of each inquiry group inquiring, in described ranks matrix bitmap, wherein, the row of described ranks matrix bitmap is corresponding one by one with the value of described default major key;
Sub-determining unit, for being defined as described Query Result by the ranks matrix bitmap after padding data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410339632.0A CN104112008A (en) | 2014-07-16 | 2014-07-16 | Multi-table data association inquiry optimizing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410339632.0A CN104112008A (en) | 2014-07-16 | 2014-07-16 | Multi-table data association inquiry optimizing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104112008A true CN104112008A (en) | 2014-10-22 |
Family
ID=51708799
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410339632.0A Pending CN104112008A (en) | 2014-07-16 | 2014-07-16 | Multi-table data association inquiry optimizing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104112008A (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015184762A1 (en) * | 2014-11-06 | 2015-12-10 | 中兴通讯股份有限公司 | Database query method and device |
| CN106445968A (en) * | 2015-08-11 | 2017-02-22 | 阿里巴巴集团控股有限公司 | Data merging method and device |
| CN106933934A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The connection method of tables of data and device |
| CN106933914A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The data processing method and device of many tables of data |
| CN106933927A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The connection method of tables of data and device |
| CN107273525A (en) * | 2017-06-23 | 2017-10-20 | 上海携程商务有限公司 | Functional expression querying method and system |
| CN107515916A (en) * | 2017-08-18 | 2017-12-26 | 北京奇虎科技有限公司 | The performance optimization method and device of data query |
| CN107545005A (en) * | 2016-06-28 | 2018-01-05 | 华为软件技术有限公司 | A kind of data processing method and device |
| CN107609091A (en) * | 2017-09-08 | 2018-01-19 | 国云科技股份有限公司 | A kind of inter-library multilist conjunctive query system and its implementation |
| CN109710789A (en) * | 2018-12-28 | 2019-05-03 | 北京旷视科技有限公司 | Search method, device, electronic equipment and the computer storage medium of image data |
| CN110597849A (en) * | 2018-05-25 | 2019-12-20 | 北京国双科技有限公司 | Data query method and device |
| CN111581237A (en) * | 2019-02-15 | 2020-08-25 | 阿里巴巴集团控股有限公司 | Data query method, device and system and electronic equipment |
| CN112559306A (en) * | 2020-11-17 | 2021-03-26 | 贝壳技术有限公司 | User behavior track obtaining method and device and electronic equipment |
| CN112612818A (en) * | 2020-12-21 | 2021-04-06 | 贝壳技术有限公司 | Data processing method and device, computing equipment and storage medium |
| CN113254427A (en) * | 2021-07-15 | 2021-08-13 | 深圳市同富信息技术有限公司 | Database expansion method and device |
| CN117131078A (en) * | 2023-10-20 | 2023-11-28 | 天津南大通用数据技术股份有限公司 | Cross-distribution mode-based associated query optimization method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1556482A (en) * | 2003-12-31 | 2004-12-22 | 中兴通讯股份有限公司 | Data processing method for realizing data base multitable inguiry |
| CN101165683A (en) * | 2006-10-19 | 2008-04-23 | 维豪信息技术有限公司 | Heterogeneous different source different platform data integration method and exchange method |
| CN102163195A (en) * | 2010-02-22 | 2011-08-24 | 北京东方通科技股份有限公司 | Query optimization method based on unified view of distributed heterogeneous database |
| CN103106261A (en) * | 2013-01-28 | 2013-05-15 | 中国电子科技集团公司第二十八研究所 | Distributed query method based on narrow-band cloud data service |
| CN103914471A (en) * | 2012-12-31 | 2014-07-09 | 北京启明星辰信息技术股份有限公司 | Mass event processing method and device |
-
2014
- 2014-07-16 CN CN201410339632.0A patent/CN104112008A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1556482A (en) * | 2003-12-31 | 2004-12-22 | 中兴通讯股份有限公司 | Data processing method for realizing data base multitable inguiry |
| CN101165683A (en) * | 2006-10-19 | 2008-04-23 | 维豪信息技术有限公司 | Heterogeneous different source different platform data integration method and exchange method |
| CN102163195A (en) * | 2010-02-22 | 2011-08-24 | 北京东方通科技股份有限公司 | Query optimization method based on unified view of distributed heterogeneous database |
| CN103914471A (en) * | 2012-12-31 | 2014-07-09 | 北京启明星辰信息技术股份有限公司 | Mass event processing method and device |
| CN103106261A (en) * | 2013-01-28 | 2013-05-15 | 中国电子科技集团公司第二十八研究所 | Distributed query method based on narrow-band cloud data service |
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105574052A (en) * | 2014-11-06 | 2016-05-11 | 中兴通讯股份有限公司 | Database query method and apparatus |
| WO2015184762A1 (en) * | 2014-11-06 | 2015-12-10 | 中兴通讯股份有限公司 | Database query method and device |
| CN106445968A (en) * | 2015-08-11 | 2017-02-22 | 阿里巴巴集团控股有限公司 | Data merging method and device |
| CN106933927B (en) * | 2015-12-31 | 2019-12-10 | 北京国双科技有限公司 | Data table connection method and device |
| CN106933934A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The connection method of tables of data and device |
| CN106933914A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The data processing method and device of many tables of data |
| CN106933927A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The connection method of tables of data and device |
| CN106933934B (en) * | 2015-12-31 | 2020-02-28 | 北京国双科技有限公司 | Data table connection method and device |
| CN107545005A (en) * | 2016-06-28 | 2018-01-05 | 华为软件技术有限公司 | A kind of data processing method and device |
| CN107273525A (en) * | 2017-06-23 | 2017-10-20 | 上海携程商务有限公司 | Functional expression querying method and system |
| CN107515916B (en) * | 2017-08-18 | 2020-12-04 | 北京奇虎科技有限公司 | Performance optimization method and device for data query |
| CN107515916A (en) * | 2017-08-18 | 2017-12-26 | 北京奇虎科技有限公司 | The performance optimization method and device of data query |
| CN107609091A (en) * | 2017-09-08 | 2018-01-19 | 国云科技股份有限公司 | A kind of inter-library multilist conjunctive query system and its implementation |
| CN107609091B (en) * | 2017-09-08 | 2020-10-27 | 国云科技股份有限公司 | Method for realizing cross-database multi-table combined query system |
| CN110597849A (en) * | 2018-05-25 | 2019-12-20 | 北京国双科技有限公司 | Data query method and device |
| CN109710789A (en) * | 2018-12-28 | 2019-05-03 | 北京旷视科技有限公司 | Search method, device, electronic equipment and the computer storage medium of image data |
| CN111581237A (en) * | 2019-02-15 | 2020-08-25 | 阿里巴巴集团控股有限公司 | Data query method, device and system and electronic equipment |
| CN111581237B (en) * | 2019-02-15 | 2023-06-09 | 阿里巴巴集团控股有限公司 | Data query method, device and system and electronic equipment |
| CN112559306A (en) * | 2020-11-17 | 2021-03-26 | 贝壳技术有限公司 | User behavior track obtaining method and device and electronic equipment |
| CN112559306B (en) * | 2020-11-17 | 2022-11-15 | 贝壳技术有限公司 | User behavior track obtaining method and device and electronic equipment |
| CN112612818A (en) * | 2020-12-21 | 2021-04-06 | 贝壳技术有限公司 | Data processing method and device, computing equipment and storage medium |
| CN113254427A (en) * | 2021-07-15 | 2021-08-13 | 深圳市同富信息技术有限公司 | Database expansion method and device |
| CN117131078A (en) * | 2023-10-20 | 2023-11-28 | 天津南大通用数据技术股份有限公司 | Cross-distribution mode-based associated query optimization method |
| CN117131078B (en) * | 2023-10-20 | 2024-02-06 | 天津南大通用数据技术股份有限公司 | Cross-distribution mode-based associated query optimization method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104112008A (en) | Multi-table data association inquiry optimizing method and device | |
| US8782324B1 (en) | Techniques for managing placement of extents based on a history of active extents | |
| CN103577440B (en) | A kind of data processing method and device in non-relational database | |
| CN104021161B (en) | A kind of clustering storage method and device | |
| US7181460B2 (en) | User-defined aggregate functions in database systems without native support | |
| CN102725753B (en) | Method and apparatus for optimizing data access, method and apparatus for optimizing data storage | |
| CN104714972B (en) | Database divides table foundation and querying method | |
| US9195701B2 (en) | System and method for flexible distributed massively parallel processing (MPP) database | |
| CN103020174A (en) | Similarity analysis method, device and system | |
| CN102682108B (en) | Row and line mixed database storage method | |
| CN103703467A (en) | Method and apparatus for storing data | |
| US8005836B2 (en) | Method and system for performing logical partial declustering | |
| CN107491487A (en) | A kind of full-text database framework and bitmap index establishment, data query method, server and medium | |
| CN103294702A (en) | Data processing method, device and system | |
| CN105117417A (en) | Read-optimized memory database Trie tree index method | |
| CN103902702A (en) | Data storage system and data storage method | |
| US20200042538A1 (en) | Methods and apparatus to partition a database | |
| CN104346458A (en) | Data storage method and device | |
| CN102521304A (en) | Hash based clustered table storage method | |
| CN102043589B (en) | Disk array capacity expansion method and system | |
| US10353610B1 (en) | Method, apparatus and computer program product for configuring a data storage system | |
| CN101997919A (en) | Storage resource management method and device | |
| US20200042634A1 (en) | Methods and apparatus to partition a database | |
| CN107451142B (en) | Method and apparatus for writing and querying data in database, management system and computer-readable storage medium thereof | |
| CN101452486A (en) | System data management method for [inscriptions on bones or tortoise shells and apparatus thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C53 | Correction of patent of invention or patent application | ||
| CB02 | Change of applicant information |
Address after: 518000 Guangdong city of Shenzhen province Nanshan District two road Nantou checkpoint Gateway Industrial Park 30 building 3 floor forward hot electrons Applicant after: GTA INFORMATION TECHNOLOGY CO., LTD. (GTA) Address before: 518000 Guangdong city of Shenzhen province Nanshan District two road Nantou checkpoint Gateway Industrial Park 30 building 3 floor forward hot electrons Applicant before: Shenzhen GTA Information Technology Co., Ltd. |
|
| COR | Change of bibliographic data |
Free format text: CORRECT: APPLICANT; FROM: SHENZHEN GTA INFORMATION TECHNOLOGY CO., LTD. TO: SHENZHEN GUOTAIAN EDUCATION TECHNOLOGY CO., LTD. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20141022 |