Apparatus and method for extracting database information from a report
A computer implemented method includes extracting query information from a report, generating database information characterizing table and column metadata for a data source, and analyzing the relationships between the query information and the database information to identify a table and column invoked by the report.
1 . A computer-readable medium to direct a computer to function in a specified manner, comprising executable instructions to:
extract query information from a report;
generate database information characterizing table and column metadata for a data source; and
analyze the relationships between the query information and the database information to identify a table and column invoked by the report.
2 . The computer-readable medium of claim 1 , wherein the executable instructions to extract include executable instructions to extract a Structured Query Language (SQL) statement from the report.
3 . The computer-readable medium of claim 1 , further comprising executable instructions to produce a table containing report dependencies on database tables and columns.
4 . The computer-readable medium of claim 1 , wherein the executable instructions to generate include executable instructions to extract metadata from multiple data warehouses.
5 . The computer-readable medium of claim 1 , wherein the executable instructions to generate include executable instructions to enhance database information to include database view information.
6 . The computer-readable medium of claim 1 , wherein the executable instructions to generate include executable instructions to enhance database information to include aliases.
7 . A computer implemented method of processing data, comprising:
extracting query information from a report;
generating database information characterizing table and column metadata for a data source; and
analyzing the relationships between the query information and the database information to identify a table and column invoked by the report.
8 . The method of claim 7 , wherein extracting includes extracting a Structured Query Language (SQL) statement from the report.
9 . The method of claim 7 , further comprising producing a table containing report dependencies on database tables and columns.
10 . The method of claim 7 , wherein generating includes extracting metadata from multiple data warehouses.
11 . The method of claim 7 , wherein generating includes enhancing database information to include database view information.
12 . The method of claim 7 , wherein generating includes enhancing database information to include aliases.