Change support system related to data processing system, development environment of data processing system, production environment of data processing system, and change support method of data processing system

Abstract

To automatically transfer change contents applied to a test environment to a production environment when a procedure is newly developed in the test environment.SOLUTION: The change support system 1 according to the data processing system includes a production environment 3 and a development environment 2 as environments of the data processing system. The development environment 2 includes a test environment 22 that reproduces the production environment 3, and a development test unit 20 that outputs a package 6 including resources necessary for the operation of the new procedure developed using the test environment 22. The production environment 3 includes an environment migration unit 30 that deploys the resources included in the package 6 to the production environment 3 and migrates the resources included in the package 6 to the production environment 3.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a technique for supporting changes to a data processing system. [Background technology]

[0002] Data processing systems that process large amounts of data are used in a variety of fields, including business, education, medicine, and scientific research. Large-scale data processing systems have databases that store large amounts of data so that multiple types of data processing can be performed at high speed, and multiple procedures that use the databases to perform specific tasks.

[0003] When a reason for change arises in a procedure stored in a data processing system, such as adding a function or fixing a defect, the procedure for which the reason for the change occurred must be changed. In a data processing system that stores multiple procedures, making a change to one procedure may cause problems in other procedures.

[0004] Therefore, when changing one procedure, it is necessary to verify in advance that the change will not affect other procedures. The work involved in the verification in advance takes time, and human judgment makes it more likely for errors to occur. For this reason, in addition to the production environment that will be the environment for the data processing system in actual operation, a development environment has been prepared that includes a test environment that replicates the production environment, and testing is performed using the development environment instead of the production environment (for example, Patent Document 1). [Prior art documents] [Patent documents]

[0005] [Patent Document 1] Japanese Patent Application Publication No. 2018-205796 Summary of the Invention [Problem to be solved by the invention]

[0006] By preparing a development environment that has a test environment that replicates the production environment, new procedures can be developed and verified in advance without using the production environment, but changes made in the test environment must be migrated to the production environment.

[0007] Developing a new procedure requires not only developing a procedure that reflects the reasons for the change, but also modifying the objects that accompany the procedure change. When there are a large number of objects that need to be modified, manually migrating the objects modified in the test environment to the production environment can easily result in differences between the changes made in the test environment and the changes migrated to the production environment due to human error. If differences arise between the changes made in the test environment and the changes migrated to the production environment, even if the newly developed procedure works properly in the test environment, these differences could cause serious problems in the production environment, such as system failures.

[0008] Therefore, in the present application, when a procedure is newly developed in a test environment of a data processing system, changes made to the test environment can be automatically migrated to the production environment of the data processing system. [Means for solving the problem]

[0009] The first invention that solves the above-mentioned problem is a system for supporting changes to a data processing system that has a database that stores multiple objects and multiple procedures that use the database. The change support system for a data processing system according to the first invention includes a production environment and a development environment as the environments of the data processing system. In the change support system for a data processing system according to the first aspect of the present invention, the development environment includes a test environment that reproduces the production environment, and a development test unit that outputs a package including resources necessary for the operation of a new procedure developed using the test environment. The production environment includes an environment migration unit that deploys the resources included in the package to the production environment and migrates the resources to the production environment. In the first invention, the package is data indicating changes made to the test environment. In the first invention, the production environment is provided with a function for deploying the resources included in the package, so that when the new procedure is developed in the test environment, the changes made to the test environment can be automatically migrated to the production environment. In the first invention, the object used by the new procedure in the test environment can be the resource. In this case, when the development test unit in the development environment executes the new procedure in the test environment, it outputs an object package that includes the object used by the new procedure as the resource, and the environment migration unit in the production environment deploys the object included in the object package to the database in the production environment. Additionally, in the first invention, the executable file of the new procedure can be the resource. In this case, the development test unit of the development environment outputs a procedure package including the executable file of the new procedure as the resource, and the environment migration unit of the production environment deploys the executable file included in the procedure package to the production environment.

[0010] The second invention is a development environment for a data processing system having a database that stores multiple objects and multiple procedures that use the database, characterized in that it includes a test environment that reproduces the production environment of the data processing system, and a development test unit that outputs a package that includes resources necessary for the operation of a new procedure developed using the test environment. The second invention relates to a development environment that constitutes a change support system for the data processing system according to the first invention. As in the first invention, in the second invention, it is desirable that the development test section of the development environment outputs an object package as the package, which includes as resources the objects used by the new procedure in the test environment. Additionally, in the second aspect of the present invention, it is preferable that the development test unit of the development environment outputs, as the package, a procedure package that includes an execution file of the new procedure as the resource.

