KR20030014011A - Method and system for automatic combining a different kind of database - Google Patents

Abstract

PURPOSE: A system for automatically merging different kind of databases and a method thereof are provided to shorten an analyzing process and automatically analyze/standardize/merge data by minimizing a setting item of a user and suggesting the optimum method such as data filtering, variable reduction, and merging to the user when data are loaded and extracted from a database among various databases in remote places. CONSTITUTION: A data merging program is executed(S2). An interface for connecting a remote database system is executed(S8). A URL, an ID, and a password of a targeted database are inputted(S10). The targeted database is connected(S12). A table list of the targeted database is output on a screen(S14). A table to be copied out of the output table list is selected(S18). A local database system, which is an object to be copied, is connected(S20). The selected table is copied from the targeted database to the local database(S22).

Description

Heterogeneous database automatic merging system and its method {Method and system for automatic combining a different kind of database}

The present invention relates to a database merging system and method thereof, and more particularly, to copy a table between different databases that are remotely separated by a user's selection, and to collectively arrange similar data of the copied table. The present invention relates to a heterogeneous database automatic merging system and a method for automatically merging desired tables.

Accumulating profile information, purchasing and marketing information of target customers is very important for corporate management decision making and marketing activities. Failure to update target records on time or to maintain accuracy is not only a waste of information, but also a tremendous amount of misinformation while using this data for marketing in the future. Because of the loss, the importance of maintaining the accumulated data is emphasized.

To this end, it is necessary to extract customer data accumulated in heterogeneous databases, merge and standardize them into one database, remove inaccurate or duplicate data, and update the latest information on existing accumulated customer information from time to time. .

1 is a diagram illustrating a system in which a user interacts with a commercial data analysis provider in accordance with the prior art.

As shown, the user uses the client computer 2 to operate with the data analysis system 8 to obtain data and pay a predetermined price for the data obtained.

The data analysis system has both a data analysis algorithm 4 and a database 6 to be analyzed. The client computer 2 and the data analysis system 8 may be implemented as a client-server system in which a user and a data analysis provider interact with each other via a computer communication network (Internet or intranet). Meanwhile, the data analysis algorithm 4 and the database 6 may be developed by different subjects.

Existing data analysis performed to derive useful information for decision making usually involves the following process.

First, the process of extracting raw data (data before processing or aggregation) that is the target of data analysis from a database or loading a file stored in the form of text or Excel from an analysis system Second, in order to pre-arrange data prior to full-scale data analysis, the process of integrating duplicate data into one and converting the data into a format of a desired format. Third, the code value of the data is numerically meaningful. (4) the process of adding explanations to each data code value for presentation, the process of selecting and applying algorithms appropriate for the data type and analysis purpose, and (5) evaluating the results of the analysis performed and changing or changing the detailed criteria as necessary. Reanalyze the data by applying the algorithm. Sixth, the final result according to the analysis purpose. It consists of interpreting and reporting.

Typically, data analysis methods used in the field of marketing include the following.

First, frequency / crosstabulation / descriptive statistics for estimating the aggregation and composition ratio of the data, calculating the mean and standard deviation of the measured values, the range of the measured values, performing cross-aggregation between data items, or testing the significance of the crossover. There is an analysis,

Second, the correlation analysis using the correlation coefficient and covariance

Third, linear regression analysis (logic logistic regression), which defines the dependencies between the measures, tests the degree of dependence, selects influential variables for the objective variable, and tests the degree of its influence.

Fourth, discriminant analysis to determine the target value in the form of category, and select the variable influential to the target value,

Fifth, grouping data with similar characteristics into clusters, classifying them into non-hierarchical clusters and hierarchical clusters according to the clustering method, and using this classification for cluster segmentation and similar customer identification.

Sixth, a method of reducing the number of measurement variables by combining variables with high similarity and excluding variables with low similarity, which is mainly used with regression analysis for importance evaluation and satisfaction evaluation of respondents,

Seventh, as a technique for calculating the probability of a certain event occurring at the same time, the correlation analysis used to calculate the evidence probability, the confidence probability, the graphical probability, etc.

