CN107133300A - A kind of data query method and device - Google Patents

A kind of data query method and device Download PDF

Info

Publication number
CN107133300A
CN107133300A CN201710288467.4A CN201710288467A CN107133300A CN 107133300 A CN107133300 A CN 107133300A CN 201710288467 A CN201710288467 A CN 201710288467A CN 107133300 A CN107133300 A CN 107133300A
Authority
CN
China
Prior art keywords
keyword
key word
data
file
inquiry
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
Application number
CN201710288467.4A
Other languages
Chinese (zh)
Inventor
沈文策
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian Cnfol Information Technology Co Ltd
Original Assignee
Fujian Cnfol Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fujian Cnfol Information Technology Co Ltd filed Critical Fujian Cnfol Information Technology Co Ltd
Priority to CN201710288467.4A priority Critical patent/CN107133300A/en
Publication of CN107133300A publication Critical patent/CN107133300A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2393Updating materialised views
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2453Query optimisation
    • G06F16/24534Query rewriting; Transformation
    • G06F16/24535Query rewriting; Transformation of sub-queries or views
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24552Database cache management

Abstract

The present invention has been disclosed a kind of data query method and apparatus, applied to system server, the system server is connected with data server, it is characterized in that, be stored with the key word file generated according to the data place of the data server in the system server, methods described receives the query statement that user terminal is sent, and the query statement includes key word of the inquiry;The query statement is parsed, the key word of the inquiry is obtained;The key word file is searched for according to the key word of the inquiry, keyword search results corresponding with the key word of the inquiry are obtained;The keyword search results are returned into the user terminal to be shown.Due to being the inquiry carried out to the key word file in system server according to the query statement of user terminal, data are not operated directly, the performance of database is not interfered with even if when inquiring about more yet, it is to avoid database server is paralysed.

Description

