JP2010015458A - Program correction support system, program correction support method, and program correction support program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable specification without omission and customizing process for influenced portions following correction without referring to a source code in program correction work, and to increase the efficiency of the program correction work. <P>SOLUTION: This program correction support system 100 is composed of a correction direction acceptance means 110 which acquires attribute data and correction content data of correction object program parts contained in correction directions, a range estimating means 111 which specifies other program parts in a use relation, reads out the definition information of the other program parts from a part management table 125 and executes the similar data retrieval of the correction content data in the definition information, and specifies a data item similar to the correction contents, an update influence presentation means 112 which generates and displays information on the corrected data when the data item is updated by the correction content data, and an influence deciding means 113 which accepts decision directions on the corrected data information and executes updating with the correction content data on the part management table 125. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a program correction support system, a program correction support method, and a program correction support program. Specifically, the present invention relates to design of web-type business applications such as an ERP package, development support technology, and particularly designed by a development framework. The present invention relates to a technique for enabling program content modification without omission of source code, enabling specification and customization processing of a portion affected by the modification without omission, and realizing efficiency of program modification work.

  In order to streamline the development of business applications using Web technology, there are already technical concepts such as a design standard model for creating a program and a development environment compliant with this design standard model. For example, the design standard model includes an MVC (Model-View-Controller) model and a P / C / F / D / DB layer model that is an extension of the MVC model. The MVC model is designed by dividing the program configuration into three types: Model, View, and Control. In the P / C / F / D / DB layer model, the program structure is the Present layer (P layer), Control layer (C layer), Function layer (F layer), Data layer (D layer), Database layer. It is designed by dividing into four (DB layer).

  These layers are: Present layer (P layer): Screen display processing, Control layer (C layer): Layer that controls multiple business logic processes and performs processing such as screen operation units, Function layer (F layer): Business Layer for performing business logic processing in units (business-specific calculation processing is performed in this layer), Data layer (D layer): Table, layer for performing collective operations on table items, Database layer (DB layer): D It becomes a table configuration and a layer consisting of items to be operated in the layer.

  Furthermore, an information processing apparatus (see Patent Document 1) that supports setting of operation attributes of an application program has been proposed as a development environment that supports development work in conformity with such a design standard model. In this technology, the configuration of program parts is shown based on the above-mentioned P / C / F / D / DB layer model, and the development support framework platform is divided into P layer and C layer based on P / C layer definition information. The corresponding program part is generated. The P / C layer definition information is composed of “program configuration definition sheet”, “screen definition sheet”, and “data input / output definition sheet”, and these sheets relate to the F layer or D layer. Stores design information.

In addition, a method for detecting a portion requiring correction in a plurality of programs (see Patent Document 2) has been proposed. This technology extracts affected parts of program component changes and modifications, and modifies the changed parts. It extracts information necessary for maintenance from existing software and builds a repository by correlating those information with each other. It will be. From this repository information, existing software revisions are automatically extracted. In addition, substitution relations in the program, data area redefinition relations, and passing parameters / files between programs are detected, and correction points are extracted based on these.
JP 2008-40751 A Japanese Patent No. 2571492

  Here, when a series of business applications is developed using the technique disclosed in Patent Document 1 and a situation where such business applications are used by a plurality of companies, the following problems arise. In this case, since the detailed contents of the business are different for each company, a correction request is generated for the developed business application. For example, for the “product table” in the DB layer, there is a case where a correction request is generated to change the product category management classification in the table from 3 layers to 4 layers. When such a modification to the DB layer occurs, a modification request is generated for the program parts from the D layer to the P layer that use this directly or indirectly. In order to quickly perform this correction work, a processing method that supports the identification of the affected part and the correction work is required. However, the prior art cannot identify and correct such affected parts.

  On the other hand, even if the technique shown in Patent Document 2 is adopted in response to the above correction request, if the P / C / F / D / DB layer model is used as a premise, the affected part can be appropriately identified, The part cannot be modified. For example, the effect of changes that occur in the DB layer and the D layer are greatly different. For example, in the program component of the D layer and the DB layer, it is necessary to specify the change influence part between programs in consideration of the change contents of the database table structure itself. In addition, when the F layer program calls the D layer program, it is necessary to identify the change-affected location by paying attention to the change in the interface specifications of the program module. As described above, the process for specifying the change-affected location differs depending on the hierarchy to which the program component belongs. However, Patent Documents 1 and 2 do not take these points into consideration, and it is not possible to identify change-affected locations in program development based on the P / C / F / D / DB layer model and support correction work. .

  Therefore, the present invention has been made in view of the above-described problems, and in the case of a program correction work, it is possible to specify and customize processing without any omissions regarding the affected parts associated with the correction without referring to the source code. The purpose is to provide technology that realizes efficiency.

  The program correction support system according to the present invention is a computer system including storage means for storing a component management table in which definition information of each program component that is divided into layers and exchanges data between layers is stored for each layer. The program modification support system includes a modification instruction receiving unit that receives a modification instruction for a program part from an input interface and acquires attribute data and modification content data of a modification target program part included in the modification instruction. In particular, when a correction request is received, it is more preferable to generate a component management table using the attribute of the program component to be corrected and store it in the storage means. That is, in this aspect, each time the above processing is executed, the component management table is generated by utilizing the fact that program components are created according to a certain rule (by layer).

  Further, the program correction support system specifies the definition information of the corresponding correction target program component by collating the attribute data of the correction target program component with the component management table, and uses the definition information of the correction target program component as a key. Then, search for other program parts that are in the same layer as the program part to be corrected and have a usage relationship with each other, and read definition information of the other program parts searched here from the part management table And a range estimation means for performing a search for similar data of the correction content data in the definition information and specifying a data item similar to the correction content in the definition information.

  The program correction support system generates updated data information when the data item in the definition information of the other program part is updated with the correction content data, and displays the updated data information on the output interface. The update influence presentation means and a confirmation instruction for the updated data information are received from the input interface, and the data item in the definition information of the other program component is updated with the correction content data in the component management table. An effect determining means is provided for execution.

  In the program modification support system, the influence determination unit receives a modification instruction for the updated data information from an input interface, and the modification indicated by the modification instruction for the data item in the definition information of the other program component. It is good also as a structure which performs the update by a content with the said components management table.

  Further, in the program correction support system, the range estimation means defines the next correction target program part with the other program part that has been updated for the data item in the part management table as a next correction target program part. Information specified in the component management table, and using the definition information of the next modification target program component as a key, the next other program that belongs to the same layer as the next modification target program component and is in a usage relationship except for the modification target program component The part search is executed, the definition information of the next other program part searched here is read from the part management table, and in the definition information, the similar data of the data updated in the part management table is read. The next data item that is similar to the data after execution of the update in the definition information after executing the search It may be configured to identify.

  In this case, the update effect presenting means generates information of the data after the next update when the next data item in the definition information of the next other program part is updated with the data after the update execution, and after the next update Display data information on the output interface. In addition, the influence determination means receives a determination instruction for the data information after the next update from the input interface, and updates the next data item in the definition information of the next other program part with the data after the execution of the update. Execute with the component management table.

  Further, in the program correction support system, the range estimation means executes a search for the next other program component and a search for the next data item across the layers in the component management table, and a new next other program component. It may be configured to repeat the search for the next other program part and the search for the next data item until it cannot be specified.

  In this case, the update effect presentation unit generates the information of the data after the next update and displays the data information after the next update until the repetition of the specifying process of the next data item in the range estimation unit is completed. repeat. In addition, the influence determination means accepts a confirmation instruction for the data information after the next update and updates the data after the update execution for the next data item with the data after the next update by the update influence presentation means. The process is repeated until the information display process is completed.

  In the program correction support system, the correction instruction receiving unit, the range estimation unit, the update effect presentation unit, and the effect determination unit may be provided for each layer. In this case, the correction instruction accepting means for the layer A receives the correction instruction for the program part belonging to the layer A from the input interface, and the attribute data and the correction content of the correction target program part belonging to the layer A included in the correction instruction. Get data and.

  Further, the range A range estimation means identifies the correction target program part definition information by collating the correction target program part attribute data with the part management table, and determines the correction target program part definition information. Using the key as a key, a search is performed for other program parts that are in a usage relationship with the correction target program part in the layer A, and the definition information of the other program parts searched here is read from the part management table, and the definition A search for similar data of the correction content data in the information is executed, and a data item similar to the correction content is specified in the definition information.

  In addition, the layer A update effect presentation unit generates updated data information when the data item in the definition information of the other program component is updated with the correction content data, and outputs the updated data information Display on the interface.

  The influence determination means of the layer A receives a determination instruction for the updated data information from the input interface, and updates the data item in the definition information of the other program component with the correction content data. It will be executed in the management table.

  Further, in the program correction support system, the layer A range estimation means uses the other program part for which the data item has been updated in the part management table as the next correction target program part, and the next correction target program part. The definition information on the part management table is specified, and the definition information of the next modification target program part is used as a key to search for the next other program part that belongs to the layer A and has a usage relationship except for the modification target program part. The definition information of the next other program parts retrieved here is read from the parts management table, and similar data of the data updated in the parts management table is searched in the definition information. The configuration may be such that the next data item similar to the data after execution of the update is specified in the definition information.

  In this case, the update influence presentation unit of the layer A generates information of the data after the next update when the next data item in the definition information of the next other program part is updated with the data after the execution of the update, Displays the data information after the next update on the output interface. Further, the layer A influence determination means receives a determination instruction for the data information after the next update from the input interface, and uses the data after the update execution for the next data item in the definition information of the next other program part. Is updated in the component management table.

  In the program correction support system, the layer A range estimation means executes the search for the next other program component and the search for the next data item for other layers other than the layer A in the component management table. The search for the next other program component and the search for the next data item may be repeated until a new next other program component cannot be specified.

  In this case, the update influence presentation means of the layer A generates the information of the data after the next update and displays the data information after the next update, and repeats the specifying process of the next data item by the range estimation means. Repeat until finished. The influence determination means of the layer A accepts a confirmation instruction for the data information after the next update and updates the data after the execution of the update for the next data item with the update influence presentation means. This process is repeated until the display process of the updated data information is completed.

  The program correction support method according to the present invention further includes a storage unit that stores a component management table in which definition information of each program component that is divided into layers for each function and exchanges data between layers is stored for each layer. Receiving a correction instruction for the program part from the input interface, obtaining attribute data and correction content data of the correction target program part included in the correction instruction, and managing the attribute data of the correction target program part The definition information of the corresponding program part to be corrected is specified by collating with the table, and the program parts belonging to the same layer as the program part to be corrected are used with the definition information of the program part to be corrected as a key. Execute the search for other program parts in Processing for reading out definition information of a gram component from the component management table, searching for similar data of the modification content data in the definition information, and identifying a data item similar to the modification content in the definition information And processing for generating updated data information when the data item in the definition information of the other program component is updated with the correction content data, and displaying the updated data information on an output interface; Receiving a confirmation instruction for data information from an input interface, and executing, in the component management table, updating of the data item in the definition information of the other program component with the modification content data. And

  Further, the program correction support program of the present invention is a computer comprising storage means for storing a component management table in which definition information of each program component that is divided into layers and exchanges data between each layer is stored for each layer, Receiving a correction instruction for the program part from the input interface, obtaining attribute data and correction content data of the correction target program part included in the correction instruction; and attribute data of the correction target program part in the part management table The definition information of the corresponding program part to be corrected is specified by collation, and the program parts belonging to the same layer as the program part to be corrected are in the usage relationship with the definition information of the program part to be corrected as a key. Execute search for other program parts and search here. The definition information of other program parts is read from the part management table, the similar data of the correction content data in the definition information is searched, and the data item similar to the correction content is specified in the definition information Generating updated data information when the data items in the definition information of the other program parts are updated with the correction content data, and displaying the updated data information on an output interface; and Receiving a confirmation instruction for the post-update data information from the input interface, and executing the step of executing the update with the correction content data in the component management table for the data item in the definition information of the other program component It is characterized by.

  In the program modification support method and program described above, it is more preferable that when a modification request is received, a component management table is generated using the attribute of the program component to be modified and stored in the storage means.

  In addition, the problems disclosed by the present application and the solutions thereof will be clarified by the embodiments of the present invention and the drawings.

  According to the present invention, in the program correction work, it is possible to specify and customize processing without omissions about the affected part due to the correction without referring to the source code, and the efficiency of the program correction work can be realized.