[0011] The third invention is a production environment for a data processing system having a database that stores multiple objects and multiple procedures that use the database, characterized in that when a package containing resources necessary for the operation of a new procedure developed using a development environment that has a test environment that reproduces the production environment is output from the development environment, the production environment for the data processing system is equipped with an environment migration unit that deploys the resources contained in the package to the production environment and migrates the resources to the production environment. The third invention relates to a production environment that constitutes a change support system for the data processing system according to the first invention. As in the first invention, in the third invention, the package is an object package that includes as the resource the object used by the new procedure in the test environment, and it is desirable that the environment migration unit deploys the object included in the object package to the database in the production environment. Additionally, in the third invention, it is desirable that the package be a procedure package that includes an executable file of the new procedure as the resource, and that the environment migration unit deploy the executable file included in the procedure package to the production environment.

[0012] The fourth invention is a procedure development process in which a development environment, which is an environment for a data processing system having a database that stores a plurality of objects and a plurality of procedures that use the database, outputs a package that includes resources necessary for the operation of a new procedure developed using a test environment that reproduces a production environment of the data processing system; and an environment migration process in which the production environment deploys the resources included in the package to the production environment and migrates the resources to the production environment. The present invention relates to a method for supporting changes to a data processing system, the method comprising: The fourth invention is a method invention corresponding to the first invention. In the fourth invention, in the procedure development process, the development environment preferably outputs an object package that includes as the package the objects used by the new procedure in the test environment as resources, and in the environment migration process, the production environment preferably deploys the objects included in the object package to the database of the production environment. In addition, in the fourth invention, in the procedure development process, it is desirable that the development environment outputs a procedure package that includes the executable file of the new procedure as the resource, and in the environment migration process, the production environment deploys the executable file included in the procedure package to the production environment. [Effects of the Invention]

[0013] In this way, the invention disclosed in this application makes it possible to automatically migrate changes made to a test environment when a new procedure is developed in the test environment of a data processing system to the production environment of the data processing system. [Brief explanation of the drawings]

[0014] [Figure 1] FIG. 1 is a diagram showing the overall configuration of a change support system for a data processing system. [Figure 2] FIG. 2 is a diagram showing an example of a hardware configuration of a server. [Figure 3] FIG. 2 is a diagram for explaining steps executed by a change support system for a data processing system. [Figure 4] FIG. 10 is a diagram illustrating an example of a change in a production environment. DETAILED DESCRIPTION OF THE INVENTION

[0015] From here, we will describe embodiments of the invention disclosed in this application. These embodiments are intended to facilitate understanding of the invention disclosed in this application, and the invention disclosed in this application is not limited to these embodiments. Furthermore, unless otherwise specified, the drawings are schematic diagrams drawn to facilitate understanding of the invention disclosed in this application.

[0016] 1 is a diagram showing the overall configuration of a change support system 1 for a data processing system. In this application, a data processing system refers to a system that includes a database that stores a large number of objects and multiple procedures that use the database to perform specific tasks.

[0017] Referring to FIG. 1, a change support system 1 for a data processing system includes a production environment 3 and a development environment 2 as environments for a data processing system to which the invention disclosed in this application is applied. The environment refers to a computer system in which the hardware and software necessary for the data processing system to operate are provided. The production environment 3 is an environment in which the data processing system is actually operated. The development environment 2 is an environment for carrying out development and testing of the data processing system to be actually operated. The change support system 1 for a data processing system is a system for supporting changes to a data processing system, and is configured to automatically migrate changes made to the production environment 3 in a test environment to the production environment 3.

[0018] The development environment 2 and the production environment 3 are each constructed on a server 7. Figure 2 shows an example of the hardware configuration of the server 7 used for the development environment 2 and the production environment 3. Note that in Figure 1, the server 7 on which the development environment 2 is constructed and the server 7 on which the production environment 3 is constructed are separate, but the development environment 2 and the production environment 3 can also be constructed on the same server 7. Furthermore, the development environment 2 and the production environment 3 can also be constructed using cloud technology.

