JP2010157165A - Information processor, information processing method, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To make it unnecessary to perform any coding operation, and to achieve the efficiency of development by providing a means for automatically generating a program from design information in developing a master maintenance system. <P>SOLUTION: This information processor is configured to extract information necessary for a master maintenance system from the design product of the master maintenance, and to convert the extracted information into a code, and to generate a master maintenance picture by executing the obtained code. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to generation of a master maintenance program, and more particularly to a generation method of a program for performing master maintenance on an edit screen using rich client technology in a two-layer system.

  In master maintenance, operations such as editing and acquisition of master information using GUI technology are performed. In general, when developing a master maintenance program, a table definition and a screen definition design document are first created, and then a program is developed based on the created design document.

  In a large-scale system, the number of master maintenance screens increases in proportion to the number of master information, and the development man-hours tend to increase. In addition, it was necessary to regenerate the source code according to the modification of the design document due to specification changes, etc., which had a great impact on development man-hours.

  Therefore, there is a need for a method and system for improving and automating the development of master maintenance so that it can cope with an increase in the number of screens and specification changes.

  Patent Document 1 discloses a technique related to automatic generation of master maintenance as a Web application.

Patent Document 2 discloses a technique related to automatic generation of a program and a specification from input data described in a spreadsheet.
JP 2006-285690 A JP 2003-263315 A

  However, in the screen automatic generation apparatus and its program described in Patent Document 1, it is possible to automatically reflect changes in the table definition on the screen. However, since this is a Web application, it is a Web server for performing master maintenance. It is necessary to go through, and is not compatible with the case of a two-layer system.

Further, in the automatic program generation apparatus described in Patent Document 2, a program and a design document can be automatically generated by correcting input data in response to a specification change. Since it is fixed, it is necessary to modify the format of the design document after automatic generation depending on the requirement.

  An object of the present invention is to suppress development man-hours by extracting design information from a program design document and generating a program in master maintenance of a two-layer system. In addition, since the design document is generally described in various formats in the spreadsheet, the information to be extracted can be flexibly defined in the spreadsheet so that it can be used for a general-purpose design document without fixing the format. Like that.

In order to achieve the above object, an information processing apparatus of the present invention has the following configuration. That is,
An information processing apparatus for generating a program for editing various master data managed in a database system,
First acquisition means for acquiring document data in which an information acquisition location is defined by tag information;
Second acquisition means for acquiring design information of master data defined in the document data acquired by the first acquisition means according to the tag information;
First generation means for generating entity information of master data based on the design information acquired by the second acquisition means;
Third acquisition means for acquiring definition information of an edit screen of master data having entity information generated by the first generation means from the document data;
Second generation means for generating screen information used for editing master data having entity information generated by the first generation means based on definition information of the edit screen acquired by the third acquisition means. It is characterized by.

In order to achieve the above object, an information processing method of the present invention comprises the following arrangement. That is,
An information processing method performed by an information processing device that generates information for editing various types of master data managed in a database system,
A first acquisition step of acquiring document data in which an information acquisition location is defined by tag information;
A second acquisition step of acquiring design information of master data defined in the document data acquired in the first acquisition step according to the tag information;
A first generation step of generating entity information of master data based on the design information acquired in the second acquisition step;
A third acquisition step of acquiring, from the document data, definition information of an edit screen of master data having entity information generated in the first generation step;
A second generation step of generating screen information used for editing the master data having the entity information generated in the first generation step based on the definition information of the edit screen acquired in the third acquisition step. It is characterized by.

In order to achieve the above object, the computer program of the present invention comprises the following arrangement. That is,
A computer program for causing a computer to function as an information processing device that generates information for editing various types of master data managed by a database system,
The computer,
First acquisition means for acquiring document data in which an information acquisition location is defined by tag information;
Second acquisition means for acquiring design information of master data defined in the document data acquired by the first acquisition means according to the tag information;
First generation means for generating entity information of master data based on the design information acquired by the second acquisition means;
Third acquisition means for acquiring definition information of an edit screen of master data having entity information generated by the first generation means from the document data;
Based on the definition information of the edit screen acquired by the third acquisition means, function as second generation means for generating screen information used for editing master data having entity information generated by the first generation means It is characterized by that.

