Relational database access system using semantically dynamic objects

• US 5,555,403 A
• Filed: 11/27/1991
• Issued: 09/10/1996
• Est. Priority Date: 11/27/1991
• Status: Expired due to Term

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects SA (SAP SE)
• Inventors: Liautaud, Bernard, Cambot, Jean-Michel
• Primary Examiner(s): Kulik, Paul V.
• Application Number:
  US07/800,506
• Time in Patent Office: 1,749 Days
• Field of Search: 395/600, 395/12, 395/54, 395/62, 395/63, 395/925, 364/419.19, 364/401
• 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: 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
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

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 method for accessing values in a relational database, wherein the relational database operates in a computer system and provides returned values responsive to queries specified in a predefined query language, wherein the relational database supports the use of functions and operators to perform operations on values within the database, wherein the relational database includes a plurality of tables, wherein each table is associated with one or more attributes, wherein each attribute has a set of values, wherein the method includes a user interface executing on a computer system operated by a human user, wherein the computer system executing the user interface includes a processor coupled to a memory, wherein the processor is further coupled to the user interface and the relational database, the method comprising the following steps:

associating a first familiar name with a first returned value, wherein the familiar name is also associated with the following;

a SELECT clause describing the values returned using a combination of the functions and operators supported by the predefined query language;

a WHERE clause describing a condition which can be used to restrict the scope of the returned value; and

a plurality of tables containing the attributes on which the SELECT and WHERE clauses operate;

accepting signals from the user interface to specify a query, wherein the query includes the familiar name;

generating a query in the predefined query language, wherein the query includes the condition; and

using the query to access one or more attributes in the relational database.

2. The method of claim 1, wherein the computer system includes query engine means for generating queries, wherein the relational database includes a plurality of tables, wherein each table includes attributes and values associated with the attributes, the method further comprising the following steps:

providing a selection of familiar names, wherein each familiar name is associated with one or more of the attributes in the relational database as described in claim 1;

accepting signals from the user interface to select first and second combinations of familiar names from the selection of familiar names;

generating, by using the query engine means, first and second queries based on first and second combinations, wherein the first and second combinations both include a same first familiar name but different additional familiar names, wherein the first query based on the first combination results in the retrieval of a first set of returned values based on the first familiar name, wherein the second query based on the second combination results in the retrieval of a second set of returned values based on the same first familiar name from the same database.

3. The method of claim 1, wherein the relational database includes a plurality of tables, wherein each table includes one or more attributes, wherein the attributes of the tables include values associated with the attributes, the method further comprising:

providing a selection of familiar names, wherein each familiar name is associated with one or more of the tables in the relational database, wherein a table is an array of data comprising rows and columns;

predefining a list of joins between tables in the relational database, wherein a join is a link between two tables such that two rows are linked if specified attributes on each table contain matching values;

storing the list of joins in the computer memory;

accepting signals from the user interface to select a plurality of familiar names from the selection of familiar names;

determining a list of tables associated with the selected plurality of familiar names;

determining a list of tables named in joins between the tables associated with the familiar names;

if all of tables in the list of tables match tables named in a join in the list of joins then performing the step of using the attributes from tables in the matching join to form a permissible query;

else if all of the table names in the list of tables match the table names-in more than one join in the list of joins then performing the steps of accepting signals from the user input device to select a preferred join from among the matching joins; and

using the attributes from tables in the preferred join to form a permissible query;

else if all tables in the list of tables do not match tables in any join in the list of joins then providing an error indication; and

using the permissible query to access values in the relational database.

4. A relational database access system comprising:

a computer system including a processor coupled to a memory;

a relational database including attributes, wherein the relational database is responsive to a query in a predefined query language for accessing the attributes in the relational database;

a user interface for allowing a human user to specify one or more familiar names in the form of a user query;

selection means coupled to the user interface for allowing the human user to select familiar names and to associate two or more familiar names together; and

query engine means for generating queries in the predetermined query language based on a given combination of two or more selected and associated familiar names, wherein the query engine means generates first and second queries based on first and second combinations, wherein the first and second combinations both include a same first familiar name but different additional familiar names, wherein the first query based on the first combination results in the retrieval of a first set of returned values based on the first familiar name, wherein the second query based on the second combination results in the retrieval of a second set of returned values based on the same first familiar name from the same database.

5. The relational database access system of claim 4, further comprising:

a plurality of tables, wherein each table includes one or more attributes, wherein the attributes include values associated with attributes;

a predefined list of joins stored in the computer memory, wherein a join is a linkage between two tables in the relational database such that rows from the two tables are linked if specified attributes on each table contain matching values;

a selection of familiar names, wherein each familiar name is associated with one or more tables in the relational database;

a means for the user to select a plurality of familiar names from the selection of familiar names;

a list of tables associated with the selected plurality of familiar names;

a list of tables associated with each join in the list of joins;

a means to identify the joins which contain all the tables in the list of tables associated with the selected plurality of familiar names;

a means to allow the user to select a preferred join if more than one join contains all the tables in the list of tables associated with the selected plurality of familiar names; and

a path, where the path is the list of tables associated with the selected join.

6. The system as in claim 5 wherein said query engine means includes means for generating joins representative of a path used to access data.

7. The system as in claim 6 wherein said query engine means includes means for testing the set of joins for multiple paths.

8. The system as in claim 7 wherein said query engine means includes means for selecting between multiple paths.

9. The system as in claim 8 wherein said query engine means includes means for generating a query on objects definition screen, which allows a user to define a query wherein the query includes a result object representative of information required by the user;

conditions, which represent restrictions to be used on the data; and

sorts, which represent the sorting of the returned data.

10. The system as in claim 9 wherein said query engine means include means for providing a result objects window to permit a user to construct a linear association of business objects.

11. The system as in claim 10 wherein said query engine means include means for providing a conditions window to permit a user to specify a list of conditions on any of the available objects.

12. The system as in claim 11 wherein said query engine means includes means for providing a sorts window to permit a user to introduce a sort on a list of objects.

13. The system as in claim 12 wherein said query engine means include means for generating a object selector window which provides a list of business objects of the current universe.

14. The system as in claim 13 including means for generating an initial list of tables involved in said query.

15. The system as in claim 14 including means for generating a final list of tables so as to determine a single path connecting all the tables in said initial list of tables using a list of joins.

16. The system as in claim 15 including means for generating a FROM clause by listing all the tables of said final list of tables.

17. The system as in claim 16 including means for generating a WHERE clause including the list of joins from the selected context that involved the tables of said final list of tables;

building the conditions on objects from said result objects windows;

building the conditions placed under the objects in the results objects window by converting it to its SQL equivalent statement; and

translating the objects and the operators used in the conditions window by their structured query language SQL equivalent statement.

18. The system as in claim 17 including means for generating a group by clause, including means for scanning the list of objects involved in the query on objects and using the concatenation of all the SQL equivalent statements present in the result objects and sort windows.

19. The system as in claim 18 including means for generating a having clause by translating the simple conditions placed on objects in the result objects windows into their SQL equivalent statement.

20. The system as in claim 19 including means for generating an order by clause by taking the sorts defined in the sorts window and replacing them by their SQL equivalent statement.