JP2005190178A - Data maintenance apparatus, data maintenance method and data maintenance program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To automatically create a maintenance screen capable of displaying arbitrary substitute information easy for an operator to understand, without independent programming for every system. <P>SOLUTION: A data maintenance apparatus comprises an input operation part 11 with which an operator makes an input operation to a database 10 to be maintained, a screen creation processing part 12 for creating a maintenance screen for data operation during maintenance according to information input via the input operation part 11, and a display part 13 for displaying various information including the maintenance screen created by the screen creation processing part 12. The screen creation processing part 12 creates, according to data stored in the database 10, the maintenance screen on which the value of each item constituting the data is not a code but arbitrary substitute information easy for the operator to understand, and displays it on the display part 13. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a data maintenance apparatus, a data maintenance method, and a data maintenance program that perform maintenance of various data stored in a relational database.

  2. Description of the Related Art In recent years, various information processing systems using information processing apparatuses have been developed with the spread and advancement of information processing apparatuses such as computer devices. As one of such various information processing systems, for example, various operations are performed on data having a hierarchical structure expressed in a table format managed by a relational data model such as a so-called RDBMS (Relational DataBase Management System). Some perform predetermined processing to obtain output data. In particular, relational databases are widely used for managing data processed in an information processing apparatus.

  In such a relational database, each data forms a two-dimensional table describing the relationship. These tables relate to, for example, a predetermined management target and data uniquely assigned to the management target, list the items of the management target in the column direction, and describe the values of these items in the row direction. Formed by. Such a table is used as a user interface in a relational database. Further, in a relational database, each table can define not only a management target itself but also a pointer to another management target, thereby defining a relationship between a plurality of management targets.

  By the way, in this type of database system, it is inevitably necessary to perform various maintenance such as registration, update, and / or deletion of new data in system development. For example, Patent Documents 1 to 5 have been proposed as techniques related to such maintenance work.

