CN104598652A - Database inquiry method and database inquiry device - Google Patents
Database inquiry method and database inquiry device Download PDFInfo
- Publication number
- CN104598652A CN104598652A CN201510092451.7A CN201510092451A CN104598652A CN 104598652 A CN104598652 A CN 104598652A CN 201510092451 A CN201510092451 A CN 201510092451A CN 104598652 A CN104598652 A CN 104598652A
- Authority
- CN
- China
- Prior art keywords
- field data
- field
- index
- partition
- querying condition
- 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/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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- 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
- G06F16/24534—Query rewriting; Transformation
- G06F16/24535—Query rewriting; Transformation of sub-queries or views
Abstract
The invention discloses a database inquiry method and a database inquiry device and belongs to the technical field of the Internet. The method comprises the following steps: receiving an inquiry request aiming at a target data table, wherein the inquiry request comprises an inquiry condition; acquiring a global index corresponding to the target data table, wherein the global index is correspondence of split field data and index field data in the target data table and the index fields comprise other fields in the target data table expect the split fields; inquiring the split field data which satisfy the inquiry condition in the global index; inquiring inquiry records corresponding to the split field data which satisfies the inquiry condition in storage sub-libraries corresponding to the target data table. According to the method and device disclosed by the invention, the calculated quantity in the inquiry process of other fields except the split fields is reduced, and the inquiry efficiency in the inquiry process is improved.
Description
Technical field
The present invention relates to database field, particularly a kind of data base query method and device.
Background technology
Along with the development of internet, quantity of information increases progressively with geometry rank, and in legacy data storehouse, data volume is increasing, and the time that the mode of inquiring about whole tables of data consumes is more and more longer.
In order to reduce the query time to tables of data, by original tables of data with one of them critical field for partition field carry out level fractionation, the record of legacy data table is dispersed in multiple points of storehouses, and record partition field and each point of storehouse between corresponding relation.Such as: include id in Table A, the fields such as name, creat_time are totally one ten thousand records, id is divided into 10 points of storehouses as partition field, wherein preserves 1,000 records in each point of storehouse.In the query script for partition field, inquire about point storehouse at this partition field place in the corresponding relation first between partition field and each point of storehouse, and in point storehouse inquired, directly get the query note corresponding to this partition field.
Inventor finds that prior art at least exists following problem:
For the query script of other fields beyond partition field, then need to inquire about in multiple even all point storehouses, partial query demand can produce the intermediate data and extra computation that are multiple times than Query Result, therefore query time consumption process is caused, system consumption resource is excessive, and search efficiency is low.
If prior art needs the query script realizing example in step 302, then need in each point of storehouse, choose 100 records satisfied condition, then the record chosen in each point of storehouse is sorted, finally choose front 100 records.
The embodiment of the present invention additionally provides a kind of method upgrading global index in data base query method, and see Fig. 4, the method comprises:
401: receive the update request for target matrix, at least comprise the partition field data involved by renewal in update request, field to be updated and more new data corresponding to field to be updated.
All need to upgrade global index at each renewal rewards theory for target matrix, can ensure in follow-up query script that the data in global index are up-to-date content, and then ensure to find correct query note.Wherein, renewal rewards theory can comprise: increase record, deletion record, the modes such as amendment record.
402: in the global index that target matrix is corresponding, obtain the global index that index field data belong to field to be updated.
First need to find this upgrade involved by global index, namely obtain the global index that index field is field to be updated in this update request.
403: the partition field data involved by renewal and the more new data in field to be updated, upgrade the global index that index field data belong to field to be updated.
According to the partition field that update request comprises, search the record needing to need in the corresponding relation to break field data and index field data to upgrade, and according to this record of renewal Data Update in field to be updated.
The embodiment of the present invention is when receiving the inquiry request for target matrix, obtain the global index that target matrix is corresponding, and inquiry meets the partition field data of querying condition in this global index, finally divide in storehouse in each storage that target matrix is corresponding, inquiry meets query note corresponding to the partition field data of querying condition, obtains final Query Result.Reduce for the calculated amount in the query script of other fields beyond partition field, improve the search efficiency in this query script.
Summary of the invention
In order to solve the problem of prior art, embodiments provide a kind of data base query method and device.Described technical scheme is as follows:
On the one hand, provide a kind of database checking method, described method comprises:
Receive the inquiry request for target matrix, described inquiry request comprises querying condition;
Obtain the global index corresponding with described target matrix, described global index is the corresponding relation of partition field data in described target matrix and index field data, and described index field is other fields in described target matrix except described partition field;
In described global index, inquiry meets the partition field data of described querying condition;
The each storage corresponding at described target matrix divides in storehouse, and inquiry meets query note corresponding to the partition field data of described querying condition.
Optionally, the global index that described acquisition is corresponding with described target matrix, comprising:
Obtain the field to be checked in described querying condition;
The global index that index field data belong to described field to be checked is obtained in the global index that described target matrix is corresponding.
Optionally, described in described global index inquiry meet the partition field data of described querying condition, comprising:
In the global index that index field data belong to for described field to be checked, inquiry meets the field data to be checked of described querying condition, and partition field data corresponding for the field data to be checked meeting described querying condition is defined as the partition field data meeting described querying condition.
Optionally, the described each storage corresponding at described target matrix divides in storehouse, and inquiry meets query note corresponding to the partition field data of described querying condition, comprising:
The partition field data prestored with store in the corresponding relation in point storehouse, acquisition meets storage point storehouse corresponding to the partition field data of described querying condition;
In the described storage point storehouse determined, inquiry meets query note corresponding to the partition field data of described querying condition.
Optionally, described method also comprises:
Receive the update request for described target matrix, in described update request, at least comprise the partition field data involved by renewal, field to be updated and more new data corresponding to described field to be updated;
In the global index that described target matrix is corresponding, obtain the global index that index field data belong to described field to be updated;
More new data in partition field data involved by described renewal and described field to be updated, upgrades the global index that index field data belong to described field to be updated.
On the other hand, provide a kind of database and look into device, described device comprises:
First receiver module, for receiving the inquiry request for target matrix, described inquiry request comprises querying condition;
First acquisition module, for obtaining the global index corresponding with described target matrix, described global index is the corresponding relation of partition field data in described target matrix and index field data, and described index field is other fields in described target matrix except described partition field;
First enquiry module, meets the partition field data of described querying condition for inquiry in described global index;
Second enquiry module, divides in storehouse for each storage corresponding at described target matrix, and inquiry meets query note corresponding to the partition field data of described querying condition.
Optionally, described first acquisition module, comprising:
First acquiring unit, for obtaining the field to be checked in described querying condition;
Second acquisition unit, belongs to the global index of described field to be checked for obtaining index field data in the global index that described target matrix is corresponding.
Optionally, described first enquiry module is used for:
In the global index that index field data belong to for described field to be checked, inquiry meets the field data to be checked of described querying condition, and partition field data corresponding for the field data to be checked meeting described querying condition is defined as the partition field data meeting described querying condition.
Optionally, described second enquiry module, comprising:
3rd acquiring unit, for the partition field data prestored with store in the corresponding relation in point storehouse, acquisition meets storage point storehouse corresponding to the partition field data of described querying condition;
Query unit, in the described storage point storehouse determined, inquiry meets query note corresponding to the partition field data of described querying condition.
Optionally, described device also comprises:
Second receiver module, for receiving the update request for described target matrix, at least comprises the partition field data involved by renewal in described update request, field to be updated and more new data corresponding to described field to be updated;
Second acquisition module, in the global index that described target matrix is corresponding, obtains the global index that index field data belong to described field to be updated;
Update module, for the more new data in the partition field data involved by described renewal and described field to be updated, upgrades the global index that index field data belong to described field to be updated.
The beneficial effect that the technical scheme that the embodiment of the present invention provides is brought is:
When receiving the inquiry request for target matrix, obtain the global index that target matrix is corresponding, and inquiry meets the partition field data of querying condition in this global index, finally divide in storehouse in each storage that target matrix is corresponding, inquiry meets query note corresponding to the partition field data of querying condition, obtains final Query Result.Reduce for the calculated amount in the query script of other fields beyond partition field, improve the search efficiency in this query script.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present invention, below the accompanying drawing used required in describing embodiment is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the data base query method process flow diagram that the embodiment of the present invention one provides;
Fig. 2 is overall architecture schematic diagram in the data base query method that provides of the embodiment of the present invention one;
Fig. 3 is the data base query method process flow diagram that the embodiment of the present invention two provides;
Fig. 4 is the method flow diagram upgrading global index in the data base query method that provides of the embodiment of the present invention three;
Fig. 5 is the database inquiry device structural representation that the embodiment of the present invention four provides.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly, below in conjunction with accompanying drawing, embodiment of the present invention is described further in detail.
Embodiment one
Embodiments provide a kind of data base query method, see Fig. 1.
101: receive the inquiry request for target matrix, inquiry request comprises querying condition;
102: obtain the global index corresponding with target matrix, global index is the corresponding relation of partition field data in target matrix and index field data, and index field is other fields in target matrix except partition field;
103: in global index, inquiry meets the partition field data of querying condition;
104: each storage corresponding at target matrix divides in storehouse, inquiry meets query note corresponding to the partition field data of querying condition.
Wherein, in a database in each tables of data according to query demand, generate the global index that each tables of data is corresponding in advance, the global index that wherein each tables of data is corresponding can be one or more.Such as: in Table A, include field: id, name, creat_time etc., Table A has carried out the global index that can generate the corresponding relation of id field data and name field data after partition processes according to query demand respectively according to id as partition field, and the global index of the corresponding relation of id field data and creat_time field data.Above-mentioned Liang Ge global index can be arranged in different database servers and carry out safeguarding to avoid that the data volume of global index is excessive server is caused to over-burden, also can be arranged in same database server and safeguard, further, if the data volume of global index exceedes certain predetermined threshold value, also can carry out breaking for global index obtains multiple index partition corresponding to same global index.Wherein, in advance global index is loaded in the internal memory in database server, and in internal memory, carries out the query manipulation to global index.
Further, regular backup operation can also be carried out in other database servers for each global index.
Wherein, the overall architecture of the embodiment of the present invention as shown in Figure 2, wherein unified interface be inquiry to database, increase, delete, the communication interface of the operation such as amendment; Routing layer comprises each global index generated according to each partition field in each tables of data of database, such as: global index 1_1, and global index 1_2, global index 2; Wherein, global index 1_1 and global index 1_2 belongs to the global index comprising same partition field, " global index of the corresponding relation of id field data and name field data " and " global index of the corresponding relation of id field data and creat_time field data " as above in example.Database Systems safeguard each global index in routing layer, and any write operation related in database all can upgrade corresponding global index.Wherein, also comprise each point of storehouse that each tables of data is corresponding in overall architecture, each point of storehouse is distinguished by subregion key mark.
In addition, also include routing layer backup in overall architecture, each global index in this routing layer backup meeting periodic synchronization routing layer carries out backup operation.
Optionally, global index can share on disparate databases server and safeguards, database server maintenance global index, avoids the excessive unit of index to bear.If individual data storehouse server cannot bear a larger global index, index partition can be carried out according to the service condition of this index.
The embodiment of the present invention is when receiving the inquiry request for target matrix, obtain the global index that target matrix is corresponding, and inquiry meets the partition field data of querying condition in this global index, finally divide in storehouse in each storage that target matrix is corresponding, inquiry meets query note corresponding to the partition field data of querying condition, obtains final Query Result.Reduce for the calculated amount in the query script of other fields beyond partition field, improve the search efficiency in this query script.
Embodiment two
Embodiments provide a kind of data base query method, see Fig. 3.
301: receive the inquiry request for target matrix, inquiry request comprises querying condition.
Wherein, the querying condition in inquiry request can be query sentence of database.Accordingly, need in query statement to comprise target matrix to be checked, field to be checked and condition.Such as: SELECT*fromname WHERE birthday='2011-04-08', wherein name is target matrix to be checked, birthday is the field to be checked during this name shows, condition be inquire about in birthday field belong to ' the record of 2011-04-08'.
302: obtain the global index corresponding with target matrix, global index is the corresponding relation of partition field data in target matrix and index field data, and index field is other fields in target matrix except partition field.
Wherein, step 302 can be realized by following steps:
3021: obtain the field to be checked in querying condition;
3022: in the global index that target matrix is corresponding, obtain the global index that index field data belong to field to be checked.
Such as: in Table A, include field: id, name, creat_time, Table A has carried out breaking process according to id field as partition field, in the inquiry request received, target matrix is A, field to be checked is creat_time field, and condition is inquire about 100 nearest in one day records of creat_time field.Therefore, needing to obtain index field data in global index corresponding to A table in step 202. and belong to the global index of creat_time field, accordingly, is the global index of the corresponding relation of id field data and creat_time field data.
303: in global index, inquiry meets the partition field data of querying condition.
Wherein, step 303 can be realized by following steps:
In the global index that index field data belong to for field to be checked, inquiry meets the field data to be checked of querying condition, and partition field data corresponding for the field data to be checked meeting querying condition is defined as the partition field data meeting querying condition.
Concrete, query script is in the corresponding relation of id field data and creat_time field data, inquiry meets 100 nearest in one day records of creat_time field data, wherein first inquire the 100 creat_time field datas meeting querying condition, and be defined as partition field data corresponding for each creat_time field data inquired to meet the partition field data of querying condition, now obtain 100 partition field datas.
304: each storage corresponding at target matrix divides in storehouse, inquiry meets query note corresponding to the partition field data of querying condition.
Wherein, step 304 can be realized by following steps:
3041: the partition field data prestored with store in the corresponding relation in point storehouse, acquisition meets storage point storehouse corresponding to the partition field data of querying condition.
Wherein, by 100 partition fields this step of execution one by one obtained in step 303, the mark in the storage point storehouse of each correspondence in 100 partition fields is determined one by one.Accordingly, the mark in the storage point storehouse that each partition field is corresponding in 100 partition fields can be determined.
3042: in the storage point storehouse determined, inquiry meets query note corresponding to the partition field data of querying condition.
In units of each storage satisfied condition point storehouse, generate for query statement corresponding to each storage point storehouse, its querying condition is " the partition field data belonging to this storage point storehouse in corresponding above-mentioned 100 the partition field datas of partition field ".
Embodiment three
Embodiments provide a kind of database inquiry device, see Fig. 5, this device comprises:
First receiver module 501, for receiving the inquiry request for target matrix, inquiry request comprises querying condition;
First acquisition module 502, for obtaining the global index corresponding with target matrix, global index is the corresponding relation of partition field data in target matrix and index field data, and index field is other fields in target matrix except partition field;
First enquiry module 503, meets the partition field data of querying condition for inquiry in global index;
Second enquiry module 504, divides in storehouse for each storage corresponding at target matrix, and inquiry meets query note corresponding to the partition field data of querying condition.
Wherein, the first acquisition module 501, comprising:
First acquiring unit, for obtaining the field to be checked in querying condition;
Second acquisition unit, for obtaining the global index that index field data belong to field to be checked in the global index that target matrix is corresponding.
Wherein, the first enquiry module 503 for:
In the global index that index field data belong to for field to be checked, inquiry meets the field data to be checked of querying condition, and partition field data corresponding for the field data to be checked meeting querying condition is defined as the partition field data meeting querying condition.
Wherein, the second enquiry module 504, comprising:
3rd acquiring unit, for the partition field data prestored with store in the corresponding relation in point storehouse, acquisition meets storage point storehouse corresponding to the partition field data of querying condition;
Query unit, in the storage point storehouse determined, inquiry meets query note corresponding to the partition field data of querying condition.
Wherein, device also comprises:
Second receiver module 505, for receiving the update request for target matrix, at least comprises the partition field data involved by renewal in update request, field to be updated and more new data corresponding to field to be updated;
Second acquisition module 506, in the global index that target matrix is corresponding, obtains the global index that index field data belong to field to be updated;
Update module 507, for the partition field data involved by renewal and the more new data in field to be updated, upgrades the global index that index field data belong to field to be updated.
The embodiment of the present invention is when receiving the inquiry request for target matrix, obtain the global index that target matrix is corresponding, and inquiry meets the partition field data of querying condition in this global index, finally divide in storehouse in each storage that target matrix is corresponding, inquiry meets query note corresponding to the partition field data of querying condition, obtains final Query Result.Reduce for the calculated amount in the query script of other fields beyond partition field, improve the search efficiency in this query script.
The invention described above embodiment sequence number, just to describing, does not represent the quality of embodiment.
One of ordinary skill in the art will appreciate that all or part of step realizing above-described embodiment can have been come by hardware, the hardware that also can carry out instruction relevant by program completes, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium mentioned can be ROM (read-only memory), disk or CD etc.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a data base query method, is characterized in that, described method comprises:
Receive the inquiry request for target matrix, described inquiry request comprises querying condition;
Obtain the global index corresponding with described target matrix, described global index is the corresponding relation of partition field data in described target matrix and index field data, and described index field is other fields in described target matrix except described partition field;
In described global index, inquiry meets the partition field data of described querying condition;
The each storage corresponding at described target matrix divides in storehouse, and inquiry meets query note corresponding to the partition field data of described querying condition.
2. method according to claim 1, is characterized in that, the global index that described acquisition is corresponding with described target matrix, comprising:
Obtain the field to be checked in described querying condition;
The global index that index field data belong to described field to be checked is obtained in the global index that described target matrix is corresponding.
3. method according to claim 2, is characterized in that, described in described global index inquiry meet the partition field data of described querying condition, comprising:
In the global index that index field data belong to for described field to be checked, inquiry meets the field data to be checked of described querying condition, and partition field data corresponding for the field data to be checked meeting described querying condition is defined as the partition field data meeting described querying condition.
4. method according to claim 1, is characterized in that, the described each storage corresponding at described target matrix divides in storehouse, and inquiry meets query note corresponding to the partition field data of described querying condition, comprising:
The partition field data prestored with store in the corresponding relation in point storehouse, acquisition meets storage point storehouse corresponding to the partition field data of described querying condition;
In the described storage point storehouse determined, inquiry meets query note corresponding to the partition field data of described querying condition.
5. method according to claim 1, is characterized in that, described method also comprises:
Receive the update request for described target matrix, in described update request, at least comprise the partition field data involved by renewal, field to be updated and more new data corresponding to described field to be updated;
In the global index that described target matrix is corresponding, obtain the global index that index field data belong to described field to be updated;
More new data in partition field data involved by described renewal and described field to be updated, upgrades the global index that index field data belong to described field to be updated.
6. a database inquiry device, is characterized in that, described device comprises:
First receiver module, for receiving the inquiry request for target matrix, described inquiry request comprises querying condition;
First acquisition module, for obtaining the global index corresponding with described target matrix, described global index is the corresponding relation of partition field data in described target matrix and index field data, and described index field is other fields in described target matrix except described partition field;
First enquiry module, meets the partition field data of described querying condition for inquiry in described global index;
Second enquiry module, divides in storehouse for each storage corresponding at described target matrix, and inquiry meets query note corresponding to the partition field data of described querying condition.
7. device according to claim 6, is characterized in that, described first acquisition module, comprising:
First acquiring unit, for obtaining the field to be checked in described querying condition;
Second acquisition unit, belongs to the global index of described field to be checked for obtaining index field data in the global index that described target matrix is corresponding.
8. device according to claim 7, is characterized in that, described first enquiry module is used for:
In the global index that index field data belong to for described field to be checked, inquiry meets the field data to be checked of described querying condition, and partition field data corresponding for the field data to be checked meeting described querying condition is defined as the partition field data meeting described querying condition.
9. device according to claim 6, is characterized in that, described second enquiry module, comprising:
3rd acquiring unit, for the partition field data prestored with store in the corresponding relation in point storehouse, acquisition meets storage point storehouse corresponding to the partition field data of described querying condition;
Query unit, in the described storage point storehouse determined, inquiry meets query note corresponding to the partition field data of described querying condition.
10. device according to claim 6, is characterized in that, described device also comprises:
Second receiver module, for receiving the update request for described target matrix, at least comprises the partition field data involved by renewal in described update request, field to be updated and more new data corresponding to described field to be updated;
Second acquisition module, in the global index that described target matrix is corresponding, obtains the global index that index field data belong to described field to be updated;
Update module, for the more new data in the partition field data involved by described renewal and described field to be updated, upgrades the global index that index field data belong to described field to be updated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510092451.7A CN104598652B (en) | 2015-02-14 | 2015-02-14 | A kind of data base query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510092451.7A CN104598652B (en) | 2015-02-14 | 2015-02-14 | A kind of data base query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104598652A true CN104598652A (en) | 2015-05-06 |
| CN104598652B CN104598652B (en) | 2017-11-24 |
Family
ID=53124437
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510092451.7A Active CN104598652B (en) | 2015-02-14 | 2015-02-14 | A kind of data base query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104598652B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106802891A (en) * | 2015-11-26 | 2017-06-06 | 中国电信股份有限公司 | The querying method of the non-burst field of distributed data base, system and equipment |
| CN106959970A (en) * | 2016-01-12 | 2017-07-18 | 北京搜狗科技发展有限公司 | Dictionary, the processing method of dictionary, device and the device for handling dictionary |
| CN110019211A (en) * | 2017-11-27 | 2019-07-16 | 北京京东尚科信息技术有限公司 | The methods, devices and systems of association index |
| CN110222054A (en) * | 2019-05-22 | 2019-09-10 | 福建大屏网络科技有限公司 | A kind of method, apparatus, terminal device and storage medium improving retrieval rate |
| CN111221883A (en) * | 2018-11-27 | 2020-06-02 | 浙江宇视科技有限公司 | Data statistical method and system |
| CN111221883B (en) * | 2018-11-27 | 2024-04-26 | 浙江宇视科技有限公司 | Data statistics method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102999526A (en) * | 2011-09-16 | 2013-03-27 | 阿里巴巴集团控股有限公司 | Splitting and inquiring method and system of database relational table |
| CN102999519A (en) * | 2011-09-15 | 2013-03-27 | 上海盛付通电子商务有限公司 | Read-write method and system for database |
| CN103020054A (en) * | 2011-09-20 | 2013-04-03 | 深圳市金蝶中间件有限公司 | Fuzzy query method and system |
| WO2013147785A1 (en) * | 2012-03-29 | 2013-10-03 | Hitachi Data Systems Corporation | Highly available search index with storage node addition and removal |
| CN104008199A (en) * | 2014-06-16 | 2014-08-27 | 北京京东尚科信息技术有限公司 | Data inquiring method |
| CN104199881A (en) * | 2014-08-21 | 2014-12-10 | 广州华多网络科技有限公司 | Database cluster, data query method and data synchronism method and device |
-
2015
- 2015-02-14 CN CN201510092451.7A patent/CN104598652B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102999519A (en) * | 2011-09-15 | 2013-03-27 | 上海盛付通电子商务有限公司 | Read-write method and system for database |
| CN102999526A (en) * | 2011-09-16 | 2013-03-27 | 阿里巴巴集团控股有限公司 | Splitting and inquiring method and system of database relational table |
| CN103020054A (en) * | 2011-09-20 | 2013-04-03 | 深圳市金蝶中间件有限公司 | Fuzzy query method and system |
| WO2013147785A1 (en) * | 2012-03-29 | 2013-10-03 | Hitachi Data Systems Corporation | Highly available search index with storage node addition and removal |
| CN104008199A (en) * | 2014-06-16 | 2014-08-27 | 北京京东尚科信息技术有限公司 | Data inquiring method |
| CN104199881A (en) * | 2014-08-21 | 2014-12-10 | 广州华多网络科技有限公司 | Database cluster, data query method and data synchronism method and device |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106802891A (en) * | 2015-11-26 | 2017-06-06 | 中国电信股份有限公司 | The querying method of the non-burst field of distributed data base, system and equipment |
| CN106959970A (en) * | 2016-01-12 | 2017-07-18 | 北京搜狗科技发展有限公司 | Dictionary, the processing method of dictionary, device and the device for handling dictionary |
| CN106959970B (en) * | 2016-01-12 | 2022-04-19 | 北京搜狗科技发展有限公司 | Word bank, processing method and device of word bank and device for processing word bank |
| CN110019211A (en) * | 2017-11-27 | 2019-07-16 | 北京京东尚科信息技术有限公司 | The methods, devices and systems of association index |
| CN111221883A (en) * | 2018-11-27 | 2020-06-02 | 浙江宇视科技有限公司 | Data statistical method and system |
| CN111221883B (en) * | 2018-11-27 | 2024-04-26 | 浙江宇视科技有限公司 | Data statistics method and system |
| CN110222054A (en) * | 2019-05-22 | 2019-09-10 | 福建大屏网络科技有限公司 | A kind of method, apparatus, terminal device and storage medium improving retrieval rate |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104598652B (en) | 2017-11-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108427684B (en) | Data query method and device and computing equipment | |
| CN104090889B (en) | Data processing method and system | |
| CN109857724B (en) | Method and equipment for supporting various databases based on block chain | |
| US10248680B2 (en) | Index management | |
| CN103049521B (en) | Virtual table directory system and the method for many attributes multiple condition searching can be realized | |
| US20190121901A1 (en) | Database Sharding | |
| CN111241108B (en) | Key value based indexing method and device for KV system, electronic equipment and medium | |
| CN104794123A (en) | Method and device for establishing NoSQL database index for semi-structured data | |
| CN103150394A (en) | Distributed file system metadata management method facing to high-performance calculation | |
| CN103678494A (en) | Method and device for client side and server side data synchronization | |
| CN105550225A (en) | Index construction method and query method and apparatus | |
| CN105956123A (en) | Local updating software-based data processing method and apparatus | |
| CN101464895A (en) | Method, system and apparatus for updating internal memory data | |
| CN105868421A (en) | Data management method and data management device | |
| CN111221840B (en) | Data processing method and device, data caching method, storage medium and system | |
| CN104424219A (en) | Method and equipment of managing data documents | |
| CN105100050A (en) | User permission management method and system | |
| CN104598652A (en) | Database inquiry method and database inquiry device | |
| CN106874459A (en) | Stream data storage method and device | |
| CN103559319A (en) | Cache synchronization method and equipment for distributed cluster file system | |
| CN110427364A (en) | A kind of data processing method, device, electronic equipment and storage medium | |
| CN105677904A (en) | Distributed file system based small file storage method and device | |
| CN116521956A (en) | Graph database query method and device, electronic equipment and storage medium | |
| CN106227769A (en) | Date storage method and device | |
| US11144522B2 (en) | Data storage using vectors of vectors |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 511446 Guangzhou City, Guangdong Province, Panyu District, South Village, Huambo Business District Wanda Plaza, block B1, floor 28 Applicant after: Guangzhou Huaduo Network Technology Co., Ltd. Address before: 510655, Guangzhou, Whampoa Avenue, No. 2, creative industrial park, building 3-08, Applicant before: Guangzhou Huaduo Network Technology Co., Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |