CN100465967C - Inquiry result processing method and device - Google Patents
Inquiry result processing method and device Download PDFInfo
- Publication number
- CN100465967C CN100465967C CNB2007101420363A CN200710142036A CN100465967C CN 100465967 C CN100465967 C CN 100465967C CN B2007101420363 A CNB2007101420363 A CN B2007101420363A CN 200710142036 A CN200710142036 A CN 200710142036A CN 100465967 C CN100465967 C CN 100465967C
- Authority
- CN
- China
- Prior art keywords
- index value
- result
- interim
- historical record
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The utility model discloses a processing method of the query result, which comprises a receiving the query index; wherein, the query index comprises a query condition and user identity. If a historical record which is in consistent with the index value does not exist, the data base is queried and a historical record and a temporary result table corresponding to the index value are created, and the data are brought back. If a historical record which is in consistent with the index value exists and a temporary result table corresponding to the index value exists, the temporary result table is queried and the data are brought back. If historical record which is in consistent with the index value exists but a temporary result table corresponding to the index value does not exist, the data base is re-queried and a temporary result table corresponding to the index value is created, and the data are brought back. Besides, the utility model also provides a processing device of the query result, which comprises a receiving element, a query element, a judging element and a processing element. The utility model has the advantages of enabling to avoid the problem that the reusability of the query result is poor due to the previous query data are covered when the user queries the current data, and improving the query efficiency.
Description
Technical field
The present invention relates to computer realm, relate in particular to a kind of querying method and device.
Background technology
Along with developing rapidly of modern enterprise, the various data that enterprise accumulated also increase severely thereupon.For the ease of these mass datas are carried out science, effectively manage and analyzed, data warehouse (Data Warehouse) technology begins to obtain extensive promotion and application.
An important tool software during extemporaneous inquiry represents as the data warehouse front end, mainly be responsible for business datum extraction, analyze and represent process.Extemporaneous inquiry (Ad hoc query) is the most general a kind of inquiry of database application, utilizes data warehouse technology, can allow the user can face database at any time, obtains desirable data.Especially the final user who is fit to the non-IT technician of those database application systems (such as management information system) uses.In the application of enterprise-level, the user often need extract data according to the different business condition from data warehouse, and data warehouse to extract the table of data very big, the data magnitude of its single table can reach several GB, in addition tens, a hundreds of GB.If adopt traditional direct inquiry mode, its performance and efficient are very low, and demonstrating data is very slow, can't meet customer need at all.Therefore, in order to solve performance bottleneck and the inefficient problem of data exhibiting that data warehouse extracts data, adopt the suitable interim memory technology as a result of inquiry scheme to become inevitable trend.
The user is when taking one's seat inquiry in the prior art, and the querying condition of setting according to the user in the data warehouse directly extracts data, the data that check out at every turn, sets up the result set storage in internal memory.The analysis operation that result set in content-based then is correlated with.Change as information such as new inquiry or querying conditions, data query from data warehouse is created the internal memory result set again once more.But because this technical scheme is temporarily stored in result set in the internal memory, memory consumption is big, the fatal error that causes internal memory to overflow easily; And because the only corresponding internal memory result set of each inquiry, when a plurality of user concurrents were carried out inquiry, user's data can be covered mutually.
In order to solve the problem of such scheme, industry is improved inquiring about the interim scheme of memory technology as a result.The structure of this method is referring to Fig. 1, from data warehouse, inquire the result, after each user inquires about and obtains a result, make a check mark according to current inquiring user ID, corresponding respectively each user sets up an interim table as a result and stores this user's data query.This method is stored in Query Result in the database by setting up interim table as a result, has alleviated the pressure of internal memory greatly, and has solved the problem that data were capped when multi-user concurrent was inquired about.
But this technical scheme still has following defective:
1, owing to be the interim table of setting up at each user as a result, on this scheme, when inquiring about each time, the user all can cover the interim table as a result that generated its last time so, and cause the buffer memory effect of interim table as a result to reduce greatly, reusability is not enough.
2, the interim table as a result that adopts this technical scheme to set up can only be preserved the result of the last inquiry of user, when the user need change querying condition and checks historical results, because interim table is not as a result stored corresponding data, need data query warehouse once more, still have the low problem of search efficiency.
Summary of the invention
The technical matters that one embodiment of the invention will solve provides a kind of querying method and device, can solve when the user inquires about each time and all can cause the problem that the buffer memory effect reduces greatly, reusability is not enough of interim table as a result to the interim covering of table as a result that she generated last time.
For solving the problems of the technologies described above, querying method embodiment provided by the present invention is achieved through the following technical solutions:
Receive the search index value, this index value comprises querying condition and user ID; According to index value query history record, comprise the information of the query script of once carrying out in the described historical record; If there be not the historical record consistent with index value, then this index value corresponding historical record, interim table and return data are as a result created in the data query warehouse, and described interim table as a result is used for storing the data about index value that inquire from data warehouse; If there be the historical record consistent with index value, and this index value correspondence interim as a result then inquired about also return data by described interim table as a result when table exists; If there be the historical record consistent with index value, but the interim table as a result of this index value correspondence is not when existing, and then interim as a result table and the return data corresponding with this index value created in data query warehouse again.
Corresponding to said method, the embodiment of the invention also provides a kind of inquiry unit, and this device comprises:
Receiving element is used to receive the search index value, and this index value comprises querying condition and user ID;
Query unit is carried out the query history record according to index value, comprises the information of the query script of once carrying out in the described historical record;
Judging unit is used to judge whether to exist the historical record consistent with index value; And judge when having the historical record consistent with index value, further judging whether to exist the interim as a result table corresponding with described index value, described interim table as a result is used for storing the data about index value that inquire from data warehouse;
Processing unit is used for when judgment unit judges goes out not exist the historical record consistent with index value, and this index value corresponding historical record, interim table and return data are as a result created in the data query warehouse; When go out there is corresponding with described index value interim table as a result in judgment unit judges, by the described interim inquiry of table as a result return data also; When judgment unit judges went out not exist corresponding with described index value interim table as a result, the interim table as a result and the return data of this index value correspondence were created in data query warehouse again then.
Technical scheme in the technique scheme has following beneficial effect: technical solution of the present invention at first comes really to carry out in the data warehouse whether the inquiry of same index value by index value; And because this index value has comprised querying condition and user ID, Cha Xun result is according to querying condition and the common distribution of user ID so; Therefore if this user carried out the inquiry of same index value, so just directly by the interim return data of table as a result, and can not carry out again the same queries condition repeat the inquiry, and can create different interim tables as a result at each user to different querying conditions, like this with regard to avoided the user at every turn inquiry can cover data query last time, cause the problem of Query Result reusability difference, thereby improved the efficient of user inquiring.And because interim table as a result is corresponding each user ID, the problem that interim table as a result writes conflict can not take place in the time of can also avoiding different users to inquire about with identical querying condition so.
Description of drawings
Fig. 1 is the art methods structural drawing;
Fig. 2 is the embodiment of the invention 1 method flow diagram;
Fig. 3 is the embodiment of the invention 2 method flow diagrams;
Fig. 4 is the embodiment of the invention 3 structure drawing of device;
Fig. 5 is the embodiment of the invention 4 structure drawing of device.
Embodiment
The embodiment of the invention provides following concrete scheme:
Embodiment 1, referring to Fig. 2, and a kind of querying method:
Step 101: receive the search index value, this index value comprises querying condition and user ID;
Wherein user ID can for concrete numeral with can be for the unique string that generates according to random algorithm etc., concrete form does not limit in embodiments of the present invention, as long as it is just passable to distinguish the unique identification of user identity.
Step 102: judge whether to exist the historical record consistent, promptly judge whether to exist and querying condition and the simultaneously consistent historical record of user ID with index value; If there is not then execution in step 103; If there is then execution in step 104:
The each query script that carries out before the described historical record of this step is meant all can be preserved in system, the querying condition that the content of preservation is carried out before can being, user ID, executor, execution time, interim table name as a result etc.; And described querying condition is stored according to structurized mode.It is that the principle of tree-shaped file system is applied in the single file that structurized mode is stored actual, make single file also can comprise deeper " sub-directory " as file system, each " catalogue " can contain a plurality of files, the content that needed a plurality of file storage originally is saved in the file by tree structure and level goes.As existing querying condition A, B, C, can be stored as different querying condition forms according to different logical relations: 1, (A and B) or C, 2, A and (B or C), the storage mode of preferred structureization is for to store with the xml mode in the present embodiment, and can be output into the condition combining characters string of XML form, the very convenient set of circumstances relationship match of carrying out.Historical record is to be stored in the database table, and the content of storage can be: historical record index sign ID, executor, querying condition, execution time etc.Above-mentioned querying condition feature can be by system intialization, each querying condition feature corresponding one or a group polling condition; Querying condition feature and its corresponding querying condition are stored by system.
Step 103: the data query warehouse, create and this index value corresponding historical record, interim table and return data as a result, finish inquiry;
The establishment index corresponding historical record of mentioning in this step that is to say the querying condition feature of index value correspondence and user ID storage, and the storing queries interim table as a result and the table name that arrive.
Interim table as a result in this step is to be used for storing the data about index value that inquire from data warehouse.
1), the interim table name of table as a result can be made up of the querying condition feature and the user ID that preset;
2), the table name of interim table as a result can also be made up of unique random number of title that presets and the random algorithm that presets generation; And the table name and the described index value of described interim table as a result set up mapping table;
As long as can be when the multi-user inquires about identical conditions simultaneously, produce unique interim table name as a result, and can come corresponding one by one according to the index value that contents such as querying condition, user ID are formed, the inquiry that is each user is corresponding to an interim table name as a result, can be not restricted to above-mentioned two kinds of methods as the interim replacement scheme of table name as a result in this scheme.
Step 104: judge whether to exist the interim as a result table corresponding with this index value; If there is then execution in step 105; If there is not then execution in step 103;
Judging whether in this step exist the interim as a result table corresponding with this index value method can for:
1), when using above-mentioned first kind of interim table name as a result, the querying condition that comprises by index value judges whether to store the interim as a result table name corresponding with described index value with user ID, as if the then existence interim as a result table corresponding with index value arranged.
Above-mentioned querying condition feature can be by system intialization, one or a group polling condition that each querying condition feature is unique; Querying condition feature and its corresponding querying condition are stored by system; And only corresponding user of user ID.
2), when using above-mentioned second kind of interim table name as a result, inquire about the table name of interim table as a result by index value and described mapping table, if find the then existence interim as a result table corresponding with index value.
The above-mentioned title that presets can be the rule generation by system intialization, for example can be some index values, and the concrete mode of index value can be determined by actual conditions.
Step 105: by described interim inquiry of table as a result and return data.
This step that is to say the data of search index value correspondence in the scope of interim table as a result, and returns.
Embodiment 1 at first comes really to carry out in the data warehouse whether the inquiry of same index value by index value; And because this index value has comprised querying condition and user ID, Cha Xun result is according to querying condition and the common distribution of user ID so; Therefore if this user carried out the inquiry of same index value, so just directly by the interim return data of table as a result, and can not carry out again the same queries condition repeat the inquiry, and can create different interim tables as a result at each user to different querying conditions, like this with regard to avoided the user at every turn inquiry can cover data query last time, cause the problem of Query Result reusability difference, thereby improved the efficient of user inquiring.And because interim table as a result is corresponding each user ID, the problem that interim table as a result writes conflict can not take place in the time of can also avoiding different users to inquire about with identical querying condition.
Embodiment 2, referring to Fig. 3, and the another kind of querying method that the embodiment of the invention provides:
Step 201: receive the search index value, this index value comprises querying condition and user ID;
Step 202: judge whether to exist the historical record consistent with index value; If there is then execution in step 203; If there is not then execution in step 206:
The each query script that carries out before the described historical record of this step is meant all can be preserved in system, the querying condition and the user ID of carrying out before can preserving; And described querying condition is stored according to structurized mode.
Step 203: judge whether to exist the interim as a result table corresponding with this index value; If there is then execution in step 204; If there is not then execution in step 205;
Judging whether described in this step exist the interim as a result table corresponding with this index value method can for:
1), the interim table name of table as a result can preset by querying condition feature and user ID and form;
The querying condition that comprises by index value judges whether to store the interim as a result table name corresponding with described index value with user ID, if the then existence interim as a result table corresponding with index value arranged.
Above-mentioned querying condition feature can be by system intialization, one or a group polling condition that each querying condition feature is unique; Querying condition feature and its corresponding querying condition are stored by system; And only corresponding user of user ID.
2), the foregoing description 1 can also be made up of unique random number of title that presets and the random algorithm that presets generation with the table name of embodiment 2 described interim tables as a result; And the table name and the described index value of described interim table as a result set up mapping table;
Inquire about the table name of interim table as a result by index value and described mapping table, if find the then existence interim as a result table corresponding with index value.
As long as can when multi-user concurrent, produce unique interim table name as a result, and can come correspondence, can be not restricted to above-mentioned two kinds of methods as the interim replacement scheme of table name as a result in this scheme according to the index value that contents such as querying condition are formed.
The above-mentioned title that presets can be the rule generation by system intialization, for example can be some index values, and the concrete mode of index value can be determined by actual conditions.
Step 204:, jump out this flow process by described interim inquiry of table as a result and return data;
Step 205: the data query warehouse, create this index value corresponding historical record, interim table and return data as a result, jump out this flow process;
Step 206: judge whether that index value is the subclass of historical record; If then execution in step 207; If not execution in step 205 then;
Step 207: in the scope of the interim table as a result of described historical record correspondence the search index value, create historical record, interim table and return data as a result that should index value.
Embodiment 2 improves on the basis of embodiment 1, when there be not the historical record consistent with index value in judgement, has judged further whether index value is the subclass of historical record; If index value is the subclass of historical record, just can be according to inquiring about again in the interim scope of table as a result that has existed, because the scope of interim table as a result is much smaller than the scope of whole data warehouse, so this search efficiency will improve greatly.In order clearly to explain the scheme of the embodiment of the invention, providing one is the concrete instance on basis according to embodiment 2:
Suppose in operation analysis system, to have the user A of market department of province company to use extemporaneous inquiry inquiry " newly-increased color ring user table " data.
The condition of user A inquiry is Query Dates=200703 and user ID=5, and it is as follows that inquiry generates interim outcome procedure:
1) at first in this user's execution historical record, searches whether corresponding record according to the user inquiring conditional information;
2) as finding corresponding record, take out this record.Otherwise, a newly-built inquiry executive logging, and record is for information about;
3) if the record that takes out in historical record, then whether output field information that relatively should record is consistent with the output field information of current inquiry.Otherwise directly start new inquiry.
4) if every information all finds corresponding querying condition from historical record, interim table as a result exists, and directly returns the interim data of table as a result; If interim table does not as a result exist, then regenerate data with this interim table name as a result, and return data.
5) if can't from historical record, find corresponding querying condition, the process of the new inquiry that then enters.In historical record, insert this query note.
6) in querying condition just now, increase the condition of area identification=370 as user A, this area identification sign can be inquired about the data of the whole province, reformulate new index value according to new querying condition information, and judge whether corresponding record is arranged in historical record.
7) suppose not carry out the inquiry that this condition of Query Dates=200703, user ID=5 and area identification=370 makes up before the user A, that will can't find index value just now in historical record.Then, judge whether current querying condition is the subclass of certain record in the historical record.
8) result of this condition generation of Query Dates=200703, user ID=5 and area identification=370 can be comprised by the result of Query Dates=200703 and this condition generation of user ID=5.Therefore, system only need use this condition of area identification=370 to do the secondary inquiry in the interim table as a result that generates just now and just can obtain the result that the user needs fast.
And the user B of user ID=6, when its during with Query Dates=200703 and area identification=370 condition queries, just can't see that user ID is 5 the user A interim table as a result that inquires with same querying condition, user B can only see that with its user ID 6, Query Dates=200703 and area identification=370 be the interim table as a result that querying condition is inquired about, although guaranteed that Query Dates is identical with area identification when inquiry, interim table as a result can not take place write collision problem.
Embodiment 3, and in order to realize the method for embodiment 1, the embodiment of the invention also provides a kind of inquiry unit, and referring to Fig. 4, this device comprises:
Receiving element 301 is used to receive the search index value, and this index value comprises querying condition and user ID;
Query unit 302 is carried out the query history record according to index value;
Judging unit 303 is used to judge whether to exist the historical record consistent with index value; And judge when having the historical record consistent with index value, further judge whether to exist the interim as a result table corresponding with described index value;
Processing unit 304 is used for judging when not having the historical record consistent with index value when judging unit 303, and this index value corresponding historical record, interim table and return data are as a result created in the data query warehouse; When judging unit 303 is judged when having corresponding with described index value interim table as a result, by the described interim inquiry of table as a result return data also; When judging unit 303 is judged when not having corresponding with described index value interim table as a result, the interim table as a result and the return data of this index value correspondence are created in data query warehouse again then.
Embodiment 4, and corresponding to embodiment 2, on the basis of embodiment 3, the embodiment of the invention also provides a kind of inquiry unit, and this device comprises:
Receiving element 401 is used to receive the search index value, and this index value comprises querying condition and user ID;
Judging unit 403 is used to judge whether to exist the historical record consistent with index value; And judge when having the historical record consistent with index value, further judge whether to exist the interim as a result table corresponding with described index value; Be used for judging whether judging when not having the record consistent whether index value is the subclass of historical record with described index value; Be used for when judging index value and be the subclass of historical record, further judging whether to exist the interim as a result table corresponding with described index value;
By the specific descriptions to the embodiment of the invention, the technical scheme of the embodiment of the invention has following beneficial effect as can be seen: technical solution of the present invention at first comes really to carry out in the data warehouse whether the inquiry of same index value by index value; And because this index value has comprised querying condition and user ID, Cha Xun result is according to querying condition and the common distribution of user ID so; Therefore if this user carried out the inquiry of same index value, so just directly by the interim return data of table as a result, and can not carry out again the same queries condition repeat the inquiry, and can create different interim tables as a result at each user to different querying conditions, like this with regard to avoided the user at every turn inquiry can cover data query last time, cause the problem of Query Result reusability difference, thereby improved the efficient of user inquiring.And because interim table as a result is corresponding each user ID, the problem that interim table as a result writes conflict can not take place in the time of can also avoiding different users to inquire about with identical querying condition.
And on embodiment 2 bases, when there be not the historical record consistent with index value in judgement, judged further whether index value is the subclass of historical record; So as long as index value is the subclass of historical record, just can be according to inquiring about again in the interim scope of table as a result that has existed since temporarily as a result the scope of table be much smaller than the scope of whole data warehouse, will just improve search efficiency greatly so.
One of ordinary skill in the art will appreciate that all or part of step that realizes in the foregoing description method is to instruct relevant hardware to finish by program, described program can be stored in a kind of computer-readable recording medium.The above-mentioned storage medium of mentioning can be a ROM (read-only memory), disk or CD etc.
More than a kind of querying method provided by the present invention and device are described in detail, for one of ordinary skill in the art, thought according to the embodiment of the invention, part in specific embodiments and applications all can change, in sum, this description should not be construed as limitation of the present invention.
Claims (8)
1, a kind of querying method is characterized in that, this method comprises:
Receive the search index value, this index value comprises querying condition and user ID;
According to index value query history record, comprise the information of the query script of once carrying out in the described historical record;
If there be not the historical record consistent with index value, then this index value corresponding historical record, interim table and return data are as a result created in the data query warehouse, and described interim table as a result is used for storing the data about index value that inquire from data warehouse;
If there be the historical record consistent with index value, and this index value correspondence interim as a result then inquired about also return data by described interim table as a result when table exists;
If there be the historical record consistent with index value, but the interim table as a result of this index value correspondence is not when existing, and then interim as a result table and the return data corresponding with this index value created in data query warehouse again.
2, querying method according to claim 1, it is characterized in that, if there be not the historical record consistent with described index value, and index value is not when being the subclass of historical record, again the data query warehouse, create this index value corresponding historical record, interim table and return data as a result; If there be not the historical record consistent with index value, but index value be the subclass of historical record and this historical record correspondence interim as a result when table exists then in the scope of interim table as a result the search index value, create historical record, interim table and return data as a result that should index value.
3, querying method according to claim 1 and 2 is characterized in that, the table name of described interim table as a result comprises querying condition feature and user ID;
Determine to exist the method for the interim as a result table corresponding with described index value to be: the querying condition and the user ID that comprise by index value judge whether to store the interim as a result table name corresponding with described index value, if the then existence interim as a result table corresponding with index value arranged.
4, querying method according to claim 1 and 2 is characterized in that,
The table name of described interim table as a result generates a unique random number by title that presets and the random algorithm that presets and forms; And the table name and the described index value of described interim table as a result set up mapping table;
Determine to exist the method for the interim as a result table corresponding to be: to inquire about the table name of interim table as a result by index value and described mapping table, if find the then existence interim table as a result corresponding with index value with index value.
5, querying method according to claim 1 and 2 is characterized in that,
The querying condition that described historical record comprises is stored according to structurized mode.
6, a kind of inquiry unit is characterized in that, this device comprises:
Receiving element is used to receive the search index value, and this index value comprises querying condition and user ID;
Query unit is carried out the query history record according to index value, comprises the information of the query script of once carrying out in the described historical record;
Judging unit is used to judge whether to exist the historical record consistent with index value; And judge when having the historical record consistent with index value, further judging whether to exist the interim as a result table corresponding with described index value, described interim table as a result is used for storing the data about index value that inquire from data warehouse;
Processing unit is used for when judgment unit judges goes out not exist the historical record consistent with index value, and this index value corresponding historical record, interim table and return data are as a result created in the data query warehouse; When go out there is corresponding with described index value interim table as a result in judgment unit judges, by the described interim inquiry of table as a result return data also; When judgment unit judges went out not exist corresponding with described index value interim table as a result, the interim table as a result and the return data of this index value correspondence were created in data query warehouse again then.
7, inquiry unit according to claim 6 is characterized in that,
Judging unit is further used for judging judging when not having the historical record consistent with described index value whether described index value is the subclass of historical record; Be used for when judging index value and be the subclass of historical record, further judging whether to exist the interim as a result table corresponding with described index value;
Processing unit is further used for when judgment unit judges goes out index value and is not the subclass of historical record, again the data query warehouse, create this index value corresponding historical record, interim table and return data as a result; Be used for when judgment unit judges goes out to exist the interim table as a result of historical record correspondence, in the scope of interim table as a result the search index value, create historical record, interim table and return data as a result that should index value.
8, according to claim 6 or 7 described inquiry units, it is characterized in that,
The querying condition that described historical record comprises is stored according to structurized mode.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2007101420363A CN100465967C (en) | 2007-08-20 | 2007-08-20 | Inquiry result processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2007101420363A CN100465967C (en) | 2007-08-20 | 2007-08-20 | Inquiry result processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101127048A CN101127048A (en) | 2008-02-20 |
| CN100465967C true CN100465967C (en) | 2009-03-04 |
Family
ID=39095080
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2007101420363A Active CN100465967C (en) | 2007-08-20 | 2007-08-20 | Inquiry result processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100465967C (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102937980A (en) * | 2012-10-18 | 2013-02-20 | 亿赞普(北京)科技有限公司 | Method for inquiring data of cluster database |
Families Citing this family (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101640696A (en) * | 2008-08-01 | 2010-02-03 | 华为技术有限公司 | Method, device and system for managing elements |
| CN101340492B (en) * | 2008-08-12 | 2011-11-23 | 华为技术有限公司 | Information inquiry method and apparatus |
| CN101656928B (en) * | 2008-08-20 | 2011-11-09 | 华为软件技术有限公司 | Short message processing method, system and assembly program unit |
| CN102236878A (en) * | 2010-04-30 | 2011-11-09 | 上海博泰悦臻电子设备制造有限公司 | Application-equipment-based weather data supply method and weather data service system |
| CN101882161B (en) * | 2010-06-23 | 2012-07-04 | 中国工商银行股份有限公司 | Application level asynchronous task scheduling system and method |
| CN102479223B (en) * | 2010-11-25 | 2014-06-04 | 中国移动通信集团浙江有限公司 | Data query method and system |
| CN102236718B (en) * | 2011-07-20 | 2019-09-13 | 南京中兴新软件有限责任公司 | A kind of method and device of data query |
| CN102542009B (en) * | 2011-12-14 | 2018-03-13 | 中兴通讯股份有限公司 | Data query method and device |
| CN102902701B (en) * | 2012-06-01 | 2016-08-03 | 珠海市君天电子科技有限公司 | Information query system and method |
| CN102737133B (en) * | 2012-06-27 | 2016-02-17 | 北京城市网邻信息技术有限公司 | A kind of method of real-time search |
| CN103810187A (en) * | 2012-11-08 | 2014-05-21 | 天津市国瑞数码安全系统有限公司 | Method for dynamically back-tracing historical query based on basic data of filing system |
| CN102968507B (en) * | 2012-12-14 | 2016-07-20 | 中国银行股份有限公司 | data query method based on cache table |
| CN104050181B (en) * | 2013-03-13 | 2018-03-20 | 深圳金蝶账无忧网络科技有限公司 | A kind of electronic spreadsheet penetrates querying method and device |
| CN104346350B (en) * | 2013-07-26 | 2019-09-20 | 南京中兴力维软件有限公司 | The tree node querying method and system of Asynchronous Tree |
| CN103455560A (en) * | 2013-08-12 | 2013-12-18 | 曙光信息产业股份有限公司 | Data query method and system |
| CN103593419B (en) * | 2013-10-30 | 2018-03-09 | 华为技术有限公司 | Data query method, apparatus, server and system |
| CN104143004B (en) * | 2014-08-04 | 2017-09-22 | 浪潮(北京)电子信息产业有限公司 | A kind of method and device of lookup K UX system files |
| CN106899558B (en) * | 2015-12-21 | 2020-05-08 | 腾讯科技（深圳）有限公司 | Access request processing method and device and storage medium |
| CN105930496A (en) * | 2016-05-06 | 2016-09-07 | 深圳市永兴元科技有限公司 | Data query method and system |
| CN107330768B (en) * | 2017-07-13 | 2021-02-26 | 北京京东尚科信息技术有限公司 | Personalized material display control method, device and system |
| CN110019332A (en) * | 2017-09-29 | 2019-07-16 | 北京国双科技有限公司 | A kind of data query method and device based on precomputation |
| CN109542907B (en) * | 2018-11-21 | 2021-09-03 | 万兴科技股份有限公司 | Database cache construction method and device, computer equipment and storage medium |
| CN111221883B (en) * | 2018-11-27 | 2024-04-26 | 浙江宇视科技有限公司 | Data statistics method and system |
| CN111639241B (en) * | 2020-05-20 | 2024-04-16 | 中国工商银行股份有限公司 | Processing method and device for list screening |
| CN112287180B (en) * | 2020-10-26 | 2024-07-16 | 深圳市友华软件科技有限公司 | Fault machine repairing management method based on MAC (media access control) search |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH11328030A (en) * | 1998-05-18 | 1999-11-30 | Oki Electric Ind Co Ltd | Storage system |
| CN1605992A (en) * | 2003-10-10 | 2005-04-13 | 鸿富锦精密工业（深圳）有限公司 | User authority rapid access generation system in call control list and method thereof |
| CN1661597A (en) * | 2004-01-30 | 2005-08-31 | GoGo技术公司 | Wireless search engine and method thereof |
| WO2006041342A1 (en) * | 2004-10-15 | 2006-04-20 | Telefonaktiebolaget Lm Ericsson (Publ) | Arrangement and method for a location database |
-
2007
- 2007-08-20 CN CNB2007101420363A patent/CN100465967C/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH11328030A (en) * | 1998-05-18 | 1999-11-30 | Oki Electric Ind Co Ltd | Storage system |
| CN1605992A (en) * | 2003-10-10 | 2005-04-13 | 鸿富锦精密工业（深圳）有限公司 | User authority rapid access generation system in call control list and method thereof |
| CN1661597A (en) * | 2004-01-30 | 2005-08-31 | GoGo技术公司 | Wireless search engine and method thereof |
| WO2006041342A1 (en) * | 2004-10-15 | 2006-04-20 | Telefonaktiebolaget Lm Ericsson (Publ) | Arrangement and method for a location database |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102937980A (en) * | 2012-10-18 | 2013-02-20 | 亿赞普(北京)科技有限公司 | Method for inquiring data of cluster database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101127048A (en) | 2008-02-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100465967C (en) | Inquiry result processing method and device | |
| US10657112B2 (en) | External system integration into automated attribute discovery | |
| WO2020192064A1 (en) | Incremental data consistency implementation method and device | |
| US20090171908A1 (en) | Natural language minimally explicit grammar pattern | |
| US9524317B2 (en) | Optimization of aggregate queries in database management systems using an early out join when processing min and max functions | |
| US7689553B2 (en) | Execution cost reduction of sampled queries in a database | |
| US8019771B2 (en) | Method for dynamically finding relations between database tables | |
| US8914354B2 (en) | Cardinality and selectivity estimation using a single table join index | |
| US7962442B2 (en) | Managing execution of a query against selected data partitions of a partitioned database | |
| US8280907B2 (en) | System and method for managing access to data in a database | |
| US7831620B2 (en) | Managing execution of a query against a partitioned database | |
| CN103345518A (en) | Self-adaptive data storage management method and system based on data block | |
| JP5199317B2 (en) | Database processing method, database processing system, and database server | |
| US9355147B2 (en) | Access plan for a database query | |
| CN106066895A (en) | A kind of intelligent inquiry system | |
| CN105164673A (en) | Query integration across databases and file systems | |
| CN105630934A (en) | Data statistic method and system | |
| US20090063458A1 (en) | method and system for minimizing sorting | |
| CN105095247A (en) | Symbolic data analysis method and system | |
| CN101963993B (en) | Method for fast searching database sheet table record | |
| US20100036804A1 (en) | Maintained and Reusable I/O Value Caches | |
| US20100070536A1 (en) | Dynamic change data capture process | |
| US20090063397A1 (en) | Method and system for disjunctive single index access | |
| US8548980B2 (en) | Accelerating queries based on exact knowledge of specific rows satisfying local conditions | |
| CN102193988A (en) | Method and system for retrieving node data in graphic database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: BEIJING WEIBEN INTELLECTUAL PROPERTY MANAGEMENT CO Free format text: FORMER OWNER: HUAWEI TECHNOLOGY CO., LTD. Effective date: 20150414 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 518129 SHENZHEN, GUANGDONG PROVINCE TO: 100080 HAIDIAN, BEIJING |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20150414 Address after: 100080 room 401A, building 27, 1 Xin Lu, Haidian District, Beijing Patentee after: Beijing Weiben Intellectual Property Management Co. Ltd. Address before: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee before: Huawei Technologies Co., Ltd. |
|
| ASS | Succession or assignment of patent right |
Owner name: BEIJING Z-GOOD TECHNOLOGY SERVICE CO., LTD. Free format text: FORMER OWNER: BEIJING WEIBEN INTELLECTUAL PROPERTY MANAGEMENT CO., LTD. Effective date: 20150520 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 100080 HAIDIAN, BEIJING TO: 100085 HAIDIAN, BEIJING |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20150520 Address after: 100085 Beijing city Haidian District No. 33 Xiaoying Road 1 1F06 room Patentee after: BEIJING ZHIGU TECHNOLOGY SERVICES CO., LTD. Address before: 100080 room 401A, building 27, 1 Xin Lu, Haidian District, Beijing Patentee before: Beijing Weiben Intellectual Property Management Co. Ltd. |