JP2005050149A - System and method for managing database table data, database system, server, terminal, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable a database which handles data occurring in time series to more efficiently achieve a function similar to a time-series accumulation method (capable of referring to and updating current data; occasionally comparing table data at a certain time with table data at another time; occasionally referring to table data at a previous time). <P>SOLUTION: A system for managing database table data includes an export setting file 72 including a method of obtaining the name of a user connected to a DB, a bus to which table data is outputted, and the name of a table to be exported; an export means 71 for exporting table data in a DB storage part 3 to an external file 4 according to the content of the file and outputs the table name of the table data exported and the date of export to a management file; an import setting file 82 including a method of obtaining the name of the user connected to the DB and a bus from which the table data was inputted, a method of obtaining the table name of interest, a method of designating the name of the user to be processed, and an adding method if the name of the user is of the type with the addition of date; and an import means 81 for determining the table data of interest according to the content of the file 82 and which, if the name of the user is of the type with the addition of date, imports the table data in the external file 4 into an area different from an area used for exporting to the DB storage part 3. This solves the problem with a conventional method of accumulating data in a database in time series that accumulating a large amount of data is very inefficient in terms of database maintenance and costs. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a database table data management method and method, a database system, a database server, a terminal, and a program, and more particularly, a database table that exports database table data to an external file and imports the exported table data of the external file as needed. The present invention relates to a data management method and method, a database system, a database server, a terminal, and a program.

  Conventionally, database systems are required to compare table data at a certain point in time with other points in time or to refer to table data at a past point in time.

  In order to clear the above requirements, a method of accumulating data in a database in time series is adopted.

  On the other hand, because of the above requirements, there is often a need to store data for a long time, but the frequency of use of stored data is not necessarily high.

  As a conventional example of outputting table data to an external file, the table structure of the table data created in the HTML format is analyzed via a WWW browser, and the table data is converted into table data in the editing program based on the analyzed table structure. There is an information processing method and an information processing apparatus that convert to a recognizable format and output the converted table data to an external file (see Patent Document 1).