[0019] The server 7 used in the development environment 2 and the production environment 3 includes, for example, a processor 70, a memory 71, a storage 72, and a network interface 73. The memory 71 is a volatile memory. The storage 72 is a large-capacity electrically rewritable non-volatile memory. The network interface 73 is an interface for communicating via a network. The processor 70 is an integrated circuit that has the function of executing a computer program transferred from the storage 72 to the memory 71.

[0020] The production environment 3 includes a database 31 that stores a plurality of objects 5, and a plurality of procedures 4 that execute predetermined tasks using the objects 5 stored in the database 31. In this application, the resources used by the procedures 4 are the procedures 4 themselves as well as the objects 5 used by the procedures 4.

[0021] Procedure 4 is a collection of procedures for database 31. For example, procedure 4 is a program including SQL statements for executing a specific task. In FIG. 1, production environment 3 stores procedure 4 separately from database 31, but procedure 4 can also be stored in database 31 of production environment 3. Procedure 4 is identified by a name added to procedure 4. According to FIG. 1, production environment 3 has procedure 4a, which is procedure 4 named A, procedure 4b, which is procedure 4 named B, and procedure 4c, which is procedure 4 named C.

[0022] The database 31 of the production environment 3, which is constructed using the storage 72 of the server 7, stores objects 5 used by the procedures 4 included in the production environment. An object 5 refers to a unit of data managed in the database 31. Typical objects 5 stored in the database 31 include tables, views, sequences, and data files. A table is a tabular object 5 having rows and columns. A view is an object 5 that is a part of a table or that processes and displays a table. A sequence is an object 5 that automatically generates a unique number. A data file is a file-format object 5 that stores data. Each object 5 is assigned a name used to identify the object 5. As shown in FIG. 1, the database 31 included in the production environment 3 stores an object 5a named A, an object 5b named B, an object 5c named C, an object 5d named D, and an object 5e named E.

[0023] The development environment 2 includes a test environment 22 that is a reproduction of the production environment 3. The test environment 22 included in the development environment 2 includes a database 21 that stores a plurality of procedures 4 and a plurality of objects 5. In this embodiment, the procedures 4 included in the production environment 3 and the procedures 4 included in the development environment 2 have the same reference numerals. It can be determined from the context whether the procedure 4 in the production environment 3 or the procedure 4 in the development environment 2 is being referred to. The same is true for the objects 5.

[0024] 1, test environment 22 has the same procedure 4 as production environment 3. Furthermore, database 21 of test environment 22 stores the same object 5 as production environment 3. For example, in FIG. 1, test environment 22 of development environment 2 has procedure 4a, procedure 4b, and procedure 4c as production environment 3. Furthermore, database 21 of test environment 22 of development environment 2 stores objects 5a, object 5b, object 5c, object 5d, and object 5e as production environment 3.

[0025] Each of the development environment 2 and the production environment 3 has a function for migrating the contents of the test environment 22 to the production environment 3 when a new procedure that will become the new procedure 4 is developed. The development environment 2 has a development test unit 20 that has a tool function for developing a new procedure using the test environment 22 and a function for outputting a package 6 for migrating resources required for the operation of the new procedure to the production environment 3. The production environment 3 also has an environment migration unit 30 that deploys resources included in the package 6 output by the development environment 2 to the production environment 3 as a function for migrating resources required for the operation of the new procedure to the production environment 3. The development test unit 20 is a function realized by using a processor 70 of the server 7 that configures the development environment 2. The environment migration unit 30 is a function realized by using a processor 70 of the server 7 that configures the production environment 3.

[0026] The development test unit 20 provided in the development environment 2 is a software development kit (SDK) that corresponds to the programming language of the procedure 4. The development test unit 20 has tool functions necessary for developing a new procedure, such as a function for editing and debugging a new procedure, a function for viewing objects 5 stored in a database 21 of the test environment 22 and a function for creating objects 5, and a function for displaying the execution results of the new procedure in the test environment 22.

[0027] The development test unit 20 provided in the development environment 2 also has a function of outputting a procedure package 6a including an executable file of a new procedure newly developed using the test environment 22, as a function of outputting a package 6 for migrating resources required for the operation of the new procedure to the production environment 3. Furthermore, the development test unit 20 provided in the development environment 2 has a function of tracking the objects 5 used by the new procedure in the test environment 22 when the new procedure is executed in the test environment 22, and outputting an object package 6b including the objects 5 used by the new procedure in the test environment 22.

