WO2007077626A1 - Data maintenance device, data maintenance method, and data maintenance program - Google Patents

Abstract

According to information inputted by an operator performing input operation into a database as a maintenance object, a data maintenance device creates various screens for setting environments for operating data when performing an environment setting operation defining a content of the maintenance and various screens for maintenance for operating the data when performing maintenance operation. Here, the data maintenance device operates a maintenance menu configured by collecting maintenance data created by the environment setting for each maintenance operation used and registering them as a single menu, creates a screen for customizing the maintenance menu, and causes a display unit to display it. Moreover, according to the content set by the environment setting, the data maintenance device creates various screens for maintenance in which values of respective items constituting the data are replaced by not a code but arbitrary information which can easily be understood by an operator and causes the display unit to display it.

Description

 Specification

 Data maintenance device, data maintenance method, and data maintenance program

 Technical field

 [0001] The present invention relates to a data maintenance apparatus, a data maintenance method, and a data maintenance program for performing maintenance of various data stored in a relational database.

 Background art

 In recent years, various information processing systems using information processing devices have been developed with the spread and advancement of information processing devices such as computer devices. As one of such various information processing systems, 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 output data is obtained by performing predetermined processing. In particular, relational databases are widely used for managing data processed in information processing apparatuses.

 [0003] In a powerful 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 tables are used as user's interfaces in relational databases. Furthermore, in a relational database, each table can define not only the management object itself but also the relationship between multiple management objects by describing pointers to other management objects.

[0004] By the way, in this type of database system, it is necessary to perform various maintenance such as registration, update, and Z or deletion of new data for system development. For example, Patent Document 1 to Patent Document 5 have been proposed as techniques related to such maintenance work. Patent Document 1: Japanese Patent Laid-Open No. 10-214211

 Patent Document 2: JP-A-10-214212

 Patent Document 3: Japanese Patent Laid-Open No. 11-232158

 Patent Document 4: Japanese Patent Laid-Open No. 2000-66932

 Patent Document 5: Special Table 2003-520363

 [0006] Specifically, Patent Document 1 discloses a database system equipped with a database that stores various data tables. In particular, this database system has a maintenance script file that stores multiple maintenance scripts created for each data table in the database, and script management that stores final run-time data for each maintenance script stored in this maintenance script file. Time limit setting means for setting the time limit for reorganizing the file and the data table on the database, and the execution order for determining the execution order of the maintenance scripts in order from the last run time data stored in the script management file A reorganization processing means for performing reorganization of the data table by executing the restriction set by the time limit setting means according to the order determined by the execution order determination means, and the reorganization processing means. Finished Last execution time update means for updating data at the last execution time in the script management file of the maintenance script. As a result, in this database system, the reorganization execution target data tables can be automatically and sequentially reorganized, and all the reorganization execution target data tables can be reconfigured within the time limit. In the event that the organization is unsuccessful, the subsequent force can be automatically reorganized the next time, and as a result, the effort required for the reorganization can be reduced and the processing efficiency can be improved. .

[0007] In addition, Patent Document 2 discloses a database system that stores equipment data of a computer system that is operated online, uses this data for system operation, and performs data maintenance in response to new installation Z change Z removal. Has been. 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 a maintenance type, and a variable. It includes a database having a table composed of a change pointer for managing the position of another record for storing update contents and a data access unit element, and a database access routine. 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 “used”, sets the maintenance type to “new”, and stores the new contents in the data record. Also, the database access routine sets the maintenance type to “removal” at the time of data maintenance for facility removal. In addition, the database access routine searches for an empty record with the record use flag during equipment maintenance data maintenance, 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 the access of the operation process power to the data record at the new equipment location, and from the operation process for the data record at the equipment removal location and the equipment change location. Access as requested. As a result, in this database system, since data maintenance is performed using free areas in anticipation of future increments, an extra data area for data maintenance becomes unnecessary, and the use efficiency can be improved. .

 [0008] Further, Patent Document 3 includes 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. Is disclosed. In particular, this database maintenance management system has master data receiving means for receiving master data for update sent from other systems, and the master data is received when the master data receiving means receives the master data. It has a master management means that is automatically reflected in the master database, and automatically performs master maintenance function processing. As a result, in this database maintenance management system, the contents of the update master data can be automatically reflected in the master database without human intervention.

[0009] Furthermore, Patent Document 4 discloses a maintenance method for master information. In particular, this master information maintenance method includes a step of converting predetermined master information into text data, additional information to be added to the master information, and a key for specifying the additional information. And a step of inputting information into a spreadsheet, and a step of combining text data and additional information input into the spreadsheet to generate a new database. As a result, this master information maintenance method is able to efficiently and reliably reflect individual items that do not exist in the positive master information in a batch.

 [0010] 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 includes a subset of data of at least partially different central databases, and change information for data stored in the database of the database network system is transmitted to a plurality of node systems. Force to transmit this change information from the node system to the central system as a replication object containing ID keys structured in different types, if an online connection is made, or If the transmission is from the central system to the node system and there is no online connection, the replication object is adjusted in the output queue for later transmission and replicated in the replication object central system with the change information. Assigned to node system transmission destination via at least one look-up table as a destination by the application 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 a maintenance operation, it is necessary to display a predetermined maintenance screen in order to operate the data. However, such a maintenance screen needs to be created by original programming according to the system because the data differs depending on the individual system. Specifically, there are things that can be effective for more than a month just by creating one maintenance screen, and it will take more time to perform the test etc., which requires very much cost and labor. It was something to do.

[0012] In addition, in a database system, the values of items constituting each table are usually represented by a series of numbers, symbols, and other codes that are conveniently added. 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 is created. You can also. However, since this type of general-purpose software simply displays data as it is, it can display the code as it is on the maintenance screen according to the value represented by the code. become . Therefore, this kind of general-purpose software has to be associated with the code and the actual name separately, and in reality it was not strong enough to withstand use.

[0013] 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, system administrator, and operator operating the system is remarkably increased. Was. In the database system, due to these problems, there is a concern that the development cost and maintenance cost will increase and the quality will be decreasing. Disclosure of the invention

 [0014] The present invention has been made in view of such circumstances, and a data maintenance device and a data maintenance device capable of automatically creating individual maintenance screens without programming each system individually. The purpose is to provide a method and data maintenance program.

[0015] 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. Based on the input operation means input by the operator and the information input via the input operation means, the environment setting for operating the data when performing the environment setting operation that defines the contents of the maintenance Screen creation processing means for creating various maintenance screens and various maintenance screens for operating data during maintenance operations, environment setting screens created by the screen creation processing means, and Display means for displaying various types of information including various maintenance screens. Maintenance data that defines the content of maintenance created through various screens for environment settings are collected and registered as a single menu for each maintenance operation used. A menu customization screen is created as one of the various environment setting screens for operating the maintenance menu to customize the maintenance menu, and displayed on the display means, and stored in the database. Based on the data! /, The value for each item constituting the data is not the code, but the above-mentioned environment setting for performing the setting for replacing with any information that is easy for the operator to understand. Based on the means for creating a replacement setting screen as one of the various screens and displaying it on the display means, and the contents set via the replacement setting screen, the values of the items constituting the data are as described above. There are means for creating various maintenance screens that are replaced with arbitrary information that is easy for the operator to understand instead of codes and displaying them on the display means. It is characterized in that.

The 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 the relational database, and is a method for maintaining the database to be maintained. Performing input operations Based on the information entered by the operator, create various environment setting screens for operating data when performing environment setting operations that define the contents of maintenance. Based on the environment setting process in which the screen is displayed on the display means and the environment setting content is input via the input operation means and the information input by the operator, the data is operated when performing the maintenance operation. Create various maintenance screens, and create the above maintenance screens. A maintenance process for displaying the contents of maintenance via the input operation means, and the environment setting process is a maintenance that defines the contents of maintenance created through the various environment setting screens. A menu as one of the various screens for setting the above environment to customize the maintenance menu by collecting the data for each maintenance operation to be used and registering it as a single menu Based on the menu customization screen display process of creating a customization screen and displaying it on the display means, and the data stored in the database, the operator, not the code, sets the value of each item constituting the data. Above for setting to replace with arbitrary information that is easy to understand As one of the various screens for the border set A replacement setting screen display step for creating a replacement setting screen and displaying it on the display means. In the maintenance step, each item constituting the data based on the contents set via the replacement setting screen. As a value of the above, various screens for maintenance described above are created in place of the above code instead of arbitrary information that can be easily understood by the operator.

 Furthermore, the data maintenance program according to the present invention that achieves the above-mentioned object is a computer-executable data maintenance program that performs maintenance of various data stored in a relational database. Based on the information entered by the operator