JP 2001-256220 A (first page)

  The above-mentioned method of accumulating data in the database in time series accumulates infrequently used data in a large amount in the database, so it is very inefficient when considering database maintenance and cost. was there.

  Further, in the conventional example in which the table data is output to an external file, it is not indicated that the original data created in the HTML format is deleted from the file storage device or the like, which causes problems in terms of database maintenance and cost. It does not solve.

  It is an object of the present invention to more efficiently function the same as the time series accumulation method in a database that handles data generated in time series (current data can be referred to and updated, and table data at a certain time point and other time points can be It is possible to compare irregularly and refer to the table data at the past time irregularly).

  The first database table data management method of the present invention includes an export means for exporting database table data to an external file, an import means for importing table data of an external file into a database, an export setting file, and an import setting file. The export setting file includes a user name, a table data output destination path, and a table name acquisition method to be exported, and the export means sets the database access destination as the area corresponding to the user name, and export settings. Depending on whether the target table name acquisition method of the file is list use or manual selection, the table specified by the list or the table selected from the user-owned table name in the schema information of the database is the target, respectively. Specify data by output path Create a management file that includes the table name of the output table data and the output date information, and create the management file that contains the user name, table data input source path, export Including a target table name acquisition method, wherein the import means sets the access destination of the database as the area corresponding to the user name, and depending on whether the target table name acquisition method is list use or manual selection, The table selected from the table name of the management file is targeted, the table data of the external storage device file specified by the input source path is stored in the database, and the table name information held by the user of the schema information is targeted It is characterized by adding the table name.

  The second database table data management method according to the present invention includes an export means for exporting database table data to an external file, an import means for importing table data of an external file into a database, an export setting file, and an import setting file. The export setting file includes a user name, a table data output destination path, and a table name acquisition method to be exported, and the export means sets the database access destination as the area corresponding to the user name, and export settings. Depending on whether the file target table name acquisition method is list use or manual selection, the table data specified in the list or the table selected from the user-owned table name in the schema information of the database is the target, respectively. Is specified by the output destination path Create a management file that includes the table name of the output table data and the output date, and create a management file that contains the user name, input path of the table data, target table A name acquisition method, a processing target user name specification method, and a format specification for adding date information when it is a date addition type user name, and the import means determines whether the processing target user name specification method is a date addition type. Depending on the user name of the import setting file, the name of the table data to be imported is the user name added according to the above format, or the user name of the setting file is the processing target user name, and the target table name acquisition method is listed Depending on whether it is used or manually selected, the table specified by the list or the table selected from the table name of the management file is targeted, and specified by the input source path. The table data file, stored in the area corresponding to the processing target user name in the database, and writes the table name of the target as a table name information held association with the processed user name schema information.

  A first database system according to the present invention is a database system in which a database server and a user terminal that accesses the database server are network-connected, and the database server includes a database storage unit and a schema including a table name owned by each user An information storage unit, an export processing unit that receives a request from the user terminal and exports the table data in the database storage unit to an external file, and an import that imports the table data received from the user terminal and exported to an external file into the database storage unit The user terminal includes an export setting file storage unit, an import setting file storage unit, a list file storage unit, an export request processing unit, and an import request processing unit. Includes a user name, an output destination path of table data, and a table name acquisition method for export. The export request processing means connects to the database server with the user name, and acquires an export setting file and its target table name. A request is sent to the database server together with a list file when the method is list use, the user terminal stores the received management file in the corresponding storage unit, and the export processing means includes a target table of the received export setting file Depending on whether the acquisition method is list use or manual selection, the table specified by the list or the table name held by the corresponding user of the schema information is returned to the export request processing means and the table selected from this is stored in the database To the external file specified by the output destination path of the received configuration file Create a management file containing the table name of the output table data and the output date and date, and send it to the user terminal. The import setting file contains the user name, the input path of the table data, Including a table name acquisition method of import target, the import request processing means acquires the table name selected from the table name of the management file if the target table acquisition method of the import setting file is manual selection, and the user name Connect to the database server, send a request to the database server with the import setting file and the list file or the acquired table name, and the import processing means uses the list of target table name acquisition method of the received setting file Depending on whether it is manual selection or table name specified in the received list, or the table data specified respectively by the received table name In this case, the file is stored in the database storage unit from the file in the external storage device specified by the input source path, and the target table name is added to the table name information held by the user in the schema information storage unit.

  A second database system of the present invention is a database system in which a database server and a user terminal that accesses the database server are network-connected, and the database server includes a database storage unit and a schema including a table name held by each user An information storage unit, an export processing unit that receives a request from a user terminal and exports the table data of the database storage unit to an external file, and an import processing unit that receives a request from the user terminal and imports the table data of the external file to the database storage unit The user terminal includes an export setting file storage unit, an import setting file storage unit, a list file storage unit, an export request processing unit, and an import request processing unit. The export setting file includes a user name, Table The export request processing means connects to the database server with the user name, and the export setting file and the target table name acquisition method use a list. A request is sent to the database server with the list file, the user terminal stores the received management file in the corresponding storage unit, and the export processing means manually uses the list whether the target table acquisition method of the received export setting file is list use Depending on the selection, the table specified in the list or the table name held by the corresponding user of the schema information is returned to the export request processing means, and the table selected from this is received, and the table data in the database storage unit is received. Output to the external file specified by the output path of the configuration file Create a management file that contains the table name and the output date and time, and send it to the user terminal. The import setting file contains the user name, the input path of the table data, and the table name to be imported And a processing target user name specifying method and a format specification for adding date information when this is a date-added type user name, and the import request processing means is configured such that the target table name acquisition method of the setting file is manually set If selected, obtains the selected table name from the table name of the management file. If the user name specification method for processing is not date-added, connect to the database server with the user name in the configuration file and use the date-added type. For example, a connection request is made to the database server with a user name in which the date information of the table data to be imported is added to the user name in the setting file according to the above format, and the user name is not yet found. If registration, request registration of the user name, connect to the database server, send the request to the database server with the import setting file and the list file or the acquired table name, the import processing means, In response to the user name registration request, an area corresponding to the user name is secured in the database storage unit, and the received list is specified depending on whether the target table name acquisition method of the received setting file is list use or manual selection. The table name of the external storage device file specified by the input source path is stored in the user name corresponding area of the database storage unit, and the user name is stored in the schema information storage unit. The target table name is written as table name information associated with and stored in the table.

  The first database server of the present invention includes a database storage unit, a schema information storage unit including a table name owned by each user, an export processing unit that exports table data in the database storage unit to an external file in response to a request from a terminal. , A database server including an import processing unit that receives a request from the terminal and imports the table data of the external file into the database storage unit, and the export processing unit uses the list of target table acquisition methods of the export setting file received from the terminal Depending on whether it is selected manually or manually, the table name specified in the list or the table name held by the user corresponding to the schema information is returned to the terminal and the table selected from this is received, and the table data in the database storage unit is received Output to an external file specified by the output path of the configuration file, and output Create a management file containing the table name of the table data and the output date and time, and send it to the terminal. Whether the import processing means uses the list as the target table name acquisition method of the setting file received from the terminal Depending on whether it is manual selection or the table name specified in the received list, or the table name of the file of the external storage device specified by the input source path is stored in the database storage unit. The target table name is added to the table name information held by the user of the schema information storage unit.

  The second database server of the present invention includes a database storage unit, a schema information storage unit including a table name owned by each user, an export processing unit that exports table data in the database storage unit to an external file in response to a request from a terminal. , Including an import processing unit that receives a request from the terminal and imports the table data of the external file into the database storage unit, and the export processing unit determines whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection Depending on the table specified in the list or the table name held by the corresponding user of the schema information returned to the terminal, the table data in the database storage unit is output to the output destination of the received setting file Is output to the external file specified by the path, and the table name of the output table data is output Create a management file containing the date and date and send it to the terminal. The import processing means responds to the user name registration in the database storage unit in response to a new date addition type user name registration request from the terminal. The target table name of the setting file received from the terminal is used for the list name specified by the received list or the received table name is input, depending on whether the list file acquisition method is the list use or manual selection method. Store the table data of the file in the external storage device specified by the original path in the user name correspondence area of the database storage unit, and write the target table name as the table name information associated with the user name in the schema information storage unit It is characterized by that.

  A first terminal of the present invention is a terminal that accesses a database server through a network, and includes an export setting file storage unit, an import setting file storage unit, a list file storage unit, an export request processing unit, and an import request process. The export setting file includes a user name, an output destination path of table data, and a table name acquisition method to be exported, and the export request processing means connects to the database server with the user name, and export settings The export setting request is sent to the database server together with the list file when the file and its target table name acquisition method is list use, the management file received from the database server is stored in the corresponding storage unit, and the import setting file Includes user name, table The import request processing means acquires the table name selected from the table name of the management file if the target table acquisition method of the import setting file is manually selected. Then, the user name is connected to the database server, and an import processing request is sent to the database server together with the import setting file and the list file or the acquired table name.

  A second terminal of the present invention is a terminal that accesses a database server through a network, and includes an export setting file storage unit, an import setting file storage unit, a list file storage unit, an export request processing unit, and an import request process. The export setting file includes a user name, an output destination path of table data, and a table name acquisition method to be exported, and the export request processing means connects to the database server with the user name, and export settings The export setting request is sent to the database server together with the list file when the file and its target table name acquisition method is list use, the management file received from the database server is stored in the corresponding storage unit, and the import setting file Includes user name, table Input request path, import target table name acquisition method, processing target user name designation method, and format designation for adding date information when this is a date addition type user name, the import request processing means Acquires the table name selected from the table name of the management file if the target file name acquisition method of the setting file is manual selection, and if the processing target user name specification method is not a date addition type, the user of the setting file Connect to the database server by name, and if it is a date-added type, make a connection request to the database server with the user name with the date and time information of the imported table data added to the user name in the setting file according to the above format, and that user If the name is not registered, request registration of the user name, connect to the database server, import setting file and list file or With a table name and wherein the sending the import process request to the database server.

  The first program of the present invention reads an export setting file including a user name, an output destination path of table data, and a table name acquisition method to be exported from a storage device, connects to the database server with the user name, and export settings file And an export request processing procedure for sending an export processing request to the database server with a list file when the target table name acquisition method is list use, and storing the management file received from the database server in the corresponding storage unit, Import setting file including user name, table data input source path, import target table name acquisition method is read from the storage device, and if this target table acquisition method is manual selection, it is selected from the table name of the management file Get the table name, connect to the database server with the username, And over preparative configuration file, characterized in that to execute and the import request procedure sends the import processing request to the computer with a list file or table names that the acquired database server.

  The second program of the present invention reads an export setting file including a user name, an output destination path of table data, and a table name acquisition method to be exported from a storage device, connects to the database server with the user name, and export settings file And an export request processing procedure for sending an export processing request to the database server with a list file when the target table name acquisition method is list use, and storing the management file received from the database server in the corresponding storage unit, Import setting file including user name, table data input source path, import target table name acquisition method, processing target user name specification method, and format specification to add date information if this is a date addition type user name , Read from the storage device, if the target table name acquisition method is manual selection Acquires the table name selected from the table name of the logical file, and if the processing target user name specification method is not the date addition type, connects to the database server with the user name of the configuration file. Request the database server to connect to the database server with the user name in which the date and time information of the table data to be imported is added to the user name according to the above format, and if the user name is not registered, request the registration of the user name, and The computer is connected to the server, and the computer executes an import request processing procedure for sending an import processing request to the database server together with the import setting file and the list file or the acquired table name.

  According to the third program of the present invention, depending on whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection, the table specified by the list or the table name held by the corresponding user of the schema information is stored. Targeting the table returned to the terminal and selected from it, the table data in the database storage unit is output to the external file specified by the output destination path of the received configuration file, and the table name and output of the output table data Created a management file that includes the date and time of the date and time received, depending on whether the export processing procedure to be sent to the terminal and the target table name acquisition method of the setting file received from the terminal is list use or manual selection Target the table name specified in the list or the received table name, and store the table data of the file of the external storage device specified by the input source path in the database storage unit It was paid, characterized in that to execute the import processing procedure appending the table name of the target table name information held by the user of the schema information storage unit to the computer.

  According to the fourth program of the present invention, depending on whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection, the table specified by the list or the table name held by the corresponding user of the schema information is stored. Targeting the table returned to the terminal and selected from it, the table data in the database storage unit is output to the external file specified by the output destination path of the received configuration file, and the table name and output of the output table data Create a management file that includes the date and date and the export processing procedure that is sent to the terminal and the registration request for the new date-added user name from the terminal. Depending on whether the target table name acquisition method of the setting file received from the terminal is list use or manual selection, the table name specified by the received list, or Stores the table data of the file of the external storage device specified by the input source path in the user name corresponding area of the database storage unit, and stores it in the schema information storage unit in association with the user name. An import processing procedure for writing a target table name as table name information is executed by a computer.

  The first database table data management method of the present invention reads an export setting file including a user name, a table data output destination path, and a table name acquisition method to be exported from a storage device, and connects to the database server with the user name The export processing file is sent to the database server together with the list file when the target table name acquisition method is list use, and the management file received from the database server is stored in the corresponding storage unit. Depending on whether the request processing procedure and the target table acquisition method of the export setting file received from the terminal is list use or manual selection, the table specified by the list or the table name held by the corresponding user of the schema information is exported request processing procedure To the table selected by replying to Output the table data in the base storage to an external file specified by the output destination path of the received configuration file, and create a management file that includes the table name of the output table data and the output date and time Read the import setting file including the export processing procedure to be sent to the terminal, the user name, the input path of the table data, and the table name acquisition method to be imported from the storage device, connect to the database server with the user name, and import settings File and list file when the target table name acquisition method is list use, or import request processing procedure that sends an import processing request to the database server with the target table name, and the target of the setting file received from the terminal Depending on whether the table name acquisition method is list use or manual selection, the table name specified by the received list, or The table name of the external storage device file specified by the input source path is stored in the database storage unit for the received table name, and the target table name is stored in the table name information held by the user in the schema information storage unit. And an import processing procedure to be additionally recorded.

  The second database table data management method of the present invention reads an export setting file including a user name, a table data output destination path, and a table name acquisition method to be exported from a storage device, and connects to the database server with the user name. The export processing file is sent to the database server together with the list file when the target table name acquisition method is list use, and the management file received from the database server is stored in the corresponding storage unit. Depending on whether the request processing procedure and the target table acquisition method of the export setting file received from the terminal is list use or manual selection, the table specified by the list or the table name held by the corresponding user of the schema information is exported request processing procedure To the table selected by replying to Output the table data in the base storage to an external file specified by the output destination path of the received configuration file, and create a management file that includes the table name of the output table data and the output date and time , Export processing procedure to be sent to the terminal, user name, table data input source path, import target table name acquisition method, processing target user name designation method, date / date information if this is a date addition type user name Import setting file including the format specification to be read from the storage device, and if the target table name acquisition method is manual selection, the table name selected from the management file table name is acquired, and the processing target user name specification method If is not date-added, connect to the database server with the user name of the setting file. If date-added, import table data to the user name of the setting file. Request connection to the database server with the user name with the date information added according to the format, and if the user name is unregistered, request registration of the user name, connect to the database server, import setting file, In response to an import request processing procedure for sending an import processing request to the database server with a list file or the acquired table name and a registration request for a new date addition type user name from the terminal, the user name is stored in the database storage unit. Secure the corresponding area, depending on whether the target table name acquisition method of the setting file received from the terminal is list use or manual selection, the target table name specified by the received list, or the received table name, Store the table data of the external storage device file specified by the input source path in the user name corresponding area of the database storage unit. And an import processing procedure for writing the target table name as the table name information held in association with the user name in the schema information storage unit.

  According to the present invention, the data storage method is not the data retention method based on the database time series accumulation method, but the table data retention method in the database external file format is adopted, so that a minimum database area can be secured and the data comparison can be performed. Thus, it is possible to provide a degree of freedom of data storage without being bothered by much time-consuming estimation of the amount of database and database maintenance.

  In addition, when importing between a user who is executing export and another user, even if it is a table with the same name, the saved data is actually returned to the database as a separate schema table, so the table definitions and items from the past (export execution) Even if the definition is changed, it can be handled.

  Further, in the conventional time series accumulation method of data deletion, it is necessary to delete in units of records, and information before update is always generated. Therefore, a large amount of records are deleted and processing time and area are required.

  In addition, fragmentation of data blocks constituting the table and useless areas occur, and there is a high possibility that access performance deterioration and block usage rate deterioration will occur.

  Compared with this, since the table which became unnecessary in this invention is deleted for every table, such an influence is small.

  Next, when it is possible to secure a timing at which transaction processing does not occur for a certain period of time such as at night, the present invention can be used as a daily (yearly / monthly / daily) backup / restore method. -Since only the necessary table data is to be restored, it is possible to avoid unnecessary storage area and processing time waste compared to cold backup and the like.

  In addition, if a data restoration is required in the event of a failure of the machine that performed the export process, the saved file contains only table data and some management information. It is possible to return data and refer to the data relatively easily to the database system of a different machine.

  Next, the best mode for carrying out the present invention will be described in detail with reference to the drawings. First, referring to FIG. 1, the database table data management method of the present invention will be described.

  A DB (database) system main body 1 includes a DB storage unit 3 and a schema information storage unit 2. The schema information storage unit 2 holds a table name held by each user.

  As shown in FIG. 6, the export setting file 72 includes a database connection user name, a password, a file output destination path, and a table name acquisition method to be exported.

  The export means 71 sets the access destination of the DB system main body 1 as the area corresponding to the user name, and specifies the table specified by the list file 73 according to whether the target table name acquisition method of the export setting file 72 is list use or manual selection. Alternatively, a table name owned by the user in the schema information storage unit 2 is acquired, and the table name displayed on the input / output device 6 and selected by the user is set as the target table name.

  The target table data in the DB storage unit 3 is output to an external file specified by a file output destination path, and the management file 5 includes the table name of the table data output to the external file and the output date Create

  As shown in FIG. 8, the import setting file 82 includes a database connection user name, a file input source path, an import target table name acquisition method, an import processing target user name designation method, and a year when it is a date addition type user name. Includes a user name date addition format for adding month and day information.

  The import unit 81 adds the date / month / day information of the table data to be imported to the user name of the import setting file according to the format depending on whether the user name specification method of the processing target is the date addition type or only the user name of the import setting file. Or the user name of the setting file as the processing target user name.

  If the target table name acquisition method is list use, the table specified by the list file 83 is targeted. If the target table name acquisition method is manual selection, the table name and date of the management file 5 are acquired, and the table displayed on the input / output device 6 and selected by the user is set as the target table.

  The table data of the file specified by the input source path is stored in the area corresponding to the processing target user name in the DB storage unit 3, and the target is the table name information stored in association with the processing target user name in the schema information Write the table name.

  A specific operation of export or import will be described with reference to FIG. An example of importing table data saved in an external file by export processing using a user name different from that at the time of export processing will be described.

  In March 1999, the DB storage unit 3 stores the table [AAAA] [BBBB] [CCCC] [DDDD] in the area 31 of the user xxx, and the schema information storage unit 2 stores the xxx possession table information. [AAAA] [BBBB] [CCCC] [DDDD].

  In March 1999, monthly export was automatically performed using the export setting file 72 and the list file 73.

  Table data [AAAA] [BBBB] [CCCC] [DDDD] of March 1999 was output to the external file 4 (table configuration information, display information, and data were output).

  [CCCC] is a table that has been exported as April and May 1999, and all table data has already been exported and is scheduled to be used until May 1999. There is no regular access to this table. Deleted. It was deleted from the DB storage unit 3 and the name was deleted from the xxx possession table.

  [AAAA] [BBBB] [DDDD] table of the DB storage unit 3 deletes data by collecting a plurality of blocks and leaving the configuration information and display information unchanged when there is no regular access to the data block after export. .

  In March 2003, it became necessary to make a comparison with the data of March 1999. The only table data that needs to be compared is [BBBB] and [DDDD].

  Of the tables [AAAAA] [BBBB] [CCCC] [DDDD] exported in March 1999, only the [BBBB] and [DDDD] tables are imported, and the data comparison is performed.

  The import setting file 82 designates the import, and the import means 8 generates a user name xxx_199903 in which the date is added to the original user name xxx as the user name based on the contents, and uses it as the user name at the time of import.

  The import setting file 82 also describes how to specify the table to be imported, and specifies whether to specify the list file 83 or to manually select from the table data of the management file 5 created at the time of export.

  The import means 8 selects the tables “BBBB” and “DDDD” of March 1999 in response to the list display of the management file 5 created at the time of export.

  The DB system body 1 receives the user name at the time of import, and prepares an area corresponding to “xxx — 199903” separately from the area corresponding to xxx in the DB storage unit.

  The import means 81 imports the tables [BBBB] and “DDDD” in the data 4 exported at the end of March 1999 according to the selected table name into the area corresponding to “xxx — 199903”, and stores the table “xxx — 199903” in the schema information storage unit 2. Add information so that user xxx can refer to it.

  Next, an example of the database system of the present invention will be described. FIG. 2 is a diagram showing the overall configuration of the database system of the present invention. The database system of the present invention is configured by connecting a DB server 10 and user terminals 20 and 30 via a network 100 such as a LAN.

  The DB server 10 includes a communication processing unit 11, a DB access processing unit 12, an external storage device 13 such as a large-capacity hard disk, and an external storage device 14 to which a removable medium 141 can be attached.

  The DB access processing unit 12 includes a management unit 121, a DB reference update processing unit 122, an export processing unit 124, and an import processing unit 123.

  The external storage device 13 includes a schema information storage unit 131 including table names owned by each user, a DB storage unit 132 that stores each table data of the database, and a management file storage unit that stores a master of the management file created at the time of export 133 is included.

  When the DB reference update processing unit 122 receives a reference request from the user terminal 20 or 30 and the table to be referenced is the table information held by the user in the schema information storage unit 131, the DB reference update processing unit 122 stores the corresponding table data in the DB storage unit. The data is transmitted to the reading user terminal 20 or 30.

  When an update request is received from the user terminal 20 or 30, the table to be updated is the table information held by the user in the schema information storage unit 131, and if the update right of the user is set, the target of the DB storage unit 132 is set. Update table data.

  Also, table deletion and table data are deleted in block units.

  The export processing unit 124 receives a request from the user terminal 20 and exports the table data in the database storage unit to an external file.

  The import processing unit 123 receives a request from the user terminal 20 or 30 and imports the table data of the external file into the database storage unit.

  The DB server 10 includes, as hardware, an input device such as a keyboard, an output device such as a display, an external storage device 13 such as a large-capacity hard disk, an external storage device 14 to which a removable medium 141 can be mounted, a communication device, And a CPU for controlling these and a main memory.

  The management unit 121, the DB reference update processing unit 122, the export processing unit 124, and the import processing unit 123 are realized by a program of the DB server 10.

  The user terminal 20 includes a communication processing unit 21, a DB access request processing unit 22, and an external storage device 23 such as a hard disk.

  The DB access request processing unit 22 includes a DB reference update request processing unit 221, an export request processing unit 222, and an import request processing unit 223.

  The external storage device 23 includes a management file storage unit 231, an export setting file storage unit 232, an import setting file storage unit 233, and a list file storage unit 234.

  The export setting file includes the user name, table data output destination path, and the export target table name acquisition method. The import setting file includes the user name, table data input source path, import target table name acquisition method, A processing target user name designation method, including a format designation for adding date information when this is a date addition type user name.

  The DB reference update request processing unit 221 connects to the DB server 10 with the user name and password, and requests DB reference / update. Also, a table deletion or table deletion request is made in units of blocks.

  The export request processing means connects to the database server with the user name, and sends a request to the DB access processing means 12 together with the export setting file and the list file when the target table name acquisition method is list use.

  The import request processing means acquires the table name selected from the table name of the management file if the target table name acquisition method of the import setting file is manual selection, and if the processing target user name specification method is not a date addition type, Connect to the DB server 10 with the user name of the setting file, and if it is a date addition type, connect to the DB server 10 with the user name to which the date information of the table data to be imported is added according to the above format to the user name of the setting file If the user name is not registered, a request for registration of the user name is made, the DB server 10 is connected, and the DB access processing means is connected with the import setting file and the list file or the acquired table name. A request is sent to 12.

  The user terminal 30 is a normal user terminal that is not an administrator, does not include the export request processing means 222 and the export setting file storage unit 232, and has only a DB reference update request processing function and an import function.

  There are also examples in which the functions and configurations are the same as those of the user terminal 20.

  Further, the user terminal 20 includes, as hardware, an input device such as a keyboard, an output device such as a display, an external storage device 13 such as a hard disk, a communication device, a CPU for controlling these programs, and a main storage device.

  The DB reference update request processing unit 221, the export request processing unit 222, and the import request processing unit 223 are realized by a program of the user terminal 20. The hardware configuration of the user terminal 30 is the same as that of the user terminal 20.

  Next, the operation of the best mode for carrying out the present invention will be described with reference to the drawings. Based on the example of FIG. 1, the export processing operation will be described in detail according to the export processing flow of FIG.

  The processing timing is executed by schedule execution or at an arbitrary timing. It is assumed that the schedule was executed at the end of March 1999 as in the case of FIG.

  The user terminal 20 schedules the export request processing means of the DB access request processing means, which reads the export setting file from the export setting file storage unit 232 (step A1).

