TW504615B - System using message queue for data reproduction and method thereof - Google Patents

Abstract

The present invention relates to a data reproduction method applicable in a data reproduction system consisting of a main server having a first data, a secondary server having a second data, and a data maintenance server. When the main server uses a database command to change the first data, the database command will be placed into the data maintenance server in a form of queued message. After the secondary server captures the queued message, the second data will be changed in accordance with the database command. The present invention is also applicable in a system having N secondary servers. Then, the number of queued messages stored in the data maintenance server must be N and each queued message must correspond individually to one of the N secondary servers.

Description

504615 V. Description of the invention (1) The present invention relates to data reproduction technology. In particular, it relates to a system and method for copying data obtained by using a message list. * Learning database copying technology is most likely to take a database-to-database approach. However, the conventional method consumes system resources and operation time. Among them, the one that consumes the most system resources is to perform the data :: Check the second part of the change. Again *, most of the applied soft phases today: flat material library 1 is a homogeneous database or material health HQ ^ and for heterogeneous or cross-platform asset libraries, it has not yet provided a better s solution. The method is to provide a variety of data copying methods to avoid data being copied directly from the database. Another object of the present invention is to provide one: only applicable to homogeneous or identical The database of the Umbrella platform, or a non-database format, can be heterogeneous or cross. To achieve the above purpose, the system and method for copying the obtained data of the present invention can be dreamed; 2 offerings; 'a kind of utilization information = evening, shellfish One of the main servers, and one right-handed #trembling one time server, and one data maintenance server. Crying two = one younger two, two. When the main feeder refers to a database;; == gluttony journey, the database command will be different in the form of a message. After the server reads the queue information, the feeding axillary device will change. According to the present invention, it is also applicable to the "枓" order pair system. At this time, it is stored in the data maintenance server. The server's queued message of 35 doors is required.

Page 4

There are N, min% 丨 because the knife type corresponds to one of the N secondary servers. The SQL command is used to execute the data copy according to the present invention. 7If it's a queue of warehouse information, keep it in the queue of the operation data maintenance server, = "Multiple units need to copy the data, we will establish their corresponding department server queue to generate multiple copies to the corresponding ones. Then, for each SQL command, the corresponding queue, and then execute the message queue, 9 can achieve the function of data replication. Therefore, for each servo :, to: ϊ Ϊ standard SQL instructions, so the database does not need to be homogeneous. Because + Beiku has the same data structure, you can perform data recovery: library, Wufei !! According to the data copying party of the present invention, you can achieve heterogeneous assets in . ^ Data copy in the form of soil shell material library (such as 1〇1_ (1 * Excel capital

^ ΡΤ / Dan, but since I was taken away, °: No;: It has not been taken away, it will remain until the second ancestor system, so different feeders can decide when to do it and the advantages can be more Ming drawing style 'for detailed deer! 2 To make the above and other objects and features of the present invention obvious and easy to produce, the following is a special embodiment-a preferred embodiment, and the details are as follows: A brief description of the figure: A first picture shows that it is not a better one according to the present invention. Symbol description of the system architecture diagram of the embodiment: 1 0 ~ main server; C; 14 ~ SQL database 1 7 ~ Word or Exce1 11 ~ server A; 1 2 ~ server B; 1 3 ~ servo '15 ~ SQL database; 16 ~ Oracle database material, and 1 ~ 8 ~ operating data maintenance server.

