JP2002351710A - Method/device/program for migrating database system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method and program for migrating a database system of excellent general usefulness, extensibility and operability in a database system connected to a network. SOLUTION: In the method for migrating the database system through a data communication middleware, a database migration processing terminal receives database migrating operation by a GUI, conversion to an SQL sentence or the selection of a stored procedure is performed concerning the migrating operation designated by the GUI, and outputs a result to a display device, etc. A method for migrating the database file in the state of being easy visually and being interactive, a terminal and a program for making a computer constituting the terminal perform the processing are provided.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a technology for migrating a database system, and more particularly, to a method, an apparatus, and a program.

[0002]

2. Description of the Related Art Database systems are built on various platforms, and data files may need to be migrated when the systems are integrated or updated. If the compatibility between the database systems is not perfect, only the data files can be migrated as they are, and the data storage definition of the database must be created separately on the migration destination system.

[0003] In particular, when the migration source is a library format file or flat file and the migration destination is a relational database file, various table definitions (key settings, associations, permissions) on the relational database are manually input from specifications and programs. It is necessary to confirm by the above, and it takes a lot of man-hours.

Japanese Patent No. 2783109 discloses a conventional technique for facilitating the transfer of data files between databases. Database access means, storage medium access means, command interpretation means, save (restore) procedure generation means,
The apparatus provided with the control means is connected to the database system of the transfer source, saves the definition information of the transfer source and the data handled by the definition information to a storage medium using a database processing language, A system for saving, restoring, and migrating a database system has been proposed which causes a database system to perform a restoration process using a structured query language.

Japanese Patent Application Laid-Open No. 2000-347907 discloses a technique for managing a record format and a table definition using common record format information for data files and relational database systems having different management formats. A technique for automating the transition between systems by a unified method has been proposed.

However, even when the above-mentioned technology is used, when performing the migration between data files and the relational database system, in order to perform the safe and reliable migration / evacuation work, the person in charge of the system must use the SQ.
L (Structured Query Language)
e, hereinafter referred to as "SQL". ) Is often required. The reason is that in addition to the syntax standardized by JIS, there are cases where SQL-specific statements are implemented for each database system, and that SQL is also used for verification work after database system migration work. Is required.

[0007] In addition, since authority can be given only in SQL command units, improvement in security is desired.

[0008] Furthermore, in today's high-speed network is being developed, the migration of data files between database systems connected by the network requires
It is desired to establish a method that can be performed more easily through a network while maintaining the same reliability as that performed by a conventional storage medium.

[0009]

SUMMARY OF THE INVENTION The present invention has been made in view of the above problems, and has as its object to facilitate the transfer of data files between database systems and to secure security such as authority management. Another object of the present invention is to provide a database system migration method, system, and program which are excellent in terms of aspects.

[0010]

According to a first aspect of the present invention, there is provided a database system migration method described below. That is, in a method of migrating a database file from one database system to another database system via data communication middleware,
(A) a step in which the terminal connects to the one database system to acquire and output database file information stored and managed in the one database system; and (B) the terminal performs processing based on the database file information. Accepting an input of an inquiry condition of a database file to be migrated; and (C) the terminal executes an SQL (Structured Querter) corresponding to the input content.
generating a Structured Query Language (SQL) statement and transmitting the SQL statement to the one database system; and (D) the terminal receives an execution result of the SQL statement as a response to the SQL statement. (E) receiving input of an operation command for a database file to be migrated based on the execution result of the SQL statement; and (F) the terminal comprises: An SQL statement corresponding to the other database system having the definition information of the selected database file connected to the other database system and data corresponding to the other database system based on the inquiry command and the migration command; Creating an SQL statement of the operation command; (G)
Transmitting each of the SQL statements to the other database system; and (H) outputting a processing result transmitted from the other database system as a response to each of the SQL statements. A method for migrating a database system is provided. In this case, the terminal preferably includes a step of receiving and outputting a processing result as a response when the terminal transmits the SQL statement to the other database system.

[0011] Further, the terminal transmits an SQL statement for confirming a result of the migration processing to the other database system, and transmits a response to the SQL statement and a response received from the one database system. It is preferable to include a step of collating with the stored contents and a step of giving a warning to an operator when the collation result indicates an abnormality.

Also, in the present invention, the steps (A) to (H) of the first aspect of the invention are realized by executing a program on a computer constituting a terminal. In the form of a program. A process in which the terminal transmits an SQL sentence for confirming a result of the migration process to the other database system, a content in which a response to the SQL sentence and a response received from the one database system are stored and stored; If the result of the comparison indicates an abnormality,
A program is provided for causing an operator to perform a process of giving a warning.