As shown in FIG. 6, the following information is described in the export setting file.
(1) Database user name / password (2) File output path (3) Specification of target table acquisition method (whether to acquire from a list file that describes the target table or display a list of owned tables and manually select a table Specified)
In the case of FIG. 6, the user who also serves as the DB administrator exports a plurality of DB data (including the table structure and display information) monthly, so the table name is almost constant, so the list is used. And

  Next, the export request processing means 222 connects to the database (step A2). Connect to the database with the database user name obtained from the export settings file.

  Specifically, the DB access processing unit 12 is connected through the communication processing unit 21, the network 100, and the communication processing unit 11. The management unit 121 checks the user name and password, and if registered, calls the export processing unit 124 and passes the received export setting file and list file.

  Next, the export processing unit 124 acquires a processing target table name. If the “target table acquisition method” in the export setting file is list use (step A3), the target table is acquired from the list file describing the target table (step A4).

  If the “target table acquisition method” is a manual selection (step A3), a table held by the connected user is displayed on the screen, and a necessary table is manually selected (a table held by the user of the schema information storage unit 131). A list of names is returned to the export request processing means 222, and the table name selected thereby is received (step A5).

  In the case of FIG. 6, “list file” is used to automate the processing at the user terminal 20.

  Next, the export processing unit 124 reads one processing target table name. One table name is acquired from the acquired target table (step A6).

  The export processing unit 124 creates a parameter file. A parameter file for export processing corresponding to the acquired table name is created (step A7).

  The export processing unit 124 executes export processing. Export the target table using the created parameter file.

  That is, the external storage device 14 is instructed to create a file with the name “AAAA”. Data including the table configuration information and display control data of the table AAAA in the DB storage unit 132 is transferred to the external storage device 14 and written into the created file.

  Perform a verify check if necessary. The export output file has the same name as the table name (step A8).

  It is determined whether all tables to be processed have been processed (loop determination). That is, if there is an unprocessed table name acquired at step A3, the process proceeds to step A4, and if there is no unprocessed, the process proceeds to step A8 (step A9).