--- System configuration ---
Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a network configuration diagram including a program correction support system 100 according to this embodiment. The program correction support system 100 (hereinafter, system 100) according to the present embodiment enables the specification and customization processing without omissions regarding the affected parts associated with the correction without referring to the source code during the program correction work. It is a computer system that realizes efficiency improvement.

  As a specific example, a server device for supporting correction work of business applications such as an ERP package can be assumed. In addition, an ERP package or the like is assumed to be designed based on a P / C / F / D / DB layer model that is an extension of the MVC (Model-View-Controller) model as a design model. In the P / C / F / D / DB layer model, the program structure is the Present layer (P layer), Control layer (C layer), Function layer (F layer), Data layer (D layer), Database layer (DB). It is designed by dividing into four layers. Also, these layers are: Present layer (P layer): screen display processing, Control layer (C layer): a layer that controls a plurality of business logic processes and performs processing such as screen operation units, Function layer (F layer) : A layer that performs business logic processing for each business unit (business-specific calculation processing is performed in this layer), Data layer (D layer): A layer that performs operations on tables and table items, Database layer (DB layer) : Means a table configuration and a layer consisting of items to be operated in the D layer. Thus, by clearly separating each program component for each function in each layer, development work can be performed for each layer, and division of development work becomes easy.

  However, when there is a usage relationship between program components within a layer or between layers, it is difficult to determine the effect of a specification change in a certain program component on other program components (same layer or other layers). Therefore, the program correction support system 100 according to the present embodiment makes it possible to specify and customize processing without any omissions regarding the affected parts associated with the correction without referring to the source code at the time of the program correction work, thereby improving the efficiency of the program correction work. Realize.

  An example of a development framework with such a design model is shown in FIG. The definition information in the P / C layer (for example, held in the component management table 125) is composed of “program configuration definition”, “screen definition”, and “data input / output definition” (Japanese Patent Laid-Open No. 2008-2009). No. 40751). Information is stored in these as follows. (1) Program configuration definition: defines program component configuration information used in an application program, and corresponds to a program configuration definition sheet in Japanese Patent Application Laid-Open No. 2008-40751 (for screen definition and data input / output definition described later) (2) Screen definition: Holds information related to screen attributes handled by an application program. Japanese Patent Application Laid-Open No. 2008-40751 Corresponds to the screen definition sheet in the gazette (consisting of the screen ID for which screen definition is to be performed, the branch number in the order of screen transition, screen items and their attributes, etc.), (3) Data input / output definition: at screen display And the contents of the data input / output processing that is performed when performing button operations on the screen, etc. Holding information about the calling process execution order or method of program component, such as in the time of the plane display (corresponding to the data input and output definition sheet in JP 2008-40751). Note that the component management table 125 is not stored in advance, and when a correction request is received by the correction instruction receiving unit 110, the component management table is generated by a generation unit (not shown) using the attribute of the program component to be corrected.

  By using the information of “program configuration definition”, “screen definition”, and “data input / output definition” described above, as shown in Japanese Patent Application Laid-Open No. 2008-40751, processing related to the P / C layer at the time of application execution Is generated. In the following description, it is assumed that the definition information of the P / C layer is stored as data in a unique XML format, and the information is stored with a file name such as “product management AP.xml”, for example.

  In the F layer, the D layer, and the DB layer in the present embodiment, there are C ++ program parts and tables as shown in the figure. These realization means themselves are realized by an ordinary program language or the like, but are based on the following restrictions because they are components conforming to the design framework. F layer component: SQL that directly manipulates DBMS is not described, but table operation is indirectly performed using D layer component or another F layer component, etc. D layer component: Search or change for multiple or single table -Perform operations related to registration (in the D layer component, SQL statements or equivalent descriptions are performed as program processing), DB layer: a table schema in the database system and a physical table realized by the table schema (Direct manipulation to this table is performed by D layer components).

  In the present embodiment, a situation where a business application such as an ERP package is being developed in a development framework based on such a configuration and conditions is adopted as an example.

  The system 100 reads out the program 102 stored in the storage device 101 such as a non-volatile memory into the memory 103 and executes it by the CPU 104 which is an arithmetic device in order to realize the function of executing the program correction support method. In addition, the system 100 includes an input interface 105 such as various buttons and a keyboard generally provided in a computer device, an output interface 106 such as an LED and a display, if necessary, and a user terminal 200 via a network 140. A communication device 107 that is responsible for communication with the communication device 107 may be included.

  Next, the means that the system 100 configures and holds based on the program 102 will be described. Each means may be provided integrally in one server device or the like, but is distributed and arranged in a computer group (including the server device corresponding to the system 100) arranged on the network 140, and one of the server devices (system 100). An example of collaboration under the leadership of The system stores at least the component management table 125 in the storage device 101.

  The system 100 inputs a correction instruction for the program component 50 (for example, “product table” in the DB layer in FIG. 2 and “class definition (Class SU_TBL [...])” In the D layer as well). A correction instruction receiving unit 110 is provided that receives from the interface 105 and acquires attribute data and correction content data of the correction target program component 50 included in the correction instruction.

  Further, the system 100 collates the attribute data of the modification target program component 50 with the component management table 125 to identify the definition information of the corresponding modification target program component 50, and also defines the definition information of the modification target program component 50. As a key, a search is performed for other program parts 51 that belong to the same layer as the program part 50 to be modified and have a usage relationship with each other, and the other program parts 51 searched here (for example, FIG. 2). The definition information of “sales table by branch office” in the DB layer is read from the component management table 125, and the similar data of the correction content data is searched in the definition information, and the correction is performed in the definition information. A range estimation unit 111 for specifying a data item similar to the content is provided.

  In addition, the system 100 generates updated data information when the data item in the definition information of the other program component 51 is updated with the correction content data, and displays the updated data information on the output interface 106. Update impact presentation means 112 is provided.

  Further, the system 100 receives a confirmation instruction for the updated data information from the input interface 105, and updates the data item in the definition information of the other program component 51 with the correction content data in the component management table. An influence determination unit 113 executed at 125 is provided.

  The influence determination unit 113 receives a correction instruction for the updated data information from the input interface 105, and updates the data item in the definition information of the other program component 51 with the correction content indicated by the correction instruction. May be executed by the component management table 125.

  The range estimation unit 111 replaces the other program part 51 that has been updated for the data item in the part management table 125 with the next modification target program part 52 (for example, the “sales table by branch office in the DB layer in FIG. 2). "), The definition information of the next correction target program part 52 is specified in the part management table 125, and the definition information of the next correction target program part 52 is used as a key to be in the same layer as the next correction target program part 52. A search is made for the next other program part that is in a usage relationship except for the modification target program part 50, and the next other program part 53 searched here (for example, "sector-specific sales table" in the DB layer in FIG. 2). Definition information is read from the component management table 125, and in the definition information, the component management table 125 It is also possible to perform a search for similar data of the data that has been updated, and specify the next data item similar to the data after the execution of the update in the definition information.

  Further, in this case, the update effect presentation unit 112 generates information of data after the next update when the next data item in the definition information of the next other program component 53 is updated with the data after the update execution, and The data information after the next update is displayed on the output interface 106. Further, the influence determination means 113 receives a determination instruction for the data information after the next update from the input interface 105, and the data after the update is executed for the next data item in the definition information of the next other program part 53. Is updated in the component management table 125.

  The range estimation unit 111 searches for the next other program component 53 and the search for the next data item across the layers in the component management table 125 (for example, between the DB layer and the D layer in FIG. D layer that executes a new next program part (for example, "Sales table by branch office" in the DB layer of FIG. 2) between the D layer and the F layer, between the F layer and the P / C layer, etc. "Class definition (Class SU_TBL [...])" in layer D and "Class definition (Class SU_TBL [...])" in layer D ...]) ", and until the" data input / output definition "of the P / C layer using the" class definition (Class F1 [...]) "in this F layer cannot be specified. The search for the next other program part and the search for the next data item may be repeated. In this case, the update effect presentation unit 112 completes the generation of the information of the next updated data and the display of the data information of the next update, and repeats the process of specifying the next data item in the range estimation unit 111. Repeat until In addition, the influence confirmation unit 113 receives a confirmation instruction for the data information after the next update, and updates the data after the execution of the update for the next data item. This is repeated until the subsequent data information display process is completed.

  In the program modification support system, the modification instruction receiving unit 110, the range estimation unit 111, the update effect presentation unit 112, and the effect determination unit 113 are associated with each layer (for example, each of the layers associated with each layer). It is also possible to easily provide a functional module for realizing the means. FIG. 1 shows an example in which the modules 110 to 113 are provided in modules for each layer (DB layer to P / C layer).

  In this case, the modification instruction accepting unit 110 of a certain layer A receives the modification instruction for the program part 50 belonging to the layer A from the input interface, and the attribute of the modification target program part 50 belonging to the layer A included in the modification instruction. Acquire data and modification data.

  In addition, the layer A range estimating means 111 collates the attribute data of the correction target program component 50 with the component management table 125 to identify definition information of the corresponding correction target program component 50, and the correction target program Using the definition information of the component 50 as a key, a search is performed for the other program component 51 having a usage relationship with the correction target program component 50 in the layer A, and the definition information of the other program component 51 searched here is Read from the component management table 125, search for similar data of the correction content data in the definition information, and specify a data item similar to the correction content in the definition information.

  In addition, the update influence presentation unit 112 of the layer A generates updated data information when the data item in the definition information of the other program component 51 is updated with the correction content data, and the updated data information Is displayed on the output interface 106.

  The layer A influence determining means 113 receives an instruction for determining the updated data information from the input interface 105 and updates the data item in the definition information of the other program component 51 with the correction content data. Is executed by the component management table 125.

  Here, the range A estimating unit 111 of the layer A uses the other program component 51 that has been updated for the data item in the component management table 125 as the next correction target program component 52, and the next correction target program component 52. Is defined in the component management table 125, and the definition information of the next modification target program component 52 is used as a key, and the next other program component belonging to the layer A and in the usage relationship except for the modification target program component 50 The definition information of the next other program component 53 retrieved here is read from the component management table 125, and the similarity of the data in the definition information that has been updated in the component management table 125 is read. Perform a data search and identify the next data item in the definition information that is similar to the updated data That.

  Further, the update effect presentation unit 112 of the layer A generates information on the data after the next update when the next data item in the definition information of the next other program part 53 is updated with the data after the update execution, The next updated data information is displayed on the output interface 106. In this case, the influence determination unit 113 of the layer A receives a determination instruction for the data information after the next update from the input interface 105, and executes the update for the next data item in the definition information of the next other program part 53. Updating with later data is executed by the component management table 125.

  In addition, the layer A range estimation unit 111 executes the search for the next other program component 53 and the search for the next data item for the other layers other than the layer A in the component management table 125, so that a new next The search for the next other program part and the search for the next data item may be repeated until the other program part cannot be specified.

  In this case, the update influence presentation unit 112 of the layer A performs the generation of the information of the next updated data and the display of the data information of the subsequent update in the process of specifying the next data item in the range estimation unit 111. Repeat until the iteration is complete. Further, the layer A influence determination unit 113 receives a confirmation instruction for the data information after the next update and updates the data after the update for the next data item with the update effect presentation unit 112. The process is repeated until the display process of the data information after the next update is completed.

  The units 110 to 113 in the system 100 described so far may be realized as hardware, or as a program stored in an appropriate storage device 101 such as a memory or an HDD (Hard Disk Drive). Also good. In this case, the CPU 103 of the system 100 reads the corresponding program 102 from the storage device 101 to the memory 103 and executes it in accordance with the program execution.