Create various environment setting screens for manipulating data when performing environment setting operations that define the contents of maintenance, and display the created various screens for environment settings on the display means. Based on the environment setting process to be input through the input operation means and the information input by the operator, various maintenance screens for operating data when performing a maintenance operation are created, and the created maintenance is performed. A maintenance process for displaying various screens for nonce on the display means and inputting maintenance contents via the input operation means. The environment setting process is a maintenance process created via the environment setting screens. Maintenance data that defines the content

Menu customization as one of the various screens for setting the above-mentioned environment for customizing the maintenance menu by collecting and registering it as a single menu for each maintenance operation to be used Based on the menu customization screen display process that creates the screen and displays it on the display means, and the data stored in the database, the values of the items that make up the data are not the code but the operator can easily understand A replacement setting screen display process for creating a replacement setting screen as one of the various environment setting screens for performing settings for replacing with arbitrary information and displaying the replacement setting screen on the display means. In the maintenance process, each item constituting the data is based on the contents set via the replacement setting screen. As values, as characterized by various screens for the maintenance of the operator rather than by the foregoing code is replaced to facilitate any information understanding is created, Ru. [0018] The data maintenance device, the data maintenance method, and the data maintenance program according to the present invention are for environment setting for manipulating data when performing an environment setting operation for defining the contents of maintenance, respectively. Various screens for maintenance and various maintenance screens for manipulating data when performing maintenance operations can be created automatically by screen creation processing means based on data regardless of the system. . At this time, the data maintenance device, the data maintenance method, and the data maintenance program that are relevant to the present invention are based on the contents set via the replacement setting screen, and the operator instead of the code as the value of each item. Can be replaced with arbitrary information that is easy to understand. In addition, the data maintenance device, the data maintenance method, and the data maintenance program according to the present invention each collect maintenance data for each maintenance operation to be used as one menu through various screens for environment setting. The maintenance menu can be customized by operating the registered maintenance menu.

 [0019] The present invention as described above can easily create various environment setting screens and maintenance various screens customized according to the preference of the operator. The need for individual programming can be eliminated. In addition, since the maintenance menu can be customized in the present invention, the environment setting for defining the contents of maintenance can be easily performed, and the use and convenience of the operator can be greatly improved. Therefore, the present invention significantly reduces the load on the system designer, system administrator, and operator who operates the system, and also reduces the development cost and maintenance cost, and can improve the quality. Can do.

 Brief Description of Drawings

 FIG. 1 is a block diagram for explaining the configuration of a data maintenance device shown as an embodiment of the present invention.

 FIG. 2 is a diagram for explaining a specific example of a connection screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and is displayed when the connection destination database is an SQL server. It is a figure explaining the specific example of a screen for work.

FIG. 3 is displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention. It is a figure explaining the specific example of the screen for a connection, and is a figure explaining the specific example of the screen for a connection displayed when the database of a connection destination is Oracle (trademark).

[4] FIG. 4 is a diagram illustrating a specific example of an environment setting menu screen displayed on the display unit of the data maintenance device shown as the embodiment of the present invention.

 FIG. 5 is a diagram illustrating a specific example of a table selection screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention.

 FIG. 6 is a diagram for explaining a specific example of the environment setting menu screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention, and illustrates how settings already registered are corrected It is a figure for doing.

7] FIG. 7 is a diagram illustrating a specific example of an item setting screen displayed on the display unit of the data maintenance device shown as the embodiment of the present invention.

 FIG. 8 is a diagram for explaining a specific example of an environment setting menu screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, for explaining a situation in which arbitrary maintenance data is deleted. FIG.

9] A diagram illustrating a specific example of the environment setting menu screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and a message dialog for confirmation when deleting any maintenance data It is a figure for demonstrating a mode that it displayed

FIG. 10 is a diagram for explaining a specific example of the main part of the item setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and the child table can be switched to the item setting screen. It is a figure for demonstrating a mode that it added.

 FIG. 11 is a diagram for explaining a specific example of the main part of the item setting screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention, and shows the order of a plurality of child tables in the item setting screen. It is a figure for demonstrating a mode that it rearranges by.

 FIG. 12 is a diagram for explaining a specific example of a combination condition setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention.

FIG. 13 is a diagram for explaining a specific example of an item setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and the manner in which the order of items to be displayed is changed It is a figure for demonstrating.

 FIG. 14 is a diagram for explaining a specific example of the item setting screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and moves the selected column to the column on the left side of the column. It is a figure for demonstrating a mode that it replaced.

 FIG. 15 is a diagram illustrating a specific example of a replacement setting screen displayed on the display unit of the data maintenance device shown as the embodiment of the present invention.

 FIG. 16 is a diagram illustrating a specific example of a replacement item table selection screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention.

 FIG. 17 is a diagram for explaining a specific example of the main part of the replacement setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and selecting an item name to be replaced from a drop-down list It is a figure for demonstrating a mode to do.

 FIG. 18 is a diagram for explaining a specific example of the main part of the screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and explains the first selection method when replacement setting is performed It is a figure for doing.

 FIG. 19 is a diagram for explaining a specific example of a screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, for explaining a second selection method when replacement setting is performed. FIG.

 FIG. 20 is a diagram for explaining a specific example of a screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention, for explaining a third selection method when replacement setting is performed. FIG.

 FIG. 21 is a diagram for explaining a specific example of an environment setting menu screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and a diagram for explaining how to customize the maintenance menu It is.

 FIG. 22 is a diagram for explaining a specific example of a menu customization screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention.

FIG. 23 is a diagram for explaining a specific example of the main part on the menu customization screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and is a new one with the top menu selected. A diagram for explaining how menu items have been added is there.

 FIG. 24 is a diagram for explaining a specific example of a main part on a menu customization screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and selecting a maintenance menu that has already been created. It is a figure for demonstrating a mode that the new menu item was added as a submenu of the said maintenance menu in a state.

FIG. 25 is a diagram for explaining a specific example of a menu customization screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and is used for confirmation when deleting an arbitrary maintenance menu. It is a figure for demonstrating a mode that the message dialog was displayed.

 FIG. 26 is a diagram for explaining a specific example of the main part of the menu customization screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, in which a maintenance menu that has already been created is deleted. It is a figure for demonstrating.

 FIG. 27 is a diagram for explaining a specific example of the main part of the menu customization screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and shows the display order of maintenance menus already created. It is a figure for demonstrating a mode that it rearranges.

 FIG. 28 is a diagram for explaining a specific example of the main part of the menu customization screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and shows the display order of maintenance menus already created. It is a figure for demonstrating a mode that it rearranged.

 FIG. 29 is a diagram for explaining a specific example of a menu customization screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention, and a diagram for explaining a state in which registerable maintenance data is displayed. It is.

 FIG. 30 is a diagram for explaining a specific example of a menu customization screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, for explaining a state of dragging registered ヽ maintenance data. FIG.