Create a management file. As shown in FIG. 7, the following information is output to the management file. (1) Processing date (YYYYMMDD)
(2) Export table (the name of the table that executed the export process)
In the case of FIG. 6, using the date acquired from the calendar clock as the export processing date, the executed table name “AAAA”,..., “DDDD” is generated, a write file is created, and stored in the management file storage unit 133 as a master. (Step A10).

  The created management file is transmitted to the user terminals 20,... 30 (step A11). In the user terminals 20 and 30, the received file is stored in the management file storage unit 231.

  Next, based on the example of FIG. 1, the import processing operation will be described in detail according to the import processing flow of FIGS. The process is executed at an arbitrary timing.

  When the import request processing means 223 is activated, it reads an import setting file from the import setting file storage unit 233 (step B1).

As shown in FIG. 8, the following information is described in the import setting file.
(1) Database user name / password (2) File input destination path (3) Import processing target table acquisition method (designation of whether to acquire from the list of the list file storage unit 234 or manual table selection)
(4) Import process target user name specification 1) Setting file user 2) Date addition user (setting file user name + date addition)
(5) Date format when creating a date-added user name Example) YYYYMMDD YYYY MM
Next, the management file is read from the management file storage unit 231 (step B1).
As shown in FIG. 7, the management file is automatically generated when the export process is executed, and the following information is described therein.
(1) Processing date (YYYYMMDD)
(2) Export table (the name of the table that executed the export process)
In the case of FIG. 7, the processing date is 199903331, and the export table is “AAAA”, “BBBB”, “CCCC”, “DDDD”.

Next, the acquisition method of the processing target table name is determined. If the “target table acquisition method” of the import setting file is list use (step B3), the target table name is acquired from the list file (step B4). If manually selected, the “export table” acquired from the management file is acquired. Is displayed on the screen and the necessary table is manually selected (step B5).
In the case of FIG. 8, [AAAAA] [BBBB] [CCCC] [DDDD] is displayed and [BBBB] [DDDD] is manually selected.

  Next, the import target user is set. When the “import processing target user” in the import setting file is “setting file user” (step B6), the user is connected to the database. That is, it connects to the DB access processing means 12 (step B7).

  In the case of “date addition user” (step B6), the user name added with the processing date is compared with the existing user name. The import request processing means 223 makes a DB connection request with the user name added to its own user name by setting the processing date of the management file to “date format when creating a date-added user name” in the import setting file.

  If the received user name is already registered (step B8), the management unit 121 of the DB access processing unit 12 connects (step B9).

  If there is no received user name (step B8), the management unit 121 returns no user name, the import request processing unit 223 requests registration of the created user name, and the management unit 121 registers the xxx part of the user name. Therefore, the requested user is created (step B10).

  The import request processing means 223 connects to the database using the user. In the case of FIG. 8, since “date format when creating date-added user name = YYYYMM”, a user “xxx — 199903” is created and connected to the database as in the naming rule of FIG. 10 (step B11).

  The import processing means 123 receives the processing target table name at the time of connection or thereafter. One of the table names is acquired (set as a processing target. Step B12). A parameter file for import processing corresponding to the acquired table name is created (step B13).

  Import the target table using the created parameter file. That is, the import processing unit 123 secures a user-corresponding area of xxx — 199903 ″ in the DB storage unit 132, reads out the previously exported table data file information on the external storage device 14, and stores it in the area (step B14).

  If there is a received table name that has not been processed (step B15), the process of step B12 is repeated.

  If there is nothing that has not been processed (step B15), the user name and the possession table of the imported table data are written in the schema information storage unit (grant reference authority to the reference user; step B16).

  The DB data deletion after the database data export is performed as follows. When all the table data has been exported by the user terminal 20 and there is no regular access to the table in the DB storage unit 132, the administrator activates the reference update request processing means 221 and requests deletion of the table unit.

  The DB reference update processing unit 122 deletes the specified table name from the specified table data in the DB storage unit 132 and the retained table information in the schema information storage unit 131.

  When the same table is used for a long period of time, deletion of the table data that has already been exported (for example, data for one month) is requested after regular access is lost. In this case, the DB reference update processing unit 122 deletes the specified data block of the specified table in the DB storage unit 132. Deletion of data blocks is performed in correspondence with multiple exports.