--- Example of table structure ---
Next, the structure of the table used by the system 100 in this embodiment will be described. FIG. 3 is a diagram illustrating a data structure example 1 of the component management table 125 and the inter-component correspondence management table 126 according to the present embodiment.

  The component management table 125 is a table in which definition information of each program component that is divided into layers for each function and exchanges data between the layers is stored in association with the layer, and is a nonvolatile storage device such as a hard disk drive. Stored in the means 101. This component management table 125 includes, for example, program component ID (in the figure: component management ID), component type (layer ID to which it belongs), class / table name (object class, table type, etc. of the corresponding program component). , A set of records in which function / item names (program part definition contents: table key items, function names used by programs, code data, and the like) are associated with each other. This component management table 125 is a storage folder for program components straddling each layer, which is stored by attaching the type data of the layer to which the engineer or the like who constructs the system adds the type data of the layer to which the component belongs.

  In addition, the inter-component correspondence management table 126 is configured such that when the system 100 receives a correction instruction from a user, based on the correction instruction and information stored in the component management table 125, the mutual correspondence between program parts is determined. Is a temporary table in which the usage relationships are tabulated and stored, for example, temporarily in the memory 103 (unlike the component management table 125, the system 100 always uses them from the beginning. Not possible). The inter-component correspondence management table 126 associates, for example, the ID of the program component on the use side with the ID of the inter-component correspondence management ID and the ID of the program component on the used side that uses functions and data from this program component. It is a collection of records.

  Next, another example of the component management table 125 and the inter-component correspondence management table 126 will be described. FIG. 4 is a diagram illustrating a data structure example 2 of the component management table 125 and the component correspondence management table 126 according to the present embodiment. Here, the component management table 125 is divided into layers (P / C layer, F layer, D layer, DB) storing definition information of each program component that is divided into layers and exchanges data between layers. Layer) and is stored in the storage means 101 which is a nonvolatile storage device such as a hard disk drive. The component management table 125 for each layer includes, for example, program component ID (in the figure: component management ID), class / table name (object class of the corresponding program component, table type, etc.), function / item name (program Component definition content: a set of records in which table key items, function names used by programs, code data, and the like) are associated with each other. This component management table 125 is a folder for storing program components for each layer, which is a storage location of the program components designed by an engineer or the like who constructs the system.

  The inter-part correspondence management table 126 is a program part between each layer based on the correction instruction and the stored information of the part management table 125 when the system 100 receives a correction instruction from users. It is a temporary table in which the mutual usage relationship is retrieved and the usage relationship is tabulated for each layer, and is temporarily stored in, for example, the memory 103 (unlike the component management table 125, the system 100 Is not always available from the beginning). This inter-component correspondence management table 126 uses, for example, the ID of the program component on the use side, and functions and data from this program component, using the inter-component correspondence management ID as a key for each layer (eg, D-DB layer). This is a set of records in which the IDs of the used program parts to be used are associated with each other.

  As shown in FIG. 1, the program parts group before execution of data update by the correction instruction is a pre-change program parts group 125a, and the program parts group after execution of data update by the correction instruction is changed. The post program component group 125b is used. The pre-change program component group 125a is the program component group itself before execution of the program correction support method of the present invention in the component management table 125, and the post-change program component group 125b is the program correction support method of the present invention. It becomes a program component group after execution and data update. Further, the change influence range information, the table change rule definition screen, the table change rule information, and the stratified change influence location display screen group in FIG. 1 will be described later.

  As described above, the component management table 125 is generated by the generation unit (not shown) using the attribute of the program component to be corrected when the correction instruction reception unit 110 receives a correction request. Is more preferred.

