TW425514B - E-mail driving data exchange method - Google Patents

Abstract

The present invention relates to an e-mail driving data exchange method that can perform data exchange on cross-domain databases. It aims mainly, while exchanging databases, to packet the required structured query language (SQL) command into an executable command before transmitting the command in a form of e-mail from the local end to a remote end through a network. When the remote end receives the e-mail, it will identify the command as a database updated data and voluntarily execute the command so as to duplicate or update the database.

Description

4 2551 4 V. Description of the Invention (1) The present invention relates to a method for data exchange, and in particular, to a method for driving data exchange using e-mail. At present, in the application of database, relational database is becoming more and more popular and popular. A relational database management system (DBMS) can be roughly defined as follows: (1) All data in the database are stored in tables. (2) Represent data in a logical way, without having to worry about how the data is stored. (3) Use a high-level language to structure, query, and modify the information in the database morning. (4) It should be able to provide the main Θ related operations such as selection 'projection, join, and set operations such as union' intersection 'difference' division. (5) It is necessary to support the view function, so that the user can query the data in the data table in a customized manner. (6) There must be a method for distinguishing the unknown value (nu L 丨 s) and 0 or blank. (7) Provide methods on integrity, authori z a t i on, transaction, and data reply. As for the aforementioned high-level languages, theoretically all database languages can do the aforementioned actions, but SQL (structured Query Language) is most suitable for relational databases. SQL is used for data operation (acquisition and change), data definition, and data management. Each data acquisition, change, definition, or management action is represented by SQL statements or commands. In the foregoing, data operations can be divided into two types: data acquisition and data changes. Among them, " Get " means finding the specific data you want; " Changes " means adding, deleting or modifying data.

0213-4566TW-ptd

Page 4 4 2551 4,

V. Description of the invention (2) When the database needs to be copied, in addition to backup, there may be two database servers (DB servers) that need to copy or update data across the network domain. At this time, you can use The first method is to directly perform a one-way database transfer (database transfer), which will transfer the database once every… some time, but this method will consume more network bandwidth. In addition, it is on both sides of the two DB servers Establish a trust relationship between domains), if the servers on both sides can directly see each other's information, but this way, because each other can also directly modify each other's information, there will be security concerns. 〇 Moreover, 'regardless of Taking the above-mentioned method 'in addition to occupying more network bandwidth', the stability of the network connection will also affect the update of the database, that is to say * when the database from one end passes through the network, such as Agreement, when copying or updating data on the other end of the database, if the network is interrupted during the data update process, it will cause data update problems. Unless the progress of the update is recorded separately, the update process must be restarted. Secondly, the purpose of the present invention is to propose an email-driven > parent-for-data exchange method, which can be used for cross-domain databases Change without the aforementioned shortcomings of the current technology.

In order to achieve the above purpose, the present invention mainly exchanges the database with%. The required SQL command is packaged into an executable command, and then transmitted from the local end to the remote end in the form of email through the network. After the email is received, it is identified as the database update data, and the initiative is executed to copy or update the database. In order to further describe the method, architecture and features of the present invention,