FIG. 31 is a diagram for explaining a specific example of a menu customization screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention. It is a figure for demonstrating a mode that data was dropped on the desired maintenance menu.

 FIG. 32 is a diagram for explaining a specific example of a menu customization screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention. V, Maintenance not registered in the maintenance menu for misalignment It is a figure for demonstrating a mode that data was displayed.

 FIG. 33 is a diagram for explaining a specific example of the main part of the menu customization screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and registers one maintenance data in one maintenance menu. It is a figure for demonstrating how it performed.

 FIG. 34 is a diagram for explaining a specific example of the main part of the menu customization screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention. The maintenance data shown in FIG. 33 is used as another maintenance menu. It is a figure for demonstrating a registered state.

 FIG. 35 is a diagram for explaining a specific example of the main part of the menu customization screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and is the maintenance data registered in a certain maintenance menu. It is a figure for demonstrating a mode that is moved to another maintenance menu.

 FIG. 36 is a diagram for explaining a specific example of the main part of the menu customization screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and shows maintenance data registered in a certain maintenance menu. It is a figure for demonstrating a mode that it copies to another maintenance menu.

 FIG. 37 is a diagram for explaining a specific example of a menu customization screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, in which an ID is given before the name of the maintenance menu. It is a figure for demonstrating.

 FIG. 38 is a diagram illustrating a specific example of a maintenance screen displayed on the display unit of the data maintenance device shown as the embodiment of the present invention.

FIG. 39 is a diagram for explaining a specific example of an initial display screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, and a table to be maintained is It is a figure explaining the specific example of the initial display screen in the case of being one.

 FIG. 40 is a diagram for explaining a specific example of an initial display screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and an initial display screen when there are a plurality of tables to be maintained. It is a figure explaining the specific example of.

 FIG. 41 is a diagram for explaining a specific example of a display data screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and display data when there is one table to be maintained. It is a figure explaining the example of a screen.

 FIG. 42 is a diagram for explaining a specific example of a display data screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention, and a display data screen when there are a plurality of tables to be maintained. It is a figure explaining the specific example of.

 FIG. 43 is a diagram illustrating a specific example of a condition setting screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention.

 FIG. 44 is a diagram for explaining a specific example of a condition setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and displays a drop-down list displaying items that can be set as conditions It is a figure for demonstrating the state made to do.

FIG. 45 is a diagram for explaining a specific example of a condition setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and a diagram for explaining how to set extraction condition contents; is there.

 FIG. 46 is a diagram illustrating a specific example of a selection screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention.

 FIG. 47 is a diagram for explaining a specific example of a condition setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, in which data is input to a cell for setting extraction condition contents It is a figure for demonstrating.

 FIG. 48 is a diagram illustrating a specific example of a condition setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and displays a drop-down list displaying selectable extraction conditions. It is a figure for explaining a situation.

FIG. 49 is a diagram illustrating a specific example of a condition setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and shows data that matches all the set conditions. FIG. 5 is a diagram for explaining how to set the power of extracting data and whether to extract data that matches any one of the conditions.

 FIG. 50 is a diagram illustrating a specific example of a search condition name input screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention.

 FIG. 51 is a diagram for explaining a specific example of a condition setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, in which a drop-down list displaying stored conditions is displayed It is a figure for demonstrating a mode.

 FIG. 52 is a diagram for explaining a specific example of a condition setting screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and a diagram for explaining how to change the name of a saved condition It is.

 FIG. 53 is a diagram for explaining a specific example of a search condition edit screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention.

 FIG. 54 is a diagram for explaining a specific example of a search condition edit screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and a diagram for explaining a state in which a saved condition is deleted. is there.

 FIG. 55 is a diagram for explaining a specific example of a display data screen displayed on the display unit of the data maintenance apparatus shown as an embodiment of the present invention, and a diagram for explaining a state in which the display width of a column is changed. is there.

 FIG. 56 is a diagram for explaining a specific example of the initial display screen displayed on the display unit of the data maintenance apparatus shown as the embodiment of the present invention, in the initial display screen having a two-screen configuration divided for each table. It is a figure for demonstrating a mode that the display ratio of a table is changed.

 FIG. 57 is a diagram illustrating a specific example of a history display screen displayed on the display unit of the data maintenance device shown as an embodiment of the present invention.

 BEST MODE FOR CARRYING OUT THE INVENTION

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

[0022] This embodiment is a method for storing various data stored in a relational database. This is a data maintenance device that performs maintenance. This data maintenance device is used for various environment setting screens for operating data when performing environment setting operations that define the contents of maintenance, and for maintenance for operating data when performing maintenance operations. Regardless of the system, the various screens are automatically created based on the data, and the values for each item are replaced with arbitrary information that is easy for the operator to understand instead of the codes. It can be displayed on the screen. In addition, this data maintenance device collects maintenance data that defines the content of maintenance created through various screens for environment setting for each maintenance operation to be used and registers it as one menu. The maintenance menu can be customized by operating.

 [0023] 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. In the following, for convenience of explanation, a database including a so-called system catalog will be described.

 [0024] Configuration of Data Maintenance Device

 For example, as shown in FIG. 1, the data maintenance device is input via the input operation unit 11 and an input operation unit 11 which is an input operation means for an operator to perform an input operation on a database 10 to be maintained. Screen creation processing unit 12 that is a screen creation processing unit that creates various screens based on the information that has been displayed, and display that is a display unit that displays various types of information including the various screens created by this screen creation processing unit 12 Part 13 is provided.

 [0025] The input operation unit 11 is a user who has various operation device capabilities such as a keyboard and a mouse.

 'Configured as an interface. In the data maintenance device, the maintenance operator performs various information input operations through the input operation unit 11. Information input via the input operation unit 11 is supplied to the screen creation processing unit 12.

[0026] The screen creation processing unit 12 accesses the database 10 in accordance with an instruction given via the input operation unit 11, and defines the content of maintenance based on the system catalog of the database 10. Various environment setting screens for manipulating data when performing environment setting operations, and maintenance for manipulating data when performing maintenance operations Create various screens for use. The system catalog is management information related to the tables described by the relational database management system, and describes at least information related to the format of each item constituting the table. Typically, the system catalog is unique to the database, except for some, because it is replicated from the template database when the database is created. The screen creation processing unit 12 acquires such a system capability log in response to an instruction given via the input operation unit 11, and reads each item constituting the table based on this system catalog. Create various screens for setting up and setting the environment, and various screens for maintenance. The screen creation processing unit 12 displays the created various screens on the display unit 13.

 [0027] The display unit 13 is configured as a user 'interface including, for example, an LCD (Liquid Crystal Display) t and various display devices. The display unit 13 displays various screens created by the screen creation processing unit 12 and various other information.

 Such a data maintenance device realizes the function of the screen creation processing unit 12 in terms of hardware by a CPU (Centra 1 Processing Unit) controlled according to a program developed on a predetermined memory. be able to.

 [0029] Weaving settings

 Now, such a data maintenance device performs an environment setting that defines the content of the maintenance prior to performing the maintenance.

[0030] First, in order to perform environment setting, the data maintenance device starts an environment setting screen in response to an operator starting an environment setting program and logging in to the system. At this time, under the control of the screen creation processing unit 12, the data maintenance device causes the display unit 13 to display a connection screen for connecting to the database 10 simultaneously with the activation of the environment setting screen. Specifically, when the data base 10 to be connected is a SQL (Structured Query Language) server, the data maintenance device causes the display unit 13 to display a connection screen as shown in FIG. When the connection destination database 10 is a so-called Oracle (registered trademark), a display screen as shown in FIG.