ADVANTAGE OF THE INVENTION According to this invention, the automatic production | generation part which can extract the design information from the program design document in master maintenance development, and can produce | generate the code of a program, and the program execution part which can execute the produced | generated code can be provided.

  When the design is finished, the program can be executed immediately, so the development man-hour is reduced. Further, when there is a change in the specification, the correction is reflected in the program by correcting the design document, so that the specification change can be easily dealt with.

  In particular, since a design document described in a spreadsheet can support any format, the system developer can freely design using a spreadsheet.

  Hereinafter, an example of an embodiment of the present invention will be described with reference to the drawings.

  FIG. 1 is a diagram showing a configuration of a two-layer system according to an embodiment of the present invention. In FIG. 1, a database server 101 has a database mechanism for recording and managing various master data such as a customer master and a sales master.

  The client terminals 102-1 and 102-2 (hereinafter collectively referred to as the client terminal 102) execute a master maintenance program and request registration, update, deletion, search, and the like in the database managed by the database server 101 using the GUI. . The database server 101 performs these processes in response to requests.

  Reference numeral 103 denotes a network such as a local area network (LAN), for example, which connects the database server 101 and the client terminal 102 to each other so that data communication is possible.

  Next, the hardware configuration of the database server 101 and the client terminal 102 will be described with reference to FIG. FIG. 2 is a block diagram illustrating an example of the hardware configuration of the database server 101 and the information processing apparatus 102.

  In FIG. 2, reference numeral 201 denotes a CPU that controls the entire terminal (computer) using programs and data stored in the main memory 202, and the database server 101 or client terminal 102 to which the present computer is applied. Each process to be described later is executed.

  A main memory 202 temporarily stores programs and data loaded from the secondary storage 203 and includes a work area used by the CPU 201 to perform various processes.

  Reference numeral 203 denotes secondary storage, which stores various data such as programs and data for causing the CPU 201 to execute processing described later performed by the OS (operating system), the database server 101 to which the computer is applied, or the client terminal 102. These are read out to the main memory 202 and executed under the control of the CPU 201 as necessary.

  An input device 204 includes a keyboard and a pointing device, and inputs various instructions to the CPU 201.

  A display device 205 includes a CRT, a liquid crystal screen, and the like, and has a function of displaying information such as characters and images on a display screen.

  Reference numeral 206 denotes a network I / F (interface) for connecting a computer to the network 103. The computer can perform data communication with other devices on the network via the network I / F 206.

  Reference numeral 207 denotes a system bus, which functions as a bus for connecting the various components described above.

  FIG. 3 shows an input / output configuration of the information processing apparatus 305 that analyzes the program design document according to the present invention and generates a master maintenance screen.

  Reference numeral 301 denotes a design document described in a spreadsheet, which is a design document input to the information processing apparatus according to the present invention, in which design information and tag information are defined. Reference numeral 302 denotes a function included in the information processing apparatus 305 that analyzes tag information from a design document to extract design information and generates a code 303 from the extracted information.

  Reference numeral 303 denotes entity and screen program source codes and setting files, which are read by the master maintenance execution unit 304 of the information processing apparatus 305 when the program is started. Reference numeral 304 denotes a master maintenance execution unit that reads the code 303 provided in the information processing apparatus 305. The master maintenance execution unit 304 generates a user interface editing screen and a data access function that acquires and updates data in the database server 101.

  In order to execute master maintenance in the client terminal 102, it is necessary to install a set of code 303 and a master maintenance execution unit 304 (hereinafter, execution program) in the secondary storage 203. FIG. 4 shows a system configuration in which an execution program is installed in the client terminal 102.

  When master maintenance is executed at the client terminal 102, a program is read from the secondary storage 203 to the main storage 202, processing is executed by the CPU 201, and a master data editing screen is displayed on the display device 205. When a user requests acquisition of a list on the editing screen, the master maintenance execution unit 304 executes SQL for acquiring the list on the database 101 to acquire the list. The acquired list is drawn on the editing screen by the master maintenance execution unit 304.

  This completes the description of the system configuration of the present invention.

  Hereinafter, processing contents performed by the information processing apparatus according to the present invention will be described.

  FIG. 5 is a master maintenance execution flow, particularly a processing flow focused on the code automatic generation unit 302. This process is, for example, a process executed by the CPU 201 of the client apparatus 102 in FIG.

  In step S501, the type of database to be used, the file path of the spreadsheet 301, and the like are acquired as application setting information. In S502 and S504, the table definition and the screen design information described in the spreadsheet 301 are analyzed, and the entity 503 and the screen program 505 are created.

  If the table relation definition is used in S506, the table relation definition in which the relation information between the entities is defined is analyzed in S507 to create a related entity 508. By defining the relationship, it is possible to handle the relationship between each piece of permanent data in master maintenance.

  The created entity 503, the screen program 505, and the related entity 508 are compiled to obtain the code 303. When the master maintenance execution unit 304 is executed in S509, the master maintenance program is started.

  FIG. 6 is a screen image generated by the master maintenance execution unit 304. Reference numeral 601 denotes a menu screen. A list screen 602 displays a list of entities 503. A matrix table 603 displays related entities 508 between N to N entities.

  In S502, S504, and S507, an analysis process is performed on each design document. Details of each step will be described below.

  FIG. 7 is a processing flow for explaining the processing of S502 in FIG. 5 in detail, and is a flow for creating the entity 503 from the table design document.

  The table design document has two patterns that define all tables in one sheet or one table in one sheet, and the code automatic generation unit 302 corresponds to the two patterns.

  Since the path of the spreadsheet 301 describing the table design is obtained from the setting information acquired in S501, the spreadsheet 301 is read into the main memory 202 from the acquired path in S701.

  In S702, tag information is searched from the read spreadsheet. Tag information is information for defining design information to be extracted. FIG. 8 shows an example of a table design document 801 defining tag information. Reference numeral 802 denotes the meaning of the tag information being used.

  In S703, the code automatic generation unit 302 extracts design information according to the tag information definition. The extracted information is stored in the main memory 202.

  In S704, the source code of the entity 503 is created with the extracted information. The source code is generated by reading a template code template into the main memory 202 and replacing the portion corresponding to the placeholder with the value of the tag information to obtain the code.

  FIG. 9 is a tag information search flow. A process for searching for tag information from within a spreadsheet will be described. This process is a process showing details of step S702 in FIG.

  Before describing FIG. 9, tag information will be described first.

  Tag information is expressed by keywords enclosed in angle brackets, and is classified into two types of tag information.

