KR20010085501A - A system for synchronizing database of client systems and database of a host system and a method thereof - Google Patents

Abstract

PURPOSE: A system and a method for synchronizing a database between a client system and a host system are provided to update and register a host database according to the update and registration of a plurality of client databases. CONSTITUTION: A host server(100) is comprised of a host web server operating part(110), a data receiving part(120), a DBMS(DataBase Management System)(130), and a host database(140). A client server(200) is comprised of a client web server operating part(210), a data transmitting part(220), a DBMS(230), and a client database(240). The host server(100) and the client server(200) are connected through Internet(600) each other. The data to be stored in the host database(140) and the data to be stored in the client database(240) should be identical overall or partially in their formats. The data inputted and outputted in the client database(240) are controlled by the DBMS(230). In other words, in order to access desired data stored in the client database(240), the data transmitting part(220) controls the DBMS(230). The client web server operating part(210) can be configured of the web service program or web page of the client server(200). And the data transmitting part(220) can be configured of a Java applet program. The Java applet program of the data transmitting part(220), installed inside of the client server(200), is linked with the webpage of the client server(200).

Description

Database synchronization system between client system and host system and its method {A SYSTEM FOR SYNCHRONIZING DATABASE OF CLIENT SYSTEMS AND DATABASE OF A HOST SYSTEM AND A METHOD THEREOF}

The present invention relates to database interworking and synchronization via a network, and relates to updating / registering a host database according to update / registration of a plurality of client databases connected to a network.

Databases are widely used in medium-to-large computer systems because they can store huge amounts of data and are easy to search.

Such databases are frequently used by Oracle, Informix, or MS-SQL.

In general, a local area network (LAN) is localized so that multiple client computers can easily share data with a common database. Moreover, the database shared by the local area network (LAN) has an advantage that it is easy to operate.

However, there is a problem in that the database sharing is not easy between the remote computer, or between the client computer and the host computer.

In other words, if the computer between remote sites does not have a high data transfer rate, data sharing efficiency will be reduced. Moreover, as the number of clients in the database to be shared increases, the complexity increases.

The present invention relates to the interworking and synchronization of the database through the Internet, the object of which is to update / register the host database in accordance with the update / registration of a plurality of client databases connected to the network.

1 is a diagram illustrating a connection relationship between a plurality of client systems and a host system constituting a synchronization system according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating a connection relationship between one client server and a host server among client servers in the synchronization system of FIG. 1.

3 is a diagram illustrating an example of a database applied to a synchronization system according to an embodiment of the present invention.

4 is a flowchart illustrating a data extraction and transmission step of a client server in the synchronization system of FIG. 2.

5 is a flowchart illustrating a data receiving and storing step in a host server of the synchronization system of FIG. 2.

6 is a diagram showing the web database operation of the synchronization system according to another embodiment of the present invention.

7 is a diagram illustrating an example in which a synchronization system according to another embodiment of the present invention is applied.

As a means for achieving the above object, the present invention provides a plurality of clients having a predetermined client database, and transmitting the updated or registered data through a network when data stored in the client database is updated or new data is registered. system; And a predetermined host database having a data format that is in particular the same as the data format stored in the client database of the client system, and receiving the updated or registered data transmitted through the network from the client system to receive the updated data from the host database. And a host system for updating or newly registering data of a portion corresponding to the client database.

Another means of the present invention for achieving the above object is a method for synchronizing a database between a client system and a host system connected to each other via a network, wherein a predetermined client database provided therein is updated or newly registered. If so, transmitting the updated or newly registered data to the host system via a network; And receiving, by the host system, the updated or newly registered data transmitted from the client system via a network, and storing the received data in a predetermined host database in the host system.

Another means of the present invention for achieving the above object comprises a host database for storing the recipient data of individuals or groups associated with the message sender, the message input from the data terminal device of the message sender connected via the wired or wireless network A host system for transmitting the data to the data terminal device of a recipient of an individual or a group selected by a message sender through the host database; And a client database having a specific data format identical to a data format stored in the host database, the client database storing receiver data of an individual or a group to receive a message, wherein the client system includes the client database. The updated or registered receiver data is transmitted to the host system via a network when the receiver data stored in the receiver is updated or new receiver data is registered, and the host system transmits the updated or registered data transmitted from the client system via the network. Receiving receiver data and updating or newly registering receiver data of a part corresponding to the client database of the host database The.

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