JP-A-10-214111 JP-A-10-214212 Japanese Patent Laid-Open No. 11-232158 JP 2000-66932 A Japanese translation of PCT publication No. 2003-520363

  Specifically, Patent Document 1 discloses a database system equipped with a database that stores various data tables. In particular, this database system includes a maintenance script file that stores a plurality of maintenance scripts created for each data table on the database, and a script management file that stores final runtime data for each maintenance script stored in the maintenance script file. A time limit setting means for setting a time limit for processing to reorganize the data table on the database; an execution order determining means for determining the execution order of the maintenance scripts in order of the last execution time data stored in the script management file; In accordance with the order determined by the execution order determining means, the corresponding maintenance script of the maintenance script file is executed within the time limit set by the time limit setting means to execute the data table. A reorganization processing means for reorganization, in which a final runtime updating means for updating the final runtime data in the script management file maintenance script has finished running This reorganization means. As a result, in this database system, reorganization can be automatically and sequentially performed on the data tables to be reorganized, and all the data tables to be reorganized cannot be reorganized within the time limit. If this happens, it is possible to automatically perform reorganization from the next time onward, and as a result, it is possible to reduce the effort required for reorganization and improve the processing efficiency.

  Further, Patent Document 2 discloses a database system that stores facility data of a computer system that is operated online, uses this data for system operation, and performs data maintenance in response to the establishment / change / removal of the facility. In particular, this database system includes a data record for storing data, a record use flag for managing the use state of the record, a maintenance type for managing the maintenance type, and a change for managing the position of another record for storing the change contents. A database having a table constituted by pointers as a data storage unit element and a database access routine are provided. Then, the database access routine searches for an empty record with the record use flag at the time of data maintenance of the new equipment, sets the record to “use”, sets the maintenance type to “new”, and stores the new contents in the data record. The database access routine sets the maintenance type to “removal” at the time of data maintenance for facility removal. Furthermore, the database access routine searches for an empty record with the record use flag at the time of data maintenance for equipment change, sets the empty record to “use”, writes the change contents into the empty record, and uses the empty record in the change pointer of the original record. Is written and the maintenance type is changed. During the data maintenance, the database access routine rejects access from the operation process to the data record of the facility newly installed location, and accesses from the operation process to the data record of the facility removal location and the facility change location as requested. . As a result, in this database system, since data maintenance is performed using an empty area in anticipation of the invited image, an extra data area for data maintenance becomes unnecessary, and usage efficiency can be improved.

  Further, Patent Document 3 discloses a database maintenance management system that is installed in a system in which normal business processing using a database is continuously performed for 24 hours, and performs maintenance management of the database without stopping the normal business processing. ing. In particular, the database maintenance management system includes a master data receiving unit that receives master data for update sent from another system, and the master data is received by the master database when the master data receiving unit receives the master data. And a master management means for automatically reflecting the master maintenance function processing. Thus, in this database maintenance management system, the contents of the update master data can be automatically reflected in the master database without manual intervention.

  Furthermore, Patent Document 4 discloses a maintenance method for master information. In particular, the master information maintenance method includes a step of converting predetermined master information into text data, a step of inputting additional information to be added to the master information, and key information for specifying the additional information into a spreadsheet. And combining the text data and the additional information input to the spreadsheet to generate a new database. Thereby, the maintenance method of this master information can reflect the individual item which does not exist in positive master information efficiently and reliably in batch.

  Patent Document 5 discloses a data maintenance method in an offline distributed database network system having a central system having a central database and a plurality of node systems having a local database. In particular, in this data maintenance method, the local database contains at least partly different subsets of central database data, and the change information for the data stored in the database of the database network system is registered in multiple node systems. When the online connection is formed, the change information is transmitted from the node system to the central system as a replication object including ID keys structured in a plurality of different types, or from the central system to the node system. If there is no online connection, the replication object is adjusted in the output queue for later transmission and replicated in the central system of the replication object with the change information. Assigned to node system transmission destination via at least one look-up table as a destination by tio down algorithm, at least one look-up table, it is to update the realignment algorithm taking into account the modification information.

  By the way, in the database system, when performing maintenance, it is necessary to display a predetermined maintenance screen in order to operate data. However, since the data differs depending on the individual system, it is necessary to create such a maintenance screen by unique programming corresponding to the system. Specifically, there are things that take more than a month just by creating one maintenance screen, and it takes more time to perform the test, etc., which is very costly and troublesome Met.

  Further, in a database system, the values of items constituting each table are usually expressed by codes consisting of a series of numbers, symbols, etc. for convenience. Here, for example, a general-purpose database software such as Access provided by Microsoft (registered trademark) has a function to display data, so a maintenance screen for maintenance can be created. it can. However, since this type of general-purpose software simply displays data as it is, the code is also displayed as it is on the maintenance screen in response to the value being expressed by the code. Therefore, this type of general-purpose software needs to associate a code with an actual name separately, and in reality, it cannot be used.

  As described above, in the conventional database, since it is necessary to individually create maintenance screens for performing maintenance, the load on the system designer, the system administrator, and the operator who operates the system has increased remarkably. . In the database system, due to such a problem, there is a concern that an increase in development cost and maintenance cost and a decrease in quality are becoming remarkable.

  The present invention has been made in view of such a situation, and it is possible to replace a maintenance screen that can be displayed with any information that is easy for the operator to understand instead of a code without programming each system individually. An object of the present invention is to provide a data maintenance device, a data maintenance method, and a data maintenance program that can be automatically created.

  A data maintenance device according to the present invention that achieves the above-described object is a data maintenance device that performs maintenance of various data stored in a relational database, and is an input that is input by an operator to a database to be maintained. Operation means, screen creation processing means for creating a maintenance screen for operating data during maintenance based on information input via the input operation means, and maintenance created by the screen creation processing means Display means for displaying various information including a screen, and the screen creation processing means understands the value of each item constituting the data as the value of each item constituting the data, not the code, based on the data stored in the database. The above maintenance replaced with easy arbitrary information Create a face, it is characterized by displaying on the display means.

  In such a data maintenance device according to the present invention, a predetermined maintenance screen displayed for operating data during maintenance is automatically created by screen creation processing means based on the data regardless of the difference in the system. At the same time, the value of each item is replaced with arbitrary information that is easy for the operator to understand instead of the code, and is displayed on the display means.

  Specifically, the screen creation processing means creates the maintenance screen based on at least a system catalog describing information regarding the format of each item constituting the table stored in the database.

  The data maintenance apparatus according to the present invention can create the maintenance screen even when the system catalog is not used. In this case, the screen creation processing means creates the maintenance screen based on at least a user table describing information on the format of each item constituting the table stored in the database. This user table is created in advance. Thereby, even if the data maintenance apparatus concerning this invention is a database which is not provided with a system catalog, it can produce a maintenance screen appropriately.

  In addition, the data maintenance apparatus according to the present invention performs environment setting that defines the content of maintenance prior to performing maintenance.

  Specifically, the screen creation processing means lists all databases connectable to the operator, displays them in a selectable manner on the display means, and performs maintenance selected via the input operation means. A list of all tables stored in the database to be connected is read and displayed on the display means so as to be selectable. At this time, the screen creation processing means refers to the system catalog or user table of the selected database, and acquires information about the table based on this.

  Subsequently, the screen creation processing means reads a list of all items constituting the table selected via the input operation means, and displays the list on the display means. At this time, the screen creation processing unit refers to the system catalog or user table of the selected database, and acquires information on all items constituting the selected table based on the system catalog or user table.

  Then, the screen creation processing means is input through the input operation means, at least the name of maintenance data defining the content of the maintenance currently set, and the items on the maintenance screen to be finally created The maintenance screen based on the display order of the items, the display items that are the items to be displayed, the replacement items that are the items to be displayed instead of the code instead of the code, the item extraction conditions, and the operator representing the extraction conditions Create At this time, in setting the replacement item, the screen creation processing unit causes the display unit to display a target table having an item to be replaced and a list of all the tables as replacement destination candidates. The join condition with the selected replacement destination table is input via the input operation means.

  Further, the data maintenance apparatus according to the present invention can also deal with a table having a parent-child relationship, and the screen creation processing means is based on the definition of the parent-child relationship selected through the input operation means. Create the maintenance screen.

  Furthermore, the screen creation processing means can create the maintenance screen that allows selection of whether to display all data or only those that meet an arbitrary condition as a maintenance target.

  A data maintenance method according to the present invention that achieves the above-described object is a data maintenance method for maintaining various data stored in a relational database, and is an operator who performs an input operation on a database to be maintained. Based on the information input by the screen, various information including a screen creation processing step for creating a maintenance screen for operating data during maintenance and the maintenance screen created in the screen creation processing step is displayed on the display means. In the screen creation processing step, based on the data stored in the database, the value of each item constituting the data is not a code but arbitrary information that is easily understood by the operator. The replaced maintenance screen is created It is characterized.

  Furthermore, a data maintenance program according to the present invention that achieves the above-described object is a computer-executable data maintenance program that performs maintenance of various data stored in a relational database, and is for a database to be maintained. Based on the information input by the operator who performs the input operation, a screen creation process for creating a maintenance screen for operating data during maintenance and various information including the maintenance screen created by the screen creation process are displayed. Display processing to be displayed on the means, and in the screen creation processing, based on the data stored in the database, as the value of each item constituting the data, not the code but any information that the operator can easily understand The above maintainer replaced with It is characterized in that the scan screen is created.

  Each of the data maintenance method and the data maintenance program according to the present invention automatically displays a predetermined maintenance screen displayed for operating data during maintenance based on the data regardless of the system. In addition, the value of each item is replaced with arbitrary information that is easy for the operator to understand instead of the code, and is displayed on the display means.

  Since the present invention can easily create a maintenance screen customized according to the preference of the operator, the need for individual programming for each system can be eliminated as in the prior art. In addition to significantly reducing the load on the system administrator and the operator operating the system, it is also possible to reduce development and maintenance costs and improve quality.

  Hereinafter, specific embodiments to which the present invention is applied will be described in detail with reference to the drawings.

  This embodiment is a data maintenance apparatus that performs maintenance of various data stored in a relational database. This data maintenance device automatically creates a predetermined maintenance screen to be displayed for operating data during maintenance based on the data regardless of the difference in the system. The information can be replaced with arbitrary information that can be easily understood by the operator.

  In the following, for the convenience of explanation, it is assumed that the main data maintenance in the relational database, that is, the master maintenance will be described. Hereinafter, for convenience of explanation, a database including a so-called system catalog will be described.

  For example, as shown in FIG. 1, the data maintenance device includes an input operation unit 11 that is an input operation unit for an operator to perform an input operation on a database 10 to be maintained, and an input operation unit 11 that is used to input the data maintenance device. A screen creation processing unit 12 that is a screen creation processing unit that creates a predetermined maintenance screen based on the information, and a display unit 13 that is a display unit that displays various types of information including the maintenance screen created by the screen creation processing unit 12. With.

  The input operation unit 11 is configured as a user interface including various operation devices such as a keyboard and a mouse. In the data maintenance apparatus, an operator who performs maintenance performs various information input operations via the input operation unit 11. Information input via the input operation unit 11 is supplied to the screen creation processing unit 12.

  The screen creation processing unit 12 accesses the database 10 in response to an instruction given via the input operation unit 11 and creates a maintenance screen based on the system catalog of the database 10. The system catalog is management information related to a table described by a relational database management system, and describes at least information related to the format of each item constituting the table. Normally, the system catalog is unique to a database because it is copied from a template database when a database is created except for a part. The screen creation processing unit 12 acquires such a system catalog from the database 10 in accordance with an instruction made via the input operation unit 11, reads out each item constituting the table based on the system catalog, Create a maintenance screen. The screen creation processing unit 12 displays the created maintenance screen on the display unit 13.

  The display unit 13 is configured as a user interface including various display devices such as an LCD (Liquid Crystal Display). The display unit 13 includes a maintenance screen for manipulating data when performing maintenance created by the screen creation processing unit 12, a predetermined screen for performing environment settings described later necessary for performing maintenance, Display various other information.

  In terms of hardware, such a data maintenance apparatus can realize the function of the screen creation processing unit 12 by a CPU (Central Processing Unit) controlled according to a program developed on a predetermined memory.

  Now, such a data maintenance device performs an environment setting that defines the content of the maintenance by performing a series of steps as shown in FIG. 2, for example, before performing the maintenance.

  First, in the data maintenance apparatus, as shown in the figure, in step S1, the operator starts an environment setting program and logs on to the system. Specifically, the data maintenance apparatus displays a logon screen as shown in FIG. 3 on the display unit 13 under the control of the screen creation processing unit 12, for example.

  In this logon screen, a list of at least one database provided in the system is described as a connection destination list. The operator inputs a user name, password, host character string, and the like on the logon screen via the input operation unit 11. In response to this, the data maintenance apparatus authenticates the legitimacy of the operator, lists all databases connectable to the operator, and displays them on the logon screen. The operator highlights and selects a database to be connected via the input operation unit 11 for maintenance.

  When the database is selected by the operator, the data maintenance device displays an environment setting menu screen as shown in FIG. 4 on the display unit 13 under the control of the screen creation processing unit 12, for example.

  This configuration menu screen describes a list of maintenance data that defines the contents of maintenance. In the initial state where maintenance data has not yet been defined, no state is listed as shown in the figure. It is said. When defining new maintenance data, the operator can set the environment by selecting a new registration button provided on the environment setting menu screen via the input operation unit 11.

  When shifting to the environment setting, the data maintenance apparatus reads a list of all tables stored in the selected database under the control of the screen creation processing unit 12 in step S2 in FIG. Specifically, the screen creation processing unit 12 refers to the system catalog of the selected database, and acquires information about the table based on this. Then, the data maintenance device displays a table selection screen as shown in FIG. 5 on the display unit 13 under the control of the screen creation processing unit 12, for example.

  This table selection screen describes a list of all tables stored in the selected database. In step S3 in FIG. 2, the operator highlights and selects a table to be operated from the list via the input operation unit 11. At this time, the data maintenance apparatus can also deal with a table having a parent-child relationship, and the operator determines whether to perform maintenance using a single table or maintenance including a child table via the input operation unit 11. Select one of the items with radio buttons for selection.

  Subsequently, in step S4, the data maintenance device acquires and reads a list of all items constituting the selected table based on the system catalog under the control of the screen creation processing unit 12. For example, it is displayed on the display unit 13 as an item setting screen as shown in FIG.

  This item setting screen describes a list of all items of the selected table, and describes at least the type (format) of each item based on the system catalog. In step S5 in FIG. 2, the operator inputs the name of the currently set maintenance data via the input operation unit 11, and finally displays the order of items on the maintenance screen to be created and the items to be displayed. (Display item), an item to be displayed by being replaced with arbitrary information instead of a code (replacement item), an item extraction condition, an operator representing the extraction condition, and the like are selected. At this time, the operator selects a replacement item setting button provided on the item setting screen via the input operation unit 11 when setting the replacement item.

  In response to this, in step S6, the data maintenance device reads a list of all tables stored in the selected database based on the system catalog under the control of the screen creation processing unit 12. Is displayed on the display unit 13 as a replacement item setting screen as shown in FIG.

  This replacement item setting screen describes a target table having an item to be replaced and a list of all tables as replacement destination candidates. When the operator checks the check button attached to the corresponding candidate from the list of all the tables as replacement destination candidates via the input operation unit 11, the data maintenance device controls the screen creation processing unit 12. Based on the system catalog, all items in the checked table are read out based on the system catalog, and the contents of the table are displayed on the display unit 13. In step S7 in FIG. 2, the operator inputs a coupling condition such as an internal coupling or an external coupling through the input operation unit 11.

  In step S8, the data maintenance device registers information input by the operator as maintenance data, and ends a series of environment settings. In the data maintenance device, a plurality of maintenance data can be created by repeatedly performing such processing. When the same operator logs on next time, the data maintenance device displays a list of maintenance data created in the past on the environment setting menu screen, for example, as shown in FIG. Note that the name displayed to identify the maintenance data is the name input on the item setting screen shown in FIG. Further, the data maintenance device can also correct the setting of maintenance data created in the past, and the setting content corrected last is automatically reflected in the maintenance data.

  When the data maintenance apparatus actually performs maintenance, when the operator starts the maintenance program and logs on to the system, the data maintenance apparatus previously shown in FIG. Similar to the environment setting menu, a predetermined screen on which a list of maintenance data is described is displayed on the display unit 13. Then, when the operator selects maintenance data in which the contents to be maintained are defined from the list via the input operation unit 11, the data maintenance device creates a maintenance screen having the contents defined by the maintenance data. Created by the processing unit 12 and displayed on the display unit 13.

  For example, as shown in FIG. 9, a case is considered in which inventory data, which is a table composed of a plurality of records including items such as inventory numbers, product codes, and quantities, is maintained. Here, the product code consisting of a series of numbers, symbols, and the like is not displayed as it is on the maintenance screen, but is displayed by replacing it with a specific product name. In this case, the data maintenance device may set the product name as the item of the product master as the replacement destination of the product code serving as a key in the environment setting described above, and register it as maintenance data.

  Thereby, the data maintenance apparatus can display the maintenance screen as shown in FIG. 10 on the display unit 13 under the control of the screen creation processing unit 12, for example. That is, in the data maintenance apparatus, normally, the item in which the product code is displayed as it is is displayed in a form in which it is replaced with a specific product name defined in the product master.

  In addition, the maintenance screen is provided with an all item search button for displaying all data and a condition search button for displaying only items that match an arbitrary condition as maintenance targets. When the condition search button is selected by the operator, the data maintenance device displays a predetermined separate screen on the display unit 13 under the control of the screen creation processing unit 12. When the operator inputs an arbitrary condition such as “stock after date”, only records that meet the condition in the inventory data are displayed on the display unit 13. By providing such a search function, the data maintenance device can display a screen at a high speed with a small load even for data consisting of a large number of records.

  Furthermore, as described above, the data maintenance device can also handle tables having a parent-child relationship. For example, as shown in FIG. 11, there is inventory lot data which is a table composed of a plurality of records including items such as product codes and lot numbers as child data for inventory data as parent data. Consider a case where inventory lot data is maintained. Also here, the product code is not displayed on the maintenance screen as it is, but is replaced with a specific product name. In this case, the data maintenance apparatus may select environment maintenance including child table selection on the table selection screen shown in FIG. 5 and perform environment setting with input selection of definition of parent-child relationship.

  Thereby, the data maintenance device, under the control of the screen creation processing unit 12, for example, as shown in FIG. 12, is divided into two screens divided into inventory data as parent data and inventory lot data as child data. A maintenance screen having the configuration is displayed on the display unit 13. In this case, in the data maintenance device, the screen display is performed so that the content related to the inventory lot data as the child data is switched to the corresponding content in response to the selection of an arbitrary record in the inventory data as the parent data. Will be made. Even in this case, in the data maintenance device, both the inventory data and the inventory lot data are displayed in a form in which the product code is replaced with a specific product name.

  In the data maintenance apparatus, the operator can perform arbitrary maintenance such as registration, update, and / or deletion of new data via such a maintenance screen. In the data maintenance apparatus, the maintained contents are automatically reflected in the contents of the database. Further, in the data maintenance device, when maintenance is performed on a table having a parent-child relationship, the corresponding child data can be automatically deleted when maintenance is performed to delete the parent data.

  As described above, the data maintenance apparatus shown as the embodiment of the present invention can automatically create a maintenance screen based on the system catalog of the database 10 under the control of the screen creation processing unit 12. it can. That is, the data maintenance device automatically creates the maintenance screen based on the data actually stored in the database 10 under the control of the screen creation processing unit 12, regardless of the difference in the system. A maintenance screen can be created. At this time, the data maintenance apparatus can display the value of each item by replacing it with arbitrary information that is easy for the operator to understand instead of the code.

  Therefore, in a data maintenance device, a maintenance screen customized according to the operator's preference can be easily created only by performing environment setting with simple input selection work. The need for individual programming can be eliminated, and the load on system designers, system administrators, and operators operating the system can be significantly reduced, and development and maintenance costs can be reduced to improve quality. It is also possible.

  As described above, the data maintenance device can provide extremely excellent convenience to the system designer, the system administrator, and the operator.

  Note that the present invention is not limited to the above-described embodiment. For example, in the above-described embodiment, the description has been made with a focus on master maintenance. However, the present invention includes transaction data and the like. And can be easily applied to the maintenance of all data.

  In the above-described embodiment, the database 10 includes the system catalog, and the screen creation processing unit 12 creates the maintenance screen based on the system catalog. However, the present invention does not use the system catalog. Even if applicable. In this case, the data maintenance device previously creates information corresponding to the system catalog describing at least information on the format of each item constituting the table stored in the database as a user table, and the screen creation processing unit 12 A maintenance screen can be created by referring to this user table. Therefore, the present invention can also be applied to a database that does not have a system catalog.

  Furthermore, in the above-described embodiment, it has been described that the environment setting program and the maintenance program exist separately. However, the present invention only applies when packaged as a set of these two programs. In addition, the present invention can be applied to a case where functions for environment setting and maintenance are created as one program and distributed as one package software.

  Thus, it goes without saying that the present invention can be modified as appropriate without departing from the spirit of the present invention.

