Method and apparatus for creating a lineage of a data field in a data flow system
AssigneeGroup 1 Software, Inc.
InventorsCraig R. Powers, Vladimir Gorelik
Life of this patent
Estimating the term…
Abstract
A method and apparatus for creating a lineage for a data field is disclosed. The method may include creating a unique identifier for a data field. Also, a record of the origin of data is created when the data is inserted into the data field; however this is not required. The record of the origin of data is associated with the unique identifier for the data field. The lineage for the data field may be viewed. In so doing, the transformations to the data field may be shown.
Claims8
A computer apparatus of creating a lineage for a data field comprising:
- means for a processor;
- means for creating a unique identifier for the data field;
- means for creating a record of data origin when the data is inserted into the data field, the record of data origin identifying a data access query to retrieve the data from a database;
- means for creating a record of transformations that are applied to the data in the data field;
- means for associating the record of the origin of data and the record of transformations with the unique identifier for the data field;
- and
- means for displaying, in response to a user on-screen selection of the data in the data field, a list of processing steps applied to the data in the data field using the unique identifier, the list of processing steps including one or more of a plurality of steps beginning with a data source step associated with the record of data origin and ending with a data viewing step.
A computer readable medium containing instructions which, when executed in a processing system, cause the system to:
- create a unique identifier for the data field;
- create a record of the data origin when the data is inserted into the data field, the record of data origin identifying a data access query to retrieve the data from a database;
- create a record of transformations that are applied to the data in the data field;
- associate the record of the origin of data and the record of transformations with the unique identifier for the data field;
- and
- display, in response to a user on-screen selection of the data in the data field, a list of processing steps applied to the data in the data field using the unique identifier, the list of processing steps including one or more of a plurality of steps beginning with a data source step associated with the record of data origin and ending with a data viewing step.
A computer-implemented method of creating a lineage for a data field in a data processing system, comprising the steps of:
- recording data origin information defining a data access query used to retrieve data from a database;
- creating a record of transformations that are applied to data from the database to produce data in the data field;
- defining a unique identifier for the data field associated with said data origin information and said record of transformations;
- receiving a user on-screen selection of data in the data field using the unique identifier;
- and
- in response to said user on-screen selection, displaying a list of processing steps applied to the data in the data field;
- wherein the list of processing steps includes one or more steps beginning with a data source step associated with the data origin information and ending with a data viewing step.
Dependencies are inferred from the claim text.