CN104809254A - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN104809254A CN104809254A CN201510258228.5A CN201510258228A CN104809254A CN 104809254 A CN104809254 A CN 104809254A CN 201510258228 A CN201510258228 A CN 201510258228A CN 104809254 A CN104809254 A CN 104809254A
- Authority
- CN
- China
- Prior art keywords
- sql
- template
- statistics
- sql statement
- item
- 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/248—Presentation of query results
-
- 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/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data query method and a data query device. The method comprises the following steps: pre-compiling an SQL (Structured Query Language) template corresponding to each statistical item, wherein the query parameter of each SQL template is a variable, so that the SQL template corresponding to a statistical item can be searched by only inputting the query parameter when a statistical result of a certain target statistical item is queried by a user; converting the SQL template into a specific SQL statement by utilizing the query parameter; querying the statistical result by utilizing the SQL statement. When the data query is performed by the user by using the method disclosed by the invention, only the query parameter is required to be input; the process of compiling the SQL statement in the prior art is eliminated, so that the workload of the user is reduced, and the query efficiency is greatly improved.
Description
Technical field
The application relates to technical field of data processing, more particularly, relates to a kind of data enquire method and device.
Background technology
Along with the rise of ecommerce, various shopping class website emerges in multitude, and supplier issues the product information that will sell on website, understands and choose oneself product to more buyer.In shopping website, Various types of data generally all stores in a database.As the supvr of shopping website, need to add up the Various types of data relevant to supplier, such as, add up that user in certain period subscribes to quantity, user's release product quantity etc. in certain period.
In prior art, for the statistical items that each is to be checked, all need when user inquires about to write a SQL (Structured Query Language, Structured Query Language (SQL)) statement at every turn, and utilize the SQL statement of writing to inquire about the statistics of corresponding statistical items in a database.And of a great variety due to statistical items, user, to inquire about the statistics of multiple statistical items, needs to write multiple SQL statement, and this will the inquiry workload of adding users, and reduces search efficiency.
Summary of the invention
In view of this, this application provides a kind of data enquire method and device, for solving the problem that search efficiency is low, amount of user effort is large existing for available data querying method.
To achieve these goals, the existing scheme proposed is as follows:
A kind of data enquire method, comprising:
Response Client-initiated is to the inquiry request of object statistics item, and transfer SQL template corresponding with described object statistics item in preset configuration file, the query argument in described SQL template is variable;
According to Client-initiated query argument, be SQL statement by described SQL template switch;
Described SQL statement is utilized to inquire about the statistics corresponding with described object statistics item.
Preferably, the described statistics utilizing the inquiry of described SQL statement corresponding with described object statistics item, comprising:
Utilize hashing algorithm to process described SQL statement, obtain target hashed value;
In caching system, search object statistics result, described object statistics result is the result utilizing target SQL statement to inquire about gained in a database in advance, and the hashed value of described target SQL statement after described hashing algorithm process is identical with described target hashed value.
Preferably, also comprise:
Described statistics is graphically shown.
Preferably, when the number of described object statistics item is multiple, described described statistics graphically to be shown, comprising:
Multiple described statistics is shown in the same chart of the same page.
Preferably, also comprise:
According to the instruction of Client-initiated template operation, process the SQL template in described configuration file, described template operation instruction comprises increase, deletes and/or amendment SQL template.
A kind of data query arrangement, comprising:
Request-response unit, for responding the inquiry request of Client-initiated to object statistics item, transfer SQL template corresponding with described object statistics item in preset configuration file, the query argument in described SQL template is variable;
Described SQL template switch, for according to Client-initiated query argument, is SQL statement by template switch unit;
Result determining unit, inquires about the statistics corresponding with described object statistics item for utilizing described SQL statement.
Preferably, described result determining unit comprises:
Hashing unit, for utilizing hashing algorithm to process described SQL statement, obtains target hashed value;
Hash value matches unit, for searching object statistics result in caching system, described object statistics result is the result utilizing target SQL statement to inquire about gained in a database in advance, and the hashed value of described target SQL statement after described hashing algorithm process is identical with described target hashed value.
Preferably, also comprise:
Diagrammatic representation unit, for graphically showing described statistics.
Preferably, described diagrammatic representation unit comprises:
First diagrammatic representation subelement, for when the number of described object statistics item is multiple, shows multiple described statistics in the same chart of the same page.
Preferably, also comprise:
Template operation unit, for according to the instruction of Client-initiated template operation, processes the SQL template in described configuration file, and described template operation instruction comprises increase, deletes and/or amendment SQL template.
As can be seen from above-mentioned technical scheme, the data enquire method that the embodiment of the present application provides, write the SQL template corresponding with each statistical items in advance, wherein the query argument of each SQL template is variable, thus user is when inquiring about the statistics of some object statistics items, only need input inquiry parameter, the application's scheme can find the SQL template of object statistics item correspondence, and utilize query argument to be concrete SQL statement by SQL template switch, then utilize this SQL statement query statistic result.User is when using the application's method to carry out data query, and only need input inquiry parameter, eliminate in prior art the process of writing SQL statement, because this reducing the workload of user, and search efficiency have also been obtained very large lifting.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present application or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only the embodiment of the application, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to the accompanying drawing provided.
Fig. 1 is a kind of data enquire method process flow diagram disclosed in the embodiment of the present application;
Fig. 2 is another kind of data enquire method process flow diagram disclosed in the embodiment of the present application;
Fig. 3 is the embodiment of the present application another data enquire method process flow diagram disclosed;
Fig. 4 is the embodiment of the present application another data enquire method process flow diagram disclosed;
Fig. 5 is a kind of statistics page presentation design sketch disclosed in the present application;
Fig. 6 is the embodiment of the present application another data enquire method process flow diagram disclosed;
Fig. 7 is a kind of data query arrangement structural representation disclosed in the embodiment of the present application;
Fig. 8 is a kind of result determining unit structural representation disclosed in the embodiment of the present application;
Fig. 9 is another kind of data query arrangement structural representation disclosed in the embodiment of the present application;
Figure 10 is a kind of diagrammatic representation cellular construction schematic diagram disclosed in the embodiment of the present application;
Figure 11 is the embodiment of the present application another data query arrangement structural representation disclosed.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present application, be clearly and completely described the technical scheme in the embodiment of the present application, obviously, described embodiment is only some embodiments of the present application, instead of whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not making the every other embodiment obtained under creative work prerequisite, all belong to the scope of the application's protection.
For the ease of understanding the application, before introducing the application's scheme, first introduce noun, the concept that hereinafter may use.
SQL statement: SQL is the abbreviation of Structured Query Language, and its Chinese name is called Structured Query Language (SQL).SQL statement is a kind of data base querying and programming language, for access data and inquiry, renewal and administrative relationships Database Systems.
See Fig. 1, Fig. 1 a kind of data enquire method process flow diagram disclosed in the embodiment of the present application.
As shown in Figure 1, the method comprises:
Step S100, response Client-initiated, to the inquiry request of object statistics item, transfer SQL template corresponding with described object statistics item in preset configuration file;
It should be noted that, write corresponding SQL template for each statistical items in advance in the application, the query argument in SQL template is variable.The SQL template write is stored in configuration file.
SQL template can regard the predecessor of SQL statement as, and after only needing the query argument in SQL template to determine, namely SQL template can be exchanged into SQL statement.
Client-initiated inquiry request can be the statistics of inquiring about some object statistics items, also can be the statistics to multiple object statistics item.When the number of object statistics item is multiple, needs to transfer the SQL template corresponding with each object statistics item, also namely transfer multiple SQL template.
Further, the application can provide user's query page, and query page has displayed multiple statistical items.User only needs to choose certain or multiple statistical items namely can trigger inquiry.
Preferably, for the multiple statistical items be illustrated in query page, the application can also classify to it in advance, possesses same alike result or several statistical items that user inquires about possibility higher simultaneously can be divided into a class.Classification name can also be carried out to each classification.Citing as:
Known all statistical items can be divided into following a few class: user base information, user's subscription, product, examination & verification state.Wherein, for product, " release product sum " and " submitting company information to and the product quantity of release product " two statistical items can be comprised in product category.
Described SQL template switch is SQL statement by step S110, foundation Client-initiated query argument;
Particularly, Client-initiated query argument can be carried in inquiry request, or after inquiry request, is again initiated by user.
Query argument is general comprises query time, by the query argument as variable in SQL template is defined as Client-initiated query argument, can obtain SQL statement.
Step S120, the statistics utilizing the inquiry of described SQL statement corresponding with described object statistics item.
The data enquire method that the embodiment of the present application provides, write the SQL template corresponding with each statistical items in advance, wherein the query argument of each SQL template is variable, thus user is when inquiring about some object statistics items, only need input inquiry parameter, the application's scheme can find the SQL template of object statistics item correspondence, and utilizes query argument to be concrete SQL statement by SQL template switch, then utilizes this SQL statement query statistic result.User is when using the application's method to carry out data query, and only need input inquiry parameter, eliminate in prior art the process of writing SQL statement, because this reducing the workload of user, and search efficiency have also been obtained very large lifting.
In another embodiment of the application, describe a kind of mode of the statistics utilizing SQL statement query aim statistical items corresponding.See Fig. 2, Fig. 2 another kind of data enquire method process flow diagram disclosed in the embodiment of the present application.
As shown in Figure 2, the method comprises:
Step S200, response Client-initiated, to the inquiry request of object statistics item, transfer SQL template corresponding with described object statistics item in preset configuration file;
It should be noted that, write corresponding SQL template for each statistical items in advance in the application, the query argument in SQL template is variable.The SQL template write is stored in configuration file.
Client-initiated inquiry request can be the statistics of inquiring about some object statistics items, also can be the statistics to multiple object statistics item.When the number of object statistics item is multiple, needs to transfer the SQL template corresponding with each object statistics item, also namely transfer multiple SQL template.
Described SQL template switch is SQL statement by step S210, foundation Client-initiated query argument;
Particularly, Client-initiated query argument can be carried in inquiry request, or after inquiry request, is again initiated by user.
Query argument is general comprises query time, by the query argument as variable in SQL template is defined as Client-initiated query argument, can obtain SQL statement.
Step S220, utilize described SQL statement query statistic result in a database.
In the present embodiment, after being converted to SQL statement, can utilize existing inquiry mode, in database, input SQL statement, can obtain the statistics that database exports, this statistics is the statistics of object statistics item correspondence.
Here, store the data relevant to each statistical items in database, general, this database is Mysql database.
Further, because Mysql database only supports Series poll mode, also namely a certain moment only allows the statistics of an inquiry statistical items, therefore when Client-initiated inquiry request comprises multiple object statistics item, the multiple SQL statement obtained in step S210 can be mail to Mysql database one by one, obtain the statistics of each object statistics item correspondence successively.
Certainly, if the database storing each statistical items related data supports parallel query mode, then when Client-initiated inquiry request comprises multiple object statistics item, the multiple SQL statement obtained in step S210 can be mail to database together, by the inquiry request of all SQL statement of database parallel processing, search efficiency can be accelerated like this.
In the another embodiment of the application, describe the mode of the statistics that another utilizes SQL statement query aim statistical items corresponding.Be the embodiment of the present application another data enquire method process flow diagram disclosed see Fig. 3, Fig. 3.
As shown in Figure 3, the method comprises:
Step S300, response Client-initiated, to the inquiry request of object statistics item, transfer SQL template corresponding with described object statistics item in preset configuration file;
It should be noted that, write corresponding SQL template for each statistical items in advance in the application, the query argument in SQL template is variable.The SQL template write is stored in configuration file.
Client-initiated inquiry request can be the statistics of inquiring about some object statistics items, also can be the statistics to multiple object statistics item.When the number of object statistics item is multiple, needs to transfer the SQL template corresponding with each object statistics item, also namely transfer multiple SQL template.
Described SQL template switch is SQL statement by step S310, foundation Client-initiated query argument;
Particularly, Client-initiated query argument can be carried in inquiry request, or after inquiry request, is again initiated by user.
Query argument is general comprises query time, by the query argument as variable in SQL template is defined as Client-initiated query argument, can obtain SQL statement.
Step S320, utilize hashing algorithm to process described SQL statement, obtain target hashed value;
Step S330, utilize target hashed value in caching system, search object statistics result.
Particularly, described object statistics result is the result utilizing target SQL statement to inquire about gained in a database in advance, and the hashed value of described target SQL statement after described hashing algorithm process is identical with described target hashed value.
In the present embodiment, in order to alleviate the inquiry pressure of database, and result can be obtained fast after allowing user initiate inquiry request, can by system at one's leisure between utilize the SQL statement corresponding with each statistical items, in database, send inquiry request, and inquiry gained statistics is recorded in caching system.It is noted herein that the SQL statement corresponding with each statistical items can have multiple, different according to Query Dates, SQL statement is also different.System can be selected to inquire about the statistics of each statistical items in the previous day in two o'clock in the morning every day.When inquiring about for each statistical items, the SQL statement used through the hashed value of hashing gained as the mark of the statistics of this statistical items.Like this, when the statistics of user's query aim statistical items, using the target hashed value after the hashing of the SQL statement after the SQL template switch corresponding with object statistics item as matching condition, the statistics that in caching system, the mark of statistics is identical with target hashed value is the statistics of object statistics item.
Optionally, caching system can be adopt Nosql database.
Optionally, hashing algorithm can adopt MD5 algorithm.MD5 and Message-Digest Algorithm 5, message digest algorithm 5 is one of widely used hashing algorithms of computing machine.Translate again digest algorithm, hash algorithm.Develop through MD2, MD3 and MD4, be born in early 1990s.For guaranteeing that information transmission is unanimously complete.Although be cracked, but still there is good security, can freely use in addition, so be still widely used in the fields such as digital signature, file integrality checking and password encryption.
In the another embodiment of the application, disclose another data enquire method process flow diagram.
As shown in Figure 4, the method comprises:
Step S400, response Client-initiated, to the inquiry request of object statistics item, transfer SQL template corresponding with described object statistics item in preset configuration file;
It should be noted that, write corresponding SQL template for each statistical items in advance in the application, the query argument in SQL template is variable.The SQL template write is stored in configuration file.
Client-initiated inquiry request can be the statistics of inquiring about some object statistics items, also can be the statistics to multiple object statistics item.When the number of object statistics item is multiple, needs to transfer the SQL template corresponding with each object statistics item, also namely transfer multiple SQL template.
Described SQL template switch is SQL statement by step S410, foundation Client-initiated query argument;
Particularly, Client-initiated query argument can be carried in inquiry request, or after inquiry request, is again initiated by user.
Query argument is general comprises query time, by the query argument as variable in SQL template is defined as Client-initiated query argument, can obtain SQL statement.
Step S420, the statistics utilizing the inquiry of described SQL statement corresponding with described object statistics item;
Step S430, described statistics graphically to be shown.
Particularly, a kind of statistics page presentation design sketch can be illustrated with reference to Fig. 5, Fig. 5.By the mode of diagrammatic representation, make statistics more directly perceived, vivid.In addition, for the statistics that diagrammatic form is shown, can also export in Excel table.
Further, still with reference to figure 5, if the number of object statistics item is multiple, then, when carrying out statistics and showing, multiple statistics can be shown in the same chart of the same page.
In another embodiment of the application, disclose another data enquire method process flow diagram.
As shown in Figure 6, the method comprises:
Step S600, response Client-initiated, to the inquiry request of object statistics item, transfer SQL template corresponding with described object statistics item in preset configuration file;
It should be noted that, write corresponding SQL template for each statistical items in advance in the application, the query argument in SQL template is variable.The SQL template write is stored in configuration file.
Client-initiated inquiry request can be the statistics of inquiring about some object statistics items, also can be the statistics to multiple object statistics item.When the number of object statistics item is multiple, needs to transfer the SQL template corresponding with each object statistics item, also namely transfer multiple SQL template.
Described SQL template switch is SQL statement by step S610, foundation Client-initiated query argument;
Particularly, Client-initiated query argument can be carried in inquiry request, or after inquiry request, is again initiated by user.
Query argument is general comprises query time, by the query argument as variable in SQL template is defined as Client-initiated query argument, can obtain SQL statement.
Step S620, the statistics utilizing the inquiry of described SQL statement corresponding with described object statistics item;
Step S630, the instruction of foundation Client-initiated template operation, process the SQL template in described configuration file.
Wherein, described template operation instruction comprises increase, deletes and/or amendment SQL template.
Be understandable that, be not defined as above-mentioned sequencing between above-mentioned steps S630 and other step, it can optional position between step S600-S620.
Owing to facing possibly in actual conditions, statistical items modified, increase or the operation such as deletion, therefore the present embodiment provides the user operation SQL function of template, user can change any one existing SQL template in configuration file, also can increase SQL template newly in configuration file.
Be described the data query arrangement that the embodiment of the present application provides below, data query arrangement described below can mutual corresponding reference with above-described data enquire method.
See Fig. 7, Fig. 7 a kind of data query arrangement structural representation disclosed in the embodiment of the present application.
As shown in Figure 7, this device comprises:
Request-response unit 71, for responding the inquiry request of Client-initiated to object statistics item, transfer SQL template corresponding with described object statistics item in preset configuration file, the query argument in described SQL template is variable;
Described SQL template switch, for according to Client-initiated query argument, is SQL statement by template switch unit 72;
Result determining unit 73, inquires about the statistics corresponding with described object statistics item for utilizing described SQL statement.
Optionally, the embodiment of the present application also discloses a kind of alternate configurations of the above results determining unit 73, and as shown in Figure 8, result determining unit 73 can comprise:
Hashing unit 731, for utilizing hashing algorithm to process described SQL statement, obtains target hashed value;
Hash value matches unit 732, for searching object statistics result in caching system, described object statistics result is the result utilizing target SQL statement to inquire about gained in a database in advance, and the hashed value of described target SQL statement after described hashing algorithm process is identical with described target hashed value.
Optionally, the embodiment of the present application discloses the another kind of structure of above-mentioned data query arrangement, composition graphs 7 and Fig. 9 known, this device can also comprise:
Diagrammatic representation unit 74, for graphically showing described statistics.
Optionally, the embodiment of the present application discloses a kind of alternate configurations of above-mentioned diagrammatic representation unit 74, and as shown in Figure 10, diagrammatic representation unit 74 can comprise:
First diagrammatic representation subelement 741, for when the number of described object statistics item is multiple, shows multiple described statistics in the same chart of the same page.
Optionally, the embodiment of the present application discloses another structure of above-mentioned data query arrangement, composition graphs 7 and Figure 11 known, this device can also comprise:
Template operation unit 75, for according to the instruction of Client-initiated template operation, processes the SQL template in described configuration file, and described template operation instruction comprises increase, deletes and/or amendment SQL template.
The data query arrangement that the embodiment of the present application provides, write in advance and store the SQL template corresponding with each statistical items, wherein the query argument of each SQL template is variable, thus user is when inquiring about some object statistics items, only need input inquiry parameter, the application's device can find the SQL template of object statistics item correspondence, and utilizes query argument to be concrete SQL statement by SQL template switch, then utilizes this SQL statement query statistic result.User is when using the application's method to carry out data query, and only need input inquiry parameter, eliminate in prior art the process of writing SQL statement, because this reducing the workload of user, and search efficiency have also been obtained very large lifting.
Finally, also it should be noted that, in this article, the such as relational terms of first and second grades and so on is only used for an entity or operation to separate with another entity or operational zone, and not necessarily requires or imply the relation that there is any this reality between these entities or operation or sequentially.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thus make to comprise the process of a series of key element, method, article or equipment and not only comprise those key elements, but also comprise other key elements clearly do not listed, or also comprise by the intrinsic key element of this process, method, article or equipment.When not more restrictions, the key element limited by statement " comprising ... ", and be not precluded within process, method, article or the equipment comprising described key element and also there is other identical element.
In this instructions, each embodiment adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar portion mutually see.
To the above-mentioned explanation of the disclosed embodiments, professional and technical personnel in the field are realized or uses the application.To be apparent for those skilled in the art to the multiple amendment of these embodiments, General Principle as defined herein when not departing from the spirit or scope of the application, can realize in other embodiments.Therefore, the application can not be restricted to these embodiments 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:
Response Client-initiated is to the inquiry request of object statistics item, and transfer SQL template corresponding with described object statistics item in preset configuration file, the query argument in described SQL template is variable;
According to Client-initiated query argument, be SQL statement by described SQL template switch;
Described SQL statement is utilized to inquire about the statistics corresponding with described object statistics item.
2. method according to claim 1, is characterized in that, the described statistics utilizing the inquiry of described SQL statement corresponding with described object statistics item, comprising:
Utilize hashing algorithm to process described SQL statement, obtain target hashed value;
In caching system, search object statistics result, described object statistics result is the result utilizing target SQL statement to inquire about gained in a database in advance, and the hashed value of described target SQL statement after described hashing algorithm process is identical with described target hashed value.
3. method according to claim 1, is characterized in that, also comprises:
Described statistics is graphically shown.
4. method according to claim 3, is characterized in that, when the number of described object statistics item is multiple, describedly described statistics graphically to be shown, comprising:
Multiple described statistics is shown in the same chart of the same page.
5. method according to claim 1, is characterized in that, also comprises:
According to the instruction of Client-initiated template operation, process the SQL template in described configuration file, described template operation instruction comprises increase, deletes and/or amendment SQL template.
6. a data query arrangement, is characterized in that, comprising:
Request-response unit, for responding the inquiry request of Client-initiated to object statistics item, transfer SQL template corresponding with described object statistics item in preset configuration file, the query argument in described SQL template is variable;
Described SQL template switch, for according to Client-initiated query argument, is SQL statement by template switch unit;
Result determining unit, inquires about the statistics corresponding with described object statistics item for utilizing described SQL statement.
7. device according to claim 6, is characterized in that, described result determining unit comprises:
Hashing unit, for utilizing hashing algorithm to process described SQL statement, obtains target hashed value;
Hash value matches unit, for searching object statistics result in caching system, described object statistics result is the result utilizing target SQL statement to inquire about gained in a database in advance, and the hashed value of described target SQL statement after described hashing algorithm process is identical with described target hashed value.
8. device according to claim 6, is characterized in that, also comprises:
Diagrammatic representation unit, for graphically showing described statistics.
9. device according to claim 8, is characterized in that, described diagrammatic representation unit comprises:
First diagrammatic representation subelement, for when the number of described object statistics item is multiple, shows multiple described statistics in the same chart of the same page.
10. device according to claim 6, is characterized in that, also comprises:
Template operation unit, for according to the instruction of Client-initiated template operation, processes the SQL template in described configuration file, and described template operation instruction comprises increase, deletes and/or amendment SQL template.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510258228.5A CN104809254A (en) | 2015-05-19 | 2015-05-19 | Data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510258228.5A CN104809254A (en) | 2015-05-19 | 2015-05-19 | Data query method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104809254A true CN104809254A (en) | 2015-07-29 |
Family
ID=53694076
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510258228.5A Pending CN104809254A (en) | 2015-05-19 | 2015-05-19 | Data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104809254A (en) |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105117213A (en) * | 2015-07-30 | 2015-12-02 | 青岛海尔智能家电科技有限公司 | Preprocessing method and apparatus based on release-subscription mode |
| CN105426481A (en) * | 2015-11-19 | 2016-03-23 | 北京京东尚科信息技术有限公司 | Data processing method and device |
| CN105989185A (en) * | 2015-11-04 | 2016-10-05 | 北京卓易讯畅科技有限公司 | System configuration method and system for routine task and tool generation |
| CN106610973A (en) * | 2015-10-21 | 2017-05-03 | 北京国双科技有限公司 | Television data query method and device |
| CN106776689A (en) * | 2016-11-10 | 2017-05-31 | 郑州云海信息技术有限公司 | A kind of host information querying method, device and main frame |
| CN107220327A (en) * | 2017-05-22 | 2017-09-29 | 千寻位置网络有限公司 | Data query method and system based on MongoDB, service terminal, memory |
| CN107515875A (en) * | 2016-06-16 | 2017-12-26 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN107844519A (en) * | 2017-10-09 | 2018-03-27 | 平安科技（深圳）有限公司 | Electronic installation, data base querying scenario generation method and storage medium |
| CN107908733A (en) * | 2017-11-14 | 2018-04-13 | 童友俊 | A kind of querying method of global trade data, apparatus and system |
| CN107943466A (en) * | 2016-10-13 | 2018-04-20 | 腾讯科技（深圳）有限公司 | Database access statement generation method, device and equipment |
| CN109033173A (en) * | 2018-06-21 | 2018-12-18 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of multidimensional index data |
| CN109165238A (en) * | 2018-06-21 | 2019-01-08 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of cyclical indicator data |
| CN109284323A (en) * | 2018-09-18 | 2019-01-29 | 武汉裕量信息科技有限公司 | The management method and device of detection data |
| CN109445768A (en) * | 2018-09-28 | 2019-03-08 | 平安科技（深圳）有限公司 | Database script generation method, device, computer equipment and storage medium |
| CN109635168A (en) * | 2018-12-12 | 2019-04-16 | 成都四方伟业软件股份有限公司 | Chart output method and device |
| CN109739876A (en) * | 2019-01-10 | 2019-05-10 | 中化石化销售有限公司 | The data query method and apparatus of database based on Sqltoy-orm frame |
| CN109739963A (en) * | 2018-12-27 | 2019-05-10 | 苏州龙信信息科技有限公司 | Information retrieval method, device, equipment and medium |
| CN110019350A (en) * | 2017-07-28 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Data query method and apparatus based on configuration information |
| CN110134705A (en) * | 2018-02-09 | 2019-08-16 | 中国移动通信集团有限公司 | A kind of data query method, cache server and terminal |
| CN110489465A (en) * | 2018-09-28 | 2019-11-22 | 北京数聚鑫云信息技术有限公司 | A kind of data bank access method and device |
| CN111339128A (en) * | 2018-12-18 | 2020-06-26 | 北京嘀嘀无限科技发展有限公司 | Data acquisition method and device, electronic equipment and storage medium |
| CN111752964A (en) * | 2019-06-10 | 2020-10-09 | 北京京东尚科信息技术有限公司 | Data processing method and device based on data interface |
| CN113535791A (en) * | 2020-04-14 | 2021-10-22 | 北京一起教育信息咨询有限责任公司 | Data generation method and device and electronic equipment |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070271251A1 (en) * | 2006-05-17 | 2007-11-22 | Jason Levine | Method and system for transferring data between MIME attachments and relational databases |
| CN101196926A (en) * | 2007-12-29 | 2008-06-11 | 中国建设银行股份有限公司 | Database access platform and access method thereof |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN102073640A (en) * | 2009-11-19 | 2011-05-25 | 阿里巴巴集团控股有限公司 | Method, system and server for testing structured query language (SQL) statements |
| CN103412766A (en) * | 2013-09-05 | 2013-11-27 | 曙光云计算技术有限公司 | User right-based data access method and device |
| CN103744891A (en) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | Method and system for data query |
| CN103914290A (en) * | 2012-12-31 | 2014-07-09 | 杭州勒卡斯广告策划有限公司 | Operating command processing method and device |
| CN104239368A (en) * | 2013-06-21 | 2014-12-24 | 苏州精易会信息技术有限公司 | Form data inquiring method based on setting |
| CN104572979A (en) * | 2014-12-31 | 2015-04-29 | 北京锐安科技有限公司 | SQL (Structured Query Language) processing method and device |
-
2015
- 2015-05-19 CN CN201510258228.5A patent/CN104809254A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070271251A1 (en) * | 2006-05-17 | 2007-11-22 | Jason Levine | Method and system for transferring data between MIME attachments and relational databases |
| CN101196926A (en) * | 2007-12-29 | 2008-06-11 | 中国建设银行股份有限公司 | Database access platform and access method thereof |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN102073640A (en) * | 2009-11-19 | 2011-05-25 | 阿里巴巴集团控股有限公司 | Method, system and server for testing structured query language (SQL) statements |
| CN103914290A (en) * | 2012-12-31 | 2014-07-09 | 杭州勒卡斯广告策划有限公司 | Operating command processing method and device |
| CN104239368A (en) * | 2013-06-21 | 2014-12-24 | 苏州精易会信息技术有限公司 | Form data inquiring method based on setting |
| CN103412766A (en) * | 2013-09-05 | 2013-11-27 | 曙光云计算技术有限公司 | User right-based data access method and device |
| CN103744891A (en) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | Method and system for data query |
| CN104572979A (en) * | 2014-12-31 | 2015-04-29 | 北京锐安科技有限公司 | SQL (Structured Query Language) processing method and device |
Cited By (32)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105117213A (en) * | 2015-07-30 | 2015-12-02 | 青岛海尔智能家电科技有限公司 | Preprocessing method and apparatus based on release-subscription mode |
| CN105117213B (en) * | 2015-07-30 | 2021-10-19 | 青岛海尔智能家电科技有限公司 | Pre-processing method and device based on publish-subscribe mode |
| CN106610973A (en) * | 2015-10-21 | 2017-05-03 | 北京国双科技有限公司 | Television data query method and device |
| CN105989185A (en) * | 2015-11-04 | 2016-10-05 | 北京卓易讯畅科技有限公司 | System configuration method and system for routine task and tool generation |
| CN105426481A (en) * | 2015-11-19 | 2016-03-23 | 北京京东尚科信息技术有限公司 | Data processing method and device |
| CN105426481B (en) * | 2015-11-19 | 2018-09-14 | 北京京东尚科信息技术有限公司 | Handle the method and device of data |
| CN107515875A (en) * | 2016-06-16 | 2017-12-26 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN107943466A (en) * | 2016-10-13 | 2018-04-20 | 腾讯科技（深圳）有限公司 | Database access statement generation method, device and equipment |
| CN107943466B (en) * | 2016-10-13 | 2021-06-01 | 腾讯科技（深圳）有限公司 | Database access statement generation method, device and equipment |
| CN106776689A (en) * | 2016-11-10 | 2017-05-31 | 郑州云海信息技术有限公司 | A kind of host information querying method, device and main frame |
| CN107220327A (en) * | 2017-05-22 | 2017-09-29 | 千寻位置网络有限公司 | Data query method and system based on MongoDB, service terminal, memory |
| CN110019350A (en) * | 2017-07-28 | 2019-07-16 | 北京京东尚科信息技术有限公司 | Data query method and apparatus based on configuration information |
| CN107844519A (en) * | 2017-10-09 | 2018-03-27 | 平安科技（深圳）有限公司 | Electronic installation, data base querying scenario generation method and storage medium |
| WO2019071898A1 (en) * | 2017-10-09 | 2019-04-18 | 平安科技（深圳）有限公司 | Electronic device, database query script generation method and storage medium |
| CN107908733A (en) * | 2017-11-14 | 2018-04-13 | 童友俊 | A kind of querying method of global trade data, apparatus and system |
| CN110134705A (en) * | 2018-02-09 | 2019-08-16 | 中国移动通信集团有限公司 | A kind of data query method, cache server and terminal |
| CN109165238B (en) * | 2018-06-21 | 2022-09-09 | 土巴兔集团股份有限公司 | Data processing method and device for generating period index data |
| CN109033173A (en) * | 2018-06-21 | 2018-12-18 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of multidimensional index data |
| CN109165238A (en) * | 2018-06-21 | 2019-01-08 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of cyclical indicator data |
| CN109284323A (en) * | 2018-09-18 | 2019-01-29 | 武汉裕量信息科技有限公司 | The management method and device of detection data |
| CN109284323B (en) * | 2018-09-18 | 2021-02-12 | 武汉裕量信息科技有限公司 | Management method and device for detection data |
| CN110489465A (en) * | 2018-09-28 | 2019-11-22 | 北京数聚鑫云信息技术有限公司 | A kind of data bank access method and device |
| CN109445768B (en) * | 2018-09-28 | 2022-02-11 | 平安科技（深圳）有限公司 | Database script generation method and device, computer equipment and storage medium |
| CN109445768A (en) * | 2018-09-28 | 2019-03-08 | 平安科技（深圳）有限公司 | Database script generation method, device, computer equipment and storage medium |
| CN109635168A (en) * | 2018-12-12 | 2019-04-16 | 成都四方伟业软件股份有限公司 | Chart output method and device |
| CN111339128A (en) * | 2018-12-18 | 2020-06-26 | 北京嘀嘀无限科技发展有限公司 | Data acquisition method and device, electronic equipment and storage medium |
| CN111339128B (en) * | 2018-12-18 | 2023-09-26 | 北京嘀嘀无限科技发展有限公司 | Data acquisition method and device, electronic equipment and storage medium |
| CN109739963A (en) * | 2018-12-27 | 2019-05-10 | 苏州龙信信息科技有限公司 | Information retrieval method, device, equipment and medium |
| CN109739876B (en) * | 2019-01-10 | 2021-01-12 | 中化石化销售有限公司 | Data query method and device for database based on Sqltoy-orm framework |
| CN109739876A (en) * | 2019-01-10 | 2019-05-10 | 中化石化销售有限公司 | The data query method and apparatus of database based on Sqltoy-orm frame |
| CN111752964A (en) * | 2019-06-10 | 2020-10-09 | 北京京东尚科信息技术有限公司 | Data processing method and device based on data interface |
| CN113535791A (en) * | 2020-04-14 | 2021-10-22 | 北京一起教育信息咨询有限责任公司 | Data generation method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104809254A (en) | Data query method and device | |
| CN101036141B (en) | A database management system with persistent, user- accessible bitmap values | |
| US7974981B2 (en) | Multi-value property storage and query support | |
| CN106776809B (en) | Data query method and system | |
| CN103632250A (en) | Quick sales order sorting, grouping and screening method | |
| Barmpis et al. | Comparative analysis of data persistence technologies for large-scale models | |
| JP2023022812A5 (en) | ||
| CN107015987B (en) | Method and equipment for updating and searching database | |
| CN106294478A (en) | The data processing method of data warehouse and device | |
| CN104573022A (en) | Data query method and device for HBase | |
| US20080140604A1 (en) | Converting arbitrary strings into numeric representations to facilitate complex comparisons | |
| CN105574054A (en) | Distributed cache range query method, apparatus and system | |
| CN106095964A (en) | A kind of method that data are carried out visualization filing and search | |
| CN106339498A (en) | Method, device and system for synchronizing data | |
| JP2012108635A (en) | Distributed memory database system, front database server, data processing method and program | |
| Liang et al. | Mid-model design used in model transition and data migration between relational databases and nosql databases | |
| US11853279B2 (en) | Data storage using vectors of vectors | |
| CN110795524A (en) | Main data mapping processing method and device, computer equipment and storage medium | |
| Kalampokis et al. | ICT tools for creating, expanding and exploiting statistical linked Open Data | |
| US12056191B2 (en) | Bitmap filter, a method of generating the same, and a method of using a bitmap filter to perform a join | |
| US9047328B2 (en) | Searching entity-key associations using in-memory objects | |
| CN105046414A (en) | Business tracing method and business tracing device applied to ERP systems | |
| CN109978513A (en) | Obtain method and apparatus, project task management equipment and the medium of technical standard | |
| KR20160117965A (en) | Method and apparatus for generating NoSQL model | |
| CN106547898A (en) | A kind of data processing method and device of distributed data base |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 450000 Zhengzhou science and technology zone, Henan high tech Road, building 169, building 1, No. 1 Applicant after: ZHENGZHOU XIZHI INFORMATION TECHNOLOGY CO., LTD. Address before: 450000 Zhengzhou science and technology zone, Henan high tech Road, building 169, building 1, No. 1 Applicant before: ZHENGZHOU XIZHI INFORMATION TECHNOLOGY CO., LTD. |
|
| COR | Change of bibliographic data | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150729 |