CN104199977A - Method for searching based on data creation information in database - Google Patents
Method for searching based on data creation information in database Download PDFInfo
- Publication number
- CN104199977A CN104199977A CN201410492550.XA CN201410492550A CN104199977A CN 104199977 A CN104199977 A CN 104199977A CN 201410492550 A CN201410492550 A CN 201410492550A CN 104199977 A CN104199977 A CN 104199977A
- Authority
- CN
- China
- Prior art keywords
- search
- database
- index
- data
- data creation
- 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
- 238000000034 method Methods 0.000 title claims abstract description 20
- 230000006870 function Effects 0.000 claims description 9
- 230000007246 mechanism Effects 0.000 claims description 7
- 230000010354 integration Effects 0.000 claims description 3
- 238000006243 chemical reaction Methods 0.000 abstract description 3
- 230000011218 segmentation Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000004069 differentiation Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003278 mimic effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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
-
- 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
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 method for searching based on data creation information in a database, which comprises the following steps: s10: create index configuration S11: create search engine S12: generation of index data S13: the invention provides a search service, and provides a search engine applied to data search by configuring and creating an index based on a data creation information search method in a database. The conversion from data to index is realized by configuring information and by various word segmentation modes, so that the search mode is diversified, the system is easier to use, the search efficiency is improved, and the consumption of database resources is reduced.
Description
Technical field
The present invention relates to high-end server design field and large scale integrated circuit design technical field, be specifically related to a kind of method based on data creation information search in database.
Background technology
Due to informationalized, develop rapidly, data volume increases considerably, and practical application not only need to have been inquired about with list (several) table above, and increasing user wishes the function of full-text search, thereby improves convenience and the accuracy of search.
Informationalized construction has made all trades and professions accumulate considerable data, and most of data are all stored in database, if develop full-text search function based on these data, will cause database resource consumption very large.
Traditional operation system business information is substantially all stored in database, based on database develop search function on the one hand inquiry velocity fall flat at all, resource that on the other hand also can larger consumption data storehouse.
While inquiring about based on mass data, utilize traditional database retrieval, efficiency own is low, and can not meet and search for requirement fast.
Therefore, the problem existing for above-mentioned prior art, is necessary to develop research, so that a kind of scheme to be provided, and to improve the speed of search, and saving resource, reduce the consumption of database resource.
Summary of the invention
For addressing the above problem, the object of the present invention is to provide a kind of method based on data creation information search in database, to improve search efficiency, and reduce the consumption of database resource.
For achieving the above object, technical scheme of the present invention is:
A method based on data creation information search in database, comprises the steps:
S10: create index configurations
Obtain after database, according to the structure of the information analysis data of data in database, according to the Data classification of different structure, conclude type, and determine the type of concrete index participle, finally by index configurations instrument, configuration information is preserved;
S11: create search engine
Complete after index configurations, read configuration information, the establishment API that utilizes search engine to provide, creates search engine;
S12: generating indexes data
The establishment indexing means of calling search engine, becomes index by the data creation in database; And the update mechanism of later stage index is set according to demand;
S13: search service is provided
Wherein, described search service can be applied towards search, also can be towards the related application of other integration search functions.
Further, in step S12, described update mechanism includes incremental update, full dose renewal, update time and renewal frequency.
The method that the present invention is based on data creation information search in database creates index by configuration, and search engine is provided, and is applied to the application of data search.In data, to the conversion of index, pass through configuration information, and by diversified participle mode, make way of search variation, be easier to the use of system, improved search efficiency, and reduced the consumption of database resource.
Term " first " in instructions of the present invention and claims and above-mentioned accompanying drawing, " second " etc. are for distinguishing similar object, and needn't be for describing specific order or precedence.The term that should be appreciated that such use suitably can exchange in situation, and this is only to describe the differentiation mode in embodiments of the invention, the object of same alike result being adopted when describing.In addition, term " comprises " and " having " and their any distortion, intention is to cover not exclusive comprising, so that the process that comprises a series of unit, method, system, product or equipment are not necessarily limited to those unit, but can comprise clearly do not list or for other intrinsic unit of these processes, method, product or equipment.
Please refer to shown in Fig. 1, Fig. 2, below be elaborated respectively.
A kind of method based on data creation information search in database of the present invention, comprises the steps:
S10: create index configurations
After obtaining database, according to the structure of the information analysis data of data in database, according to the Data classification of different structure, conclude type, and the type of definite concrete index participle (as: numeric type, character type, Chinese word segmentation, English string segmentation, other expansion participle types etc.), finally by index configurations instrument, configuration information is preserved.
S11: create search engine
Complete after index configurations, read configuration information, the establishment API that utilizes search engine to provide, creates search engine.
S12: generating indexes data
Created after search engine, the establishment indexing means of calling search engine, becomes index by the data creation in database; And the update mechanism of later stage index is set according to demand;
Wherein, described update mechanism includes incremental update, full dose renewal, update time and renewal frequency etc.
S13: search service is provided
After index creation completes, can externally provide search service, wherein, described search service can be applied towards search, also can be towards the related application of other integration search functions.
The present invention creates index by the data in database by configuration, and search engine is provided, and is applied to the application of data search.In data, to the conversion of index, pass through configuration information, and by diversified participle mode, make way of search variation, be easier to the use of system.Wherein, take after data, by custom configuration, generate generating indexes, and set up increment index mechanism to meet follow-up data increment.When other operation systems are used function of search, directly utilize search engine just can obtain search information.In the embodiment of the present invention, the solr choosing in search-engine tool, solr provides the api interface that is similar to Web-service.User can ask to inquire about and operate index information by http.
Through the above description of the embodiments, those skilled in the art can be well understood to the mode that the present invention can add essential common hardware by software and realize, and can certainly comprise that special IC, dedicated cpu, private memory, special-purpose components and parts etc. realize by specialized hardware.Generally, all functions being completed by computer program can realize with corresponding hardware at an easy rate, and the particular hardware structure that is used for realizing same function can be also diversified, such as mimic channel, digital circuit or special circuit etc.But software program realization is better embodiment under more susceptible for the purpose of the present invention condition.Understanding based on such, the part that technical scheme of the present invention contributes to prior art in essence in other words can embody with the form of software product, this computer software product is stored in the storage medium can read, as the floppy disk of computing machine, USB flash disk, portable hard drive, ROM (read-only memory) (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic disc or CD etc., comprise that some instructions are with so that a computer equipment (can be personal computer, server, or the network equipment etc.) method described in each embodiment of execution the present invention.
In sum, above embodiment only, in order to technical scheme of the present invention to be described, is not intended to limit; Although the present invention is had been described in detail with reference to above-described embodiment, those of ordinary skill in the art is to be understood that: its technical scheme that still can record the various embodiments described above is modified, or part technical characterictic is wherein equal to replacement; And these modifications or replacement do not make the essence of appropriate technical solution depart from the spirit and scope of various embodiments of the present invention technical scheme.
Accompanying drawing explanation
Fig. 1 is method flow diagram of the present invention.
Fig. 2 is the principle block architecture diagram of the inventive method.
Embodiment
The embodiment of the present invention provides a kind of method based on data creation information search in database, to improve search efficiency, and reduces the consumption of database resource.
For making goal of the invention of the present invention, feature, advantage can be more obvious and understandable, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, the embodiments described below are only the present invention's part embodiment, but not whole embodiment.Embodiment based in the present invention, the every other embodiment that those skilled in the art obtains, belongs to the scope of protection of the invention.
Claims (3)
1. the method based on data creation information search in database, is characterized in that, comprises the steps:
S10: create index configurations
Obtain after database, according to the structure of the information analysis data of data in database, according to the Data classification of different structure, conclude type, and determine the type of concrete index participle, finally by index configurations instrument, configuration information is preserved;
S11: create search engine
Complete after index configurations, read configuration information, the establishment API that utilizes search engine to provide, creates search engine;
S12: generating indexes data
The establishment indexing means of calling search engine, becomes index by the data creation in database; And the update mechanism of later stage index is set according to demand;
S13: search service is provided
Wherein, described search service can be applied towards search, also can be towards the related application of other integration search functions.
2. the method based on data creation information search in database as claimed in claim 1, is characterized in that: in step S12, described update mechanism includes incremental update, full dose renewal, update time and renewal frequency.
3. the method based on data creation information search in database as claimed in claim 2, is characterized in that: can ask to inquire about and operate index information by http.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410492550.XA CN104199977A (en) | 2014-09-24 | 2014-09-24 | Method for searching based on data creation information in database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410492550.XA CN104199977A (en) | 2014-09-24 | 2014-09-24 | Method for searching based on data creation information in database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104199977A true CN104199977A (en) | 2014-12-10 |
Family
ID=52085270
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410492550.XA Pending CN104199977A (en) | 2014-09-24 | 2014-09-24 | Method for searching based on data creation information in database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104199977A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504146A (en) * | 2015-01-05 | 2015-04-08 | 浪潮(北京)电子信息产业有限公司 | Classified management method and system for data |
| CN105988996A (en) * | 2015-01-27 | 2016-10-05 | 腾讯科技（深圳）有限公司 | Index file generation method and device |
| CN106156088A (en) * | 2015-04-01 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of index data processing method, data query method and device |
| CN106294695A (en) * | 2016-08-08 | 2017-01-04 | 深圳市网安计算机安全检测技术有限公司 | A kind of implementation method towards the biggest data search engine |
| CN106332167A (en) * | 2015-06-19 | 2017-01-11 | 中兴通讯股份有限公司 | Method and device of configuring management in mobile network |
| CN111767308A (en) * | 2019-04-01 | 2020-10-13 | 广州精选速购网络科技有限公司 | Method, system, electronic device and medium for real-time screening and sorting of commodities |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101154241A (en) * | 2007-10-11 | 2008-04-02 | 北京金山软件有限公司 | Data searching method and data searching system |
| CN101609460A (en) * | 2009-07-22 | 2009-12-23 | 中国科学院地理科学与资源研究所 | A kind of search method and searching system of supporting the heterogeneous earth science data resource |
-
2014
- 2014-09-24 CN CN201410492550.XA patent/CN104199977A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101154241A (en) * | 2007-10-11 | 2008-04-02 | 北京金山软件有限公司 | Data searching method and data searching system |
| CN101609460A (en) * | 2009-07-22 | 2009-12-23 | 中国科学院地理科学与资源研究所 | A kind of search method and searching system of supporting the heterogeneous earth science data resource |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504146A (en) * | 2015-01-05 | 2015-04-08 | 浪潮(北京)电子信息产业有限公司 | Classified management method and system for data |
| CN104504146B (en) * | 2015-01-05 | 2018-01-30 | 浪潮(北京)电子信息产业有限公司 | A kind of data sort management method and system |
| CN105988996A (en) * | 2015-01-27 | 2016-10-05 | 腾讯科技（深圳）有限公司 | Index file generation method and device |
| CN105988996B (en) * | 2015-01-27 | 2020-04-10 | 腾讯科技（深圳）有限公司 | Index file generation method and device |
| CN106156088A (en) * | 2015-04-01 | 2016-11-23 | 阿里巴巴集团控股有限公司 | A kind of index data processing method, data query method and device |
| CN106156088B (en) * | 2015-04-01 | 2020-02-04 | 阿里巴巴集团控股有限公司 | Index data processing method, data query method and device |
| CN106332167A (en) * | 2015-06-19 | 2017-01-11 | 中兴通讯股份有限公司 | Method and device of configuring management in mobile network |
| CN106294695A (en) * | 2016-08-08 | 2017-01-04 | 深圳市网安计算机安全检测技术有限公司 | A kind of implementation method towards the biggest data search engine |
| CN111767308A (en) * | 2019-04-01 | 2020-10-13 | 广州精选速购网络科技有限公司 | Method, system, electronic device and medium for real-time screening and sorting of commodities |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10210243B2 (en) | Method and system for enhanced query term suggestion | |
| CN104199977A (en) | Method for searching based on data creation information in database | |
| WO2019024496A1 (en) | Enterprise recommendation method and application server | |
| CN108170650B (en) | Text comparison method and text comparison device | |
| JP2020074193A (en) | Search method, device, facility, and non-volatile computer memory | |
| CN103077183A (en) | Data importing method and system for distributed sequence list | |
| CN102129425A (en) | Method and device for accessing large-object set table in data warehouse | |
| CN104077415A (en) | Searching method and device | |
| CN104866985A (en) | Express bill number identification method, device and system | |
| CN103473036A (en) | Input method skin push method and system | |
| WO2017092444A1 (en) | Log data mining method and system based on hadoop | |
| CN104484392A (en) | Method and device for generating database query statement | |
| CN103136213A (en) | Method and device for providing related words | |
| CN103942328A (en) | Video retrieval method and video device | |
| CN105138649A (en) | Data search method and device and terminal | |
| CN112905587B (en) | Database data management method and device and electronic equipment | |
| CN104699788A (en) | Database query method and device | |
| CN104462347A (en) | Keyword classifying method and device | |
| CN107220283B (en) | Data processing method, device, storage medium and electronic equipment | |
| CN103077032A (en) | Operation method for application program and application program client-side | |
| CN104915435A (en) | Data query method and device | |
| CN117171296A (en) | Information acquisition method and device and electronic equipment | |
| CN109697234B (en) | Multi-attribute information query method, device, server and medium for entity | |
| US10671644B1 (en) | Adaptive column set composition | |
| CN107977381B (en) | Data configuration method, index management method, related device and computing equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20141210 |
|
| WD01 | Invention patent application deemed withdrawn after publication |