1 is a diagram illustrating a connection relationship between a plurality of client systems and a host system constituting a synchronization system according to an embodiment of the present invention.

As shown in FIG. 1, a synchronization system according to an embodiment of the present invention includes a host server 100 and a plurality of client servers 200 to 500.

The host server 100 and the plurality of client servers 200 to 500 are connected via a network, such as the Internet.

A client database is connected to each client server 200 to 500 side, and the data input to the client is updated / registered.

That is, when a database of any client server is updated / registered, the data is transmitted to the host server 100 via, for example, the Internet. Then, the host server 100 updates / registers data transmitted from any client server through the Internet to a host web database configured in the host server 100.

FIG. 2 is a diagram illustrating a connection relationship between one client server 200 and a host server 100 among the client servers 200 to 500 in the synchronization system of FIG. 1.

As shown in FIG. 2, the host server 100 includes a host web server operating unit 110, a data receiving unit 120, a database management system (DBMS) 130, and a host database 140, and the client server 200. ) Includes a client web server operation unit 210, a data transmission unit 220, a DBMS 230, and a client database 240. The host system 100 and the client system 200 are connected to the Internet 600. Connected.

The data 150 stored in the host database 140 and the data 250 stored in the client database 240 should be identical in whole or in particular in the format.

Data inputted to and outputted from the client database 240 is controlled by the DBMS 230 controlled by the data transmitter 220. That is, the data transmitter 220 controls the DBMS 230 to access predetermined data stored in the client database 240.

Meanwhile, the client web server operating unit 210 may be configured as, for example, a web service program (for example, a web page) of the client server 200, and the data transmitter 220 may be configured as, for example, a Java applet program. .

According to the present invention configured as described above, the Java applet program of the data transmission unit 220 is installed in the client system 200 and links the Java applet program to the web page of the client web server operating unit 210.

A user of the client server 200 clicks a corresponding button of a web page linked with a Java applet program to transmit data stored in the client database 240 to the host server 100. Then, the data transmitter 220 controls the DBMS 230 to extract predetermined data from the client database 240 and transmit the predetermined data to the host server 100 through the Internet 600. In this case, in order to transmit the data stored in the client database 240 to the host server 100 was described as clicking the corresponding button of the web page linked to the Java applet program, the technical scope of the present invention is not limited thereto. When an event such as registration of new data or update of already registered data occurs in the client database 240, the DBMS 230 notifies the data transmitter 220 of the fact, and the data transmitter 220 transmits the DBMS. The control unit 230 may control the data to be transmitted to the host server 100 through the Internet 600.

Data input and output to the host database 140 is controlled by the DBMS 130 controlled by the data receiver 120. That is, the data receiver 120 controls the DBMS 130 to access predetermined data of the host database 140.

In the meantime, the host web server operating unit 110 may include a host web server 100 as a web service program (for example, a web page), and the data receiving unit 120 may include, for example, a Java applet program. . In addition, the DBMS 130 may be configured with, for example, a driver such as JDBC (Java DataBase Conectivity) or ODBC (Open DataBase Conectivity).

Data received from the client server 200 via the Internet 600 is received by the data receiving unit 120, the data receiving unit 120 controls the DBMS 130 to the client database 240 of the client server 200 The received data is written to a specific portion of the host database 140 which is synchronized with the.

3 is a diagram illustrating an example of a database applied to a synchronization system according to an embodiment of the present invention.

As shown in FIG. 3, if the personal information or course details of the CEO courses taken at a university are changed or added, the database in the affiliated Lions club's web server is updated to synchronize the database with the university.

Similarly, if the registration information is changed in a resident office belonging to the ward office, the registration information of the corresponding resident in the web database of the ward office connected to the web server of the office is changed.