Further, the present invention can be understood as providing a terminal for carrying out the invention of the first aspect, and is provided as a terminal for migration processing of a database system in the third aspect. . In addition, in addition to the above, the terminal constituting the system is provided with processing means for generating and transmitting an SQL statement for confirming the result of the migration processing to the other database system, and Processing means for comparing the response from the database system with the content stored and stored in the response received from the one database system, and processing means for alerting the operator when the result of the comparison indicates an abnormality Is preferably provided.

Further, in the method, the program, and the terminal for migrating the database system according to the first to third aspects,
An application programming interface (AP) for connecting the terminal to each of the database systems.
I ”) is preferably a predetermined API.

Also, in the method, the program, and the terminal for shifting the database system according to the first to third aspects,
The process in which the terminal generates each of the SQL statements includes that the process is performed by selecting an executable file that has been subjected to authority management processing and stored in advance in the one database system and the other database system. Is preferred.

Also, in the method, the program, and the terminal for migrating the database system according to the first to third aspects,
It is preferable that the terminal can select a previously created save file storing and saving a database file as a migration target.

[0017]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, a first embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a diagram illustrating an example of a system configuration according to an embodiment of the present invention. FIG.
Referring to FIG. 1, the system according to the present embodiment includes a terminal such as a computer having a communication function (hereinafter, referred to as a “database migration processing terminal”) (101 in FIG. 1) that executes a database file operation and a migration. It has a source database system (201 in FIG. 1), a migration destination database system (301 in FIG. 1), and a network (500 in FIG. 1) for communicating and connecting these.

FIG. 2 is a diagram showing an example of the configuration of the database migration processing terminal (101 in FIG. 1) and the source / destination database system (201 in FIG. 1, 301 in FIG. 1) in FIG. Referring to FIG. 2, a database migration processing terminal (101 in FIG. 2) includes a database migration processing unit (FIG. 2).
101a), storage and storage means (101b in FIG. 2),
Control means (101c in FIG. 2) and connection means (12c in FIG. 2)
1), data communication middleware (131 in FIG. 2),
It has input means (141 in FIG. 2), data conversion means (151 in FIG. 2), and output means (161 in FIG. 2).

The source / destination database system (201 in FIG. 2 and 301 in FIG. 2) includes a database (202 in FIG. 2 and 302 in FIG. 2) and a data communication middleware (231 in FIG. 2; 331). A database (202 in FIG. 2) managed by the migration source database system (201 in FIG. 2) stores database files to be migrated.

Next, an embodiment of the method according to the present invention will be described with reference to FIGS. In performing the migration of the database, first, the terminal (101 in FIG. 2) is connected to the network (500 in FIG.
21) via the source database system (2 in FIG. 2).
01), and refers to information such as a list of database files stored in the database (202 in FIG. 2) including the file to be migrated, and outputs it to output means (161 in FIG. 2) such as a display device (step). S001). Subsequently, the terminal (101 in FIG. 2) receives an operation such as designation of a database file to be migrated and an inquiry command from the operator via a GUI or the like (step S00).
2). The terminal (101 in FIG. 2) is connected to a data conversion unit (FIG. 2).
151), the operation content is converted into a structured query language (hereinafter, referred to as “SQL”) statement corresponding to the source database, and the data communication middleware (131 in FIG. 2, 231 in FIG. 2). The SQL statement is transmitted to the migration source database system (201 in FIG. 2) via (step S003). Subsequently, the result of the execution of the SQL statement by the transfer source database system (201 in FIG. 2) on the database (202 in FIG. 2) is returned as a response to the data communication middleware (131 in FIG. 2, FIG.
The terminal (101 in FIG. 2) that has received the content transmitted via the (231) of FIG. 2 transmits the response to the database migration processing unit (10 in FIG. 2) by the data conversion means (151 in FIG. 2).
The data is converted into the format handled in 1a), stored and stored in the storage and storage unit (101b in FIG. 2), and output to the output unit (161 in FIG. 2) such as a display device (step S0).
04). Subsequently, the terminal (101 in FIG. 2) specifies a database file to be migrated via a GUI or the like,
An operation such as an inquiry command or a transfer instruction is received (step S005). Subsequently, the terminal (101 in FIG. 2) uses the data conversion means (151 in FIG. 2) to set the operation content to an SQL statement (Data) corresponding to the data definition corresponding to the migration destination database (301 in FIG. 2). Defin
SQL statement (Data Manipulat) containing the content of the data language
(Ion Language; DML) (step S006). Subsequently, the terminal (101 in FIG. 2) is connected to the data communication middleware (131 in FIG. 2, 231 in FIG. 2).
Via the destination database system (20 in FIG. 2)
1), the respective SQL statements are transmitted (step S)
007). Next, the migration destination database system (Fig. 2
301) stores the SQL statement in a database (30 in FIG. 2).
The terminal (101 in FIG. 2) that has received the content transmitted via the data communication middleware (131 in FIG. 2, 331 in FIG. 2) in response to the result of the execution performed in response to the data conversion means (FIG. 2) 151), the response is converted into a format handled by the database migration processing unit (101a in FIG. 2), and output means such as a display device (16 in FIG. 2).
1) (Step S008).

