Method for automating software manufacturing process based on user interface form design, and computer readable medium recording computer executable instruction for performing the same

• US 20060259506A1
• Filed: 04/27/2006
• Published: 11/16/2006
• Est. Priority Date: 05/12/2005
• Status: Active Grant

• Current Assignee: Giloong Kim
• Original Assignee: Giloong Kim
• Inventors: Kim, Giloong
• Granted Patent: US 7,783,678 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces

Abstract

A method for automating a software manufacturing process based on user interface form design designs a user interface form and then automates a manufacturing process to produce business program in a reverse order. This method includes generating a user interface form for business program including item name display section, data input section, and function-discernible event buttons, as graphic-user interface; allowing an interface form designer to designate DB name and table name; analyzing each interface form and automatically extracting field design information of table based on the item name and size of the data input section; generating ERD referring to the field design information and the table name, as graphic interface; automatically composing and executing SQL statement referring to the field structure to generate physical database; and automatically composing SQL statement executed in linkage with operation of the event button and linking the SQL statement to the event button.

Claims

1. A method for automating a software manufacturing process based on user interface form (or, input/output documents) design, which firstly designs a user interface form and then automates a manufacturing process so as to produce a business program in a reverse order, the method comprising:

(a) generating a user interface form (or, input/output documents) for a business program, which includes an item name display section for displaying an item name of data to be input by a user, a data input section for inputting data corresponding to the item name, and function-discernible event buttons, as a graphic-user interface;

(b) allowing a designer of each interface form to designate a database (DB) name and a table name, in which the data input through the interface form is to be stored;

(c) analyzing each interface form and automatically extracting field design information of a table on the basis of the item name in the item name display section and a size of the data input section;

(d) generating an ERD (Entity Relationship Diagram) defining a field structure of each table with reference to the field design information analyzed from each interface form and the table name designated for each interface form, as a graphic interface;

(e) automatically composing and executing a SQL (Structured Query Language) statement for generating a database with reference to the field structure of a table displayed in the ERD so as to generate a physical database; and

(f) automatically composing a SQL statement to be executed in linkage with an operation of the event button by means of discernment of the event button, and making the SQL statement be linked with an operation of the event button.

2. The method for automating a software manufacturing process based on user interface form design according to claim 1, wherein the step (c) includes:

(c1) allowing the designer to designate a search direction and a search range of the item name display section on the basis of the data input section included in each interface form;

(c2) extracting an item name written in the item name display section for each data input section by means of the designated search condition;

(c3) designating the extracted item name as a field name or processing the extracted item name on the basis of a predetermined standard to be designated as a field name;

(c4) calculating a size of the data input section to designate the size as a length of the field; and

(c5) linking the data input section to the designated field name.

3. The method for automating a software manufacturing process based on user interface form design according to claim 2, wherein, in the step (c3), blank and special character are removed from the extracted item name so as to process the extracted item name.

4. The method for automating a software manufacturing process based on user interface form design according to claim 2, wherein, in the step (c4), kind and size of a current font are recognized for each data input section to calculate the number of letters capable of being input to the data input section, and then the number of letters is designated as the length of the field.

5. The method for automating a software manufacturing process based on user interface form design according to claim 1, wherein, in the step (b), a predetermined character string in the interface form selected by the designer is designated as a table name.

6. The method for automating a software manufacturing process based on user interface form design according to claim 5, wherein the predetermined character string is a title of the interface form.

7. The method for automating a software manufacturing process based on user interface form design according to claim 1, wherein each user interface form and ERD are synchronized with each other.

8. The method for automating a software manufacturing process based on user interface form design according to claim 7, further comprising:

making addition, deletion or change in the item name display section and/or the data input section included in the user interface form by the designer; and

automatically reflecting the changed matter on the ERD.

9. The method for automating a software manufacturing process based on user interface form design according to claim 7, further comprising:

adding or deleting a field of a specific table included in the ERD or changing name and/or attribute of a field by the designer; and

automatically reflecting the above change in a form of addition, deletion or change of the item name display section and/or the data input section on the user interface form related to the specific table.

10. The method for automating a software manufacturing process based on user interface form design according to claim 1, the function of the event button is one selected from the group consisting of data storing, data deletion, movement to forward record and movement to backward record, or their mixtures.

11. A computer-readable recording medium in which the method defined in any of the claims 1 to 10 is programmed and recorded.