Integrated graphical user interface method and apparatus for mapping between objects and databases

• US 6,279,008 B1
• Filed: 06/29/1998
• Issued: 08/21/2001
• Est. Priority Date: 06/29/1998
• Status: Expired due to Fees

• Current Assignee: Baan Development BV
• Original Assignee: Baan Development BV, Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Tung Ng, Tony Chun, Sharma, Rahul, Learmont, Timothy R.
• Primary Examiner(s): HOMERE, JEAN RAYMOND
• Application Number:
  US09/106,046
• Time in Patent Office: 1,149 Days
• Field of Search: 707/101, 707/102, 707/103, 345/334, 345/335
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A graphical user interface on a computer system is provided for displaying objects in an object-oriented application and data stored in tables of a database. The graphical user interface displays a class view corresponding to one or more classes in the object-oriented application that in turn corresponds to tables in the database and displays a table view having one or more tables in a database corresponding to classes in the object-oriented application. In addition, the graphical user interface also displays a combination table-and-class view having database elements from the database adjacent to the object-oriented elements from the object-oriented application.

Claims

1. A method, performed on a computer system, for displaying classes associated with an object-oriented application and tables associated with a database, comprising:

selectively displaying a class view corresponding to classes associated with an object-oriented application and corresponding to tables associated with the database, the displaying further comprising;

displaying a hierarchical tree representing a set of object-oriented elements corresponding to the object-oriented application; and

providing the set of the object-oriented elements in the hierarchical tree selected from a group including a package name, a class name, a field name, a relationship name, a lock group name, and an index group name;

permitting access to the classes using the displayed class view;

selectively displaying a table view corresponding to tables associated with a database and corresponding to classes associated with the object-oriented application; and

permitting access to the tables using the displayed class view.

2. The method of claim 1 further comprising:

displaying a combination table-and-class view corresponding to database elements associated with the database and object-oriented elements associated with the object-oriented application.

3. The method of claim 2 wherein displaying a class view further comprises:

displaying a column database element and a field object-oriented element.

4. The method of claim 2 wherein displaying a class view further comprises:

displaying a foreign key database element and a reference object-oriented element.

5. The method of claim 1 wherein displaying a class view further comprises:

displaying a tabular interface having a tab corresponding to each element in a set of object-oriented elements.

6. The method of claim 5 wherein displaying the tabular interface further comprises:

providing a set of entry fields that facilitates operating on characteristics associated with each element in the set of object-oriented elements.

7. The method of claim 1 wherein displaying a table view further comprises:

displaying a hierarchical tree representing a set of database elements associated with a set of tables corresponding to the database.

8. The method of claim 7 wherein displaying a hierarchical tree further comprises:

providing the set of the database elements in the hierarchical tree selected from a group of database elements including a database name, a table name, a column name, an index name, and a foreign key name.

9. The method of claim 1 wherein displaying a table view further comprises:

displaying a tabular interface having a tab corresponding to each element in a set of database elements.

10. The method of claim 9 wherein displaying the tabular interface further comprises:

providing a set of entry fields corresponding to the set of database elements that facilitate operating on characteristics associated with each of the database elements.

11. The method of claim 10 wherein displaying the tabular interface further comprises providing the set of database elements selected from a group of database elements including a table name, a column name, an index name, and foreign key name.

12. A method, performed on a computer system, for displaying classes associated with an object-oriented application and tables associated with a database, comprising:

selectively displaying a class view corresponding to classes associated with an object-oriented application and corresponding to tables associated with the database, the displaying further comprising;

displaying a tabular interface having a tab corresponding to each element in a set of object-oriented elements, the displaying a tabular interface further comprising;

providing a set of entry fields that facilitates operating on characteristics associated with each element in the set of object-oriented elements; and

providing the set of object-oriented elements selected from a group of object-oriented elements including a package name, a class name, a field name, a relationship name, a lock group name, and an index group name;

permitting access to the classes using the displayed class view;

selectively displaying a table view corresponding to tables associated with a database and corresponding to classes associated with the object-oriented application; and

permitting accessing to the tables using the displayed class view.

13. A computer apparatus that facilitates displaying an object-oriented application and tables associated with a database, comprising:

a selectable class view display element corresponding to one or more classes associated with an object-oriented application and corresponding to tables associated with the database, the selectable class view further comprising;

a hierarchical tree representing a set of object-oriented elements corresponding to the object-oriented application, wherein the set of the object-oriented elements in the hierarchical tree is selected from a group including a package name, a class name, a field name, a relationship name, a lock group name, and an index group name;

an access mechanism that provides access to the tables using the selectable class view display element;

a selectable table view display element corresponding to one or more tables associated with a database and corresponding to classes associated with the object-oriented application; and

an access mechanism that provides access to the tables using the selectable table view display element.

14. The apparatus of claim 13 further comprising:

a combination table-and-class view display element corresponding to database elements associated with the database and object-oriented elements associated with the object-oriented application.

15. The apparatus of claim 14 wherein the combination table-and-class view display element further comprises:

a column database element and a field object-oriented element.

