CN104166740A - Data inquiry method and device - Google Patents
Data inquiry method and device Download PDFInfo
- Publication number
- CN104166740A CN104166740A CN201410458284.9A CN201410458284A CN104166740A CN 104166740 A CN104166740 A CN 104166740A CN 201410458284 A CN201410458284 A CN 201410458284A CN 104166740 A CN104166740 A CN 104166740A
- Authority
- CN
- China
- Prior art keywords
- information
- data query
- regional
- field
- question blank
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- 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/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data inquiry method and device. According to the method, a data inquiry request carrying one or more data inquiry condition messages is received, an inquiry table which is preset is inquired and at least includes fields which correspond to all the data inquiry condition messages respectively, code messages in the fields indicate the superior-subordinate relations of indicated content of the fields, and data, meeting the data inquiry condition messages, of the code messages in the fields, corresponding to all the data inquiry condition messages, in the inquiry table serve as an inquiry result. Through setting indication messages (for example, the code messages in the fields indicate the superior-subordinate relations of the indicated content of the fields) of the code messages of the different fields in the preset inquiry table, the data inquiry purpose can be achieved through only one inquiry table, and the problem that in the prior art, in the process of data inquiry, because the number of inquired dimension tables correlated with a fact table is large, data inquiry efficiency is reduced is avoided.
Description
Technical field
The application relates to data analysis application systems technology field, particularly relates to a kind of data enquire method and device.
Background technology
Database table in prior art relational data warehouse is divided into fact table and dimension table (dimension table comprises time dimension table, regional dimension table etc.), when user need to be in this relevant database during data query, it wants the data of inquiry to be generally arranged in fact table, but in order to filter the data relevant to querying condition, conventionally need the condition on dimension table in query script, therefore, in order to realize inquiry object, conventionally need to each dimension table corresponding with querying condition and fact table be carried out associated.
For example, when querying condition is " Zhejiang Province's sales revenue of 2014 ", first need time dimension table and regional dimension table associated with fact table, from time dimension table, search the time code corresponding with time " 2014 " in querying condition, and from regional dimension table, search the area code corresponding with area " Zhejiang Province " in querying condition, and then utilize the time code and the area code that find as search criterion, in fact table, to find the data (that is: Zhejiang Province's sales revenue of 2014) that user needs.
The method, in data query process, can exist the dimension table associated with fact table of inquiring about because of need more conventionally, and the problem that causes efficiency data query to reduce.
Summary of the invention
In view of this, the application provides a kind of data enquire method and device, to avoid prior art in data query process, because of the dimension table associated with fact table of need inquiries more, and the problem that causes efficiency data query to reduce.
To achieve these goals, the technical scheme that the embodiment of the present invention provides is as follows:
A data enquire method, comprising:
Receive data query request, wherein carry at least one data query conditional information;
The question blank that inquiry sets in advance, at least comprise corresponding with data query conditions information described in each respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in described field in described question blank;
The data that the code information of usining in described question blank in corresponding with each data query conditions information respectively field meets described data query conditions information are as Query Result.
Preferably, also comprise: show described Query Result.
Preferably, when described data query conditions information is time inquiring conditional information,
Code information indication date and time information in described question blank in the field corresponding with described time inquiring conditional information.
Preferably, when described data query conditions information is regional querying condition information,
Regional relationship between superior and subordinate is indicated in code information in described question blank in the field corresponding with described regional querying condition information.
Preferably, described regional querying condition information is regional title querying condition information/area code querying condition information.
Preferably, when described regional querying condition information is regional title querying condition information, the method also comprises:
The regional title that utilization sets in advance and the corresponding relation between area code, be converted to area code querying condition information by described regional title querying condition information.
Preferably, also comprise: show regional dimension table, to indicate the corresponding relation between described regional title and area code.
A data query device, comprising:
Receiving element, for receiving data query request, wherein carries at least one data query conditional information;
Query unit, for inquiring about the question blank setting in advance, at least comprise corresponding with data query conditions information described in each respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in described field in described question blank;
Query Result determining unit, for usining the described question blank data that the code information in the field corresponding with each data query conditions information meets described data query conditions information respectively as Query Result.
Preferably, also comprise:
Display unit, for showing described Query Result.
Preferably, when described data query conditions information is time inquiring conditional information,
Code information indication date and time information in described question blank in the field corresponding with described time inquiring conditional information.
The application provides a kind of data enquire method and device, the method comprises: receive the data query request of carrying at least one data query conditional information, the question blank that inquiry sets in advance, in this question blank, at least comprise corresponding with each data query conditions information respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in field, the data that the code information of usining in question blank in corresponding with each data query conditions information respectively field meets data query conditions information are as Query Result.The application sets in advance the indication information (as: in field, the relationship between superior and subordinate of the indicated content of this field is indicated in code information) of the code information of different field in question blank by setting, make only to need a question blank can realize data query object, and then avoid prior art in data query process, because of the dimension table associated with fact table of need inquiries more, and the problem that causes efficiency data query to reduce.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only embodiments of the invention, for those of ordinary skills, do not paying under the prerequisite of creative work, other accompanying drawing can also be provided according to the accompanying drawing providing.
A kind of data enquire method process flow diagram that Fig. 1 provides for the embodiment of the present application one;
The structural representation of a kind of data query device that Fig. 2 provides for the embodiment of the present application two.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
Embodiment mono-:
A kind of data enquire method process flow diagram that Fig. 1 provides for the embodiment of the present application one.
As shown in Figure 1, the method comprises:
S101, the request of reception data query, wherein carry at least one data query conditional information.
In the embodiment of the present application, preferred, first receive the data query request of user's input, in this data query request, carry at least one data query conditional information.
In the embodiment of the present application, preferred, data query conditions information is time inquiring conditional information, regional querying condition information etc.As: when data query request is " GDP of Hebei province total value in 2014 ", in this data query request, carry two data query conditional informations, be respectively time inquiring conditional information " 2014 " and regional querying condition information " Hebei province ".
The question blank that S102, inquiry set in advance, at least comprise corresponding with each data query conditions information respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in field in question blank.
In the embodiment of the present application, preferred, after receiving data query request, the question blank that need set in advance according to this data query requesting query.
In the embodiment of the present application, preferred, in question blank, at least comprise corresponding with each data query conditions information respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in each field.
In the embodiment of the present application, preferably, when data query conditions information is time inquiring conditional information, code information indication date and time information in this question blank in the field corresponding with time inquiring conditional information, as: when the code information in question blank in the field corresponding with time inquiring conditional information is 20140503, when the date and time information of its indication is on May 3rd, 2014; When code information is 201405, the date and time information of its indication is in May, 2014; When code information is 2014, the date and time information of its indication is 2014.
Below be only the optimal way of the embodiment of the present application, do not limit the concrete mode of the code information indication date and time information in field corresponding with time inquiring conditional information in question blank, inventor can also arrange arbitrarily according to the demand of oneself form of expression of code information, as: when the date and time information of certain code information indication in question blank in the field corresponding with time inquiring conditional information is in May, 2014, it is Sj201405 that this code information is set.
Visible, the code information in question blank in the field corresponding with time inquiring conditional information, can be by the first two character indication year information in this code information when indication date and time information; Next month information indicated in two characters; In two characters indication day information next, also can realize thus the relationship between superior and subordinate on the code information indication date in field corresponding with time inquiring conditional information in this question blank.
In the embodiment of the present application, preferably, when data query conditions information is regional querying condition information, regional relationship between superior and subordinate is indicated in code information in this question blank in the field corresponding with regional querying condition information, as: when the code information in question blank in the field corresponding with regional querying condition information is 01, it indicates Hebei province; When the code information in question blank in the field corresponding with regional querying condition information is 0101, it indicates From Shijiazhuang City of Hebei Province; When the code information in question blank in the field corresponding with regional querying condition information is 0102, it indicates Baoding, Hebei province; When the code information in question blank in the field corresponding with regional querying condition information is 010101, it indicates Luquan county, From Shijiazhuang City of Hebei Province; When the code information in question blank in the field corresponding with regional querying condition information is 010102, it indicates Zhao County, From Shijiazhuang City of Hebei Province; When the code information in question blank in the field corresponding with regional querying condition information is 010201, it indicates Mancheng County of Baoding, Hebei province; When the code information in question blank in the field corresponding with regional querying condition information is 010202, it indicates Qingyuan County, Baoding, Hebei province.
Visible, the code information in question blank in the field corresponding with regional querying condition information, can be by the first two character indication provincial information in this code information when the regional relationship between superior and subordinate of indication; Next city-level information indicated in two characters; At two characters next, indicate information at county level.
Below be only the optimal way of the embodiment of the present application, inventor can also arrange arbitrarily according to the demand of oneself form of expression of the code information in field corresponding with regional querying condition information in question blank, as: during code information indication Hebei province in question blank in the field corresponding with regional querying condition information, this code information is Dq01.
Below being only the embodiment of the present application understands that the relationship between superior and subordinate of the indicated content of this field is indicated in code information in field and the instantiation that proposes for the ease of those skilled in the art, as: when data query conditions information is regional querying condition information, how the code information in this question blank in the field corresponding with regional querying condition information indicates regional relationship between superior and subordinate etc.Those skilled in the art will be appreciated that, in the question blank providing in the embodiment of the present application, not merely limit and comprise that with data query conditions information be the field that regional querying condition information and/or time inquiring conditional information are corresponding, concrete, code information in field corresponding to other data query conditions information indicates the mode of the relationship between superior and subordinate of the indicated content of this field to refer to the mode that regional relationship between superior and subordinate is indicated in code information in field corresponding with regional querying condition information in above-mentioned question blank, and/or the mode of code information indication date and time information in the field corresponding with time inquiring conditional information in question blank, at this, do not describe in detail.
In the embodiment of the present application, preferred, regional querying condition information is regional title querying condition information/area code querying condition information.
In the embodiment of the present application, preferably, when user (as: inventor) for the area code in the question blank that the embodiment of the present application is provided familiar, the regional querying condition information of carrying in the data query request of its input is area code querying condition information, this area's symbol lookup conditional information directly represents with the code information in field corresponding with regional querying condition information in question blank conventionally, as: when user wants to inquire about the data message in Hebei province, the code information (as: 01) corresponding to regional querying condition information Wei Yu Hebei province of carrying in the data query request of its input.
And when in the question blank that user provides the embodiment of the present application, the code information of field is unfamiliar with, the regional querying condition information of carrying in the data query request of its input is regional title querying condition information, name query conditional information in this area's shows with regional namelist conventionally, as: when user wants to inquire about the data message in Hebei province, the regional querying condition information of carrying in the data query request of its input is regional title " Hebei province ".
Further, in a kind of data enquire method providing in the embodiment of the present application, when regional querying condition information is regional title querying condition information, the method also comprises: the regional title that utilization sets in advance and the corresponding relation between area code, be converted to area code querying condition information by regional title querying condition information.
In the embodiment of the present application, preferably, when regional querying condition information is regional title querying condition information, the Netherlands setting in advance by utilization and the corresponding relation between area code, regional title querying condition information is converted to area code querying condition information, is convenient to utilize the area code querying condition information being converted to go to inquire about in question blank.
In the embodiment of the present application, preferred, when user need to inquire about the data message in May, 2014, the date and time information (as: 201405) that the time inquiring conditional information carrying in the data query request of its input is directly inputted for user.And preferred, this process only needs, when user is during in input inquiry request, to limit the input format on date in this inquiry request in implementation procedure.
In the embodiment of the present application, preferably, those skilled in the art should be appreciated that the time inquiring conditional information carrying in the data query request that user inputs can be the code information in field corresponding with this time inquiring conditional information in question blank, also can be the concrete time, at this, do not limit.
In the embodiment of the present application, preferably, the time inquiring condition of carrying in the data query request of user input is not the code information in field corresponding with this time inquiring conditional information in question blank, but during the concrete time (as: in May, 2014), the concrete time that need utilization sets in advance and the corresponding relation between time code, convert this concrete time to code information in field corresponding with this time inquiring conditional information in question blank.
The data that S103, the code information of usining in question blank in corresponding with each data query conditions information respectively field meet data query conditions information are as Query Result.
In the embodiment of the present application, preferably, when data query request comprises two data query conditions, be respectively regional querying condition information and time during querying condition information, code information in field corresponding with regional querying condition information in question blank is met to regional querying condition information, and the data that in question blank, the code information in the field corresponding with time inquiring conditional information meets time inquiring conditional information are as Query Result.
Further, in a kind of data enquire method providing in the embodiment of the present application, also comprise: show Query Result.
In the embodiment of the present application, preferred, by the demonstration to Query Result, facilitate the grasp of personnel query to Query Result.
Further, in a kind of data enquire method providing in the embodiment of the present application, also comprise: show regional dimension table, to indicate the corresponding relation between regional title and area code.
In the embodiment of the present application, in order to facilitate user to understand the indicated regional title of the area code in question blank, also comprise: show regional dimension table, this area's dimension table is used to indicate the corresponding relation between regional title and area code.
In the embodiment of the present application, preferred, field corresponding with the regional querying condition information of carrying in data query request in question blank is regional field, and the field corresponding with time inquiring conditional information is time field.Understanding for the ease of those skilled in the art to regional dimension table, provides a kind of regional dimension table at this, and this area's dimension table is as follows:
Simultaneously, in order to facilitate the understanding of the question blank that those skilled in the art provide the embodiment of the present application, at this, provide a kind of question blank, and better data query is understood to some extent for the ease of those skilled in the art, therefore, in this question blank, except time field and regional field, be also provided with sales revenue field, as: user can inquire about the sales revenue in certain time range and geographic coverage by this question blank, and this question blank is as follows:
| Sj (time field) | Dq (regional field) | Sr (sales revenue field) |
| Sj20140101 | Dq010101 | 100 |
| Sj20140102 | Dq010101 | 200 |
| Sj20140103 | Dq010101 | 300 |
The application provides a kind of data enquire method, the method comprises: receive the data query request of carrying at least one data query conditional information, the question blank that inquiry sets in advance, in this question blank, at least comprise corresponding with each data query conditions information respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in field, the data that the code information of usining in question blank in corresponding with each data query conditions information respectively field meets data query conditions information are as Query Result.The application sets in advance the indication information (as: in field, the relationship between superior and subordinate of the indicated content of this field is indicated in code information) of the code information of different field in question blank by setting, make only to need a question blank can realize data query object, and then avoid prior art in data query process, because of the dimension table associated with fact table of need inquiries more, and the problem that causes efficiency data query to reduce.
Embodiment bis-:
The structural representation of a kind of data query device that Fig. 2 provides for the embodiment of the present application two.
As shown in Figure 2, this device comprises: connected receiving element 1, query unit 2 and Query Result determining unit 3 successively, wherein:
Receiving element 1, for receiving data query request, wherein carries at least one data query conditional information.
Query unit 2, for inquiring about the question blank setting in advance, at least comprise corresponding with each data query conditions information respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in field in question blank.
In the embodiment of the present application, preferred, when data query conditions information is time inquiring conditional information, the code information indication date and time information in question blank in the field corresponding with time inquiring conditional information.
Query Result determining unit 3, for usining the question blank data that the code information in the field corresponding with each data query conditions information meets data query conditions information respectively as Query Result.
Further, in a kind of data query device providing in the embodiment of the present application, also comprise: display unit, for showing Query Result.
In the embodiment of the present application, preferred, display unit is connected with Query Result determining unit, for showing Query Result.
The application provides a kind of data query device, this device carries the data query request of at least one data query conditional information by reception, the question blank that inquiry sets in advance, in this question blank, at least comprise corresponding with each data query conditions information respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in field, the data that the code information of usining in question blank in corresponding with each data query conditions information respectively field meets data query conditions information are as Query Result.The application sets in advance the indication information (as: in field, the relationship between superior and subordinate of the indicated content of this field is indicated in code information) of the code information of different field in question blank by setting, make only to need a question blank can realize data query object, and then avoid prior art in data query process, because of the dimension table associated with fact table of need inquiries more, and the problem that causes efficiency data query to reduce.
In this instructions, each embodiment adopts the mode of going forward one by one to describe, and each embodiment stresses is the difference with other embodiment, between each embodiment identical similar part mutually referring to.For the disclosed device of embodiment, because it corresponds to the method disclosed in Example, so description is fairly simple, relevant part partly illustrates referring to method.
Below be only the application's preferred implementation, make those skilled in the art can understand or realize the application.To the multiple modification of these embodiment, will be apparent to one skilled in the art, General Principle as defined herein can be in the situation that do not depart from the application's spirit or scope, realization in other embodiments.Therefore, the application will can not be restricted to these embodiment shown in this article, but will meet the widest scope consistent with principle disclosed herein and features of novelty.
Claims (10)
1. a data enquire method, is characterized in that, comprising:
Receive data query request, wherein carry at least one data query conditional information;
The question blank that inquiry sets in advance, at least comprise corresponding with data query conditions information described in each respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in described field in described question blank;
The data that the code information of usining in described question blank in corresponding with each data query conditions information respectively field meets described data query conditions information are as Query Result.
2. method according to claim 1, is characterized in that, also comprises: show described Query Result.
3. method according to claim 1, is characterized in that, when described data query conditions information is time inquiring conditional information,
Code information indication date and time information in described question blank in the field corresponding with described time inquiring conditional information.
4. method according to claim 1, is characterized in that, when described data query conditions information is regional querying condition information,
Regional relationship between superior and subordinate is indicated in code information in described question blank in the field corresponding with described regional querying condition information.
5. method according to claim 4, is characterized in that, described regional querying condition information is regional title querying condition information/area code querying condition information.
6. method according to claim 5, is characterized in that, when described regional querying condition information is regional title querying condition information, the method also comprises:
The regional title that utilization sets in advance and the corresponding relation between area code, be converted to area code querying condition information by described regional title querying condition information.
7. method according to claim 6, is characterized in that, also comprises: show regional dimension table, to indicate the corresponding relation between described regional title and area code.
8. a data query device, is characterized in that, comprising:
Receiving element, for receiving data query request, wherein carries at least one data query conditional information;
Query unit, for inquiring about the question blank setting in advance, at least comprise corresponding with data query conditions information described in each respectively field, and the relationship between superior and subordinate of the indicated content of this field is indicated in the code information in described field in described question blank;
Query Result determining unit, for usining the described question blank data that the code information in the field corresponding with each data query conditions information meets described data query conditions information respectively as Query Result.
9. device according to claim 8, is characterized in that, also comprises:
Display unit, for showing described Query Result.
10. device according to claim 8, is characterized in that, when described data query conditions information is time inquiring conditional information,
Code information indication date and time information in described question blank in the field corresponding with described time inquiring conditional information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410458284.9A CN104166740A (en) | 2014-09-10 | 2014-09-10 | Data inquiry method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410458284.9A CN104166740A (en) | 2014-09-10 | 2014-09-10 | Data inquiry method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104166740A true CN104166740A (en) | 2014-11-26 |
Family
ID=51910553
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410458284.9A Pending CN104166740A (en) | 2014-09-10 | 2014-09-10 | Data inquiry method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104166740A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104599181A (en) * | 2015-02-11 | 2015-05-06 | 中国农业银行股份有限公司 | Method and device for querying currency products |
| CN106570760A (en) * | 2016-11-14 | 2017-04-19 | 平安科技（深圳）有限公司 | Quotation condition matching method and device |
| CN107735781A (en) * | 2015-01-14 | 2018-02-23 | 华为技术有限公司 | Store method and apparatus, the computing device of Query Result |
| CN109739876A (en) * | 2019-01-10 | 2019-05-10 | 中化石化销售有限公司 | The data query method and apparatus of database based on Sqltoy-orm frame |
| CN113220719A (en) * | 2021-06-04 | 2021-08-06 | 上海天旦网络科技发展有限公司 | Mass dimension data association query optimization method and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
| CN103020301A (en) * | 2012-12-31 | 2013-04-03 | 中国科学院自动化研究所 | Multidimensional data query and storage method and system |
| CN104021156A (en) * | 2014-05-22 | 2014-09-03 | 武汉天量数据技术有限公司 | Method for rapidly collecting multi-layer fact data based on SQL statements |
-
2014
- 2014-09-10 CN CN201410458284.9A patent/CN104166740A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
| CN103020301A (en) * | 2012-12-31 | 2013-04-03 | 中国科学院自动化研究所 | Multidimensional data query and storage method and system |
| CN104021156A (en) * | 2014-05-22 | 2014-09-03 | 武汉天量数据技术有限公司 | Method for rapidly collecting multi-layer fact data based on SQL statements |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107735781A (en) * | 2015-01-14 | 2018-02-23 | 华为技术有限公司 | Store method and apparatus, the computing device of Query Result |
| CN107735781B (en) * | 2015-01-14 | 2020-03-10 | 华为技术有限公司 | Method and device for storing query result and computing equipment |
| CN104599181A (en) * | 2015-02-11 | 2015-05-06 | 中国农业银行股份有限公司 | Method and device for querying currency products |
| CN106570760A (en) * | 2016-11-14 | 2017-04-19 | 平安科技（深圳）有限公司 | Quotation condition matching method and device |
| CN109739876A (en) * | 2019-01-10 | 2019-05-10 | 中化石化销售有限公司 | The data query method and apparatus of database based on Sqltoy-orm frame |
| CN109739876B (en) * | 2019-01-10 | 2021-01-12 | 中化石化销售有限公司 | Data query method and device for database based on Sqltoy-orm framework |
| CN113220719A (en) * | 2021-06-04 | 2021-08-06 | 上海天旦网络科技发展有限公司 | Mass dimension data association query optimization method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104166740A (en) | Data inquiry method and device | |
| EP3117344B1 (en) | Density-based dynamic geohash | |
| CN104639664A (en) | Method and system for pushing information | |
| TWI703862B (en) | Content recommendation method and device | |
| EP4236422A3 (en) | Devices and methods for discovering collectable data and analytics data in a network | |
| CN102752336A (en) | User generated content (UGC) sharing method and system based on geographical location service | |
| CN103309883B (en) | A kind of information-pushing method and system | |
| CN104268298A (en) | Method for creating database index and inquiring data | |
| CN103327041B (en) | A kind of method and system obtaining user content | |
| CN104346466A (en) | Method and device of adding new attribute data in database | |
| CN103729378A (en) | Updating method and device for IP geographic information | |
| CN103279877A (en) | Commercial tenant information searching and ranking method | |
| CN103440197B (en) | A kind of method automatically generating difference test report based on contrast test | |
| GB2565482A (en) | Attribute matching | |
| CN106997354B (en) | POI data retrieval method and device | |
| CN104657354B (en) | A kind of digital certificate validity period search method and equipment | |
| CN105354743A (en) | Data processing method and device | |
| CN205158357U (en) | Farmland contracting power of management database management system | |
| CN103294788A (en) | Universal background processing method and system for websites | |
| CN104391861A (en) | Method for obtaining thematic map based on scale level change | |
| CN105302696A (en) | Server data querying method, cloud server and data querying system | |
| WO2013189427A2 (en) | File name conversion method and device | |
| CN102609457A (en) | Multi-application serving method of raster data and multi-application server of raster data | |
| Dewsbury | Debating the role of higher education in society | |
| CN104679804A (en) | Web page multiple attribute marking method and implementation thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20141126 |
|
| RJ01 | Rejection of invention patent application after publication |