APPARATUS AND METHOD FOR FORMING DATABASE TABLES FROM QUERIES
A computer readable storage medium includes executable instructions to capture data access commands from a query module utilizing a semantic layer. The data access commands are processed to produce table specification instructions and data access instructions to facilitate the construction and population of a table.
1 . A computer readable storage medium, comprising executable instructions to:
capture data access commands from a query module utilizing a semantic layer; and
process the data access commands to produce table specification instructions and data access instructions to facilitate the construction and population of a table.
2 . The computer readable storage medium of claim 1 wherein the query module generates a Structured Query Language (SQL) expression defining data access commands.
3 . The computer readable storage medium of claim 2 wherein the query module processes a query against the table.
4 . The computer readable storage medium of claim 1 further comprising executable instructions to route the table specification instructions and data access instructions to an Extract, Transform and Load (ETL) tool.
5 . The computer readable storage medium of claim 4 wherein the ETL tool constructs and populates the table.
6 . The computer readable storage medium of claim 5 wherein the ETL tool constructs and populates an aggregate table.
7 . A computer readable storage medium, comprising:
a query module utilizing a semantic layer to process a query and generate data access commands;
a data access command processor to process the data access commands to produce table specification instructions and data access instructions; and
an Extract, Transform and load (ETL) tool to process the table specification instructions to create a table and process the data access instructions to populate the table.
8 . The computer readable storage medium of claim 7 wherein the query module generates a Structured Query Language (SQL) expression defining data access commands.
9 . The computer readable storage medium of claim 7 wherein the query module processes a query against the table.