Multi-frame output form that facilitates internet search and update in a hierarchical database

• US 6,430,571 B1
• Filed: 08/13/1999
• Issued: 08/06/2002
• Est. Priority Date: 07/16/1998
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: McBride, Kevin Michael, Spain, Kelly Ann, Ho, Shyh-Mei Fang, Ling, Wai-Yee Doris, Doan, Bach Dinh
• Primary Examiner(s): Breene, John
• Assistant Examiner(s): Ali, Mohammad
• Application Number:
  US09/374,906
• Time in Patent Office: 1,089 Days
• Field of Search: 707/1-10, 707/100-104, 707/200-205, 709/217, 709/231, 709/203, 709/229, 709/226, 709/315, 709/230, 709/219, 709/310, 709/228, 345/968, 345/805, 345/853, 345/804
• US Class Current: 707/778
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/956 Hierarchical
• 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
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

A method, apparatus, and article of manufacture for accessing a hierarchical database. The hierarchical structure of a database is modeled into an objects framework, wherein the objects framework is comprised of one or more objects that correspond to application views, database definitions, and data defined and stored in the database, and the objects are organized into a tree structure to represent the hierarchical structure of the database. An Internet-enabled application accesses the hierarchical structure of the database through the objects framework using at least one multi-frame output form, wherein the multi-frame output form displays data from a plurality of the objects.

Claims

1. A computer-implemented method for accessing a database, comprising the steps of:

(a) modeling a hierarchical structure of a database into an objects framework, wherein the objects framework is comprised of one or mote objects that correspond to application views, database definitions, and data defined and stored in the database, and the objects are organized into a tree structure to represent the hierarchical structure of the database; and

(b) accessing the hierarchical structure of the database through the objects framework using at least one multi-frame output form, wherein the multi-frame output form displays data from a plurality of the objects.

2. The method of claim 1, wherein the multi-frame output form provides at least one control selected from a group comprising a first control for accessing and displaying data from the objects, a second control for modifying the displayed data in the database, and a third control for deleting the displayed data from the database.

3. The method of claim 1, wherein the accessing step comprises the step of accessing the hierarchical structure of the database via the Internet.

4. The method of claim 3, wherein the multi-frame output form is displayed by a web browser.

5. The method of claim 4, further comprising the steps of dynamically constructing one or mote queries to access the database at the web browser, and displaying the multi-frame output form using results from the dynamically constructed queries.

6. The method of claim 3, wherein the output forms comprise HyperText Markup Language documents.

7. The method of claim 1, further comprising the step of displaying data from a plurality of objects in the multi-frame output forms simultaneously.

8. The method of claim 1, further comprising the step of scrolling through the displayed data using controls on the multi-frame output forms.

9. The method of claim 8, further comprising the step of using the multi-frame output forms to scroll forward and backward to view and update data from different objects in the database.

10. The method of claim 8, wherein the multi-frame output forms include controls that allow the user to scroll back to a previous set of objects and to scroll forward to a next set of objects.

11. The method of claim 1, further comprising the step of using the multi-frame output forms to traverse through the hierarchical structure of the database.

12. The method of claim 1, wherein of the objects comprises a segment data occurrence.

13. The method of claim 1, wherein the multi-frame output form contains fields associated with specific data from the objects.

14. The method of claim 1, wherein the multi-frame output forms display a plurality of rows, and each of the rows display data from one of the objects.

15. The method of claim 14, wherein each of the rows includes both read-only and read-write fields.

16. The method of claim 15, wherein the read-only fields contain keys from the database.

17. The method of claim 15, wherein the read-write fields contain data from the database that are available for updates or modifications.

18. The method of claim 17, further comprising the steps of updating the data in the read-write fields and selecting a control from the multi-frame output forms to modify the data in the database.

19. The method of claim 17, further comprising the steps of selecting one or more of the rows and selecting a control from the multi-frame output forms to delete the data in the database.

20. A computerized apparatus for accessing a database, comprising:

(a) an objects framework, executed by a computer, for modeling a hierarchical structure of a database into an objects framework, wherein the objects framework is comprised of one or more objects that correspond to application views, database definitions, and data defined and stored in the database, and the objects are organized into a tree structure to represent the hierarchical structure of the database; and

(b) an Internet-enabled application program, executed by a computer, for accessing the hierarchical structure of the database through the objects framework using at least one multi-frame output form, wherein the multi-frame output form displays data from a plurality of the objects.

21. The apparatus of claim 20, wherein the multi-frame output form provides at least one control selected from a group comprising a first control for accessing and displaying data from the objects, a second control for modifying the displayed data in the database, and a third control for deleting the displayed data from the database.