A kind of data query method and device
Technical field
It is to be related to a kind of data query method and device in particular the present invention relates to technical field of data processing.
Background technology
When user need inquire about it is to be understood that information when, be generally required for being needed by way of inquiring about database The information of inquiry.
For example, during inquiry stock market, user is instructed by user terminal input inquiry, including stock code " 1 ", send The system server of user terminal communication is given, system server is received after query statement, inquire about the data clothes being attached thereto The database being engaged in device, obtains the stock information related to stock code " 1 " as Query Result, returns to user terminal.
But, such a inquiry mode direct to database can be operated, can simultaneously when having multiple queries while when carrying out Data are carried out with inquiry operation, overload, collapse occurs in database, or even causes database server to be paralysed.
The content of the invention
In view of this, the invention provides a kind of data query method and device, database is not operated directly, in inquiry Also will not be to database build-up of pressure when more, it is to avoid database server is paralysed.
The invention provides a kind of data query method, applied to system server, the system server takes with data Business device is connected, and be stored with the keyword text generated according to the data place of the data server in the system server Part, the key word file includes the tables of data that data structure is simplified to the tables of data in database, and methods described includes:
The query statement that user terminal is sent is received, the query statement includes key word of the inquiry;
The query statement is parsed, the key word of the inquiry is obtained;
Inquired about according to the key word of the inquiry in the key word file, obtain corresponding to the key word of the inquiry Keyword search results;
The keyword search results are returned into the user terminal to be shown.
It is preferred that, the detailed process bag of the key word file generated according to the data place of the data server Include:
Obtaining in default file generated rule, the file generated rule at least includes key field and keyword letter Cease field;
The keyword of key data table is included according to the tables of data generation that the key field inquires about the database Cache file;
The tables of data generation of database according to the keyword message Field Inquiry includes keyword message tables of data Keyword message cache file;
It regard the keyword cache file and the keyword message cache file as the key word file.
It is preferred that, it is described that the key word file is searched for according to the key word of the inquiry, obtain and the key word of the inquiry Corresponding keyword search results include:
Key data table in the keyword cache file is searched according to the key word of the inquiry, obtains looking into described Ask keyword and matching keyword that keyword matches;
According to the matching keyword, the keyword message tables of data in the keyword message cache file is searched, is obtained To the keyword message corresponding with the matching keyword;
The keyword and the keyword message are combined, keyword search results are obtained.
It is preferred that, in addition to:
According to preset time rule, the key word file is updated.
It is preferred that, in addition to:
The key word file is sent to user terminal so that the user terminal is protected to the key word file Deposit.
Another aspect of the present invention provides a kind of data query arrangement, applied to system server, the system server It is connected with data server, be stored with the pass generated according to the data place of the data server in the system server Keyword file, the key word file includes the tables of data that data structure is simplified to the tables of data in database, described device Including:
Reception device, the query statement for receiving user terminal transmission, the query statement includes key word of the inquiry;
Resolver, for parsing the query statement, obtains the key word of the inquiry;
Inquiry unit, for being inquired about according to the key word of the inquiry in the key word file, obtain with it is described The corresponding keyword search results of key word of the inquiry;
Return mechanism, is shown for the keyword search results to be returned into the user terminal.
It is preferred that, in addition to key word file generating means, the key word file generating means are for according to the number The key word file generated according to the data place of server, is specifically included:
Acquiring unit, at least includes keyword for obtaining in default file generated rule, the file generated rule Field and keyword message field;
First generation unit, the tables of data generation for inquiring about the database according to the key field includes key The keyword cache file of digital data table;
Second generation unit, includes for the tables of data generation of database according to the keyword message Field Inquiry The keyword message cache file of keyword message tables of data;
Key word file generation unit, for the keyword cache file and the keyword message cache file to be made For the key word file.
It is preferred that, the inquiry unit includes:
First query unit, for searching the number of keyword in the keyword cache file according to the key word of the inquiry According to table, obtain the keyword that matches with the key word of the inquiry and match keyword;
Second query unit, for according to the matching keyword, searching the pass in the keyword message cache file Key word information data table, obtains the keyword message corresponding with the matching keyword;
As a result generation unit, for the keyword and the keyword message to be combined, obtains keyword query knot Really.
It is preferred that, in addition to:
Updating device, for according to preset time rule, being updated to the key word file.
It is preferred that, in addition to:
Sending module, for sending the key word file to user terminal so that the user terminal is to the key Word file is preserved.
Understand that compared with prior art, the present invention has been disclosed a kind of data query method via above-mentioned technical scheme And device, applied to system server, the system server is connected with data server, it is characterised in that the system Be stored with the key word file generated according to the data place of the data server in server, and the key word file includes The tables of data of data structure is simplified to the tables of data in database, methods described receives the query statement that user terminal is sent, The query statement includes key word of the inquiry;The query statement is parsed, the key word of the inquiry is obtained;According to the inquiry Key word file described in keyword search, obtains keyword search results corresponding with the key word of the inquiry;By the key Word Query Result returns to the user terminal and shown.Due to being in system server according to the query statement of user terminal The inquiry that carries out of key word file, data are not operated directly, even if also not interfering with database when inquiring about more Performance, it is to avoid database server is paralysed, and because the data structure of the tables of data in key word file have passed through simplification, is carried High search efficiency.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing There is the accompanying drawing used required in technology description to be briefly described, it should be apparent that, drawings in the following description are only this The embodiment of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis The accompanying drawing of offer obtains other accompanying drawings.
Fig. 1 is a kind of schematic flow sheet for data query method that the embodiment of the present application is provided;
Fig. 2 is the schematic flow sheet for the generation key word file that the embodiment of the present application is provided;
Fig. 3 is a kind of structural representation for data query arrangement that the embodiment of the present application is provided;
Fig. 4 is the structural representation for another data query arrangement that the embodiment of the present application is provided.
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 carried out clear, complete Site preparation is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than whole embodiments.It is based on Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under the premise of creative work is not made Embodiment, belongs to the scope of protection of the invention.
Fig. 1 is a kind of schematic flow sheet for data query method that the embodiment of the present application is provided.
Referring to Fig. 1, the invention provides a kind of data query method, applied to system server, the system server It is connected with data server, be stored with the pass generated according to the data place of the data server in the system server Keyword file, the key word file includes the tables of data that data structure is simplified to the tables of data in database;
The main application scenarios of the application can include user terminal, system server and data server.Wherein, user Terminal is communicated with system server, and user terminal is used as service end as client, system server.With system server The database for also including preserving application in data server, data server being connected, stores the data of various applications, For example in stock application, database purchase has tables of data, and tables of data includes multiple fields, for example, stock code, stock information, Remark information, jobbing firm's information etc..
In the embodiment of the present application, key word file is stored in system server, key word file is according to database Data structure of the data structure relative to the tables of data of database in data server of tables of data in generation, key word file Simplify a lot.For example, the data structure of the tables of data of database is divided at least eight field, and the tables of data of key word file Only include 2 fields.
Wherein, the selection of 2 fields is determined according to user's actual need, can be pre-set by developer, Can also be according to being modified the need for user, detailed process is followed by being discussed in detail.
Methods described includes:
S101, the query statement for receiving user terminal transmission, the query statement include key word of the inquiry;
S102, the parsing query statement, obtain the key word of the inquiry;
In the embodiment of the present application, user terminal receives the key word of the inquiry of user's input, and user terminal is closed according to the inquiry Key word generates query statement, and is sent in system server, and system server receives the query statement.Wherein, query statement In include key word of the inquiry.
System server parses the query statement, obtains key word of the inquiry.
Wherein, key word of the inquiry can specifically include character, numeral or sentence etc..
S103, inquired about in the key word file according to the key word of the inquiry, obtain and the inquiry is crucial The corresponding keyword search results of word;
Parse after key word of the inquiry, inquiry operation is carried out to key word file according to the key word of the inquiry, closed Key word Query Result.
Wherein, the mode of inquiry can use the mode of fuzzy query to be inquired about.Obtained Query Result is looked into this Ask the result that keyword is matched, i.e. keyword search results.
S104, the keyword search results are returned into the user terminal shown.
Finally, say that the keyword search results return to user terminal, user terminal by the keyword search results according to Preset rules are shown.
Wherein pre-, if rule includes paging rule, display rule and ordering rule, it is every that paging rule characterizes user terminal Number of entries shown by page, to show that display of the rule for characterizing shown data is various, such as color, font;Sequence Rule is used to characterize display data from top to bottom and put in order, for example, carry out ascending order or descending sort according to initial.Certainly, Screening rule can also be included, for filtering out the data for the screening conditions for meeting user's input.
It can be seen from the above technical proposal that due to being to the pass in system server according to the query statement of user terminal Data are not operated directly, the performance of database are not interfered with even if when inquiring about more yet by the inquiry that keyword file is carried out, Avoid database server from paralysing, and because the data structure of the tables of data in key word file have passed through simplification, improve Search efficiency.And take full advantage of preset rules and shown so that display result is more accurate, improves the body of user Test.
In preceding solution, key word file is referred to, key word file storage is not with system server, preserving Onto data server, the direct operation to the database in data server is so avoided so as to Database Dynamic Inquiry mode be changed to the inquiry mode static to data file, greatly improve search efficiency.
Described in detail below to how to generate key word file.
Fig. 2 is the schematic flow sheet of generation key word file in the embodiment of the present application.
Referring to Fig. 2, the detailed process bag of the key word file generated according to the data place of the data server Include:
At least include key field and pass in S201, the default file generated rule of acquisition, the file generated rule Key word information field;
Key word file is generated, dependence is file generated rule, and the rule can be set by the user, certainly, also in life Into the create-rule that user is inputted is obtained before, it can also be according to the model of user terminal to match default file generated Rule.For example, obtaining the model mobile terminal of user terminal, then it is critical field and pass to match default file generated rule Key word information field.
S202, the tables of data generation for inquiring about according to the key field database include the pass of key data table Key word cache file;
S203, the tables of data generation of database according to the keyword message Field Inquiry include keyword message number According to the keyword message cache file of table;
Then the key field in file generated rule inquires about the tables of data of the database, obtains number of keyword According to table, keyword cache file is generated.Wherein, key data table includes the key field and rope of tables of data in database Draw field.Wherein, index field is unique field in database, associated with key field.
Meanwhile, the tables of data always according to database described in the keyword message Field Inquiry in file generated rule is closed Key word information data table, generates keyword message cache file.Wherein, keyword message tables of data includes data in database The keyword message field and index field of table.
In this way, multiple fields of the tables of data in original database have been simplified into single two files, Mei Gewen Be stored with a critical field in part, when being inquired about, can improve recall precision.
Certainly, different according to create-rule, the quantity of the cache file of generation also can be different.
S204, it regard the keyword cache file and the keyword message cache file as the key word file.
Finally, the keyword cache file and the keyword message cache file are regard as the key word file. Wherein key word file is xml document.
Due to having previously generated key word file and being stored in system server, therefore, when the inquiry for receiving terminal During instruction, it is not necessary to access database and can be obtained by Query Result.
It is described that the key word file is searched for according to the key word of the inquiry on the basis of previous embodiment, obtain with The corresponding keyword search results of key word of the inquiry include:
Key data table in the keyword cache file is searched according to the key word of the inquiry, obtains looking into described Ask keyword and matching keyword that keyword matches;
According to the matching keyword, the keyword message tables of data in the keyword message cache file is searched, is obtained To the keyword message corresponding with the matching keyword;
The keyword and the keyword message are combined, keyword search results are obtained.
When searching keyword file obtains keyword query result, key data is found first by key word of the inquiry Matching keyword in table, the matching keyword is exactly the coding corresponding to index field.Then the volume of index field is used Code searches corresponding keyword message in key data table.
Finally, assignment operation is carried out to keyword using index field, i.e., by index field identical keyword and key Word information is combined, and obtains keyword search results.
It is preferred that, in addition to:
According to preset time rule, the key word file is updated.
Because the data of the database in data server can update, therefore, it is also desirable to be updated to key word file Operation.Specific renewal time performs according to preset time rule.Preset time rule can include fixed time, or When can not inquire result in step S103, it can also be after step S104.
Renewal process make it that each field corresponding with database of each field in key word file is consistent.
Optionally, in addition to:
The key word file is sent to user terminal so that the user terminal is protected to the key word file Deposit.
In the embodiment of the present application, also key word file can be sent to user terminal.
User terminal is preserved the key word file, when sending query statement, directly to the key word file Operated, without being communicated to application server.And inquiry mode of the prior art is, it is necessary to and system service Device, data server even data server also need to connect other child servers, and remain connection status, and the application is real The mode applied in example obviously substantially increases search efficiency, reduces the operating load of each server.
Another aspect of the present invention provides a kind of data query arrangement.
Referring to Fig. 3, Fig. 3 is a kind of structural representation of data query arrangement in the embodiment of the present application.
The invention provides a kind of data query arrangement, applied to system server, the system server takes with data Business device is connected, it is characterised in that is stored with and is generated according to the data place of the data server in the system server Key word file, the key word file includes simplifying the tables of data in database the tables of data of data structure, described Device includes:
Reception device 301, the query statement for receiving user terminal transmission, it is crucial that the query statement includes inquiry Word;
Resolver 302, for parsing the query statement, obtains the key word of the inquiry;
Inquiry unit 303, for being inquired about according to the key word of the inquiry in the key word file, is obtained and institute State the corresponding keyword search results of key word of the inquiry;
Return mechanism 304, is shown for the keyword search results to be returned into the user terminal.
Optionally, referring to Fig. 4, Fig. 4 is that a kind of another structure for data query arrangement that the embodiment of the present application is provided is shown It is intended to.
On the basis of above-described embodiment, in addition to key word file generating means 400, the key word file generation dress The key word file for being generated according to the data place of the data server is put, is specifically included:
Acquiring unit 401, at least includes key for obtaining in default file generated rule, the file generated rule Word field and keyword message field;
First generation unit 402, the tables of data generation for inquiring about the database according to the key field includes The keyword cache file of key data table;
Second generation unit 403, the tables of data generation for the database according to the keyword message Field Inquiry Keyword message cache file including keyword message tables of data;
Key word file generation unit 404, for the keyword cache file and the keyword message to be cached into text Part is used as the key word file.
Optionally, the inquiry unit includes:
First query unit, for searching the number of keyword in the keyword cache file according to the key word of the inquiry According to table, obtain and the key word of the inquiry matches matches keyword;
Second query unit, for according to the matching keyword, searching the pass in the keyword message cache file Key word information data table, obtains the keyword message corresponding with the matching keyword;
As a result generation unit, for the keyword and the keyword message to be combined, obtains keyword query knot Really.
Optionally, in addition to:
Updating device, for according to preset time rule, being updated to the key word file.
Optionally, in addition to:
Sending module, for sending the key word file to user terminal so that the user terminal is to the key Word file is preserved.
It should be noted that a kind of data query arrangement of the present embodiment can use one kind in above method embodiment Data query method, for realizing whole technical schemes in above method embodiment, the function of its modules can basis Method in above method embodiment is implemented, and it implements process and can refer to associated description in above-described embodiment, this Place is repeated no more.
The invention discloses a kind of data query arrangement, applied to system server, the system server takes with data Business device is connected, and be stored with the keyword text generated according to the data place of the data server in the system server Part, methods described receives the query statement that user terminal is sent, and the query statement includes key word of the inquiry;Looked into described in parsing Instruction is ask, the key word of the inquiry is obtained;The key word file is searched for according to the key word of the inquiry, obtained and the inquiry The corresponding keyword search results of keyword;The keyword search results are returned into the user terminal to be shown.Due to It is the inquiry carried out to the key word file in system server according to the query statement of user terminal, data is not carried out direct Operation, the performance of database is not interfered with even if when inquiring about more yet, it is to avoid database server is paralysed.
The embodiment of each in this specification is described by the way of progressive, and what each embodiment was stressed is and other Between the difference of embodiment, each embodiment identical similar portion mutually referring to.
, can be with several embodiments provided herein, it should be understood that disclosed method, device and equipment Realize by another way.For example, device embodiment described above is only schematical, for example, the unit Divide, only a kind of division of logic function there can be other dividing mode when actually realizing, such as multiple units or component Another system can be combined or be desirably integrated into, or some features can be ignored, or do not perform.It is another, it is shown or The coupling each other discussed or direct-coupling or communication connection can be by some communication interfaces, between device or unit Connect coupling or communicate to connect, can be electrical, machinery or other forms.
The unit illustrated as separating component can be or may not be it is physically separate, it is aobvious as unit The part shown can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs 's.In addition, each functional unit in each embodiment of the invention can be integrated in a processing unit or each Unit is individually physically present, can also two or more units it is integrated in a unit.
If the function is realized using in the form of SFU software functional unit and is used as independent production marketing or in use, can be with It is stored in a computer read/write memory medium.Understood based on such, technical scheme is substantially in other words The part contributed to prior art or the part of the technical scheme can be embodied in the form of software product, the meter Calculation machine software product is stored in a storage medium, including some instructions are to cause a computer equipment (can be individual People's computer, server, or network equipment etc.) perform all or part of step of each of the invention embodiment methods described. And foregoing storage medium includes:USB flash disk, mobile hard disk, read-only storage (ROM, Read-Only Memory), arbitrary access are deposited Reservoir (RAM, Random Access Memory), magnetic disc or CD etc. are various can be with the medium of store program codes.
The foregoing description of the disclosed embodiments, enables professional and technical personnel in the field to realize or using the present invention. A variety of modifications to these embodiments will be apparent for those skilled in the art, as defined herein General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, it is of the invention The embodiments shown herein is not intended to be limited to, and is to fit to and principles disclosed herein and features of novelty phase one The most wide scope caused.

Claims (10)

1. a kind of data query method, applied to system server, the system server is connected with data server, and it is special Levy and be, be stored with the key word file generated according to the data place of the data server, institute in the system server The tables of data that key word file includes simplifying the tables of data in database data structure is stated, methods described includes:
The query statement that user terminal is sent is received, the query statement includes key word of the inquiry;
The query statement is parsed, the key word of the inquiry is obtained;
Inquired about according to the key word of the inquiry in the key word file, obtain close corresponding with the key word of the inquiry Key word Query Result;
The keyword search results are returned into the user terminal to be shown.
2. according to the method described in claim 1, it is characterised in that described to be generated according to the data place of the data server The detailed process of key word file include:
Obtaining in default file generated rule, the file generated rule at least includes key field and keyword message word Section;
The tables of data generation for inquiring about the database according to the key field includes the keyword caching of key data table File;
The tables of data generation of database according to the keyword message Field Inquiry includes the pass of keyword message tables of data Key word information cache file;
It regard the keyword cache file and the keyword message cache file as the key word file.
3. method according to claim 2, it is characterised in that described that the keyword is searched for according to the key word of the inquiry File, obtaining keyword search results corresponding with the key word of the inquiry includes:
Key data table in the keyword cache file is searched according to the key word of the inquiry, obtains closing with the inquiry Keyword and matching keyword that key word matches;
According to the matching keyword, search the keyword message tables of data in the keyword message cache file, obtain with The corresponding keyword message of the matching keyword;
The keyword and the keyword message are combined, keyword search results are obtained.
4. according to the method in claim 2 or 3, it is characterised in that also include:
According to preset time rule, the key word file is updated.
5. the method according to Claims 1-4 any one, it is characterised in that also include:
The key word file is sent to user terminal so that the user terminal is preserved to the key word file.
6. a kind of data query arrangement, applied to system server, the system server is connected with data server, and it is special Levy and be, be stored with the key word file generated according to the data place of the data server, institute in the system server The tables of data that key word file includes simplifying the tables of data in database data structure is stated, described device includes:
Reception device, the query statement for receiving user terminal transmission, the query statement includes key word of the inquiry;
Resolver, for parsing the query statement, obtains the key word of the inquiry;
Inquiry unit, for being inquired about according to the key word of the inquiry in the key word file, is obtained and the inquiry The corresponding keyword search results of keyword;
Return mechanism, is shown for the keyword search results to be returned into the user terminal.
7. device according to claim 6, it is characterised in that also including key word file generating means, the keyword File creating apparatus is used for the key word file generated according to the data place of the data server, specifically includes:
Acquiring unit, at least includes key field for obtaining in default file generated rule, the file generated rule With keyword message field;
First generation unit, the tables of data generation for inquiring about the database according to the key field includes number of keyword According to the keyword cache file of table;
Second generation unit, includes key for the tables of data generation of database according to the keyword message Field Inquiry The keyword message cache file of word information data table;
Key word file generation unit, for regarding the keyword cache file and the keyword message cache file as institute State key word file.
8. device according to claim 7, it is characterised in that the inquiry unit includes:
First query unit, for searching the key data in the keyword cache file according to the key word of the inquiry Table, obtains the keyword that matches with the key word of the inquiry and matches keyword;
Second query unit, for according to the matching keyword, searching the keyword in the keyword message cache file Information data table, obtains the keyword message corresponding with the matching keyword;
As a result generation unit, for the keyword and the keyword message to be combined, obtains keyword search results.
9. the device according to claim 7 or 8, it is characterised in that also include:
Updating device, for according to preset time rule, being updated to the key word file.
10. the device according to claim 6 to 9 any one, it is characterised in that also include:
Sending module, for sending the key word file to user terminal so that the user terminal is to keyword text Part is preserved.
CN201710288467.4A 2017-04-27 2017-04-27 A kind of data query method and device Pending CN107133300A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710288467.4A CN107133300A (en) 2017-04-27 2017-04-27 A kind of data query method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710288467.4A CN107133300A (en) 2017-04-27 2017-04-27 A kind of data query method and device

Publications (1)

Publication Number Publication Date
CN107133300A true CN107133300A (en) 2017-09-05

Family

ID=59716539

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710288467.4A Pending CN107133300A (en) 2017-04-27 2017-04-27 A kind of data query method and device

Country Status (1)

Country Link
CN (1) CN107133300A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107590248A (en) * 2017-09-14 2018-01-16 广东欧珀移动通信有限公司 Searching method, device, terminal and computer-readable recording medium
CN109241143A (en) * 2018-09-13 2019-01-18 中国建设银行股份有限公司 A kind of data query method and system
CN110196862A (en) * 2018-02-27 2019-09-03 财付通支付科技有限公司 A kind of data scene building method, device, server and system
CN110309217A (en) * 2019-05-30 2019-10-08 平安科技(深圳)有限公司 Lead-in and lead-out method, device, terminal and the computer readable storage medium of data
CN111400301A (en) * 2019-01-03 2020-07-10 阿里巴巴集团控股有限公司 Data query method, device and equipment
CN111506628A (en) * 2020-04-22 2020-08-07 中国民航信息网络股份有限公司 Data processing method and device
CN112182404A (en) * 2020-10-23 2021-01-05 网易(杭州)网络有限公司 Question query method, device, equipment and storage medium
CN112887447A (en) * 2021-01-22 2021-06-01 北京金山云网络技术有限公司 Domain name query method and device and domain name server

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101963993A (en) * 2010-10-21 2011-02-02 江苏科技大学 Method for fast searching database sheet table record
CN102117309A (en) * 2010-01-06 2011-07-06 卓望数码技术(深圳)有限公司 Data caching system and data query method
CN102867056A (en) * 2012-09-18 2013-01-09 王楚云 Method and system for searching keyword
CN102930054A (en) * 2012-11-19 2013-02-13 北京奇虎科技有限公司 Data search method and data search system
US20130239053A1 (en) * 2012-03-08 2013-09-12 Kt Corporation Generating interactive menu for contents search based on user inputs
CN106156061A (en) * 2015-03-30 2016-11-23 北大方正集团有限公司 A kind of method and device improving efficiency data query

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102117309A (en) * 2010-01-06 2011-07-06 卓望数码技术(深圳)有限公司 Data caching system and data query method
CN101963993A (en) * 2010-10-21 2011-02-02 江苏科技大学 Method for fast searching database sheet table record
US20130239053A1 (en) * 2012-03-08 2013-09-12 Kt Corporation Generating interactive menu for contents search based on user inputs
CN102867056A (en) * 2012-09-18 2013-01-09 王楚云 Method and system for searching keyword
CN102930054A (en) * 2012-11-19 2013-02-13 北京奇虎科技有限公司 Data search method and data search system
CN106156061A (en) * 2015-03-30 2016-11-23 北大方正集团有限公司 A kind of method and device improving efficiency data query

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107590248A (en) * 2017-09-14 2018-01-16 广东欧珀移动通信有限公司 Searching method, device, terminal and computer-readable recording medium
CN107590248B (en) * 2017-09-14 2020-02-14 Oppo广东移动通信有限公司 Search method, search device, search terminal and computer-readable storage medium
CN110196862A (en) * 2018-02-27 2019-09-03 财付通支付科技有限公司 A kind of data scene building method, device, server and system
CN109241143A (en) * 2018-09-13 2019-01-18 中国建设银行股份有限公司 A kind of data query method and system
CN111400301A (en) * 2019-01-03 2020-07-10 阿里巴巴集团控股有限公司 Data query method, device and equipment
CN111400301B (en) * 2019-01-03 2023-06-27 阿里巴巴集团控股有限公司 Data query method, device and equipment
CN110309217A (en) * 2019-05-30 2019-10-08 平安科技(深圳)有限公司 Lead-in and lead-out method, device, terminal and the computer readable storage medium of data
CN110309217B (en) * 2019-05-30 2024-03-08 平安科技(深圳)有限公司 Data import and export method and device, terminal and computer readable storage medium
CN111506628A (en) * 2020-04-22 2020-08-07 中国民航信息网络股份有限公司 Data processing method and device
CN112182404A (en) * 2020-10-23 2021-01-05 网易(杭州)网络有限公司 Question query method, device, equipment and storage medium
CN112182404B (en) * 2020-10-23 2023-08-11 网易(杭州)网络有限公司 Question query method, device, equipment and storage medium
CN112887447A (en) * 2021-01-22 2021-06-01 北京金山云网络技术有限公司 Domain name query method and device and domain name server

Similar Documents

Publication Publication Date Title
CN107133300A (en) A kind of data query method and device
US9424351B2 (en) Hybrid-distribution model for search engine indexes
CA2610208C (en) Learning facts from semi-structured text
CN108090064A (en) A kind of data query method, apparatus, data storage server and system
CN110427368A (en) Data processing method, device, electronic equipment and storage medium
CN110119292A (en) System operational parameters querying method, matching process, device and node device
WO2016018201A1 (en) Searching relational and graph databases
US8156073B1 (en) Item attribute generation using query and item data
US10776352B2 (en) Generic query language for data stores
CN108762808A (en) The generation method and system of interface document
US20110276577A1 (en) System and method for modelling and profiling in multiple languages
CN104714974A (en) Method and device for parsing and reprocessing query statement
CN109284326A (en) A kind of data bank access method and device
CN107480268A (en) Data query method and device
CN109753504A (en) Data query method and device
US8037090B2 (en) Processing structured documents stored in a database
US20040049495A1 (en) System and method for automatically generating general queries
Bruelheide et al. Implementing the formal language of the vegetation classification expert systems (ESy) in the statistical computing environment R
CN115039090A (en) Data query method, device, server and storage medium
CN107105004A (en) Cross-platform service calling method and device
CN106506661A (en) Method, server and system for dynamically returning data
CN103020300B (en) Method and device for information retrieval
CN108595450A (en) One kind burying point data base construction method, bury point data base and buries a querying method
CN111831684B (en) Data query method, device and computer readable storage medium
CN108090185A (en) A kind of customer information duplicate checking method

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20170905

RJ01 Rejection of invention patent application after publication