In addition, in the case of the technical review server in which the company / person and database synchronization are affiliated, when the technical data file of the company / person is updated / registered, the corresponding data of the technical review database is also updated / registered.

4 is a flowchart illustrating a data extraction and transmission step of the client server 200 in the synchronization system of FIG. 2.

As shown in FIG. 4, when new data is registered in the client database 240 or existing data is updated to select data transmission manually or automatically to synchronize data in the host database 140 (S210). After the data transmission unit 220 of the client server 200 extracts the registered or updated data from the client database 240 (S220), the data transmission unit 220 transmits the extracted data to the host server 100 through the Internet 600. (S230).

5 is a flowchart illustrating a data receiving and storing step in the host server 100 in the synchronization system of FIG. 2.

As shown in FIG. 5, when data newly registered or updated in the client database 240 is received by the host server 100 for synchronization through the Internet 600 (S110), the data receiving unit 120 receives the data. Determines whether the data is registered in the host database 140 (S120). If the data is not registered, the data is updated or registered in the corresponding portion of the host database 140 (S130).

6 is a diagram showing the web database operation of the synchronization system according to another embodiment of the present invention.

As shown in FIG. 6, various business procedures are required to synchronize the web database of the synchronization system according to the present invention.

First, the operator of the host server 100 needs to secure a plurality of client server 200 operators, and in order to do so, a contract with the operator of the client server 200 is performed (S310).

When the contract is made in this way, the operator of the host server 100 to grasp the operation form of the client server 200 contracted to synchronize the web database (S320).

Then, the web database interlocking program (for example, a Java applet) is tailored according to the identified operation type of the client server 200 (S330).

In this way, the web database interworking program tailored to the contracted operation of the client server 200 is installed in the client server 200 (S340).

Subsequently, the operator of the host server 100 registers the contracted client server 200 on the homepage, for example (S350).

Then, all procedures for synchronizing and interlocking the web database are completed, and the database synchronization system is operated (S360).

7 is a diagram illustrating an example in which a synchronization system according to another embodiment of the present invention is applied.

As shown in FIG. 7, the synchronization system according to another exemplary embodiment of the present invention selects a group of recipients from data stored in a database and transmits a predetermined message to a receiver of the selected group. ) Is used.

The wired / wireless group transmission apparatus 700 includes an interactive voice response server 760 connected to a user terminal such as a mobile telephone 10, a telephone 50, a fax 40, or the like through a public switched telephone network (PSTN) 20, Automatic call distribution server 765, and fax server 770.

Each server 760, 765, 770 is connected to a database server 780 and a short message server 730, and a file server 785 is connected to a database server 780.

The short message server 730 is connected to the mobile communication service company 30 through a dedicated line such as a wide area network (WAN). At this time, the mobile communication service company 30 may be connected regardless of the type of mobile communication service such as 011, Ol6, 017, 018, 019.

The email server 790 is connected between the database server 780 and the short message server 730.

The web server 710, which is connected to the client system 800 via the Internet 600, is connected to the database server 780.

The message sender may be both a client system 800 and a user terminal, i.e., a mobile telephone 10, a telephone 50, and a fax 40. In this embodiment, the client system 800 is a sender and a receiver. Will be described as being a user terminal.

The interactive voice response server 760 functions as a voice response interface to the user when there is a connection to the mobile phone 10 or the phone 50 via the PSTN 20.

The automatic call distribution server 765 outputs voice data to the mobile phone 10 or the phone 50 through the PSTN 20, and distributes and outputs the voice data to a plurality of users.

The fax server 770 is connected to the user's fax 40 through the PSTN 20 and performs tasks such as fax-to-fax and fax transmission, text or email-to-fax transmission, and the like.

The database server 780 manages a database of individuals or groups.

The database server 780 stores, for example, name books such as clubs, social gatherings, and reunions. The directory includes data such as group name, name, address, telephone number, mobile phone number, fax number, ID, etc. of an individual or group.

The email server 790 performs a task related to email transmission.

When the client system 800 is connected, the web server 710 outputs a service menu through a web browser. When the client system 800 selects a predetermined service menu, the web server 710 performs overall control to perform a corresponding service.