Eighth, the self-learning model through error developed in the field of machine learning, there are many different neural network models, but in the marketing field, multilayer artificial perception theory and circular reference function are used. There is a neural network analysis which is mainly used for forecasting and purchasing possibility.

There are over 100 products on the market under the name of data analytics, especially the Data Mining Tool, and prices vary widely. These solutions vary slightly from one type to the other, but are equipped with most of the aforementioned statistical analysis techniques and are typically designed to handle very large data sets.

In addition, these data mining tools support the ability to connect to databases, deliver analysis results, filter and data transformation functions, and macro functions, and provide the benefits of data analysis by continuously updating and adding their own algorithms. I put it.

However, the existing solutions described above present many problems. First, since data analysis itself is based on statistics, it is difficult for general marketers or analysts without a statistical background to access, so the help of experts or external consultants is absolutely necessary to analyze and interpret the data. In other words, there is a problem in that it is difficult for the user to proceed with the data state and analysis process without prior knowledge since the user guide is not provided in terms of interface.

Secondly, the user must interpret the analysis process and the results of the analysis and apply it to his own problems, and it is not easy to select an analysis model or algorithm suitable for understanding the user's business issues and the issues. It requires a lot of trial and error for optimization.

Third, conventional data mining tools are very large and therefore expensive, costing only billions of dollars. In addition to the purchase price of data mining tools, additional consulting costs are required, and engineers and consultants to build the tools There was a problem of being put in and receiving their support for a considerable period of time.

Fourth, the process of connecting and loading the database or general data files and loading the data is cumbersome and difficult for analysts without computer expertise. The problem is that the quality of data analysis cannot be guaranteed because it must be performed in combination with the complex functions required.

The present invention has been made to solve the above problems, between different databases that are remotely spaced, to minimize the user's setting items during the data loading and extraction process from the database, data filtering and variables to the user The purpose is to provide a heterogeneous database automatic merging system and method, which can shorten the analysis process by suggesting optimal measures such as reduction and merging, and to automatically analyze, cleanse, standardize, organize, and merge data. There is this.

According to an object of the present invention, a user computer connected to remote database systems via the Internet and executing a table copy, similar data standardization processing, and table merging between remote database systems through a database merging program is provided. A method for automatically merging heterogeneous databases, the method comprising: executing an interface for connecting a remote database system, connecting to a target database system as a source and a local database system as a target, of the target database Copying a table to a local database, executing a user interface for processing similar data standardization, processing the standardization of similar data by collectively arranging the tables of the copied local database, and using a table for merging tables. Executing a user interface, selecting a table and a field to be merged in the local database, and merging the fields of the selected table to create a new table. This is provided.

According to another object of the present invention, in a heterogeneous database automatic merging system in which various heterogeneous database systems are interconnected through the Internet, the overall operation is controlled as hardware that is the basis of the heterogeneous database automatic merging system. Platform, based on the Java language, a Java Virtual Machine that executes interfaces using classes, a plurality of Java Database Connectivity drivers for connecting to the various heterogeneous database systems, and heterogeneous. A database merging program for automatically merging databases, input means for inputting data, screen output means for screen output of data, temporarily storing data input through the input means or storing data transmitted and received Data for A storage unit, a local database for merging and storing data copied or organized from remote database systems by the database merging program, and including an application interface (API) of a program created at the request of a user, The platform is connected to the heterogeneous database system to copy a table, standardizes the copied table contents, and controls the generation of a new table by merging the fields of the table selected by the user. A database automatic merging system is provided.

1 illustrates a prior art system in which a user interacts with a commercial data analysis provider;

2 is a block diagram illustrating a heterogeneous database automatic merging system according to an embodiment of the present invention;

3 is a view schematically showing the internal configuration of the user computer 12 of FIG.

4 is a flowchart illustrating a process of selecting and copying a table from a remote database system;

5 is a view showing the first screen provided when the database merge program is executed;

6 is a view showing an interface and a login screen for connecting to a remote database system;

7 illustrates program codes of a user interface for connecting a database;

8 is a screen showing the contents of a table in a remote database;

9 illustrates program code of a user interface for copying a database;

10 is a diagram showing a program code of a meta data processing class for copying a table;

