CN102968482A - Data query method and data query device - Google Patents
Data query method and data query device Download PDFInfo
- Publication number
- CN102968482A CN102968482A CN2012104754653A CN201210475465A CN102968482A CN 102968482 A CN102968482 A CN 102968482A CN 2012104754653 A CN2012104754653 A CN 2012104754653A CN 201210475465 A CN201210475465 A CN 201210475465A CN 102968482 A CN102968482 A CN 102968482A
- Authority
- CN
- China
- Prior art keywords
- user
- scheme
- data
- query
- key word
- 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 embodiment of the invention discloses a data query method and a data query device, which can improve the efficiency of data query. The method comprises the following steps of: receiving request information sent by a user, wherein the request information contains key words for data query; storing the key words, and distributing scheme marks to the stored key words; and returning the scheme marks to users. The embodiment of the invention also provides a data query device. Through the data query method and data query device provided by the embodiment of the invention, the efficiency of data query can be effectively improved.
Description
Technical field
The present invention relates to data processing field, relate in particular to a kind of data enquire method and device.
Background technology
Along with development and the accumulation of the whole world (IT, Information Technology) technology, database has become one of basis of IT technical development.There are various types of Database Systems in the prior art, Microsoft SQL Server for example, Oracle, DB2, MySQL etc., the user uses these databases to carry out data storage and query.
A kind of data enquire method of the prior art is: Database Systems provide the key word interface to the user, inputted the keyword message of wishing inquiry by the user, Database Systems are according to the data of keyword message match query success in database of user input, and return to the user.
For example the user wishes to inquire about this month sales department and the cost of customer department, then may input following key word: " November, cost, sales department, customer department ".
But have following shortcoming in the scheme of prior art: the user needs to input keyword message at every turn when carrying out data query, and the sometimes key word difference repeatedly inputted of user is little, even identical, but still need the user word for word to input, for example the user inquire about this month sales department and the key word inputted during the cost of customer department be " November; cost; sales department, customer department ", the user wishes again to inquire about sales department and the cost of customer department last month afterwards, then the user also needs to input key word " October; cost, sales department, customer department ", this has carried out a large amount of duplication of labour concerning the user, reduced the efficient of data query.
Summary of the invention
The embodiment of the invention discloses a kind of data enquire method and device, efficient that can the Effective Raise data query.
The data enquire method that the embodiment of the invention provides comprises:
Receive the solicited message that the user sends, carry in the described request information be used to the key word that carries out data query;
Described key word is stored, and the keyword assignment scheme of storage is identified;
Return described scheme sign to the user.
Alternatively, also comprise after the solicited message that described reception user sends:
According to the data of described key word match query in database, and return the data that inquire to described user.
Alternatively, describedly after returning described scheme sign, the user comprises:
Receive user's scheme query requests, carry the scheme sign in the described scheme query requests;
According to the data of key word match query in database corresponding to described scheme sign, and return the data that inquire to described user.
Alternatively, describedly after returning described scheme sign, the user comprises:
Receive user's scheme query requests, carry the scheme sign in the described scheme query requests;
Show key word corresponding to described scheme sign to the user;
Receive the key word after the user upgrades;
Use the data of the key word match query in database after upgrading, and return the data that inquire to described user.
Alternatively, described method also comprises:
The scheme of distributing is identified between the user who meets prerequisite shares.
The data query device that the embodiment of the invention provides comprises:
Receiving element is used for receiving the solicited message that the user sends, and carries in the described request information be used to the key word that carries out data query;
Storage unit is used for described key word is stored, and the keyword assignment scheme of storage is identified;
Return the unit, be used for returning described scheme sign to the user.
Alternatively, described device also comprises:
Query unit is used for according to the data of described key word in the database match query, and returns the data that inquire to described user.
Alternatively, described receiving element also is used for receiving user's scheme query requests, carries the scheme sign in the described scheme query requests;
Described query unit also is used for identifying corresponding key word in the data of database match query according to described scheme, and returns the data that inquire to described user.
Alternatively, described data query device also comprises: updating block;
Described receiving element also is used for receiving user's scheme query requests, carries the scheme sign in the described scheme query requests;
Described updating block is used for showing key word corresponding to described scheme sign to the user, and receives the key word after the user upgrades;
Key word after described query unit also be used for to use is upgraded is in the data of database match query, and returns the data that inquire to described user.
Alternatively, described data query device also comprises:
Shared cell, the scheme that is used for distributing is identified between the user who meets prerequisite to be shared.
Can be found out that by technique scheme the embodiment of the invention has following beneficial effect:
In the embodiment of the invention, the data query device receives after the request message of user's transmission, can will preserve for the key word that carries out data query in this request message, and give the keyword assignment scheme of preserving sign, simultaneously, the party's pattern identification can also be returned to the user, so can set up the corresponding relation between key word and the scheme sign in the embodiment of the invention, so that the user only needs when inquiring about next time the input scheme sign can finish inquiry, and need not again to repeat to input concrete key word, so can the Effective Raise efficiency data query.
Description of drawings
Fig. 1 is embodiment synoptic diagram of data enquire method in the embodiment of the invention;
Fig. 2 is another embodiment synoptic diagram of data enquire method in the embodiment of the invention;
Fig. 3 is that scheme is preserved the interface synoptic diagram in the embodiment of the invention;
Fig. 4 is embodiment synoptic diagram of data query device in the embodiment of the invention;
Fig. 5 is another embodiment synoptic diagram of data query device in the embodiment of the invention.
Embodiment
The embodiment of the invention discloses a kind of data enquire method and device, efficient that can the Effective Raise data query.
See also Fig. 1, embodiment of data enquire method comprises in the embodiment of the invention:
101, receive the solicited message that the user sends;
In the present embodiment, when the user wishes to carry out data query, can think that the data query device sends a request message, and can carry be used to the key word that carries out data query in this request message.
102, key word is stored, and the keyword assignment scheme of storage is identified;
The data query device receives after the request message of user's transmission, can extract key word wherein, these key words is stored, and the keyword assignment scheme of storage is identified, so that the corresponding scheme sign of this set of keyword.
103, return the scheme sign to the user.
When the data query device is stored these key words, and after the keyword assignment scheme sign to storage, can return the scheme sign to the user.
In the present embodiment, the data query device receives after the request message of user's transmission, can will preserve for the key word that carries out data query in this request message, and give the keyword assignment scheme of preserving sign, simultaneously, the party's pattern identification can also be returned to the user, so can set up the corresponding relation between key word and the scheme sign in the embodiment of the invention, so that the user only needs when inquiring about next time the input scheme sign can finish inquiry, and need not again to repeat to input concrete key word, so can the Effective Raise efficiency data query.
For ease of understanding, the below is elaborated to data enquire method of the present invention with an instantiation, sees also Fig. 2, and another embodiment of embodiment of the invention data enquire method comprises:
201, receive the solicited message that the user sends;
In the present embodiment, when the user wishes to carry out data query, can think that the data query device sends a request message, and can carry be used to the key word that carries out data query in this request message.
In the present embodiment, suppose that the user wishes to inquire about on October 1st, 2012 between 1 day November in 2012 in database, name is called equipment failure that the lane detector of JCQ-01-05 the occurs event of inner event level for " high " that report an error in the lane detector of detection system, then the key word that carries in request message of user can be " 2012.10.1 ~ 2012.11.1; high, equipment failure reports an error, JCQ-01-05; lane detector, detection system ".
202, key word is stored, and the keyword assignment scheme of storage is identified;
The data query device receives after the request message of user's transmission, can extract key word wherein, these key words is stored, and the keyword assignment scheme of storage is identified, so that the corresponding scheme sign of this set of keyword.
For example, the data query device gets access to key word " 2012.10.1 ~ 2012.11.1, high, equipment failure reports an error, JCQ-01-05, lane detector, detection system " afterwards, can distribute a scheme sign " query scheme three " for it.
Need to prove, in the present embodiment, if the user needs just to inquire about now, then the data query device can also be directly according to key word " 2012.10.1 ~ 2012.11.1, high, equipment failure reports an error; JCQ-01-05; lane detector, detection system " data of match query in database, and return the data that inquire to this user.
If the user does not temporarily need direct inquiry, then the data query device also can be inquired about, and waits for user's query requests next time.
203, return the scheme sign to the user.
When the data query device is stored these key words, and after the keyword assignment scheme sign to storage, can return the scheme sign to the user.
204, receive user's scheme query requests;
In the present embodiment, after the user had got access to scheme sign, if wish again to inquire about, then the user can the delivery plan query requests, carries the scheme sign in this scheme query requests.
For example, the user can carry " query scheme three " in the scheme query requests.
In the present embodiment, after the scheme sign is distributed, the data query device can be identified at the scheme of distributing between the user who meets prerequisite to be shared, this prerequisite can refer to have identical authority, or reach some authorities, or all users etc., specifically do not do restriction herein.
Above-mentioned sharing can be so that a plurality of user can use the party's pattern identification, thereby finds corresponding key word to carry out data query, and is not that the user who only sends a request message could use the party's pattern identification.
205, to key word corresponding to user's exhibition scheme sign;
The data query device can find key word corresponding to the party's pattern identification according to scheme sign wherein, and show these key words to the user after receiving user's scheme query requests.
In the present embodiment, concrete scheme sign can be " query scheme three ", the key word that the party's pattern identification is corresponding is " 2012.10.1 ~ 2012.11.1; high; equipment failure reports an error, JCQ-01-05, lane detector; detection system ", so the user can see scheme as shown in Figure 3 the interface is set.
Need to prove that in the present embodiment, the user at any time can arrange by scheme as shown in Figure 3 the interface corresponding relation between the scheme of having preserved sign and the key word is made amendment.
206, the key word after the reception user upgrades;
In the present embodiment, if the user wishes to carry out some modifications on the basis of key word corresponding to " query scheme three ", then the user can upgrade key word corresponding to " query scheme three ", for example the user wishes to inquire about on October 1st, 2012 between 1 day November in 2012, name is called equipment failure that the lane detector of JCQ-01-06 the occurs inner event level that reports an error and is the event of " high " in the lane detector of detection system, and then the user can be revised as " JCQ-01-06 " with " JCQ-01-05 " in the original keyword.
Be understandable that, if other key word of user's desired modifications also can be inhaled monster in a comparable manner, do not do restriction herein.
Need to prove that in actual applications, the user can select to revise key word, can select not revise key word yet, if do not revise key word, then this step can not carried out.
207, use the data of the key word match query in database after upgrading;
After the user upgraded key word, then the data query device can use the data of the key word match query in database after the renewal.
For example, the data query device can use key word " 2012.10.1 ~ 2012.11.1, high, equipment failure reports an error, JCQ-01-06, lane detector, detection system " data of match query in database.
Need to prove that if the user does not revise key word, then the data query device still can use key word " 2012.10.1 ~ 2012.11.1; high, equipment failure reports an error, JCQ-01-05; lane detector, detection system " data of match query in database.
208, return the data that inquire to the user.
After the data query device inquires the data of coupling, then can return the data that inquire to the user.
In the present embodiment, the data query device receives after the request message of user's transmission, can will preserve for the key word that carries out data query in this request message, and give the keyword assignment scheme of preserving sign, simultaneously, the party's pattern identification can also be returned to the user, so can set up the corresponding relation between key word and the scheme sign in the embodiment of the invention, so that the user only needs when inquiring about next time the input scheme sign can finish inquiry, and need not again to repeat to input concrete key word, so can the Effective Raise efficiency data query;
Secondly, the scheme sign can be shared between different users, thereby so that different users can both use the party's pattern identification to find corresponding key word to carry out data query, so further improved efficiency data query.
The above is described the data enquire method in the embodiment of the invention, and the below is described the data query device in the embodiment of the invention, sees also Fig. 4, and embodiment of the data query device in the embodiment of the invention comprises:
Receiving element 401 is used for receiving the solicited message that the user sends, and carries in this solicited message be used to the key word that carries out data query;
In the present embodiment, receiving element 401 receives after the request message of user's transmission, storage unit 402 can will be preserved for the key word that carries out data query in this request message, and give the keyword assignment scheme of preserving sign, simultaneously, return unit 403 and the party's pattern identification can also be returned to the user, so can set up the corresponding relation between key word and the scheme sign in the embodiment of the invention, so that the user only needs when inquiring about next time the input scheme sign can finish inquiry, and need not again to repeat to input concrete key word, so can the Effective Raise efficiency data query.
For ease of understanding, the below is described in detail the data query device in the embodiment of the invention with an instantiation, sees also Fig. 5, and another embodiment of data query device in the embodiment of the invention comprises:
Receiving element 501 is used for receiving the solicited message that the user sends, and carries in this solicited message be used to the key word that carries out data query;
Data query device in the present embodiment can further include:
Receiving element 501 in the present embodiment also is used for receiving user's scheme query requests, carries the scheme sign in this scheme query requests;
Data query device in the present embodiment can further include: updating block 505;
Receiving element 501 in the present embodiment also is used for receiving user's scheme query requests, carries the scheme sign in this scheme query requests;
Updating block 505 in the present embodiment is used for showing the key word that the party's pattern identification is corresponding to the user, and the key word after the reception user renewal;
Key word after query unit 504 in the present embodiment also be used for to use is upgraded is in the data of database match query, and returns the data that inquire to this user.
Need to prove that the data query device in the present embodiment can further include:
The function of each unit in the present embodiment data query device and the flow process of aforementioned middle description embodiment illustrated in fig. 2 are similar, repeat no more herein.
In the present embodiment, receiving element 501 receives after the request message of user's transmission, storage unit 502 can will be preserved for the key word that carries out data query in this request message, and give the keyword assignment scheme of preserving sign, simultaneously, return unit 503 and the party's pattern identification can also be returned to the user, so can set up the corresponding relation between key word and the scheme sign in the embodiment of the invention, so that the user only needs when inquiring about next time the input scheme sign can finish inquiry, and need not again to repeat to input concrete key word, so can the Effective Raise efficiency data query;
Secondly, shared cell 506 can be identified at the scheme of distributing between the user who meets prerequisite to be shared, so that thereby different users can both use the party's pattern identification to find corresponding key word to carry out data query, so further improved efficiency data query.
One of ordinary skill in the art will appreciate that all or part of step that realizes in above-described embodiment method is to come the relevant hardware of instruction to finish by program, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium of mentioning can be ROM (read-only memory), disk or CD etc.
More than a kind of data enquire method provided by the present invention and device are described in detail, for one of ordinary skill in the art, thought according to the embodiment of the invention, all will 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:
Receive the solicited message that the user sends, carry in the described request information be used to the key word that carries out data query;
Described key word is stored, and the keyword assignment scheme of storage is identified;
Return described scheme sign to the user.
2. data enquire method according to claim 1 is characterized in that, also comprises after the solicited message that described reception user sends:
According to the data of described key word match query in database, and return the data that inquire to described user.
3. method according to claim 1 and 2 is characterized in that, describedly comprises after the user returns described scheme sign:
Receive user's scheme query requests, carry the scheme sign in the described scheme query requests;
According to the data of key word match query in database corresponding to described scheme sign, and return the data that inquire to described user.
4. method according to claim 1 and 2 is characterized in that, describedly comprises after the user returns described scheme sign:
Receive user's scheme query requests, carry the scheme sign in the described scheme query requests;
Show key word corresponding to described scheme sign to the user;
Receive the key word after the user upgrades;
Use the data of the key word match query in database after upgrading, and return the data that inquire to described user.
5. method according to claim 1 and 2 is characterized in that, described method also comprises:
The scheme of distributing is identified between the user who meets prerequisite shares.
6. a data query device is characterized in that, comprising:
Receiving element is used for receiving the solicited message that the user sends, and carries in the described request information be used to the key word that carries out data query;
Storage unit is used for described key word is stored, and the keyword assignment scheme of storage is identified;
Return the unit, be used for returning described scheme sign to the user.
7. device according to claim 6 is characterized in that, described device also comprises:
Query unit is used for according to the data of described key word in the database match query, and returns the data that inquire to described user.
8. device according to claim 7 is characterized in that, described receiving element also is used for receiving user's scheme query requests, carries the scheme sign in the described scheme query requests;
Described query unit also is used for identifying corresponding key word in the data of database match query according to described scheme, and returns the data that inquire to described user.
9. device according to claim 7 is characterized in that, described data query device also comprises: updating block;
Described receiving element also is used for receiving user's scheme query requests, carries the scheme sign in the described scheme query requests;
Described updating block is used for showing key word corresponding to described scheme sign to the user, and receives the key word after the user upgrades;
Key word after described query unit also be used for to use is upgraded is in the data of database match query, and returns the data that inquire to described user.
10. device according to claim 7 is characterized in that, described data query device also comprises:
Shared cell, the scheme that is used for distributing is identified between the user who meets prerequisite to be shared.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2012104754653A CN102968482A (en) | 2012-11-21 | 2012-11-21 | Data query method and data query device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2012104754653A CN102968482A (en) | 2012-11-21 | 2012-11-21 | Data query method and data query device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102968482A true CN102968482A (en) | 2013-03-13 |
Family
ID=47798620
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2012104754653A Pending CN102968482A (en) | 2012-11-21 | 2012-11-21 | Data query method and data query device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102968482A (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104572673A (en) * | 2013-10-15 | 2015-04-29 | 威廉·肖 | Information inquiry method and device |
CN104572674A (en) * | 2013-10-15 | 2015-04-29 | 威廉·肖 | Information processing method and device |
CN104580080A (en) * | 2013-10-15 | 2015-04-29 | 威廉·肖 | Message verification method and device |
CN106095775A (en) * | 2016-05-24 | 2016-11-09 | 中国银行股份有限公司 | A kind of method and system realizing data query or derivation |
CN110704548A (en) * | 2019-09-30 | 2020-01-17 | 北京元年科技股份有限公司 | System and method for screening efficient computing data for multidimensional databases |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6370532B1 (en) * | 1998-11-09 | 2002-04-09 | Unisys Corporation | Cool ICE batch interface |
CN1625252A (en) * | 2003-10-14 | 2005-06-08 | 索尼株式会社 | System and server for providing information, user terminal device, contents display device and method |
CN102508927A (en) * | 2011-12-01 | 2012-06-20 | 中国核工业二三建设有限公司 | Device and method of data synchronization technology based on nuclear power construction multi-project management |
-
2012
- 2012-11-21 CN CN2012104754653A patent/CN102968482A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6370532B1 (en) * | 1998-11-09 | 2002-04-09 | Unisys Corporation | Cool ICE batch interface |
CN1625252A (en) * | 2003-10-14 | 2005-06-08 | 索尼株式会社 | System and server for providing information, user terminal device, contents display device and method |
CN102508927A (en) * | 2011-12-01 | 2012-06-20 | 中国核工业二三建设有限公司 | Device and method of data synchronization technology based on nuclear power construction multi-project management |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104572673A (en) * | 2013-10-15 | 2015-04-29 | 威廉·肖 | Information inquiry method and device |
CN104572674A (en) * | 2013-10-15 | 2015-04-29 | 威廉·肖 | Information processing method and device |
CN104580080A (en) * | 2013-10-15 | 2015-04-29 | 威廉·肖 | Message verification method and device |
CN106095775A (en) * | 2016-05-24 | 2016-11-09 | 中国银行股份有限公司 | A kind of method and system realizing data query or derivation |
CN110704548A (en) * | 2019-09-30 | 2020-01-17 | 北京元年科技股份有限公司 | System and method for screening efficient computing data for multidimensional databases |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP6940662B2 (en) | Methods and systems for the protection and verification of identities and certificates via the blockchain | |
CN101876983B (en) | Method for partitioning database and system thereof | |
US8886590B2 (en) | Master data management in a data warehouse/data mart | |
CN102272756B (en) | Method of integrating in real time large volumes of updates in database | |
CN102426602A (en) | Scoped database connections | |
CN107533569B (en) | System and method for sandbox support in a multidimensional database environment | |
CN101268439A (en) | Database fragment cloning and management | |
CN103092903A (en) | Database Log Parallelization | |
CN102968482A (en) | Data query method and data query device | |
CN104160381A (en) | Managing tenant-specific data sets in a multi-tenant environment | |
CN103294675A (en) | Method and device for updating data in distributed storage system | |
CN100426293C (en) | Object integrated management system | |
CN103544153A (en) | Data updating method and system based on database | |
CN101655871A (en) | Method and device for storing and inquiring data | |
CN102202087A (en) | Method for identifying storage equipment and system thereof | |
CN104216955A (en) | Methods and devices for operating data and managing events and distributed system | |
US20080104008A1 (en) | Common data broker method, system, and program product | |
CN102346744A (en) | Device for processing materialized table in multi-tenancy (MT) application system | |
CN110427775A (en) | Data query authority control method and device | |
CN111385370B (en) | ID allocation method, device, storage medium and ID allocation system | |
CN102385617A (en) | Dynamic domain query and query translation | |
US8700565B2 (en) | Method and system for data filing systems | |
CN101452556A (en) | Customer information processing system and method | |
CN104461736B (en) | Resource allocation and searching method, resource allocation and search system and Cloud Server | |
CN112364021B (en) | Service data processing method, device and storage medium |
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 |
Application publication date: 20130313 |