[0028] The environment migration unit 30 of the production environment 3 has a function of deploying resources included in the package 6 output by the development environment 2 to the production environment 3 and migrating resources required for the operation of the new procedure to the production environment 3. In this embodiment, the environment migration unit 30 of the production environment 3 has a function of using the procedure package 6a output by the development environment 2 to deploy the executable file of the procedure 4 included in the procedure package 6a to the production environment 3 and migrating a newly developed new procedure to the production environment 3 using the test environment 22. Furthermore, the environment migration unit 30 of the production environment 3 has a function of deploying the objects 5 included in the object package 6b output by the development environment 2 to the database 31 of the production environment 3 and migrating the objects 5 used by the new procedure in the test environment 22 to the database 31 of the production environment 3. Note that deployment means storing the executable file of the procedure 4 and the objects 5 in the storage 72 of the production environment 3, etc., so that they can be used in the production environment 3.

[0029] Next, the steps executed by the change support system 1 for a data processing system will be described. Fig. 3 is a diagram for explaining the steps executed by the change support system 1 for a data processing system. The explanation with reference to Fig. 3 also serves as an explanation of the method for supporting change in a data processing system, which is the invention of the method disclosed in this application.

[0030] In the change support system 1 for a data processing system, first, a procedure development process S1 is carried out to develop a new procedure. The environment in which the procedure development process S1 is carried out is a development environment 2. The new procedure developed in the procedure development process S1 may be an improvement of an existing procedure 4, or may be an entirely new procedure 4. When improving an existing procedure 4, the tool functions of the development test department 20 are used to add improvements to the existing procedure 4. When creating an entirely new procedure 4, the tool functions of the development test department 20 are used to create an entirely new procedure 4.

[0031] The operation of a new procedure developed using the development test section 20 included in the development environment 2 is pre-verified in the test environment 22. If a defect is found in the new procedure itself during the pre-verification, the new procedure is corrected using the tool functions of the development test section 20 included in the development environment 2. Furthermore, if the operation of the new procedure requires changing an existing object 5 or adding a new object 5, the tool functions of the development test section 20 are used to change the object 5 stored in the database 21 of the test environment 22 or add a new object 5 to the database 21 of the test environment 22.

[0032] When the development of the new procedure is complete, the development test unit 20 included in the development environment 2 outputs a procedure package 6a including an executable file for the newly developed new procedure as a package 6 for migrating the new procedure to the production environment 3. This procedure package 6a can also include a configuration file for the new procedure. Furthermore, when the development of the new procedure is complete, the development test unit 20 included in the development environment 2 outputs an object package 6b including the objects 5 used by the new procedure as a package 6 for migrating the objects 5 used by the new procedure to the database 31 included in the production environment 3. Note that the operation of instructing the development test unit 20 of the development environment 2 to output the procedure package 6a and object package 6b may be done manually.

[0033] After the procedure development process S1 for developing a new procedure is carried out, an environment migration process S2 is carried out to migrate the contents of the test environment 22 when the development of the new procedure is completed to the production environment 3. The environment in which the environment migration process S2 is carried out is the production environment 3. The environment migration process S2 is a process for deploying the resources included in the package 6 (here, the procedure package 6a and object package 6b) output by the development environment 2 to the production environment 3, and migrating the resources used by the new procedure to the production environment 3.

[0034] In the environment migration step S2, the environment migration unit 30 of the production environment 3 first deploys the executable file included in the procedure package 6a output by the development environment 2 to the production environment 3, and migrates a new procedure newly developed in the development environment 2 to the production environment 3. If the procedure package 6a includes a setting file describing parameters for controlling the operation of the new procedure, the environment migration unit 30 also deploys the setting file included in the procedure package 6a to the production environment 3.

[0035] Next, the environment migration unit 30 of the production environment 3 deploys the objects 5 included in the object package 6b output by the development environment 2 to a database provided in the production environment 3, and migrates the objects 5 used by the new procedure to the database 31 of the production environment 3.

[0036] If an object 5 with the same name as an object 5 included in object package 6b is stored in the production environment 3, the environment migration unit 30 updates the existing object 5 already registered in the database 31 of the production environment 3 to the object 5 included in object package 6b. Also, if an object 5 with the same name as an object 5 included in object package 6b is not stored in the production environment 3, the environment migration unit 30 adds a new object 5 to the database 31 of the production environment 3.