11 is a diagram showing a program code of a field type processing class of a new table generated when a table is copied;

12 is a diagram showing a program code and a diagram of a class for copying a table;

13 is a screen showing login to a local database and a table copy;

14 is a flowchart showing similar data normalization processing;

15 is a view showing a screen output showing the contents of the selected table;

16 is a diagram showing a program code of a user interface for similar data normalization processing;

17 is a diagram showing a screen for inputting data for standardization processing;

18 is a diagram showing a program code and a diagram of a class for standardizing similar data;

19 is a diagram showing a screen showing the contents of a table arranged collectively after similar data normalization processing;

20 is a view showing an interface screen for selecting a table to merge;

21 is a view showing a screen for inputting a name and primary key of a table to be merged;

22 is a screen illustrating program code of a user interface for merging a table;

23 is a diagram showing a program code and a diagram of a table merge processing class;

24 is a diagram illustrating a screen showing merged results of a table.

♣ Explanation of symbols for main part of drawing ♣

2: client 4: data analysis algorithm

6: database 8: data analysis provider

10 Internet 12 User Computer

14: Oracle Database 16: SQL Server

18: Informix database 122: Java virtual machine

124 ~ 128: JDBC driver 130: API

132 platform: a database merge program

135: data storage unit 136: local database

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

2 is a block diagram illustrating a heterogeneous database automatic merging system according to an exemplary embodiment of the present invention.

In the present invention, in order to provide flexibility that can operate regardless of the type of platform used by the user, a Java virtual machine is adopted as an execution basis. In addition, to overcome the heterogeneity between the Database Management System (DBMS), a Java Database Connector (JDBC) technology based on the Java language is used. Used.

As shown in FIG. 2, the heterogeneous database automatic merging system according to the present invention includes a plurality of user computers 12 in the Internet 10, which is a network for transmitting and receiving data through communication between computers scattered in remote locations. Heterogeneous database systems 14 to 18 are connected, and the user computer 12 inputs a Uniform Resource Locator (URL) and user login account information to provide various types of DBMSs distributed on the Internet 10. Easily linked, the data in the tables of each database system is sorted by field and batch-normalized similar data.

FIG. 3 is a block diagram showing a function performed by the user computer 12 shown in FIG. 2 to perform heterogeneous database automatic merging.

In order to provide flexibility to operate with any platform, the Java virtual machine 122 is installed on the user computer 12, and JDBC drivers 124 to 128 for connecting to various heterogeneous database systems are provided. Have.

In FIG. 3, reference numeral 130 denotes a program made at the request of a user, and is an application programming interface (API), and 132 is a platform which is hardware (CPU) or operating system software (OS) on which a computer system is based. .

The user computer 12 is connected to each target database through the JDBC drivers 124 to 128. The main classes of JDBC supporting database application development are shown in Table 1 below.

Class name main function Driver Java components provided by the appropriate DBMS vendor for connecting to the DBMS. Connection Support connection, session maintenance and transaction management with DBMS Statement Provide an interface for SQL processing PreparedStatement Precompiled SQL Processing Callablestatement Provide an interface to handle a set of stored procedures ResultSet Interface representing the result of an SQL query ResultSetMetaData Provide column information of ResultSet DatabaseMetaData Provide meta information about the entire database

In FIG. 3, reference numeral 134 denotes a database merging program as a database cleanup tool for executing heterogeneous database automatic merging according to the present invention, and reference numeral 135 temporarily stores data processed by the user computer 12, or A data storage unit for storing data transmitted and received, reference numeral 136 denotes data to be shared by other systems by copying data from remote database systems or merging data using the database merging program 134. Local database to store.

In addition, although not shown in FIG. 3, the user computer 12 may further include a keyboard or mouse used when a user inputs or selects data, and a monitor for screen output.

Next, a heterogeneous database automatic merging method will be described with reference to the flowcharts shown in FIGS. 4 and 14.

4 is a flowchart illustrating a process of selecting and copying a table from a remote database system.

First, the user computer 12 instructs the user to execute the database merge program 134 stored in the form of a program file (step S2).

When a user inputs an execution command of the database merging program 134, the platform 132 of the user computer 12 executes the database merging program to provide a first screen as shown in FIG. 5 (step S4). ).