Page 5 504615 V. Description of the invention (3) 'a " Embodiment: Please refer to FIG. 1, which shows a system architecture diagram according to a preferred embodiment of the present invention. Reference numerals 10, 11, 12, 13 and so on represent server Θ servers, each of which has its own database, such as database 14, 15, 16, 17, and so on. In this example, you want to copy database 1 4 to databases 1, 5, 16, and 7; for the sake of convenience, server 10 is called the master server, and server 1, j, 12, and 13 is divided into server A, server b, and server c. Furthermore, since the present invention can be applied to replication between homogeneous or heterogeneous databases, or non-database forms, databases 14 and 15 in Figure 1 are both SQL databases, database 16 is an Oracle database, The database 17 is based on word or "^^ 丨" data as an example. Oracle is manufactured by Jiawen Company, and wr (^ tExcel is a product of Microsoft Corporation. According to the present invention, it also includes an operation data The maintenance server 丨 8 is for each server A, server B, server C, and stores the corresponding information for each row, which will be described in detail below. According to the figure shown in Figure 1, each server 1 〇- 1 3, 1 8 seems to be based on a hierarchical structure, but this is only for convenience of explanation, and is not intended to limit the present invention. In a broad sense, the connections between the servers 1013 to 18 are implemented by a The Internet works, or it can be said that a network structure is composed of feeders 1 0 -1 3, 1 8. ★ system ^ If you want to copy multiple databases to the SQL database 14 of the main server 10 ' In other words, it is easy for the main server 10 to perform any operation on the SQL database 14 and it is easy to perform operations on the servers 11-13. Library materials do ί 15-17 μ with the movable operation Co. According to the invention, each line of first performing the required sum ,,, ". Consulting configuration language (hereinafter abbreviated to SQL) instructions to add job number

504615