According to the first embodiment, the GUI technology and the automatic SQL sentence conversion process are linked to each other, so that the processing and the response of each database operation are made interactively via the input / output means. This makes it possible to safely and promptly perform the transition without any skilled person. In the first embodiment, it is one of more desirable embodiments to determine an API to be used in advance and construct and execute a system. In this case, there is no need to develop a new API,
Data conversion can be performed by creating and introducing the database system driver corresponding to a predetermined API. Therefore, even if a database system with a different platform is added to the network, the database system can be immediately added to the database system. Database files can be migrated. In each of the above-described embodiments, the execution file is stored in the transfer source / destination database system (201 in FIG. 2 and 301 in FIG. 2) by performing the authority management process on the database (202 in FIG. 2 and 30 in FIG. 2).
2), and the terminal (101 in FIG. 2)
The process of generating a statement and causing the source / destination database system (201 in FIG. 2 and 301 in FIG. 2) to execute the SQL statement may be replaced with a process in which the executable file is selected and combined with parameters to be executed. This is one of more desirable embodiments. In this case, it is possible to speed up the database operation processing, and it is possible to set the authority management processing finely for each execution file. In each of the above embodiments, the terminal (10
1) is a terminal (1 in FIG. 2) as a database migration target.
One of the more preferable embodiments is to read a file (backup file) in which a database file is stored and stored in a storage medium in advance, for example, to make it a target of database migration processing. In this case, it is possible to perform the migration process to the destination database system using the save file as the source without connecting to the source database system one by one. Further, in each of the above embodiments, the terminal (10 in FIG. 2)
1) transmitting an SQL statement for confirming the result of the migration processing to the migration destination database system, and storing the response to the SQL statement and the content of storing the response received from the one database system; Step of matching, if the result of matching indicates an abnormality,
Adding a step of determining an abnormality and giving a warning to the operator is also one of the more desirable embodiments. In this case, the verification of the result of the migration can be easily and interactively performed.

Next, a second embodiment of the present invention will be described with reference to FIGS. The program according to the second embodiment includes the steps (step S001) to step (step S008) of the terminal (1 in FIG. 2) described in the first embodiment.
The functions and processes can be realized by a program that causes a computer constituting the terminal (101 in FIG. 2) to execute the processing operation of (01). In this case, the present invention can be implemented by loading the program from a storage medium storing the program into the main storage device of each computer and executing the program. According to the second embodiment, the GUI technology and the automatic SQL sentence conversion process are linked to each other, and the processing and response of each database operation are interactively performed via the input / output means. In addition, there is an effect that it is possible to perform the operation safely and promptly even by a non-expert. Further, in the second embodiment, it is one of more desirable embodiments to use a program based on a system in which an API to be used is determined in advance. In this case, a new AP
It is not necessary to develop I, and data conversion is possible by creating and introducing the database system driver corresponding to the prescribed API. Therefore, when a database system with a different platform is added to the network, Even if there is, the database file can be promptly transferred to the database system. In each of the above embodiments, the source / destination database system (201 in FIG. 2 and 30 in FIG. 2)
In 1), the execution file is subjected to authority management processing and stored in a database (202 in FIG. 2 and 302 in FIG. 2).
Each computer constituting the terminal (101 in FIG. 2)
The process of generating a QL statement and causing the source / destination database system (201 in FIG. 2 and 301 in FIG. 2) to execute the SQL statement is replaced with a process in which the execution file is selected and combined with parameters to be executed. A program to be executed is also one of the more desirable embodiments. In this case, the speed of the database operation process can be increased, and the authority management process can be set finely for each execution file. In each of the above-described embodiments, the terminal (101) reads a file (evacuated file) in which a database file is previously stored and saved in a storage medium by the terminal (101 in FIG. 2) as a database migration target, and executes the database migration. Being able to be a target of processing is also one of the more desirable embodiments. In this case, it is possible to perform the migration process to the destination database system using the save file as the source without connecting to the source database system one by one. Further, in each of the above-described embodiments, the terminal (101 in FIG. 2) uses the SQL for confirming the result of the migration process to the migration destination database system.
Transmitting the sentence, collating the response to the SQL statement with the content received and stored from the one database system, and determining that the result is abnormal if the result of the comparison indicates an abnormality, Is also one of the more desirable embodiments. In this case, the verification of the result of the migration can be easily and interactively performed.

