APPARATUS AND METHOD FOR ANALYZING RELATIONSHIPS BETWEEN MULTIPLE SOURCE DATA OBJECTS
A computer readable storage medium includes executable instructions to receive a data hierarchy. Data relationships across multiple data sources are specified. Multiple source object relationships are identified. The multiple source object relationships are assessed.
1 . A computer readable storage medium, comprising executable instructions to:
receive a data hierarchy;
specify data relationships across multiple data sources;
identify multiple source object relationships; and
assess the multiple source object relationships.
2 . The computer readable storage medium of claim 1 wherein the data hierarchy specifies a database, catalog, schema, table and columns.
3 . The computer readable storage medium of claim 1 wherein the executable instructions to specify data relationships include executable instructions to specify hierarchically equivalent objects.
4 . The computer readable storage medium of claim 3 wherein the executable instructions to specify data relationships include executable instructions to specify a complete hierarchy of hierarchically equivalent objects.
5 . The computer readable storage medium of claim 3 wherein the executable instructions to specify data relationships include executable instructions to specify a segment of a hierarchy with hierarchically equivalent objects.
6 . The computer readable storage medium of claim 3 wherein the executable instructions to specify hierarchically equivalent objects include executable instructions to specify case sensitive equivalent objects.
7 . The computer readable storage medium of claim 3 wherein the executable instructions to specify hierarchically equivalent objects include executable instructions to specify case insensitive equivalent objects.
8 . The computer readable storage medium of claim 1 wherein the executable instructions to specify hierarchically equivalent objects include executable instructions to specify metadata relationships.
9 . The computer readable storage medium of claim 8 further comprising executable instructions to access metadata from a repository.
10 . The computer readable storage medium of claim 1 wherein the executable instructions to specify data relationships across multiple data sources include executable instructions to specify data relationships between at least two data sources selected from a relational database, an Online Analytical Processing (OLAP) database, a modeling tool, an Extraction Transform Load (ETL) tool, and a Business Intelligence (BI) tool.
11 . The computer readable storage medium of claim 1 wherein the executable instructions to specify data relationships across multiple data sources include executable instructions to equate common objects with different metadata descriptors.
12 . The computer readable storage medium of claim 1 wherein the executable instructions to specify data relationships across multiple data sources include executable instructions to specify the highest common hierarchal level across all data sources.
13 . The computer readable storage medium of claim 1 wherein the executable instructions to receive a data hierarchy include executable instructions to receive an associated context.
14 . The computer readable storage medium of claim 1 wherein the executable instructions to receive a data hierarchy include executable instructions to receive a context selected from a database context, a system context and any context.