KR19990079216A - How to share a database on the Internet - Google Patents

Abstract

Create a database on one server, transfer the database created over the Internet to one other server, and update the database by synchronizing the database between one server and another server.

Thus, by synchronizing the database between remote servers using the Internet, it is possible to quickly and easily share the latest database between remote servers.

Description

How to share a database on the Internet

The present invention relates to a method of sharing a database on the Internet, and more particularly, to share a state-of-the-art database even among remote servers by using a synchronization of a database available only on an existing network file system on the Internet. The present invention relates to a method of sharing a database on the Internet.

In general, database synchronization refers to an operation of matching contents between physically different databases. This tracks the changes between records, which are the actual contents of each table in both databases, and updates the two databases with the latest data, if any.

The database synchronization process begins with the creation of a copy in the original database. The structure of this copy is identical to the original and additionally contains additional information needed for the synchronization operation. Synchronization updates the original and copy databases with data that has been recently changed by comparing data added, changed, or deleted between the original and the copy. At this time, the amount of comparison of the database is as many as the number of records, and the larger the number of records, the longer it takes to update to the latest data.

Currently, the Network File System can be freely accessed as if accessing the File System of the local disk, so that it is located at a certain distance in a LAN (Local Area Network) environment. Database synchronization between two computers is now possible.

On the other hand, the number of users of the Internet is increasing day by day, and the transmission speed of the Internet is also increasing accordingly. With the launch of the World Wide Web (WWW), the development of the Internet is revolutionary, and the world's information can be instantly accessed by using WUW at home via regular telephone lines. It was collected.

However, in the remote work such as the Internet as described above, the synchronization work is not currently performed, so the sharing of the latest database among buildings and the sharing of the latest database among different cities are also impossible to share the latest database existing in another country.

Accordingly, the present invention is to solve such problems, the first object of the present invention is to enable synchronization to the Internet using a database engine (Database Engine) that can be synchronized on the existing file system (File System) It is to provide a database sharing method on the Internet.

A second object of the present invention is to provide a database sharing method on the Internet to shorten the development period since it is not necessary to design a separate database engine by using a conventional database engine.

1 is a schematic block diagram illustrating a multiple server-client environment in which the present invention may be applied.

2A is a flowchart showing a generating step.

2B is a flowchart showing an update step.

<Description of the code | symbol about the principal part of drawing>

A: 1 secondary server network B: secondary server network

1: 1 primary server 1a: secondary server

2: client 3: source database

4: transmission copy 5: copy database

A characteristic of the present invention for achieving the above objects is the creation step of creating a database on one server and transferring the database to one other server to create the same database on both servers and between one server and one other server. In that it includes an update step to update the database.

Here, the generating step is the first and the first step of creating a database on one server and connecting the two servers when there is a database transfer request from one server, and then creating a transfer copy of the database on one server. The second step of transferring the transfer copy from one server to the other server and the third step of transferring all the transfer copies from one server to one other server and creating a copy of the transfer copy on one other server. do.

At this time, the update step, if any one of the server and one of the other server requests a database synchronization, any other server that has been requested for database synchronization to create a transmission copy and the transfer copy from any other server Receiving both the transfer copy sent in step 2 and step 2 to any server at any server, the transfer copy and copy at step 3 and any server to synchronize the transfer copy and copy at any server After the synchronization with the server is completed, the fourth step of creating a transfer copy of the synchronized database on any server, and the fifth and fifth steps of transferring the transfer copy of the synchronized database from any server to any other server. Receive all sync copies sent from to any other server. And a sixth step of synchronizing the original database with the transmission copy which has been synchronized from any other server.

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

1 is a schematic block diagram illustrating a multiple server-client environment in which the present invention may be applied.

2A is a flowchart showing a fish step.

2B is a flowchart showing an update step.

Referring to Figure 1 schematically illustrates a multiple server-client environment to which the present invention can be applied.

In FIG. 1, a multiple server-client environment consists of two remote primary and secondary server networks (A, B), and the primary and secondary server networks transmit and receive databases over the Internet.

First, the configuration of the primary server network (A) is as follows.

The primary server 1 is a device for providing various resources in the system, in particular, generating a transmission copy 4 from the original database and controlling synchronization in the primary network.

A client (2) refers to a process (also referred to as a program or a task) that requests a service provided by another program in computer processing, and a plurality of clients exist in the server.

The original database 3 represents the initial database created by the primary server 1.

The transmission copy 4 represents a copy of the original database for transmission from the primary network A to another network via the Internet.

Next, the configuration of the secondary server network (B) is as follows.

The secondary server 1 is a device for providing various resources in the system, in particular, generating a transmission copy from the original database and controlling synchronization in the primary network.

A client (2) refers to a process requiring a service provided by another program in computer processing, and a plurality of clients exist in the server.

The transmission copy 4 represents a copy of the original database 3 received from the primary network A for synchronization at the secondary server 1.

The copy database 5 represents a database received from the primary server network A for use in the secondary server.