Next, a third embodiment of the present invention will be described with reference to FIG. The terminal according to the third embodiment includes connection means (121 in FIG. 2) to the source / destination database system, and middleware (231 in FIG. 2, FIG. 2) provided in the source / destination database system.
331) and middleware for data communication (1 in FIG. 2).
31) and the source / destination database system (FIG. 2)
Output means (161 in FIG. 2) and an output means (161 in FIG. 2) for outputting the status of 201) and a response to the SQL statement from the source / destination database system to inform the operator. Input means (141 in FIG. 2) for receiving an operator's database operation command based on the contents output to the server, an SQL statement containing the data operation command from the operation command, and the definition information of the database file. And generates an SQL statement to
Data conversion means (151 in FIG. 2) for converting the response to the QL sentence into a common format, and storage and storage means (101b in FIG. 2) for storing and storing the response to each of the SQL statements.
And database migration processing means (101a in FIG. 2) for controlling the execution of each means.

Next, the operation of the terminal according to the third embodiment will be described with reference to FIGS. In performing the database migration, first, the terminal (101 in FIG. 2)
Is connected to the source database system (201 in FIG. 2) using the network (500 in FIG. 2) and the connection means (121 in FIG. 2), and is stored in the database (202 in FIG. 2) including the files to be transferred. Output means such as a display device (see FIG. 2)
161) (step S001). continue,
The terminal (101 in FIG. 2) receives an operation such as designation of a database file to be migrated and an inquiry command from the operator via a GUI or the like (step S00).
2). The terminal (101 in FIG. 2) is connected to a data conversion unit (FIG. 2).
151), the operation content is converted into a structured query language (hereinafter, referred to as “SQL”) statement corresponding to the source database, and the data communication middleware (131 in FIG. 2, 231 in FIG. 2). The SQL statement is transmitted to the migration source database system (201 in FIG. 2) via (step S003). Subsequently, the result of the execution of the SQL statement by the transfer source database system (201 in FIG. 2) on the database (202 in FIG. 2) is returned as a response to the data communication middleware (131 in FIG. 2, FIG.
The terminal (101 in FIG. 2) that has received the content transmitted via the (231) of FIG. 2 transmits the response to the database migration processing unit (10 in FIG. 2) by the data conversion means (151 in FIG. 2).
The data is converted into the format handled in 1a), stored and stored in the storage and storage unit (101b in FIG. 2), and output to the output unit (161 in FIG. 2) such as a display device (step S0).
04). Subsequently, the terminal (101 in FIG. 2) specifies a database file to be migrated via a GUI or the like,
An operation such as an inquiry command or a transfer instruction is received (step S005). Subsequently, the terminal (101 in FIG. 2) uses the data conversion means (151 in FIG. 2) to set the operation content to the SQL statement (DDL) that is the content of the data definition corresponding to the migration destination database (301 in FIG. ) And a SQL statement (DML) containing the contents of the data operation (step S006). Subsequently, the terminal (101 in FIG. 2) transmits each of the SQL statements to the migration destination database system (201 in FIG. 2) via the data communication middleware (131 in FIG. 2, 231 in FIG. 2). (Step S00
7). Subsequently, the migration destination database system (3 in FIG. 2)
01) stores the SQL statement in a database (302 in FIG. 2).
The terminal (101 in FIG. 2) receiving the content transmitted via the data communication middleware (131 in FIG. 2 and 331 in FIG. 2) in response to the result of the execution to the data conversion unit (151 in FIG. 2). ), The response is converted into a format handled by the database migration processing unit (101a in FIG. 2), and output means such as a display device (161 in FIG. 2).
(Step S008).

