Method and apparatus for building an application interface

• US 6,097,382 A
• Filed: 05/12/1998
• Issued: 08/01/2000
• Est. Priority Date: 05/12/1998
• Status: Expired due to Term

• Current Assignee: RPX Corporation
• Original Assignee: SilverStream Software, Inc. (Open Text Corporation)
• Inventors: Dicristina, Paul H., Rosen, Alexander D.
• Primary Examiner(s): Powell, Mark R.
• Assistant Examiner(s): CUNNINGHAM, GREGORY F
• Application Number:
  US09/076,926
• Time in Patent Office: 812 Days
• Field of Search: 707/509, 707/514, 707/515, 707/904, 707/907, 345/357, 345/968, 345/326
• US Class Current: 715/762
• CPC Class Codes: G06F 8/34 Graphical or visual programming
• CPC Class Codes: G06F 8/38 for implementing user interfaces
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

Embodiments of the invention comprise a design tool for designing an application interface. The design tool includes a graphical user interface (GUI) that visually represents a hierarchy of data and the relationships between the data. Thus, the design tool eliminates the need for an interface designer to have independent knowledge of the structure of the data (i.e., the data fields and relationships between the data). The design tool'"'"'s GUI represents the data and the relationships between the data in a hierarchical display referred to as a data palette. An output hierarchy comprised of output levels is created as the user selects fields from the data palette to be displayed in the application'"'"'s interface. When a data field is selected, the design tool automatically determines the appropriate interface component and output level of the output hierarchy using the relationships defined for the data. Output levels are associated with interface components that comprise the application'"'"'s interface. Examples of interface components that can be used in the application'"'"'s interface include a form, view and subband.

Claims

1. In a computer system, a method of building an application interface comprising:

obtaining a data palette that displays a set of data fields and relationships defined for said data fields;

obtaining an output hierarchy having a plurality of output levels, each of said plurality of output levels being associated with one or more interface components of an application interface; and

using said relationships to assign a selected one of said data fields to one of said one or more interface components of one of said plurality of output levels of said output hierarchy, said step of using said relationships comprising traversing a table hierarchy to identify one of said plurality of output levels for said selected data field.

2. The method of claim 1 wherein one or more of said relationships comprise a one-to-many relationship.

3. The method of claim 1 wherein one or more of said relationships comprise a many-to-one relationship.

4. The method of claim 1 wherein one or more of said relationships comprise a one-to-one relationship.

5. The method of claim 1 wherein said assigning a selected one of said data fields is performed automatically by said computer system.

6. The method of claim 1 further comprising displaying said output hierarchy.

7. The method of claim 1 wherein said interface component comprises a form.

8. The method of claim 1 wherein said interface component comprises a view.

9. The method of claim 1 wherein said interface component comprises a subband.

10. The method of claim 2 wherein said selected data field is assigned to a different output level than a corresponding data field specified in said relationship.

11. The method of claim 2 wherein said output level comprises a child output level of a primary table'"'"'s output level.

12. The method of claim 1 wherein said obtaining a data palette step further comprises:

selecting a primary table;

obtaining a table hierarchy;

displaying said primary table and data fields from said primary table; and

displaying relationships of said primary table.

13. A computer program product comprising:

a computer usable medium having computer readable program code embodied therein configured to build an application interface, said computer program product comprising;

computer readable code configured to cause a computer to obtain a data palette that displays a set of data fields and relationships defined for said data fields;

computer readable code configured to cause a computer to obtain an output hierarchy having a plurality of output levels, each of said plurality of output levels being associated with one or more interface components of an application interface; and

computer readable code configured to cause a computer to use said relationships to assign a selected one of said data fields to one of said one or more interface components of one of said plurality of output levels of said output hierarchy, said computer readable code configured to cause a computer to use said relationships configured to traverse a table hierarchy to identify one of said plurality of output levels for said selected data field.

14. The computer program product of claim 13 wherein one or more of said relationships comprise a one-to-many relationship.

15. The computer program product of claim 13 wherein one or more of said relationships comprise a many-to-one relationship.

16. The computer program product of claim 13 wherein one or more of said relationships comprise a one-to-one relationship.

17. The computer program product of claim 13 wherein said computer code configured to cause a computer to assign a selected one of said data fields is configured to perform said assignment automatically.

18. The computer program product of claim 13 further comprising computer readable program code configured to cause a computer to display said output hierarchy.

19. The computer program product of claim 13 wherein said interface component comprises a form.

20. The computer program product of claim 13 wherein said interface component comprises a view.

21. The computer program product of claim 13 wherein said interface component comprises a subband.

22. The computer program product of claim 14 wherein said selected data field is assigned to a different output level than a corresponding data field specified in said relationship.

23. The computer program product of claim 14 wherein said output level comprises a child output level of a primary table'"'"'s output level.

24. The computer program product of claim 13 wherein said computer code configured to cause a computer to obtain a data palette further comprises:

computer readable program code configured to cause a computer to select a primary table;

computer readable program code configured to cause a computer to obtain a table hierarchy;

computer readable program code configured to cause a computer to display said primary table and data fields from said primary table; and

computer readable program code configured to cause a computer to display relationships of said primary table.

25. A system comprising:

a set of data fields;

one or more relationships defined for said data fields;

a data palette configured to display said set of data fields and said one or more relationships defined for said data fields;

an application interface having one or more interface components;

an output hierarchy having a plurality of output levels, each of said plurality of output levels being associated with said one or more interface components of said application interface; and

computer code configured to use said relationships to assign a selected one of said data fields to one of said one or more interface components of one of said plurality of output levels of said output hierarchy, wherein said computer code is further configured to traverse said table hierarchy to identify one of said plurality of output levels for said selected data field.

26. The system of claim 25 wherein one or more of said relationships comprise a one-to-many relationship.

27. The system of claim 25 wherein one or more of said relationships comprise a many-to-one relationship.

28. The system of claim 25 wherein one or more of said relationships comprise a one-to-one relationship.

29. The system of claim 25 wherein said computer code automatically assigns a selected one of said data fields to one of said one or more interface components.

30. The system of claim 25 further comprising a graphical user interface for displaying said output hierarchy.

31. The system of claim 25 wherein said interface component comprises a form.

32. The system of claim 25 wherein said interface component comprises a view.

33. The system of claim 25 wherein said interface component comprises a subband.

34. The system of claim 26 wherein said computer code assigns said selected data field to a different output level than a corresponding data field specified in said relationship.

35. The system of claim 26 wherein said output level comprises a child output level of a primary table'"'"'s output level.

36. The system of claim 25 further comprising:

a primary table having said set of data fields; and

a table hierarchy;

wherein said relationships are obtained using said table hierarchy; and

wherein said data palette is further configured to display said primary table, said data fields from said primary table, and said one or more relationships.