1. Tag information for control:
A sheet reading operation by the code automatic generation unit 302 is controlled. Add "!" To the beginning of the keyword and define it in the first column of the spreadsheet. There are the following four types.
1) Reading start: Indicates the start of search. Use the following tag: <! START>, <! FORMAT_START>
2) Reading end: Indicates the end of the search. Use the following tag: <! END>, <! FORMAT_END>
3) Reading line skip: The line is not read. Use the following tag: <! COMMENT>
4) Format definition: Search column elements. Use the following tag: <! FORMAT>, <! VALUE_LOCATOR>

2. Tag information for extraction:
Define how to get the cell value. There are the following two types.
1) Address designation: The cell value of the designated address is acquired. The format is <tag name> = address.
2) Column index specification: The cell value at the specified column index is acquired. The format is <tag name>.

  Hereinafter, a tag information search method will be described with reference to FIG.

  In S901, data for one row is read from the read spreadsheet, and in S902, control tag information is acquired from the first column of the read data.

  In S903, if the control tag information is “end of reading”, the search process is ended.

  In S904 and 905, if the control tag information is “format definition”, the column element is searched for the read data. The tag information for extraction is acquired from the column elements, and the obtained set of tag information for extraction is stored in the main memory 202 as “format”.

  The format is roughly divided into the following two types.

1. Sheet format:
The format definition is <! VALUE_LOCATOR> is defined in the format defined in the case of VALUE_LOCATOR>. This is called a sheet format because it holds information unique to the sheet.