--- Processing flow example ---
Hereinafter, the actual procedure of the program correction support method in the present embodiment will be described with reference to the drawings. Various operations corresponding to the program correction support method described below are realized by the program 102 that the system 100 reads into the memory 103 and executes. The program 102 includes codes for performing various operations described below. Further, each means 110 to 113 in the system 100 will be described below assuming a situation provided for each of the DB layer to the P / C layer. Of course, only one of the means 110 to 113 may be provided in the system 100, and necessary processing may be performed across all the layers.

FIG. 5 is a flowchart showing a processing procedure example 1 of the program correction support method of the present embodiment. First, the DB layer correction instruction receiving means 110 in the system 100 receives a correction instruction for the program part 50 from the input interface 105 such as the table change rule definition screen 500, and the correction target program part included in the correction instruction. 50 attribute data and correction content data are acquired (s100).
In the table change rule definition screen 500 shown in FIG. 6, for example, it is assumed that correction content of the DB layer is received in units of tables. In the table change rule definition screen 500, the “change table name” list box includes a list of names of tables to be corrected (also referred to as program parts) (the system 100 lists from the parts management table 125). Indicated.

  Further, the system 100 is a table item based on the information of the table already defined in the DB layer (storage information of the pre-change program component group 125a) in the “table definition before change” area of the screen 500. Is displayed as a key item and a non-key item (non-key item). On the other hand, a list of changed key items and non-key items desired by a user such as a developer is displayed in the “table definition after change” area.

  For example, on the screen 500, for example, a user who accesses the system 100 using the user terminal 200 moves the right mouse button over a predetermined key item (or non-key item) in the “table definition after change” area. The system 100 reads out submenu data such as “add item”, “delete item”, and “change item name” from the storage device 101 and displays them. The user can edit the item names of key item lists and non-key items by appropriately selecting these submenus.

  Therefore, in response to the selection of the submenu, the system 100 reads from the storage device 101 a sub-screen that accepts correction content for the corresponding item and sends it to the user terminal 200, and accepts the key-in of the correction content on this sub-screen. Further, the system 100 detects the pressing of the “detailed item definition” button for attribute editing such as the data type of each item, and displays a sub-screen. On this sub-screen, the DBMS displays the data type, the number of digits, etc. Accept the attribute editing instructions required for the above table item definition.

  Further, the system 100 detects that the “definition registration” button on the screen 500 is pressed, and the correction instruction for the table: “product table” in the DB layer received on the screen 500: “in-product category” Addition is acquired and stored in the memory 103 or the storage device 101.

  Subsequently, the DB layer range estimation means 111 in the system 100 uses the attribute data (eg, table name, table ID, etc.) of the “product table” as the correction target program component 50 as a key, and the component management table 125. The stored data of the other records is searched for, and the other program parts 51: “sales table by branch office” and “sales table by department” in use relation are specified (s101). In the example of the component management table 125 of FIG. 3, for example, when the record of the component management ID “1” corresponds to the modification target program component 50, for example, “product code” as the attribute data. As a key, the record of the component management ID “2” including “product code” in the definition content can be specified. The range estimation unit 111 may list the information on the usage relationship between the program parts thus identified as the part correspondence management table 126 shown in FIGS. 3 and 4 and store it in the memory 103. In s100, it is more preferable that the component management table is not prepared in advance and the system 100 generates the component management table 125 using the attribute of the program component to be corrected.

  Next, the range estimation means 111 of the DB layer reads the definition information of the other program component 51 (in this case, the key item having a table structure) from the component management table 125, and the definition information in the definition information A similar data search of the correction content data is executed, and a data item similar to the correction content is specified in the definition information (s102). It should be noted that the similar data search process or the like may be employed for the similar data search process.

  As a result of such processing, for example, for the other program parts that are affected by the addition of the “product table” correction instruction “product category” in the DB layer, the update effect presentation means 112 in the DB layer in the system 100 For the key item in the definition information of the other program component 51, information of updated data when the correction content data “commodity category” is additionally updated is generated, and the updated data information is output to the user terminal 200 (or output). It is displayed on the interface 106) (s103).

  7 and 8 show a DB layer change influence location display screen (effect table axis) 600 and a DB layer change influence location display screen (key item list axis) 700 as display examples of the updated data. As shown in FIG. 7, the “DB layer change influence location display screen 600 includes items of“ influence source table name ”and“ display axis pattern ”. In “influence source table name”, the table name “product table” that is the source of the influence is displayed. In the list area of “display axis pattern”, options of information display methods in the display area 601 of the updated data are shown. In the example of the figure, “influence table name”, “key item list”, “non-key item list”, etc. can be selected.

  When “influence table name” is selected in the “display axis pattern” item, the system 100 displays the item list information before and after correction in association with the influence table name. When “key item list” is selected in the “display axis pattern” item, the system 100 displays the information before and after correction in association with each other as shown in FIG. Further, when “non-key item list” is selected in the “display axis pattern” item, the system 100 associates the information before and after the change for each non-key item in the same screen configuration as FIG. To display. In addition, when “influence relation diagram” is selected in the “display axis pattern” item, the system 100 reads out an “influence relation diagram screen” described later from the storage device 101 and displays it.

  By the way, when the system 100 receives a press of the “analogue processing for changed item” button 610 shown in FIG. 7, the system 100 changes the data before and after the correction between the rows in the table area 601 shown in FIG. The process of reducing the user's correction input work for the table area 601 is performed by automatically estimating the contents of the subsequent key items. In this case, the system 100 sets the “item list before correction” in a row having a larger number based on the correspondence relationship between the “item list before correction” and the “item list after correction” included in the row having a young line number. The content is automatically inferred.

  For example, in the screen example shown in FIG. 7, the user sets the contents of the corrected key item list of line number 1: “branch name, product major category, product middle category, product code” as “branch name, product major”. “Category 1, product major category 2, product middle category, product code” are corrected. At this time, when the user presses the “analogue processing for changed item” button 610 via the user terminal 200, the system 100 that has detected this presses the contents of the corrected key item list of line number 2: “Branch Name” , “Department name, major product category, middle product category, product code” is changed to “branch name, department name, major product category 1, major product category 2, middle product category, product code”. As described above, the system 100 automatically estimates the post-correction contents at a larger line number based on the pre-correction and post-correction item correspondence input with a young line number. Since the system 100 has such a function, it is possible to reduce the work of the user manually correcting the correction contents of similar items individually.

  In this way, the contents input by the operation on the screen 600, that is, the “table change rule information” shown in FIG. 1 is stored in the memory 103 or the storage device 101 of the system 100 using the format of text, DBMS table or the like. Saved in. The information storage format and means are not particularly limited as long as the information corresponding to the screen display items shown in FIG. Although the case of the DB layer has been described above, the respective means 110 to 112 provided corresponding to the respective layers similarly perform the processing for the D layer, the F layer, and the P / C layer other than the DB layer.

  Further, the DB layer influence determination means 113 in the system 100 receives a determination instruction for the updated data information from the user terminal 200 (or the input interface 105), and the data in the definition information of the other program component 51 The item is updated with the correction content data in the component management table 125 (s104). In the example of FIG. 7, the depression of the DB layer change reflection button 611 is detected as a confirmation instruction for the updated data information. The DB layer influence determination unit 113 receives a correction instruction for the updated data information from the input interface 105 such as the screen 600, and the correction instruction for the data item in the definition information of the other program component 51 is received. It is good also as updating with the correction content shown by said component management table 125.

  Next, the D layer range estimation means 111 performs the next correction on the other program parts “sales table by branch” and “sales table by department” that have been updated for the data item in the parts management table 125. As the program part 52, the attribute data of the next modification target program part 52 is collated with the part management table 125, and the next other program part that is in use relationship except for the modification target program part 50 is specified in the D layer. (S105). In the example of the present embodiment, a C ++ package located in the D layer is a candidate for the next other program component. For example, when the record of the part management ID “1” corresponds to the modification target program part 50, the “product code” is expressed by the function / item name using, for example, “product code” as the attribute data as a key. It is possible to specify a record (= “Class SYHN.TBL...” Of the component management ID “3” including “(= corresponding to a specific code in the function: for example,“ input1 ”).

  Further, the D layer range estimation means 111 reads the definition information (in this case, the C ++ source) of the next other program component 53 specified in the step s105 from the component management table 125, and includes the definition information in the definition information. , Similar data search of the data “product category” for which update in the component management table 125 has been executed, for example, a search for a key item group including “product category” etc., and the update information in the definition information The next data item similar to the post-execution data is specified (s106).

  Next, the update effect presentation unit 112 of the D layer generates information on the data after the next update when the next data item in the definition information of the next other program part 53 is updated with the data after the update execution. The next updated data information is displayed on the output interface 106 (s107). Further, the influence determination unit 113 of the D layer receives a confirmation instruction for the data information after the next update from the input interface 105, and after the execution of the update for the next data item in the definition information of the next other program part 53 Is updated in the component management table 125 (s108).

  Here, an example showing the influence on the D layer specified to be affected by the correction in the DB layer will be described with reference to FIG. The D layer change influence location display screen 800 in FIG. 9 includes an item “display axis pattern” as in FIG. 7. On this screen 800, a display axis pattern for operating the D layer can be selected. In the list area of “display axis pattern”, the information display method choices “influence destination method”, “influence occurrence source SQL element”, and “influence relation diagram” in the influence area display area 801 in the D layer are displayed.

  Further, the column “Affected Destination Method” in the display area 801 includes information of “Affected Class Name Before Modification / Method Name / IF” and “Affected Class Name After Modification / Method Name / IF”. In “Pre-modification affected class name / method name / IF” shown in the figure, the class name / method name / IF affected by the modification in the DB layer is displayed in the program part before modification existing at this time. . In “Modified Affected Class Name / Method Name / IF”, a result inferred as a corrected class name / method name / IF or a corrected result manually input by the user is displayed. When the user presses the “Modified method analogy processing” button 802, the system 100 detects this, and the analogized data after the next update in the “modified effect target class name / method name / IF” area. Display information. At this time, it is preferable that the system 100 executes a highlighting process such as displaying italicized characters for the estimated post-update data information.

  Further, the system 100 detects pressing of the “D layer change reflection” button 804 and registers the data information after the next update in the storage device 101.

  Further, in the column of “Effect occurrence source SQL element” shown in the figure, data of “SQL type”, “operation phrase”, and “Where phrase” are displayed. “SQL type” indicates whether the SQL type that is the source of the effect is to perform registration (= Insert), update (= Update), search (= Select), or delete (= Delete) processing. "Operation Phrase" is further composed of the one before modification and the one after modification, each displaying the item condition in the SQL operation phrase in the program before modification and the item condition in the SQL operation phrase in the program after modification To do. Similarly, the “Where clause” is composed of pre-correction and post-correction items, respectively, the item conditions in the SQL Where clause in the program before correction, and the item conditions in the SQL Where clause in the program after correction, respectively. Is displayed. When the user presses the “Modified SQL analogy processing” button 803, the system 100 detects this, and the “modified operation phrase item list” and “corrected Where phrase item list” are corrected. The analogy result (data information after the next update) is displayed.

  The D layer range estimation means 111 determines the next other program part 53 and the next data item in addition to the DB layer to the D layer, the D layer to the F layer, the F layer to the P / C. It may be executed across layers, and the identification of the next other program part and the identification of the next data item may be repeated until it becomes impossible to identify a new next other program part (of course, of other layers) It may be executed by the range estimation means 111).

  Similarly, the update effect presentation unit 112 of the D layer generates the information of the data after the next update and displays the data information after the next update of the next data item in the range estimation unit 111 of the D layer. Repeat until the specific process is completed. Further, the D layer influence determining means 113 receives a confirmation instruction for the data information after the next update, and updates the data after the update execution for the next data item with the update influence presenting means for the D layer. Step 112 is repeated until the display processing of the data information after the next update is completed.

  Through such a repeated processing flow, the system 100 also performs processing on the F layer and the P / C layer, which are upper layers of the D layer. In addition, when it is assumed that there are many F layer classes that are affected by the modification in the D layer, for example, one selection is accepted from the user terminal 200 as the class of the influence occurrence source, and the selection accepted here Narrow down the display contents for classes.

  Note that the F layer change influence location display screen 900 (FIG. 10), which is the processing result for the F layer, includes an item “display axis pattern” as in FIG. On this screen 900, a display axis pattern for operating the F layer can be selected. In the list area of “display axis pattern”, options of information display method in the display area 901 indicating the influence part from the D layer in the F layer, “influence destination method”, “influence source method”, “influence relation diagram” Is displayed.

  As shown in the figure, the display items in the area 901 are roughly divided into “influenced method” and “influenced source method”. “Affected method” is the same as “D layer change effect location display screen” in FIG. 9, “Before modification affected class name / method name / IF” and “Modified affected class name / method name / IF”. Consists of. Further, as in FIG. 8, a “post-change method analogy processing” button 902 is provided, and functions similar to those in FIG.

  Moreover, the processing result about a P / C layer is shown on the P / C layer change influence location display screen 1000-1200 of FIGS. In the “P / C layer change influence location display screen”, there is an item of “display axis pattern” as in FIG. On this screen, a display axis pattern for operating the P layer and the C layer can be selected. In the “display axis pattern” list area, there are choices of information display methods in the display area 1001 of the affected part in the P layer and C layer, “influence destination definition information”, “influence source method”, and “influence relation diagram”. Is shown.

  In the “P / C layer change influence location display screen”, tags of “program configuration definition”, “screen definition”, and “data input / output definition” are shown. When the user selects one of these tags, the system 100 changes the table items displayed on the screen as shown in FIGS. FIG. 11 shows a state in which the “program configuration definition” tag is selected, FIG. 12 shows a state in which the “data input / output definition” tag has been selected, and FIG. 13 shows a state in which the “screen definition” tag has been selected.

  As shown in FIGS. 11 to 12, the display data of the area 1001 is composed of “influence destination definition information” and “influence source class”. In the “influence destination definition information”, detailed items of definition information corresponding to the selected tag content are displayed. For example, in FIG. 12, a “data input / output definition” tag is selected, and “influence destination definition information” is composed of contents such as “program ID” and “data input / output definition” corresponding to this tag. Yes.

  In addition, the screen examples of FIGS. 11 to 12 are configured to display information before and after correction in units of records. In the definition information of "Program configuration definition", "Screen definition", and "Data input / output definition", the number of items to be defined is very large, so it is easy for the user to compare the definition item contents before and after modification. Therefore, the definition information before correction is displayed in the odd-numbered record column, and the definition information after correction is displayed in the even-numbered record.

  In the “program configuration definition” tag, the system 100 can accept a list selection of “influence program ID / branch number” from the user and narrow down the record information to be displayed in the area 1001. In the area 1001, a list of items defined as program configuration definitions is arranged. The item names and contents are the same as those described in Japanese Patent Application Laid-Open No. 2008-40751. In the area 1001, record information indicating the contents before and after correction is alternately displayed.

  In the “data input / output definition” tag, the system 100 can accept a list selection of “influence program ID / branch number” from the user and narrow down the record information to be displayed in the area 1001. In the area 1001, a list of items defined as program configuration definitions is arranged. The item names and contents are the same as those described in Japanese Patent Application Laid-Open No. 2008-40751. In the area 1001, record information indicating the contents before and after correction is alternately displayed.

  The “screen definition” tag allows the system 100 to accept a list selection of “influence screen ID” from the user and narrow down the record information to be displayed in the area 1001. In the area 1001, a list of items defined as program configuration definitions is arranged. The item names and contents are the same as those described in Japanese Patent Application Laid-Open No. 2008-40751. In the area 1001, record information indicating the contents before and after correction is alternately displayed.

  Through the processing as described above, the system 100 identifies the influence of the modification in the DB layer from the D layer to the P / C layer, estimates the modification content, presents it to the user, and receives a confirmation instruction from the user. The storage information update operation in the storage device 101 was executed. As a result, the degree of influence between the program parts from the DB layer to the P / C layer is generated by the system 100 as an influence relation diagram screen 1300. FIG. 14 shows an outline of the influence relation diagram screen 1300. The screen 1300 in this figure shows the influence relationship of each layer from the DB layer to the D layer, the F layer, the C layer, and the P layer. For this impact relationship, the affected party (in the same layer) that is directly affected by the location where the correction occurred, and the affected party (those that straddled the layer) that are further affected indirectly via the indirectly affected party There is. The system 100 displays the difference between the direct and indirect influence paths by distinguishing between direct: solid lines and indirect: dotted lines.

  Further, the system 100 counts the number of influence occurrence destinations (= program parts) associated with the correction in the DB layer for each layer, and displays the count value on the target layer on the screen 1300. For example, “P / C layer influence number” displays the number of definition information changes in the definition information of the P / C layer. Thus, a developer such as the user can perform an approximation of the development man-hour based on the change result by multiplying the change man-hour by one man-hour required for one change. Of course, the system 100 may calculate the man-hours that increase in the entire program generated by the correction related to a certain program component, and the calculation result may be returned to the user terminal 200.

  Further, buttons 1301 to 1304 are arranged below the P / C layer, F layer, D layer, and DB layer shown on the influence relation diagram screen 1300. When the arranged buttons 1301 to 1304 are pressed, the system 100 reads the data of the change influence location display screens (already shown in FIGS. 7 to 12) for each layer from the storage device 101, and the user terminal 200. Send to.