22. The apparatus of claim 20, wherein the Internet-enabled application program further comprises means for accessing the hierarchical structure of the database via the Internet.

23. The apparatus of claim 22, wherein the multi-frame output form is displayed by a web browser.

24. The apparatus of claim 23, wherein the Internet-enabled application program further comprises means for dynamically constructing one or more queries to access the database at the web browser, and for displaying the multi-frame output form using results from the dynamically constructed queries.

25. The apparatus of claim 22, wherein the output forms comprise HyperText Markup Language documents.

26. The apparatus of claim 20, wherein the Internet-enabled application program further comprises means for displaying data from a plurality of objects in the multi-frame output forms simultaneously.

27. The apparatus of claim 20, Internet-enabled application program further comprises means for scrolling through the displayed data using controls on the multi-frame output forms.

28. The apparatus of claim 27, wherein the Internet-enabled application program further comprises means for using the multi-frame output forms to scroll forward and backward to view and update data from different objects in the database.

29. The apparatus of claim 27, wherein the multi-frame output forms include controls that allow the user to scroll back to a previous set of objects and to scroll forward to a next set of objects.

30. The apparatus of claim 20, wherein the Internet-enabled application program further comprises means for using the multi-frame output forms to traverse through the hierarchical structure of the database.

31. The apparatus of claim 20, wherein of the objects comprises a segment data occurrence.

32. The apparatus of claim 20, wherein the multi-frame output form contains fields associated with specific data from the objects.

33. The apparatus of claim 20, wherein the multi-frame output forms display a plurality of rows, and each of the rows display data from one of the objects.

34. The apparatus of claim 33, wherein each of the rows includes both read-only and read-write fields.

35. The apparatus of claim 34, wherein the read-only fields contain keys from the database.

36. The apparatus of claim 34, wherein the read-write fields contain data from the database that are available for updates or modifications.

37. The apparatus of claim 36, wherein the Internet-enabled application program further comprises means for updating the data in the read-write fields and for selecting a control from the multi-frame output forms to modify the data in the database.

38. The apparatus of claim 36, wherein the Internet-enabled application program further comprises means for selecting one or more of the rows and for selecting a control from the multi-frame output forms to delete the data in the database.

39. An article of manufacture embodying logic for accessing a database, comprising the steps of:

(a) modeling a hierarchical structure of a database into an objects framework, wherein the objects framework is comprised of one or more objects that correspond to application views, database definitions, and data defined and stored in the database, and the objects are organized into a tree structure to represent the hierarchical structure of the database; and

(b) accessing the hierarchical structure of the database through the objects framework using at least one multi-frame output form, wherein the multi-frame output form displays data from a plurality of the objects.

40. The method of claim 39, wherein the multi-frame output form provides at least one control selected from a group comprising a first control for accessing and displaying data from the objects, a second control for modifying the displayed data in the database, and a third control for deleting the displayed data from the database.

41. The method of claim 39, wherein the accessing step comprises the step of accessing the hierarchical structure of the database via the Internet.

42. The method of claim 41, wherein the multi-frame output form is displayed by a web browser.

43. The method of claim 42, further comprising the steps of dynamically constructing one or more queries to access the database at the web browser, and displaying the multi-frame output form using results from the dynamically constructed queries.

44. The method of claim 41, wherein the output forms comprise HyperText Markup Language documents.

45. The method of claim 39, further comprising the step of displaying data from a plurality of objects in the multi-frame output forms simultaneously.

46. The method of claim 39, further comprising the step of scrolling through the displayed data using controls on the multi-frame output forms.

47. The method of claim 46, farther comprising the step of using the multi-frame output forms to scroll forward and backward to view and update data from different objects in the database.

48. The method of claim 46, wherein the multi-frame output forms include controls that allow the user to scroll back to a previous set of objects and to scroll forward to a next set of objects.

49. The method of claim 39, further comprising the step of using the multi-frame output forms to traverse through the hierarchical structure of the database.

50. The method of claim 39, wherein of the objects comprises a segment data occurrence.

51. The method of claim 39, wherein the multi-frame output form contains fields associated with specific data from the objects.

52. The method of claim 39, wherein the multi-frame output forms display a plurality of rows, and each of the tows display data from one of the objects.

53. The method of claim 52, wherein each of the rows includes both read-only and read-write fields.

54. The method of claim 53, wherein the read-only fields contain keys from the database.

55. The method of claim 53, wherein the read-write fields contain data from the database that are available for updates or modifications.

56. The method of claim 55, further comprising the steps of updating the data in the read-write fields and selecting a control from the multi-frame output forms to modify the data in the database.

57. The method of claim 55, further comprising the steps of selecting one or more of the rows and selecting a control from the multi-frame output forms to delete the data in the database.