[0031] These connection screens connect to at least one database included in the system. It is configured to be able to input or select information necessary to do this. Specifically, when the connection destination database 10 is an SQL server, information such as “connection destination server name”, “database name”, “login name”, and “password” is entered on the connection screen. An input box 21 is provided for this purpose. On the other hand, when the connection destination database 10 is Oracle (registered trademark), an input box 31 for inputting information such as “user name”, “password”, and “host character string” is displayed on the connection screen. Provided. The data maintenance device checks the validity of the operator when the operator inputs necessary information in the input boxes 21 and 31 via the input operation unit 11 and clicks the connection buttons 22 and 32. After authenticating, connect to database 10 and log in to the system.

 [0032] In addition, the connection screen is provided with connection destination list display areas 23 and 33 in which a list of at least one database included in the system is posted. The connection destination lists displayed in the connection destination list display areas 23 and 33 also provide information regarding the connection destination database 10 that the operator has input through the input boxes 21 and 31 in the past. That is, in the connection destination list display areas 23 and 33, when the connection destination database 10 is an SQL server, information such as “connection destination server name”, “database name”, and “login name” is stored. Displayed as a single connection destination list. When the connection destination database 10 is Oracle (registered trademark), it is displayed as a single connection destination list such as "user name" and "host string". . In the data maintenance device, the operator selects the connection destination list to be connected from the connection destination lists displayed in the connection destination list display areas 23 and 33, and selects the connection destination list via the input operation unit 11. At the same time, by entering a password in the input boxes 21 and 31 and clicking the connection buttons 22 and 32, it is possible to connect to the database 10 after authenticating the validity of the operator. The connection screen is provided with delete buttons 24 and 34 for deleting an arbitrary connection destination list displayed in the connection destination list display areas 23 and 33. The operator clicks this delete button 24, 34 while highlighting and selecting an arbitrary connection destination list displayed in the connection destination list display area 23, 33 via the input operation unit 11. The connection destination list can be deleted.

Subsequently, when the data maintenance apparatus connects to the desired database 10 through such a connection screen, for example, as shown in FIG. 4 under the control of the screen creation processing unit 12. A simple configuration menu screen is displayed on the display unit 13.

 This environment setting menu screen is provided with a maintenance data list display area 41 in which a list of maintenance data defining the contents of maintenance is displayed. In the initial state in which the maintenance data has not yet been defined, the environment setting menu screen is listed in the maintenance data list display area 41 and is in a state. When defining new maintenance data, the operator must perform a new environment setting operation by clicking the new registration button 42 provided on the environment setting menu screen via the input operation unit 11. Can do.

 When the data maintenance apparatus shifts to the environment setting operation, it reads a list of all tables stored in the selected database under the control of the screen creation processing unit 12. Specifically, the screen creation processing unit 12 refers to the system capability log of the selected database, and acquires information about the table based on this. Then, under the control of the screen creation processing unit 12, the data maintenance device causes the display unit 13 to display a table selection screen as shown in FIG.

[0036] The table selection screen is provided with a table list display area 51 for displaying a list of all tables stored in the database selected as the maintenance target. The operator selects the environment setting from the tables displayed in the table list display area 51 via the input operation unit 11 by highlighting the line size: and ヽ tables. Then, the data maintenance device performs environment setting for the selected table. In addition, when the operator corrects the already registered setting, for example, as shown in FIG. 6, it is displayed in the maintenance data list display area 41 on the environment setting menu screen via the input operation unit 11. From the maintenance data, highlight the maintenance data that has been modified, double-click the selected maintenance data, or click the setting correction button 43. The data maintenance device selects based on the system catalog under the control of the screen creation processing unit 12 in response to an operation for setting the environment or correcting the selected table. A list of all items constituting the table is acquired and read, and this is displayed on the display unit 13 as an item setting screen as shown in FIG. 7, for example. In addition, as shown in FIGS. 6 and 8, the environment setting menu screen is provided with a delete button 44 for deleting any maintenance data displayed in the maintenance data list display area 41. The operator clicks this delete button 44 while selecting and selecting any maintenance data displayed in the maintenance data list display area 41 via the input operation unit 11. In response to this, the data maintenance device displays a confirmation message dialog on the display unit 13 as shown in FIG. 9, for example, and the operator performs the intention to delete the selected maintenance data. Can be deleted.

 [0038] Note that the data maintenance device collects maintenance data created via the environment setting menu screen for each maintenance operation to be used and registers it as a maintenance menu in order to greatly improve the convenience of the operator. The data maintenance device is configured so that the maintenance menu can be customized arbitrarily. This maintenance menu customization will be described later.

 [0039] Now, under the control of the screen creation processing unit 12, the data maintenance device displays the item setting screen as shown in Fig. 7 on the display unit 13 and is selected via the table selection screen. Set the environment of the selected table. 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. The data maintenance device sets each item for the table to be maintained via the item setting screen. Specifically, the item setting screen displays a two-dimensional table 50 having each item as a column and the setting content as a row. Each cell constituting this table 50 is composed of an input box and a drop-down list for inputting setting contents of each item.

[0040] The setting contents that can be performed through such an item setting screen include the name of maintenance data, the maximum number of extraction results to be displayed on various maintenance screens described later, and the number of maintenance items. Name of the table displayed on the tab control of each screen, whether to perform history management, whether to perform logical deletion, item display order, display Z hide, Z read only, Name of items to be displayed on various maintenance screens, items to be displayed by replacing codes with arbitrary information (replacement items), Selection method when set, data type, display order when displaying on various maintenance screens, whether this display order is done in ascending or descending order, default value, system date, user ID, etc. Extraction conditions such as presence / absence of automatic update, values as the contents of extraction conditions when only specific data is to be displayed on various maintenance screens, operators expressing the magnitude relationship with the values as the contents of these extraction conditions , History management items, key items for avoiding duplication of data when performing history management, and deletion character strings for logical deletion. The item setting screen is provided with controls and input boxes for setting these various types of information.

 Specifically, the item setting screen is provided with a child table addition button 51 for adding a child table having the table as a parent table. When adding the child table, the operator clicks the add child table button 51 via the input operation unit 11 to identify the table by the tab 52 displaying the table name as shown in FIG. 10, for example. The child table can be added to the item setting screen so that the display can be switched. The operator can also delete any child table added by clicking the delete child table button 53.

 In addition, the data maintenance device is configured to be able to rearrange the order of the plurality of added child tables on the item setting screen. Specifically, as shown in FIG. 10, the data maintenance device, for example, as shown in FIG. 11 in response to the operator dragging the tab 52 of the child table to be rearranged via the input operation unit 11. As shown, the order of the child table 52 is rearranged and displayed. Then, the data maintenance device ends the rearrangement when the operator drops the child table at a desired position via the input operation unit 11. However, the data maintenance device is configured so that the parent table cannot be rearranged.

[0043] Furthermore, the data maintenance device controls the screen creation processing unit 12 when a child table is added by an operator's operation or when the join condition change button is selected on the item setting screen. At the same time, for example, the display unit 13 displays a combination condition setting screen as shown in FIG. The operator can set the join condition between the parent table and the child table via this join condition setting screen. Specifically, the operator The items to be joined are set by selecting the column name of the parent table to be joined via drop-down list 61 via force operation unit 11. At this time, the connection type is only internal connection. In addition, when the operator uses specific data as a join condition, the operator inputs the value into the extraction condition content input box 62 via the input operation unit 11 and also expresses the magnitude relationship with the value. Select the extraction conditions such as and the operation contents from the drop-down list 63. In response to this, the data maintenance device reflects and displays the contents set according to the operation through such a combination condition setting screen as the value of the corresponding cell on the item setting screen.

Furthermore, the item setting screen is provided with a name input box 54 for inputting the name of the maintenance data currently set. The name input in the name input box 54 is displayed in the maintenance data list display area 41 on the configuration menu screen. In addition, the item setting screen has a maximum number of extraction boxes 55 for entering the maximum number of extraction results to be displayed on various maintenance screens at once, and a table displayed in the tab controls on the various maintenance screens. A table display name input box 56 for inputting a name, a check box 57 that is checked when history management is performed, and a check box 58 that is checked when logical deletion is performed are provided. If the data maintenance device is a table whose history is managed by date, the history management function can be easily added to various maintenance screens. By setting the history management function, the data maintenance device can be used for maintenance. It is possible to use the history list display and update functions on various screens. In other words, when performing the history management, the operator checks the check box 57 via the input operation unit 11 and then sets the setting in the history management item cell among the cells constituting the table 50. Enter the content. Here, the data maintenance device supports history management based on the start date and end date, and history management based only on the start date. The operator selects only the start date and end date or the start date to be worked out from the drop-down list constituting the cell of the history management item among the cells constituting the table 50 via the input operation unit 11. You can set these dates. In addition, when performing history management, the operator sets items set as history management items via the input operation unit 11 in order to avoid duplication of data. Enter that in the cell of the key item other than the eyes. Further, when performing logical deletion, the operator checks the check box 58 via the input operation unit 11, and deletes the cell constituting the table 50 to the cell of the item to be logically deleted. Enter the value as a string.

 [0045] In addition, the item setting screen is provided with arrow buttons 71 and 72 for changing the order of items to be displayed. If the operator wants to change the order of the items to be displayed, for example, as shown in FIG. 13, the operator selects and highlights the column of the item whose order is to be changed via the input operation unit 11, and the arrow button 71 , 72. When one of the arrow buttons 71 is clicked, the data maintenance device selects the selected column on the left side of the column as shown in FIG. 14, for example, under the control of the screen creation processing unit 12. Move to and swap. On the other hand, when the other arrow button 72 is clicked, the data maintenance device moves and replaces the selected column to the column on the right side of the column under the control of the screen creation processing unit 12. be able to. Furthermore, the operator can set, via the input operation unit 11, whether each item is displayed as rewritable, hidden, or displayed as read-only. Note that the data maintenance device displays items that are set as read-only so that they can be distinguished from other items, such as displaying them in gray on various maintenance screens.