--- Detailed processing flow example 1 (impact related diagram screen display processing) ---
Next, the detailed flow of the various processes described above will be described. FIG. 15 is a flowchart showing a detailed processing procedure example 1 of the present embodiment. Here, each means 110 to 112 of the DB layer receives the table change rule information (input in FIG. 6) and executes the display processing of the DB layer change location screen shown in FIG. 7 and FIG. The constituent elements of the extended DB layer, that is, the information of the table in the DB layer is acquired (s300).

  Then, each means 110 to 112 of the D layer receives the DB layer element obtained in the step s300, and executes the display process of the D layer change location screen shown in FIG. Definition information such as component elements of the D layer, that is, c ++ source code is acquired (s301). Further, each of the means 110 to 112 of the F layer receives the D layer element obtained in the step s301, and executes the display process of the F layer change portion screen shown in FIG. Similarly, the constituent elements of the F layer are acquired (s302).

  Subsequently, each of the means 110 to 112 of the P / C layer receives the F layer element obtained in the step s302 and performs the display process of the P / C layer change portion screen shown in FIG. 11 in the non-display mode. The constituent elements of the P / C layer that are executed and are affected are similarly obtained (s303).

  Next, the update effect presentation unit 112 of each layer has a direct influence in the table change rule information (existing in FIG. 1 etc.) among the influence elements obtained in steps s300 to s303 so far, and change influence range information. What has been confirmed by the user in (shown in FIG. 1 etc.) is displayed as a directly related element on the screen (any of FIGS. 7 to 13 or FIG. 14) corresponding to each layer (s304). Further, those that have not been confirmed by the user are displayed on the screen 1300 of FIG. 14 as being indirectly affected (s305). Then, the elements that are not finally connected to the constituent elements from the DB layer to the P / C layer are displayed on the screen 1300 of FIG. 14 in a manner that distinguishes them from other elements (s306).

