Patent ID: 7734576

Claim:
A computer readable storage medium storing executable instructions to graphically represent one or more relationships between data source tables, the executable instructions executed by a processor to: receive a selection of multiple data source tables from one or more data sources used to populate a data warehouse; determine a data source table, from the selection of multiple data source tables, that defines keys; receive mapping information that defines one or more column relationships between the data source table and a second data source table from the selection of multiple data source tables; analyze relationship structures of the selection of multiple data source tables based on the mapping information; determine a longest path from the data source table to one of the selection of multiple data source tables; and graphically represent the selection of multiple data source tables and the relationship structures in a sequential order, where the sequential order in which the selection of multiple data source tables are depicted is based on the longest path, thereby creating a visualization of dependencies between the multiple data source tables that supply data to the data warehouse.