In the first screen shown in Fig. 5, each database URL list (upper left corner of the screen) to connect a remote database, a table list of a selected database (left side of the screen), record status of each field (upper right corner of the screen) ), Input of data to be arranged and a target input window (lower right of the screen) are displayed on the screen.

In the state where the first screen is being provided, the platform 132 determines whether the user inputs a command regarding a remote database connection (step S6).

In the first screen, when a user selects a menu for connecting to a remote database system through a file menu, when a command for connecting to a remote database is input, the platform 132 performs a database connection as shown in FIG. 7. By executing the user interface for providing a database driver to be connected to the target database system and a screen for inputting the URL of the database system (step S8).

The user interface for database connection shown in FIG. 7 includes the "JPanel" class, the "JButton" class, the "JTextField" class, the "JLabel" class, the "ConnectDlg" class inheriting the "JDialog" class that creates a dialog window. It shows that it works in conjunction with the "XYLayout" class and the "DataBase" classes.

In FIG. 7, the "ConnectDlg" class is a class that creates a dialog window for connecting to a database, and is a class defined by inheriting the "JDialog" class.

The "JPanel" class is a class for placing a component such as a button, a radio button, a check box, a label, and a text field required for creating a user interface and creating a container object for containing them.

The "JButton" class creates a button object of a user interface and is placed on a "JPanel" object.

The "JTextField" class creates a text field object of the user interface and is placed on the "JPanel" object.

The "JLabel" class creates a label object of the user interface and is placed on the "JPanel" object.

The "XYLayout" class controls the layout of each component such as a button, a label, and the like on a container object such as a panel freely in the concept of x and y axis coordinates.

The "DataBase" class creates an object that performs database connection and connection management using JDBC.

Subsequently, when the user inputs a database driver name and a URL of the target database system, the platform 132 provides a screen for inputting an ID and password used when accessing the target database system.

When the user enters the ID and password (step S10), the platform 132 stores the input ID and password and the URL data in the data storage unit 135.

The platform 132 drives the Java virtual machine 122 based on the data stored in the data storage unit 135 through the JDBC driver 1 124 corresponding to the database driver name input. The connection is made to the URL of the database system (step S12).

Since the connection to the URL of the computer having the target database system is made through a conventional internet access process using, for example, a web browser, a detailed description thereof will be omitted.

In the target database system, if there is an access request from any user computer, the client requesting access through the login process is determined to be a valid subscription, and the access is allowed only when it is legitimate.

Therefore, when the database system requires the ID and password required for login, the platform 132 presents the ID and password data stored in the data storage unit 135 to the target database system. In the target database system, a list of tables stored in its database is provided to the connected user computer 12.

The platform 132 of the user computer 12 that has received data on the database table list from the target database system outputs the table list as shown in FIG. 8 through a monitor (not shown) (S14). step).

Subsequently, when the user selects an arbitrary table from the list of tables displayed on the screen as shown in FIG. 8 as indicated by the black bar as shown in FIG. This will launch the user interface for copying the database as shown in 9.

In FIG. 9, the user interface for database copying includes a class "DbCopy" including a class shown in FIG. 7, which provides a user interface for copying remote and local target data to a user-set DBMS. It works in conjunction with the SplitPanel "class, the" BorderLayout "class, the" Vector "class, and the" ListControl "class.

In FIG. 9, descriptions of the classes already shown in FIG. 7 will be omitted. The "SplitPanel" class of FIG. 9 creates a variable panel object that performs a function of expanding and narrowing the area of the corresponding panel area by dragging the upper, lower, left, and right dividing lines with a mouse in an interface such as a window explorer.

Unlike the "XYLayout" class, the "BorderLayout" class controls the layout of components to be positioned in north, south, east, west, and center positions according to the edge boundary of the container object.

The "Vector" class is a class that creates a flexible data structure provided by the Java language. The "Vector" class can handle various types of data as one logical unit.

The "ListControl" class creates an object that represents and controls various data items in a list form in a user interface.

In order to copy the table defined in the target database at a remote location to the user computer 12 or another database designated by the user by executing the user interface as shown in FIG. 9, the catalog, schema, table name, Metadata information such as column name should be obtained.