--- Detailed process flow example 2 (DB layer effect result display process 1) ---
FIG. 16 is a flowchart showing a detailed processing procedure example 2 of the present embodiment. Here, the range estimation unit 111 of the DB layer in the system 100 detects a table name list including key items (for example, those included in the correction instruction) of the table to be changed, and identifies it as a related table (s400). . Then, an item name (“key item name after change”) in which a change corresponding to the correction instruction occurs in the key item (pre-change key item) of the association table is specified (s401). In addition, in the non-key item of the related table, an item name (“changed key item name”) in which a change corresponding to the correction instruction occurs is specified (s402).

  Next, the update effect presentation unit 112 of the DB layer sorts the “post-change key item names” stored on the memory 103 in the order of, for example, the number of items in the “pre-change key item list” from the smallest. The result is displayed on the screen 600 of FIG. 7 as a “key item list after change” associated with the “key item list before change” (s403). Then, the display character attribute in the “changed key item list” field on the screen 600 is italicized so that it can be seen that the change result is automatically calculated (s404).

--- Detailed process flow example 3 (DB layer effect result display process 2) ---
FIG. 17 is a flowchart showing detailed processing procedure example 3 of the present embodiment. Here, the update effect presentation 112 of the DB layer in the system 100 classifies, as the “automatically changeable table”, for example, a table including all the key item lists before the change among the related tables (s500). Then, the update effect presentation unit 112 of the DB layer estimates the changed key item and the changed non-key item for each table based on the definition of the table change rule information for the “automatically changeable table” ( s501).

  Next, the update effect presentation unit 112 of the DB layer associates the item name before the change with the item name after the estimation result, and holds it as “item name information after change” on the memory 103 (s502). Subsequently, the update effect presentation unit 112 of the DB layer classifies the table that could not be classified as the “automatically changeable table” as the “automatically changeable table” (s503). Further, a list of key items that match the pre-change key item of the change target table is detected from the key items of each table that cannot be automatically changed (s504). Then, the update effect presentation unit 112 of the DB layer associates the detection result obtained in the step s504 with each automatically unchangeable table, sets it as a change source key item, sets the key item after change as “impossible to estimate”, It is stored in the “item name information after change” on 103 (s505).