Furthermore, the data maintenance apparatus can set the data type (format) of each item via the item setting screen. At this time, the data maintenance device can set the format used for display only when the data type is a date type or a numeric type. Specifically, the data maintenance device can be used with a so-called Microsoft .Net Framework such as マ イ ク ロ ソ フ ト 0 (zero place holder) or 〃 # (digit placeholder) when the data type is numeric. A form can be used. For example, if the format is set as 〃 #, # # # pieces, the data maintenance device will display the number string 〃15000 "as” 15 000 pieces ”or the format 書 式 #. 0 #. When set as ", the number" IJ "" 12 "is displayed as" 12.0 ", or" 1234.568 "and! /, And the number" IJ "is displayed as" 1234.57 " In addition, when the data type is a date type, the data maintenance device sets the format arbitrarily selected by the operator from the drop-down list constituting the cell. can do. For example, if a date and time of 12:00:00 on January 1, 2005 is entered and the format "YYYYZMMZDD" is selected, the data maintenance device will display "2005Z01Z01" and "YYYY When the format / MM / DD HH: MM: SS is selected, the time is displayed as "2005/01/01 12:00: 01". The data maintenance device displays "05Z01Z01" if the format "YYZMMZDD" is selected, and "YY / MM / DD HH: MM: SS" if the format is selected. 05/01/01 12: 00: 01 "and if the format 〃YYYY year MM month DD date〃 is selected, it will be displayed as 〃2005 01/01" and "YYYY year MM month DD date HH: MM: SS 〃 and! /, When the format is selected, “2005 Jan 01" 12: 00: 01 ”is displayed.

 [0047] Furthermore, when the data maintenance device uses the input data as a default value, the data maintenance device can set the fact in the cells constituting the table 50. At this time, the data maintenance device can select the following items according to the data type of the setting target item. For example, when the data type is a date type, the data maintenance device can select and set a system date with no time or with a time from a drop-down list constituting the cell. In addition, when the data type is a character type, the data maintenance device uses the user name or user ID entered through the login screen when starting the data maintenance device from the drop-down list constituting the cell, or the existing data type. The system value of the passed value can be set as the default value. The data maintenance device returns an error if the input data cannot be set to the data type of the setting target item.

[0048] In addition, when the data type of the item to be set is a date type or a character type, the data maintenance device can set automatic update based on the system date, user ID, etc. via the item setting screen. it can. For example, when the data type is a date type, the data maintenance device can select and set to always update with a system date with no time or with a time from a drop-down list constituting the cell. If the data type is a character type, the data maintenance device uses the user name entered via the login screen when starting the data maintenance device from the drop-down list constituting the cell. You can select and always update with your user ID. The data maintenance device returns an error if the input data cannot be set to the data type of the setting target item.

 [0049] Setting in environment setting

 By the way, the data maintenance device can be displayed by replacing it with arbitrary information such as a specific area name or product name that is not a code, as the name of the item to be displayed on various maintenance screens. This can be done via the item setting screen.

 [0050] First, the data maintenance device replaces the code force with arbitrary information by the operator, and controls the screen creation processing unit 12 in response to selection of a cell of a desired item. In addition, for example, a replacement setting screen as shown in FIG. This replacement setting screen includes a replacement source table name display area 81 for displaying the name of the replacement source table and a code item name display area 82 for displaying the item name of the replaced code. The data maintenance device is stored in the system catalog under the control of the screen creation processing unit 12 when the operator clicks the selection button 83 provided on the replacement setting screen via the input operation unit 11. Based on this, a list of all tables managing item names is read, and a replacement item table selection screen as shown in FIG. 16 is displayed on the display unit 13 for example. This replacement item table selection screen describes a list of all tables as candidates for replacement destinations. The data maintenance device can change the replacement destination in FIG. 15 according to whether the operator selects the desired table by selecting the desired table from the list of all the replacement destination candidates via the input operation unit 11. In the table name display box 84, the name of the selected table is displayed. In addition, when the replacement destination table is selected, the data maintenance device, for example, as shown in FIG. 17, under the control of the screen creation processing unit 12, based on the system catalog, the replacement destination table. All items are read out and their item names are displayed in the drop-down list 85. Thus, the operator can select the item name to be replaced from the drop-down list 85 via the input operation unit 11.

[0051] In addition, the data maintenance apparatus sets a condition for acquiring the replacement destination item name to the operator via a replacement setting screen such as an internal connection or an external connection. Enter the number. Specifically, the operator sets the items to be merged by selecting the item name of the replacement source table used when merging via the input operation unit 11 in the drop-down list, Set the type of join as either inner join or outer join in the drop-down list. In addition, the operator sets the content of the extraction condition when combining via the input operation unit 11, and also displays the extraction conditions such as the operator and the operation content indicating the magnitude relationship with the value in the drop-down list. Select from. At this time, if the data type of the item to be set is a date type, the data maintenance device can select and set the system date as the central force of the drop-down list, and also in the replacement source table. If there is a date type item, that item can also be selected as a condition. In addition, when the data maintenance device sets multiple item names in the replacement source table used for merging, the operator uses the drop-down list in descending order of priority via the input operation unit 11. By assigning, priority can be set for these multiple item names. Note that the conditions shown in the following display 1 can be set as extraction conditions for combining. In addition, when deleting a setting displayed on the replacement setting screen, the data maintenance device deletes the setting in response to the operator clicking the delete setting button 86 via the input operation unit 11. Can do.

[table 1]

Table 1 Extraction conditions

[0053] Furthermore, the data maintenance device needs to set the selection method when the code replacement is set. First, as a first selection method, the data maintenance device is provided with a function for selecting the target data in the middle of the drop-down list as shown in FIG. 18, for example. This method is effective when the replacement destination data is small. As a second selection method, the data maintenance device selects the target data from the list displayed as a result of the incremental search by inputting the search string as shown in FIG. 19, for example. The function to do is provided. Furthermore, the data maintenance device has a function of selecting a target data as a third selection method by performing a search using a code or information of a replacement destination as a key via a screen as shown in FIG. 20, for example. Set it up!

[0054] When the data maintenance device performs the replacement setting in this way, the contents are set in the item setting. It can be reflected and displayed as the value of the corresponding cell on the fixed screen. As a result, the data maintenance device can display the information by replacing it with arbitrary information instead of the code as the name of the item to be displayed on the various maintenance screens.

 [0055] The data maintenance device performs the environment setting operation as described above, and in response to the operator clicking the OK button 91 or the apply button 92 provided on the item setting screen via the input operation unit 11. Then, the information entered by the operator as a series of environment setting operations is registered as maintenance data, and the series of environment settings is completed. The data maintenance device can create a plurality of maintenance data by repeating such processing. When the same operator logs in next time, the data maintenance device displays the list of maintenance data created in the past on the configuration menu screen as shown in Fig. 4. In addition, when the maintenance data settings created in the past are modified, the data maintenance device automatically reflects the last modified settings in the maintenance data.

 [0056] Maintenance menu setting in environment settings

 Now, as described above, the data maintenance device is configured so that the maintenance menu can be customized from the environment setting menu screen. The maintenance menu customization function is described below.

 [0057] As shown in FIG. 21, the data maintenance device, when the operator clicks the menu setting button 45 provided on the environment setting menu screen through the input operation unit 11, the screen creation processing unit 12 Under the control, for example, a menu customization screen as shown in FIG.