16. The apparatus of claim 14 wherein the combination table-and-class view display element further comprises:

a foreign key database element and a reference object-oriented element.

17. The apparatus of claim 13 wherein the class view further comprises:

a tabular interface having a tab corresponding to each element in a set of object-oriented elements.

18. The apparatus of claim 17 wherein the tabular interface further comprises:

a set of entry fields that facilitates operating on characteristics associated with each element in the set of object-oriented elements.

19. The apparatus of claim 13 wherein the table view further comprises:

a hierarchical tree representing a set of database elements associated with a set of tables corresponding to the database.

20. The apparatus of claim 19 wherein the set of the database elements in the hierarchical tree is selected from a group of database elements including a database name, a table name, a column name, an index name, and a foreign key name.

21. The apparatus of claim 13 wherein the table view further comprises:

a tabular interface having a tab corresponding to each element in a set of database elements.

22. The apparatus of claim 21 wherein the tabular interface farther comprises:

a set of entry fields corresponding to the set of database elements that facilitate operating on characteristics associated with each of the database elements.

23. The apparatus of claim 22 wherein the set of database elements is selected from a group of database elements including a table name, a column name, an index name, and foreign key name.

24. A computer apparatus that facilitates displaying an object-oriented application and tables associated with a database, comprising:

a selectable class view display element corresponding to one or more classes associated with an object-oriented application and corresponding to tables associated with the database, the selectable class view further comprising;

a tabular interface having a tab corresponding to each element in a set of object-oriented elements, the tabular interface further comprising;

a set of entry fields that facilitates operating on characteristics associated with each element in the set of object-oriented elements, wherein the set of object-oriented elements is selected from a group of object-oriented elements including a package name, a class name, a field name, a relationship name, a lock group name, and an index group name;

an access mechanism that provides access to the tables using the selectable class view display element;

a selectable table view display element corresponding to one or more tables associated with a database and corresponding to classes associated with the object-oriented application; and

an access mechanism that provides access to the tables using the selectable table view display element.

25. A computer program product capable of displaying classes associated with an object-oriented application and tables associated with a database, the computer program product comprising program code to cause a data processor to perform:

selectively displaying a class view corresponding to one or more classes associated with an object-oriented application and corresponding to tables associated with the database, the selectively displaying further comprising;

displaying a hierarchical tree representing a set of object-oriented elements corresponding to the object-oriented application, the displaying a hierarchical tree further comprising;

providing the set of the object-oriented elements in the hierarchical tree selected from a group including a package name, a class name, a field name, a relationship name, a lock group name, and an index group name;

permitting access to the classes and related information using the displayed, class view;

selectively displaying a table view corresponding to one or more tables associated with a database and corresponding to classes associated with the object-oriented application; and

permitting access to the tables and related information using the displayed class view.

26. The computer program product of claim 25 wherein the code further comprises:

displaying a combination table-and-class view corresponding to database elements associated with the database and object-oriented elements associated with the object-oriented application.

27. The computer program product of claim 26 wherein the code further comprises:

displaying a column database element and a field object-oriented element.

28. The computer program product of claim 26 wherein the code further comprises:

displaying a foreign key database element and a reference object-oriented element.

29. The computer program product of claim 25 wherein the code for displaying a class view further comprises:

displaying a tabular interface having a tab corresponding to each element in a set of object-oriented elements.

30. The computer program product of claim 29 wherein the code for displaying the tabular interface further comprises:

providing a set of entry fields that facilitates operating on characteristics associated with each element in the set of object-oriented elements.

31. The computer program product of claim 25 wherein the code for displaying a table view further comprises:

displaying a hierarchical tree representing a set of database elements associated with a set of tables corresponding to the database.

32. The computer program product of claim 31 wherein the code for displaying a hierarchical tree further comprises:

providing the set of the database elements in the hierarchical tree selected from a group of database elements including a database name, a table name, a column name, an index name, and a foreign key name.

33. The computer program product of claim 25 wherein the code for displaying a table view further comprises:

displaying a tabular interface having a tab corresponding to each element in a set of database elements.

34. The computer program product of claim 33 wherein the code for displaying the tabular interface further comprises:

providing a set of entry fields corresponding to the set of database elements that facilitate operating on characteristics associated with each of the database elements.

35. A computer program product capable of displaying classes, associated with an object-oriented application and tables associated with a database, the computer program product comprising program code to cause a data processor to perform:

selectively displaying a class view corresponding to one or more classes associated with an object-oriented application and corresponding to tables associated with the database, the selectively displaying further comprising;

displaying a tabular interface having a tab corresponding to each element in a set of object-oriented elements, the displaying a tabular interface further comprising;

providing a set of entry fields that facilitates operating on characteristics associated with each element in the set of object-oriented elements; and

providing the set of object-oriented elements selected from a group object-oriented elements including a package name, a class name, a field name, a relationship name, a lock group name, and an index group name;

permitting access to the classes and related information using the displayed class view;

selectively displaying a table view corresponding to one or more tables associated with a database and corresponding to classes associated with the object-oriented application; and

permitting access to the tables and related information using the displayed class view.