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 7,783,678 B2
• Filed: 04/27/2006
• Issued: 08/24/2010
• Est. Priority Date: 05/12/2005
• Status: Active Grant

• Current Assignee: Giloong Kim
• Original Assignee: Giloong Kim
• Inventors: Kim, Giloong
• Primary Examiner(s): Breene; John E
• Assistant Examiner(s): Kerzhner; Aleksandr
• Application Number:
  US11/413,939
• Publication Number:
  US 20060259506A1
• Time in Patent Office: 1,580 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/6, 707/7, 707/9, 707/10, 707/100, 707/101, 707/102, 707/200, 707/805, 707/999.102
• US Class Current: 707/805
• 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 the manufacturing process of a software program by using design information of the user interface form in a reverse order, the method comprising:

(a) generating the user interface form for the software program, the user interface form including an item name display section for displaying an item name of data to be input by a user using a graphic-user interface, a data input section for inputting data corresponding to the item name display section, and at least one function-discernible event button for managing database structure, as the graphic-user interface;

(b) allowing the user to designate a database (DB) name and a table name for the user interface form, such that the data input through the user interface form is stored therein;

(c) analyzing the user 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) automatically generating an ERD (Entity Relationship Diagram) synchronized with the user interface form by automatically configuring a field structure of the table with reference to the table name and the field design information, as the graphic-user interface;

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

(f) discerning a function of the function-discernable event button, automatically composing the SQL statement to be executed in linkage with an operation of the function-discernible event button, and automatically producing the software program which executes the SQL statement in linkage with the operation of the function-discernible 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 user 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 user 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, 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 user; and

automatically reflecting the changed matter on the ERD.

8. The method for automating a software manufacturing process based on user interface form design according to claim 1, 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 user; 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.

9. 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.

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