CN102253967B - Data searching system and data searching method - Google Patents
Data searching system and data searching method Download PDFInfo
- Publication number
- CN102253967B CN102253967B CN 201110149691 CN201110149691A CN102253967B CN 102253967 B CN102253967 B CN 102253967B CN 201110149691 CN201110149691 CN 201110149691 CN 201110149691 A CN201110149691 A CN 201110149691A CN 102253967 B CN102253967 B CN 102253967B
- Authority
- CN
- China
- Prior art keywords
- data
- query
- type
- order
- path
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data searching system, which comprises a single order basic relationship preset module, a query path generation module, a data path selection module and a data list display module, wherein the single order basic relationship preset module is used for presetting a single order data direct association relationship and a corresponding relationship list of data types, data type query data sources and data type names; the query path generation module is used for recursively generating single-order and full-order query paths according to the single order data direct association relationship; the data path selection module is used for receiving the selected current data types, searching data types associated with the current data types from the single-order and full-order query paths and receiving the selected query data types; and the data list display module is used for searching query paths from the single-order and full-order query paths according to the current data types and the selected query data types, determining key words of the query data types and searching data matched with the key words from the corresponding relationship list. The invention also provides a data searching method. Any data in the full-order paths serves as an entry point, and all associated data can be searched.
Description
Technical field
The present invention relates to computer technology, in particular to data searching system and data search method.
Background technology
In computer application system, need a large amount of data of manual entry.After a series of data are finished in user's typing, need to search and the related total data of these data according to certain data point of penetration, for example, when data are document, during take purchase order as point of penetration, search the whole documents related with purchase order:
1, purchase order derives from purchase requisition;
2, purchase requisition derives from the production order;
3, purchase order has partly generated manifest, and part directly generates storage bill;
4, generated storage bill to manifest.
The user is take purchase order as the inquiry point of penetration, need to search the source the production order, please purchase order and downstream document to the manifest storage bill.
In correlation technique, all be to adopt the mode of hard coded or structure fixed data upstream and downstream relation to realize above-mentioned service logic, this mode has following distinct disadvantage:
1, service logic is solidificated in the program code, and inconvenience is changed;
2, increase new business association relation and need in source code, increase new code;
3, search step by step associated data, cause frequent operation.
Afterwards, the fixedly method of document upstream and downstream correlation logic of general structure had appearred:
The first step is pre-created fixing data-mapping relation according to the type of data;
Second step is according to the part upstream and downstream data of the mapping of the mapping relationship searching between the data;
In the 3rd step, divide tab sequencing display data by data type.
But said method still has following defective:
1, can only realize multistage and can not realize the data joint investigation on full rank, can't satisfy the requirement of the full rank joint investigation of user data.Full rank joint investigation gets final product joint investigation and a kind of data type exists the cross-system of incidence relation, cross-module total data type.
2, the mapping relations logic is fixed, not easy care.
3, the ways of presentation of multipage label also can cause opening tab and too much is difficult for checking when flow process is complicated.
4, can not select, the data type of the demonstration mapping of just fixing in the time will inquiring about a kind of data type does not allow user selection to show.
The flow process of enterprise is changeable, can not be exhaustive, and it has very strong professional, region and user personality, so, in the urgent need to a kind of data search technology, unify to address the above problem, and be guaranteed in dirigibility, extendability, execution efficient.
Summary of the invention
Technical matters to be solved by this invention is, a kind of data searching system and data search method are provided, and can take the arbitrary data in the path, full rank as point of penetration, find all related with it on path data.
A kind of data searching system is provided, can have comprised: single-order primary relationship preset module, for the mapping table that presets single-order data direct correlation relation and data type and data type data query source and data type title; The query path generation module, for direct correlation concerns the query path of recursive generation single-order and full rank query path according to described single-order data, wherein, described single-order query path is the path of the direct correlation relation that exists between the described data, and described full rank query path is the path of the cross-system that exists between the described data or cross-module incidence relation; Data routing is selected module, be used for receiving the current data type as source data type of selecting, from described single-order query path and described full rank query path, find out the data type with described current data type association, receive the data query type of selecting; And data list display module, be used for finding out query path according to the described data query type of described current data type and selection in described single-order query path and described full rank query path, determine the key word of described data query type according to described query path, from the mapping table of described data type and data type data query source and data type title, find the data of the described key word of coupling, show the tabulation of the described data that find.
In technique scheme, preferably, described query path generation module can comprise: selected cell is used for system's submodule that generation pass is wanted in selection; Generation unit is used for generating described single-order query path and generating described full rank query path according to the described single-order data direct correlation relation that presets according to the described single-order data direct correlation relation that presets; And storage unit, be used for described single-order query path and described full rank query path are stored in database.
In technique scheme, preferably, can also comprise: the general routes memory module, for the described data query type of the described current data type of preserving each operator who operates, corresponding selection and corresponding selection and with the commonly used data query type of described data query type as described operator.
In technique scheme, preferably, described data routing is selected module according to described current data type and described operator finds corresponding data query type described commonly used by described general routes memory module and with its described data query type of selecting by default; The data type that described data routing is selected the described association that module also will find out is according to the demonstration of classifying of the described system submodule of correspondence and corresponding described data type.
In technique scheme, preferably, can also comprise: the data content display module, be used for selecting to check one of them data in the tabulation of the described data that find, show the details of described one of them data.
Correspondingly, also provide a kind of data search method, having comprised: step 202, single-order primary relationship preset module preset the mapping table of single-order data direct correlation relation and data type and data type data query source and data type title; Step 204, direct correlation concerns the query path of recursive generation single-order and full rank query path to the query path generation module according to described single-order data, wherein, described single-order query path is the path of the direct correlation relation that exists between the described data, and described full rank query path is the path of the cross-system that exists between the described data or cross-module incidence relation; Step 206, data routing selects module to receive the current data type as source data type of selecting, from described single-order query path and described full rank query path, find out the data type with described current data type association, receive the data query type of selecting; Step 208, the data list display module finds out query path according to the described data query type of described current data type and selection in described single-order query path and described full rank query path, determine the key word of described data query type according to described query path, from the mapping table of described data type and data type data query source and data type title, find the data of the described key word of coupling, show the tabulation of the described data that find.
In technique scheme, preferably, described step 204 can comprise: step 2042, and system's submodule of generation pass is wanted in selection; Step 2044 generates described single-order query path according to the described single-order data direct correlation relation that presets; Step 2046 generates described full rank query path according to the described single-order data direct correlation relation that presets; Step 2048 is stored in described single-order query path and described full rank query path in the database.
In technique scheme, preferably, can also comprise: the general routes memory module is preserved the described data query type of the described current data type of operator, corresponding selection of each operation and corresponding selection and with the commonly used data query type of described data query type as described operator.
In technique scheme, preferably, described data routing is selected module according to described current data type and described operator finds corresponding data query type described commonly used by described general routes memory module and with its described data query type of selecting by default; The data type that described data routing is selected the described association that module also will find out is according to the demonstration of classifying of the described system submodule of correspondence and corresponding described data type.
In technique scheme, preferably, can also comprise: select to check one of them data in the tabulation of the described data that find, the data content display module shows the details of described one of them data.
Description of drawings
Fig. 1 shows the according to an embodiment of the invention block diagram of data searching system;
Fig. 2 shows the according to an embodiment of the invention process flow diagram of data search method;
Fig. 3 shows the according to an embodiment of the invention synoptic diagram of document seeking system;
Fig. 4 shows the according to an embodiment of the invention lookup result synoptic diagram of document path selection unit; And
Fig. 5 shows according to an embodiment of the invention, and the data list of data list display unit shows synoptic diagram.
Embodiment
In order more clearly to 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 in the following description a lot of details so that fully understand the present invention, still, 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.
Fig. 1 shows the according to an embodiment of the invention block diagram of data searching system.
As shown in Figure 1, data searching system 100 can comprise according to an embodiment of the invention: single-order primary relationship preset module 102, for the mapping table that presets single-order data direct correlation relation and data type and data type data query source and data type title; Query path generation module 104, be used for concerning the query path of recursive generation single-order and full rank query path according to the described single-order data direct correlation that described single-order primary relationship preset module 102 presets, wherein, described single-order query path is the path of the direct correlation relation that exists between the described data, and described full rank query path is the path of the cross-system that exists between the described data or cross-module incidence relation; Data routing is selected module 106, be used for receiving the current data type as source data type (data search point of penetration) of selecting, find out the data type with described current data type association the described single-order query path that generates from described query path generation module 104 and the described full rank query path, receive the data query type (or data query type commonly used of acquiescence) of selecting; And data list display module 108, be used for finding out query path according to the described data query type of described current data type and selection in described single-order query path and the described full rank query path that described query path generation module 104 generates, determine the key word of described data query type according to described query path, find the data of the described key word of coupling in the described data type that from described document primary relationship preset module 102, presets and the mapping table of data type data query source and data type title, show the tabulation of the described data that find.After single-order primary relationship preset module had preset single-order data direct correlation relation, the full rank relation path between can automatically generated data can with the arbitrary data in the path as point of penetration, find all data that are associated with the data of this point of penetration.In the situation that does not change the legacy data structure, solve the disposal route of different incidence relations.
In technique scheme, preferably, described query path generation module 104 can comprise: selected cell 1042 is used for system's submodule that generation pass is wanted in selection; Generation unit 1044 is used for generating described single-order query path and generating described full rank query path according to the described single-order data direct correlation relation that presets according to the described single-order data direct correlation relation that presets; And storage unit 1046, be used for described single-order query path and described full rank query path are stored in database.
In technique scheme, preferably, can also comprise: general routes memory module 110, for the described data query type of the described current data type of preserving each operator who operates, corresponding selection and corresponding selection and with the commonly used data query type of described data query type as described operator.Like this, can preserve each operator's data query type commonly used, input fast data query type commonly used for the operator.
In technique scheme, preferably, described data routing is selected module 106 according to described current data type and described operator finds corresponding data query type described commonly used by described general routes memory module 110 and with its described data query type of selecting by default; The data type that described data routing is selected the described association that module 106 also will find out is according to the demonstration of classifying of the described system submodule of correspondence and corresponding described data type.Press the system module partition level, represent with tree structure, easy-to-use more flexibly.
In technique scheme, preferably, can also comprise: data content display module 112, be used for selecting to check one of them data in the tabulation of the described data that find, show the details of described one of them data.
Fig. 2 shows the according to an embodiment of the invention process flow diagram of data search method.
As shown in Figure 2, data search method can comprise according to an embodiment of the invention: step 202, single-order primary relationship preset module preset the mapping table of single-order data direct correlation relation and data type and data type data query source and data type title; Step 204, direct correlation concerns the query path of recursive generation single-order and full rank query path to the query path generation module according to described single-order data, wherein, described single-order query path is the path of the direct correlation relation that exists between the described data, and described full rank query path is the path of the cross-system that exists between the described data or cross-module incidence relation; Step 206, data routing selects module to receive the current data type as source data type of selecting, from described single-order query path and described full rank query path, find out the data type with described current data type association, receive the data query type of selecting; Step 208, the data list display module finds out query path according to the described data query type of described current data type and selection in described single-order query path and described full rank query path, determine the key word of described data query type according to described query path, from the mapping table of described data type and data type data query source and data type title, find the data of the described key word of coupling, show the tabulation of the described data that find.
In technique scheme, preferably, described step 204 can comprise: step 2042, and system's submodule of generation pass is wanted in selection; Step 2044 generates described single-order query path according to the described single-order data direct correlation relation that presets; Step 2046 generates described full rank query path according to the described single-order data direct correlation relation that presets; Step 2048 is stored in described single-order query path and described full rank query path in the database.
In technique scheme, preferably, can also comprise: the general routes memory module is preserved the described data query type of the described current data type of operator, corresponding selection of each operation and corresponding selection and with the commonly used data query type of described data query type as described operator.
In technique scheme, preferably, described data routing is selected module according to described current data type and described operator finds corresponding data query type described commonly used by described general routes memory module and with its described data query type of selecting by default; The data type that described data routing is selected the described association that module also will find out is according to the demonstration of classifying of the described system submodule of correspondence and corresponding described data type.
In technique scheme, preferably, can also comprise: select to check one of them data in the tabulation of the described data that find, the data content display module shows the details of described one of them data.
Pass through technique scheme, can the arbitrary data from the path be point of penetration, find all data that are associated with the data of this point of penetration, can increase neatly and revise correlation logic, search by operator's maintenance and expanding data, to improve data search efficient.
At this, should be appreciated that, can describe with the data that document is searched as data searching system, so just consisted of the document seeking system, except can be with document as the data of searching, the data that electric weight in can also electric system is searched as data searching system, because the electric weight of electric system also has source and the whereabouts of upstream and downstream incidence relation and electric weight, also can search other electric weight related with it as point of penetration with the electric weight of certain target location, certainly the effect of these electric weight may be different, and therefore type difference is also arranged.
Fig. 3 shows the according to an embodiment of the invention synoptic diagram of document seeking system.
As shown in Figure 3, the document seeking system of another embodiment of the present invention comprises single-order primary relationship preset unit 302 (for example single-order primary relationship preset module among Fig. 2), query path generation unit 304 (for example query path generation module among Fig. 2), document path selection unit 308 (for example the data routing among Fig. 2 is selected module), data list display unit 310 (for example data list display module among Fig. 2), bills data display unit 312 (for example data content display module among Fig. 2) and general routes storage unit 314 (for example general routes memory module among Fig. 2), the below specifically describes with the principle of document as the document seeking system of data object.
1, single-order primary relationship preset unit 302
Direct upstream and downstream relation according to document presets single-order document direct correlation relation, and the corresponding relation of document types and document types data query source, document types title in the pre-set path table.
For example, the direct upstream and downstream relation of document:
Purchase order (A) → buying is to manifest (B) → buying storage bill (C)
Buying is to single (the D) → quality control pickup (E) of manifest (B) → quality inspection declaration → buying storage bill (C).
According to the direct upstream and downstream relation of above-mentioned document, in single-order primary relationship preset unit 302, preset A ← → B B ← → C B ← → D D ← → E E ← → the single-order document direct correlation relation (single-order primary relationship) of C.
The single-order primary relationship of single-order primary relationship preset unit need to store, and can adopt the form of xml file or database table to record the single-order primary relationship, and the data structure of its record (being labeled as data structure 1) is as shown in table 1 below:
Table 1
Therefore, closing with the direct upstream and downstream of top document is that example explanation single-order document direct correlation relation (being labeled as tables of data 1) can preset as shown in table 2 below:
Table 2
And the data structure (being labeled as data structure 2) of the corresponding relation of document types and document types data query source, document types title is as shown in table 3 below in the routing table:
Table 3
Therefore, the mapping table (being labeled as tables of data 2) of document types and document types data query source, document types title can preset as shown in table 4 below:
Table 4
2, the query path generation unit 304
The Output rusults of query path generation unit 304 is single-order query path and the full rank query path metadata that concern recursive generation according to prefabricated single-order document direct correlation in single-order primary relationship preset unit 302, this metadata is descriptive, can use the xml form to be stored in the database.The single-order relation is the relation that has direct correlation between a kind of document types and another document types, is the least unit of document incidence relation.Full rank relation is the cross-system of a kind of document types and the existence of other document types, cross-module incidence relation.
The query path generation unit generates single-order query path and full rank query path with 4 steps:
At first, select to want system's submodule of generation pass, for example PU (purchasing management), ST (stock control).
Secondly, generate the simple queries path, the single-order query path of the isinglenik=1 in the generated data table 1, it can be stored in the cpatch field in the tables of data 1 with the xml form.
Then, generate the multilevel query path, multistage associated record and the query path of isinglenik=0 in generated data table 1 table, it can be stored in the cpatch field in the tables of data 1 with the xml form.
At last, derive all executable scripts of generation database of record, behind the execution script all routing informations (single-order query path, full rank query path) are stored in the tables of data 1, when searching the path for document path selection unit 308.
Wherein, the structure of the xml form of path data explanation:
＜!--csource source document clink inquiring document--〉
＜!--linktbl inquiring document linktblkey source document key word getkey purpose document key word deffilter gives tacit consent to filtercondition--〉
＜path csource=" source document types " clink=" target document types " 〉
＜linkpath linktbl=" source document " sourcekey=" the single key word in source " linktblkey=" the source document key word that records in the target document " getkey=" target document key word " deffilter=" "/〉
</path>
It is example that continuation is closed with the single-order document direct correlation of presetting, then by query path generation unit 304 generate single-order query path A ← → B B ← → C B ← → D B ← → E, and by query path generation unit 304 generate full rank query path A ← → B ← → C ← → D ← → E.
The data structure of the single-order query path that generates so is as shown in table 5 below:
Table 5
The data structure of the full rank query path that generates is as shown in table 6 below:
Table 6
Query path generation unit 304 with the document single-order path that generates and full rank path data for example the full rank path data of the document path data of table 5 expression and for example table 6 expression be stored among Fig. 3 document single-order path and entirely in path data 306 (databases) of rank.
3, the document path selection unit 308
Document path selection unit 308 is responsible for searching the single-order path of current document types, full path, rank (xml form) from database (document single-order path and full rank path data 306), and single-order path, full path, rank press system module and the demonstration of document types classification and ordination, call again general routes storage unit 314, read current operation person's inquiring document type commonly used, and in display interface, automatically choose this inquiring document type commonly used.This unit further storage current operation person's inquiring document type is as this operator's inquiring document type commonly used.
Or closing with the single-order document direct correlation of presetting is the principle of work that example illustrates document path selection unit 308:
Such as the point of penetration of searching as full rank take the B document types, then document path selection unit 308 is the associated invoice type take the B document types as the source document types in the search database (document single-order path and full rank path data 306),
Perform statement: select * from scmvouchrelation where csourcedetailtbl=' B '
Then find out the document types that is associated with the B document types A, C, D, E are arranged, find document types and document types data query source, document types title corresponding relation according to tables of data 2 and determine that title and the sub-module of system's submodule and document types shows with tree structure under A, C, D, E are respectively, as shown in Figure 2, purchasing management, quality management etc. are system module, purchase order, the single equipotential document types of buying inspection declaration title.
4, the general routes storage unit 314
General routes storage unit 314, the metadata store of the options of the inquiring document that the operator is commonly used is database for example in the general routes data 316 shown in Fig. 3 (be about to inquiring document type that the operator selects as inquiring document type stores commonly used in database), quick in order to what provide the operator to search, can input fast inquiring document type commonly used.The form of these metadata also can for the xml form, be stored in the database.
The data structure of inquiring document type commonly used is as shown in table 7 below:
Table 7
That is to say, the operator that general routes storage unit 314 can be preserved each operation with and the document types of the correspondence inquiry point of penetration selected in general routes data 316, with this document types as inquiring document type commonly used, later on when this operator inquires about again, the inquiring document type information commonly used of correspondence can be offered this operator, namely as shown in Figure 3, from the general routes data, export the inquiring document type information commonly used of correspondence to document path selection unit 308.
This xml form is as follows:
＜menuname cpersoncode=" operator's key word " csourcetbl=" source document types " 〉
＜linktbl linktbl=" document types 1 commonly used "/〉
＜linktbl linktbl=" document types 2 commonly used "/〉
＜linktbl linktbl=" document types 3 commonly used "/〉
</menuname>
Query statement is:
Select clinktblpath from Scm VouchRelMenu where cpersoncode=' operator key word ' and csourcetbl=' source document types '
Carry out the xml information for the document types commonly used of inquiring about that query statement can find storage, in program, resolve this xml information by certain logical calculated, return to document path selection unit 308, document path selection unit 308 can be chosen the document types commonly used that general routes storage unit 314 is returned automatically when display interface.
Closing with the single-order data direct correlation of presetting above is the principle of work that example further specifies general routes storage unit 314:
As: the search point of penetration of operator demo take document types B as the query path of full rank, then in the document path selection unit 308 with in the search database take the data of document types B as the source document, finding out the document types that is associated with document types B has A, C, D, E.
General routes storage unit 314 realizes searching of general routes by carrying out following query statement, searches according to operator and document types B:
Select?clinktblpath?from?scmvouchrelation
where?cpersoncode＝′demo′and?csourcedetailtbl＝′B′
Find the result of following form
<menuname?cpersoncode＝″demo″csourcetbl＝″B″>
<lmktbl?linktbl＝″A″/>
<linktbl?linktbl＝″C″/>
</menuname>
Automatically choose by default inquiring document type of A, C when then document path selection unit 308 shows.
5, the data list display unit 310
The inquiring document type that data list display unit 310 is selected according to document path selection unit 308 circulates, find out the query path that this inquiring document type generates in the query path generation unit 304, progressively find the key word of the inquiring document type of selection according to the key message in the query path, in the document types respective view that the employing query statement presets, inquire the document of this key word of coupling from data structure 2 (as shown in table 3).
The bills data record that satisfies querying condition is shown for user selection by the tabulation mode, and as shown in Figure 5, that finds is recorded as 5, double-clicks the tabulation row and calls bills data display unit 312, checks the details of corresponding document.
Or closing with the single-order document direct correlation of presetting in the preset unit 302 of pass, single-order basis is the concrete principle that example further specifies the data list display unit.
For example: operator demo is take the point of penetration of B as full rank path searching, then in the document path selection unit 308 with in the search database (document single-order path and full rank path data 306) take the data of document types B as the source document, find out document types A, the C, D, the E that are associated with document types B, inquire commonly used document types A, C according to general routes storage unit 314, and will commonly use document types A, C and export the inquiring document type that document path selection unit 308 is selected by default to.
What inquire from document single-order path and full rank path data by B to the single-order path that makes progress of A is:
Search as follows according to the clue that records on the path so:
The key word of the document types A that stores in the inquiring document type B is assumed to be 1, then the view that presets according to tables of data 2 (as shown in table 4), as use the A DSV, find the record that satisfies A key word=1, the document of the document types A that this record will be inquired about exactly is inserted into the result in the temporary table.
What inquire from document single-order path and full rank path data by B to downward a single-order path and a multistage path of C is again:
The single-order path:
Search as follows according to the clue that records on this single-order path so:
The key word of the B that stores in the inquiring document Type C is assumed to be 1, then the view that presets according to tables of data 2 (as shown in table 4), for example use the C DSV, find the record of the key word that satisfies B among the C=1, the document of the document types C that this record will be inquired about exactly is inserted into the result in the temporary table.
Multistage path:
Search as follows according to the clue that records on this multistage path:
The B key word of storing among the inquiring document type D is assumed to be 1, then the view that presets according to tables of data 2 (as shown in table 4), for example use the D DSV, find the record of the key word that satisfies B among the D=1, the key word that inquires document types D is 2.
Again the D key word of storing among the inquiring document type E is assumed to be 2, then the view that presets according to tables of data 2 (as shown in table 4), for example use the E DSV, find the record of the key word that satisfies D among the E=2, the key word that inquires document types E is 3.
At last the E key word of storing in the inquiring document Type C is assumed to be 3, then the view that presets according to tables of data 2 (as shown in table 4), for example use the C DSV, find the record of the key word that satisfies E among the C=3, this record is exactly the bills data of final inquiring document Type C, and Query Result is inserted in the temporary table.
The data that read in the temporary table show at the interface of data list display unit 310 in the mode of tabulating, and finish the searching relevant document types C and document types A take document types B as point of penetration.
6, the bills data display unit 312
The user double-clicks the table data row of selecting and just calls bills data display unit 312 behind the document that data list display unit 310 is selected to check, open corresponding document according to document types and keyword message that the table data row provides, check the details of corresponding document.
Below by reference to the accompanying drawings the technical scheme of embodiments of the invention is had been described in detail, in application system, generate downstream data by upstream data, exist certain contact between this data, when in user's opening system during a certain data, might check source and the whereabouts of current data.Technical scheme of the present invention is applicable to the application scenarios that needs the full rank of data to search in the various application systems.Be applicable to especially following scene: the correlation inquiry of data upstream and downstream relation is processed in the product development; Self-defining data correlation relation in the client development.Therefore, technical scheme of the present invention has the following advantages:
1, can increase neatly and revise correlation logic;
2, after presetting single-order data direct correlation relation, the full rank relation between the automatically generated data;
3, the arbitrary data from path, full rank is point of penetration, can find all data on the path;
4, find a kind of the change under the legacy data structure situation, solve different incidence relation disposal routes;
5, press the system module partition level, represent with tree-shaped, easy-to-use more flexibly;
6, can preserve by the operator and expanding data is searched configuration, to improve data search efficient.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and 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 modification of doing, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a data searching system is characterized in that, comprising:
Single-order primary relationship preset module is for the mapping table that presets single-order data direct correlation relation and data type and data type data query source and data type title;
The query path generation module, for direct correlation concerns the query path of recursive generation single-order and full rank query path according to described single-order data, wherein, described single-order query path is the path of the direct correlation relation that exists between the data, and described full rank query path is the path of the cross-system that exists between the described data or cross-module incidence relation;
Data routing is selected module, be used for receiving the current data type as source data type of selecting, from described single-order query path and described full rank query path, find out the data type with described current data type association, receive the data query type of selecting; And
The data list display module, be used for finding out query path according to the described data query type of described current data type and selection in described single-order query path and described full rank query path, determine the key word of described data query type according to described query path, from the mapping table of described data type and data type data query source and data type title, find the data of the described key word of coupling, show the tabulation of the described data that find.
2. data searching system according to claim 1 is characterized in that, described query path generation module comprises:
Selected cell is used for system's submodule that generation pass is wanted in selection;
Generation unit is used for concerning the described single-order query path of recursive generation and concerning the described full rank query path of recursive generation according to the described single-order data direct correlation of presetting according to the described single-order data direct correlation of presetting; And
Storage unit is used for described single-order query path and described full rank query path are stored in database.
3. data searching system according to claim 2 is characterized in that, also comprises:
The general routes memory module is for the described data query type of the described current data type of preserving each operator who operates, corresponding selection and corresponding selection and with the commonly used data query type of described data query type as described operator.
4. data searching system according to claim 3, it is characterized in that described data routing selects module according to described current data type and described operator finds corresponding data query type described commonly used by described general routes memory module and with its described data query type of selecting by default;
The data type that described data routing is selected the described association that module also will find out is according to the demonstration of classifying of the described system submodule of correspondence and corresponding data type title.
5. each described data searching system in 4 according to claim 1 is characterized in that, also comprises:
The data content display module is used for selecting to check one of them data in the tabulation of the described data that find, and shows the details of described one of them data.
6. a data search method is characterized in that, comprising:
Step 202, single-order primary relationship preset module preset the mapping table of single-order data direct correlation relation and data type and data type data query source and data type title;
Step 204, direct correlation concerns the query path of recursive generation single-order and full rank query path to the query path generation module according to described single-order data, wherein, described single-order query path is the path of the direct correlation relation that exists between the data, and described full rank query path is the path of the cross-system that exists between the described data or cross-module incidence relation;
Step 206, data routing selects module to receive the current data type as source data type of selecting, from described single-order query path and described full rank query path, find out the data type with described current data type association, receive the data query type of selecting;
Step 208, the data list display module finds out query path according to the described data query type of described current data type and selection in described single-order query path and described full rank query path, determine the key word of described data query type according to described query path, from the mapping table of described data type and data type data query source and data type title, find the data of the described key word of coupling, show the tabulation of the described data that find.
7. data search method according to claim 6 is characterized in that, described step 204 comprises:
Step 2042, system's submodule of generation pass is wanted in selection;
Step 2044 concerns the described single-order query path of recursive generation according to the described single-order data direct correlation of presetting;
Step 2046 concerns the described full rank query path of recursive generation according to the described single-order data direct correlation of presetting;
Step 2048 is stored in described single-order query path and described full rank query path in the database.
8. data search method according to claim 7, it is characterized in that, also comprise: the general routes memory module is preserved the described data query type of the described current data type of operator, corresponding selection of each operation and corresponding selection and with the commonly used data query type of described data query type as described operator.
9. data search method according to claim 8, it is characterized in that described data routing selects module according to described current data type and described operator finds corresponding data query type described commonly used by described general routes memory module and with its described data query type of selecting by default;
The data type that described data routing is selected the described association that module also will find out is according to the demonstration of classifying of the described system submodule of correspondence and corresponding data type title.
10. each described data search method in 9 according to claim 6, it is characterized in that, also comprise: select to check one of them data in the tabulation of the described data that find, the data content display module shows the details of described one of them data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110149691 CN102253967B (en) | 2011-06-03 | 2011-06-03 | Data searching system and data searching method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110149691 CN102253967B (en) | 2011-06-03 | 2011-06-03 | Data searching system and data searching method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102253967A CN102253967A (en) | 2011-11-23 |
| CN102253967B true CN102253967B (en) | 2013-03-27 |
Family
ID=44981231
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110149691 Active CN102253967B (en) | 2011-06-03 | 2011-06-03 | Data searching system and data searching method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102253967B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103488655B (en) * | 2012-06-13 | 2017-05-10 | 阿里巴巴集团控股有限公司 | Method and system for processing composite model data |
| CN103150400B (en) * | 2013-03-27 | 2017-06-06 | 领航动力信息系统有限公司 | A kind of data screening method based on MapReduce frameworks |
| CN104243089A (en) * | 2013-06-19 | 2014-12-24 | 深圳富泰宏精密工业有限公司 | System and method for dynamically adjusting data transmission rate |
| CN105787112A (en) * | 2016-03-24 | 2016-07-20 | 浪潮通信信息系统有限公司 | Data presentation method and device |
| CN110110184B (en) * | 2017-12-21 | 2021-07-06 | 北京京东尚科信息技术有限公司 | Information inquiry method, system, computer system and storage medium |
| CN108205593A (en) * | 2017-12-29 | 2018-06-26 | 华为技术有限公司 | A kind of method and device of inquiry |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1648903A (en) * | 2004-01-26 | 2005-08-03 | 微软公司 | Automatic query clustering |
| CN1841379A (en) * | 2005-03-28 | 2006-10-04 | 微软公司 | Mapping of a file system model to a database object |
| CN1846207A (en) * | 2003-10-23 | 2006-10-11 | 微软公司 | Type path indexing |
-
2011
- 2011-06-03 CN CN 201110149691 patent/CN102253967B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1846207A (en) * | 2003-10-23 | 2006-10-11 | 微软公司 | Type path indexing |
| CN1648903A (en) * | 2004-01-26 | 2005-08-03 | 微软公司 | Automatic query clustering |
| CN1841379A (en) * | 2005-03-28 | 2006-10-04 | 微软公司 | Mapping of a file system model to a database object |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102253967A (en) | 2011-11-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102253967B (en) | Data searching system and data searching method | |
| CN102722372B (en) | Method and system for automatically generating codes through classification and configuration | |
| RU2427896C2 (en) | Annotation of documents in jointly operating applications by data in separated information systems | |
| CN101681377B (en) | User-defined relevance ranking for search | |
| CN109522480B (en) | Information recommendation method and device, electronic equipment and storage medium | |
| EP1465062A2 (en) | Dynamically generated user interface for business application integration | |
| RU2614933C2 (en) | Method and device for information search at e-commercial platform | |
| CN100461159C (en) | Hierarchical data-driven navigation system and method for information retrieval | |
| CN103164413B (en) | The method and system of dynamic expansion business object | |
| US20130085987A1 (en) | Downloading method and device | |
| CN110232106A (en) | A kind of mass data storage and method for quickly retrieving based on MongoDB and Solr | |
| CN101645086A (en) | Retrieval method | |
| US7685155B2 (en) | System and method of providing and utilizing an object schema to facilitate mapping between disparate domains | |
| CN109344374B (en) | Report generation method and device based on big data, electronic equipment and storage medium | |
| CN110929120B (en) | Method and apparatus for managing technical metadata | |
| US20160196518A1 (en) | Intelligent Business Support System | |
| CN110879799B (en) | Method and device for labeling technical metadata | |
| US7979477B2 (en) | Placeholder control for updating database object | |
| US20080158160A1 (en) | Central storage for data entry processing | |
| JPH10171814A (en) | Information retrieving device | |
| CN101236637A (en) | Financial affairs system and processing method simultaneously supporting two kinds of accounting system | |
| CN112905627B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN114662002A (en) | Object recommendation method, medium, device and computing equipment | |
| JP3437441B2 (en) | Search method, search device, and storage medium storing search program | |
| US20170075724A1 (en) | Task handling in a multisystem environment |
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 | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20160129 Address after: 100094 Beijing City, North Road, Haidian District, No. 68, building 2, floor 2 Patentee after: You Pu Information Technology Co., Ltd of UFSOFT Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Patentee before: UFIDA Software Co., Ltd. |