Database access mechanisms for a computer user interface

• US 7,113,941 B2
• Filed: 09/27/2002
• Issued: 09/26/2006
• Est. Priority Date: 06/05/2002
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Eberleh, Edmund, Arend, Udo, Willumeit, Heinz
• Primary Examiner(s): Le, Uyen
• Assistant Examiner(s): Chen, Susan
• Application Number:
  US10/256,968
• Publication Number:
  US 20030229631A1
• Time in Patent Office: 1,460 Days
• Field of Search: 715/854, 707/100, 707/3, 707/6, 709/246, 709/203, 709/218, 379/88.04
• 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/99936 Pattern matching access

Abstract

The disclosure relates to providing access to database objects. A first view displays first and second database access mechanisms. The first database access mechanism includes at least one database access pattern including a predefined search of the database. The second database access mechanism includes at least one selection function and an input function, for searching a selected subset of the database for objects having an input value. The second database access mechanism is also capable of adding a database access pattern to the first database access mechanism. A third database access mechanism comprises an attribute choice and an input field to search for database objects having the input value associated with a chosen attribute.

Claims

1. A method of providing access to database objects in computer system, the method comprising:

displaying a first view on a display device, the first view including;

a first database access mechanism comprising at least one database access pattern, the database access pattern including a predefined search of the database; and

a second database access mechanism comprising at least one selection function for selecting a subset of the database to access and an input function, the second database access mechanism capable of receiving an input to select a subset of the database, receiving at least one input value in the input function, and searching the subset of the database for database objects having the input value, the second database access mechanism also being capable of adding a database access pattern to the first database access mechanism;

receiving an input to select a database access mechanism;

searching the database using the selected database access mechanism; and

displaying a second view on the display device, the second view comprising a set of one or more database objects, the set identified by the database search.

2. The method of claim 1 wherein the first view further includes a third database access mechanism, the third database access mechanism comprising at least one attribute choice and an input field, the third database access mechanism capable of receiving an input to select an attribute, receiving an input value in the input field, and searching the database for database objects having the input value associated with the selected attribute.

3. The method of claim 1 wherein the second database access mechanism is capable of removing a database access pattern from the first database access mechanism.

4. The method of claim 1 wherein the first database access mechanism comprises a database access pattern defined by a user.

5. The method of claim 1 wherein a database access pattern of the first database access mechanism comprises a collection of database objects defined by a user.

6. The method of claim 1 wherein a database access pattern of the first database access mechanism comprises one or more search criterion, each search criterion comprised of a condition on an object attribute.

7. The method of claim 1 wherein the selection function of the second database access mechanism further comprises a containment function for selecting the subset of the database to access, and a configuration function for selecting the parameters of the input function of the second database access mechanism.

8. The method of claim 1 wherein the input function of the second database access mechanism further comprises a plurality of input fields corresponding to database object fields.

9. The method of claim 1 further comprising, displaying a temporary communication area within the first view after receiving the input to select a database access mechanism, the temporary communication area comprising a work area for utilizing the second database access mechanism.

10. The method of claim 1 further comprising, performing an initial database search on the database using a database access pattern, the initial database search occurring prior to displaying the first view.

11. The method of claim 10 wherein the database access pattern used for the initial database search is a “

My Favorites”

database access pattern.

12. The method of claim 10 wherein the first view further includes a set of database objects, the set identified by the initial database search.

13. A method of providing access to database objects in a computer system, the method comprising:

displaying a first view on a display device, the first view including;

a first database access mechanism comprising at least one database access pattern, the database access pattern including a predefined search of the database;

a second database access mechanism comprising at least one selection function for selecting a subset of the database to access and an input function, the second database access mechanism capable of receiving an input to select a subset of the database, receiving at least one input value in the input function, and searching the subset of the database for database objects having the input value, the second database access mechanism also being capable of adding a database access pattern to the first database access mechanism; and

a third database access mechanism, the third database access mechanism comprising at least one attribute choice and an input field, the third database access mechanism capable of receiving an input to select an attribute, receiving an input value in the input field, and searching the database for database objects having the input value associated with the selected attribute;

receiving an input to select a database access mechanism;

searching the database using the selected database access mechanism; and

displaying a second view on the display device, the second view comprising a set of one or more database objects, the set identified by the database search.

14. Computer-readable medium with program instructions stored thereon that when executed perform the following functions for providing access to database objects in a computer system:

displays a first view on a display device, the first view including;

a first database access mechanism comprising at least one database access pattern, the database access pattern including a predefined search of the database; and

a second database access mechanism comprising at least one selection function for selecting a subset of the database to access and an input function, the second database access mechanism capable of receiving an input to select a subset of the database, receiving at least one input value in the input function, and searching the subset of the database for database objects having the input value, the second database access mechanism also being capable of adding a database access pattern to the first database access mechanism;

receives an input to select a database access mechanism;

searches the database using the selected database access mechanism; and

displays a second view on the display device, the second view comprising a set of one or more database objects, the set identified by the database search.

15. The medium of claim 14 wherein the first view further includes a third database access mechanism, the third database access mechanism comprising at least one attribute choice and an input field, the third database access mechanism capable of receiving an input to select an attribute, receiving an input value in the input field, and searching the database for database objects having the input value associated with the selected attribute.

16. The medium of claim 14 wherein the second database access mechanism is capable of removing a database access pattern from the first database access mechanism.

17. The medium of claim 14 wherein the first database access mechanism comprises a database access pattern defined by a user.

18. The medium of claim 14 wherein a database access pattern of the first database access mechanism comprises a collection of database objects defined by a user.

19. The medium of claim 14 wherein a database access pattern of the first database access mechanism comprises one or more search criterion, each search criterion comprised of a condition on an object attribute.

20. The medium of claim 14 wherein the selection function of the second database access mechanism further comprises a containment function for selecting the subset of the database to access, and a configuration function for selecting the parameters of the input function of the second database access mechanism.

21. The medium of claim 14 wherein the input function of the second database access mechanism further comprises a plurality of input fields corresponding to database object fields.

22. The medium of claim 14 further comprising, instructions that when executed display a temporary communication area within the first view after receiving the input to select a database access mechanism, the temporary communication area comprising a work area for utilizing the second database access mechanism.

23. The medium of claim 14 further comprising, instructions that when executed perform an initial database search on the database using a database access pattern, the initial database search occurring prior to displaying the first view.

24. The medium of claim 23 wherein the database access pattern used for the initial database search is a “

My Favorites”

database access pattern.

25. The medium of claim 23 wherein the first view further includes a set of database objects, the set identified by the initial database search.