At this time, the platform 132 uses a metadata processing class for copying a table as shown in FIG. 10. That is, the platform 132 drives the Java virtual machine 122 to generate a thread for copying the table using the metadata processing class to process the copying of the table.

In the metadata processing class for copying the table shown in FIG. 10, the "DBMeta" class is associated with the "DatabaseMetaData" interface, the "Vector" class, the "Connection" class, and the "ResultSet" interface.

In FIG. 10, the "DatabaseMetaData" interface creates an interface object representing meta data information for the entire database.

The "DBMeta" class is a class in charge of metadata processing for copying a database table. The catalog, schema, table name, and the like of the target database required for copying a table defined in the target database to a user-specified database are provided. Process meta data such as column name. Create a class by interfacing the "DatabaseMetaData" interface.

The "Connection" class supports connection, session maintenance, and transaction management with the target DBMS.

The "ResultSet" interface is an interface representing an SQL query result.

In addition, it is necessary to create a new table with a user-specified database for copying the table. The platform 132 must define a field type of the new table using the metadata information. At this time, the platform 132 processes the creation of the new table using the field type processing class of the new table generated when the table is copied as shown in FIG. 11.

The field type processing class of the new table shown in FIG. 11 is that the "DBMeta" class operates in association with the "Connection" class, the "ResultSet" class, the "Vector" class, and the "DatabaseMetaData" class.

The "FieldNameType" class is responsible for matching a field type of a table when a table of a target database is copied to a new table of a database designated by a user in a heterogeneous database environment. Also, the "String" class is a standard Java class that handles string representation and handling.

When the user selects an arbitrary field and executes a copy, as shown in FIG. 12, the platform 132 performs a process of copying the contents of the field in the target database using a class for copying the selected table. Done.

In Fig. 12, the class for copying a table operates in association with the classes shown in Figs.

In step S16 of selecting an arbitrary table from the table list of the target database displayed on the screen, the user must designate a local database of a target to which the selected table is to be moved.

The user sets a JDBC driver for connection with the database system to be designated through an input window as shown in FIG. 13A provided at the bottom of the table list displayed on the screen, and inputs URL data of the local database. Done.

When the corresponding data is input by the above process and the local database to be copied from the target database is designated (step S18), the platform 132 of the user computer 12 is located as shown in (B) of FIG. It will provide an input window for logging into the database.

When the user inputs the corresponding ID and password through the input screen window regarding the local database login, the platform 132 temporarily stores the input data in the data storage unit 135, and based on this, the local database system Attempt to connect (step S20).

Subsequently, when the login is successfully performed and connected to the designated local database system, the platform 132 outputs a table list of the target database on a part of the screen as shown in FIG. 13C, and the other part of the screen. The table list of the specified local database is displayed.

While the contents of the table of the target database and the local database are output as described above, the user selects a table to be copied from the target database and clicks the copy button on the screen to copy the table (step S22). .

That is, when the user selects a table and clicks the copy button, the platform 132 of the user computer 12 copies the selected table among the tables of the database and transmits the control data to the local database. The data is sent along with the URL data to the target database system.

In the target database system, a table selected from the database and its contents data are sent to a local database URL address, thereby copying a table from the target database to the local database.

After the table copy is made from the target database to the local database by the above-described process, the user can conveniently arrange the data copied to the local database in their own way.

14 is a flowchart showing a process of standardizing similar data.

The user selects the table copied to the local database using the database merging program 134 (step S32), and the contents of the selected table are displayed on the screen as shown in FIG. 15 (step S34). In operation S36, the platform 132 determines whether there is an input of similar data to be normalized.

The platform 132 uses a user interface for similar data standardization processing as shown in FIG. 16 to organize similar data for each field into unified data.

In FIG. 15, the data class "resident" is applied to the "city" field of the copied "customer" table. If you look at the "city" field, you can see that it has data values of "Seoul" and "Incheon".

In the above state, when the user inputs similar data to be normalized using the interface for similar data registration as shown in FIG. 17, the platform 132 performs a user interface for similar data standardization processing based on the input data. It will be executed (step S38).