The figure for demonstrating the management system of the database table data of this invention. The figure which showed the whole structure of the database system of this invention. The flowchart which showed the export processing operation | movement of this invention. The flowchart which showed the import processing operation | movement of this invention. The flowchart which showed the import processing operation | movement of this invention. The figure which showed the example of the content of the export setting file. The figure which showed the example of the content of the management file. The figure which showed the example of the content of the import setting file. The figure which showed the example of the content of the list file. The figure which showed the naming rule at the time of date addition user name creation.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 DB system main body 2 Schema information storage part 3 DB storage part 4 External file 5 Management file 6 Input / output device 71 Export means 72 Export setting file 73, 83 List file 81 Import means 82 Import setting file 10 DB server 11 Communication processing means 12 DB access processing means 121 Management means 122 DB reference update processing means 123 Import processing means 124 Export processing means 13 External storage device 131 Schema information storage portion 132 DB storage portion 133 Management file storage portion 14 External storage device 141 Removable medium 20 User terminal 21 Communication processing means 22 DB access request processing means 221 DB reference update request processing means 222 Export request processing means 223 Import request processing means 23 External storage device 231 Management file storage unit 232 Export setting file storage unit 233 Import setting file storage unit 234 List file storage unit 30 User terminal 100 Network

Claims (14)