2. Line format:
The format definition is <! In the format defined in the case of FORMAT>, column index designation tag information is defined for the column element. Values are extracted from arbitrary column items by row format. Since a plurality of row formats can be specified for one sheet, names can be assigned to the row formats. The name of the row format is <! When FORMAT_XXX> is specified, the format name is XXX below FORMAT_.

  In step S906, the reading target is moved to the next line, the process starts again from step S901, and the process loops until the reading is completed.

  FIG. 10 is a flow for extracting design information from tag information. The process will be described.

  In S1001, design information is extracted from the sheet format. There is one sheet format per sheet. The sheet format is a set of address-designated tag information, and the address-designated tag information is a pair of a tag name and an address. The cell value is obtained by referring to the address from the tag information. This is performed for all tag information of collective elements.

  In S1002, design information is extracted from the line format. There are a plurality of row formats in one sheet. The row format is given a name, and in step S1003, the tag information for reading start control corresponding to the row format name is searched. When the row format name is XXX, the reading start is <! XXX_START>.

  In S1004, data for one line is acquired. In S1005, if the control tag information has been read, extraction by the line format is terminated, and processing is started from S1002 in the next line format.

  If the reading is not completed, in step S1006, tag information specifying a column index is acquired from the row format, and information is extracted from the column of the row with the matching column index. This is repeated as many times as the number of tag information constituting the line format.

  In S1007, the reading position is moved to the next line, and the process is started from S1004.

  In S1008, the extracted information is managed by a format name of a data structure such as a tag name / value pair.

  FIG. 11 shows an example of the above processing. 1101 is a spreadsheet in which tag information is defined, and 1102 is a data structure obtained from the extracted information after analysis.

  FIG. 12 is a flow for creating a screen program from a screen design document. The screen program is created by reading and analyzing the screen design document.

  In S1201, a spreadsheet 301 defining screen design information is read. In S1202, tag information is searched from the read sheet. In FIG. 13, reference numeral 1301 denotes an example of a screen design document in which tag information is defined. Reference numeral 1302 denotes the meaning of the tag information being used.

  In S1203, the code automatic generation unit 302 extracts design information according to the definition of the tag information. The extracted information is stored in the main memory 202.

  In the master maintenance of the present invention, a multi-stage cell layout can be defined in a merged cell on the grid of the editing screen. In S1204, the code automatic generation unit 302 analyzes the combined cell to convert the structure of the multistage layout into logical information, and outputs the layout structure to the setting file.

  In step S1205, the source code of the screen program 505 is created with the extracted information. The source code is generated by reading a template code template into the main memory 202 and replacing the portion corresponding to the placeholder with the value of the tag information to obtain the code.

  Then, the above process is repeated for the number of screen design documents to generate a screen program 505.

  The created source code and setting file are compiled and read into the master maintenance execution unit 304, and a master maintenance screen is generated.

  FIG. 14 is a processing flow for analyzing a cell layout.

  In S1401, the cell range is extracted from the tag information defining the cell layout from the screen design document.

  In S1402, the size of the combined cell is acquired, and a two-dimensional array of the same size is allocated on the main memory 202 to create a logical unit cell.

  In step S1403, a combined cell value is assigned to a logical unit cell (two-dimensional array element) on the main memory 202, and each unit cell is grouped with the combined cell value.

  In S1404, as shown in “4. Delete a plurality of rows having the same cell value” in FIG. 14, duplicate rows having the same all elements are deleted from the two-dimensional array.

  In S1405, duplicate columns having the same all elements are deleted from the two-dimensional array as shown in “5. Delete multiple columns having the same cell value” in FIG.

  In S1406, the remaining two-dimensional array is the logical structure of the cell layout. The logical structure is expressed by Top, Bottom, Left, and Right. When a two-dimensional array as shown in “6. Obtain logical structure of cell layout” in FIG. 14 is obtained, the logical structure is A = {Top: 0, Bottom: 0, Left: 0, Right: 0}. , B = {Top: 1, Bottom: 1, Left: 0, Right: 0}, C = {Top: 0, Bottom: 1, Left: 1, Right: 1}.

  The analysis result is output to the setting file on the screen. The grid of the edit screen is created based on the layout of the setting file.

  FIG. 15 is a flow for creating a related entity from the table relation definition.

  A related entity is an entity that defines a relationship between tables, and the relationship is classified into the following three types.

  1. Parent-child: When persisting different entities in the same table. (The relationship between entities is expressed by object-oriented “inheritance”.)

  2. Relation: N-to-N relationship between entities is defined.

  3. Composition: defines a 1-to-N relationship between entities.

  In S1501, a spreadsheet 301 defining table related information is read into the main memory 202, and in S1502, tag information is searched from the read sheet.

  In S1503, design information is extracted from the tag information, and in S1504, source codes of related entities are created. A template code template is used to generate the source code, and the code obtained by replacing the contents of the template with design information is output.

  The created source code is read into the master maintenance execution unit 304 as a related entity after being compiled.

  The above is the description of the processing content performed by the information processing apparatus according to the present invention.

  As described above, a recording medium in which a program code of software for realizing the functions of the above-described embodiments is recorded is supplied to the system or apparatus, and the computer (or CPU or MPU) of the system or apparatus is stored in the recording medium. It goes without saying that the object of the present invention can also be achieved by reading and executing the program code.

  In this case, the program code itself read from the recording medium realizes the novel function of the present invention, and the recording medium storing the program code constitutes the present invention.

  As a recording medium for supplying the program code, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, DVD-ROM, magnetic tape, nonvolatile memory card, ROM, EEPROM, A silicon disk or the like can be used.

  Further, by executing the program code read by the computer, not only the functions of the above-described embodiments are realized, but also an OS (operating system) or the like running on the computer based on the instruction of the program code. It goes without saying that a case where the function of the above-described embodiment is realized by performing part or all of the actual processing and the processing is included.

  Furthermore, after the program code read from the recording medium is written in a memory provided in a function expansion board inserted in the computer or a function expansion unit connected to the computer, the function expansion is performed based on the instruction of the program code. It goes without saying that the case where the CPU or the like provided in the board or the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

  Further, the present invention may be applied to a system composed of a plurality of devices or an apparatus composed of a single device. Needless to say, the present invention can be applied to a case where the present invention is achieved by supplying a program to a system or apparatus. In this case, by reading a recording medium storing a program represented by software for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention.

  Furthermore, by downloading a program represented by software for achieving the present invention from a server, database, etc. on a network using a communication program and reading it, the system or apparatus can enjoy the effects of the present invention. It becomes.