According to the third embodiment, in the terminal (101 in FIG. 2), the GUI technology and the automatic SQL sentence conversion process are linked, and the processing and response of each database operation are interactively performed via the input / output means. With this configuration, the database system can be migrated safely and promptly even by a non-expert. Also,
API used in advance in the third embodiment
It is one of the more desirable embodiments to establish and implement a system by defining the above. In this case, a new AP
It is not necessary to develop I, and data conversion is possible by creating and introducing the database system driver corresponding to the prescribed API. Therefore, when a database system with a different platform is added to the network, Even if there is, the database file can be promptly transferred to the database system. In each of the above embodiments, the source / destination database system (201 in FIG. 2 and 30 in FIG. 2)
In 1), the execution file is subjected to authority management processing and stored in a database (202 in FIG. 2 and 302 in FIG. 2).
The terminal (101 in FIG. 2) generates each SQL statement,
The statement is transferred to the source / destination database system (20 in FIG. 2).
It is also one of the more preferable embodiments that the processing to be executed by (1) 301 in FIG. 2 can be replaced with the processing to be executed by selecting the execution file and combining it with the parameter. In this case, it is possible to speed up the database operation processing, and it is possible to set the authority management processing finely for each execution file. In each of the above-described embodiments, the terminal (101) reads a file (evacuated file) in which a database file is previously stored and saved in a storage medium by the terminal (101 in FIG. 2) as a database migration target, and executes the database migration. Being able to be a target of processing is also one of the more desirable embodiments. In this case, it is possible to perform the migration process to the destination database system using the save file as the source without connecting to the source database system one by one. Further, in each of the above embodiments, the terminal (101 in FIG. 2) transmits an SQL statement for confirming the result of the migration process to the migration destination database system, It is also preferable to add a step of comparing the response received from the database system with the stored contents, and a step of determining that the response is abnormal and warning the operator if the result of the comparison indicates an abnormality. It is one of the forms. In this case, the reliability of the database migration process is dramatically improved, and the work of confirming the result of the migration process can be greatly saved. The reason is that the verification work of the result of the migration can be easily and interactively performed.

[0026]

Next, an embodiment of the present invention will be described with reference to FIGS. 4, 5 and 6. FIG. First, as shown in FIG.
LAN (Local Area Network) 50
0, the terminal 101 and the source database system 2
01 and the migration destination database system 301 are mutually connected. Referring to FIG. 4, the terminal 101 includes a database migration processing unit 101a and a storage / save unit 101b.
, Control means 101c, database system 20
1, 301, data input means 141, data conversion means 151, output means 161,
This is a computer that includes the auxiliary storage device 171 and is configured as a terminal that performs database migration. The source / destination database systems 201 and 301 include databases 202 and 302 and data communication middleware 231 and 331, respectively. "SQL * Net" (trademark, Oracle) is used as the middleware 231 and 331 provided in the terminal 101 and the source / destination database system, and is used between the terminal 101 and the source / destination database systems 201 and 301. Data communication is possible.