This menu customization screen is provided with a menu list display area 101 in which a list of maintenance menus such as name management and master maintenance is displayed in a tree shape. The data maintenance device is operated in response to the operator selecting the desired maintenance menu from among the maintenance menus displayed in the menu list display area 101 via the input operation unit 11 and selecting the desired maintenance menu. A list of maintenance data included in the menu is displayed in the maintenance data list display area 102. Of the maintenance menus displayed in the menu list display area 101, the highest level menu is displayed. The menu displays a list of all maintenance data in the maintenance data list display area 102, and each maintenance menu is positioned in a lower hierarchy of the top menu.

 [0059] The data maintenance device is provided on the menu customization screen with the operator highlighting and selecting a desired maintenance menu including the top menu via the input operation unit 11. Click the Add button 103 or right-click to select “Add new menu item” from the context menu displayed, for example as shown in FIG. 23 or FIG. In addition, a new menu item can be added to the lower level of the selected maintenance menu. Fig. 23 shows the addition of a "new menu item" with the "top menu" selected, and Fig. 24 shows the "name management maintenance menu" already created. In this state, “New menu item” is added as a submenu of the name management maintenance menu.

 [0060] In addition, the data maintenance apparatus can delete the maintenance menu that has already been created except for the top-level menu. Specifically, the data maintenance device clicks the delete button 104 provided on the menu customization screen with the operator selecting and selecting the maintenance menu to be deleted via the input operation unit 11. Alternatively, in response to selecting “Delete selected menu item” from the context menu displayed by right-clicking, a dialog to confirm the intention to delete is displayed as shown in FIG. 25, for example. When the intention to delete is displayed, the selected maintenance menu and all submenus included in the maintenance menu can be deleted as shown in FIG. 25 and 26 show a state where the “name management maintenance menu” including one submenu is deleted.

[0061] Further, the data maintenance apparatus can rearrange the display order of the maintenance menus already created except for the top menu. Specifically, in the data maintenance apparatus, for example, as shown in FIG. 27, the operator drags a maintenance menu to be rearranged via the input operation unit 11, and as shown in FIG. By dropping the menu at a desired position, the order of the maintenance menu can be rearranged and displayed.

 [0062] By adding maintenance data to such a maintenance menu, the data maintenance device can use the maintenance data only by selecting a desired maintenance menu during the maintenance operation. When registering maintenance data to be displayed on the maintenance menu, the operator selects and highlights the top-level menu via the input operation unit 11, for example, as shown in FIG. A list of data is displayed in the maintenance data list display area 102. Then, for example, as shown in FIG. 30, the operator drags maintenance data to be registered via the input operation unit 11 and drops the maintenance data on a desired maintenance menu as shown in FIG. At this time, the operator can select a plurality of maintenance data at a time via the input operation unit 11 and perform a drag and drop operation. When registering maintenance data not registered in any maintenance menu, the operator checks the check box 105 via the input operation unit 11 as shown in FIG. 32, for example. It is also possible to display a list of only unregistered maintenance data in the maintenance data list display area 102 and drop the maintenance data displayed in the maintenance data list display area 102 into a desired maintenance menu.

 [0063] The data maintenance device can register maintenance data in the maintenance menu in accordance with such an operation by the operator. At this time, the data maintenance device can also register one maintenance data in a plurality of maintenance menus as shown in FIGS. 33 and 34, for example. Fig. 33 shows how maintenance data called "Regional management maintenance data" is registered in "Additional menu 2". In Fig. 34, the same "Regional management maintenance data" is added to other "Additional menus". It also shows that it was registered in “1”.

[0064] In addition, as shown in FIG. 35, for example, the data maintenance device allows the operator to perform an input operation in a state where maintenance data registered in a certain maintenance menu is displayed in the maintenance data list display area 102. The maintenance data can be The maintenance data can be moved to another maintenance menu by dragging and dropping to the other maintenance menu. Further, as shown in FIG. 36, for example, the data maintenance device displays the maintenance data registered in a certain maintenance menu in the maintenance data list display area 102, and the operator operates the input operation unit 11. Then, the maintenance data can be copied to the other maintenance menu by dragging and dropping the maintenance data to another maintenance menu while pressing a predetermined key.

 [0065] Further, in the case of deleting maintenance data registered in a certain maintenance menu, the data maintenance device deletes the maintenance data via the input operation unit 11! In the selected state, click “Delete registered menu” button 106 on the menu customization screen, or right click to select “Delete registered menu” from the context menu. In response, the selected maintenance data can be deleted. Furthermore, when the data maintenance device returns the content changed by the above-described operation to the original state, the operator can make menu customization via the input operation unit 11 before updating the changed content. Click the undo button 107 provided on the screen or right-click to select the “Undo” from the context menu that appears. You can discard everything and return to the state before the change.

 [0066] Then, the data maintenance device updates the content input by the above-described operation in response to the operator clicking the update button 108 provided on the menu customization screen via the input operation unit 11. ,Determine. When the update process is normally performed, the data maintenance device gives an ID in front of the name of the maintenance menu added to the menu list display area 101 as shown in FIG. 37, for example. This ID will be used when starting the data maintenance device by specifying the maintenance menu from the existing system.

As described above, the data maintenance device can customize the maintenance menu from the environment setting menu screen, and can greatly improve the convenience of the operator. [0068] Maintenance changes

 When the data maintenance device actually performs the maintenance operation, the data maintenance device is connected to the database 10 under the control of the screen creation processing unit 12 in response to starting the operator maintenance program. The connection screen is displayed on the display unit 13. Specifically, when the connection destination database 10 is an SQL server, the data maintenance device displays a connection screen as shown in FIG. 2 on the display unit 13 and connects to the connection destination database; L When 0 is Oracle (registered trademark), the connection screen as shown in FIG. When the operator enters the necessary information on the connection screen via the input operation unit 11, the data maintenance device authenticates the validity of the operator and then connects to the database 10 to connect to the system. log in.

 [0069] When the data maintenance device is connected to the desired database 10, the maintenance menu set in all the tables stored in the selected database under the control of the screen creation processing unit 12 is set. Read the maintenance data list. Specifically, the screen creation processing unit 12 refers to the system catalog of the selected database, and obtains information related to the maintenance menu and maintenance data based on this. Then, the data maintenance device causes the display unit 13 to display a maintenance screen as shown in FIG. 38, for example, under the control of the screen creation processing unit 12.

 This maintenance screen is provided with a menu list display area 111 for displaying a list of maintenance menus created by the environment setting operation described above. The operator can use the input operation unit 11 to highlight the maintenance menu to be maintained among the maintenance menus displayed in the menu list display area 111 and double-click the selected menu, or Click the select button 112. In response to such an operation, the data maintenance device creates a list of all tables that can be maintained by the selected maintenance menu based on the system catalog under the control of the screen creation processing unit 12. Acquired and read out, and this is displayed on the display unit 13 as an initial display screen.

[0071] At this time, the data maintenance device displays different initial display screens on the display unit 13 according to the number of tables to be maintained under the control of the screen creation processing unit 12. The Specifically, when there is one table to be maintained, the data maintenance device displays an initial display screen as shown in FIG. 39 on the display unit 13, for example, with respect to the parent table. When there are multiple tables to be maintained, such as when there is an image, as shown in Fig. 40, an initial display screen that has a two-screen configuration power divided for each table is displayed on the display unit 13. . Note that the operation method for the initial display screen shown in FIGS. 39 and 40 is the same.