This article describes how to share a database in such a multiple server-client environment.

The database sharing method on the Internet according to the present invention is largely divided into a generation step and an update step.

The generation step will be described with reference to FIG. 2A.

In the fish phase of the present invention, the database is created on the primary server (S1), and the secondary server is connected to the primary server through the Internet (S2, S3), and the secondary server requests the database (S4). In the first step (S5) of creating a transmission copy for the database and the second step (S6) of transmitting the transmission copy from the primary server to the secondary server and transmitting the transmission copy from the primary server to the secondary server And a third step S8 of generating a copy for the transmission copy in the secondary server.

In addition, the update step will be described with reference to FIG. 2B.

In the update step of the present invention, the secondary server is connected to the primary server through the Internet (S9) after the connection of the two servers is completed (S10), and the secondary server requests database synchronization (S11) and receives a database synchronization request. The first step (S12) in which the primary server creates a transmission copy, the second step (S13) in which the primary server transfers the transmission copy to the secondary server, and the primary server transmits both the transmission copies and then in the secondary server. When all the transfer copies are received (S14), the second server synchronizes the transfer copy and the copy (S15) and when the secondary server finishes synchronizing the transfer copy and the copy (S16), synchronization is performed on the secondary server. Step 4 (S17) of creating a transfer copy of the completed database, and step 5 (S18) of transferring the transfer copy of the completed database from the secondary server to the primary server and the data of synchronization completion on the secondary server. When transmitting all the transmission copies of the database and receiving all of the transmission copy of the synchronization is completed in the primary server (S19) includes a sixth step (S20) for synchronizing the transmission database and the original database is completed synchronization in the primary server.

Referring to Figures 2a and 2b the process of performing a database sharing method on the Internet configured as described above in the multi-server client environment of Figure 1 as follows.

First, as shown in FIG. 2A, the original database 3 is created on the primary server 1 (S1), and the secondary server 1a is connected to the primary server 1 via the Internet (S2, S3). When the secondary server 1a requests the database of the primary server 1 (S4), the primary server 1 generates a transfer copy 4 of the original database for transferring the database (S5).

Thereafter, the above transmission copy 4 is transmitted from the primary server 1 to the secondary server 1a (S6) and when transmission / reception is completed between the 1.2 primary servers (S7), the secondary server 1a. In step S8, a copy of the received transmission copy 4 is generated (S8) to provide a copy of the transmission copy 4 above to the client (Client).

On the other hand, if a certain time has elapsed and the secondary server requests the primary server to synchronize the database being used over the Internet (S9, S10) (S11), as shown in FIG. 2B, the primary server transmits the transmission copy 4. It generates (S12).

Here, the transmitted transmission copy 4 is transmitted to the secondary server 1a via the Internet (S13) and when the reception of the transmission copy 4 is completed in the secondary server 1a (S14), the secondary server 4 ) Synchronizes the received transmission copy (4) with the database in use using a conventional synchronization technique (S15) and when the synchronization is completed (S16), the second server 1a generates a copy of the completed synchronization database. (S17).

Accordingly, a copy of the synchronization-completed database is transmitted to the primary server 1 (S18), and when the reception of the synchronization-completed database is completed (S19), the primary server 1 receives the received synchronization-completed copy 4a. By synchronizing the original database 3 with the conventional synchronization technique (S20) all the synchronization process is terminated.

Therefore, the latest database can be shared among servers by synchronizing the database between remote servers through the Internet.

After all, according to the method of sharing a database on the Internet according to the present invention as described above, it is possible to synchronize the database via the Internet, different buildings, different countries, multiple server-client environment and offline (Off-Line) environment and different Even buildings with servers have the effect of quickly searching and modifying the database.

Claims (3)

On the Internet where several different servers are connected: Generating a database in one server and transmitting the database to one other server to generate the same database in both servers; And updating the database between the one server and one other server. The method of claim 1, wherein the generating of the database comprises: creating a database at the one server and connecting to two servers when a request for database transmission is made at the other server, and then generating a transmission copy of the database at the one server. The first step to do; Transmitting, by the one server, the transmission copy to the one other server; And transmitting a copy of the transmission copy from the one server to the other server and creating a copy of the transmission copy at the one other server. 2. The method of claim 1, wherein the updating step comprises: a first step in which any other server that is requested to update the database creates a transmission copy when a database update is requested from one server and one other server; Transmitting the transmission copy from the other server to the server; A third step of synchronizing the transmission copy with the copy at the arbitrary server when the transmission copy transmitted in the second step is received at the server; A fourth step of generating a transmission copy of the synchronization-completed database in the arbitrary server when the transmission copy and the copy of the copy are completed in the arbitrary server; Transmitting a transfer copy of the synchronization-completed database from the any server to the any other server; And a sixth step of receiving, at the fifth step, all of the transmission copies that have been completed in synchronization at the other other server and synchronizing the transmission database with the synchronization completed at the other server and the original database. How to share a database on Windows.