CN106528590A - A query method and apparatus - Google Patents
A query method and apparatus Download PDFInfo
- Publication number
- CN106528590A CN106528590A CN201610829093.8A CN201610829093A CN106528590A CN 106528590 A CN106528590 A CN 106528590A CN 201610829093 A CN201610829093 A CN 201610829093A CN 106528590 A CN106528590 A CN 106528590A
- Authority
- CN
- China
- Prior art keywords
- search
- content
- pretreatment
- traffic
- search results
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a query method. Based on a preset search list and a preset task period, the method acquires search results corresponding to all currently searchable content of business tables from each business table and stores the search results in the search list corresponding to the searchable content; thus, when a query request of a user is received, a query result can be displayed to the user according to all table items corresponding to query content carried in query request in the search list. Therefore, a user does not need to switch pages in a query process, the retrieval time for query requests is reduced, query requests of users can be responded to quickly and the using experience of users is improved.
Description
Technical field
The present invention relates to database field, more particularly to a kind of pre- querying method.The present invention also relates to a kind of inquiry
Equipment.
Background technology
With E-Government, IT application in enterprises, the continuous development of social informatization, progress, the electronics text of magnanimity is generated
Part, document.For these e-files, the management of electronic document, the main task that enterprise realizes informatization strategy is increasingly becoming.
Enterprise management system (being subsequently referred to as management system) is to refer to embody the major part function of business administration (including decision-making, meter
Draw, tissue, leader, monitoring, analyze etc.), and real-time, related, accurate, complete data can be provided, so as to for manager
A kind of software of decision-making foundation is provided.
Data base is come the warehouse organized, store and manage data, with information technology and market according to data structure
Development, data management are no longer only stored and manage data, and are transformed into the mode of the various data managements required for user.
Data base has number of different types, and the form from the simplest various data that are stored with is to can carry out the large-scale of mass data storage
Database Systems are all widely used in all fields.
In informationized society, substantially effectively management and use various information resource, is to carry out scientific research and decision-making pipe
The precondition of reason.Therefore technical staff can be frequently necessary to for the number in management system during using management system
According to being inquired about.At present, the inquiry for management system generally requires the type that technical staff determines search content first, management
System could provide Search Results further according to the search content of technical staff's input, and in the process, the single of management system is looked into
Ask direction of the interface only for single fixation.
As shown in figure 1, the query interface for certain management system of the prior art shows schematic diagram, with the management system
As a example by TV software life cycle management system, generally search for mode of technical staff when using the management system is first
Input model information, after input finishes click search, the interface of Fig. 1 will provide the correlation of the version searched for by technical staff
Information, if technical staff is if desired searched in more detail, also needs by being input into branch information and clicking on search, now boundary
Face is as shown in Fig. 2 wherein contain branch's relevant information that technical staff wants.
Inventor has found that during the present invention is realized above prior art at least has following technical problem：
(1) management system backstage needs to arrange corresponding access entry for current each query type, while technology people
Member in the case of the corresponding query type of uncertain inquiry content needs to each access entry to go to retrieve corresponding data
Table, is that this technical staff will take for substantial amounts of retrieval, extract the time of result；
(2) backstage of management system needs the corresponding field of each tables of data is set up index respectively for the content of search
(such as type field, branch fields etc.), cause the query responding time of equipment long.
As can be seen here, how on the premise of retrieval/query responding time is reduced, the personnel that develop skill enter in data base
The convenience of row inquiry, becomes those skilled in the art's technical problem urgently to be resolved hurrily.
The content of the invention
The present invention provides a kind of querying method and equipment, so as on the premise of retrieval/query time is reduced, develop skill
The convenience that personnel are inquired about in data base.
In order to achieve the above object, the present invention proposes a kind of querying method, is applied to the data base set comprising traffic table
System, pre-sets search table, and the method also includes：
Obtained in each traffic table according to default duty cycle and current with the traffic table all can search for content
Corresponding Search Results, it is described to can search for the interior of all search-types that the search box that content is the Database Systems be input into
Hold；
Store can search for content described in Search Results correspondence into the search table；
When the inquiry request of user is received, according in the search table it is all with the inquiry request in carry look into
Ask the corresponding list item of content and show Query Result to the user.
Preferably, the search table includes master meter and standby table, according to default duty cycle in each traffic table
Obtain it is current with the traffic table it is all can search for the corresponding Search Results of content, specially：
When the duty cycle is reached, the standby table is emptied, and content is can search for described in obtaining from the traffic table；
The content that can search for is write into the standby table one by one, and can search for curriculum offering pretreatment mark described in each,
The original state of the pretreatment mark is untreated；
According to the pretreatment mark obtain in each traffic table with it is each it is described can search for content it is corresponding search knot
Really.
Preferably, obtained in each traffic table with each described to can search for content corresponding according to pretreatment mark
Search Results, specially：
It is that the corresponding content that can search for of untreated pretreatment mark deposits clear to internal memory search by state in the standby table
Dan Zhong；
To get from the traffic table and all can search for that content is corresponding searches with the internal memory is searched in inventory
Hitch fruit is stored into the standby table, and the Search Results for the getting corresponding pretreatment mark that can search for content is set to
It is processed, until each in internal memory search inventory can search for content and travel through.
Preferably, content will be can search for described in Search Results correspondence to store into the search table, specially：
Judge to be designated with the presence or absence of pretreatment in the standby table and untreated can search for content；
If exist in the standby table pretreatment be designated it is untreated can search for content, and existed according to pretreatment mark
Obtain in each traffic table and be not more than default pre- place with each execution number of times that can search for the corresponding Search Results of content
Reason cycle-index, is obtained with each described to can search for content corresponding in each traffic table according to pretreatment mark again
Search Results；
If do not exist in the standby table pretreatment be designated it is untreated can search for content, or identified according to the pretreatment
Obtain in each traffic table and be more than default pre- place with each execution number of times that can search for the corresponding Search Results of content
Pretreatment in the standby table is designated the processed corresponding list item of content that can search for and is copied to the master meter by reason cycle-index
In.
Preferably, the list item includes searching for content, search-type and Search Results, according to all in the search table
List item corresponding with the inquiry content carried in the inquiry request shows Query Result to the user, specially：
Inquire about in the master meter it is all can search for contents with the inquiry content matching, and obtain with the inquiry
Hold the list item that can search for content of matching；
The list item is grouped according to search-type, and is shown the Search Results after packet to the user.
Accordingly, the invention allows for a kind of query facility, is applied to the Database Systems comprising traffic table, the equipment
In pre-set search table, the equipment also includes：
Acquisition module, according to default duty cycle obtain in each traffic table it is current with the traffic table it is all can
The corresponding Search Results of search content, it is described to can search for all search that the search box that content is the Database Systems be input into
The content of type；
Memory module, stores can search for content described in Search Results correspondence into the search table；
Display module, when the inquiry request of user is received, according to all with the inquiry request in the search table
The corresponding list item of inquiry content of middle carrying shows Query Result to the user.
Preferably, the search table includes master meter and standby table, and the acquisition module is specifically included：
First acquisition module, when the duty cycle is reached, empties the standby table, and obtains institute from the traffic table
State and can search for content；
The content that can search for is write the standby table, and it is pre- described in each to can search for curriculum offering by processing module one by one
Mark is processed, the original state of the pretreatment mark is untreated；
Second acquisition module, obtains in each traffic table according to pretreatment mark and described can search for content with each
Corresponding Search Results.
Preferably, second acquisition module specifically for：
It is that the corresponding content that can search for of untreated pretreatment mark deposits clear to internal memory search by state in the standby table
Dan Zhong；
To get from the traffic table and all can search for that content is corresponding searches with the internal memory is searched in inventory
Hitch fruit is stored into the standby table, and the Search Results for the getting corresponding pretreatment mark that can search for content is set to
It is processed, until each in internal memory search inventory can search for content and travel through.
Preferably, the memory module specifically for：
Judge to be designated with the presence or absence of pretreatment in the standby table and untreated can search for content；
If exist in the standby table pretreatment be designated it is untreated can search for content, and existed according to pretreatment mark
Obtain in each traffic table and be not more than default pre- place with each execution number of times that can search for the corresponding Search Results of content
Reason cycle-index, is obtained with each described to can search for content corresponding in each traffic table according to pretreatment mark again
Search Results；
If do not exist in the standby table pretreatment be designated it is untreated can search for content, or identified according to the pretreatment
Obtain in each traffic table and be more than default pre- place with each execution number of times that can search for the corresponding Search Results of content
Pretreatment in the standby table is designated the processed corresponding list item of content that can search for and is copied to the master meter by reason cycle-index
In.
Preferably, the list item includes searching for content, search-type and Search Results, and the display module is specifically used
In：
Inquire about in the master meter it is all can search for contents with the inquiry content matching, and obtain with the inquiry
Hold the list item that can search for content of matching；
The list item is grouped according to search-type, and is shown the Search Results after packet to the user.
By using the technical scheme proposed in embodiments of the invention, based on the search table for pre-setting, according to default
Duty cycle obtain in each traffic table it is current with traffic table it is all can search for the corresponding Search Results of content, and will search knot
Fruit correspondence can search for content and store into search table, so when the inquiry request of user is received, according to institute in search table
There is list item corresponding with the inquiry content carried in inquiry request to show Query Result to user.User is made not only in query script
In need not be redirected between the different pages, and reduce the retrieval time of inquiry request such that it is able to which quick response is used
The inquiry request at family, improves the experience of user.
Description of the drawings
Fig. 1 is that the query interface of certain management system of the prior art shows schematic diagram；
Fig. 2 is another displaying schematic diagram of query interface of certain management system of the prior art；
Fig. 3 is a kind of schematic flow sheet of querying method that the application is proposed；
Fig. 3 a be the embodiment of the present application in propose it is a kind of to user show Search Results schematic diagram；
Fig. 4 is the schematic flow sheet that a kind of search table that the application specific embodiment is proposed is obtained；
Fig. 5 is that a kind of search for proposing is illustrated for the acquisition methods flow process of Search Results in table in the application specific embodiment
Figure；
A kind of structural representation of query facilities of the Fig. 6 for proposing in the embodiment of the present application.
Specific embodiment
As described in the background art, one side management system backstage needs to arrange corresponding for current each query type
Access entry, while technical staff is in the case of the corresponding query type of uncertain inquiry content, need to each retrieve into
Mouth goes to retrieve corresponding tables of data, and the backstage of another aspect management system is needed for searching plain content by the right of each tables of data
Answer field to set up index respectively, cause the query responding time of equipment long, take the plenty of time of retrieval personnel.
Therefore, present applicant proposes a kind of querying method, so as on the premise of retrieval/query time is reduced, improve skill
The convenience that art personnel are inquired about in data base.
In the embodiment of the present application, in order to be directed to the corresponding different access entries of multiple tables of data stored in data base, adopt
All search for out with the corresponding Search Results of content that may search for all tables of data, Search Results correspondence can be searched
Rope content is stored into search table, so when the inquiry request of user is received, is asked with inquiry according to all in search table
The corresponding list item of inquiry content of middle carrying is asked to show Query Result to user.
Based on above-mentioned technological thought, a kind of querying method proposed in the embodiment of the present application, as shown in figure 3, being the application
A kind of schematic flow sheet of querying method that embodiment is proposed, the method are applied in the Database Systems comprising traffic table, should
Method is concretely comprised the following steps：
Step 301, obtains in each traffic table according to default duty cycle and current with traffic table all can search for content
Corresponding Search Results.
Can search for the content of all search-types that the search box that content is Database Systems can be input into.
Obtain in each traffic table it is current with traffic table it is all can search for the corresponding Search Results of content, and in the number of reality
According to library storage system, there are multiple different traffic tables, be generally all come to sea according to different classifications, project and index
Amount data carry out classifying and are stored in different traffic tables, in the scheme of the application, are storing the data base of mass data
In, the change such as data all can be stored, deleted and be updated at any time, so the search knot in needing the data to real-time change
Fruit is also carried out updating, therefore in the technical scheme of the application, owns in default duty cycle is to all traffic tables
The search of content is can search for, is obtained and all be can search for the corresponding Search Results of content.
In specific application scenarios, in the data base for storing mass data, can all carry out at any time data renewal,
The operation such as storage and deletion, can arrange the duration of duty cycle according to actual situation, carry out logarithm every duty cycle
The corresponding Search Results of content that can search for according in are obtained, but are not very frequently data for another kind of data update
In storehouse, avoid the need for frequently to obtaining to Search Results, could be arranged to the quantity of data variation or number in data base
In the case of certain predetermined threshold value being reached according to the duration for changing, carry out Search Results in the data base of trigger condition formula and obtain,
In specific application scenarios, the condition of result acquisition and the setting of duty cycle is scanned for, will not be to the guarantor of the application
Shield scope produces impact.
In the preferred embodiment of the application, the acquisition of the Search Results for carrying out can search for content in search table, when every
During secondary beginning search mission, search table is emptied, what is can be input in extracting search box from traffic table is all types of
Content, is put into the search content field of search table, and for can search for curriculum offering pretreatment mark, now, the search content
The state of pretreatment mark is untreated.Pretreatment in search table is designated and untreated can search for content and deposit to internal memory searching
In Suo Qingdan, for can search for content per bar, according to index and the result of needs search of his correlation, in different business table
In the middle Search Results for obtaining Search Results and storing search table, will get from traffic table and search in inventory with internal memory
All corresponding Search Results of content that can search for store into standby table, now, the search content of Search Results will be got
Pretreatment mark be set to it is processed, do not got Search Results search content pretreatment identify be set to not locate
Reason.
After all corresponding Search Results acquisition being carried out to whole search contents, judge search in table whether also there is pre- place
Reason be designated it is untreated can search for content, if having in search table that pretreatment is designated untreated state can search for content,
Traversal search is all carried out to searching for the pretreatment identification-state in inventory per data for untreated, repeated in the search inventory
Traversal search until pretreatment identification-state can search for content for sky for untreated in the search inventory, in actual application
In scene, can there is the search content that cannot get Search Results, the pretreatment cycle-index of traversal search can be set, should
Pretreatment cycle-index can carry out value according to practical situation.
When the content that can search for that there is no pretreatment in search table and be designated untreated state, or pretreatment is identified in individual industry
Obtain in business table with the individual execution number of times that can search for the corresponding Search Results of content more than default pretreatment cycle-index, will search
In rope table, pretreatment is designated the processed corresponding list item of content that can search for and preserves into search table.
Search Results correspondence can search for content and store into search table by step 302.
The acquisition and storage that can search for the Search Results of content is all carried out in search table, in actual applied field
Jing Zhong, some contingencies or system mistake etc. can cause search procedure time-consuming relatively long, if now user scans for will be unable to
The accurate acquisition of result is scanned for, the experience of user can be affected, therefore in the preferred embodiment of the application, employed and will search for
Table is divided into search master meter and the standby table of search.
Specifically, the obtaining step of the Search Results that can search for content in above-mentioned steps mainly enters in the standby table of search
OK, after the Search Results that can search for content in data base are obtained to be finished simultaneously, the pretreatment in search standby table is designated and is located
All copy storage, in the standby table of search, covers original search knot in search master meter to the corresponding Search Results of search content of reason
Fruit data.
For from functional structure, for carrying out all can search for inside storage system, content is corresponding to search the standby table of search
The acquisition of hitch fruit, and search for master meter carries out the inquiry and acquisition of data for external user, so making a distinction can be effective
Improve the safety in Search Results acquisition process in ground.
Step 303, when the inquiry request of user is received, according in search table it is all with inquiry request in carry look into
Ask the corresponding list item of content and show Query Result to user.
The Search Results stored in search table have multiple list items, respectively including search content, search-type and search
As a result etc., according to the inquiry content in the inquiry request of user input, all and inquiry content is inquired about in search master meter
That what is matched somebody with somebody can search for content, and obtain the list item that can search for content with inquiry content matching, by different list item Reference Number searching class
Type is grouped, and shows the Search Results after packet to user.
In specific application scenarios, different list items can be set to different labels to scan for the exhibition of result
Show, divided with label, user selects different labels to carry out the displaying of different list items, by taking Fig. 3 a as an example, is to user
The Search Results schematic diagram of displaying, the list item of Search Results are respectively type, tag, branch, choose type for user in Fig. 3 a
During label, the displaying carried out by user.
Or, all list items all being shown, but the mark of list item can be added in Search Results, user can be according to this
The differentiation to carry out list item is identified, by taking table 1 as an example, is the Search Results shown to user, wherein SearchKey is in search
Hold, SearchType is the type of search, and SearchValue is the result of search.
Table 1
| SearchKey | SearchType | SearchValue |
| M5507 | model | ***** |
| B5507 | branch | *** |
| T5508 | tag | ********** |
| M5508 | model | ***** |
| B5508 | branch | *** |
By using a kind of querying method proposed in embodiments of the invention, based on the search table for pre-setting, according to
Default duty cycle obtain in each traffic table it is current with traffic table it is all can search for the corresponding Search Results of content, and will search
Hitch fruit correspondence can search for content and store into search table, so when the inquiry request of user is received, according to search table
In all list items corresponding with inquiry content that is carrying in inquiry request to user show Query Result.User is made not only in inquiry
During need not be redirected between the different pages, and reduce the retrieval time of inquiry request such that it is able to quick to ring
Using the inquiry request at family, the experience of user is improve.
In order to the technological thought of the present invention is expanded on further, in conjunction with specific application scenarios, the technical side to the present invention
Case is illustrated.
In a kind of querying method that the specific embodiment of the application is proposed, two steps are mainly included：
Step A, searches for the acquisition of table Search Results；
Step B, the displaying of Search Results.
For above-mentioned steps A, the acquisition of table Search Results wherein, is searched for, entered mainly by the timed task of setting
Row can search for the Search Results of content and obtain, and completes the acquisition of Search Results, then Search Results are copied in the standby table of search
In search master meter, as shown in figure 4, the schematic flow sheet that a kind of search table proposed for the application specific embodiment is obtained, the party
Method pre-sets the search master meter SearchTable and standby table SearchTabBK of search, is applied to contain different business table
Database Systems in, in the application specific embodiment, the traffic table be respectively branch (branch), type (model),
Tri- kinds of traffic tables of tag, in the implementation process of the method, need to perform the timing times that the corresponding Search Results of search content are obtained
Business, the timed task are concretely comprised the following steps：
Step 401, all the elements emptied in the standby table of search；
Specifically, after timed task starts, all data in SearchTabBK tables are deleted.
Step 402, can search field copy content in the standby table of search；
Specifically, in the different business table from data system, what is can be input in extracting search box is all types of
Content, is put into the SearchKey search contents of SearchTabBK.
Step 403, by the result storage of search in the standby table of search；
All contents that may search for are scanned for, the Search Results for searching are stored in the standby table of search
In SearchValue, the gap wherein according to traffic table is identified with SearchType.
Step 404, deletes the content in master meter；
Specifically, the upper search result table SearchValue preserved in master meter SearchTable is carried out deleting clear
It is empty.
Step 405, the Search Results of the storage in search standby table are copied in search master meter；
SearchValue in search standby table is copied in search master meter, wherein, the SearchValue has correspondence
Search key SearchKey and with search-type SearcType.
In the concrete application scene of the application, obtained by using above-mentioned timed task, carrying out regularly Search Results
Take, the Search Results for getting are stored entirely in the standby table of search, then by the content update in search standby table to search master meter
In, this completes the task that timing updates Search Results.
In order to above-mentioned timed task further instruction, below to searching for the search mission in standby table in timed task
Step 403 is illustrated, as shown in figure 5, the acquisition methods stream for searching for Search Results in standby table in the application specific embodiment
Journey schematic diagram, specially：
Whether S501, judge the traversal search number of times for performing more than preset loop number of times；
Specifically, when traversal search number of times is less than preset loop number of times, execution step S502, if traversal search number of times
It is equal to or is more than preset loop number of times, then execution step S508.
S502, the content that can search for that pretreatment is designated flag=false is stored in search inventory Searchlist.
S503, can search in judging search inventory Searchlist whether content is empty；
Specifically, if can search for content in search inventory Searchlist is not sky, execution step 504, if search inventory
Can search for content in Searchlist is sky, then execution step S508.
S504, traversal search search for every data of inventory Searchlist；
S505, obtains Search Results corresponding with search content from traffic table, and Search Results storage is arrived
In SearchVlue.
The pretreatment for getting the search content of Search Results is identified flag and is changed to true by S506；
S507, judges whether just to complete search inventory Searchlist to search for；
Specifically, complete if having searched for, execution step S501, if not completing, execution step S504.
Step S508, Search Results are copied in SearchTab from the standby table SearchTabBK of search.
By the acquisition methods using the Search Results proposed in above-mentioned the application specific embodiment, it is ensured that in step
The acquisition of the Search Results in A is complete, by searching for the differentiation of active and standby table, it is ensured that the safety of data.
And above-mentioned steps B are directed to, in actual application scenarios, various Search Results methods of exhibiting are had, with Fig. 3 a
As a example by, it is the Search Results schematic diagram shown to user, list item respectively type, tag, the branch of Search Results in Fig. 3 a are
When user chooses the label of type, the displaying carried out by user.
, by taking table 2 as an example, when user's search content is " 5507 " and " 5508 ", it is the Search Results shown to user, its
Middle SearchKey is search content, and SearchType is the type of search, and SearchValue is the result of search.
Table 2
| SearchKey | SearchType | SearchValue |
| M5507 | model | ***** |
| B5507 | branch | *** |
| T5508 | tag | ********** |
| M5508 | model | ***** |
| B5508 | branch | *** |
It follows that according to the comprehensive and multiformity of the Search Results for getting, showing for the Search Results of user
Have multiple combination, it is possible to use family with it is directly perceived, easily scanning for the acquisition of result.
By applying a kind of querying method proposed in specific embodiment of the invention, based on the search table for pre-setting,
According to default duty cycle obtain in each traffic table it is current with traffic table it is all can search for the corresponding Search Results of content, and
Search Results correspondence can search for content and store into search table, so when the inquiry request of user is received, according to searching
In rope table, all list items corresponding with inquiry content that is carrying in inquiry request show Query Result to user.User is not only made to exist
Need not be redirected between the different pages in query script, and be reduced the retrieval time of inquiry request such that it is able to be fast
The inquiry request of speed response user, improves the experience of user.
Based on technological thought same as described above, the application also proposed a kind of query facility, as shown in fig. 6, being this Shen
A kind of structural representation of the query facility that please be proposed in embodiment, the equipment application in the Database Systems comprising traffic table,
Search table is pre-set in the equipment, and the equipment also includes：
Acquisition module 61, is obtained in each traffic table according to default duty cycle and is currently owned with the traffic table
Can search for the corresponding Search Results of content, it is described can search for that the search box that content is the Database Systems can be input into all search
The content of rope type；
Memory module 62, stores can search for content described in Search Results correspondence into the search table；
Display module 63, when the inquiry request of user is received, is asked with the inquiry according to all in the search table
The corresponding list item of inquiry content of middle carrying is asked to show Query Result to the user.
In specific application scenarios, the search table includes master meter and standby table, and the acquisition module 61 is specifically included
Following submodule：
First acquisition module, when the duty cycle is reached, empties the standby table, and obtains institute from the traffic table
State and can search for content；
The content that can search for is write the standby table, and it is pre- described in each to can search for curriculum offering by processing module one by one
Mark is processed, the original state of the pretreatment mark is untreated；
Second acquisition module, obtains in each traffic table according to pretreatment mark and described can search for content with each
Corresponding Search Results.
In specific application scenarios, second acquisition module specifically for：
It is that the corresponding content that can search for of untreated pretreatment mark deposits clear to internal memory search by state in the standby table
Dan Zhong；
To get from the traffic table and all can search for that content is corresponding searches with the internal memory is searched in inventory
Hitch fruit is stored into the standby table, and the Search Results for the getting corresponding pretreatment mark that can search for content is set to
It is processed, until each in internal memory search inventory can search for content and travel through.
In specific application scenarios, the memory module 62 specifically for：
Judge to be designated with the presence or absence of pretreatment in the standby table and untreated can search for content；
If exist in the standby table pretreatment be designated it is untreated can search for content, and existed according to pretreatment mark
Obtain in each traffic table and be not more than default pre- place with each execution number of times that can search for the corresponding Search Results of content
Reason cycle-index, is obtained with each described to can search for content corresponding in each traffic table according to pretreatment mark again
Search Results；
If do not exist in the standby table pretreatment be designated it is untreated can search for content, or identified according to the pretreatment
Obtain in each traffic table and be more than default pre- place with each execution number of times that can search for the corresponding Search Results of content
Pretreatment in the standby table is designated the processed corresponding list item of content that can search for and is copied to the master meter by reason cycle-index
In.
In specific application scenarios, the list item includes searching for content, search-type and Search Results, the displaying
Module 63 specifically for：
Inquire about in the master meter it is all can search for contents with the inquiry content matching, and obtain with the inquiry
Hold the list item that can search for content of matching；
The list item is grouped according to search-type, and is shown the Search Results after packet to the user.
By using technical scheme proposed by the present invention, based on the search table for pre-setting, according to default duty cycle
Obtain in each traffic table it is current with traffic table it is all can search for the corresponding Search Results of content, and Search Results can correspondingly be searched
Rope content is stored into search table, so when the inquiry request of user is received, is asked with inquiry according to all in search table
The corresponding list item of inquiry content of middle carrying is asked to show Query Result to user.Not only make the user need not be not in query script
Redirected between the page, and reduced the retrieval time of inquiry request such that it is able to which the inquiry of quick response user please
Ask, improve the experience of user.
Through the above description of the embodiments, those skilled in the art can be understood that the present invention can be led to
Cross hardware realization, it is also possible to by software plus necessary general hardware platform mode realizing.Based on such understanding, this
Bright technical scheme can be embodied in the form of software product, and the software product can be stored in non-volatile memories
Medium (can be CD-ROM, USB flash disk, portable hard drive etc.) in, use so that a computer equipment (can be including some instructions
Personal computer, server, or network equipment etc.) perform method described in each implement scene of the invention.
It will be appreciated by those skilled in the art that accompanying drawing is a schematic diagram for being preferable to carry out scene, module in accompanying drawing or
Flow process is not necessarily implemented necessary to the present invention.
It will be appreciated by those skilled in the art that module in device in implement scene can according to implement scene describe into
Row is distributed in the device of implement scene, it is also possible to carry out one or more dresses that respective change is disposed other than this implement scene
In putting.The module of above-mentioned implement scene can merge into a module, it is also possible to be further split into multiple submodule.
The invention described above sequence number is for illustration only, does not represent the quality of implement scene.
Disclosed above is only that the several of the present invention are embodied as scene, but, the present invention is not limited to this, Ren Heben
What the technical staff in field can think change should all fall into protection scope of the present invention.
Claims (10)
1. a kind of querying method, is applied to the Database Systems comprising traffic table, it is characterised in that pre-set search table, should
Method also includes：
Obtain according to default duty cycle that current with the traffic table all to can search for content corresponding in each traffic table
Search Results, the content that can search for all search-types that the search box that content is the Database Systems can be input into；
Store can search for content described in Search Results correspondence into the search table；
When the inquiry request of user is received, according in the search table it is all with the inquiry request in the inquiry that carries
Hold corresponding list item and show Query Result to the user.
2. the method for claim 1, it is characterised in that the search table includes master meter and standby table, according to default
Duty cycle obtain in each traffic table it is current with the traffic table it is all can search for the corresponding Search Results of content, specifically
For：
When the duty cycle is reached, the standby table is emptied, and content is can search for described in obtaining from the traffic table；
The content that can search for is write into the standby table one by one, and can search for curriculum offering pretreatment mark described in each, it is described
The original state of pretreatment mark is untreated；
Obtained in each traffic table according to pretreatment mark described the corresponding Search Results of content are can search for each.
3. method as claimed in claim 2, it is characterised in that identified according to the pretreatment and obtained in each traffic table
With it is each it is described can search for the corresponding Search Results of content, specially：
It is that the corresponding content that can search for of untreated pretreatment mark is deposited into internal memory search inventory by state in the standby table；
To get from the traffic table all the corresponding search knot of content is can search for the internal memory is searched in inventory
Fruit is stored into the standby table, and the Search Results for the getting corresponding pretreatment mark that can search for content is set to locate
Reason, until each in internal memory search inventory can search for content and travel through.
4. method as claimed in claim 3, it is characterised in that will can search for described in the Search Results correspondence content store to
In the search table, specially：
Judge to be designated with the presence or absence of pretreatment in the standby table and untreated can search for content；
If exist in the standby table pretreatment be designated it is untreated can search for content, and identified in each institute according to the pretreatment
Obtain in stating traffic table and be not more than default pretreatment with each execution number of times that can search for the corresponding Search Results of content and follow
Ring number of times, obtains in each traffic table according to pretreatment mark again and described can search for the corresponding search of content with each
As a result；
If do not exist in the standby table pretreatment be designated it is untreated can search for content, or identified each according to the pretreatment
Obtain in the traffic table and follow more than default pretreatment with each execution number of times that can search for the corresponding Search Results of content
Pretreatment in the standby table is designated the processed corresponding list item of content that can search for and is copied in the master meter by ring number of times.
5. method as claimed in claim 4, it is characterised in that the list item includes searching for content, search-type and search
As a result, according to all list items corresponding with inquiry content that is carrying in the inquiry request in the search table to user's exhibition
Show Query Result, specially：
All contents that can search for the inquiry content matching are inquired about in the master meter, and are obtained and the inquiry content
That what is matched somebody with somebody can search for the list item of content；
The list item is grouped according to search-type, and is shown the Search Results after packet to the user.
6. a kind of query facility, is applied to the Database Systems comprising traffic table, it is characterised in that pre-sets in the equipment and searches
Rope table, the equipment also include：
Acquisition module, obtains can search for currently all with the traffic table in each traffic table according to default duty cycle
The corresponding Search Results of content, it is described to can search for all search-types that the search box that content is the Database Systems be input into
Content；
Memory module, stores can search for content described in Search Results correspondence into the search table；
Display module, when the inquiry request of user is received, according in the search table it is all with the inquiry request in take
The corresponding list item of inquiry content of band shows Query Result to the user.
7. equipment as claimed in claim 6, it is characterised in that the search table includes master meter and standby table, the acquisition mould
The submodule that block includes is：
First acquisition module, when the duty cycle is reached, empties the standby table, and can described in obtaining from the traffic table
Search content；
The content that can search for is write the standby table, and can search for curriculum offering pretreatment described in each by processing module one by one
Mark, the original state of the pretreatment mark is untreated；
Second acquisition module, obtains with each described to can search for content corresponding in each traffic table according to pretreatment mark
Search Results.
8. equipment as claimed in claim 7, it is characterised in that second acquisition module specifically for：
It is that the corresponding content that can search for of untreated pretreatment mark is deposited into internal memory search inventory by state in the standby table；
To get from the traffic table all the corresponding search knot of content is can search for the internal memory is searched in inventory
Fruit is stored into the standby table, and the Search Results for the getting corresponding pretreatment mark that can search for content is set to locate
Reason, until each in internal memory search inventory can search for content and travel through.
9. equipment as claimed in claim 8, it is characterised in that the memory module specifically for：
Judge to be designated with the presence or absence of pretreatment in the standby table and untreated can search for content；
If exist in the standby table pretreatment be designated it is untreated can search for content, and identified in each institute according to the pretreatment
Obtain in stating traffic table and be not more than default pretreatment with each execution number of times that can search for the corresponding Search Results of content and follow
Ring number of times, obtains in each traffic table according to pretreatment mark again and described can search for the corresponding search of content with each
As a result；
If do not exist in the standby table pretreatment be designated it is untreated can search for content, or identified each according to the pretreatment
Obtain in the traffic table and follow more than default pretreatment with each execution number of times that can search for the corresponding Search Results of content
Pretreatment in the standby table is designated the processed corresponding list item of content that can search for and is copied in the master meter by ring number of times.
10. equipment as claimed in claim 9, it is characterised in that the list item includes searching for content, search-type and search
As a result, the display module specifically for：
All contents that can search for the inquiry content matching are inquired about in the master meter, and are obtained and the inquiry content
That what is matched somebody with somebody can search for the list item of content；
The list item is grouped according to search-type, and is shown the Search Results after packet to the user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610829093.8A CN106528590B (en) | 2016-09-18 | 2016-09-18 | Query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610829093.8A CN106528590B (en) | 2016-09-18 | 2016-09-18 | Query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106528590A true CN106528590A (en) | 2017-03-22 |
| CN106528590B CN106528590B (en) | 2023-04-07 |
Family
ID=58343822
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610829093.8A Active CN106528590B (en) | 2016-09-18 | 2016-09-18 | Query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106528590B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108039958A (en) * | 2017-11-17 | 2018-05-15 | 深圳前海微众银行股份有限公司 | Data error detection method, apparatus and computer-readable recording medium |
| CN108734537A (en) * | 2017-04-24 | 2018-11-02 | 北京京东尚科信息技术有限公司 | The method and apparatus for counting violation order |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004246405A (en) * | 2003-02-10 | 2004-09-02 | Kyodo Printing Co Ltd | Apparatus and method for preparing data base inquiry statement, and program for same |
| CN104361038A (en) * | 2008-03-13 | 2015-02-18 | 商业合伙人有限公司 | Improved search engine |
-
2016
- 2016-09-18 CN CN201610829093.8A patent/CN106528590B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004246405A (en) * | 2003-02-10 | 2004-09-02 | Kyodo Printing Co Ltd | Apparatus and method for preparing data base inquiry statement, and program for same |
| CN104361038A (en) * | 2008-03-13 | 2015-02-18 | 商业合伙人有限公司 | Improved search engine |
Non-Patent Citations (1)
| Title |
|---|
| 郑冬冬等: "Deep Web爬虫爬行策略研究", 《计算机工程与设计》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108734537A (en) * | 2017-04-24 | 2018-11-02 | 北京京东尚科信息技术有限公司 | The method and apparatus for counting violation order |
| CN108734537B (en) * | 2017-04-24 | 2021-04-30 | 北京京东尚科信息技术有限公司 | Method and device for counting violation orders |
| CN108039958A (en) * | 2017-11-17 | 2018-05-15 | 深圳前海微众银行股份有限公司 | Data error detection method, apparatus and computer-readable recording medium |
| CN108039958B (en) * | 2017-11-17 | 2021-02-19 | 深圳前海微众银行股份有限公司 | Data error checking method and device and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106528590B (en) | 2023-04-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10606887B2 (en) | Providing relevant video scenes in response to a video search query | |
| US6915297B2 (en) | Automatic knowledge management system | |
| CN102483745B (en) | Co-selected image classification | |
| US8370358B2 (en) | Tagging content with metadata pre-filtered by context | |
| US20160034471A1 (en) | Entity detection and extraction for entity cards | |
| CN105095320B (en) | The mark of document based on relationship stack combinations, association, the system searched for and showed | |
| US20110307482A1 (en) | Search result driven query intent identification | |
| CN107085583B (en) | Electronic document management method and device based on content | |
| CN100416556C (en) | Information storage and research | |
| CN107015987A (en) | A kind of method and apparatus for updating and searching for database | |
| CN103026334A (en) | Data classification | |
| CN111191111A (en) | Content recommendation method, device and storage medium | |
| CN112116331A (en) | Talent recommendation method and device | |
| JP2006268744A (en) | Document management system | |
| CN113297457A (en) | High-precision intelligent information resource pushing system and pushing method | |
| US20230409551A1 (en) | Scalable Fine Grained Access Control Within A Search Engine | |
| CN103914486B (en) | Document search and display system | |
| CN113191896A (en) | Recommendation method and device for bidding information and computer equipment | |
| US9552415B2 (en) | Category classification processing device and method | |
| CN106528590A (en) | A query method and apparatus | |
| Schulz et al. | On the relevance of reports—Integrating an automated archiving component into a business intelligence system | |
| CN104182546B (en) | The data query method and device of database | |
| US20170032036A1 (en) | System and Method for Model Creation in an Organizational Environment | |
| JPH08305724A (en) | Device for managing design supporting information document | |
| US20220156228A1 (en) | Data Tagging And Synchronisation System |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 266555 Qingdao economic and Technological Development Zone, Shandong, Hong Kong Road, No. 218 Applicant after: Hisense Video Technology Co.,Ltd. Address before: 266555 Qingdao economic and Technological Development Zone, Shandong, Hong Kong Road, No. 218 Applicant before: QINGDAO HISENSE ELECTRONICS Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |