Methods and systems for creating a complex user interface adapting a generic database software application to individually manage subset domains in complex database

• US 9,672,228 B2
• Filed: 03/11/2013
• Issued: 06/06/2017
• Est. Priority Date: 03/11/2013
• Status: Active Grant

• Current Assignee: Honeywell International Inc.
• Original Assignee: Honeywell International Inc.
• Inventors: Felke, Tim, Vanderzweep, Jeff, Begur, Nagabhushana Rao, Kolandavelu, Raghupathy
• Primary Examiner(s): PYO, MONICA M
• Application Number:
  US13/794,155
• Publication Number:
  US 20140258344A1
• Time in Patent Office: 1,548 Days
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06N 5/02 Knowledge representation; Symbolic representation

Abstract

Methods are provided for creating a complex user interface using a generic computer readable database software application to manage only a specific data subset domain of the database in accordance with a work package. The method comprises creating metadata defining a data subset domain, the metadata including a task specification, a report specification and a view specification and defining attribute metadata, entity metadata and relationship metadata for the data subset domain. The method also comprises data package specification for the data subset domain, specifying a data package hierarchy within the data subset domain, specifying user groups for the data subset domain, specifying view specifications for the user groups. Further the view specification is associated with the task specification and the report specification after which the generic software application is released to a user.

Claims

1. A computer executed method for creating a complex graphical user interface on a display device via generic computer readable database software executable on a processor to manage only a specific data subset domain of application data in a database, the method comprising:

specifying a structure of a complex data model for a customer application, the structure comprising a plurality of attribute specifications, a plurality of entity specifications and a plurality of relationship specifications for the complex data model, wherein each of the plurality of entity specifications comprises a table having a plurality of rows and columns, each row of the table defining an entity of the customer application, each column of the table being defined by one of the attribute specifications, and wherein each relationship specification defines a type of relationship allowed between the entities of the customer application within each of the plurality of entity specifications;

specifying a process defining how to populate each table of the entity specification, the process comprising;

a task specification defining a sequence of tasks to populate each table of the entity specification; and

a view specification specifying a subset of the rows and columns of each table of each entity specification which are viewable and populatable during each task of the sequence of tasks; and

automatically generating a customized software application for creating the complex data model having the complex graphical user interface, wherein the complex graphical user interface is customized based upon the specified structure of the complex data model, the task specification; and

the view specification, the customized software application, when executed, presenting a sequence of the complex graphical user interfaces each controlling at least one task of the sequence of tasks to populate each table of the entity specification.

2. The method of claim 1, wherein metadata for the complex data model defines definitions for all entity types, attribute types, relationship types and primary keys for the application data being displayed.

3. The method of claim 1, wherein the entity specifications comprise a table name, a primary key and a long name.

4. The method of claim 1, wherein the Relationship specifications comprise a source entity type, a destination entity type, a forward name, a reverse name and cardinality rules.

5. The method of claim 1, wherein the attribute specifications comprise an entity name, and attribute spec, a display name, and attribute type and attribute editor and constraints.

7. The method of claim 1, wherein the specified process further comprises:

a user group specification, the user group specification defining which tasks of the sequence of tasks are viewable and executable by users of the user group.

8. The method of claim 1, wherein the specified process further comprises:

a data package specification, the data package specification defining an organizational hierarchy of the plurality of attribute specifications, the plurality of entity specifications and the plurality of relationship specifications for the complex data model.

6. A computer program product recorded on a non-transitory storage medium comprising steps for creating a complex graphical user interface on a display device via generic computer readable database software to manage only a specific data subset domain of application data in a database, the steps comprising:

specifying a structure of a complex data model for a customer application, the structure comprising a plurality of attribute specifications, a plurality of entity specifications and a plurality of relationship specifications for the complex data model, wherein each of the plurality of entity specifications comprises a table having a plurality of rows and columns, each row of the table defining an entity of the customer application, each column of the table being defined by one of the attribute specifications, and wherein each relationship specification defines a type of relationship allowed between the entities of the customer application within each of the plurality of entity specifications;

specifying a process defining how to populate each table of the entity specification, the process comprising;

a task specification defining a sequence of tasks to populate each table of the entity specification; and

a view specification specifying a subset of the rows and columns of each table of each entity specification which are viewable and populatable during each task of the sequence of tasks; and

automatically generating a customized software application for creating the complex data model having the complex graphical user interface, wherein the complex graphical user interface is customized based upon the specified structure of the complex data model, the task specification; and

the view specification, the customized software application, when executed, presenting a sequence of the complex graphical user interfaces each controlling at least one task of the sequence of tasks to populate each table of the entity specification;

user interfaces each controlling at least one step for creating the model.

9. The computer program product of claim 6, wherein the specified process further comprises:

a user group specification, the user group specification defining which tasks of the sequence of tasks are viewable and executable by users of the user group.

10. The computer program product of claim 6, wherein the specified process further comprises:

a data package specification, the data package specification defining an organizational hierarchy of the plurality of attribute specifications, the plurality of entity specifications and the plurality of relationship specifications for the complex data model.