CN103646071A - Dynamic data search method - Google Patents
Dynamic data search method Download PDFInfo
- Publication number
- CN103646071A CN103646071A CN201310661729.9A CN201310661729A CN103646071A CN 103646071 A CN103646071 A CN 103646071A CN 201310661729 A CN201310661729 A CN 201310661729A CN 103646071 A CN103646071 A CN 103646071A
- Authority
- CN
- China
- Prior art keywords
- index
- inquiry
- display field
- mode
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a dynamic data search method. The dynamic data search method comprises the steps of building relevant indexes for a search condition and a display field respectively, and setting a searched object, wherein the display field is a field needing displaying in a search result; generating the setting mode of the search condition and the setting mode of the display field according to the indexes, wherein the setting modes are provided for a user; determining the search condition and the display field by the user according to the setting mode of the search condition and the setting mode of the display field; searching corresponding data from a data base according to the search condition set by the user, and displaying the obtained search result according to the display field set by the user.
Description
Technical field
The present invention relates to data retrieval field, particularly a kind of dynamic data search method.
Background technology
In recent years, along with the explosive growth of information, how retrieving quickly and efficiently Useful Information has become a problem in the urgent need to address.Utilizing computer realization information retrieval is the most common, information retrieval mode fast at present, and the search engines such as Google, Baidu have become requisite application tool in people's work, study, life.
First deterministic retrieval condition of inevitable requirement user while adopting computer realization information retrieval, the search condition that computer information retrieval software of the prior art provides is fixed, display mode and the displaying contents of its result for retrieval are also fixed, and lack dirigibility.Specifically, when software user needs retrieving information, the fixing search condition providing in the time of can only using Software for Design exploitation is retrieved, and the resultant content simultaneously drawing is also that while developing according to Software for Design, convention shows; If when the search condition that software user does not provide in the time of need to designing and developing or identical conditions query composition retrieving information, or the field that the result for retrieval that software user needs shows row provide when designing and developing when inconsistent, just need to remodify issue to software program, both to software application, made troubles, also the stability of software was impacted simultaneously.
Summary of the invention
The object of the invention is to overcome search method of the prior art information retrieval condition, the fixing problem of displaying contents when realizing retrieval, thus provide a kind of can self-defined search condition, the search method of displaying contents.
To achieve these goals, the invention provides a kind of dynamic data search method, comprising:
Step 1), set up separately relevant index, and set searching object for search condition, display field; Wherein, described display field is the field that needs demonstration in result for retrieval;
Step 2), the index of setting up according to step 1) generates the set-up mode of search condition and the set-up mode of display field that offers user;
Step 3), user utilize step 2) set-up mode of search condition and set-up mode deterministic retrieval condition and the display field of display field that generate;
Step 4), the search condition setting according to user are inquired about corresponding data from database, and the display field then resulting Query Result being set according to user shows.
In technique scheme, in described step 1), for search condition, set up index and comprise: for inquiring about index and inquiry mode, set up index; Wherein,
For inquiry Index Establishment index comprises: set up respectively index for field name and the display Name on the page of described inquiry index in database, obtain " the field name index of inquiry index in database " and " the display Name index of inquiry index on the page ";
For inquiry mode, setting up index comprises: the content that is inquiry mode according to the type of inquiry mode is set up index, obtains " inquiry index mode types index ".
In technique scheme, for search condition, set up index and also comprise: the corresponding query contents of inquiry index that is data dictionary type to inquiry mode type is set up index, obtain " data dictionary type corresponding types value index ".
In technique scheme, in described step 1), for display field, set up index and comprise: for the title of display field in database, set up index, obtain " name index of display field in database "; For display field, in the title of the page, set up index, obtain " display field is in the name index of the page ".
In technique scheme, for display field, set up index and also comprise: for result for retrieval acquiescence display field is set up index.
In technique scheme, in described step 2) in, the set-up mode of described search condition is a search condition list, this search condition list at least comprises three: inquiry index row, inquiry mode row and query contents row; Wherein,
Described inquiry index row comprise a plurality of inquiry index item to be selected, and these inquiry index item are generated by " the display Name index of inquiry index field on the page ";
Described inquiry mode row comprise a plurality of inquiry mode items to be selected, and described multiple queries mode item is obtained by " the display Name index of inquiry index field on the page " corresponding various " inquiry index mode types index " of the inquiry index of determining;
Described query contents row comprise the list of search condition corresponding all values in data dictionary or are sky.
In technique scheme, in described step 2) in, the set-up mode of described display field is a display field list, described display field list comprises a plurality of display fields to be selected, and described display field to be selected is obtained by each " display field is in the name index of the page " corresponding field name.
In technique scheme, in described step 3), described deterministic retrieval condition comprises: first user selects one or more inquiry index item from a plurality of inquiry index item to be selected, by this definite inquiry index item, can obtain a plurality of inquiry mode items to be selected, from these inquiry mode items, choose one or more; User selects or needs input inquiry content voluntarily according to self from the list of described search condition corresponding all values data dictionary.
In technique scheme, in described step 3), described definite display field comprises: the display field that user should comprise in deterministic retrieval result from display field to be selected; If it is a plurality of that described display field has, the sequencing between display field is also set.
In technique scheme, described definite display field also comprises: user arranges acquiescence display field according to result for retrieval acquiescence display field index.
The invention has the advantages that:
1, user can meet by search method of the present invention the difference retrieval requirement producing for different business demand flexibly, easily.
2, when search condition change that user needs, can the brand-new search condition set of easy customization complete data retrieval; As user, because business demand changes while needing content field change that result for retrieval presents, only need set and display field just can change the display field in result for retrieval.
Accompanying drawing explanation
Fig. 1 is in one embodiment search condition list involved in the present invention and the operation reference view of selecting inquiry index;
Fig. 2 is the schematic diagram that inquiry mode corresponding to index inquired about in selection involved in the present invention in one embodiment;
Fig. 3 is the schematic diagram that query contents involved in the present invention is in one embodiment listed as;
Fig. 4 is the schematic diagram that generates in one embodiment search condition;
Fig. 5 is the schematic diagram that display field is set in one embodiment;
Fig. 6 is the schematic diagram of resulting result for retrieval in one embodiment;
Fig. 7 is the process flow diagram of the inventive method.
Embodiment
Now the invention will be further described by reference to the accompanying drawings.
With reference to figure 7, method of the present invention comprises:
Step 1), set up separately relevant index, and set searching object for search condition, display field.
In a, this step, the condition of required setting when described search condition refers to user search, described search condition comprises a plurality of parts, as inquiry index, inquiry mode and query contents.Corresponding data item or data field when inquiry index wherein refers to data retrieval, inquiry index can be divided into different types, as character string type, data dictionary type and time type, the common inquiry index of take in patent retrieval is example, " patent No. " belongs to character string type, " country origin under patent " belongs to digital dictionary type, and " date of application " belongs to time type.Mode when described inquiry mode refers to corresponding inquiry index inquiry.Inquiry mode can be divided into multiple according to type, as character string mode, date mode, dictionary mode etc.; For dissimilar inquiry mode, the content of inquiry mode is also had nothing in common with each other, for example, if the type of inquiry mode is the patent No., the content of inquiry mode can comprise " comprising ", " equaling ", if the type of inquiry mode is the date of application, the content of inquiry mode can comprise " being later than ", " early than ", " equaling ".Retrieval of content when described query contents refers to corresponding inquiry index retrieval.If inquiry mode is set to equal, query contents is set to 2012, according to inquiry index, equals 2012 and retrieves.
When setting up index for inquiry index, need to inquire about field name and the display Name on the page of index in database for this and set up respectively index.For example, one inquiry index is " patent No. ", the display Name of this inquiry index on the page is exactly " patent No. ", but the field name in database is " PNO ", for this inquiry index is set up respectively " the field name index of inquiry index in database " and " the display Name index of inquiry index on the page ".
When setting up index for inquiry mode, according to the type of inquiry mode, set up index, the index of setting up is called as " inquiry index mode types index ".As the index of being set up for the inquiry mode of character string type is included as " comprising ", " equaling " sets up respectively index.
Query contents is not generally set up to index, and the corresponding query contents of inquiry index that is only data dictionary type to inquiry mode type is set up index.The index of setting up is called as " data dictionary type corresponding types value index ".As: inquiry index is patented claim type, and dictionary index value is " invention, utility model, appearance design "
B, in this step, described display field refers to needs the field that shows in result for retrieval.Because result for retrieval may include a large amount of data, therefore to showing that the field that should comprise in result limits, contribute to user to pay close attention to those useful contents.For example, in patent retrieval, display field can comprise: the patent No., patent name, publication number, date of application, authorization date, Main classification number, secondary classification number etc.
For display field, setting up index comprises: for the title of display field in database set up index (resulting index name is designated as " name index of display field in database "), set up index (resulting index name is designated as " display field is in the name index of the page ") for display field in the title of the page, in addition, as a kind of optional implementation, also can be result for retrieval acquiescence display field and set up index.
C, in this step, the database that will use when searching object refers to retrieval or certain part in database.It is exactly that the object that a certain query manipulation need to be inquired about is set that searching object is set, as a certain database, or corresponding certain or a plurality of table or view etc. in a certain database.
Step 2), according to the index of setting up before, generate for offering user's the set-up mode of search condition and the set-up mode of display field.
The set-up mode of the search condition providing to user in the present embodiment, and the set-up mode of display field can adopt a Query List to realize.In this Query List, comprise search condition list and display field list.
Search condition list wherein at least comprises three: inquiry index row, inquiry mode row and query contents row; Wherein, described inquiry index row comprise a plurality of inquiry index item to be selected, and these inquiry index item are by resulting each " inquiry index field display Name index on the page " generation before; Described inquiry mode row comprise a plurality of inquiry mode items to be selected, these inquiry mode items with inquire about before index row in selected inquiry index relevant, once inquiry index is determined, described inquiry mode row comprise and the corresponding multiple queries mode of determined inquiry index item, and described multiple queries mode item can corresponding various " inquiry index mode types index " be obtained by " the display Name index of inquiry index field on the page " of the inquiry index of determining; Described query contents comprises the list of this search condition corresponding all values in data dictionary, if inquiry mode is dictionary mode, by " data dictionary type corresponding types value index ", dictionary value corresponding to the inquiry index of selection is presented on to query contents place, for you to choose.For example, inquiry mode type corresponding to certain inquiry index of selecting is data dictionary type, at query contents place, can read with reference to inquiry index index, inquiry mode index, data dictionary index correspondence the value of this inquiry index correspondence in data dictionary, as: while selecting patented claim type for inquiry index, query contents place can demonstrate the list option of " invention, utility model, appearance design ".If inquiry mode is non-dictionary mode, described query contents needs user to input.
Display field list wherein comprises each " display field is in the name index of the page " corresponding field name.
Step 3), user are according to step 2) set-up mode of search condition and set-up mode deterministic retrieval condition and the display field of display field that generate.
First user selects a certain inquiry index item from a plurality of inquiry index item to be selected, by this definite inquiry index item, can obtain a plurality of inquiry mode items to be selected, from these inquiry mode items, chooses one.User needs input inquiry content voluntarily according to self.
The display field that user should comprise in deterministic retrieval result from display field to be selected.If it is a plurality of that described display field has, also the sequencing between display field can be set.
As a kind of optional implementation, user also can give tacit consent to display field index according to result for retrieval acquiescence display field is set.
Step 4), the search condition setting according to user are inquired about corresponding data from database, and the display field then resulting Query Result being set according to user shows.
For the ease of understanding, below in conjunction with accompanying drawing, one embodiment of the present of invention are described further.
In one embodiment, user wishes patent data to retrieve, and data object to be retrieved is patent table; Corresponding data field title comprises: patent name, the patent No., date of application, authorization date etc.; Field name in database is respectively: PNAME, PNO, APPLYDATE, ACCREDITDATE.Carry out following steps below:
1, according to data message, generate the relative index that retrieval needs;
2, according to Database field title, inquiry index field page display Name index, generate search condition list, then from described search condition list, select inquiry index; The operation of resulting search condition list and selection inquiry index is with reference to shown in figure 1.
While 3, selecting inquiry index, inquiry mode generates corresponding inquiry mode according to " the field name index of inquiry index in database ", " the display Name index of inquiry index on the page ", " inquiry index mode types index ", as: be greater than, be less than, equal, comprise etc.; Select inquiry mode corresponding to inquiry index shown in Figure 2.
4, query contents corresponding to inquiry index is set, to generate complete search condition; Especially, if inquiry mode is dictionary mode, by " data dictionary type corresponding types value index ", dictionary value corresponding to the inquiry index of selection is presented on to query contents and sentences selective.The result of this step is shown in Figure 3.
5, repeat 2-4 operation before, until all inquiry indexs are added into search condition.The result of this step is shown in Figure 4.
6, the field showing in result for retrieval is set, by mobile field, DISPLAY ORDER is set, as shown in Figure 5.
7, inquiry draws result for retrieval, and resulting result for retrieval as shown in Figure 6.
It should be noted last that, above embodiment is only unrestricted in order to technical scheme of the present invention to be described.Although the present invention is had been described in detail with reference to embodiment, those of ordinary skill in the art is to be understood that, technical scheme of the present invention is modified or is equal to replacement, do not depart from the spirit and scope of technical solution of the present invention, it all should be encompassed in the middle of claim scope of the present invention.
Claims (10)
1. a dynamic data search method, comprising:
Step 1), set up separately relevant index, and set searching object for search condition, display field; Wherein, described display field is the field that needs demonstration in result for retrieval;
Step 2), the index of setting up according to step 1) generates the set-up mode of search condition and the set-up mode of display field that offers user;
Step 3), user utilize step 2) set-up mode of search condition and set-up mode deterministic retrieval condition and the display field of display field that generate;
Step 4), the search condition setting according to user are inquired about corresponding data from database, and the display field then resulting Query Result being set according to user shows.
2. dynamic data search method according to claim 1, is characterized in that, in described step 1), sets up index comprise for search condition: for inquiring about index and inquiry mode, set up index; Wherein,
For inquiry Index Establishment index comprises: set up respectively index for field name and the display Name on the page of described inquiry index in database, obtain " the field name index of inquiry index in database " and " the display Name index of inquiry index on the page ";
For inquiry mode, setting up index comprises: the content that is inquiry mode according to the type of inquiry mode is set up index, obtains " inquiry index mode types index ".
3. dynamic data search method according to claim 2, it is characterized in that, for search condition, setting up index also comprises: the corresponding query contents of inquiry index that is data dictionary type to inquiry mode type is set up index, obtains " data dictionary type corresponding types value index ".
4. dynamic data search method according to claim 1, it is characterized in that, in described step 1), for display field, set up index and comprise: for the title of display field in database, set up index, obtain " name index of display field in database "; For display field, in the title of the page, set up index, obtain " display field is in the name index of the page ".
5. dynamic data search method according to claim 4, is characterized in that, sets up index also comprise for display field: for result for retrieval acquiescence display field is set up index.
6. dynamic data search method according to claim 3, it is characterized in that, in described step 2) in, the set-up mode of described search condition is a search condition list, this search condition list at least comprises three: inquiry index row, inquiry mode row and query contents row; Wherein,
Described inquiry index row comprise a plurality of inquiry index item to be selected, and these inquiry index item are generated by " the display Name index of inquiry index field on the page ";
Described inquiry mode row comprise a plurality of inquiry mode items to be selected, and described multiple queries mode item is obtained by " the display Name index of inquiry index field on the page " corresponding various " inquiry index mode types index " of the inquiry index of determining;
Described query contents row comprise the list of search condition corresponding all values in data dictionary or are sky.
7. dynamic data search method according to claim 5, it is characterized in that, in described step 2) in, the set-up mode of described display field is a display field list, described display field list comprises a plurality of display fields to be selected, and described display field to be selected is obtained by each " display field is in the name index of the page " corresponding field name.
8. dynamic data search method according to claim 6, it is characterized in that, in described step 3), described deterministic retrieval condition comprises: first user selects one or more inquiry index item from a plurality of inquiry index item to be selected, by this definite inquiry index item, can obtain a plurality of inquiry mode items to be selected, from these inquiry mode items, choose one or more; User selects or needs input inquiry content voluntarily according to self from the list of described search condition corresponding all values data dictionary.
9. dynamic data search method according to claim 7, is characterized in that, in described step 3), described definite display field comprises: the display field that user should comprise in deterministic retrieval result from display field to be selected; If it is a plurality of that described display field has, the sequencing between display field is also set.
10. dynamic data search method according to claim 9, is characterized in that, described definite display field also comprises: user arranges acquiescence display field according to result for retrieval acquiescence display field index.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310661729.9A CN103646071A (en) | 2013-12-09 | 2013-12-09 | Dynamic data search method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310661729.9A CN103646071A (en) | 2013-12-09 | 2013-12-09 | Dynamic data search method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103646071A true CN103646071A (en) | 2014-03-19 |
Family
ID=50251285
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310661729.9A Pending CN103646071A (en) | 2013-12-09 | 2013-12-09 | Dynamic data search method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103646071A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243061A (en) * | 2014-05-30 | 2016-01-13 | 联想(北京)有限公司 | Information processing method and apparatus and electronic device |
| CN112306998A (en) * | 2020-10-13 | 2021-02-02 | 武汉中科通达高新技术股份有限公司 | Commission data duplicate removal method, device and server |
| CN112445830A (en) * | 2020-11-26 | 2021-03-05 | 湖南智慧政务区块链科技有限公司 | Data analysis system based on block chain technology |
-
2013
- 2013-12-09 CN CN201310661729.9A patent/CN103646071A/en active Pending
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243061A (en) * | 2014-05-30 | 2016-01-13 | 联想(北京)有限公司 | Information processing method and apparatus and electronic device |
| CN105243061B (en) * | 2014-05-30 | 2020-08-25 | 联想(北京)有限公司 | Information processing method and device and electronic equipment |
| CN112306998A (en) * | 2020-10-13 | 2021-02-02 | 武汉中科通达高新技术股份有限公司 | Commission data duplicate removal method, device and server |
| CN112306998B (en) * | 2020-10-13 | 2023-11-24 | 武汉中科通达高新技术股份有限公司 | Method, device and server for de-duplication of traffic and delegation data |
| CN112445830A (en) * | 2020-11-26 | 2021-03-05 | 湖南智慧政务区块链科技有限公司 | Data analysis system based on block chain technology |
| CN112445830B (en) * | 2020-11-26 | 2024-05-14 | 湖南智慧政务区块链科技有限公司 | Data analysis system based on block chain technology |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8869020B2 (en) | Method and system for generating relational spreadsheets | |
| CN101840400B (en) | Multilevel classification retrieval method and system | |
| US20060173813A1 (en) | System and method of providing ad hoc query capabilities to complex database systems | |
| US7769752B1 (en) | Method and system for updating display of a hierarchy of categories for a document repository | |
| US20060242189A1 (en) | High-level database management system | |
| CN102521417A (en) | Method for processing multi-dimensional data based on virtual data cube and system of method | |
| US10296505B2 (en) | Framework for joining datasets | |
| JP2006012125A (en) | Method and system for indexing and searching databases | |
| US20090063532A1 (en) | Method and system for generating database records | |
| EP2889788A1 (en) | Accessing information content in a database platform using metadata | |
| CN102810114A (en) | Personal computer resource management system based on body | |
| CN104268295A (en) | Data query method and device | |
| KR20160053933A (en) | Smart search refinement | |
| CN106503040B (en) | It is applicable in the KV database and its creation method of SQL query method | |
| CN104391941A (en) | Method for rapidly establishing full-text retrieval tool for common files | |
| KR101635383B1 (en) | Method, server and computer readable recording medium for associating schedule information of electronic diary with mind map | |
| WO2004097679A1 (en) | Database device, database search device, and method thereof | |
| CN103646071A (en) | Dynamic data search method | |
| CN102609455B (en) | Method for Chinese homophone searching | |
| CN101393551B (en) | Index establishing system and method for patent full text search | |
| CN106649879A (en) | Method for intelligent recommendation of professional book in library | |
| CN103177046B (en) | A kind of data processing method based on row storage data base and equipment | |
| CN105184550B (en) | Manage method, server and the system of waiting data | |
| US8185516B2 (en) | Method for filtering file clusters | |
| CN104537047A (en) | Garment basic sample plate retrieval system based on Lucene |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140319 |