--- Detailed process flow example 4 (D layer effect result display process 1) ---
FIG. 18 is a flowchart showing a detailed processing procedure example 4 of the present embodiment. Here, the update effect presentation unit 112 of the D layer in the system 100 decomposes, for example, the SQL included in the c ++ source code stored in the component management table 125 into an operation phrase and a conditional phrase (s600). In addition, a change process to the operation phrase item based on the table change rule information is executed (s601). Subsequently, a change process to the item in the conditional phrase based on the table change rule information is executed (s602). Further, the update effect presentation unit 112 of the D layer displays the pre-change item and the post-change item on the screen 800 of FIG. 9, for example, based on the “post-change item name information” (s603). Further, the set of the before-change item and the after-change item forming a pair is re-displayed as characters of the same color so that the change correspondence between the before-change and after-change items can be understood (s604). The layer D update effect presentation means 112 changes the line arrangement on the screen and redisplays the search condition phrase having a small number of items before the change and the operation phrase having a small number of items before the change as a sort condition. To do. (S605).

--- Detailed process flow example 5 (D layer effect result display process 2) ---
FIG. 19 is a flowchart showing a detailed processing procedure example 5 of the present embodiment. Here, the update effect presentation unit 112 of the D layer in the system 100 determines whether the single item name in the SQL partial phrase is included in the table change rule information (s700). If it is determined by this determination that the single item name is included in the table change rule information (s700: YES), the D layer update effect presenting means 112, based on the table change rule information, The changed item name is estimated for the corresponding single item name (s701). On the other hand, if it can be determined that it is not included (s700: NO), the item name after the change is set to “unguessable” (s702).

  Next, the update effect presenting means 112 of the D layer associates the item name before the change with the item name after the change after the estimation result, and “list of items in the operation phrase before change”, “ It is held as “item list in operation phrase after change” (s703). Then, it is determined whether or not a group of a plurality of items according to the AND condition in the SQL partial phrase is included in the table change rule information (s704). If it is determined by the determination that the group of the plurality of items is included in the table change rule information (s704: YES), the layer D update effect presentation unit 112, based on the table change rule information, The changed item name is estimated for the group of the corresponding item names (s705). On the other hand, if it can be determined that it is not included (s704: NO), the item name after the change is set to “unguessable” (s706). Then, the item name before the change and the item name after the change after the estimation result are associated with each other and stored as “item list in operation phrase before change” and “item list in operation phrase after change” on the memory 103 ( s707).

--- Detailed processing flow example 6 (F layer effect result display processing) ---
FIG. 20 is a flowchart showing detailed processing procedure example 6 of the present embodiment. Here, the F layer range estimation means 111 in the system 100 acquires the class name and source code name affected by the change from the D layer change influence information (s800). Next, the range estimation means 111 of the F layer analyzes the source code of the F layer class, and detects the one including the D layer class name and the method name as the affected F layer (s801). Further, the F layer range estimation means 111 stores the correspondence between the D layer class and the F layer class in the memory 103 as F layer change influence range information (s802), and based on the F layer change influence range information, the D layer And the F layer class are displayed on the screen 900 of FIG. 10 (s803).

--- Detailed processing flow example 7 (P / C layer effect result display processing) ---
FIG. 21 is a flowchart showing a detailed processing procedure example 7 of the present embodiment. Here, the P / C layer range estimation means 111 in the system 100 acquires the class / sod / argument name before the change and the class / method / argument name after the change from the F layer change influence range information ( s900). Further, the P / C layer range estimation means 111 searches the component management table 125 for the program configuration definition of the P / C layer definition information using the class / method / argument name before the change as a search condition, Identify the affected part of the affected program configuration definition. The P / C layer range estimation means 111 sets this as the program configuration definition information before the change (s901).

  Next, the update impact presentation unit 112 of the P / C layer converts the program configuration definition information before the change based on the correspondence relationship before and after the change of the class / method / argument name of the F layer. To calculate the program configuration definition information after the temporary placement change (s902). Further, the P / C layer update effect presentation unit 112 associates the program configuration definition information before the change with the program configuration definition information after the change, and outputs it as P / C layer change effect range information. The screen is displayed with the “program configuration definition” tag in the screen 1000 (s903).

  Subsequently, the P / C layer update effect presentation unit 112 searches the “data input / output definition” of the P / C layer definition information using the class / method / argument name before the change as a search condition, and determines the effect. Identify the affected location of the data input / output definition. This is the data input / output definition information before the change. Further, the P / C layer update effect presentation unit 112 specifies an argument name in the data input / output definition, and sets the item name corresponding to the argument name to “influence destination item name” (s904).

  The P / C layer update effect presentation means 112 converts the data input / output definition information before the change based on the correspondence before and after the change of the class / method / argument name of the previous description F layer. By performing the processing, the data input / output information after the temporary placement change is calculated (s905). Next, the data input / output definition information before the change and the data input / output definition information after the change are associated with each other and output as the P / C layer change influence range information. "Is displayed on the tag screen (s906).

  Further, the P / C layer update effect presentation unit 112 searches for “screen definition” in the P / C layer definition information using the “influence destination item name” as a search condition, and affects the affected location of the screen definition. Is identified. This is the screen definition information before the change (s907). Next, the update impact presentation means 112 of the P / C layer is based on the correspondence relationship before and after the change of the class / method / argument name of the previous description F layer, and the data entry / exit information before and after the change, By performing conversion processing on the screen definition information before the change, the screen information after the temporary placement change is calculated (s908). Then, the P / C layer update effect presentation unit 112 associates the screen definition information before the change with the screen definition information after the change, and outputs it as the P / C layer change effect range information. The screen is displayed on the “screen definition” tag on the screen 1000 (s909).

--- Other possible examples ---
As another example, the system 100 may execute a correction process in a direction opposite to the above-described example, from the screen correction work corresponding to the P / C layer to the correction of the lower DB layer. In this case, the system 100 that has received the modification contents of the screen defined in the P / C layer converts the F layer program component (C ++ package or the like) that provides the data used to generate the corresponding screen into the component. What is necessary is just to specify with the correspondence management table 126, and specify the content of the influence similarly to the above-mentioned. The same applies to the processing from the F layer to the DB layer.

  As described above, according to the present embodiment, in the program correction work, it is possible to specify and customize processing without any omissions regarding the affected parts due to the correction without referring to the source code, and to realize the efficiency of the program correction work.

  As mentioned above, although embodiment of this invention was described concretely based on the embodiment, it is not limited to this and can be variously changed in the range which does not deviate from the summary.

It is a network block diagram including the program correction assistance system in this embodiment. It is a figure which shows the example of the development framework in this embodiment. It is a figure which shows the data structure example 1 of the components management table of this embodiment, and the correspondence management table between components. It is a figure which shows the data structure example 2 of the components management table of this embodiment, and the correspondence management table between components. It is a flowchart which shows the process procedure example 1 of the program correction assistance method of this embodiment. It is a figure which shows the example of a table change rule definition screen of this embodiment. It is a figure which shows the DB layer change influence location display screen (influence table axis | shaft) example of this embodiment. It is a figure which shows the DB layer change influence location display screen (key item list axis | shaft) example of this embodiment. It is a figure which shows the D layer change influence location display screen example of this embodiment. It is a figure which shows the F layer change influence location display screen example of this embodiment. It is a figure which shows the example 1 of a P / C layer change influence location display screen of this embodiment. It is a figure which shows the example 2 of a P / C layer change influence location display screen of this embodiment. It is a figure which shows the example 3 of a P / C layer change influence location display screen of this embodiment. It is a figure which shows the example of an influence related figure screen of this embodiment. It is a flowchart which shows the detailed process sequence example 1 of this embodiment. It is a flowchart which shows the detailed process sequence example 2 of this embodiment. It is a flowchart which shows the detailed process sequence example 3 of this embodiment. It is a flowchart which shows the detailed process sequence example 4 of this embodiment. It is a flowchart which shows the detailed process sequence example 5 of this embodiment. It is a flowchart which shows the detailed process sequence example 6 of this embodiment. It is a flowchart which shows the detailed process sequence example 7 of this embodiment.

