CN101216840A - Data enquiry method and data enquiry system - Google Patents
Data enquiry method and data enquiry system Download PDFInfo
- Publication number
- CN101216840A CN101216840A CNA2008100043228A CN200810004322A CN101216840A CN 101216840 A CN101216840 A CN 101216840A CN A2008100043228 A CNA2008100043228 A CN A2008100043228A CN 200810004322 A CN200810004322 A CN 200810004322A CN 101216840 A CN101216840 A CN 101216840A
- Authority
- CN
- China
- Prior art keywords
- inquiry
- major key
- data
- query
- query statement
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data query method which includes the following steps: defining main query keys in the data source, extracting the main query keys meeting the query conditions from the main query keys to create a main query key list; generate a paging rule for the main query key list, which comprises page identifiers and corresponding range of main query keys; extracting the corresponding range of main query keys according to the user-specified page identifiers to generate query statement; executing the query statement to complete the data query and return to the data result set. The invention improves the data query efficiency simply and effectively on the premise of saving resources occupancy.
Description
Technical field
The present invention relates to the database application field, particularly relate to a kind of data enquire method and a kind of data query system.
Background technology
In present a lot of software application system, often face the problem of accessing database, data query then is a most frequently used operation.
In the existing data query technique, generally the querying condition according to the user generates SQL statement, and the data that satisfy condition are extracted from database, shows in client.Yet,, may cause the memory source deficiency of database side, thereby have a strong impact on search efficiency in case concurrent inquiry is too much.Because data quantity transmitted is bigger, and the web that needs to take in a large number the internal memory of client, this mode also not to be suitable for little bandwidth within a certain period of time uses.To this, prior art uses the paging inquiring technology to solve the problems referred to above.
The know-why of paging inquiry is, realizes paging technique in database side, takes out the data of certain scope by the vernier of database, for example, by the vernier inquiry, directly uses ResultSet to handle in JAVA.Wherein, ResultSet directly sets up vernier on database, obtain the record of nominated bank position then by the line position locating interface of ResultSet.When user's first request msg is inquired about, just carry out the SQL statement inquiry, the ResultSet object of acquisition and the connecting object that will use thereof all are saved in its corresponding session object.Later paging inquiry all obtains the record of nominated bank position by the ResultSet object location of carrying out the SQL acquisition for the first time.Yet, when this processing mode is inquired about in each paging, database still needs to filter out in advance qualified data from data acquisition, further adopt vernier to take out the data of certain scope again, thereby the reaction velocity of inquiry is slower, the access resources of database is taken bigger, especially in concurrent inquiry more for a long time, because the above-mentioned factor that influences the database side performance will cause the reaction of system slack-off.
In a word, need the urgent technical matters that solves of those skilled in the art to be exactly at present: a kind of data query mechanism of the proposition how can innovate, can improve efficiency data query simply, effectively under the prerequisite of saving resource occupation.
Summary of the invention
Technical matters to be solved by this invention provides a kind of data enquire method, in order under the prerequisite of saving resource occupation, improves efficiency data query simply, effectively.
The present invention also provides a kind of data query device, in order to guarantee said method realization and application in practice.
For solving the problems of the technologies described above, the embodiment of the invention discloses a kind of data enquire method, comprising:
Definition inquiry major key in data source;
From described inquiry major key, extract the inquiry major key that satisfies querying condition, to create the inquiry list of primary keys;
Generate the paging rule of described inquiry list of primary keys, described paging rule comprises page iden-tity and corresponding inquiry major key scope;
Extract the inquiry major key of respective range according to the page iden-tity of user's appointment, with the generated query statement;
Carry out described query statement, finish data query, the return data result set.
Preferably, described method also comprises:
Show described data result collection at current page.
Preferably, described method also comprises:
Preserve described inquiry list of primary keys to client-cache.
Preferably, described data source is the database that is positioned at server end or client.
Preferably, described query statement is the SQL query statement.
The embodiment of the invention also discloses a kind of data query system, comprising:
The major key definition module is used at data source definition inquiry major key;
The major key extraction module is used for extracting the inquiry major key that satisfies querying condition from described inquiry major key, to create the inquiry list of primary keys;
The paging module is used to generate the paging rule of described inquiry list of primary keys, and described paging rule comprises page iden-tity and corresponding inquiry major key scope;
The statement generation module is used for the inquiry major key according to the page iden-tity extraction respective range of user's appointment, with the generated query statement;
Execution module is used to carry out described query statement, finishes data query, the return data result set.
Preferably, described system also comprises:
Display module is used for showing described data result collection at current page.
Preferably, described system also comprises:
Cache module is used for preserving described inquiry list of primary keys to client-cache.
Preferably, described data source is the database that is positioned at server end or client.
Preferably, described query statement is the SQL query statement.
Compared with prior art, the present invention has the following advantages:
In order to solve the problem of big data quantity data query, the invention provides a kind of solution route, inquiry major key by the definition of data source is as the basis of inquiry, and set up paging rule, during user inquiring, page iden-tity and corresponding inquiry major key generated query statement by appointment, show to carry out paging, thereby data processing amount and transmission quantity have been significantly reduced, effectively save system resource and taken, improved search efficiency, and then improved the reaction velocity of system, especially in the concurrent inquiry of data more for a long time, the raising of this query performance is particularly evident.
Description of drawings
Fig. 1 is the flow chart of steps of the method embodiment 1 of a kind of data query of the present invention;
Fig. 2 is the flow chart of steps of the method embodiment 2 of a kind of data query of the present invention;
Fig. 3 is a kind of synoptic diagram of order data table;
Fig. 4 is the interface synoptic diagram of return data result set;
Fig. 5 is the structured flowchart of the system embodiment of a kind of data query of the present invention.
Embodiment
For above-mentioned purpose of the present invention, feature and advantage can be become apparent more, the present invention is further detailed explanation below in conjunction with the drawings and specific embodiments.
The present invention can be used in numerous general or special purpose computingasystem environment or the configuration.For example: personal computer, server computer, handheld device or portable set, plate equipment, multicomputer system, comprise distributed computing environment of above any system or equipment or the like.
The present invention can describe in the general context of the computer executable instructions of being carried out by computing machine, for example program module.Usually, program module comprises the routine carrying out particular task or realize particular abstract, program, object, assembly, data structure or the like.Also can in distributed computing environment, put into practice the present invention, in these distributed computing environment, by by communication network connected teleprocessing equipment execute the task.In distributed computing environment, program module can be arranged in the local and remote computer-readable storage medium that comprises memory device.
One of core idea of the embodiment of the invention is, inquiry major key by the definition of data source is as the basis of inquiry, and set up paging rule, during user inquiring,, show to carry out paging by the page iden-tity and the corresponding inquiry major key generated query statement of appointment, thereby reduce data processing amount and transmission quantity, effectively save taking of system resource, improve the efficient of inquiry, and then improve the reaction velocity of system.
With reference to figure 1, show the process flow diagram of a kind of data enquire method embodiment 1 of the present invention, can may further comprise the steps:
The paging rule of step 103, the described inquiry list of primary keys of generation, described paging rule comprise page iden-tity and corresponding inquiry major key scope;
Usually, when setting up database, can be that every table specifies a major key (Primary Key), so-called major key be exactly can the unique identification table in the attribute or the set of properties of certain delegation, a table can only have a major key usually, but a plurality of candidate indexs can be arranged.Because major key can a certain line item of unique identification, so the mistake that can not occur fastening one person's story upon another person when can guarantee to carry out Data Update, deletion.Certainly, also eliminate when the executable operations and share conflict to increase other field.Major key usually constitutes referential integrity constraints with external key except above-mentioned effect, it is inconsistent to prevent data.
The scheme that prior art provides all multiple database major keys to choose, for example, the automatic increase field, manually increase field, use UniqueIdentifier type, use " COMB (Combine) " type etc.Certainly, it all is feasible that those skilled in the art adopt any method to define in data source to search major key, and the present invention does not need to make restriction to this.
With reference to figure 2, show the process flow diagram of a kind of data enquire method embodiment 2 of the present invention, can may further comprise the steps:
The paging rule of step 203, the described inquiry list of primary keys of generation, described paging rule comprise page iden-tity and corresponding inquiry major key scope;
Preferably, described query statement can be the SQL query statement.SQL is the abbreviation of StructuredQuery Language (Structured Query Language (SQL)).SQL aims at database and the operation commands set set up, is senior deproceduring programming language, allows the user to work on the high level data structure.It does not require that the user specifies the deposit method to data, does not need the user to understand concrete deposit data mode yet, can use identical sql like language as the interface of data input with management so have the disparate databases system of complete different fabrics.Because sql like language belongs to the known technology of this area, is not described in detail in this.
For the process that generates SQL statement, also belong to the common technology of this area.For example, those skilled in the art generate SQL statement through regular meeting by O-R Mapping framework technology.ORM, be Object-Relation Mapping, its effect is to do a mapping between relevant database and object, like this, the technician is in concrete operating database, just do not need to go and complicated SQL statement is not come into contacts with, it is just passable as long as operate as operand at ordinary times again.For example, utilize O/R Mapping preservation, deletion or reading object, get final product and be responsible for generating SQL statement by O/R Mapping.
With an object lesson the present invention is further described below.
Suppose that the user needs to inquire about the sequence information of " amount of money "＞100, the step of using the preferred embodiment of the present invention comprises:
S1, in database table shown in Figure 3, determine the inquiry major key of sequence information, i.e. FID in the table;
S2, the querying condition " amount of money "＞100 that is provided with according to the user extract the inquiry major key that satisfies condition, and can be expressed as with query statement:
select?FID?From?order?Where?amount＞100
S3, will form the inquiry list of primary keys, be saved in the buffer memory by the major key that the inquiry of above-mentioned major key obtains;
S4, generate paging rule according to the quantity of inquiry major key, promptly set up the corresponding relation of certain page iden-tity and corresponding major key scope, for example, quantity according to page display record calculates total page number, suppose that one page can show 100 records, then form the page 1 corresponding 1-100 bar major key record, the page 2 corresponding 101-200 bar major key records or the like, can also be arranged on current record is less than when presetting display record, promptly suppose when assigning to the page 3, all remaining major key records directly got in only surplus 201-288 bar major key record.
S5, extract the inquiry major key of respective range according to the page iden-tity of user's appointment, with the generated query statement;
For example, the user specifies the data of extracting the page 1, then takes out 1 to 100 major key from the inquiry list of primary keys, constructs the inquiry of the field of actual needs, and the query statement that promptly can obtain this inquiry by the information of all fields in the order is:
select*from?order?Where?id?IN(1，2，....100)；
S6, carry out described query statement, finish data query, the return data result set, and show at current page.
The displaying result of this example can be with reference to interface synoptic diagram shown in Figure 4.
At user's page selection operation further, from list of primary keys, obtain the major key scope of respective page correspondence, construct query statement again, for example, the user selects to inquire about the 3rd page data, and obtaining major key from list of primary keys is (500,511.....), then corresponding query statement can for:
select*from?order?Where?id?In(500，511....)
The Query Result that obtains according to this query statement shows again.
For aforesaid each method embodiment, for simple description, so it all is expressed as a series of combination of actions, but those skilled in the art should know, the present invention is not subjected to the restriction of described sequence of movement, because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in the instructions all belongs to preferred embodiment, and related action and module might not be that the present invention is necessary.
With reference to figure 5, show the structured flowchart of a kind of data query system embodiment of the present invention, can comprise with lower module:
Major key definition module 501 is used at data source definition inquiry major key;
Major key extraction module 502 is used for extracting the inquiry major key that satisfies querying condition from described inquiry major key, to create the inquiry list of primary keys;
Preferably, present embodiment can also comprise display module, is used for showing described data result collection at current page.
Preferably, present embodiment can also comprise cache module, is used for preserving described inquiry list of primary keys to client-cache.
In practice, described data source can be for being positioned at the database of server end or client; Described query statement is the SQL query statement.
In the above-described embodiments, the description of each embodiment is all emphasized particularly on different fields, do not have the part that describes in detail among certain embodiment, can be referring to the associated description of other embodiment.For system class embodiment, because it is similar substantially to method embodiment, so description is fairly simple, relevant part gets final product referring to the part explanation of method embodiment.
More than the method and system of a kind of data query provided by the present invention is described in detail, used specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof; Simultaneously, for one of ordinary skill in the art, according to thought of the present invention, the part that all can change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (10)
1. a data enquire method is characterized in that, comprising:
Definition inquiry major key in data source;
From described inquiry major key, extract the inquiry major key that satisfies querying condition, to create the inquiry list of primary keys;
Generate the paging rule of described inquiry list of primary keys, described paging rule comprises page iden-tity and corresponding inquiry major key scope;
Extract the inquiry major key of respective range according to the page iden-tity of user's appointment, with the generated query statement;
Carry out described query statement, finish data query, the return data result set.
2. the method for claim 1 is characterized in that, also comprises:
Show described data result collection at current page.
3. method as claimed in claim 1 or 2 is characterized in that, also comprises:
Preserve described inquiry list of primary keys to client-cache.
4. method as claimed in claim 3 is characterized in that, described data source is the database that is positioned at server end or client.
5. method as claimed in claim 4 is characterized in that, described query statement is the SQL query statement.
6. a data query system is characterized in that, comprising:
The major key definition module is used at data source definition inquiry major key;
The major key extraction module is used for extracting the inquiry major key that satisfies querying condition from described inquiry major key, to create the inquiry list of primary keys;
The paging module is used to generate the paging rule of described inquiry list of primary keys, and described paging rule comprises page iden-tity and corresponding inquiry major key scope;
The statement generation module is used for the inquiry major key according to the page iden-tity extraction respective range of user's appointment, with the generated query statement;
Execution module is used to carry out described query statement, finishes data query, the return data result set.
7. system as claimed in claim 6 is characterized in that, also comprises:
Display module is used for showing described data result collection at current page.
8. as claim 6 or 7 described systems, it is characterized in that, also comprise:
Cache module is used for preserving described inquiry list of primary keys to client-cache.
9. system as claimed in claim 8 is characterized in that, described data source is the database that is positioned at server end or client.
10. system as claimed in claim 9 is characterized in that, described query statement is the SQL query statement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100043228A CN101216840A (en) | 2008-01-21 | 2008-01-21 | Data enquiry method and data enquiry system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100043228A CN101216840A (en) | 2008-01-21 | 2008-01-21 | Data enquiry method and data enquiry system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101216840A true CN101216840A (en) | 2008-07-09 |
Family
ID=39623272
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008100043228A Pending CN101216840A (en) | 2008-01-21 | 2008-01-21 | Data enquiry method and data enquiry system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101216840A (en) |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101860449A (en) * | 2009-04-09 | 2010-10-13 | 华为技术有限公司 | Data query method, device and system |
| WO2012025058A1 (en) * | 2010-08-26 | 2012-03-01 | 腾讯科技（深圳）有限公司 | Method and apparatus for managing massive data messages |
| CN102456004A (en) * | 2010-10-18 | 2012-05-16 | 金蝶软件（中国）有限公司 | Query control method and system of page data |
| CN102479234A (en) * | 2010-11-29 | 2012-05-30 | 深圳市金蝶中间件有限公司 | Database paging operation method and device |
| CN102541927A (en) * | 2010-12-30 | 2012-07-04 | 北京新媒传信科技有限公司 | Method and device for realizing data cache |
| CN101661509B (en) * | 2009-09-29 | 2012-07-18 | 金蝶软件（中国）有限公司 | Method for generating major key field of database table and device thereof |
| CN103020151A (en) * | 2012-11-22 | 2013-04-03 | 用友软件股份有限公司 | Large data quantity batch processing system and large data quantity batch processing method |
| CN103164418A (en) * | 2011-12-12 | 2013-06-19 | 阿里巴巴集团控股有限公司 | Method and device for processing serial numbers |
| CN103246659A (en) * | 2012-02-06 | 2013-08-14 | 阿里巴巴集团控股有限公司 | Method and device for key value data query |
| CN103886022A (en) * | 2014-02-24 | 2014-06-25 | 上海上讯信息技术股份有限公司 | Paging-query querying device and method based on primary key fields |
| CN104915435A (en) * | 2015-06-24 | 2015-09-16 | 努比亚技术有限公司 | Data query method and device |
| CN105045902A (en) * | 2015-08-07 | 2015-11-11 | 虎扑（上海）文化传播股份有限公司 | Data query method and system |
| CN105760457A (en) * | 2016-02-05 | 2016-07-13 | 成都康赛信息技术有限公司 | Data paging optimizing method based on MongoDB |
| CN105843958A (en) * | 2016-04-15 | 2016-08-10 | 北京思特奇信息技术股份有限公司 | Cache-based server paging method and system |
| CN106227894A (en) * | 2016-08-24 | 2016-12-14 | 中国农业银行股份有限公司 | A kind of data page querying method and device |
| CN106250477A (en) * | 2016-07-29 | 2016-12-21 | 厦门天锐科技股份有限公司 | A kind of paging method of point of table data |
| CN106446080A (en) * | 2016-09-09 | 2017-02-22 | 华为技术有限公司 | Data query method, query service device, client device and data system |
| CN106708864A (en) * | 2015-11-13 | 2017-05-24 | 北京国双科技有限公司 | Query framework-based data query method and apparatus |
| WO2017133538A1 (en) * | 2016-02-05 | 2017-08-10 | 中兴通讯股份有限公司 | Method for realizing data query and server |
| CN107193874A (en) * | 2017-04-20 | 2017-09-22 | 南京航空航天大学 | A kind of data query method based on finger URL Yu Boolean query condition |
| CN108090064A (en) * | 2016-11-21 | 2018-05-29 | 腾讯科技（深圳）有限公司 | A kind of data query method, apparatus, data storage server and system |
| CN108228663A (en) * | 2016-12-21 | 2018-06-29 | 杭州海康威视数字技术股份有限公司 | A kind of paging search method and device |
| CN110019350A (en) * | 2017-07-28 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Data query method and apparatus based on configuration information |
-
2008
- 2008-01-21 CN CNA2008100043228A patent/CN101216840A/en active Pending
Cited By (36)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101860449A (en) * | 2009-04-09 | 2010-10-13 | 华为技术有限公司 | Data query method, device and system |
| CN101860449B (en) * | 2009-04-09 | 2014-02-19 | 华为技术有限公司 | Data query method, device and system |
| CN101661509B (en) * | 2009-09-29 | 2012-07-18 | 金蝶软件（中国）有限公司 | Method for generating major key field of database table and device thereof |
| WO2012025058A1 (en) * | 2010-08-26 | 2012-03-01 | 腾讯科技（深圳）有限公司 | Method and apparatus for managing massive data messages |
| CN102456004A (en) * | 2010-10-18 | 2012-05-16 | 金蝶软件（中国）有限公司 | Query control method and system of page data |
| CN102456004B (en) * | 2010-10-18 | 2014-04-02 | 金蝶软件（中国）有限公司 | Query control method and system of page data |
| CN102479234B (en) * | 2010-11-29 | 2015-04-08 | 深圳市金蝶中间件有限公司 | Database paging operation method and device |
| CN102479234A (en) * | 2010-11-29 | 2012-05-30 | 深圳市金蝶中间件有限公司 | Database paging operation method and device |
| CN102541927A (en) * | 2010-12-30 | 2012-07-04 | 北京新媒传信科技有限公司 | Method and device for realizing data cache |
| CN102541927B (en) * | 2010-12-30 | 2013-11-13 | 北京新媒传信科技有限公司 | Method and device for realizing data cache |
| CN103164418A (en) * | 2011-12-12 | 2013-06-19 | 阿里巴巴集团控股有限公司 | Method and device for processing serial numbers |
| CN103164418B (en) * | 2011-12-12 | 2016-05-04 | 阿里巴巴集团控股有限公司 | A kind of processing method of sequence number and equipment |
| CN103246659B (en) * | 2012-02-06 | 2016-05-25 | 阿里巴巴集团控股有限公司 | The method and apparatus of key assignments data query |
| CN103246659A (en) * | 2012-02-06 | 2013-08-14 | 阿里巴巴集团控股有限公司 | Method and device for key value data query |
| CN103020151B (en) * | 2012-11-22 | 2015-12-02 | 用友网络科技股份有限公司 | Big data quantity batch processing system and big data quantity batch processing method |
| CN103020151A (en) * | 2012-11-22 | 2013-04-03 | 用友软件股份有限公司 | Large data quantity batch processing system and large data quantity batch processing method |
| CN103886022A (en) * | 2014-02-24 | 2014-06-25 | 上海上讯信息技术股份有限公司 | Paging-query querying device and method based on primary key fields |
| CN103886022B (en) * | 2014-02-24 | 2019-01-18 | 上海上讯信息技术股份有限公司 | A kind of query facility and its method carrying out paging query based on major key field |
| CN104915435A (en) * | 2015-06-24 | 2015-09-16 | 努比亚技术有限公司 | Data query method and device |
| CN105045902A (en) * | 2015-08-07 | 2015-11-11 | 虎扑（上海）文化传播股份有限公司 | Data query method and system |
| CN106708864A (en) * | 2015-11-13 | 2017-05-24 | 北京国双科技有限公司 | Query framework-based data query method and apparatus |
| CN105760457A (en) * | 2016-02-05 | 2016-07-13 | 成都康赛信息技术有限公司 | Data paging optimizing method based on MongoDB |
| WO2017133538A1 (en) * | 2016-02-05 | 2017-08-10 | 中兴通讯股份有限公司 | Method for realizing data query and server |
| CN105843958A (en) * | 2016-04-15 | 2016-08-10 | 北京思特奇信息技术股份有限公司 | Cache-based server paging method and system |
| CN106250477A (en) * | 2016-07-29 | 2016-12-21 | 厦门天锐科技股份有限公司 | A kind of paging method of point of table data |
| CN106250477B (en) * | 2016-07-29 | 2020-04-03 | 厦门天锐科技股份有限公司 | Paging method for data in sub-table |
| CN106227894A (en) * | 2016-08-24 | 2016-12-14 | 中国农业银行股份有限公司 | A kind of data page querying method and device |
| CN106227894B (en) * | 2016-08-24 | 2019-11-26 | 中国农业银行股份有限公司 | A kind of data page querying method and device |
| CN106446080A (en) * | 2016-09-09 | 2017-02-22 | 华为技术有限公司 | Data query method, query service device, client device and data system |
| CN108090064A (en) * | 2016-11-21 | 2018-05-29 | 腾讯科技（深圳）有限公司 | A kind of data query method, apparatus, data storage server and system |
| CN108090064B (en) * | 2016-11-21 | 2021-10-08 | 腾讯科技（深圳）有限公司 | Data query method and device, data storage server and system |
| CN108228663A (en) * | 2016-12-21 | 2018-06-29 | 杭州海康威视数字技术股份有限公司 | A kind of paging search method and device |
| CN107193874A (en) * | 2017-04-20 | 2017-09-22 | 南京航空航天大学 | A kind of data query method based on finger URL Yu Boolean query condition |
| CN107193874B (en) * | 2017-04-20 | 2020-06-16 | 南京航空航天大学 | Data query method based on locator and logic query condition |
| CN110019350A (en) * | 2017-07-28 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Data query method and apparatus based on configuration information |
| CN110019350B (en) * | 2017-07-28 | 2021-06-29 | 北京京东尚科信息技术有限公司 | Data query method and device based on configuration information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101216840A (en) | Data enquiry method and data enquiry system | |
| US10831753B2 (en) | Query plan generation and execution in a relational database management system with a temporal-relational database | |
| CN107402992B (en) | Distributed NewSQL database system and full-text retrieval establishing method | |
| Olston et al. | Automatic optimization of parallel dataflow programs | |
| US8285709B2 (en) | High-concurrency query operator and method | |
| Ma et al. | Big graph search: challenges and techniques | |
| US8924373B2 (en) | Query plans with parameter markers in place of object identifiers | |
| US20150095308A1 (en) | Background format optimization for enhanced sql-like queries in hadoop | |
| CN110674432A (en) | Second-level caching method and device and computer readable storage medium | |
| CN103177056A (en) | Hybrid database table stored as both row and column store | |
| CN109614347B (en) | Processing method and device for multi-level cache data, storage medium and server | |
| CN103177055A (en) | Hybrid database table stored as both row and column store | |
| CN103177058A (en) | Hybrid database table stored as both row and column store | |
| CN105138621B (en) | A kind of Sybase ASE database configuration optimization system and method | |
| CN110134705A (en) | A kind of data query method, cache server and terminal | |
| CN107077480A (en) | The method and system of column storage database is adaptively built from the row data storage storehouse of current time based on query demand | |
| CN105550206B (en) | The edition control method and device of structured query sentence | |
| CN112860727B (en) | Data query method, device, equipment and medium based on big data query engine | |
| CN103198136B (en) | A kind of PC file polling method based on sequential correlation | |
| CN104620241A (en) | Multi-language document clustering | |
| JP2009530738A (en) | Declarations for transformations in service sequences | |
| CN108475266A (en) | For removing the matching reparation of matching document | |
| US20120310918A1 (en) | Unique join data caching method | |
| US20140067853A1 (en) | Data search method, information system, and recording medium storing data search program | |
| CN115237937A (en) | Distributed collaborative query processing system based on interplanetary file system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20080709 |