V. Description of the Invention (3) The preferred embodiment will be described with reference to the accompanying drawings, wherein FIG. 1 is a block diagram showing a system of an email method according to the present invention. Moving Material Exchanger FIG. 2 is a diagram showing SQL instructions for explaining the electronic exchange method of the present invention.卞 Mail-driven data transfer Figure 3 is the executable Sql reference figure of Figure 2 above. 7 Results after implementation Reference symbol description 1 Data exchange engine, 1 2 worksheet, [4 capital

P library, 16 database, 18 SQL storage, 20 data sending, meaning, description of the embodiment, device. Please refer to the first circle. The e-mail-driven system of the present invention includes a data exchange engine 10, a worksheet 12, a 'definition database 14, a database i6, a SQL repository 18' and a data transmission device 20 '. Among them, the above-mentioned data exchange engine 10 is the control center of the entire data exchange. After obtaining the task from the work form 12, it first goes to the definition database 丨 4 to obtain the definition of data exchange, and then to the database 16 to obtain the parent exchange. The actual database, then go to the SQL repository 18 to obtain the required SQL protection order, package the data exchange definition and the database to be exchanged, so that it becomes an executable SQL command, execute this 8 command The action of material exchange on the database. Then, send this executable command to the database to be exchanged by e-mail. Upon receiving this email, the database will first determine the content of the email, and after confirming that it contains executable SQL and orders, it will automatically execute the SQl instruction for data 425514,

Of course, the above-executable ^ instruction can also use the DCOM (DiStributing c〇mm〇n 〇bject 'Common Object Management), which can be directly transmitted from one database line to another. Next, please refer to Figure 2, An example is used to describe the executable SQL instructions in the e-mail-driven data exchange method. In accordance with the above description of the operation of the data exchange engine, it can be seen from Fig. 2 that when the data exchange engine obtains work, first, the data transfer definition is obtained, as indicated by the reference numeral 100. 5. Explanation of the invention (4) Exchange.

DatabaseName Src = 00ERPDB DatabaseNaine Trg = 00ERPDB

TableName Src = ABCStMatICategory TableName Trg ^ ABCStMatICategory The next step is to get the database, as indicated by the number 1 02. sABCCategory = ABCCategory iCycleCuntPrd = CycleCuntPrd cCostPerceat = CostPercent sLatelyChangedDate = LatelyChangedDate sLatelyChangedUser = LatelyChangedUser

sDataOwner = DataOwner sDataOwnerGroup ^ DataOwnerGroup sCreateDate = CreateDate sIsDataEffID = IsDataEffID Next, the SQL command is fetched from the SQL repository ’as shown in Figure 2

I

戽 2 5 5 1 "5. Indicated by the index k 1 0 4 of the invention description (5). SQL = Insert into ABCStkMat1Category (ABCCategory, Cyc1eCuntPrd, CostPercent, Late1yChangedDate, LatelyChangedUser, Da taOwner, DataOwnerGroup, CreateDate, IsDataEffID) Value : sABCCategory ,: i Cyc1eCuntPrd,: cCostPercent, isLatelyChangedDate,: sLatelyChangedUser,: sDataOwner,: sDataOwnerGroup,: sCreateDate,: s I sDataE f fID) Then, package the data exchange definition with the data to be exchanged into an executable SQL instruction As indicated by reference numeral 106 in FIG. 2.

Insert into ABCStkMat1 Category (ABCCategory,

Cyc1eCuntPrd, CostPercent, LatelyChangedDate, LatelyChangedUser, DataOwner, Dat aOwnerGroup, CreateDate, IsDataEffID) Values (" A ", 15, 85, " 09/25/1 998 AM 09: 30: 53 ", " guest11, " guest ", " guest ", " 09/25/1998 AM 09: 30: 53 ", " Y ")

Insert into ABCStkMat1 Category (ABCCategory, CycleCuntPrd, CostPercent, LatelyChangedDate, LatelyChangedUser, DataOwner, DataOwnerGroup, CreateDate, IsDataEffID) Values (" B ", 30, 40,, 01/01/1900 ", " 01/0 1 / 1 90 0 ", " Y ")

Insert into ABCStkMat1 Category (ABCCategory,

Cyc1eCuntPrd, CostPercent, LatelyChangedDate, LatelyChangedUser, DataOwner, DataOwnerGroup,

Page 8 4 2 551 4 · V. Explanation of the invention (6)

CreateDate, IsDataEffID) Values (" CM, 90, 20, 01/01/1900 ", ""," ", ", " 〇1 / 〇1 / 19〇〇 ", τ) Now In order to execute the 2SqL instruction, this instruction can be e-mailed to the database to be exchanged. After the execution, it will produce a result that is not shown in Figure 3. The method of the present invention can be used in the data. Data exchange between the warehouses The data to be exchanged is made into executable SQL commands, no need to be-directly occupied, you can avoid the process of = material exchange. The data exchange is electronic mail; waste of bandwidth. Xibu, because it does not need to worry about holding the lights and instructions in the process of data exchange, so in the method of the invention described above, the problem of instability or interruption. A microprocessor running a specific program. The above data exchange engine can be An enforcement library and the above-mentioned SQL repository are used to store the above-mentioned database, the above-mentioned data exchange or hard disk, etc. As for the above-mentioned resources in the storage device, such as a memory communication device.

Claims (1)

(·. ~ An e-mail-driven resource exchange method, including the following steps: Data ^) Utilizing a data exchange engine to generate an executable instruction based on the data to be exchanged in the first database; sending it to the above Executable instructions are transmitted to the second database by e-mail, and the instructions are executed to enter the data exchange. Method, the second email application-driven data exchange party of the first patent application scope 3, and the above-mentioned executable command is a SQL command. Law, which is the first email-driven data exchange party applying for patent scope The method 4 ^, in step (i) above, the data exchange engine generates executable instructions & includes the following steps: get the data ^ After she has obtained the form, she first goes to the data exchange definition database to get the τ parent for the definition; SQL · Obtain the actual database to be exchanged, and obtain the required database. (Continuing & packaging the above data exchange definition and the data to be exchanged will become an executable SQL instruction. 4Grant a patent The email-driven data exchange party of the first item of scope, ", the above data exchange engine is a micro-processor that executes a specific program: Page 10