Data management system and data management method
AssigneeHitachi, Ltd.
InventorsKeiko Tanigawa, Toshihiko Kashiyama, Jumpei Okoshi
Life of this patent
Estimating the term…
Abstract
A data management system includes a processor. An estimated ETL level mapping processing unit is operated on the processor to estimate existence of unregistered ETL that is ETL not registered in a repository, to calculate a degree of similarity based on matching between an existing data model and retained data, and to extract a column to be a candidate based on the degree of similarity. The existence of the unregistered ETL is estimated by estimating the presence or absence of connectedness in the ETLs on the basis of correspondence between input data and output data in ETLs by using an execution ETL log relevant to an execution history of the ETL.
Claims11
A data management system supporting reuse of a data model by accumulating ETL relevant to an existing data model in a repository, the system comprising:
- a processor,
- wherein an estimated ETL level mapping processing unit is operated on the processor to estimate existence of unregistered ETL that is ETL not registered in the repository, to calculate a degree of similarity based on matching between the existing data model and retained data, and to extract a column to be a candidate for reuse based on the degree of similarity, and
- the estimated ETL level mapping processing unit estimates the presence or absence of connectedness in the ETLs on the basis of correspondence between input data and output data in the ETLs by using an execution ETL log relevant to an execution history of the ETL to estimate the existence of the unregistered ETL.
A data management method using an electronic computer supporting reuse of a data model by accumulating ETL relevant to an existing data model in a repository, the method comprising:
- estimating existence of unregistered ETL that is ETL not registered in the repository, calculating a degree of similarity based on matching between the existing data model and retained data, and extracting a column to be a candidate for reuse based on the degree of similarity;
- and
- estimating the presence or absence of connectedness in the ETLs on the basis of correspondence between input data and output data in the ETLs by using an execution ETL log relevant to an execution history of the ETL to estimate the existence of the unregistered ETL.
Dependencies are inferred from the claim text.