CN107609171A - Data source tracing method and device based on data warehouse - Google Patents
Data source tracing method and device based on data warehouse Download PDFInfo
- Publication number
- CN107609171A CN107609171A CN201710897207.7A CN201710897207A CN107609171A CN 107609171 A CN107609171 A CN 107609171A CN 201710897207 A CN201710897207 A CN 201710897207A CN 107609171 A CN107609171 A CN 107609171A
- Authority
- CN
- China
- Prior art keywords
- information
- source
- attribute
- cell
- traced
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Abstract
The invention belongs to technical field of data processing, there is provided a kind of data source tracing method and device based on data warehouse.This method includes：Acquisition is traced to the source request, and request of tracing to the source includes user to be checked and identified and attribute.In the data warehouse of prebuild, traced to the source according to user's mark or attribute, positioning unit lattice, and the information in acquiring unit lattice, and the information source of the associated storage of cell and renewal time.Data source tracing method and device of the invention based on data warehouse, can accurately and fast carry out data and trace to the source, precise positioning cell data, provide the user reliable Query Result.
Description
Technical field
The present invention relates to technical field of data processing, and in particular to a kind of data source tracing method and dress based on data warehouse
Put.
Background technology
As the requirement to information technologies such as internet, cloud computing, Internet of Things, the receipts of mass data are built in smart city
Collection, storage, analysis, processing and its application are more and more extensive, and the decision behavior of government will be gradually based on data and analysis and make.
It is the description information of origin to data and data generating procedure that data, which are traced to the source, and these information play important at many aspects
Effect.
In the prior art, generally use dictionary, configuration rule, mapping relations progress data are traced to the source, and Query Result is mostly to obtain
Take the information of a certain tables of data, can not precise positioning to specific a certain cell data, even, using existing technological means
Contradiction be present between the data inquired.
Data how are carried out accurately and fast to trace to the source, and precise positioning cell data, are that those skilled in the art need solution badly
Certainly the problem of.
The content of the invention
For in the prior art the defects of, the present invention provide data source tracing method and device based on data warehouse, can
Accurately and fast carry out data to trace to the source, precise positioning cell data.
In a first aspect, the present invention provides a kind of data source tracing method based on data warehouse, this method includes：Acquisition is traced to the source
Request, request of tracing to the source include user's mark to be checked and attribute；
In the data warehouse of prebuild, traced to the source according to user's mark or attribute, positioning unit lattice, and acquiring unit
Information in lattice, and the information source of the associated storage of cell and renewal time.
Further, before being traced to the source according to user's mark or attribute, this method also includes：
Attributive analysis is carried out to the information of pre-acquiring, obtains the attribute of every information；
According to the attribute of information, by the cell of every information separate storage to atomic layer；
By the information source of every information of pre-acquiring and renewal time associated storage to this information atomic layer list
First lattice；
The information of every attribute is integrated, obtains and integrates information, and stored information is integrated to the unit of conformable layer
Lattice；
By the information source of integration information and renewal time associated storage to this information in the cell of conformable layer, data
Warehouse includes atomic layer and conformable layer.
Further, traced to the source according to user's mark or attribute, positioning unit lattice, and the information in acquiring unit lattice,
Specifically include：
Traced to the source according to user's mark or attribute in the conformable layer of data warehouse, the cell of positioning integration layer, and obtain
Take the information of cell；
Or traced to the source according to user's mark or attribute in the atomic layer of data warehouse, the cell of atomic layer is positioned, and
The information of acquiring unit lattice.
Further, after obtaining request of tracing to the source, traced to the source according to user's mark or attribute, before positioning unit lattice,
This method also includes：
According to the granularity of query for request of tracing to the source, it is determined that level to be traced to the source in data warehouse；
Traced to the source, positioning unit lattice, specifically included according to user's mark or attribute：
If level to be traced to the source is conformable layer, traced back according to user's mark or attribute in the conformable layer of data warehouse
Source, the cell of positioning integration layer；
If level to be traced to the source is atomic layer, traced back according to user's mark or attribute in the atomic layer of data warehouse
Source, position the cell of atomic layer.
Based on the above-mentioned data source tracing method embodiment arbitrarily based on data warehouse, further, according to user's mark or
Attribute is traced to the source, positioning unit lattice, and obtains the information in the cell, is specifically included：
Traced to the source according to user's mark, obtain the information associated with user mark；
According to the associated information of attribute and user's mark, positioning unit lattice, and the information in acquiring unit lattice；
Or traced to the source according to attribute, obtain the information of the attribute；
According to user's mark and the information of the attribute, positioning unit lattice, and the information in acquiring unit lattice.
Further, the information of every attribute is integrated, obtains and integrate information, specifically include：
According to the integration rules being pre-configured with, the information of every attribute is integrated, obtains and integrates information.
Further, after the information in acquiring unit lattice, this method also includes：
Information in verification unit lattice, obtain assay；
According to assay, integration rules are corrected.
Second aspect, the present invention provide a kind of data based on data warehouse and traced to the source device, and the device includes acquisition request
Module and trace to the source module, acquisition request module is used for acquisition and traced to the source request, and request of tracing to the source includes user to be checked and identifies and belong to
Property；Module of tracing to the source is used in the data warehouse of prebuild, is traced to the source according to user's mark or attribute, positioning unit lattice, and
Information in acquiring unit lattice, and the information source of the associated storage of cell and renewal time.
Further, data of the present embodiment based on data warehouse trace to the source device data warehouse specifically include atomic layer and
Conformable layer, atomic layer are used to carry out attributive analysis to the information of pre-acquiring, obtain the attribute of every information；According to the category of information
Property, by the cell of every information separate storage to atomic layer；By the information source of every information of pre-acquiring and renewal time
Associated storage to this information atomic layer cell；Conformable layer is used to integrate the information of every attribute, obtains whole
Information is closed, and is stored information is integrated to the cell of conformable layer；The information source for integrating information is associated with renewal time and deposited
Store up to this information conformable layer cell.
Further, module of tracing to the source is identified according to user or attribute is traced to the source, positioning unit lattice, and in acquiring unit lattice
Information when, be specifically used for：Traced to the source according to user's mark or attribute in the conformable layer of data warehouse, the list of positioning integration layer
First lattice, and the information of acquiring unit lattice；Or traced to the source according to user's mark or attribute in the atomic layer of data warehouse, positioning is former
The cell of sublayer, and the information of acquiring unit lattice.
As shown from the above technical solution, the data source tracing method and device based on data warehouse that the present embodiment provides,
In advance specifying information, the information source of the associated storage information and renewal time are stored in the cell of structure data warehouse.
When progress data are traced to the source, traced to the source according to user's mark to be checked and attribute, precise positioning cell, you can obtain specific
Information, information source and renewal time.
Therefore, data source tracing method and device of the present embodiment based on data warehouse, can accurately and fast carry out data
Trace to the source, precise positioning cell data, provide the user reliable Query Result.
Brief description of the drawings
, below will be to specific in order to illustrate more clearly of the specific embodiment of the invention or technical scheme of the prior art
The required accompanying drawing used is briefly described in embodiment or description of the prior art.In all of the figs, similar element
Or part is typically identified by similar reference.In accompanying drawing, each element or part might not be drawn according to the ratio of reality.
Fig. 1 shows a kind of flow chart of data source tracing method based on data warehouse provided by the present invention；
Fig. 2 shows that a kind of data based on data warehouse provided by the present invention are traced to the source the structured flowchart of device.
Embodiment
The embodiment of technical solution of the present invention is described in detail below in conjunction with accompanying drawing.Following examples are only used for
Clearly illustrate technical scheme, therefore be intended only as example, and the protection of the present invention can not be limited with this
Scope.
It should be noted that unless otherwise indicated, technical term or scientific terminology used in this application should be this hair
The ordinary meaning that bright one of ordinary skill in the art are understood.
In a first aspect, a kind of data source tracing method based on data warehouse that the embodiment of the present invention is provided, with reference to Fig. 1,
This method includes：
Step S1：Acquisition is traced to the source request, and request of tracing to the source includes user to be checked and identified and attribute.For example, user identifies
Can be the identification card number of user to be checked, attribute can be the information such as the marital status of the user, academic situation.
Step S2：In the data warehouse of prebuild, traced to the source according to user's mark or attribute, positioning unit lattice, and
Information in acquiring unit lattice, and the information source of the associated storage of cell and renewal time.
As shown from the above technical solution, the data source tracing method based on data warehouse that the present embodiment provides, in advance structure
Build in the cell of data warehouse and store specifying information, the information source of the associated storage information and renewal time.Entering line number
During according to tracing to the source, traced to the source according to user's mark to be checked and attribute, precise positioning cell, you can acquisition specifying information,
Information source and renewal time.
Therefore, data source tracing method of the present embodiment based on data warehouse, data can accurately and fast be carried out and traced to the source,
Precise positioning cell data, provide the user reliable Query Result.
In order to further improve the accuracy of data source tracing method of the present embodiment based on data warehouse, specifically, in number
In terms of information storage according to warehouse, before being traced to the source according to user's mark or attribute, this method can also：
Attributive analysis is carried out to the information of pre-acquiring, obtains the attribute of every information.
According to the attribute of information, by the cell of every information separate storage to atomic layer.
By the information source of every information of pre-acquiring and renewal time associated storage to this information atomic layer list
First lattice.
The information of every attribute is integrated, obtains and integrates information, and stored information is integrated to the unit of conformable layer
Lattice.
By the information source of integration information and renewal time associated storage to this information in the cell of conformable layer, data
Warehouse includes atomic layer and conformable layer.
For example, for the marriage attribute of a certain user, the user is stored in the marriage change information of different time node
To atomic layer, and the information source of every marriage change information of associated storage.
According to the information source of every information or renewal time, the user is integrated on the information of marital status,
Formed and integrate information, the i.e. current marital status of the user, and be updated to conformable layer.
Here, the atomic layer of data warehouse can store a plurality of information of every attribute, the conformable layer of data warehouse side by side
The information of every attribute can be integrated, eliminate information ambiguity, determine the unique states of the attribute, be easy to user to carry out
Varigrained data are traced to the source.
Specifically, in terms of the information source tracing of data warehouse, traced to the source according to user's mark or attribute, positioning unit
Lattice, and during information in acquiring unit lattice, specific implementation process is as follows：
Traced to the source according to user's mark or attribute in the conformable layer of data warehouse, the cell of positioning integration layer, and obtain
Take the information of cell.
Or traced to the source according to user's mark or attribute in the atomic layer of data warehouse, the cell of atomic layer is positioned, and
The information of acquiring unit lattice.
Traced back here, data source tracing method of the present embodiment based on data warehouse can carry out data from conformable layer or atomic layer
Source, using user's mark or attribute, precise positioning cell, so as to obtain accurate, comprehensive information, specific letter such as to be traced to the source
Breath, information source and renewal time, user is facilitated to inquire about.
Also, data source tracing method of the present embodiment based on data warehouse can combine granularity of query, inquired about, that is, obtained
After taking request of tracing to the source, traced to the source according to user's mark or attribute, before positioning unit lattice, this method can also be according to tracing to the source
The granularity of query of request, it is determined that level to be traced to the source in data warehouse.For example, for certain user mark marriage attribute and
Speech, request of tracing to the source can be the current marital status or all marriage change information of the user of the user, both
Granularity of query is different.It can be obtained for current marital status information from conformable layer, and can for all marriage change informations
To be obtained from atomic layer.
Traced to the source according to user's mark or attribute, during positioning unit lattice, specific implementation process is as follows：
If level to be traced to the source is conformable layer, traced back according to user's mark or attribute in the conformable layer of data warehouse
Source, the cell of positioning integration layer.
If level to be traced to the source is atomic layer, traced back according to user's mark or attribute in the atomic layer of data warehouse
Source, position the cell of atomic layer.
Here, data source tracing method of the present embodiment based on data warehouse, can be positioned at according to the granularity of query of user
Level to be traced to the source in data warehouse, further according to user's mark and attribute fast positioning cell, the information of acquiring unit lattice.
Specifically, in terms of the information source tracing of data warehouse, traced to the source according to user's mark or attribute, positioning unit
Lattice, and when obtaining the information in the cell, specific implementation process is as follows：
Traced to the source according to user's mark, obtain the information associated with user mark.
According to the associated information of attribute and user's mark, positioning unit lattice, and the information in acquiring unit lattice.
Or traced to the source according to attribute, obtain the information of the attribute.
According to user's mark and the information of the attribute, positioning unit lattice, and the information in acquiring unit lattice.
Here, data source tracing method of the present embodiment based on data warehouse, can be identified according to user, obtain and marked with user
Know associated information, or the attribute according to certain information, obtain the information of the attribute, be easy to user to carry out letter from different dimensions
Breath inquiry.Meanwhile this method is identified using user and attribute, you can the cell of precise positioning request to be traced to the source, is that user is anti-
Present accurate information.
Specifically, in terms of the information integration of data warehouse, the information of every attribute is integrated, obtains and integrates information
When, specific implementation process is as follows：
According to the integration rules being pre-configured with, the information of every attribute is integrated, obtains and integrates information.
For example, the integration rules being pre-configured with can be：
Integrated according to the weight of the information source of every information.The a plurality of information stored side by side for same attribute
For, if the weight of the information source of a certain bar information is more than the weight of the information source of other information, this information is set
It is set to the integration information of the attribute.
The integration rules being pre-configured with can also be：
Integrated according to the renewal time of every information.For a plurality of information that same attribute stores side by side,
If the renewal time of a certain bar information is the newest time, this information is arranged to the integration information of the attribute.
Here, data source tracing method of the present embodiment based on data warehouse uses integration rules, to the information of every attribute
Integrated, to eliminate the ambiguity of information, determine the unique states of the attribute.
Also, after the information in acquiring unit lattice, information that this method can also be in verification unit lattice obtains and examines knot
Fruit.According to assay, integration rules are corrected.
For example, assay can be user to be checked confirm after result, if most users feedback according to renewal
The integration information that time determines is correct, then other integration rules is excluded, using newest renewal time as integration rules.If
The integration information that most users feedback determines according to the weight of information source is correct, then other integration rules is excluded, using letter
The weight in source is ceased as integration rules.
Here, data source tracing method of the present embodiment based on data warehouse optimizes and combines rule according to assay, improve
The accuracy of information integration, it is easy to provide the user accurate information.
Second aspect, the embodiment of the present invention provides a kind of data based on data warehouse and traced to the source device, with reference to Fig. 2, the dress
Put including acquisition request module 1 and trace to the source module 2, acquisition request module 1 is used for acquisition and traced to the source request, and tracing to the source, it is to be checked to ask to include
The user's mark and attribute of inquiry.Module of tracing to the source 2 is used in the data warehouse of prebuild, is traced back according to user's mark or attribute
Source, positioning unit lattice, and the information in acquiring unit lattice, and the information source of the associated storage of cell and renewal time.
As shown from the above technical solution, the data based on data warehouse that the present embodiment provides are traced to the source device, in advance structure
Build in the cell of data warehouse and store specifying information, the information source of the associated storage information and renewal time.Entering line number
During according to tracing to the source, traced to the source according to user's mark to be checked and attribute, precise positioning cell, you can acquisition specifying information,
Information source and renewal time.
Therefore, data of the present embodiment based on data warehouse are traced to the source device, can accurately and fast be carried out data and be traced to the source,
Precise positioning cell data, provide the user reliable Query Result.
Traced to the source the accuracy of device to further improve data of the present embodiment based on data warehouse, specifically, in number
In terms of information storage according to warehouse, data warehouse specifically includes atomic layer and conformable layer, and atomic layer is used for the information to pre-acquiring
Attributive analysis is carried out, obtains the attribute of every information；According to the attribute of information, by the list of every information separate storage to atomic layer
First lattice；By the information source of every information of pre-acquiring and renewal time associated storage to this information atomic layer unit
Lattice.Conformable layer is used to integrate the information of every attribute, obtains and integrates information, and is stored information is integrated to conformable layer
Cell；By integrate information information source and renewal time associated storage to this information conformable layer cell.
Here, the atomic layer of data warehouse can store a plurality of information of every attribute, the conformable layer of data warehouse side by side
The information of every attribute can be integrated, eliminate information ambiguity, determine the unique states of the attribute, be easy to user to carry out
Varigrained data are traced to the source.
Specifically, in terms of the information source tracing of data warehouse, module of tracing to the source 2 is identified according to user or attribute is traced to the source,
Positioning unit lattice, and during information in acquiring unit lattice, be specifically used for：According to user mark or attribute data warehouse integration
Layer is traced to the source, the cell of positioning integration layer, and the information of acquiring unit lattice；Or according to user's mark or attribute in data bins
The atomic layer in storehouse is traced to the source, and positions the cell of atomic layer, and the information of acquiring unit lattice.
Here, data of the present embodiment based on data warehouse are traced to the source, device can trace back from conformable layer or atomic layer progress data
Source, using user's mark or attribute, precise positioning cell, so as to obtain accurate, comprehensive information, specific letter such as to be traced to the source
Breath, information source and renewal time, user is facilitated to inquire about.
In the description of this specification, reference term " one embodiment ", " some embodiments ", " example ", " specifically show
The description of example " or " some examples " etc. means specific features, structure, material or the spy for combining the embodiment or example description
Point is contained at least one embodiment or example of the present invention.In this manual, to the schematic representation of above-mentioned term not
Identical embodiment or example must be directed to.Moreover, specific features, structure, material or the feature of description can be with office
Combined in an appropriate manner in one or more embodiments or example.In addition, in the case of not conflicting, the skill of this area
Art personnel can be tied the different embodiments or example and the feature of different embodiments or example described in this specification
Close and combine.
It should be noted that the flow chart and block diagram in accompanying drawing show the service of multiple embodiments according to the present invention
Architectural framework in the cards, function and the operation of device, method and computer program product.At this point, flow chart or block diagram
In each square frame can represent the part of a module, program segment or code, the module, one of program segment or code
Subpackage is containing one or more executable instructions for being used to realize defined logic function.It should also be noted that at some as replacement
Realization in, the function that is marked in square frame can also be to occur different from the order marked in accompanying drawing.For example, two continuous
Square frame can essentially perform substantially in parallel, they can also be performed in the opposite order sometimes, and this is according to involved work(
Depending on energy.It is also noted that each square frame and block diagram in block diagram and/or flow chart and/or the square frame in flow chart
Combination, function or the special hardware based server of action it can be realized as defined in execution, or can be with special
The combination of hardware and computer instruction is realized.
The configuration device that the embodiment of the present invention is provided can be computer program product, including store program code
Computer-readable recording medium, the instruction that described program code includes can be used for performing the side described in previous methods embodiment
Method, specific implementation can be found in embodiment of the method, will not be repeated here.
It is apparent to those skilled in the art that for convenience and simplicity of description, the service of foregoing description
The specific work process of device, device and unit, the corresponding process in preceding method embodiment is may be referred to, will not be repeated here.
In several embodiments provided herein, it should be understood that disclosed server, apparatus and method, can
To realize by another way.Device embodiment described above is only schematical, for example, the unit is drawn
Point, only a kind of division of logic function, there can be other dividing mode when actually realizing, in another example, multiple units or group
Part can combine or be desirably integrated into another server, or some features can be ignored, or not perform.It is another, show
Show or the mutual coupling discussed or direct-coupling or communication connection can be by some communication interfaces, device or unit
INDIRECT COUPLING or communication connection, can be electrical, mechanical or other forms.
The unit illustrated as separating component can be or may not be physically separate, show as unit
The part shown can be or may not be physical location, you can with positioned at a place, or can also be published to multiple
On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs
's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, can also
That unit is individually physically present, can also two or more units it is integrated in a unit.
If the function is realized in the form of SFU software functional unit and is used as independent production marketing or in use, can be with
It is stored in a computer read/write memory medium.Based on such understanding, technical scheme is substantially in other words
The part to be contributed to prior art or the part of the technical scheme can be embodied in the form of software product, the meter
Calculation machine software product is stored in a storage medium, including some instructions are causing a computer equipment (can be
People's computer, server, or network equipment etc.) perform all or part of step of each embodiment methods described of the present invention.
And foregoing storage medium includes：USB flash disk, mobile hard disk, read-only storage (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), magnetic disc or CD etc. are various can be with the medium of store program codes.
Finally it should be noted that：Various embodiments above is merely illustrative of the technical solution of the present invention, rather than its limitations；To the greatest extent
The present invention is described in detail with reference to foregoing embodiments for pipe, it will be understood by those within the art that：Its according to
The technical scheme described in foregoing embodiments can so be modified, either which part or all technical characteristic are entered
Row equivalent substitution；And these modifications or replacement, the essence of appropriate technical solution is departed from various embodiments of the present invention technology
The scope of scheme, it all should cover among the claim of the present invention and the scope of specification.
Claims (10)
- A kind of 1. data source tracing method based on data warehouse, it is characterised in that including：Acquisition is traced to the source request, and the request of tracing to the source includes user to be checked and identified and attribute；In the data warehouse of prebuild, traced to the source according to user mark or the attribute, positioning unit lattice, and obtain Information in the cell, and the information source of the associated storage of the cell and renewal time.
- 2. the data source tracing method based on data warehouse according to claim 1, it is characterised in thatBefore being traced to the source according to user mark or the attribute, this method also includes：Attributive analysis is carried out to the information of pre-acquiring, obtains the attribute of every information；According to the attribute of information, by the cell of every information separate storage to atomic layer；By the information source of every information of pre-acquiring and renewal time associated storage to this information atomic layer cell；The information of every attribute is integrated, obtains and integrates information, and the integration information is stored to the unit of conformable layer Lattice；By it is described integration information information source and renewal time associated storage to this information conformable layer cell, it is described Data warehouse includes the atomic layer and the conformable layer.
- 3. the data source tracing method based on data warehouse according to claim 2, it is characterised in that identified according to the user Or the attribute is traced to the source, positioning unit lattice, and the information in the cell is obtained, specifically include：Traced to the source according to user mark or the attribute in the conformable layer of the data warehouse, the unit of positioning integration layer Lattice, and obtain the information of the cell；Or traced to the source according to user mark or the attribute in the atomic layer of the data warehouse, position the list of atomic layer First lattice, and obtain the information of the cell.
- 4. the data source tracing method based on data warehouse according to claim 3, it is characterised in thatTrace to the source described in acquisition after request, traced to the source according to user mark or the attribute, should before positioning unit lattice Method also includes：According to the granularity of query of the request of tracing to the source, it is determined that level to be traced to the source in data warehouse；Traced to the source, positioning unit lattice, specifically included according to user mark or the attribute：If level to be traced to the source is conformable layer, according to the user mark or the attribute the data warehouse conformable layer Traced to the source, the cell of positioning integration layer；If level to be traced to the source is atomic layer, according to the user mark or the attribute the data warehouse atomic layer Traced to the source, position the cell of atomic layer.
- 5. the data source tracing method based on data warehouse according to claim 1, it is characterised in thatTraced to the source according to user mark or the attribute, positioning unit lattice, and the information in the cell is obtained, specifically Including：Traced to the source according to user mark, obtain the information associated with user mark；According to the associated information of the attribute and user mark, the cell is positioned, and obtain in the cell Information；Or traced to the source according to the attribute, obtain the information of the attribute；According to user mark and the information of the attribute, the cell is positioned, and obtain the information in the cell.
- 6. the data source tracing method based on data warehouse according to claim 2, it is characterised in thatThe information of every attribute is integrated, obtains and integrates information, specifically include：According to the integration rules being pre-configured with, the information of every attribute is integrated, obtains and integrates information.
- 7. the data source tracing method based on data warehouse according to claim 6, it is characterised in thatAfter obtaining the information in the cell, this method also includes：The information in the cell is examined, obtains assay；According to the assay, the integration rules are corrected.
- The device 8. a kind of data based on data warehouse are traced to the source, it is characterised in that including：Acquisition request module：For obtaining request of tracing to the source, the request of tracing to the source includes user's mark to be checked and attribute；Trace to the source module：For in the data warehouse of prebuild, being traced to the source, being positioned according to user mark or the attribute Cell, and the information in the cell is obtained, and the information source of the associated storage of the cell and renewal time.
- 9. the data based on data warehouse are traced to the source device according to claim 8, it is characterised in thatThe data warehouse, is specifically included：Atomic layer：For carrying out attributive analysis to the information of pre-acquiring, the attribute of every information is obtained；According to the attribute of information, By the cell of every information separate storage to atomic layer；The information source of every information of pre-acquiring is associated with renewal time Store to this information atomic layer cell；Conformable layer：For being integrated to the information of every attribute, obtain and integrate information, and the integration information is stored to whole Close the cell of layer；By it is described integration information information source and renewal time associated storage to this information conformable layer list First lattice.
- 10. the data based on data warehouse are traced to the source device according to claim 9, it is characterised in thatThe module of tracing to the source, traced to the source according to user mark or the attribute, positioning unit lattice, and obtain the unit During information in lattice, it is specifically used for：Traced back according to user mark or the attribute in the conformable layer of the data warehouse Source, the cell of positioning integration layer, and obtain the information of the cell；Or according to user mark or the attribute in institute The atomic layer for stating data warehouse is traced to the source, and positions the cell of atomic layer, and obtains the information of the cell.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710897207.7A CN107609171A (en) | 2017-09-28 | 2017-09-28 | Data source tracing method and device based on data warehouse |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710897207.7A CN107609171A (en) | 2017-09-28 | 2017-09-28 | Data source tracing method and device based on data warehouse |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107609171A true CN107609171A (en) | 2018-01-19 |
Family
ID=61059059
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710897207.7A Pending CN107609171A (en) | 2017-09-28 | 2017-09-28 | Data source tracing method and device based on data warehouse |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107609171A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109783515A (en) * | 2019-01-25 | 2019-05-21 | 上海创景信息科技有限公司 | More relation data tracks retroactive method and system based on database |
| CN112199352A (en) * | 2020-10-14 | 2021-01-08 | 武汉第二船舶设计研究所(中国船舶重工集团公司第七一九研究所) | Product data tracing method and system |
-
2017
- 2017-09-28 CN CN201710897207.7A patent/CN107609171A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109783515A (en) * | 2019-01-25 | 2019-05-21 | 上海创景信息科技有限公司 | More relation data tracks retroactive method and system based on database |
| CN112199352A (en) * | 2020-10-14 | 2021-01-08 | 武汉第二船舶设计研究所(中国船舶重工集团公司第七一九研究所) | Product data tracing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110292775B (en) | Method and device for acquiring difference data | |
| US10452625B2 (en) | Data lineage analysis | |
| CN107688591B (en) | A kind of actuarial treating method and apparatus | |
| CN104112026B (en) | A kind of short message text sorting technique and system | |
| EP3218811B1 (en) | Testing insecure computing environments using random data sets generated from characterizations of real data sets | |
| Jeevalatha et al. | Performance analysis of undergraduate students placement selection using decision tree algorithms | |
| CN105894183A (en) | Project evaluation method and apparatus | |
| CN109165326A (en) | A kind of character string matching method and device | |
| CN110110035A (en) | Data processing method and device and computer readable storage medium | |
| CN107480205A (en) | A kind of method and apparatus for carrying out data partition | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN112634056A (en) | Method, equipment and storage medium for rapidly calculating and updating enterprise share right structure | |
| CN110837568A (en) | Entity alignment method and device, electronic equipment and storage medium | |
| CN111913936A (en) | Relate to multi-field traceability system | |
| CN109690571A (en) | Group echo system and method based on study | |
| CN114612194A (en) | Product recommendation method and device, electronic equipment and storage medium | |
| CN107609171A (en) | Data source tracing method and device based on data warehouse | |
| CN111639077A (en) | Data management method and device, electronic equipment and storage medium | |
| CN114862140A (en) | Behavior analysis-based potential evaluation method, device, equipment and storage medium | |
| CN106599291A (en) | Method and device for grouping data | |
| CN111325255B (en) | Specific crowd delineating method and device, electronic equipment and storage medium | |
| CN115860835A (en) | Advertisement recommendation method, device and equipment based on artificial intelligence and storage medium | |
| CN114968816A (en) | Data simulation-based strategy testing method, device, equipment and storage medium | |
| CN114238768A (en) | Information pushing method and device, computer equipment and storage medium | |
| CN113516205A (en) | Data classification method, device, equipment and storage medium based on artificial intelligence |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180119 |
|
| RJ01 | Rejection of invention patent application after publication |