CN102789487B - Data query retrieval process device and data query search processing method - Google Patents
Data query retrieval process device and data query search processing method Download PDFInfo
- Publication number
- CN102789487B CN102789487B CN201210225062.3A CN201210225062A CN102789487B CN 102789487 B CN102789487 B CN 102789487B CN 201210225062 A CN201210225062 A CN 201210225062A CN 102789487 B CN102789487 B CN 102789487B
- Authority
- CN
- China
- Prior art keywords
- data
- retrieval
- retrieved
- result
- index information
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of data query retrieval process device, comprising: data acquisition module, obtain the section of the corresponding data cube of external data table; Data filtering module, by predetermined filtering item, carries out filtration to described section and obtains the data that are retrieved; Index generation module is the described data genaration index information that is retrieved; Retrieval process module, receives the search key of user, and obtains the first index information mated with described search key, and is retrieved data as result for retrieval using corresponding with described first index information first, is presented to described user.Present invention also offers a kind of data query search processing method.The inquiry mode of form can be optimized by the present invention, improve search efficiency.
Description
Technical field
The present invention relates to data retrieval technology field, in particular to a kind of data query retrieval process device and a kind of data query search processing method.
Background technology
Enterprise can produce various in business process, have different business meaning, the form of different-format, these forms embody the whole management state of enterprise, and when want for enterprise operation carry out in a certain respect analyzing time, need to carry out finishing analysis to these report datas.
Solving the common mode of this demand is use OLAP system, carries out modeling, sum up concrete dimension to analysis in a certain respect, and needs the index of checking, analysis in a certain respect often has multiple dimension, multiple index usually; Have member value in dimension, the data cube data message amount formed after combination is very large.And when specifically representing, represent certain data tangent plane (namely in multiple dimension, each member puts the face of composition) often.From the angle of analyst, to understand under certain several dimension when several finger target value at needs, multiple tangent plane may be crossed over, i.e. multiple analytical statement.
In existing form, the analysis for index and dimension is all carry out retrieval and inquisition for single table substantially, inquires about after the achievement data of each form needs execution to represent simultaneously.The query demand of analyst can not be met like this, open simultaneously at every turn and all will carry out the complex operations such as calculating, efficiency also exists serious problems.
Therefore, need a kind of new data query retrieval process device, the inquiry mode of form can be optimized, improve search efficiency.
Summary of the invention
Technical matters to be solved by this invention is, provides a kind of data query retrieval process device, can optimize the inquiry mode of form, improves search efficiency.
In view of this, the invention provides a kind of data query retrieval process device, comprising: data acquisition module, obtain the section of the corresponding data cube of external data table; Data filtering module, by predetermined filtering item, carries out filtration to described section and obtains the data that are retrieved; Index generation module is the described data genaration index information that is retrieved; Retrieval process module, receives the search key of user, and obtains the first index information mated with described search key, and is retrieved data as result for retrieval using corresponding with described first index information first, is presented to described user.In this technical scheme, by first, section is filtered, significantly can reduce the scope of the data that are retrieved, then carry out data retrieval at the search key inputted according to user, effectively improve recall precision; By calling search function, the real-time refreshing of retrieve data can be realized, improve the accuracy of retrieval; In addition, by the index of gopher for keyword, the data retrieval across form is achieved.
Preferably, described retrieval process module also arranges ways of presentation, and represents described result for retrieval by described ways of presentation.In this technical scheme, by arranging ways of presentation, can realize controlling neatly to represent effect.
Preferably, described in the data that are retrieved there is one or more tables of data attribute, the value of the one or more tables of data attribute in described result for retrieval is linked to corresponding tables of data by described retrieval process module.In this technical scheme, the value of tables of data attribute is linked to corresponding tables of data, achieve the hyperlink of report name being added to corresponding true form, the form can opening needs understanding when user needs checks the details of this form, convenient for users to use.
Preferably, described retrieval process module also inquires about the related content of described result for retrieval, and is presented to described user.In this technical scheme, can also automatically retrieve the content relevant to result for retrieval and show, make user can understand the various information relevant to result for retrieval in time, improve Consumer's Experience.
Preferably, described index generation module uses the research tool of specifying, and carries out participle dissection process, to generate described index information to the described data that are retrieved.In this technical scheme, external plug-in can be called and retrieve, decrease the workload of developer, reduce cost.
Present invention also offers a kind of data query search processing method, comprising: step 202, obtain the section of the corresponding data cube of external data table; Step 204, by predetermined filtering item, carries out filtration to described section and obtains the data that are retrieved; Step 206 is the described data genaration index information that is retrieved; Step 208, receives the search key of user, and obtains the first index information mated with described search key, and is retrieved data as result for retrieval using corresponding with described first index information first, is presented to described user.In this technical scheme, by first, section is filtered, significantly can reduce the scope of the data that are retrieved, then carry out data retrieval at the search key inputted according to user, effectively improve recall precision; By calling search function, the real-time refreshing of retrieve data can be realized, improve the accuracy of retrieval; In addition, by the index of gopher for keyword, the data retrieval across form is achieved.
Preferably, described step 208 also comprises: arrange ways of presentation, and represents described result for retrieval by described ways of presentation.In this technical scheme, by arranging ways of presentation, can realize controlling neatly to represent effect.
Preferably, described step 208 comprises: described in the data that are retrieved there is one or more tables of data attribute, the value of the one or more tables of data attribute in described result for retrieval is linked to corresponding tables of data.In this technical scheme, the value of tables of data attribute is linked to corresponding tables of data, achieve the hyperlink of report name being added to corresponding true form, the form can opening needs understanding when user needs checks the details of this form, convenient for users to use.
Preferably, described step 208 also comprises: the related content of also inquiring about described result for retrieval, and is presented to described user.In this technical scheme, can also automatically retrieve the content relevant to result for retrieval and show, make user can understand the various information relevant to result for retrieval in time, improve Consumer's Experience.
Preferably, described step 206 comprises: use the research tool of specifying, carry out participle dissection process, to generate described index information to the described data that are retrieved.In this technical scheme, external plug-in can be called and retrieve, decrease the workload of developer, reduce cost.
In sum, by the present invention, by first, section is filtered, significantly can reduce the scope of the data that are retrieved, then carry out data retrieval at the search key inputted according to user, effectively improve recall precision; By calling search function, the real-time refreshing of retrieve data can be realized, improve the accuracy of retrieval; In addition, by the index of gopher for keyword, the data retrieval across form is achieved.
Accompanying drawing explanation
Fig. 1 is the block diagram of the data query retrieval process device according to the embodiment of the present invention;
Fig. 2 is the process flow diagram of the data query search processing method according to the embodiment of the present invention;
Fig. 3 is the block diagram of data query retrieval process device according to another embodiment of the present invention;
Fig. 4 is the process flow diagram of data query search processing method according to another embodiment of the present invention;
Fig. 5 is the interface sectional drawing of keyword search device according to another embodiment of the present invention.
Embodiment
In order to more clearly understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.
Set forth a lot of detail in the following description so that fully understand the present invention, but the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following public specific embodiment.
As shown in Figure 1, the invention provides a kind of data query retrieval process device 100, comprising: data acquisition module 102, obtain the section of the corresponding data cube of external data table; Data filtering module 104, by predetermined filtering item, carries out filtration to section and obtains the data that are retrieved; Index generation module 106 is the data genaration index information that is retrieved; Retrieval process module 108, receives the search key of user, and obtains the first index information mated with search key, and is retrieved data as result for retrieval using corresponding with the first index information first, is presented to user.In this technical scheme, by first, section is filtered, significantly can reduce the scope of the data that are retrieved, then carry out data retrieval at the search key inputted according to user, effectively improve recall precision; By calling search function, the real-time refreshing of retrieve data can be realized, improve the accuracy of retrieval; In addition, by the index of gopher for keyword, the data retrieval across form is achieved.
Preferably, retrieval process module 108 also arranges ways of presentation, and represents result for retrieval by ways of presentation.In this technical scheme, by arranging ways of presentation, can realize controlling neatly to represent effect.
Preferably, the data that are retrieved have one or more tables of data attribute, and the value of the one or more tables of data attribute in result for retrieval is linked to corresponding tables of data by retrieval process module 108.In this technical scheme, the value of tables of data attribute is linked to corresponding tables of data, achieve the hyperlink of report name being added to corresponding true form, the form can opening needs understanding when user needs checks the details of this form, convenient for users to use.
Preferably, retrieval process module 108 goes back the related content of query and search result, and is presented to user.In this technical scheme, can also automatically retrieve the content relevant to result for retrieval and show, make user can understand the various information relevant to result for retrieval in time, improve Consumer's Experience.
Preferably, index generation module 106 uses the research tool of specifying, and to being retrieved, data carry out participle dissection process, with generating indexes information.In this technical scheme, external plug-in can be called and retrieve, decrease the workload of developer, reduce cost.
As shown in Figure 2, present invention also offers a kind of data query search processing method, comprising: step 202, obtain the section of the corresponding data cube of external data table; Step 204, by predetermined filtering item, carries out filtration to section and obtains the data that are retrieved; Step 206 is the data genaration index information that is retrieved; Step 208, receives the search key of user, and obtains the first index information mated with search key, and is retrieved data as result for retrieval using corresponding with the first index information first, is presented to user.In this technical scheme, by first, section is filtered, significantly can reduce the scope of the data that are retrieved, then carry out data retrieval at the search key inputted according to user, effectively improve recall precision; By calling search function, the real-time refreshing of retrieve data can be realized, improve the accuracy of retrieval; In addition, by the index of gopher for keyword, the data retrieval across form is achieved.
Preferably, step 208 also comprises: arrange ways of presentation, and represents result for retrieval by ways of presentation.In this technical scheme, by arranging ways of presentation, can realize controlling neatly to represent effect.
Preferably, step 208 comprises: the data that are retrieved have one or more tables of data attribute, the value of the one or more tables of data attribute in result for retrieval is linked to corresponding tables of data.In this technical scheme, the value of tables of data attribute is linked to corresponding tables of data, achieve the hyperlink of report name being added to corresponding true form, the form can opening needs understanding when user needs checks the details of this form, convenient for users to use.
Preferably, step 208 also comprises: the related content of going back query and search result, and is presented to user.In this technical scheme, can also automatically retrieve the content relevant to result for retrieval and show, make user can understand the various information relevant to result for retrieval in time, improve Consumer's Experience.
Preferably, step 206 comprises: use the research tool of specifying, to being retrieved, data carry out participle dissection process, with generating indexes information.In this technical scheme, external plug-in can be called and retrieve, decrease the workload of developer, reduce cost.
Fig. 3 is the block diagram of data query retrieval process device according to another embodiment of the present invention.
As shown in Figure 3, the data query retrieval process device in the present embodiment comprises: dispatch deal device 302, primary responsibility timing scan reporting system, get cube slice information corresponding in form, and section is calculated, according to the structure of the data that are retrieved, generate the data that are retrieved; Index instrument 304, adopts third-party research tool, crawls the data be retrieved, generating indexes file, simultaneously as search engine, to query and search provisioning interface, returns matching result; Results processor 306, provides customizable result to describe, and to inquiring about the result returned, customizes, and comprise form coding as returned, report name, matching keywords is highlighted, and form opens the Search Results of link; Keyword search device 308, accepts the input of extraneous keyword, calls gopher, obtain Search Results
Wherein, data cube section refers to the section that the data cube quoted in inquiry report data system is correlated with.Form essential informations (title, coding) all in system can be got from here, the Data Source (i.e. data cube) that form is quoted, data model (i.e. cube section).
The data be retrieved are mainly third party's gopher and crawl prepared data, can be configured according to different business scenarios, and its typical data structure is as shown in the table:
| Coding | Title | Key word (dimension) | Details |
In this example, coding and title are the base attributes of form, and key word is generally the dimension of filtering in form content, such as, check the data of certain unit time, then unit and time are key word (dimension).Details are concrete report form index data, as the title of index, and desired value etc.
Index file refers to, index instrument crawls " data be retrieved ", is generated a kind of data structure describing the data that are retrieved by participle dissection process.
Search Results refers to, calls gopher, according to the result data that key word of the inquiry returns.
Fig. 4 is the process flow diagram of data query search processing method according to another embodiment of the present invention.
The concrete treatment scheme of the data query retrieval process device shown in Fig. 3 as shown in Figure 4, comprises the following steps:
Step 402, analytical statement design, amendment are preserved, the accounting logging of scheduler program timing scan.
Step 402, obtains form essential information, and slice information.
Step 402, generates according to definition format the data that are retrieved.
Step 402, gopher generating indexes file.
Step 402, obtains Search Results according to search keyword.
Step 402, result treatment apparatus processes result.
Step 402, obtains processing result information.
Wherein, by after the amendment of concrete inquiry Report Form Design, when carrying out persistence, by calling the service interface of timing, the analysis data directory that form quotes can be realized and refresh in real time, improving the real-time of Search Results.
Figure 5 shows that the keyword search device realized in actual products, it is divided into two regions: input frame is keyword input area above; Form is Search Results return area below.
Such as, input keyword " assets " in the search box, perform " retrieval " afterwards:
Gopher can carry out Chinese word segmentation to the keyword of input, according to the result after participle, retrieves index, returns results, comprising the coding of form, and title, and match information; According to returning results, by result constructor, getting the catalogue at form place, the information such as form major key, simultaneously for report name item, adding the hyperlink of corresponding true form; Result after constructor process is represented in Search Results return area; Click corresponding report name and then directly open corresponding form, the keyword message simultaneously highlighted display form mated.
In sum, by the present invention, first by filtering section, significantly can reduce the scope of the data that are retrieved, then carrying out data retrieval at the search key inputted according to user, effectively improve recall precision; By calling search function, the real-time refreshing of retrieve data can be realized, improve the accuracy of retrieval; In addition, by the index of gopher for keyword, the data retrieval across form is achieved; Propose based on cube in OLAP system, asynchronous schedule, calculate according to data slicer and produce retrieve data, key word index is generated by search engine, there is provided Query Result processor, the customization realizing Search Results represents, and then the query and search application demand of Realization analysis data.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (6)
1. a data query retrieval process device, is characterized in that, comprising:
Data acquisition module, obtains the section of the corresponding data cube of external data table;
Data filtering module, by predetermined filtering item, carries out filtration to described section and obtains the data that are retrieved;
Index generation module is the described data genaration index information that is retrieved;
Retrieval process module, receive the search key of user, and obtain the first index information mated with described search key, and be retrieved data as result for retrieval using corresponding with described first index information first, be presented to described user, the described data that are retrieved have one or more tables of data attribute, and the value of the one or more tables of data attribute in described result for retrieval is linked to corresponding tables of data by described retrieval process module;
Wherein, described index generation module uses the research tool of specifying, and carries out participle dissection process, to generate described index information to the described data that are retrieved.
2. data query retrieval process device according to claim 1, is characterized in that, described retrieval process module also arranges ways of presentation, and represents described result for retrieval by described ways of presentation.
3. data query retrieval process device according to claim 2, it is characterized in that, described retrieval process module also inquires about the related content of described result for retrieval, and is presented to described user.
4. a data query search processing method, is characterized in that, comprising:
Step 202, obtains the section of the corresponding data cube of external data table;
Step 204, by predetermined filtering item, carries out filtration to described section and obtains the data that are retrieved;
Step 206 is the described data genaration index information that is retrieved;
Step 208, receives the search key of user, and obtains the first index information mated with described search key, and is retrieved data as result for retrieval using corresponding with described first index information first, is presented to described user;
The described data that are retrieved have one or more tables of data attribute, the value of the one or more tables of data attribute in described result for retrieval are linked to corresponding tables of data;
Wherein, described step 206 comprises:
Use the research tool of specifying, participle dissection process is carried out, to generate described index information to the described data that are retrieved.
5. data query search processing method according to claim 4, is characterized in that, described step 208 also comprises:
Ways of presentation is set, and represents described result for retrieval by described ways of presentation.
6. data query search processing method according to claim 5, is characterized in that, described step 208 also comprises:
Also inquire about the related content of described result for retrieval, and be presented to described user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210225062.3A CN102789487B (en) | 2012-06-29 | 2012-06-29 | Data query retrieval process device and data query search processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210225062.3A CN102789487B (en) | 2012-06-29 | 2012-06-29 | Data query retrieval process device and data query search processing method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102789487A CN102789487A (en) | 2012-11-21 |
| CN102789487B true CN102789487B (en) | 2015-09-02 |
Family
ID=47154890
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210225062.3A Active CN102789487B (en) | 2012-06-29 | 2012-06-29 | Data query retrieval process device and data query search processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102789487B (en) |
Families Citing this family (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064933B (en) * | 2012-12-24 | 2016-06-29 | 华为技术有限公司 | Data query method and system |
| CN104077302B (en) * | 2013-03-28 | 2017-07-25 | 中国银联股份有限公司 | A kind of large user's amount account storage and retrieval and Verification System |
| DE102014224208A1 (en) * | 2014-11-27 | 2016-06-02 | Robert Bosch Gmbh | Method and device for controlling at least one data retrieval from a control device of a vehicle and method and device for retrieving data from a control device of a vehicle |
| CN105812430B (en) * | 2014-12-31 | 2019-12-13 | 金蝶软件（中国）有限公司 | Intelligent query method for mobile terminal, mobile terminal and server |
| CN105512309A (en) * | 2015-12-11 | 2016-04-20 | 广州精点计算机科技有限公司 | Report search method and report search device |
| CN107273468B (en) * | 2017-06-06 | 2018-08-03 | 腾讯科技（深圳）有限公司 | A kind of database data processing method, device and terminal |
| CN107291938B (en) * | 2017-07-06 | 2020-04-07 | 携程旅游网络技术（上海）有限公司 | Order inquiry system and method |
| CN110837545A (en) * | 2019-11-13 | 2020-02-25 | 贵州医渡云技术有限公司 | Interactive data analysis method, device, medium and electronic equipment |
| CN114023076B (en) * | 2021-10-22 | 2022-10-04 | 北京商海文天科技发展有限公司 | Specific vehicle tracking method based on multi-source heterogeneous data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101908063A (en) * | 2010-07-20 | 2010-12-08 | 浪潮齐鲁软件产业有限公司 | Universal report query tool |
| CN102262640A (en) * | 2010-05-31 | 2011-11-30 | 中国移动通信集团贵州有限公司 | Method and device for full-text retrieval of document database |
| CN102306176A (en) * | 2011-08-25 | 2012-01-04 | 浙江鸿程计算机系统有限公司 | On-line analytical processing (OLAP) keyword query method based on intrinsic characteristic of data warehouse |
-
2012
- 2012-06-29 CN CN201210225062.3A patent/CN102789487B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102262640A (en) * | 2010-05-31 | 2011-11-30 | 中国移动通信集团贵州有限公司 | Method and device for full-text retrieval of document database |
| CN101908063A (en) * | 2010-07-20 | 2010-12-08 | 浪潮齐鲁软件产业有限公司 | Universal report query tool |
| CN102306176A (en) * | 2011-08-25 | 2012-01-04 | 浙江鸿程计算机系统有限公司 | On-line analytical processing (OLAP) keyword query method based on intrinsic characteristic of data warehouse |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102789487A (en) | 2012-11-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102789487B (en) | Data query retrieval process device and data query search processing method | |
| US7136467B2 (en) | Customer-oriented telecommunications data aggregation and analysis method and object oriented system | |
| US7630956B2 (en) | System and method for analyzing and reporting extensible data from multiple sources in multiple formats | |
| US9824127B2 (en) | Systems and methods for interest-driven data visualization systems utilized in interest-driven business intelligence systems | |
| CN110955717A (en) | Visual dynamic display method and system based on big data | |
| US20070260582A1 (en) | Method and System for Visual Query Construction and Representation | |
| US9152998B2 (en) | Investor relations systems and methods | |
| WO2014047681A1 (en) | System and method for processing digital traffic metrics | |
| MXPA06000331A (en) | Diagrammatic access and arrangement of data. | |
| CN103177068A (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| US9633077B2 (en) | Query of multiple unjoined views | |
| CN104317936A (en) | ROLAP (relational on-line analysis processing) analysis engine design method and device on basis of star models | |
| CN115344639A (en) | Panoramic analysis method and device for regional enterprises, computer equipment and medium | |
| CN117056308A (en) | Method for generating financial big data blood-edge relation based on OpenLinear database | |
| CN112634004A (en) | Blood margin map analysis method and system for credit investigation data | |
| US10203841B2 (en) | In place creation of objects | |
| US11461337B2 (en) | Attribute annotation for relevance to investigative query response | |
| CN101470602A (en) | Software development method depending on relational database | |
| US9489438B2 (en) | Systems and methods for visualizing master data services information | |
| CN104408184A (en) | Two-dimensional visual data display method and device based on data cubes | |
| CN108875008A (en) | A kind of Large Volume Data analysis method and device | |
| Kazi et al. | MOLAP data warehouse of a software products servicing Call center | |
| Lin et al. | OREO: Detection of cherry-picked generalizations | |
| Klauck et al. | Interactive, flexible, and generic what-if analyses using in-memory column stores | |
| WO2015178778A1 (en) | Method and system for providing personalized intelligent content data base and a personalized graphical user interface, gui |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP03 | Change of name, title or address |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Patentee after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Patentee before: UFIDA Software Co., Ltd. |