[0037] Next, an example of changing the production environment 3 will be described. Fig. 4 is a diagram illustrating an example of changing the production environment 3. In Fig. 4, a new procedure, procedure 4a1, is developed by changing procedure 4a using the development test unit 20 of the development environment 2, and procedure 4a1 is registered in the test environment 22 instead of procedure 4a. The objects 5 used by procedure 4a1 in the test environment 22 are object 5a1, which is a change of object 5a, object 5c, object 5d, and newly added object 5f.

[0038] 4, procedure package 6a output by development environment 2 includes an executable file for procedure 4a1. Furthermore, object package 6b output by development environment 2 includes objects 5a1, 5c, 5d, and 5f. When environment migration unit 30 of production environment 3 uses procedure package 6a to deploy the executable file for procedure 4a1 newly developed in development environment 2 to production environment 3, procedure 4a registered in production environment 3 is changed to procedure 4a1 newly developed in development environment 2. Furthermore, when environment migration unit 30 of production environment 3 uses object package 6b to change database 31 of production environment 3, object 5a registered in database 31 of production environment 3 is changed to object 5a1, and object 5f is newly registered in database 31 of production environment 3. [Explanation of symbols]

[0039] 1. Change support system for data processing systems 2 Development environment 20 Development Test Department 21 Databases 22 Test Environment 3 Production Environment 30 Environmental Transition Department 31 databases 4 Procedure 5. Objects

Claims

1. 1. A system for supporting changes to a data processing system having a database that stores a plurality of objects and a plurality of procedures that use said database, comprising: The data processing system environment includes a production environment and a development environment, the development environment includes a test environment that reproduces the production environment, and a development test unit that outputs a package including resources necessary for the operation of a new procedure developed using the test environment; the production environment includes an environment migration unit that deploys the resources included in the package to the production environment and migrates the resources to the production environment; A change support system for a data processing system, comprising:

2. the development test unit of the development environment outputs an object package including, as the resource, the object used by the new procedure in the test environment; the environment migration unit of the production environment deploys the objects included in the object package to the database of the production environment; 2. A change support system for a data processing system according to claim 1.

3. the development test unit of the development environment outputs a procedure package including an executable file of the new procedure as the resource, as the package; the environment migration unit of the production environment deploys the executable file included in the procedure package to the production environment; 3. A change support system for a data processing system according to claim 1 or 2.

4. A development environment for a data processing system having a database that stores a plurality of objects and a plurality of procedures that use said database, comprising: a test environment that reproduces the production environment of the data processing system, and a development test unit that outputs a package including resources necessary for the operation of a new procedure developed using the test environment; A development environment for a data processing system, characterized by:

5. the development test unit of the development environment outputs, as the package, an object package including, as the resource, the object used by the new procedure in the test environment; 5. The development environment for a data processing system according to claim 4.

6. the development test unit of the development environment outputs a procedure package including an executable file of the new procedure as the resource, as the package; 6. A development environment for a data processing system according to claim 4 or 5.

7. 1. A production environment for a data processing system having a database storing a plurality of objects and a plurality of procedures that use said database, comprising: an environment migration unit that, when a package including resources necessary for operation of a new procedure developed using a development environment that has a test environment that reproduces the production environment is output from the development environment, deploys the resources included in the package to the production environment, and migrates the resources to the production environment; 1. A production environment for a data processing system, comprising:

8. the package is an object package that includes, as the resource, the object used by the new procedure in the test environment; the environment migration unit deploys the objects included in the object package to the database in the production environment.

8. The production environment of a data processing system according to claim 7.

9. the package is a procedure package that includes an executable file of the new procedure as the resource, The environment migration unit deploys the executable file included in the procedure package to the production environment.

9. A production environment for a data processing system according to claim 7 or 8.

10. a procedure development process in which a development environment, which is an environment for a data processing system having a database that stores a plurality of objects and a plurality of procedures that use said database, outputs a package including resources necessary for the operation of a new procedure developed using a test environment that reproduces the production environment of said data processing system; an environment migration process in which the production environment deploys the resources included in the package to the production environment and migrates the resources to the production environment; A method for supporting changes to a data processing system, comprising:

11. In the procedure development step, the development environment outputs an object package including, as the package, the object used by the new procedure in the test environment as the resource; In the environment migration step, the production environment deploys the objects included in the object package to the database of the production environment.

11. The method for supporting modification of a data processing system according to claim 10.

12. In the procedure development step, the development environment outputs a procedure package including an executable file of the new procedure as the resource, In the environment migration step, the production environment deploys an executable file included in the procedure package to the production environment.

12. The method for supporting modification of a data processing system according to claim 10 or 11.

Images