In the terminal 101 according to the present embodiment, as a database migration processing unit 101a, a computer constituting the terminal 101 is provided with "MS-ACCESS" (a trademark of Microsoft Corporation) and "MS-ACCESS" (a trademark of Microsoft Corporation, trademark). ) To introduce the service program and perform its function. The input means 141 includes a keyboard and a mouse, and the output means 161 includes a display device. Also, the data conversion unit 151 uses an ODBC (Open DataBase Conn) as an API.
activity), the ODBC manager 1 as a means for selecting and managing the ODBC driver
51a and each ODB corresponding to each database system
C drivers (151b, 151b ').

Furthermore, the database 202 of the source database system and the destination database system 201
In addition, an executable file (hereinafter referred to as a stored procedure) in which authority management information and processing contents are binarized in advance is stored in a database. Stored procedures are CREATE VIEW, CREATE IN
A series of processing procedures using an SQL syntax such as DEX are binarized, and the terminal 101 is configured to be able to read and execute an authorized stored procedure.

Next, referring to the flowchart of FIG.
The operation of each component in one embodiment of the present invention will be described. In the terminal 101, as preparation for database migration, “MS-ACCESS” (Microsoft Corporation, trademark) for performing processing as the database migration processing unit 101a, the service program, and the middleware 131 and 231 are activated, and the database migration is performed. The environment information such as the operator name, network address, and network protocol of the processing terminal 101 is acquired, and connection to the migration source database system 201 is started.
(Step S1001). Subsequently, the terminal 101 selects a stored procedure for making a reference request of the database file list, displays the database file list on the output unit 161 as the database information of the database 202 managed by the source database system 201, and displays the screen on the screen. , "MS-A" which is a component of the database migration processing unit 101a.
Using the query function of "CCESS" (a trademark of Microsoft Corporation), the designation of the source database file 202 and the input of an inquiry command are accepted (step S10).
02). Here, the operator selects a table to be migrated from the table list on the display, further selects a field to be migrated, and specifies necessary records by setting conditions as necessary. Subsequently, the terminal 101
The authority content of the operator is determined by the service program which is a component of the database migration processing unit 101a (step S1003). If the input content is out of the range of the authority of the operator, the operator is notified that the operation is out of the authority, and the process is interrupted. If the authority of the operator is valid, the terminal 101 subsequently converts the input content into an SQL statement corresponding to the source database system by the data conversion unit 151 (more specifically,
Driver 151 corresponding to source database system
b performs the conversion), and sends the SQL statement via the middleware 131, 231 to perform an inquiry process (step S1004). Subsequently, the transfer source database system 201 that has received the inquiry process searches the database 202 and returns the result to the terminal 101 via the middleware 131 and 231 as a response.
(Step S1005). The terminal 101 converts the response received by the data conversion unit 151 into a format that can be read by the “MS-ACCESS” (trademark of Microsoft Corporation) (more specifically, a driver corresponding to the migration source database system). 1
51b performs the conversion), and stores and saves the contents of the response as a save file in the auxiliary storage device 171 (step S).
1006). The save file holds data file definition information. Subsequently, the terminal 101
Displays on the output means at least database definition information (for example, table name, field name, data type, etc.) of the response content, presents it to the operator, and displays the "MS-A
Using a query function of "CCESS" (trademark of Microsoft Corporation), a database file to be migrated is specified and a migration command is input (step S100).
7). Here, the operator selects an item to be transferred with reference to the definition information on the display, specifies a necessary record by setting conditions as necessary, and issues a transfer command. Subsequently, the terminal 101 determines the authority content of the operator using the service program which is a component of the database migration processing unit 101a (step S1).
008). If the input content is out of the range of the authority of the operator, the operator is notified that the operation is out of the authority, and the process is interrupted. If the operator's authority is legitimate,
Subsequently, the terminal 101 uses the data conversion means 151
The input contents are converted into an SQL statement including definition information of the database file corresponding to the destination database system 301 and operation information of the database file (more specifically, the driver 151b ′ corresponding to the source database system performs the conversion). Further, the middleware 331 of the destination database system 301 is started and connected to the destination database system 301, and
The QL sentence is transmitted to start the database migration processing (step S1009). Migration destination database system 30
1 stores the received SQL statements in the database 302
, The data definition information is created first, and then the database file stored in the terminal 101 is migrated to the migration destination database system 301 (step S1010). Further, the terminal 101 transmits the “M
Using the query function of “S-ACCESS” (trademark of Microsoft Corporation), the definition information of the database file on the auxiliary storage device 171 and the migration destination database system 3
01 is compared with the database file migrated in the database 302 (step S1011). As a result of the collation, when data violating the constraint of the definition information exists in the database 302 of the migration destination database system 301, the terminal 101 displays an error notification (step S1012).

Next, with reference to FIG. 6, a description will be given of an input acceptance by the GUI provided by the database migration processing unit 101a and a conversion process to an SQL sentence in the embodiment.
FIG. 6 is a diagram illustrating a state in which the terminal 101 displays the definition information of the database file to be migrated of the migration source database system 201 on the output unit 161 and subsequently connects to the migration destination database system 301. is there. In the window showing the migration source database system, a part of the database file selected as the migration target and a window showing the migration destination database system are displayed on one screen. The operator selects items and conditions to be transferred using input devices such as a mouse,
By executing the copy instruction, the data conversion unit 151 creates an SQL statement. For example, by selecting an arbitrary table from the table list in the source database column on the screen and moving it to the destination database column, CREATE T
An ABLE statement will be created. In addition, CREA
When the TE TABLE statement is transmitted and executed in the migration destination database system 301, the result is reflected by being displayed in the migration destination database column. By adopting such a configuration, a system is provided in which the database migration work can be easily understood visually and the work can be carried out interactively. As described above, a database migration processing method that can prevent data destruction due to an operation error by using a visual user interface of database software and a simple query function is provided. In addition, when general-purpose database software that implements a GUI is adopted as in the above-described embodiment, it is sufficient to develop only a service program that adds functions necessary for implementing the present invention. During the period, a program that causes the computer to perform the processing as the database migration processing terminal 101 becomes available.