Including export means for exporting database table data to external file, import means for importing table data of external file to database, export setting file, import setting file,
The export setting file includes a user name, an output destination path of table data, and a table name acquisition method to be exported,
The export means sets the access destination of the database as the area corresponding to the user name, and depending on whether the target table name acquisition method of the export setting file is list use or manual selection, the list specified in the list or in the schema information of the database Targets each table selected from the table names owned by the user, outputs the table data of the database to the external file specified by the output destination path, and the table name of the output table data and the output date information Create a management file that includes
The import setting file includes a user name, a table data input source path, an export target table name acquisition method,
The import means sets the database access destination as the area corresponding to the user name, and selects from the table specified by the list or the table name of the management file depending on whether the target table name acquisition method is list use or manual selection. The table data of the external storage device file specified by the input source path is stored in the database, and the target table name is added to the table name information held by the user of the schema information. Characteristic database table data management method. Including export means for exporting database table data to external file, import means for importing table data of external file to database, export setting file, import setting file,
The export setting file includes a user name, an output destination path of table data, and a table name acquisition method to be exported,
The export means sets the access destination of the database as the area corresponding to the user name, and depending on whether the target table name acquisition method of the export setting file is list use or manual selection, the list specified in the list or in the schema information of the database The table selected from the user-owned table name is output, and the database table data is output to the external file specified by the output destination path. The table name of the output table data and the output date Create a management file containing
The import setting file includes a user name, a table data input source path, a target table name acquisition method, a processing target user name designation method, and a format designation for adding date information when it is a date addition type user name. Including
The import means is a user name in which the date information of the table data to be imported is added to the user name of the import setting file according to the format according to whether the processing target user name designation method is a date addition type, or a setting file The user name of
Depending on whether the target table name acquisition method is list use or manual selection, the table specified in the list or the table selected from the table name of the management file is the target, and the table of the file specified by the input source path Data is stored in an area corresponding to the processing target user name in the database, and the target table name is written in the schema information as table name information associated with the processing target user name. Management method. A database system in which a database server and a user terminal that accesses the database server are network-connected,
The database server includes a database storage unit, a schema information storage unit including a table name owned by each user, an export processing unit that receives a request from the user terminal and exports the table data of the database storage unit to an external file, and a user terminal And import processing means for importing the table data exported to the external file upon request to the database storage unit,
The user terminal includes an export setting file storage unit, an import setting file storage unit, a list file storage unit, an export request processing unit, and an import request processing unit,
The export setting file includes a user name, an output destination path of table data, and a table name acquisition method to be exported,
The export request processing means connects to the database server with the user name, and sends a request to the database server together with an export setting file and a list file when the target table name acquisition method is a list use,
The user terminal stores the received management file in the corresponding storage unit,
Depending on whether the target table acquisition method of the received export setting file is list use or manual selection, the export processing means uses the table specified by the list or the table name held by the corresponding user of the schema information as the export request processing means. For the table selected by replying and selecting it, the table data in the database storage unit is output to the external file specified by the output destination path of the received configuration file, and the table name and output year of the output table data Create a management file containing the date and date, send it to the user terminal,
The import setting file includes a user name, a table data input source path, and a table name acquisition method to be imported.
The import request processing means acquires the table name selected from the table name of the management file if the target table acquisition method of the import setting file is manual selection, connects to the database server with the user name, Send a request to the database server with the list file or the obtained table name,
The import processing means, depending on whether the target table name acquisition method of the received setting file is a list use or manual selection, the table name specified by the received list or the table specified by the received table name, respectively. Data is stored in a database storage unit from a file in an external storage device specified by an input source path, and the target table name is added to the table name information held by the user in the schema information storage unit system. A database system in which a database server and a user terminal that accesses the database server are network-connected,
The database server includes a database storage unit, a schema information storage unit including a table name owned by each user, an export processing unit that receives a request from the user terminal and exports the table data of the database storage unit to an external file, and a user terminal Including an import processing means for receiving the request to import the table data of the external file into the database storage unit,
The user terminal includes an export setting file storage unit, an import setting file storage unit, a list file storage unit, an export request processing unit, and an import request processing unit.
The export setting file includes a user name, an output destination path of table data, and a table name acquisition method to be exported,
The export request processing means connects to the database server with the user name, and sends a request to the database server together with an export setting file and a list file when the target table name acquisition method is a list use,
The user terminal stores the received management file in the corresponding storage unit,
Depending on whether the target table acquisition method of the received export setting file is list use or manual selection, the export processing means uses the table specified by the list or the table name held by the corresponding user of the schema information as the export request processing means. For the table selected by replying and selecting it, the table data in the database storage unit is output to the external file specified by the output destination path of the received configuration file, and the table name and output year of the output table data Create a management file containing the date and date, send it to the user terminal,
A user name, table data input source path, import target table name acquisition method, processing target user name designation method, and date information when this is a date addition type user name are added to the import setting file. Including format specification,
The import request processing means acquires the table name selected from the table name of the management file if the target table name acquisition method of the setting file is manual selection, and the processing target user name specification method is not a date addition type Connect to the database server with the user name of the setting file, and if it is a date addition type, request to connect to the database server with the user name of the setting file user name added with the date information of the table data to be imported according to the above format If the user name is not registered, request registration of the user name, connect to the database server, and send the request to the database server with the import setting file and the list file or the acquired table name And
In response to the user name registration request, the import processing unit secures an area corresponding to the user name in the database storage unit, and depending on whether the target table name acquisition method of the received setting file is list use or manual selection The table name specified in the received list or the table name of the external storage device file specified by the input source path for the received table name is stored in the user name corresponding area of the database storage unit, and the schema A database system characterized by writing a target table name as table name information associated with a user name in an information storage unit. A database storage unit, a schema information storage unit including a table name possessed by each user, an export processing means that receives a request from the terminal and exports the table data of the database storage unit to an external file, and a table of the external file that receives a request from the terminal A database server including import processing means for importing data into a database storage unit,
The export processing means returns the table specified by the list or the table name held by the corresponding user of the schema information to the terminal depending on whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection For the table selected from this, the table data in the database storage unit is output to the external file specified by the output destination path of the received configuration file, and the table name of the output table data and the output date Create a management file containing the date and date, send it to your device,
The import processing means inputs the table name specified in the received list or the received table name, depending on whether the target table name acquisition method of the setting file received from the terminal is list use or manual selection A database server characterized in that the table data of the file in the external storage device specified by the original path is stored in the database storage unit, and the target table name is added to the table name information held by the user in the schema information storage unit . A database storage unit, a schema information storage unit including a table name possessed by each user, an export processing means that receives a request from the terminal and exports the table data of the database storage unit to an external file, and a table of the external file that receives a request from the terminal Including import processing means for importing data into the database storage,
The export processing means returns the table specified by the list or the table name held by the corresponding user of the schema information to the terminal depending on whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection For the table selected from this, the table data in the database storage unit is output to the external file specified by the output destination path of the received configuration file, and the table name of the output table data and the output date Create a management file containing the date and date, send it to your device,
In response to a request for registration of a new date addition type user name from the terminal, the import processing means secures an area corresponding to the user name in the database storage unit, and a target table name acquisition method of the setting file received from the terminal Depending on whether the list is used or manually selected, the table name specified in the received list or the table name of the file in the external storage device specified by the input source path for the received table name is stored in the database storage unit. A database server characterized in that the target table name is written in the schema name storage area as table name information stored in association with the user name. A terminal that accesses a database server through a network,
Including an export setting file storage unit, an import setting file storage unit, a list file storage unit, an export request processing unit, and an import request processing unit,
The export setting file includes a user name, an output destination path of table data, and a table name acquisition method to be exported,
The export request processing means connects to the database server with the user name, sends an export processing request to the database server together with an export setting file and a list file when the target table name acquisition method is list use, Store the management file received from the server in the corresponding storage unit,
The import setting file includes a user name, a table data input source path, and a table name acquisition method to be imported.
The import request processing means acquires the table name selected from the table name of the management file if the target table acquisition method of the import setting file is manual selection, connects to the database server with the user name, A terminal characterized by sending an import processing request to a database server together with a list file or the acquired table name. A terminal that accesses a database server through a network,
Including an export setting file storage unit, an import setting file storage unit, a list file storage unit, an export request processing unit, and an import request processing unit,
The export setting file includes a user name, an output destination path of table data, and a table name acquisition method to be exported,
The export request processing means connects to the database server with the user name, sends an export processing request to the database server together with an export setting file and a list file when the target table name acquisition method is list use, Store the management file received from the server in the corresponding storage unit,
A user name, table data input source path, import target table name acquisition method, processing target user name designation method, and date information when this is a date addition type user name are added to the import setting file. Including format specification,
The import request processing means acquires the table name selected from the table name of the management file if the target table name acquisition method of the setting file is manual selection, and the processing target user name specification method is not a date addition type Connect to the database server with the user name of the setting file, and if it is a date addition type, request to connect to the database server with the user name of the setting file user name added with the date information of the table data to be imported according to the above format If the user name is not registered, request the registration of the user name, connect to the database server, and request the database server for import processing with the import setting file and the list file or the acquired table name. A terminal characterized by sending a message. The export setting file including the user name, the output path of the table data, and the table name acquisition method to be exported is read from the storage device, connected to the database server with the user name, and the export setting file and the target table name acquisition method are An export request processing procedure for sending an export processing request to a database server with a list file in the case of using a list, and storing a management file received from the database server in a corresponding storage unit;
Import setting file including user name, table data input source path, import target table name acquisition method is read from the storage device, and if this target table acquisition method is manual selection, it is selected from the table name of the management file The computer acquires the table name, connects to the database server with the user name, and sends the import request file to the database server with the import setting file and the list file or the acquired table name. A program to make it run. The export setting file including the user name, the output path of the table data, and the table name acquisition method to be exported is read from the storage device, connected to the database server with the user name, and the export setting file and the target table name acquisition method are An export request processing procedure for sending an export processing request to a database server with a list file in the case of using a list, and storing a management file received from the database server in a corresponding storage unit;
Import setting file including user name, table data input source path, import target table name acquisition method, processing target user name specification method, and format specification to add date information if this is a date addition type user name If the target table name acquisition method is manually selected, the table name selected from the table name of the management file is acquired. If the processing target user name specification method is not the date addition type, the setting file To the database server with the user name, and if it is a date addition type, make a connection request to the database server with the user name with the date and time information of the table data to be imported added to the user name in the configuration file according to the above format, If the user name is not registered, request registration of the user name, connect to the database server, import setting file, list file or Program for executing the import request procedure sends the import process request to the database server with a table name the acquired computer. Depending on whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection, the table specified by the list or the table name held by the corresponding user of the schema information is returned to the terminal and selected from this For a table, output the table data in the database storage unit to an external file specified by the output destination path of the received configuration file, and include the table name of the output table data and the output date and time Create a management file and send it to your device,
Depending on whether the target table name acquisition method of the configuration file received from the terminal is list use or manual selection, the table name specified by the received list or the received table name is targeted and specified by the input source path A program for causing a computer to execute an import processing procedure in which table data of a file in an external storage device is stored in a database storage unit, and a target table name is added to table name information held by a user in a schema information storage unit. Depending on whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection, the table specified by the list or the table name held by the corresponding user of the schema information is returned to the terminal and selected from this For a table, output the table data in the database storage unit to an external file specified by the output destination path of the received configuration file, and include the table name of the output table data and the output date and time Create a management file and send it to your device,
In response to a request for registration of a new date-added user name from the terminal, an area corresponding to the user name is secured in the database storage unit, and the target table name acquisition method of the setting file received from the terminal is a list use or manual Depending on the selection, the table name specified in the received list or the table name of the file in the external storage device specified by the input source path for the received table name is stored in the user name corresponding area of the database storage unit. A program for causing a computer to execute an import processing procedure for storing and writing a target table name as table name information stored in association with a user name in a schema information storage unit. The export setting file including the user name, the output path of the table data, and the table name acquisition method to be exported is read from the storage device, connected to the database server with the user name, and the export setting file and the target table name acquisition method are An export request processing procedure for sending an export processing request to a database server with a list file in the case of using a list, and storing a management file received from the database server in a corresponding storage unit;
Depending on whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection, return the table specified by the list or the table name held by the corresponding user of the schema information to the export request processing procedure. For the selected table, the table data in the database storage unit is output to the external file specified by the output destination path of the received configuration file, the table name of the output table data, and the output date Create a management file that contains and send it to your device,
Import setting file including user name, table data input source path, import target table name acquisition method from storage device, connect to database server with the user name, import setting file and target table name acquisition method thereof Import request processing procedure for sending an import processing request to the database server with the list file when the list is used or the target table name,
Depending on whether the target table name acquisition method of the configuration file received from the terminal is list use or manual selection, the table name specified by the received list or the received table name is targeted and specified by the input source path A database table comprising: table processing for storing file data of an external storage device in the database storage unit; and an import processing procedure for adding the target table name to the table name information held by the user in the schema information storage unit. Data management method. The export setting file including the user name, the output path of the table data, and the table name acquisition method to be exported is read from the storage device, connected to the database server with the user name, and the export setting file and the target table name acquisition method are An export request processing procedure for sending an export processing request to a database server with a list file in the case of using a list, and storing a management file received from the database server in a corresponding storage unit;
Depending on whether the target table acquisition method of the export setting file received from the terminal is list use or manual selection, return the table specified by the list or the table name held by the corresponding user of the schema information to the export request processing procedure. For the selected table, the table data in the database storage unit is output to the external file specified by the output destination path of the received configuration file, the table name of the output table data, and the output date Create a management file that contains and send it to your device,
Import setting file including user name, table data input source path, import target table name acquisition method, processing target user name specification method, and format specification to add date information if this is a date addition type user name If the target table name acquisition method is manually selected, the table name selected from the table name of the management file is acquired. If the processing target user name specification method is not the date addition type, the setting file To the database server with the user name, and if it is a date addition type, make a connection request to the database server with the user name with the date and time information of the table data to be imported added to the user name in the configuration file according to the above format, If the user name is not registered, request registration of the user name, connect to the database server, import setting file, list file or In response to an import request processing procedure for sending an import processing request to the database server together with the acquired table name and a registration request for a new date-added user name from the terminal, the database storage unit supports the user name. Depending on whether the target table name acquisition method of the configuration file received from the terminal is a list use or manual selection, the table name specified by the received list or the received table name as the target, input source Import the table data of the external storage device file specified by the path into the user name correspondence area of the database storage unit and write the target table name as the table name information associated with the user name in the schema information storage unit A database table data management method comprising a processing procedure.

Images