Explanation of symbols

50 Program Parts 100 Program Correction Support System 101 Storage Device 102 Program 103 Memory 104 CPU
105 Input Interface 106 Output Interface 107 Communication Device 110 Correction Instruction Receiving Unit 111 Range Estimation Unit 112 Update Effect Presentation Unit 113 Effect Determination Unit 125 Part Management Table 126 Interpart Correspondence Management Table 140 Network 200 User Terminal

Claims (12)

Storage means for storing a component management table in which definition information of each program component that is divided into layers for each function and exchanges data between the layers is stored for each layer,
A correction instruction receiving means for receiving a correction instruction for a program part from an input interface and acquiring attribute data and correction content data of a correction target program part included in the correction instruction;
The attribute data of the correction target program part is collated with the part management table to identify the definition information of the corresponding correction target program part, and with the definition information of the correction target program part as a key, A search for other program parts that belong to the same layer and are in a usage relationship with each other is executed, the definition information of the other program parts searched here is read from the part management table, and the definition information in the definition information A range estimation unit that performs a search for similar data of correction content data and identifies a data item similar to the correction content in the definition information;
An update effect presentation means for generating information on updated data when the data item in the definition information of the other program part is updated with the correction content data, and displaying the updated data information on an output interface;
An impact determination unit that receives a confirmation instruction for the updated data information from the input interface, and executes an update with the correction content data in the component management table for the data item in the definition information of the other program component;
A program correction support system comprising:   The influence determination unit receives a correction instruction for the updated data information from the input interface, and updates the data item in the definition information of the other program part with the correction content indicated by the correction instruction in the component management table. The program correction support system according to claim 1, wherein the program correction support system is executed. The range estimation means specifies the definition information of the next correction target program component in the component management table, with the other program component that has been updated for the data item in the component management table as the next correction target program component. Then, using the definition information of the next correction target program part as a key, a search is performed for the next other program part that belongs to the same layer as the next correction target program part and has a usage relationship except for the correction target program part. The definition information of the searched next other program parts is read out from the parts management table, and in the definition information, the similar data of the data updated in the parts management table is searched, and the definition information To identify the next data item similar to the data after execution of the update,
When the update effect presentation means updates the next data item in the definition information of the next other program part with the data after the update execution, generates information on the data after the next update, Which is displayed on the output interface,
The influence confirmation means receives a confirmation instruction for the data information after the next update from the input interface, and updates the data after the execution of the update for the next data item in the definition information of the next other program part. Which is executed in the management table,
The program correction support system according to claim 1 or 2, characterized in that The range estimating means executes the search for the next other program part and the search for the next data item across the layers in the part management table, and until the new next other program part cannot be specified. It repeats the search for the program part and the search for the next data item,
The update effect presentation unit repeats generation of the information of the data after the next update and display of the data information after the next update until the repetition of the specifying process of the next data item in the range estimation unit is completed. Yes,
The influence confirmation means accepts a confirmation instruction for the data information after the next update, and updates the data after the update execution for the next data item, and updates the data information after the next update by the update influence presentation means. It repeats until the repetition of the display process ends.
The program correction support system according to claim 3. The correction instruction receiving means, the range estimation means, the update effect presentation means, and the effect determination means are provided for each layer,
The correction instruction receiving means for the layer A receives a correction instruction for the program part belonging to the layer A from the input interface, and obtains attribute data and correction content data of the correction target program part belonging to the layer A included in the correction instruction. Acquired,
The range A range estimation means specifies attribute information of the modification target program component against the component management table to identify definition information of the corresponding modification target program component, and uses the definition information of the modification target program component as a key. In the layer A, a search for other program parts having a usage relationship with the correction target program part is executed, the definition information of the other program parts searched here is read from the part management table, and the definition information Performing a search for similar data of the correction content data in, identifying a data item similar to the correction content in the definition information,
The layer A update effect presentation means generates updated data information when the data item in the definition information of the other program part is updated with the correction content data, and uses the updated data information as an output interface. Display
The layer A influence determining means receives a determination instruction for the updated data information from the input interface, and updates the data item in the definition information of the other program component with the correction content data in the component management table. Run on,
The program correction support system according to claim 1 or 2, characterized in that The layer A range estimation means uses the other program part for which the data item has been updated in the part management table as the next correction target program part, and the definition information of the next correction target program part in the part management table. Using the definition information of the next modification target program part as a key, a search for the next other program part belonging to the layer A and excluding the modification target program part is performed, and the next The definition information of other program parts is read from the parts management table, and similar data of the data updated in the parts management table is searched in the definition information, and the update information is updated in the definition information. Identifies the next data item similar to the post-execution data,
The update effect presentation means of the layer A generates information of data after the next update when the next data item in the definition information of the next other program part is updated with the data after the update execution, and after the next update Data information is displayed on the output interface.
The influence determination means of the layer A receives a determination instruction for the data information after the next update from the input interface, and updates the next data item in the definition information of the next other program part with the data after the execution of the update. Is executed in the parts management table,
The program correction support system according to claim 5. The layer A range estimation means executes the search for the next other program component and the search for the next data item for other layers other than the layer A in the component management table, and specifies a new next other program component. Until the next other program part search and the next data item search process are repeated until
The update influence presentation unit of the layer A generates the information of the data after the next update and displays the data information after the next update until the repetition of the specifying process of the next data item in the range estimation unit is completed. It repeats,
After the next update by the update effect presenting means, the influence determination means of the layer A receives a confirmation instruction for the data information after the next update and updates the data after the update for the next data item. It is repeated until the repetition of the data information display process is completed.
The program correction support system according to claim 6. The program correction support system according to any one of claims 1 to 7,
When receiving by the correction instruction means, further comprising a component management table generating means for generating the component management table based on the received attribute data of the correction target program component,
The storage unit stores the generated component management table. Computer
A storage means for storing a component management table in which definition information of each program component that is divided into layers for each function and exchanges data between the layers is stored for each layer,
Processing for receiving a modification instruction for a program part from an input interface and acquiring attribute data and modification content data of a modification target program part included in the modification instruction;
The attribute data of the correction target program part is collated with the part management table to identify the definition information of the corresponding correction target program part, and with the definition information of the correction target program part as a key, A search for other program parts that belong to the same layer and are in a usage relationship with each other is executed, the definition information of the other program parts searched here is read from the part management table, and the definition information in the definition information A process of performing a search for similar data of correction content data and specifying a data item similar to the correction content in the definition information;
Processing for generating updated data information when the data items in the definition information of the other program parts are updated with the correction content data, and displaying the updated data information on an output interface;
A process of receiving a confirmation instruction for the updated data information from the input interface, and executing an update with the correction content data in the component management table for the data item in the definition information of the other program component;
A program correction support method comprising: The program correction support method according to claim 9,
When the correction instruction is received in the acquisition process, the component management table is further generated based on the received attribute data of the correction target program part;
The storage unit stores the generated component management table, and a program correction support method. In a computer comprising storage means for storing a component management table in which definition information of each program component that is divided into layers for each function and exchanges data between layers is stored for each layer,
Receiving a correction instruction for the program part from the input interface, obtaining attribute data and correction content data of the correction target program part included in the correction instruction;
The attribute data of the correction target program part is collated with the part management table to identify the definition information of the corresponding correction target program part, and with the definition information of the correction target program part as a key, A search for other program parts that belong to the same layer and are in a usage relationship with each other is executed, the definition information of the other program parts searched here is read from the part management table, and the definition information in the definition information Performing a search for similar data of correction content data, and specifying a data item similar to the correction content in the definition information;
Generating updated data information when the data item in the definition information of the other program part is updated with the correction content data, and displaying the updated data information on an output interface;
Receiving a confirmation instruction for the post-update data information from an input interface, and executing an update with the correction content data in the component management table for the data item in the definition information of the other program component;
A program correction support program characterized in that the program is executed. The program correction support program according to claim 11,
When the correction instruction is accepted in the obtaining step, the step of generating the component management table based on the received attribute data of the modification target program component is further executed.
The storage unit stores the generated component management table.

Images