CN102521412B - Data association device and data association method - Google Patents
Data association device and data association method Download PDFInfo
- Publication number
- CN102521412B CN102521412B CN 201110447747 CN201110447747A CN102521412B CN 102521412 B CN102521412 B CN 102521412B CN 201110447747 CN201110447747 CN 201110447747 CN 201110447747 A CN201110447747 A CN 201110447747A CN 102521412 B CN102521412 B CN 102521412B
- Authority
- CN
- China
- Prior art keywords
- field
- data
- obtains
- information
- attribute
- 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 association device which comprises a first analysis unit, a selection unit, a second analysis unit, an information addition unit, a source data set generating unit, a reference data set generating unit, an association model generating unit, a query unit, a value acquiring unit, an address acquiring unit and a value writing unit, wherein the first analysis unit is used for obtaining at least one piece of attribute information of a processed object; the selection unit is used for selecting the obtained at least one piece of attribute information; the second analysis unit is used for carrying out analysis on the attribute information to obtain attribute field information; the information addition unit is used for adding additional field information; the source data set generating unit is used for generating a source data set by combination; the reference data set generating unit is used for generating a reference data set; the association model generating unit is used for generating a multi-level data association model; the query unit is used for generating and executing stitch query sentences to obtain a query result; the value acquiring unit is used for acquiring a result value of a written field; the address acquiring unit is used for acquiring a data address of the written field; and the value writing unit is used for writing the result value into the data address. The invention also provides a data association method corresponding to the data association device. The multi-level association data exhibition is realized in a simple and effective mode.
Description
Technical field
The present invention relates to technical field of data processing, in particular to a kind of data correlation device and a kind of data correlation method.
Background technology
The multi-levels data correlation model is applied in a plurality of operation systems at present, as long as have related information between table or the object, perhaps can set up relation by middle table or medium object, just can use the multi-levels data correlation model to realize representing of whole business.User interface for example except the information that shows user itself, may need to show the extraneous informations such as department's coding, department name at user place, at this moment can pass through multi-level correlation model realization.In the prior art, several schemes below main the employing:
1. by increasing the redundant field mode to the application data base table, but this scheme has increased the complicacy of table, if the associate field that particularly need to represent is a lot, certainly will need so increases a lot of redundant field to table, has so not only increased the complicacy of system, must be able to predict all fields of these associations simultaneously, if a service application is finished, if need to add the association of certain field, need like this redesign list structure, for maintenance has caused very large difficulty;
2. the developer carries out the multilist association by program and goes to realize, this mode has increased developer's workload greatly, especially work as certain field and quote realization by multilayer, for example need to show the responsible official of user department in the subscriber's meter, if department table changes, the code of exploitation is all wanted corresponding change, has greatly increased developer's workload;
3. realize the application of multi-levels data association by metadata, but this scheme just need to be set up complete relation when modelling, if incidence relation changes, need the redesign metadata.
Therefore, need a kind of data correlation method, can do not revise list structure and do not increase in the situation of developer's development amount, adopt a kind of simple and effective way to realize that multi-level associated data represents.
Summary of the invention
Based on the problems referred to above, need a kind of can do not revise list structure with the situation that increases developer's development amount under, adopt a kind of simple and effective way to realize the data correlation method that multi-level associated data represents.
In view of this, the invention provides a kind of data correlation device, comprising: the first resolution unit, carry out dissection process to processing object, obtain at least one attribute information of described processing object, wherein, described processing object comprises database table or data object; Selected cell, according to user's selection instruction, at least one described attribute information of selecting described the first resolution unit to obtain; The second resolution unit is resolved the described attribute information that described selected cell is selected, and obtains attribute field information; The information adding device according to user's interpolation instruction, adds extra field information; The set of source data generation unit will generate set of source data from the described attribute field information of described the second resolution unit with from the described extra field information combination of described information adding device; Reference data collection generation unit according to user's requirement command, need in the described attribute field information to select the field quoted, generates the reference data collection; The correlation model generation unit, generate the multi-levels data correlation model, comprise matching field collection and condition field, wherein, described matching field collection comprises at least one matching field, each described matching field consists of by writing field and reading in field, and the said write Related fields is in the field of described source data set, the described Related fields that reads in the concentrated field of described reference data, and described condition field comprises key assignments and value attribute, and described key assignments is that field, the described value attribute that described reference data is concentrated is the field of described source data set; Query unit generates the splicing query statement corresponding to described multi-levels data correlation model, and obtains Query Result by carrying out described splicing query statement; The numerical value acquiring unit in the described Query Result that described query unit obtains, obtains the result value that writes field corresponding to all matching fields in the described multi-levels data correlation model; Address acquisition unit, that obtains all matching fields writes field in the data address of described source data set; The numerical value writing unit will write from the described result value of described numerical value acquiring unit the described data address from described address acquisition unit.
In this technical scheme, by setting up the multi-levels data correlation model, can be when needs be set up data correlation, by this model needs are carried out after related object resolves, obtain corresponding target data by field, and target data imported in this object, this process is only related by simple Configuration field, do not need the data tableau format is changed, do not need again development sequence yet, do not increase redundant field, under the prerequisite that does not increase staff's workload, realized that with a kind of simple effective means associated data represents.In addition, for the extra field information of wherein adding, such as hope related " employee " information in " signing the card application form ", and " employee " information is present in " employee's table ", so when carrying out association, on the interface of " signing the card application form ", when wishing also to have " employee " printed words, these printed words just need to additionally add.
In the multi-levels data correlation model of setting up, write the position that field is equivalent to preset in the matching field, be used for placing the result who obtains at last, and the field of reading in the matching field has been placed the field that reference data is concentrated, the field that key assignments in the condition field is concentrated corresponding to reference data, value attribute all is given data corresponding to the field of source data set, the data query after can be used for.
In technique scheme, preferably, described attribute information comprises field information in the described database table or the composition structural information of described data object.In this technical scheme, pending object is resolved, obtain its attribute information, thereby be convenient to utilize these information to carry out data correlation.
In technique scheme, preferably, described attribute field information comprises unique identification and/or the data type of each described attribute information.In this technical scheme, attribute field information comprises unique identification and/or the data type of each attribute information, has guaranteed accurate in the data correlation process, has guaranteed the reliability of system.
In technique scheme, preferably, described query unit specifically comprises: template generates subelement, generated query statement template; First obtains subelement, obtains the matching field collection in the described multi-levels data correlation model, for each matching field wherein, obtains the field that field is concentrated in the reference data of correspondence of reading in the described matching field; Second obtains subelement, obtains the condition field in the described multi-levels data correlation model, for key assignments wherein, obtains the field that described key assignments is concentrated in the reference data of correspondence; The 3rd obtains subelement, obtains the title that described reference data is concentrated the target database table that comprises; The 4th obtains subelement, obtains the field in the value attribute in the described condition field, and obtains the field value of the Related fields of described value attribute in described source data set; Process subelement, will from described first obtain the field of reading in field that field concentrates in the reference data of correspondence, concentrating in the reference data of correspondence from the described second described key assignments that obtains subelement in the described matching field of subelement, from the described the 3rd obtain subelement described target database table title and from the described the 4th field value of Related fields that obtains the described value attribute of subelement, the inquiry field of splicing to the described query statement template.
In this technical scheme, query statement has certain template, but the information of the matching effect when wherein playing inquiry, need to splice according to concrete request for information, thereby when inquiring about at every turn, be configured as the case may be, just can obtain easily carrying out related data and target.
In technique scheme, preferably, described data correlation device also comprises: multi-level relating module is the target database table foundation of described set of source data as the data correlation described in the above-mentioned technical scheme.In this technical scheme, with a source object and destination object carry out related after, can also continue this destination object as another source object, and carry out related with other destination object.By from level to level association, thereby realize multi-level data correlation.
According to a further aspect in the invention, also provide a kind of data correlation method, having comprised: step 202, by carrying out dissection process to processing object, obtain at least one attribute information of described processing object, wherein, described processing object comprises database table or data object; Step 204 according to user's selection instruction, is selected at least one described attribute information, and is again resolved, and obtains attribute field information; Step 206 according to user's interpolation instruction, is added extra field information, and described extra field information and described attribute field information combination are generated set of source data; Step 208 according to user's requirement command, need in the described attribute field information to select the field quoted, generates the reference data collection; Step 210, generate the multi-levels data correlation model, comprise matching field collection and condition field, wherein, described matching field collection comprises at least one matching field, each described matching field consists of by writing field and reading in field, and the said write Related fields is in the field of described source data set, the described Related fields that reads in the concentrated field of described reference data, and described condition field is by key assignments and value attribute, and described key assignments is that field, the described value attribute that described reference data is concentrated is the field of described source data set; Step 212 generates the splicing query statement corresponding to described multi-levels data correlation model, and obtains Query Result by carrying out described splicing query statement; Step 214 in described Query Result, is obtained the result value that writes field corresponding to all matching fields in the described multi-levels data correlation model; Step 216, that obtains described all matching fields writes field in the data address of described source data set, and described result value is write described data address.
In this technical scheme, by setting up the multi-levels data correlation model, can be when needs be set up data correlation, by this model needs are carried out after related object resolves, obtain corresponding target data by field, and target data imported in this object, this process is only related by simple Configuration field, do not need the data tableau format is changed, do not need again development sequence yet, do not increase redundant field, under the prerequisite that does not increase staff's workload, realized that with a kind of simple effective means associated data represents.In addition, for the extra field information of wherein adding, such as hope related " employee " information in " signing the card application form ", and " employee " information is present in " employee's table ", so when carrying out association, on the interface of " signing the card application form ", when wishing also to have " employee " printed words, these printed words just need to additionally add.
In the multi-levels data correlation model of setting up, write the position that field is equivalent to preset in the matching field, be used for placing the result who obtains at last, and the field of reading in the matching field has been placed the field that reference data is concentrated, the field that key assignments in the condition field is concentrated corresponding to reference data, value attribute all is given data corresponding to the field of source data set, the data query after can be used for.
In technique scheme, preferably, described attribute information comprises field information in the described database table or the composition structural information of described data object.In this technical scheme, pending object is resolved, obtain its attribute information, thereby be convenient to utilize these information to carry out data correlation.
In technique scheme, preferably, described attribute field information comprises unique identification and/or the data type of each described attribute information.In this technical scheme, attribute field information comprises unique identification and/or the data type of each attribute information, has guaranteed accurate in the data correlation process, has guaranteed the reliability of system.
In technique scheme, preferably, in described step 212, the process that generates described splicing query statement comprises: step 302, generated query statement template; Step 304, obtain the matching field collection in the described multi-levels data correlation model, for each matching field wherein, obtain the field that field is concentrated in the reference data of correspondence of reading in the described matching field, and the inquiry field of splicing to the described query statement template; Step 306 is obtained the condition field in the described multi-levels data correlation model, for key assignments wherein, obtains the field that described key assignments is concentrated in the reference data of correspondence, and the described inquiry field of splicing to the described query statement template; Step 308, described reference data are concentrated the title comprise the target database table, with the title splicing of the described target database table described inquiry field to the described query statement template; Step 310 is obtained the field in the value attribute in the described condition field, and obtains the field value of the Related fields of described value attribute in described source data set, with the described inquiry field of described field value splicing to the described query statement template; Step 312 generates described splicing query statement.
In this technical scheme, query statement has certain template, but the information of the matching effect when wherein playing inquiry, need to splice according to concrete request for information, thereby when inquiring about at every turn, be configured as the case may be, just can obtain easily carrying out related data and target.
In technique scheme, preferably, described data correlation method also comprises: be the target database table foundation of described set of source data as the data correlation described in the above-mentioned technical scheme.In this technical scheme, with a source object and destination object carry out related after, can also continue this destination object as another source object, and carry out related with other destination object.By from level to level association, thereby realize multi-level data correlation.
By above technical scheme, analyze according to business demand, determine the incidence relation of business association data set and reference data collection according to the result who analyzes, thereby set up the multi-levels data correlation model, realize that by the mode of setting up the multi-levels data correlation model multi-levels data is related, can be related by simple Configuration field, avoided the adjustment of data list structure and a large amount of code development quantity; Can increase dynamically simultaneously the associate field with Update Table.Generally speaking, use the multi-level associated data model can be in view layer representing by the association of simple Configuration multilist, do not need to increase redundant field, do not need the extra exploitation code of developer, reduce code maintenance amount and exploitation amount, saved cost, do not needed to revise business model, have very high ease for use and dirigibility, improved efficient.
Description of drawings
Fig. 1 shows the according to an embodiment of the invention structured flowchart of data correlation device;
Fig. 2 shows the according to an embodiment of the invention process flow diagram of data correlation method;
Fig. 3 shows the process flow diagram that generates according to an embodiment of the invention the splicing statement;
Fig. 4 shows the process flow diagram of setting up according to an embodiment of the invention the business association data set;
Fig. 5 shows the according to an embodiment of the invention structured flowchart of multi-levels data correlation model;
Fig. 6 shows according to an embodiment of the invention another structured flowchart of multi-levels data correlation model;
Fig. 7 shows the according to an embodiment of the invention process flow diagram of associated data model implementation;
Fig. 8 shows the process flow diagram that splices according to an embodiment of the invention the query statement rule;
Fig. 9 A is the synoptic diagram of data correlation according to an embodiment of the invention;
Fig. 9 B is the synoptic diagram of multi-levels data association according to an embodiment of the invention.
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.
In order clearly to describe the implementation based on the associated data of technical scheme of the present invention, those skilled in the art will be appreciated that the implication of the set of source data mentioned among the present invention, reference data collection, field etc. is:
Set of source data: a kind of mode of data description, often list structure in the correspondence database or object.A set of source data is comprised of a plurality of fields, and each field object has represented an element that forms this set of source data.
The reference data collection: function and data set are similar, only quote use, can not be as data exhibiting.
Field: the component of set of source data or reference data collection, an attribute in each Related fields tables of data.
Fig. 1 shows the according to an embodiment of the invention structured flowchart of data correlation device.
As shown in Figure 1, the data correlation device 100 according to an embodiment of the invention, comprising: the first resolution unit 102, carry out dissection process to processing object, and obtain processing at least one attribute information of object, wherein, process object and comprise database table or data object; Selected cell 104, according to user's selection instruction, at least one attribute information of selecting the first resolution unit 102 to obtain; The second resolution unit 106 is resolved the attribute information that selected cell 104 is selected, and obtains attribute field information; Information adding device 108 according to user's interpolation instruction, adds extra field information; Set of source data generation unit 110 will generate set of source data with the extra field information combination of coming self-information adding device 108 from the attribute field information of the second resolution unit 106; Reference data collection generation unit 112 according to user's requirement command, to need in the attribute field information to select the field quoted, generates the reference data collection; Correlation model generation unit 114, generate the multi-levels data correlation model, comprise matching field collection and condition field, wherein, the matching field collection comprises at least one matching field, and each matching field is by writing field and read in field and consist of, and write Related fields in the field of source data set, read in the field that Related fields is concentrated in reference data, and condition field comprises key assignments and value attribute, and key assignments is that field, the value attribute that reference data is concentrated is the field of source data set; Query unit 116 generates the splicing query statement corresponding to the multi-levels data correlation model, and obtains Query Result by carrying out the splicing query statement; Numerical value acquiring unit 118 in the Query Result that query unit 116 obtains, obtains the result value that writes field corresponding to all matching fields in the multi-levels data correlation model; Address acquisition unit 120, that obtains all matching fields writes field in the data address of source data set; Numerical value writing unit 122 will write from the result value of numerical value acquiring unit 118 data address from address acquisition unit 120.
In this technical scheme, by setting up the multi-levels data correlation model, can be when needs be set up data correlation, by this model needs are carried out after related object resolves, obtain corresponding target data by field, and target data imported in this object, this process is only related by simple Configuration field, do not need the data tableau format is changed, do not need again development sequence yet, do not increase redundant field, under the prerequisite that does not increase staff's workload, realized that with a kind of simple effective means associated data represents.In addition, for the extra field information of wherein adding, such as hope related " employee " information in " signing the card application form ", and " employee " information is present in " employee's table ", so when carrying out association, on the interface of " signing the card application form ", when wishing also to have " employee " printed words, these printed words just need to additionally add.
In the multi-levels data correlation model of setting up, write the position that field is equivalent to preset in the matching field, be used for placing the result who obtains at last, and the field of reading in the matching field has been placed the field that reference data is concentrated, the field that key assignments in the condition field is concentrated corresponding to reference data, value attribute all is given data corresponding to the field of source data set, the data query after can be used for.
In technique scheme, attribute information comprises field information in the database table or the composition structural information of data object.In this technical scheme, pending object is resolved, obtain its attribute information, thereby be convenient to utilize these information to carry out data correlation.
In technique scheme, attribute field information comprises unique identification and/or the data type of each attribute information.In this technical scheme, attribute field information comprises unique identification and/or the data type of each attribute information, has guaranteed accurate in the data correlation process, has guaranteed the reliability of system.
In technique scheme, query unit 116 specifically comprises: template generates subelement 1161, generated query statement template; First obtains subelement 1162, obtains the matching field collection in the multi-levels data correlation model, for each matching field wherein, obtains the field that field is concentrated in the reference data of correspondence of reading in the matching field; Second obtains subelement 1163, obtains the condition field in the multi-levels data correlation model, for key assignments wherein, obtains the field that key assignments is concentrated in the reference data of correspondence; The 3rd obtains subelement 1164, obtains the title that reference data is concentrated the target database table that comprises; The 4th obtains subelement 1165, obtains the field in the value attribute in the condition field, and obtains the field value of the Related fields of value attribute in source data set; Process subelement 1166, will from first obtain the field of reading in field that field concentrates in the reference data of correspondence, concentrating in the reference data of correspondence from the second key assignments that obtains subelement 1163 in the matching field of subelement 1162, from the 3rd obtain subelement 1164 the target database table title and from the 4th field value of Related fields that obtains the value attribute of subelement 1165, splice the inquiry field to the query statement template.
In this technical scheme, query statement has certain template, but the information of the matching effect when wherein playing inquiry, need to splice according to concrete request for information, thereby when inquiring about at every turn, be configured as the case may be, just can obtain easily carrying out related data and target.
In technique scheme, data correlation device 100 also comprises: multi-level relating module 124 is the target database table foundation of set of source data as the data correlation described in the above-mentioned technical scheme.In this technical scheme, with a source object and destination object carry out related after, can also continue this destination object as another source object, and carry out related with other destination object.By from level to level association, thereby realize multi-level data correlation.
Fig. 2 shows the according to an embodiment of the invention process flow diagram of data correlation method.
As shown in Figure 2, data correlation method according to an embodiment of the invention comprises: step 202, by carrying out dissection process to processing object, obtain processing at least one attribute information of object, and wherein, process object and comprise database table or data object; Step 204 according to user's selection instruction, is selected at least one attribute information, and is again resolved, and obtains attribute field information; Step 206 according to user's interpolation instruction, is added extra field information, and extra field information and attribute field information combination are generated set of source data; Step 208 according to user's requirement command, to need in the attribute field information to select the field quoted, generates the reference data collection; Step 210, generate the multi-levels data correlation model, comprise matching field collection and condition field, wherein, the matching field collection comprises at least one matching field, and each matching field is by writing field and read in field and consist of, and write Related fields in the field of source data set, read in the field that Related fields is concentrated in reference data, and condition field is by key assignments and value attribute, and key assignments is that field, the value attribute that reference data is concentrated is the field of source data set; Step 212 generates the splicing query statement corresponding to the multi-levels data correlation model, and obtains Query Result by carrying out the splicing query statement; Step 214 in Query Result, is obtained the result value that writes field corresponding to all matching fields in the multi-levels data correlation model; Step 216, that obtains all matching fields writes field in the data address of source data set, and with result value data writing address.
In this technical scheme, by setting up the multi-levels data correlation model, can be when needs be set up data correlation, by this model needs are carried out after related object resolves, obtain corresponding target data by field, and target data imported in this object, this process is only related by simple Configuration field, do not need the data tableau format is changed, do not need again development sequence yet, do not increase redundant field, under the prerequisite that does not increase staff's workload, realized that with a kind of simple effective means associated data represents.In addition, for the extra field information of wherein adding, such as hope related " employee " information in " signing the card application form ", and " employee " information is present in " employee's table ", so when carrying out association, on the interface of " signing the card application form ", when wishing also to have " employee " printed words, these printed words just need to additionally add.
In the multi-levels data correlation model of setting up, write the position that field is equivalent to preset in the matching field, be used for placing the result who obtains at last, and the field of reading in the matching field has been placed the field that reference data is concentrated, the field that key assignments in the condition field is concentrated corresponding to reference data, value attribute all is given data corresponding to the field of source data set, the data query after can be used for.
In technique scheme, attribute information comprises field information in the database table or the composition structural information of data object.In this technical scheme, pending object is resolved, obtain its attribute information, thereby be convenient to utilize these information to carry out data correlation.
In technique scheme, preferably, attribute field information comprises unique identification and/or the data type of each attribute information.In this technical scheme, attribute field information comprises unique identification and/or the data type of each attribute information, has guaranteed accurate in the data correlation process, has guaranteed the reliability of system.
In technique scheme, data correlation method also is included as the target database table foundation of set of source data as the data correlation described in the above-mentioned technical scheme.In this technical scheme, with a source object and destination object carry out related after, can also continue this destination object as another source object, and carry out related with other destination object.By from level to level association, thereby realize multi-level data correlation.
Below in conjunction with Fig. 3, the generative process of the splicing statement among Fig. 2 is elaborated, wherein, Fig. 3 shows the process flow diagram that generates according to an embodiment of the invention the splicing statement.
As shown in Figure 3, generating the process of splicing query statement comprises: step 302, generated query statement template; Step 304 is obtained the matching field collection in the multi-levels data correlation model, for each matching field wherein, obtains the field that field is concentrated in the reference data of correspondence of reading in the matching field, and splices the inquiry field to the query statement template; Step 306 is obtained the condition field in the multi-levels data correlation model, for key assignments wherein, obtains the field that key assignments is concentrated in the reference data of correspondence, and splices the inquiry field to the query statement template; Step 308, reference data are concentrated the title comprise the target database table, and the title of target database table is spliced inquiry field to the query statement template; Step 310 is obtained the field in the value attribute in the condition field, and obtains the field value of the Related fields of value attribute in source data set, and field value is spliced inquiry field to the query statement template; Step 312 generates the splicing query statement.
In this technical scheme, query statement has certain template, but the information of the matching effect when wherein playing inquiry, need to splice according to concrete request for information, thereby when inquiring about at every turn, be configured as the case may be, just can obtain easily carrying out related data and target.
By above technical scheme, analyze according to business demand, determine the incidence relation of business association data set and reference data collection according to the result who analyzes, thereby set up the multi-levels data correlation model, realize that by the mode of setting up the multi-levels data correlation model multi-levels data is related, can be related by simple Configuration field, avoided the adjustment of data list structure and a large amount of code development quantity; Can increase dynamically simultaneously the associate field with Update Table.Generally speaking, use the multi-level associated data model can be in view layer representing by the association of simple Configuration multilist, do not need to increase redundant field, do not need the extra exploitation code of developer, reduce code maintenance amount and exploitation amount, saved cost, do not needed to revise business model, have very high ease for use and dirigibility, high efficient.
The multi-levels data associated apparatus realizes that by setting up the multi-levels data correlation model multi-levels data is related according to an embodiment of the invention.Set up the multi-levels data correlation model and mainly comprise three steps, set up the data set of business association, set up the reference data collection, set up multi-level service correlation model on the basis that data set and reference data collection are all set up.
Step 1, set up the data set of business association.
The process of setting up of data set mainly comprises as shown in Figure 4:
Step 404 will obtain table or data object and resolve, and obtain the relevant information of all properties, as forming structural information, field information etc.
Step 406 is selected part or all properties according to service needed.
Step 408 is resolved attribute, obtains the information such as unique identification, data type of each attribute, forms corresponding data set field information.
Step 412 makes up the field information that obtains, and forms data set.
Step 2, set up the reference data collection, its process is with to set up data set similar, need in the operation system just only to select the field of quoting when selecting the attribute of resolving.
Step 3, set up the multi-levels data correlation model.
About the multi-levels data correlation model, be elaborated below in conjunction with Fig. 5 and Fig. 6, wherein, Fig. 5, Fig. 6 show respectively the according to an embodiment of the invention structured flowchart of multi-levels data correlation model.
As shown in Figure 5, this multi-levels data correlation model comprises matching field set and condition field, wherein, comprise one or more matching fields in the matching field set, and each matching field represents the related of the data centralization field of service application own and reference data collection field, matching field comprises and reads in field and write field, wherein, reading in field is the field that reference data is concentrated, and is known field, be used for after when inquiring about, the splicing query statement, and write the field that Related fields data centralization, be after affiliated partner is inquired about, being used for depositing the headspace of the association results of obtaining, is unknown object.
And condition field comprises key assignments and value attribute, wherein, the field that key-value pair is answering reference data to concentrate, and the value attribute correspondence the field of data centralization, all is known data, be used for after when inquiring about, splice query statement.
As shown in Figure 6, in order to set up the multi-levels data association, for the business association data set that creates, Mr. becomes corresponding reference data collection, and utilization multi-layer data correlation model as shown in Figure 5, set up first order layer data correlation model, then, for the target of association, can continue to generate the reference data collection, then set up second level layer data correlation model, by that analogy, just can set up multi-level data correlation.
Fig. 7 shows the according to an embodiment of the invention process flow diagram of associated data model execution.
Associated data model implementation such as Fig. 7 comprise:
Step 602 reads relevant multi-level associated data model.
Step 610 is taken out all matching fields from multi-level associated data model, from wherein obtaining writing field, obtain writing the position of field in data centralization.
Wherein, the rule of the described splicing query statement of step 604, its concrete implementation such as Fig. 8 comprise:
Step 702 from multi-level associated data model read matching field set, is taken out one of them matching field.
Step 704 obtains reading in field information from matching field.
Step 706 reads the reference data collection, obtains reference data and concentrates the field corresponding with reading in field information.
Step 708 is spliced to the field of reading in that obtains in the step 706 in the inquiry field of query statement.
Step 710 obtains the key assignments field information from condition field.
Step 712 reads the reference data collection, obtains reference data and concentrates the field of answering with key-value pair.
Step 716 judges whether to exist untreated matching field, if exist, then returns step 702 and continues to process, until the splicing of all matching fields is finished; If not, go to step 718.
Step 718 reads the database table that the reference data set pair is answered from reference data is concentrated, table name is spliced in the question blank field of query statement.Here, the table name that need to carry out related target matrix adds in the query statement, thereby it is directly inquired about.
Step 724 is spliced to the value that obtains in the step 722 in the condition of query statement.
Below in conjunction with Fig. 9 A and Fig. 9 B, multi-levels data correlation model application in practice according to an embodiment of the invention is introduced:
Application scenarios 1: the label card application of self-aid system is used, sign in the card application form and need demonstration person's job number information, but the person's of existence job number field not in signing list structure corresponding to card application, existence person's job number major key field, the person's of obtaining job number information, can in signing the card application, set up the single level data correlation of quoting employee information, sign card after foundation is related and apply for that the interface can demonstration person's job number information.The step of setting up the single level data correlation is as follows:
Step 1, set up and sign data set corresponding to card application form:
Step 2, set up the employee and show corresponding reference data collection:
Step 3, set up the data correlation relation:
After establishing data correlation, display effect is shown in Fig. 9 A.
Application scenarios 2: if change now the demand of signing the card application, except will showing above-mentioned field, also will demonstration personnel coding and name field.Personnel's coding and personnel's title are non-existent in signing the card application, although can know clearly these two fields exists in person chart, but sign in the card application and can not find the field related with person chart, but, exist in the employee work table and show related field with the employee, at this time need to set up the secondary data correlation model to reach the realization effect, be about to employee's table as data set, generate corresponding reference data collection, and by the multi-levels data correlation model, set up data correlation with the employee work table, be the secondary data association, final display effect is shown in Fig. 9 B.
More than be described with reference to the accompanying drawings technical scheme of the present invention, consider in the implementation procedure of whole technical scheme, do not increase redundant field, so under the prerequisite that does not increase staff's workload, realized that with a kind of simple effective means multi-level associated data represents.Analyze according to business demand, determine the incidence relation of business association data set and reference data collection according to the result who analyzes, thereby set up the multi-levels data correlation model, realize that by the mode of setting up the multi-levels data correlation model multi-levels data is related, can be related by simple Configuration field, avoided the adjustment of data list structure and a large amount of code development quantity; Can increase dynamically simultaneously the associate field with Update Table.Generally speaking, use the multi-level associated data model can be in view layer representing by the association of simple Configuration multilist, do not need to increase redundant field, do not need the extra exploitation code of developer, reduce code maintenance amount and exploitation amount, saved cost, do not needed to revise business model, have very high ease for use and dirigibility, improved 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 correlation device is characterized in that, comprising:
The first resolution unit is carried out dissection process to processing object, obtains at least one attribute information of described processing object, and wherein, described processing object comprises database table or data object;
Selected cell, according to user's selection instruction, at least one described attribute information of selecting described the first resolution unit to obtain;
The second resolution unit is resolved the described attribute information that described selected cell is selected, and obtains attribute field information;
The information adding device according to user's interpolation instruction, adds extra field information;
The set of source data generation unit will generate set of source data from the described attribute field information of described the second resolution unit with from the described extra field information combination of described information adding device;
Reference data collection generation unit according to user's requirement command, need in the described attribute field information to select the field quoted, generates the reference data collection;
The correlation model generation unit, generate the multi-levels data correlation model, comprise matching field collection and condition field, wherein, described matching field collection comprises at least one matching field, each described matching field consists of by writing field and reading in field, and the said write Related fields is in the field of described source data set, the described Related fields that reads in the concentrated field of described reference data, and described condition field comprises key assignments and value attribute, and described key assignments is that field, the described value attribute that described reference data is concentrated is the field of described source data set;
Query unit generates the splicing query statement corresponding to described multi-levels data correlation model, and obtains Query Result by carrying out described splicing query statement;
The numerical value acquiring unit in the described Query Result that described query unit obtains, obtains the result value that writes field corresponding to all matching fields in the described multi-levels data correlation model;
Address acquisition unit, that obtains all matching fields writes field in the data address of described source data set;
The numerical value writing unit will write from the described result value of described numerical value acquiring unit the described data address from described address acquisition unit.
2. data correlation device according to claim 1 is characterized in that, described attribute information comprises: the composition structural information of the field information in the described database table or described data object.
3. data correlation device according to claim 1 is characterized in that, described attribute field information comprises: the unique identification of each described attribute information and/or data type.
4. data correlation device according to claim 1 is characterized in that, described query unit specifically comprises:
Template generates subelement, generated query statement template;
First obtains subelement, obtains the matching field collection in the described multi-levels data correlation model, for each matching field wherein, obtains the field that field is concentrated in the reference data of correspondence of reading in the described matching field;
Second obtains subelement, obtains the condition field in the described multi-levels data correlation model, for key assignments wherein, obtains the field that described key assignments is concentrated in the reference data of correspondence;
The 3rd obtains subelement, obtains the title that described reference data is concentrated the target database table that comprises;
The 4th obtains subelement, obtains the field in the value attribute in the described condition field, and obtains the field value of the Related fields of described value attribute in described source data set;
Process subelement, will from described first obtain the field of reading in field that field concentrates in the reference data of correspondence, concentrating in the reference data of correspondence from the described second described key assignments that obtains subelement in the described matching field of subelement, from the described the 3rd obtain subelement described target database table title and from the described the 4th field value of Related fields that obtains the described value attribute of subelement, the inquiry field of splicing to the described query statement template.
5. each described data correlation device in 4 according to claim 1 is characterized in that, also comprises:
Multi-level relating module is for the target database table of described set of source data is set up such as each described data correlation in the claim 1 to 4.
6. a data correlation method is characterized in that, comprising:
Step 202 by carrying out dissection process to processing object, obtains at least one attribute information of described processing object, and wherein, described processing object comprises database table or data object;
Step 204 according to user's selection instruction, is selected at least one described attribute information, and is again resolved, and obtains attribute field information;
Step 206 according to user's interpolation instruction, is added extra field information, and described extra field information and described attribute field information combination are generated set of source data;
Step 208 according to user's requirement command, need in the described attribute field information to select the field quoted, generates the reference data collection;
Step 210, generate the multi-levels data correlation model, comprise matching field collection and condition field, wherein, described matching field collection comprises at least one matching field, each described matching field consists of by writing field and reading in field, and the said write Related fields is in the field of described source data set, the described Related fields that reads in the concentrated field of described reference data, and described condition field is by key assignments and value attribute, and described key assignments is that field, the described value attribute that described reference data is concentrated is the field of described source data set;
Step 212 generates the splicing query statement corresponding to described multi-levels data correlation model, and obtains Query Result by carrying out described splicing query statement;
Step 214 in described Query Result, is obtained the result value that writes field corresponding to all matching fields in the described multi-levels data correlation model;
Step 216, that obtains described all matching fields writes field in the data address of described source data set, and described result value is write described data address.
7. data correlation method according to claim 6 is characterized in that, described attribute information comprises: the composition structural information of the field information in the described database table or described data object.
8. data correlation method according to claim 6 is characterized in that, described attribute field information comprises: the unique identification of each described attribute information and/or data type.
9. data correlation method according to claim 6 is characterized in that, in described step 212, the process that generates described splicing query statement comprises:
Step 302, generated query statement template;
Step 304, obtain the matching field collection in the described multi-levels data correlation model, for each matching field wherein, obtain the field that field is concentrated in the reference data of correspondence of reading in the described matching field, and the inquiry field of splicing to the described query statement template;
Step 306 is obtained the condition field in the described multi-levels data correlation model, for key assignments wherein, obtains the field that described key assignments is concentrated in the reference data of correspondence, and the described inquiry field of splicing to the described query statement template;
Step 308, described reference data are concentrated the title comprise the target database table, with the title splicing of the described target database table described inquiry field to the described query statement template;
Step 310 is obtained the field in the value attribute in the described condition field, and obtains the field value of the Related fields of described value attribute in described source data set, with the described inquiry field of described field value splicing to the described query statement template;
Step 312 generates described splicing query statement.
10. each described data correlation method in 9 according to claim 6 is characterized in that, also comprises:
For the target database table of described set of source data is set up such as each described data correlation in the claim 6 to 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110447747 CN102521412B (en) | 2011-12-28 | 2011-12-28 | Data association device and data association method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110447747 CN102521412B (en) | 2011-12-28 | 2011-12-28 | Data association device and data association method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102521412A CN102521412A (en) | 2012-06-27 |
| CN102521412B true CN102521412B (en) | 2013-04-24 |
Family
ID=46292325
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110447747 Active CN102521412B (en) | 2011-12-28 | 2011-12-28 | Data association device and data association method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102521412B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105631047A (en) * | 2016-02-17 | 2016-06-01 | 中国工商银行股份有限公司 | Hierarchically-cascaded data processing method and hierarchically-cascaded data processing system |
| CN107220266A (en) * | 2016-03-22 | 2017-09-29 | 阿里巴巴集团控股有限公司 | It is a kind of to create Service Database, business datum storage and the method and device for determining business datum |
Families Citing this family (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649375B (en) * | 2015-10-31 | 2020-08-04 | 阿里巴巴集团控股有限公司 | Relation data processing method and device |
| CN105760273A (en) * | 2016-01-29 | 2016-07-13 | 浪潮通信信息系统有限公司 | Method and device for processing indicators |
| CN108241624B (en) * | 2016-12-23 | 2022-03-18 | 北京国双科技有限公司 | Query script generation method and device |
| CN107403371B (en) * | 2017-04-13 | 2020-06-09 | 阿里巴巴集团控股有限公司 | Data generation method and device |
| CN107301113A (en) * | 2017-05-26 | 2017-10-27 | 北京小度信息科技有限公司 | Mission Monitor method and device |
| CN108038175A (en) * | 2017-09-30 | 2018-05-15 | 用友金融信息技术股份有限公司 | Multidimensional data dynamically associates querying method, device, computer equipment and medium |
| CN107766494B (en) * | 2017-10-19 | 2021-11-30 | 北京科技大学 | Storage method and system of material genetic engineering data |
| CN109377159A (en) * | 2018-09-19 | 2019-02-22 | 成都信息工程大学 | A kind of software modeling procedure incarnation evolution system and method, processor, terminal |
| CN110008209B (en) * | 2018-12-07 | 2024-04-19 | 创新先进技术有限公司 | Database enhancement method and device |
| CN111309721B (en) * | 2018-12-11 | 2024-09-20 | 北京京东尚科信息技术有限公司 | Method and device for determining association relation of data table |
| CN110032500B (en) * | 2019-03-01 | 2023-06-09 | 创新先进技术有限公司 | Multi-layer nested data analysis method and device |
| CN111142871B (en) * | 2019-12-24 | 2023-06-06 | 杭州安恒信息技术股份有限公司 | Front-end page development system, method, equipment and medium |
| CN111274269B (en) * | 2020-01-17 | 2023-07-07 | 广州至真信息科技有限公司 | Data processing method and device |
| CN112052242B (en) * | 2020-09-02 | 2024-06-04 | 平安科技（深圳）有限公司 | Data query method, device, electronic equipment and storage medium |
| CN112182349B (en) * | 2020-09-14 | 2024-06-11 | 支付宝(杭州)信息技术有限公司 | Query method, device and system for compliance files |
| CN115185982A (en) * | 2022-09-14 | 2022-10-14 | 浩鲸云计算科技股份有限公司 | Data preparation method and system based on data set arrangement |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101000619A (en) * | 2006-12-25 | 2007-07-18 | 华为技术有限公司 | Data synchronous method and device based on SQL |
| CN101470746A (en) * | 2007-12-28 | 2009-07-01 | 英业达股份有限公司 | Multi-layer statistical diagram system and method with data correlation function |
| CN101655857A (en) * | 2009-09-18 | 2010-02-24 | 西安建筑科技大学 | Method for mining data in construction regulation field based on associative regulation mining technology |
| CN101876984A (en) * | 2009-12-07 | 2010-11-03 | 金蝶软件（中国）有限公司 | Data management system and data relation query method and device thereof |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030078987A1 (en) * | 2001-10-24 | 2003-04-24 | Oleg Serebrennikov | Navigating network communications resources based on telephone-number metadata |
-
2011
- 2011-12-28 CN CN 201110447747 patent/CN102521412B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101000619A (en) * | 2006-12-25 | 2007-07-18 | 华为技术有限公司 | Data synchronous method and device based on SQL |
| CN101470746A (en) * | 2007-12-28 | 2009-07-01 | 英业达股份有限公司 | Multi-layer statistical diagram system and method with data correlation function |
| CN101655857A (en) * | 2009-09-18 | 2010-02-24 | 西安建筑科技大学 | Method for mining data in construction regulation field based on associative regulation mining technology |
| CN101876984A (en) * | 2009-12-07 | 2010-11-03 | 金蝶软件（中国）有限公司 | Data management system and data relation query method and device thereof |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105631047A (en) * | 2016-02-17 | 2016-06-01 | 中国工商银行股份有限公司 | Hierarchically-cascaded data processing method and hierarchically-cascaded data processing system |
| CN107220266A (en) * | 2016-03-22 | 2017-09-29 | 阿里巴巴集团控股有限公司 | It is a kind of to create Service Database, business datum storage and the method and device for determining business datum |
| CN107220266B (en) * | 2016-03-22 | 2021-03-19 | 创新先进技术有限公司 | Method and device for creating service database, storing service data and determining service data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102521412A (en) | 2012-06-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102521412B (en) | Data association device and data association method | |
| US8954480B2 (en) | End-to-end interoperability and workflows from building architecture design to one or more simulations | |
| CN107798017B (en) | Method and system for generating execution plan information in distributed database | |
| CN105760168A (en) | Automatic code file generation method and system | |
| CN106055528A (en) | Automatic generation method and apparatus of documents | |
| TW201234202A (en) | Geospatial database integration using business models | |
| CN101216835B (en) | Data file conversion method and apparatus | |
| CN110263317A (en) | A kind of method and device generating document template | |
| CN105930330A (en) | Portal system page display method and apparatus | |
| CN106155769A (en) | A kind of workflow processing method, device and workflow engine | |
| CN102567399A (en) | Method and device for accessing database | |
| CN101901262A (en) | Object-oriented model-based enterprise database construction and service data display method | |
| CN111461666A (en) | Demand tracking matrix display method and system | |
| US20210012168A1 (en) | Print, and production method and production system for touch-read content of print | |
| CN101645062B (en) | Report form generation method and system | |
| CN103324749A (en) | Spatial analysis and correction method based on standard text addresses | |
| CN109977317A (en) | Data query method and device | |
| CN109543076A (en) | User's managing detailed catalogue generation method and device, electronic equipment, storage medium | |
| CN108874871A (en) | Real-time PNT service data source tracing method and device | |
| CN101616153B (en) | Web page based method, system and device for interacting operation information | |
| CN104424206A (en) | Information processing method and education platform | |
| CN101599231B (en) | Method for setting and retrieving information points and device thereof | |
| CN111798317B (en) | Multidimensional space block chain and data processing method based on block chain | |
| CN113656724B (en) | Method and system for dynamically configuring webpage function based on web page | |
| Cerna | Mobile computing framework for student engagement system in Ethiopian Higher Educational Institution |
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 |
Owner name: YONYOU NETWORK TECHNOLOGY CO., LTD. Free format text: FORMER NAME: UFIDA SOFTWARE CO., LTD. |
|
| 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. |