Automatic interface layout generator for database systems

• US 5,495,567 A
• Filed: 07/20/1993
• Issued: 02/27/1996
• Est. Priority Date: 11/06/1992
• Status: Expired due to Term

• Current Assignee: Ricoh Company Limited, Ricoh Corporation (Ricoh Company Limited)
• Original Assignee: Ricoh Company Limited, Ricoh Corporation (Ricoh Company Limited)
• Inventors: Pizano, Arturo, Yoshiura, Yukari, Iizawa, Atsushi
• Primary Examiner(s): Zimmerman, Mark K.
• Assistant Examiner(s): Burwell, Joseph R.
• Application Number:
  US08/095,105
• Time in Patent Office: 952 Days
• Field of Search: 395/155, 395/156, 395/159, 395/161, 395/921
• US Class Current: 715/762
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: Y10S 706/921 Layout, e.g. circuit, construction
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 715/967 Visual or iconic programming
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

An automatic interface layout generator for database systems is disclosed herein. The automatic generator includes a specification tool for specifying a set of block descriptions representative of specified portions of a database. A block layout generator produces interface objects to be included within an interface of the database, wherein each of the interface objects corresponds to one of the block descriptions and includes a plurality of layout fields. A layout quality parameter is determined for each of the interface objects based on arrangement of the layout fields within the interface objects. A block placement generator arranges sets of the interface objects into block configurations within the interface. A placement quality parameter for each of the block configurations is derived based on a set of block placement rules and on the layout quality parameters, and a final block configuration is selected by comparing the placement quality parameters corresponding to particular block configurations.

Claims

1. An automatic interface layout generator for database systems comprising:

means for specifying a set of block descriptions representative of specified portions of a database;

means for generating interface objects to be included within an interface of said database wherein each of said interface objects corresponds to one of said block descriptions and includes a plurality of layout fields;

means for determining a layout quality parameter for each of said interface objects based on layout of said layout fields within said interface objects;

block placement means for arranging sets of said interface objects into block configurations within said interface; and

means for determining a placement quality parameter for each of said block configurations based on a set of block placement rules and on said layout quality parameters, including means for selecting a final block configuration by comparing said placement quality parameters.

2. The automatic interface layout generator of claim 1 wherein said block placement rules include guidelines relating to geometry of said block configurations.

3. The automatic interface layout generator of claim 2 wherein said block placement rules include constraints relating to geometry of said block configuration relative to geometry of said interface.

4. The automatic interface layout generator of claim 1 wherein said layout quality parameters are determined in accordance with layout guidelines relating to distribution of said layout fields within said interface objects.

5. The automatic interface generator of claim 4 wherein said layout guidelines include:

a wasted space guideline corresponding to the ratio of area occupied by a first set of said layout fields included within one of said interface objects to area occupied by said one interface object, and

a balance guideline related to uniformity of distribution of said first set of layout fields over predefined regions of said one interface object.

6. The automatic interface generator of claim 1 wherein said means for generating interface objects includes means for generating a set of interface objects for each of said block descriptions by varying placement of said layout fields among said objects included within said set of interface objects.

7. The automatic interface generator of claim 6 wherein each of said layout fields corresponds to one of a plurality of widget types, and wherein said means for generating a set of interface objects for each of said block descriptions includes means for assigning a widget type to each of said layout fields.

8. The automatic interface generator of claim 1 wherein said block placement means includes means for iteratively arranging sets of said interface objects into block configurations on the basis of a simulated annealing procedure in which a pair of said placement quality parameters corresponding to a pair of said block configurations generated during successive iterations of said annealing procedure are compared so as to determine which of said pair of placement quality parameters is utilized in a subsequent iteration of said annealing procedure.

9. The automatic interface generator of claim 8 further including means for perturbing said simulated annealing procedure in accordance with a perturbation function.

10. The automatic interface generator of claim 1 further including code generator means for generating code corresponding to a display representation of said final block configuration.

11. The layout generator of claim 1 wherein said means for specifying a set of block descriptions includes means for generating, based on information included within said database, a schema diagram representative of relationships and attributes associated with a set of database entities defined within said database.

12. The layout generator of claim 11 further including schema editor means for transforming said schema diagram into an application specification diagram.

13. The layout generator of claim 12 further including interpreter means for generating said block descriptions in accordance with said application specification diagram.

14. A method for automatically generating an interface layout for a database comprising the steps of:

specifying a set of block descriptions representative of specified portions of said database;

generating interface objects, based on said block descriptions, for inclusion within an interface of said database wherein each of said interface objects has a plurality of layout fields and each of said block descriptions has associated therewith a set of said interface objects;

determining a layout quality parameter for each of said interface objects based on layout of said layout fields within said interface objects;

arranging first and second groups of said interface objects into first and second block configurations, respectively, within said interface wherein each of said groups includes an interface object from each of said sets of interface objects; and

determining first and second placement quality parameters for said first and second block configurations, respectively, based on a set of block placement rules and on said layout quality parameters, and selecting a final block configuration by comparing said first and second placement quality parameters.

15. The method of claim 14 wherein said step of specifying a set of block descriptions includes the step of generating, based on information included within said database, a schema diagram representative of relationships and attributes associated with a set of database entities defined within said database.

16. The method of claim 15 further including the step of transforming said schema diagram into an application specification diagram.

17. The method of claim 14 further including the step of generating said block descriptions in accordance with said application specification diagram.