It is a figure which shows the structure of the two-layer system of embodiment of this invention. It is a figure which shows the hardware constitutions of the various terminals of this invention. This is an input / output configuration of an information processing apparatus 305 that analyzes a program design document according to the present invention and generates a master maintenance screen. This is a system configuration in which an execution program is installed in the client terminal 102. This is a master maintenance execution flow, particularly a processing flow focused on the code automatic generation unit 302. 3 is a screen image generated by a master maintenance execution unit 304. FIG. In the detailed processing flow of S502, the entity 503 is created from the table design document. It is a figure which shows an example of the table design document which defined tag information, and description of the meaning of the tag information used by a table design document. It is a figure explaining the process which searches tag information from within a spreadsheet. It is a flow for extracting design information from tag information. FIG. 5 is a diagram illustrating a spreadsheet in which tag information is defined and information extracted from the sheet. This is a flow for creating a screen program from a screen design document. It is a figure which shows an example of the screen design document which defined tag information, and description of the meaning of the tag information used by a screen design document. It is a processing flow which analyzes a cell layout. This is a flow for creating related entities from table relation definitions.

Explanation of symbols

101 Database server 102-1 and 102-2 Client terminal 103 Network 201 CPU
202 Main Memory 203 Secondary Storage 204 Input Device 205 Display Device 206 Network I / F
301 Design document (spreadsheet)
302 Code automatic generation unit 303 Code 304 Master maintenance execution unit 305 Information processing device 503 Entity 505 Screen program 508 Related entity 601 Menu screen 602 List screen 603 Matrix table screen 801 Table design document 802 Table design tag information 1101 Tag defined design 1102 Extraction information 1301 Screen design document 1302 Screen design document tag information

Claims (8)

An information processing apparatus that generates information for editing various master data managed in a database system,
First acquisition means for acquiring document data in which an information acquisition location is defined by tag information;
Second acquisition means for acquiring design information of master data defined in the document data acquired by the first acquisition means according to the tag information;
First generation means for generating entity information of master data based on the design information acquired by the second acquisition means;
Third acquisition means for acquiring definition information of an edit screen of master data having entity information generated by the first generation means from the document data;
Second generation means for generating screen information used for editing master data having entity information generated by the first generation means based on definition information of the edit screen acquired by the third acquisition means. An information processing apparatus characterized by the above. The information according to claim 1, wherein the document data includes at least ID information for uniquely identifying a data type, a data type, and an allowable number of input digits of data as design information of the master data. Processing equipment. The information processing apparatus according to claim 1, wherein a data name, an item name, and a control style are defined in the document data as definition information of the editing screen. In the document data, related information of master data is set,
The information processing apparatus according to claim 1, further comprising: a third generation unit that generates a relation definition between master data based on the relation information. The information processing apparatus according to claim 1, wherein the document data is a database design document generated by a spreadsheet. 6. The information processing apparatus according to claim 5, wherein in the document data, configuration information of the editing screen is defined as cell combination information. An information processing method performed by an information processing device that generates information for editing various types of master data managed in a database system,
A first acquisition step of acquiring document data in which an information acquisition location is defined by tag information;
A second acquisition step of acquiring design information of master data defined in the document data acquired in the first acquisition step according to the tag information;
A first generation step of generating entity information of master data based on the design information acquired in the second acquisition step;
A third acquisition step of acquiring, from the document data, definition information of an edit screen of master data having entity information generated in the first generation step;
A second generation step of generating screen information used for editing the master data having the entity information generated in the first generation step based on the definition information of the edit screen acquired in the third acquisition step. An information processing method characterized by the above. A computer program for causing a computer to function as an information processing device that generates information for editing various types of master data managed by a database system,
The computer,
First acquisition means for acquiring document data in which an information acquisition location is defined by tag information;
Second acquisition means for acquiring design information of master data defined in the document data acquired by the first acquisition means according to the tag information;
First generation means for generating entity information of master data based on the design information acquired by the second acquisition means;
Third acquisition means for acquiring definition information of an edit screen of master data having entity information generated by the first generation means from the document data;
Based on the definition information of the edit screen acquired by the third acquisition means, function as second generation means for generating screen information used for editing master data having entity information generated by the first generation means A computer program characterized by the above.

Images