It is a block diagram explaining the structure of the data maintenance apparatus shown as embodiment of this invention. It is a flowchart explaining a series of processes at the time of performing environment setting which defines the content of maintenance in the data maintenance apparatus. It is a figure explaining an example of the logon screen displayed on a display part by environmental setting. It is a figure explaining an example of the environment setting menu screen displayed on a display part by environment setting. It is a figure explaining an example of the table selection screen displayed on a display part by environmental setting. It is a figure explaining an example of the item setting screen displayed on a display part by environmental setting. It is a figure explaining an example of the replacement item setting screen displayed on a display part by environmental setting. It is a figure explaining an example of the environment setting menu screen displayed on a display part by environment setting, Comprising: It is a figure for demonstrating a mode that the list of the maintenance data produced in the past is displayed. It is a figure for demonstrating a mode that inventory data is maintained, Comprising: It is a figure for demonstrating a mode that the merchandise code which is 1 item of inventory data is substituted to the merchandise name which is an item of a merchandise master. It is a figure explaining an example of the maintenance screen displayed on a display part, Comprising: It is a figure explaining an example of the maintenance screen regarding the data shown in FIG. It is a figure for demonstrating a mode that the inventory data and inventory lot data in a parent-child relationship are maintained, Comprising: The product code which is one item of inventory data and inventory lot data is replaced with the product name which is an item of a product master It is a figure for demonstrating a mode. It is a figure explaining an example of the maintenance screen displayed on a display part, Comprising: It is a figure explaining an example of the maintenance screen regarding the data shown in FIG.

