Relational database access system using semantically dynamic objects

• US 7,899,810 B2
• Filed: 02/05/2007
• Issued: 03/01/2011
• Est. Priority Date: 11/27/1991
• Status: Expired due to Fees

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Liautaud, Bernard, Cambot, Jean-Michel
• Primary Examiner(s): Vo; Tim T.
• Assistant Examiner(s): TRAN, ANHTAI V
• Application Number:
  US11/671,449
• Publication Number:
  US 20070130136A1
• Time in Patent Office: 1,485 Days
• Field of Search: 707/713, 707/714, 707/716, 707/718, 707/999.2
• US Class Current: 707/713
• 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/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

A relational database access system and method provides a new data representation and a query technique which allows information system end users to access (query) relational databases without knowing the relational structure or the structure query language (SQL). The present invention utilizes semantically dynamic objects.

Claims

1. A hardware computer storage device with computer executable instructions for accessing a database, comprising executable instructions to:

present a user at a client computer with a set of business objects, wherein the business objects include familiar terms corresponding to information about the structure of the database;

receive a plurality of selected business objects;

generate a SQL query from the selected business objects, wherein the SQL query includes a SELECT clause and a FROM clause, wherein the selected business objects are associated with a selected context that includes a list of joins between tables that gives meaning to the selected business objects, wherein the selected context is chosen from several contexts applicable to the SQL query;

receive a condition used to restrict the scope of values returned from the database;

translate the condition into a WHERE clause in the SQL query;

transmit the SQL query to the database; and

receive a tabular result set.

2. The hardware computer storage device of claim 1 wherein the FROM clause includes a list of tables associated with selected business objects.

3. The hardware computer storage device of claim 1 further comprising executable instructions to:

define a list of joins between tables in the database to characterize a set of linked tables, wherein a join is a relational synchronization between tables;

add a union of the set of linked tables to the FROM clause if the set of linked tables is linked by one path;

add a union of the set of linked tables along a particular path defined by the selected context to the FROM clause if the set of linked tables are linked by multiple paths, wherein the selected context includes a set of joins including all of the tables in the set of linked tables; and

add a union of the set of linked tables arranged along all joins in the list of joins to the FROM clause if the set of linked tables is linked by multiple paths but no context exists.

4. The hardware computer storage device of claim 2 wherein the meaning given to the selected business objects by the selected context is established by a path without a loop between a first table and a second table in the list of tables.

5. The hardware computer storage device of claim 3 further comprising executable instructions to propose different contexts to a user.

6. The hardware computer storage device of claim 3 wherein the condition includes a set of elementary and linking logic, including:

a first elementary condition with a first condition business object, a first operator and a first operand,

a second elementary condition including a second condition business object, a second operator and a second operand; and

a complex combination linking the first elementary condition and the second elementary condition.

7. The hardware computer storage device of claim 6 wherein the executable instructions to translate the condition into a WHERE clause include executable instructions to:

generate a list of joins for the selected context linked by an AND operator; and

replace the set of elementary conditions and linking logic by SQL equivalents.

8. The hardware computer storage device of claim 6 further comprising executable instructions to perform data analysis on the tabular result set.

9. A hardware computer storage device with computer executable instructions for accessing a database, comprising executable instructions to:

present a user at a client computer with a set of business objects, wherein the business objects include familiar terms corresponding to information about the structure of the database;

receive a plurality of selected business objects;

generate a SQL query from the selected business objects, wherein the SQL query includes a SELECT clause and a FROM clause, wherein the FROM clause includes a list of tables associated with selected business objects;

receive a selection of a context from several contexts applicable to the SQL query;

wherein the selected context includes a list of joins between tables that give meaning to the selected business objects;

receive a condition used to restrict the scope of values returned from the database;

translate the condition into a WHERE clause in the SQL query; and

transmit the SQL query to the database.

10. The hardware computer storage device of claim 9 wherein the context gives meaning to the selected business objects.

11. The hardware computer storage device of claim 9 further comprising executable instructions to:

define a set of linked tables with the list of tables and the list of joins, wherein a join is a relational synchronization between tables;

add the set of linked tables to the FROM clause if the set of linked tables is linked by one path;

add the set of linked tables along a particular path defined by the selected context to the FROM clause if the set of linked tables are linked by multiple paths, wherein the context is a set of joins including all of the tables in the set of linked tables; and

add the set of linked tables arranged along all joins in the list of joins to the FROM clause if the set of linked tables is linked by multiple paths but no context exists.

12. The hardware computer storage device of claim 9 further comprising executable instructions to receive a tabular result set.

13. The hardware computer storage device of claim 11 further comprising executable instructions to propose a different context.

14. The hardware computer storage device of claim 11 wherein the condition includes a set of elementary and linking logic, including:

a first elementary condition with a first condition business object, a first operator and a first operand,

a second elementary condition including a second condition business object, a second operator and a second operand; and

a complex combination linking the first elementary condition and the second elementary condition.

15. The hardware computer storage device of claim 11 wherein the executable instructions to translate the condition into a WHERE clause include executable instructions to:

generate a list of joins for the selected context linked by an AND operator; and

replace the set of elementary conditions and linking logic by SQL equivalents.