In the above embodiment, the network is LA
Although an example of N connection has been described, the network is not limited to a LAN as long as it can realize the above-described DB connection function, and can be applied to any network such as a dedicated line or a public network. In the above embodiment, one database system is shown as the migration destination database system. However, it is not always necessary that the migration destination is one database system, and the migration work to two or more database systems can be performed in parallel. It is also possible to do.

In the above embodiment, the database migration processing unit 101a employs a configuration including "MS-ACCESS" (a trademark of Microsoft Corporation) and the service program. However, the database migration processing unit 101a includes other database software and a service program. It can also be realized by creating new software / hardware.

Further, in the above embodiment, the data conversion means 151 uses the ODBC (Open Da
taBase Connectivity), but other APIs may be used, or a configuration using a driver that can perform a processing function as data conversion means of the present invention may be used.

In the above embodiment, the terminal 101 and the data communication middleware 131, 231, 331 provided in the source / destination database system are as follows:
"SQL * Net" (trademark, Oracle) was used,
Other data communication middleware may be used.

In the above-described embodiment, an example is described in which the drivers 151b and 151b 'are used assuming that the specifications of the source / destination database systems are different. However, the specifications of the source / destination database systems are the same. In this case, one driver corresponding to the source / destination database system is sufficient. Furthermore, in order to perform a migration operation using another database system as a migration source / destination, a driver 151b ″ corresponding to the database system is introduced, and the driver manager 1
What is necessary is just to make 51a recognize.

[0036]

According to the present invention, there is provided a database transfer processing method, apparatus, and program excellent in operability, which do not depend on the proficiency of a terminal operator. In addition, it is possible to more easily confirm the result of the database migration process. The reason is that the GUI accepts the migration operation, converts the input content of the GUI into an SQL sentence,
The point is that a method of visually and interactively performing database migration processing and migration result confirmation processing is employed.

Further, according to the present invention, fine authority management becomes possible in the database system migration work. The reason for this is that an executable file (stored procedure) that has been compiled in advance and the processing procedure is used is used, and furthermore, the configuration is made such that the authority confirmation processing can be performed in interactive processing.

According to the present invention, there is provided a method for migrating a database system which is excellent in scalability and versatility. The reason is that the database migration system according to the present invention can be implemented as long as SQL transparency is secured for connection paths such as networks between each database system and terminals. Furthermore, ODBC, JDB as API
When a standardization-oriented API such as C (trademark) is defined as a standard API of the database migration system according to the present invention, a driver corresponding to a desired database system is obtained, so that the present invention can be easily applied. Has the advantage that it becomes possible.

[Brief description of the drawings]

FIG. 1 is a diagram showing an outline of a system in a database system migration method according to an embodiment of the present invention.

FIG. 2 is a block diagram illustrating a configuration of a terminal and a database system according to an embodiment of the present invention.

FIG. 3 is a flowchart illustrating a flow of a database migration process according to an embodiment of the present invention.

FIG. 4 is a block diagram illustrating a configuration of a terminal and a database system according to another embodiment of the present invention.

FIG. 5 is a flowchart showing a flow of a database migration process according to another embodiment of the present invention.

FIG. 6 is an image diagram of a GUI operation screen displayed on a terminal according to another embodiment of the present invention.

[Explanation of symbols]

101 terminal 121 connection means 131, 231, 331 data communication middleware 141 input means 151 data conversion means 161 output means 171 auxiliary storage device 201, 301 source database system, destination database system 202, 302 source database, destination database 500 network

Claims (15)

