APPARATUS AND METHOD FOR FORMING DATABASE TABLES FROM QUERIES

• US 20090193004A1
• Filed: 01/30/2008
• Published: 07/30/2009
• Est. Priority Date: 01/30/2008
• Status: Abandoned Application

• Current Assignee: SAP France SA (SAP SE)
• Original Assignee: Business Objects SA (SAP SE)
• Inventors: Reynolds, Richard Thomas JR., Meiniel, Philippe, Naibo, Alexis-Jean Laurent
• Application Number:
  US12/022,970
• Publication Number:
  US 20090193004A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/243 Natural language query formulation

Abstract

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.

Claims

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.