For example, referring to the table on the right side of the screen of FIG. 17, data to be changed as in the second and fourth lines is referred to as "gwangju city" or "seoul city", and the data to be changed is "gwangju metropolitan city" or "seoul city". As a result, when the data class inputs a "start" command for collectively arranging "dwelling", the platform 132 uses the batch cleanup class for standardizing similar data, as shown in FIG. The process is executed (step S40).

Accordingly, the platform 132 is collectively changed to "gwangju" as "gwangju" and "seoul" as "seoul". As a result, as shown in FIG. 19, it can be seen that the value of the "city" field is changed to a value such as "Seoul" or "Incheon" according to the definition of the data class.

As described above, by using the user interface for standardizing the similar data, the similar data can be arranged for all the field data, and a standardized table can be obtained.

Subsequently, the platform 132 determines whether there are no more tables to clean up (step S42), and if there are more tables to clean up, returns to the step S34 of outputting the contents of the table and repeats the similar data normalization process in the above-described process. Done.

On the other hand, when there are no more tables to clean up and the user selects an interface for merging the tables in order to merge the tables (step S44), the platform 132 executes a user interface class for merging the tables as shown in FIG. As shown in FIG. 20, a screen for executing a table merge is output (step S46).

As shown in FIG. 20 (A), when the user clicks the ">" button in the "Table A" and "Table B" areas to select a field to be merged (step S48), the platform 132 selects a new table. In step S50, the table merge process is performed by moving the selected field of the merge target.

When a user inputs and specifies a name of a new table according to a merge process, the platform 132 may have the selected field as a table of a newly input name using a table merge process class as shown in FIG. 23. A new table is created (step S52).

In addition, the platform 132 clicks the "Select" button to select the primary key of each table to be merged and selects the corresponding field, and sets the selected field as the primary key in the table. .

Through the above-described process, as shown in FIG. 24, the result values according to the merge result may be obtained.

So far, the database has been cleaned up in the local database. The platform 132 may also execute the function of migrating these tables to other specific database systems.

In addition, unnecessary records may be deleted from a desired table in any process before or after the database merge, and a value of a field satisfying a specific condition may be extracted using a range designation operator.

That is, according to the above embodiment, it is possible to copy and move the contents of a table in a remote database system to another specific database system, to collectively arrange similar data for convenient use, and to merge desired tables.

The present invention is not limited to the above-described embodiments, and various modifications and changes can be made without departing from the technical gist of the present invention.

As described above, according to the present invention, it is possible to copy, collectively, and merge the heterogeneous database contents of remote locations, thereby minimizing user setting items in the process of loading and extracting data from the database. It provides universal data connectivity possibilities regardless of various source formats, and can shorten the data analysis process.

Claims (25)