[Claims] 1. A method for migrating a database file from one database system to another database system via a data communication middleware, wherein: (A) a terminal for performing a database migration process connects to the one database system and (B) obtaining and outputting database file information stored and managed by the database system; and (B) receiving input of a query condition of a database file to be migrated based on the database file information. C) The terminal sends an SQL (St.
ructured Query Language)
Generating a sentence and transmitting the SQL sentence to the one database system; and (D) the terminal responds to the SQL sentence by:
Receiving and outputting the execution result of the SQL statement and storing and storing the result; and (E) receiving, based on the execution result of the SQL statement, an input of an operation command for a database file to be migrated. (F) the terminal is connected to the other database system, and based on the input content, an SQL statement corresponding to the other database system containing the definition information of the database file to be the input content. SQ of a data operation instruction corresponding to the other database system
Creating an L statement; (G) transmitting each of the SQL statements to the other database system; and (H) transmitting a processing result transmitted from the other database system as a response to each of the SQL statements. Outputting, and a method for migrating a database system. 2. The method of migrating a database system according to claim 1, wherein the terminal is connected to each of the database systems by an application programming interface (AP).
I ") is a predetermined API, a method for migrating a database system. 3. The method for migrating a database system according to claim 1, wherein the process of generating each of the SQL statements by the terminal is stored and saved in the one database system and the other database system in advance. A database system migration method, which is performed by selecting an executable file for which authority management processing has been performed. 4. The method for migrating a database system according to claim 1, wherein the terminal is capable of selecting a previously created save file storing and saving a database file as a migration target. A method for migrating a database system, characterized in that: 5. The database system migration method according to claim 1, wherein the terminal transmits an SQL statement for confirming a result of the migration process to the another database system. Collating the response to the SQL statement with the content stored and stored in the response received from the one database system; and warning the operator if the collation result indicates an abnormality. A method for migrating a database system, comprising: 6. A computer constituting a terminal for performing a process of transferring a database file via a data communication middleware, comprising: (A) connecting to one database system and storing database file information stored and managed by the one database system; (B) a process of receiving an input of a query condition of a database file to be migrated based on the database file information; and (C) an SQL (Structur) corresponding to the query condition.
ed Query Language: a process for generating a sentence and transmitting the SQL sentence to the one database system; and (D) receiving and outputting an execution result of the SQL sentence as a response to the SQL sentence. And (E) receiving an input of an operation command for a database file to be migrated based on the execution result of the SQL statement, and (F) connecting to another database system and selecting the selected database. (G) creating a SQL statement corresponding to the other database system containing the file definition information and a SQL statement of a data operation instruction corresponding to the other database system based on the inquiry command and the migration command; And (H) transmitting each of the SQL statements to the other database system. Outputting a processing result transmitted from the other database system as a response to each SQL statement. 7. The database system migration processing program according to claim 6, wherein the terminal is connected to each of the database systems by an application programming interface (AP).
I ") is a database system migration processing program, which is a predetermined API. 8. The database system migration processing program according to claim 6, wherein said terminal is connected to each of said S
The process of generating a QL sentence includes performing the process by selecting an executable file that has been subjected to authority management processing and stored in advance in the one database system and the other database system. Database system migration processing program. 9. The database system migration processing program according to any one of claims 6 to 8, wherein the migration target presented by the terminal by the program is a previously created evacuation file storing and saving a database file. A database system migration processing program, comprising: 10. The database system migration processing program according to claim 6, wherein the terminal transmits an SQL statement for confirming a result of the migration process to the another database system. Processing, collating the response to the SQL sentence with the content stored and stored in the response received from the one database system, and, if the collation result indicates an abnormality, warning the operator. , A database system migration processing program. 11. A terminal for performing a process of migrating a database file from one database system to another database system, the terminal comprising: (A) connection means for each database system; and (B) each database system. And (C) the state of each database system and the SQL (Structured Query) from each database system.
(D. Language; structured query language) output means for outputting a response to the sentence to inform the operator; (D) input means for receiving an operator's database operation instruction based on the content output to the output means; (E) S containing a data operation instruction from the operation instruction
A data conversion means for generating a SQL sentence containing the definition information of the QL sentence and the database file, and converting the response to the SQL sentence into a common format; and (F) storing the response to the SQL sentence. A terminal, comprising: a storage unit; and (G) a database migration processing unit that controls execution of the units. 12. The terminal according to claim 11, wherein said terminal is connected to each of said database systems by an application programming interface (AP).
I ") is a predetermined API. 13. The terminal according to claim 11, wherein the terminal is stored in advance in the one database system and the other database system as a process of generating the SQL statements from the operation command. And selecting and executing an executable file for which the authority management processing has been performed. 14. The terminal according to claim 11, wherein the database migration processing means enables an operator to select a previously created evacuation file in which a database file is stored and saved as an operation target. Terminal. 15. The terminal according to claim 11, wherein said database migration processing unit transmits an SQL statement for confirming a result of the migration process to said another database system. And the SQ
A function of collating the response to the L sentence with the content stored and stored in the response transmitted from the one database system, and a function of giving a warning to an operator when the result of the collation indicates an abnormality, A terminal characterized by the following.