Way, put in the operation data maintenance server 丨 8. Material, divided into the same number of columns. For example, if the database 14 is copied from the data warehouse 15-17, the queue structure in the storage = sub-injector 18 can be as follows: Explore the Beco maintenance servo queue A: jobl. ..... j 〇b 2 ... Queue B: jobl ...... job 2 ......; Queue C: jobl ...... job 2 .. ....; And queue A corresponds to database 15, queue B corresponds to database 16, and rune c corresponds to database 17 and so on. And each j 〇 b even represents a g q [instruction. Subsequently, the server 11-1 3 can, depending on the network connection status, go to the operation data maintenance server 18 to retrieve all the SQL instructions in the corresponding queue. For example, the server 11 retrieves queue A, Server 12 retrieves row 8 and feeder 13 retrieves row C. Then, it performs data maintenance operations on its database according to the sequence number of j ob. For example, server 1 1 The SQL commands represented by j 〇b 1 and j 〇b 2 are sequentially executed, the server 12 executes the SQL commands represented by j 〇b 1 and j 〇b2 sequentially, and the server 13 is executed against the database 1 7 Sequentially execute the SQL commands represented by jobl and job2. According to this, the purpose of data replication can be obtained.

SQL indicates that when copying f data, it is the end of the device to be executed. If / the ancient, "Xi τ way of the 'maintained in the operating data maintenance servo queue, will ^ ^ do shell material copy', we will establish their respective feeders = to the corresponding thanks. Then, the SQL command, that is, the queue of n 1 sub-responders, performs the function of crying and t, 9 in the message queue to copy the information. Therefore, for each server: the standard SQL command, so the data The database does not need to be homogeneous: because 1 ί has the same data structure, the data can be duplicated. Kang Zhifei ^ According to the data copying method of the present invention, heterogeneous resources can be achieved. For example, if the information queue of "wced" is not taken away, it will remain until different feeders can decide when to do it according to their time. Because the data copying method of the present invention is to use Message queues are used for data replication, instead of the conventional method of directly copying data from the database. Therefore, it is not limited to applications on the same platform, as long as the data structure between the platforms is the same, even if available The message box has been copied to the data. The invented data copy method is applied to non-database type (such as Word or Excel) data copy, and the message queue can still be used to retrieve the message queue first (instead of directly executing the SQL command of the message queue) ), The data content in the SQL command corresponds to Word or Ex cel (the corresponding form needs to be established first), and then the data content is retrieved and transferred to the WOR (i or Ex cel form, you can do To data replication. According to the present invention, in addition to reducing the consumption of resources,

504615 V. Description of the invention (6) Achieve data copy for the databases with the same data structure but belonging to heterogeneity. And even when operating on different platforms, data can still be effectively copied. Moreover, if the data copying method of the present invention is applied to the same data structure as defined in Word or Exce 1, the purpose of data copying can also be achieved. Although the present invention has been disclosed in the preferred embodiment as above, it is not intended to limit the present invention. Any person skilled in the art can make changes and retouches without departing from the spirit and scope of the present invention. Therefore, the protection of the present invention The scope shall be determined by the scope of the attached patent application.

Page 9

Claims (1)

504615 Case No. 88109271 Amendment I 6. Scope of patent application 1. A data replication system includes a master server with a first data supplementary server and a second data; a data maintenance server and the The main server and the secondary server are connected to the network; when the main server changes the first data with a database command, the server internal command pair is 2. as in, the 3. as in, the 4 · If yes, this type of information. 5. The data copying system described in item 1 of the scope of patent application, wherein the database instruction is a SQL instruction. A kind of data copying system includes:, the database command inserts the data maintenance in the form of a queue message, and after the queue message is retrieved by the server, a change is made according to the data and the second data. In the data replication system described in item 1 of the scope of patent application, the first data and the second data are homogeneous databases. In the data replication system described in item 1 of the scope of patent application, the first data and the second data are heterogeneous databases. The data replication system described in item 1 of the scope of patent application, one of the data is a database, and the second data is a non-database database. Each has a second data; a data maintenance server connected to the main server and the secondary servers into a network; when the main server changes the first data with a database command, the data The library instructions are placed into the data maintenance server in the form of N queue messages, and the corresponding queue is retrieved by these servers 0213-4428TWFl; RENEE.ptc Page 10 504615 Case No. 88109271 ♦ f month > _. Day 丨 .. d. Amendment VI. After applying for patent coverage information, make changes to the second data according to the instructions of this database. 7. The data replication system described in item 6 of the scope of patent application, wherein the first data and the second data are homogeneous databases. 8. The data replication system as described in item 6 of the scope of patent application, wherein the first data and the second data are heterogeneous databases. 9. The data copying system described in item 6 of the scope of patent application, wherein the first data is a database and the second data is a non-database data. 10. The data copying system as described in item 6 of the scope of patent application, wherein the database instruction is a SQL instruction. 11. A data copying method suitable for a network constructed by a master server having a first data, a primary server having a second data, and a data maintenance server; the data copying method includes: The main server changes the first data with a database command; puts the warehouse command into the lean material maintenance temple server in the form of a penning column message; and waits for the server to retrieve the card After the messages are listed, the second data is changed according to the database instruction. 1 2. The method of copying data as described in item 11 of the scope of patent application, wherein the first data and the second data are homogeneous databases. 1 3. The data copying method as described in item 11 of the scope of patent application, wherein the first data and the second data are heterogeneous databases. 14. The method for copying data as described in item 11 of the scope of patent application, wherein the first data is a database and the second data is a non-database :1 0213-4428TWFl; RENEE.ptc Page 11 504615 _Case No. 88109271 Amendment_ VI. Scope of Patent Application-Not n 丨 form of information. 1 5. The data copying method as described in item 11 of the scope of patent application, wherein the database instruction is a SQL instruction. 16. A data copying method suitable for a network constructed by a primary server having a first data, N secondary servers each having a second data, and a data maintenance server; the The data copying method includes: the main server changes the first data with a database command; the database command is divided into N queue messages into the data maintenance server; and After the secondary server retrieves the corresponding queued information, it changes the second data according to the database command. 1 7. The data copying method described in item 16 of the scope of patent application, wherein the first data and the second data are homogeneous databases. 1 8. The data copying method as described in item 16 of the scope of patent application, wherein the first data and the second data are heterogeneous databases. 19. The method of copying data as described in item 16 of the scope of patent application, wherein the first data is a database and the second data is a non-database data. 20. The data copying method described in item 16 of the scope of patent application, wherein the database instruction is a SQL instruction. 0213-4428TWFl; RENEE.ptc Page 12