[0072] This initial display screen is provided with an all item search button 121 for displaying all data and a condition search button 122 for displaying only data that matches an arbitrary condition as maintenance targets. . As shown in FIG. 41 and FIG. 42, for example, as shown in FIG. 41 and FIG. A display data screen displaying records according to the contents set in the environment setting operation is displayed on the display unit 13. At this time, the data maintenance device displays the information of the replacement destination under the control of the screen creation processing unit 12 for the item for which the replacement setting described above is performed. For example, a data maintenance device is used to maintain inventory data, which is a table composed of multiple record cards that also have item capabilities such as inventory numbers, product codes, and quantities. If the product name, which is an item in the product master, is set, the product code consisting of a series of numbers, symbols, etc. should not be displayed as it is in the table displayed on the display data screen. Replace with the product name and display. In other words, the data maintenance apparatus normally displays the item in which the product code is displayed as it is defined in the product master and replaced with a specific product name. In addition, the data maintenance device displays items that are set to be displayed as read-only so that they can be distinguished from other items, such as displaying them in gray on the display data screen.

On the other hand, when the operator clicks the condition search button 122 via the input operation unit 11, the data maintenance device, for example, as shown in FIG. 43 under the control of the screen creation processing unit 12. A condition setting screen for setting conditions is displayed on the display unit 13. The data maintenance device allows the operator to click the item name cell via the input operation unit 11. In response to this, as shown in FIG. 44, a drop-down list 123 displaying items that can be set as conditions is displayed, and a desired item is selected. In addition, the data maintenance device allows the operator to set the extraction condition contents as shown in FIG. 45, for example. At this time, if the item power selected from the drop-down list 123 has the replacement setting described above, the data maintenance device, for example, in FIG. 46 under the control of the screen creation processing unit 12. As shown, a selection screen for displaying an item composed of a name replaced with specific arbitrary information such as a region name instead of a code is displayed on the display unit 13, and the operator selects a desired item. On the other hand, if the item selected from the drop-down list 123 has not been set for replacement as described above, the data maintenance device, for example, as shown in FIG. Let the operator enter codes and names. Then, the data maintenance device displays a drop-down list 124 displaying selectable extraction conditions, for example, as shown in FIG. 48, when the operator clicks the extraction condition cell via the input operation unit 11. And select the desired extraction conditions. In this way, the data maintenance device can set conditions via the condition setting screen.

 [0074] Note that the data maintenance device allows the operator to click on the add button 125 via the input operation unit 11 under the control of the screen creation processing unit 12, for example, as shown in FIG. Multiple settings can be set by adding a setting line. In addition, the data maintenance device displays the clicked condition setting line under the control of the screen creation processing unit 12 when the operator clicks the delete button 126 via the input operation unit 11. You can also Furthermore, when a plurality of conditions are set, the data maintenance device, as shown in FIG. 49, for example, has the power to extract data that matches all the set conditions. Have the operator set whether to extract data.

Here, the data maintenance device can also store the conditions set via the condition setting screen so as to be reusable for each user. That is, the data maintenance device determines whether or not to save the set conditions when the condition setting operation via the condition setting screen is completed and the operator clicks the OK button 127 via the input operation unit 11. Check When a save intention operation is performed, a search condition name input screen as shown in FIG. 50 is displayed on the display unit 13 under the control of the screen creation processing unit 12. Let Then, the data maintenance device stores the conditions in response to the operator inputting the search condition name in the input box 128 via the input operation unit 11. Further, when reusing the stored conditions, the data maintenance device, for example, as shown in FIG. 51, the operator selects a desired one from the drop-down list 129 on the condition setting screen via the input operation unit 11. By selecting a condition and clicking the OK button 127, data that matches the selected condition can be extracted. The data maintenance device is called to reuse the saved conditions, and when the contents are changed, whether or not to save the changed conditions by overwriting under the control of the screen creation processing unit 12. A dialog to confirm the confirmation is displayed, and an intention to save is displayed, so that the new conditions can be overwritten and saved. In addition, the data maintenance device can change the name of the saved condition at will. Specifically, the data maintenance device, for example, as shown in FIG. 52, for example, as shown in FIG. 53, when the operator clicks the edit button 130 provided on the condition setting screen via the input operation unit 11. The search condition edit screen as shown in the figure is displayed on the display unit 13, and the name of the condition displayed on the search condition edit screen can be arbitrarily changed by the operator. Further, when deleting the saved conditions, the data maintenance device, for example, as shown in FIG. 54, the operator checks the check box 131 provided on the search condition edit screen via the input operation unit 11. Thus, the condition corresponding to the check box 131 can be deleted.

 [0076] After setting the conditions in this way, the data maintenance device performs the environment setting operation as shown in FIG. 41 and FIG. 42 under the control of the screen creation processing unit 12. Display the display data screen that displays the records according to the contents set in, 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 if the data consists of a large amount of records.

[0077] When the display data screen is displayed on the display unit 13, the data maintenance device performs the following operations in addition to normal operations such as copying, cutting, pasting, and deleting of each cell constituting the table. be able to. First, the data maintenance device can add rows constituting the table via the display data screen. In other words, the data maintenance device is displayed in the context menu displayed when the operator clicks or adds a right-click button on the toolbar that implements various functions for each table via the input operation unit 11. The user can arbitrarily add a line in response to selecting “Add Line” from “” or selecting “Add Line” from a predetermined editing menu. The data maintenance device can also copy the contents of the row with the selected cell as it is and add it as a new row via the display data screen. In other words, the data maintenance device can be selected from the context menu displayed by the operator clicking the copy addition button on the toolbar that realizes various functions for each table or right-clicking via the input operation unit 11. Any line can be copied and added by selecting "Copy and Add Line" or selecting "Copy Line and Add" from the predefined editing menu. Furthermore, the data maintenance device can delete rows constituting the table via the display data screen. In other words, the data maintenance device can be selected from the context menu displayed when the operator clicks the delete button on the toolbar that realizes various functions for each table or right-clicks via the input operation unit 11. One or more selected rows can be arbitrarily deleted in response to selecting “Delete Row” or selecting “Delete Row” from the predefined edit menu.

 [0079] In addition, the data maintenance device allows the operator to click an output button on a toolbar that realizes various functions for each table via the input operation unit 11, or select "output to file" from a predetermined editing menu. The data of the table displayed on the display data screen can be output to a file in the so-called CSV (Comma Separated Value) format.

[0080] Further, when performing a maintenance operation, it is desirable to arbitrarily set the display width of each column constituting the table so that the operator can easily see. For this reason, as shown in FIG. 55, for example, as shown in FIG. 55, the data maintenance device displays a desired column by dragging the cursor to the separator line dividing each column via the input operation unit 11. The width can be changed. At this time, the data maintenance device operates When the display data screen is closed under the control of the screen creation processing unit 12 by checking the check box 132 provided on the display data screen via the input operation unit 11 When the display width of each column at that time is automatically saved and displayed again on the display unit 13, the display data screen can be displayed with the saved display width.

[0081] Furthermore, the data maintenance device is, for example, branch data which is a table composed of a branch code, a store code, and a plurality of records having item power as a child table for the district data as the parent table. If there are multiple tables to be maintained, such as when maintaining these district data, branch data, and store data, the control of the screen creation processing unit 12 Based on the above, as shown in FIGS. 40 and 42, the display unit 13 displays the initial display screen and the display data screen having a two-screen structure divided for each table. In this case, as shown in FIG. 56, for example, the data maintenance device allows the operator to place the cursor on the separator line dividing each table and drag through the input operation unit 11, thereby The display ratio can be changed. In addition, the data maintenance device displays the screen so that the content corresponding to the child table is switched to the corresponding content under the control of the screen creation processing unit 12 as an arbitrary record in the parent table is selected. Is made. Even in this case, the data maintenance device will display both the parent table and the child table in a form in which the replaced item is replaced with the replacement destination information.

