Methods and systems for providing intuitive direction for populating complex model content into a database

• US 9,569,469 B2
• Filed: 07/26/2013
• Issued: 02/14/2017
• Est. Priority Date: 07/26/2013
• Status: Active Grant

• Current Assignee: Honeywell International Inc.
• Original Assignee: Honeywell International Inc.
• Inventors: vanderZweep, Jeff, Begur, Nagabhushana Rao, Felke, Tim, Kolandavelu, Raghupathy
• Primary Examiner(s): Kerzhner, Aleksandr
• Assistant Examiner(s): Cheung, Eddy
• Application Number:
  US13/952,249
• Publication Number:
  US 20150032687A1
• Time in Patent Office: 1,299 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06Q 10/0631 Resource planning, allocation, distributing or scheduling for enterprises or organisations

Abstract

Methods and systems are provided for populating a database with data associated with a specific task. The method comprises creating a work package specification for a work package associated with the specific task, creating a task specification within the work package specification, creating a view specification within the task specification, and creating a task network comprising tasks that when performed in a desired sequence populates the database with the data associated with the specific task.

Claims

1. A computer executed method for generating an application to create a specific entity model, comprising:

creating, by a processor, a work package specification for a work package associated with the specific entity model, the work package specification comprising a subset of metadata specifications stored within the database 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 is associated to a table within the database 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;

creating, by the processor, a task specification within the work package specification, the task specification defining a sequence of steps to be performed to populate each table of the plurality of entity specifications;

creating, by the processor, a view specification within the task specification, specifying a subset of the rows and columns of each table of the plurality of entity specifications which are viewable and populatable by a user during each step of the sequence of steps to be performed defined by the task specification; and

automatically creating, by the processor, the application based upon the work package specification, the task specification and the view specification, wherein the application, when executed generates a plurality of graphical user interface screens for each step of the sequence of steps defined by the task specification based upon the view specification and creates the specific entity model after the sequence of steps defined by the task specification are completed by the user.

2. The computer executed method of claim 1, wherein the data associated the specific model is received from one of a user and a device.

3. The computer executed method of claim 1, wherein the view specification defines a limited set of data tables within the database that are to be populated to generate the specific model.

4. The computer executed method of claim 3, wherein each graphical user interface screen is associated with one of the limited set of data tables being populated.

5. A computer program product recorded on a non-transitory storage medium comprising steps to create an application to generate a specific entity model that when executed by a processor:

create a work package specification for a work package associated with the specific entity model, the work package specification comprising a subset of metadata specifications stored within the database specifying 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 is associated to a table within the database 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;

create a task specification within the work package specification, the task specification defining a sequence of steps to be performed to populate each table of the plurality of entity specifications;

create a view specification within the task specification, specifying a subset of the rows and columns of each table of the plurality of entity specifications which are viewable and populatable by a user during each step of the sequence of steps to be performed defined by the task specification; and

automatically create the application based upon the work package specification, the task specification and the view specification, wherein the application, when executed generates a plurality of a graphical user interface screens for each step of the sequence of steps defined by the task specification based upon the view specification and creates the specific entity model after the sequence of steps defined by the task specification are completed by the user.

6. The computer program product of claim 5, wherein the view specification defines a limited set of data tables within the database that are to be populated to generate the specific model.

7. The computer program product of claim 6, wherein each graphical user interface (GUI) screen is associated with one of the limited set of data tables being populated.

8. A system configured to create an application to generate a specific entity model, comprising:

a computer readable storage device with a database comprising application data;

a display device configured to display a sequence of graphical user interface (GUI) screens to a user; and

a computing device executing a computer program product, wherein the computer program product containing instructions that when executed by the computing device;

create a work package specification for a work package associated with the specific entity model, the work package specification comprising a subset of metadata specifications stored within the database specifying 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 is associated to a table within the database 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;

create a task specification within the work package specification, the task specification defining a sequence of steps to be performed to populate each table of the plurality of entity specifications;

create a view specification within the task specification, specifying a subset of the rows and columns of each table of the plurality of entity specifications which are viewable and populatable by a user during each step of the sequence of steps to be performed defined by the task specification; and

automatically create the application based upon the work package specification, the task specification and the view specification, wherein the application, when executed generates a plurality of a graphical user interface screens for each step of the sequence of steps defined by the task specification based upon the view specification and creates the specific entity model after the sequence of steps defined by the task specification are completed by the user.

9. The system of claim 8, wherein the view specification defines a limited set of data tables within the database that are to be populated to generate the specific model.

10. The computer program product of claim 9, wherein each graphical user interface screen is associated with one of the limited set of data tables being populated.