The short message server 730 performs a task of transmitting a short message through the mobile communication service company 30.

The client system 800 includes a client web server 810, a DBMS 820, and a client database 830.

The client web server 810 is connected to the web server 710 of the wired / wireless group transmission apparatus 700 via the Internet 600. The client may transmit a specific message to the user terminal through the wired / wireless group transmission apparatus 700 using the client web server 810.

The client database 830 stores data of individuals or groups. For example, a name book such as a fellowship, a social gathering, or a class reunion is stored. The directory includes data such as group name, name, address, telephone number, mobile phone number, fax number, ID, etc. of an individual or group.

At this time, the data stored in the client database 830 and the data stored in the database server 780 of the wired / wireless group transmission apparatus 700 should be the same in whole or in a specific part in the format.

The data stored in the client database 830 is controlled by the DBMS 820, and the client database server may be separately configured by including the client database 830 and the DBMS 820.

Between the client, the user of the client system 800, and the administrator of the wired / wireless group transmission apparatus 700, a synchronization contract for data for wired / wireless group transmission, for example, a receiver group data, is made, and a database interworking program for synchronizing the data includes a client web. It is installed in the server 810.

The database interlocking program is manually operated by the client for synchronization purposes and transmits data stored in the client database 830 to the database server 780 of the wired / wireless group transmission apparatus 700 via the Internet 600, or the client database ( If new data is registered or existing data is updated in the 830, it is automatically detected and transmitted to the database server 780 through the Internet 600 to synchronize the corresponding data.

The database server 780 of the wired / wireless group transmitting apparatus 700 receives data transmitted for synchronization through the Internet 600 and updates the data if it is already registered, and newly registers the data if it is not registered. To synchronize with the contents of the data stored in the client database 830.

Meanwhile, the wire / wireless group transmission apparatus 700 uses client-related data stored in the database server 780 which is synchronized with the client database 830, and uses a voice mail service (VMS), which is a voice service operation, and an SMS (short message service operation). Short Message Service (FMS), and Fax Message Service (FMS), which is a fax transmission service job, can perform three major tasks.

First, in the case of a VMS operation, when the client connects to the interactive voice response server 760 through a specific phone number using the mobile phone 10 or the phone 50, the interactive voice response server 760 is connected to the corresponding terminal ( 10, 50) provides an interactive voice response service. For example, it provides services such as checking mail contents, sending mail contents, and transmitting voice recordings.

The mail content confirmation service is a service well known in the art to check mail received by the user and stored in the database server 780.

Here, the voice recording transmission service will be described.

The service is used when the client wants to transmit a specific voice to an individual or a group using the mobile phone 10 or the phone 50. When the client selects the service, the interactive voice response server 760 The voice input from the client's mobile phone 10 or phone 50 is stored in the file server 785 as a corresponding voice data file.

At this time, the interactive voice response server 760 receives the environment information of the client stored in the database server 780 to determine whether the client is a member, whether the service is available, or the like.

On the other hand, if all of the voice input from the client is stored, the interactive voice response server 760 receives the range of the receiver to receive the voice from the client. At this time, the range of the receiver designated from the client is stored in advance in the database server 780 synchronized by the client server 800, and whenever the client database 830 of the client server 800 is changed, the database server ( The data stored in 780 is also matched.

When the designation of the receiver to receive the voice from the client is completed, the interactive voice response server 760 transmits an instruction to the automatic call distribution server 765 to output the voice to the designated receiver.

Thereafter, the automatic call distribution server 765 receives the corresponding voice data from the file server 785, receives the designated recipient range from the database server 780, and then receives the mobile phone number or the telephone number of the recipient included in the recipient range. The voice data is extracted and output to the terminals 10 and 50 of the corresponding receiver through the PSTN 20.

On the other hand, if the receiver's terminal is the phone 50, up to three attempts are made, and in the case of the mobile phone 10, the receiver automatically switches to the voice mailbox when the reception is not possible and records the corresponding voice.

Next, in the case of an SMS task, which is a short message service task, when the client accesses the web server 710 through the server 800, the web server 710 provides a stored web page, and whether or not the client is a member of the SMS. After determining whether the service is available or not, the client inputs or selects a text message to be sent to the receiver if it is available.

When the client selects to input a text message to be sent to the receiver, the text message input from the client server 800 is stored in the database server 780.

However, if the client wants to select among the example sentences stored in the web server 710 in advance, the web server 710 displays the example sentence to the client through the client server 800, and the client selects the desired example sentence among the example sentences. do. At this time, the date, time, etc. of the examples can be changed by the client.

For example, if the example sentence provided by the web server 710 and selected by the client is "the meeting time was changed from 17:00 to 19:00 today", the client may display the time displayed during the example (17:00, 19:00). ) Can be changed.

As such, when a specific example is selected by the client, the web server 710 stores the example in the database server 780.

Thereafter, the web server 710 extracts and displays the data of the individual or group to which the client in the database server 780 belongs to the client so that the client can select a range of recipients to receive the corresponding text message or example. Specifies a specific recipient range from the recipients individual or group to be displayed.

Meanwhile, the short message server 730 monitors whether a text message is stored in the database server 780, and when a specific text message or example sentence is stored by the web server 710, the short message server 730 is included in the range of recipients specified by the client. After extracting the mobile phone number of the receiver, the text message or example sentence stored in the database server 780 is transmitted to the mobile communication service company 30 connected through a dedicated line such as a WAN along with the receiver mobile phone number, and the corresponding mobile communication service. The company sends the text message or example sentence to the recipient. At this time, the range of the receiver designated from the client is stored in advance in the database server 780 synchronized by the client server 800, and whenever the client database 830 of the client server 800 is changed, the database server ( The data stored in 780 is also matched.

On the other hand, the short message server 730 is a mobile communication service company varies depending on the mobile phone number of the receiver, it should be noted that to be converted to a text message type corresponding to the mobile communication service provider to be transmitted.

Next, in the case of the FMS job, which is a fax service job, when a client uses a fax (40) to connect to the fax server (770) through a specific phone number, the fax server (770) is an interactive fax answering service to the fax (40). To provide. For example, the present invention provides a service for checking a sender's ID and password, and checking whether a fax transmission or an electronic mail transmission is selected.

This section describes the case of a fax transmission service.

A service used when a client wants to send a specific fax to an individual or a group using a fax 40. When the client selects the service, the fax server 770 is sent from the client's fax 40. The fax data is stored in file server 785.

At this time, the fax server 770 receives the environment information of the client stored in the database server 780 to determine whether the client is a member, whether or not to use the service.

On the other hand, if all of the fax data input from the client is stored, the fax server 770 is designated from the client the range of the recipient to receive the fax data. At this time, the range of the receiver designated from the client is stored in the database server 780.

At this time, the range of the receiver designated from the client is stored in advance in the database server 780 synchronized by the client server 800, and whenever the client database 830 of the client server 800 is changed, the database server ( The data stored in 780 is also matched.

When the specification of the recipient to receive the corresponding fax data from the client is completed, the fax server 770 receives the corresponding fax data from the file server 785, receives the designated recipient range from the database server 780, and then includes the recipients included in the recipient range. Extract the recipient's fax number and output the fax data to the recipient's fax via the PSTN 20.

On the other hand, fax data transmission by the recipient is attempted up to three times when an error occurs, but is not limited thereto.

Although the operation of the VMS, SMS, and FMS has been described above, it will be easily understood by those skilled in the art that the VMS, SMS, and FMS operations of other paths are not limited to the above-described examples.

Although the present invention has been described with reference to the most practical and preferred embodiments, the present invention is not limited to the above disclosed embodiments, but also includes various modifications and equivalents within the scope of the following claims.

According to the present invention, as long as the client computer and the host computer are connected to the Internet, interworking and synchronization of the database are possible. And even if the number of clients increases, the host computer can operate efficiently.

Therefore, the database of the host computer stores the information consistent with the data of the database of the client computer no matter how far away the remote computer is.

Claims (9)

A plurality of client systems having a predetermined client database and transmitting the updated or registered data through a network when data stored in the client database is updated or new data is registered; And A predetermined host database having a data format specific to the data format stored in a client database of the client system, the data format being stored in a client database of the client system; Host system that updates or newly registers data in the appropriate part of the client database Database synchronization system between the client system and the host system comprising a. The method of claim 1, The client system A database operating system managing data input / output of the client database; A data transmitter configured to extract data from the client database by controlling the database operating system according to a predetermined data transmission signal; And A client server operator which controls the data transmitter to transmit data extracted from the client database to the host system through a network; Database synchronization system between the client system and the host system comprising a. The method of claim 1, The host system A host database operating system managing data input / output of the host database; A data receiver configured to receive data transmitted from the client system via a network; And When data is received in the data receiver, the host system operating unit controls the host database operating system to register or update the received data in the host database. Database synchronization system between the client system and the host system comprising a. In a method for synchronizing a database between a client system and a host system connected to each other via a network, Transmitting the updated or newly registered data to the host system through a network when a predetermined client database provided therein is updated or newly registered. And The host system receiving the updated or newly registered data transmitted from the client system via a network, and storing the received data in a predetermined host database within the host system. Database synchronization method between the client system and the host system comprising a. The method of claim 4, wherein The step of transmitting the data Determining, by the client system, whether the client database is updated or new data is registered; Selecting data to be updated or registered in the client database as transmission data; Extracting the selected data; And Transmitting the extracted data to the host system through a network. Database synchronization method between the client system and the host system comprising a. The method of claim 4, wherein Receiving the data Receiving, by the host system, data transmitted through a network; Determining whether to register or update the input data in the host database; And Registering or updating the data in the host database when it is determined to register or update the input data. Database synchronization method between the client system and the host system comprising a. A host database that stores recipient data of individuals or groups associated with the message sender, wherein the individual inputted by the message sender via the host database receives a message input from a data terminal device of the message sender connected through a wired or wireless network; A host system for transmitting to the data terminal apparatus of the receiver of the group, respectively; And A plurality of client systems comprising a client database that has a data format that is partly identical to the data format stored in the host database and that stores recipient data of individuals or groups to receive messages. Including; The client system transmits the updated or registered receiver data to the host system through a network when the receiver data stored in the client database is updated or new receiver data is registered. The host system receives the updated or registered receiver data transmitted from the client system through a network to update or newly register receiver data of a portion corresponding to the client database of the host database. How to synchronize a database between a client system and a host system. The method of claim 7, wherein The host system An interactive voice response server configured to perform a voice response interface function of a sender's voice transmit / receive terminal device connected through a wired / wireless network, and receive voice data to be transmitted to the receiver from the sender's voice transmit / receive terminal device and store the received voice data in the host database; An automatic call distribution server configured to transmit voice data stored in the host database to a receiver voice transmitting / receiving terminal apparatus of a sender-related person or group stored in the host database according to an instruction of the interactive voice response server; It functions as an interface to the sender's fax, which is connected via wired or wireless network, receives the fax data to be sent to the receiver from the sender's fax, stores it in the host database, and stores the stored fax data in the host database. A fax server for transmitting each of the stored sender-related individuals or groups to a recipient fax; When a specific text message is stored in the host database through a dedicated network, the text message is selected by the sender through the corresponding mobile communication service provider among the plurality of mobile communication service providers. A short message server for transmitting to a receiver voice transmitting / receiving terminal apparatus of a sender-related person or group stored in the host database, respectively; A user interface function for a data terminal device of a sender connected through a network, the character selected by the sender among text data or document data input from the sender's data terminal device, or prestored text data or prestored document data. A web server for storing data or document data in the host database; And Receives and stores the e-mail transmitted from the sender's data terminal device through the web server, and the e-mail address of the recipient of the sender related person or group selected by the sender and stored in the host database. A database synchronization system between a client system and a host system that includes an e-mail server each transmitting to a network. The method of claim 7, wherein The client system A database operating system managing data input / output of the client database; And A client web server which controls the database operating system according to a predetermined data transmission signal, extracts data from the client database, and transmits the data to the host system through a network.