Explanation of symbols

10 Database 11 Input operation unit 12 Screen creation processing unit 13 Display unit

Claims (15)

A data maintenance device for maintaining various data stored in a relational database,
An input operation means for an operator to perform an input operation on a database to be maintained;
Screen creation processing means for creating a maintenance screen for manipulating data at the time of maintenance based on information input via the input operation means;
Display means for displaying various information including the maintenance screen created by the screen creation processing means,
Based on the data stored in the database, the screen creation processing means creates the maintenance screen replaced with arbitrary information that is easy for the operator to understand instead of a code as the value of each item constituting the data. A data maintenance apparatus characterized by displaying on the display means. The said screen creation processing means creates the said maintenance screen based on the system catalog which described the information regarding the format of each item which comprises the table stored in the said database at least. Data maintenance device. The said screen creation processing means creates the said maintenance screen based on the user table which described the information regarding the format of each item which comprises the table stored in the said database at least. Data maintenance device. The data maintenance device according to claim 3, wherein the user table is created in advance. 4. The data maintenance apparatus according to claim 2, wherein the screen creation processing means lists all databases connectable to the operator and displays them in a selectable manner on the display means. The screen creation processing means reads a list of all tables stored in a database to be connected to perform maintenance selected via the input operation means, and displays the list in a selectable manner on the display means. The data maintenance device according to claim 5. The data maintenance apparatus according to claim 6, wherein the screen creation processing unit refers to a system catalog or a user table of the selected database and acquires information on the table based on the system catalog or the user table. The data according to claim 6 or 7, wherein the screen creation processing means reads a list of all items constituting the table selected via the input operation means and displays the list on the display means. Maintenance device. 9. The screen creation processing means refers to a system catalog or user table of a selected database, and acquires information on all items constituting the selected table based on the system catalog or user table. Data maintenance equipment. The screen creation processing means displays at least the name of maintenance data that defines the content of the maintenance that is currently set and is selected through the input operation means, and displays the items on the maintenance screen to be finally created Create the maintenance screen based on the order, the display item that should be displayed, the replacement item that is replaced with arbitrary information instead of the code, the item extraction condition, and the operator that represents the extraction condition The data maintenance device according to claim 8 or 9, wherein: In the setting of the replacement item, the screen creation processing unit causes the display unit to display a target table having an item to be replaced and a list of all tables as replacement destination candidates, and the target table is selected. The data maintenance apparatus according to claim 10, wherein a join condition with a replacement destination table is input via the input operation means. The screen creation processing means creates the maintenance screen based on the definition of the parent-child relationship that is input and selected via the input operation means. Data maintenance device described in the section. The screen creation processing means creates the maintenance screen that enables selection of whether to display all data or only those that meet an arbitrary condition as a maintenance target. The data maintenance apparatus according to any one of claims 12 to 12. A data maintenance method for maintaining various data stored in a relational database,
A screen creation processing step for creating a maintenance screen for manipulating data based on information input by an operator who performs an input operation on a database subject to maintenance;
A display step for displaying various information including the maintenance screen created in the screen creation processing step on the display means
In the screen creation processing step, based on the data stored in the database, the maintenance screen is created as the value of each item constituting the data, instead of the code and any information that is easy for the operator to understand. A data maintenance method characterized by that. A computer-executable data maintenance program for maintaining various data stored in a relational database,
Screen creation processing for creating a maintenance screen for manipulating data based on information input by an operator who performs an input operation on the database to be maintained;
Display processing for displaying various information including the maintenance screen created in the screen creation processing on the display means,
In the screen creation process, based on the data stored in the database, the maintenance screen is created as the value of each item constituting the data, instead of the code with arbitrary information that can be easily understood by the operator. A data maintenance program characterized by