In addition, the data maintenance device can display a history via a display data screen. That is, in the case where history is set, the data maintenance device displays the history via the input operation unit 11 and selects the row with the cell, and the entire data display screen is displayed. Create a screen according to the history display button on the toolbar that implements various functions, or by selecting “Display History” from the context menu displayed by right-clicking. Under the control of the unit 12, for example, a history display screen as shown in FIG. 57 can be displayed on the display unit 13. The data maintenance device can perform the same operation on the history display screen as the operation on the display data screen. The data maintenance apparatus allows the operator to perform arbitrary maintenance operations such as registration, update, and Z or deletion of new data via such various screens. The data maintenance device automatically reflects the maintained contents in the contents of the database. Note that the data maintenance device can automatically delete the corresponding child table when performing maintenance for deleting the parent table when performing maintenance on the table having the parent-child relationship.

 As described above, the data maintenance apparatus shown as the embodiment of the present invention is the information input through the input operation unit 11 and the database 10 under the control of the screen creation processing unit 12. Based on the system catalog, various environment setting screens for operating data when performing environment setting operations that define the contents of maintenance, and maintenance screens for operating data when performing maintenance operations Various screens can be created automatically. In other words, under the control of the screen creation processing unit 12, the data maintenance device automatically creates various environment setting screens and various maintenance screens based on the data actually stored in the database 10. Since it is created, various screens for environment setting and various maintenance screens can be created regardless of differences in the system. At this time, based on the contents set via the replacement setting screen, the data maintenance device replaces each item value with arbitrary information that can be easily understood by the operator instead of the code, and displays it on the maintenance screen. Can be made.

 [0085] Further, the data maintenance device displays various screens for setting the environment that define the contents of the maintenance on the display unit 13 under the control of the screen creation processing unit 12, and through this screen, the maintenance data is displayed. Can be collected for each maintenance operation to be used and registered as one menu, and the maintenance menu can be customized by operating this maintenance menu.

[0086] Therefore, in the data maintenance device, various environment setting screens and various maintenance screens that are customized according to the operator's preference can be easily obtained by simply performing environment setting with simple input selection work. Therefore, it is possible to eliminate the need to program each system individually as in the past. Also, for data maintenance devices, customize the maintenance menu. This makes it easy to set up the environment that defines the contents of maintenance and greatly improves the convenience of the operator.

 [0087] As described above, the data maintenance device significantly reduces the load on the system designer, system administrator, and operator who operates the system, and also reduces the development cost and maintenance cost, thereby improving the quality. It is also possible to provide extremely superior convenience.

 [0088] It should be noted 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. It can be easily applied to the maintenance of all data, including data.

 In the above-described embodiment, the database 10 includes a system catalog, and based on the system catalog, the screen creation processing unit 12 displays various screens for environment setting and various screens for maintenance. Force described as being created The present invention is applicable even when a system catalog is not used. In this case, the data maintenance device creates in advance as a user table information corresponding to a system catalog that describes information about the format of each item constituting at least the table stored in the database. By referring to this user table in step 12, various screens for environment setting and various screens for maintenance can be created. Therefore, the present invention can also be applied to a database that does not have a system catalog.

 [0090] Further, in the above-described embodiment, the power described as the environment setting program and the maintenance program exist separately. The present invention distributes the package software as a set of these two programs. In addition to this, it can also be applied to the case where functions for environment setting and maintenance are created as a single program and distributed as a single package software.

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

Claims

The scope of the claims  [1] A data maintenance device that maintains 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;  Based on the information input via the input operation means, various environment setting screens for operating data when performing environment setting operations for defining the contents of maintenance, and data for performing maintenance operations Screen creation processing means for creating various maintenance screens for operating  Display means for displaying various types of information including various environment setting screens and maintenance various screens created by the screen creation processing means,  The screen creation processing means  Maintenance data that defines the content of maintenance created via the various screens for environment settings above is collected for each maintenance operation to be used and registered as a single menu to operate the maintenance menu. Creating a menu customization screen as one of the various screens for environment setting for customizing the menu and displaying it on the display means;  Based on the data stored in the database, various values for the environment setting for setting the value of each item constituting the data to be replaced with arbitrary information easy for the operator to understand rather than the code Creating a replacement setting screen as one of the screens and displaying it on the display means;  Based on the contents set via the replacement setting screen, various maintenance screens are created as the values of the items that make up the data, instead of the above codes, with arbitrary information that is easy for the operator to understand. And display means on the display means  A data maintenance device characterized by [2] The screen creation processing means is based on at least a system catalog describing information on the format of each item constituting the table stored in the database. 2. The data maintenance apparatus according to claim 1, wherein the various screens for setting the environment and the various screens for maintenance are created. [3] The screen creation processing means includes at least the environment setting screens and the maintenance based on a user table describing information on the format of each item constituting the table stored in the database. Creating a screen  The data maintenance device according to claim 1, wherein: [4] The screen creation processing means lists all the databases connectable by the operator and displays them in a selectable manner on the display means.  The data maintenance device according to claim 2 or claim 3, wherein [5] The screen creation processing means reads a list of all tables stored in the database to be connected to perform maintenance selected through the input operation means, and displays the list on the display means so as to be selectable. Letting  The data maintenance device according to claim 4, wherein: [6] 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.  The data maintenance device according to claim 5, wherein: [7] The screen creation processing means displays a list of maintenance menus on the menu customization screen, and when an arbitrary maintenance menu is selected via the input operation means, the screen creation processing means Display the list of maintenance data included in the maintenance menu on the menu customization screen.  The data maintenance device according to any one of claims 1 to 6, wherein the data maintenance device is any one of claims 1 to 6.  [8] The screen creation processing means adds a new maintenance menu to the list and deletes the already created maintenance menu from the list in response to an operation through the input operation means.  The data maintenance device according to claim 7, wherein: [9] The screen creation processing means is also registered in the maintenance menu for V and misalignment, and displays a list of maintenance data only on the menu customization screen. The data maintenance device according to claim 7, wherein: [10] The screen creation processing means deletes the maintenance data registered in any maintenance menu according to the operation through the input operation means.  The data maintenance device according to claim 7, wherein: [11] A data maintenance method for maintaining various data stored in a relational database,  Based on the information entered by the operator who performs input operations on the database to be maintained, various environment setting screens are created for operating the data when performing environment setting operations that define the contents of maintenance. An environment setting step for displaying the created various screens for environment setting on the display means and inputting the environment setting contents via the input operation means;  Based on the information entered by the operator, create various maintenance screens for operating the data when performing maintenance operations, and display the created maintenance screens on the display means. And a maintenance process for inputting via the input operation means,  The environment setting process  Maintenance data that defines the content of maintenance created through the various screens for environment settings above is collected for each maintenance operation to be used and registered as a single menu to operate the maintenance menu. A menu customization screen display step for creating a menu customization screen as one of the various environment setting screens for customizing and displaying on the display means;  Based on the data stored in the database, various values for the environment setting for setting the value of each item constituting the data to be replaced with arbitrary information easy for the operator to understand rather than the code A replacement setting screen display process for creating a replacement setting screen as one of the screens and displaying it on the display means, In the maintenance process, based on the contents set via the replacement setting screen, the values of each item constituting the data are replaced with arbitrary information that can be easily understood by the operator instead of the code. Various screens must be created A data maintenance method characterized by  A computer-executable data maintenance program that maintains various data stored in a relational database.  Based on the information entered by the operator who performs input operations on the database to be maintained, various environment setting screens are created for operating the data when performing environment setting operations that define the contents of maintenance. An environment setting process for displaying the created various screens for environment setting on the display means and inputting the environment setting contents via the input operation means;  Based on the information entered by the operator, create various maintenance screens for operating the data when performing maintenance operations, and display the created maintenance screens on the display means. Maintenance processing to input the input via the input operation means,  The environment setting process  Maintenance data that defines the content of maintenance created through the various screens for environment settings above is collected for each maintenance operation to be used and registered as a single menu to operate the maintenance menu. A menu customization screen display process for creating a menu customization screen as one of the various environment setting screens for customizing and displaying on the display means;  Based on the data stored in the database, various values for the environment setting for setting the value of each item constituting the data to be replaced with arbitrary information easy for the operator to understand rather than the code A replacement setting screen display process that creates a replacement setting screen as one of the screens and displays it on the display means,  In the maintenance process, based on the contents set through the replacement setting screen, the maintenance value is replaced with arbitrary information that is easy for the operator to understand instead of the code as the value of each item constituting the data. A data maintenance program characterized by the creation of various screens.