A heterogeneous database automatic with a user computer connected to remote database systems via the Internet and performing table copying, similar data standardization processing, and table merging between remote database systems through a database merging program. In the merging method, Executing the database merging program; Executing an interface for connecting to a remote database system, Connecting to the target database system, Outputting a table list of the target database; Selecting a table to copy from the list of tables displayed on the screen; Connecting to the local database system to be copied and moved, Copying the selected table from the target database to a local database. The method of claim 1, The interface for connecting to the remote database system is a heterogeneous database automatic merging method, characterized in that using the Java Database Connector (JDBC) technology based on the Java language. The method of claim 1, The interface for connecting to the remote database system is a heterogeneous database automatic merging method, characterized in that for connecting to the target database using a JDBC driver for connecting a variety of heterogeneous database system. The method of claim 1, When connecting to the target database and the local database, heterogeneous database automatic merging method characterized in that the connection by inputting the URL and ID and password of each database system. The method of claim 1, Method for automatically merging heterogeneous databases, using an interface for copying a database when copying a table from the target database to a local database. The method of claim 1, A method for automatically merging heterogeneous databases, wherein a class for processing metadata is used to obtain metadata information about a catalog, schema, table name, and column name of a target database before copying the selected table. The method of claim 1, The method of automatically merging heterogeneous databases, wherein a class for copying a table is used when copying the selected table. A heterogeneous database automatic with a user computer connected to remote database systems via the Internet and performing table copying, similar data standardization processing, and table merging between remote database systems through a database merging program. In the merging method, Executing the database merge program to display the contents of the table of the target database; Executing a user interface for processing similar data standardization, Enter the data you'd like to bulk sort, Collectively tidying up table contents using classes for standardizing similar data; A method for automatically merging heterogeneous databases, comprising: outputting the contents of a batched table. Heterogeneous database automation with user computers connected to remote database systems via the Internet, and using a database merge program to perform table copying, pseudo-data normalization processing, and table merging between remote database systems. In the merging method, Launching an interface for selecting tables to merge, Selecting the tables and fields you want to merge, Merging the fields of the selected table into a new table; Setting a name of the new table; Displaying the contents of the new table screen heterogeneous database automatic merging method comprising the. The method of claim 9, The method of claim 1, further comprising the step of setting a primary key of each of the merged tables. The method of claim 9, The method for automatically merging heterogeneous databases, wherein unnecessary records can be deleted from a desired table before or after the database merging. The method of claim 9, A method for automatically merging heterogeneous databases, in which a range operator is used to extract values of fields that satisfy specific conditions when selecting tables and fields to be merged. The method of claim 9, When merging the selected table into a new table, heterogeneous database automatic merging method characterized in that executed through a table merge processing class. A heterogeneous database automatic with a user computer connected to remote database systems via the Internet and performing table copying, similar data standardization processing, and table merging between remote database systems through a database merging program. In the merging method, Executing an interface for connecting to a remote database system, Connecting to the target target database system and the target local database system, Copying the table of the target database to a local database; Executing a user interface for processing similar data standardization, Processing the similar data standardization by collectively arranging the tables of the copied local database; Launching a user interface for merging tables, Selecting tables and fields to be merged in the local database; And merging the fields of the selected table to create a new table. The method of claim 14, The interface for connecting to the remote database system is a heterogeneous database automatic merging method, characterized in that using the Java Database Connector (JDBC) technology based on the Java language. The method of claim 14, The interface for connecting to the remote database system is a heterogeneous database automatic merging method, characterized in that for connecting to the target database using a JDBC driver for connecting a variety of heterogeneous database system. The method of claim 14, When connecting to the target database and the local database, heterogeneous database automatic merging method characterized in that the connection by inputting the URL and ID and password of each database system. The method of claim 14, Method for automatically merging heterogeneous databases, using an interface for copying a database when copying a table from the target database to a local database. The method of claim 14, A method for automatically merging heterogeneous databases, wherein a class for processing metadata is used to obtain metadata information about a catalog, schema, table name, and column name of a target database before copying the selected table. The method of claim 14, The method of automatically merging heterogeneous databases, wherein a class for copying a table is used when copying the selected table. In heterogeneous database automatic merging system in which various heterogeneous database systems are interconnected through the Internet, A platform that controls the overall operation as hardware that is the basis of the heterogeneous database automatic merging system, Java Virtual Machine, which is based on the Java language and uses interfaces to implement interfaces, A plurality of Java Database Connectivity driver for connecting to the various heterogeneous database systems, A database merge program for executing heterogeneous database automatic merges, Input means for inputting data, Screen output means for screen output of data, A data storage unit for temporarily storing data input through the input means or storing data transmitted and received; A local database for merging and storing data copied or cleaned up from remote database systems by the database merging program; It is configured to include the application interface (API) of the program made at the request of the user, The platform is connected to the heterogeneous database system to copy a table, standardizes the copied table contents, and controls the generation of a new table by merging fields of a table selected by a user. Database automatic merge system. The method of claim 21, When connecting to the various heterogeneous database systems, heterogeneous database automatic merging system, characterized in that the connection through the URL and ID and password of each database system input by the user. The method of claim 21, The heterogeneous database automatic merging system, wherein an interface for copying a database is used when copying a selected table from the heterogeneous database system. The method of claim 21, And a class for processing metadata to obtain metadata information about the catalog, schema, table name, and column name of the heterogeneous database before copying the selected table. The method of claim 21, The heterogeneous database automatic merging system, characterized in that to use the class for copying the table when copying the selected table.