Data-change-driving execution system and execution method
View Patent ↗A data-change-driving execution system and a data-change-driving execution method are provided. The data-change-driving execution system of the disclosure includes a storage device and a processor. The processor is configured to capture changing data in a target database, the processor obtains event information corresponding to the changing data according to the data matching rule, and the processor outputs the event information, so that a message server executes a corresponding process according to the event information. In this way, the data-change-driving execution system and the data-change-driving execution method use fewer system resources to timely perceive a target system, and drive the corresponding process according to the changing data.
1 . A data-change-driving execution system, comprising:
a storage device, configured to store a data matching rule; and
a processor, coupled to the storage device,
wherein the processor captures modified data in a target database, and the processor obtains event information corresponding to the modified data according to the data matching rule, wherein the modified data is a difference between a data before and after each of modifications in the target database,
wherein the processor outputs the event information;
wherein the storage device stores an event converter, and the processor executes the event converter,
wherein the modified data comprises a modified entity and a modified type, and the event converter obtains corresponding event information from the data matching rule according to the modified entity and the modified type;
wherein the event converter obtains a corresponding scenario rule from the data matching rule according to the modified entity, the event converter obtains a corresponding rule from the scenario rule according to the modified type, and the event converter matches out the corresponding event information from the corresponding rule according to modified content of the modified data;
wherein the storage device stores a data change capturing module, the processor executes the data change capturing module,
wherein the data change capturing module analyzes a log in the target database to capture the modified data;
wherein the data change capturing module is disposed on a same server as the target database, and the data change capturing module captures the modified data in the target database through an access operation,
wherein the data change capturing module converts the modified data into a default format according to a format rule, and the data change capturing module outputs converted modified data to the event converter,
wherein the data change capturing module is a trigger, and the log is a binlog.
2 . The data-change-driving execution system according to claim 1 , further comprising: a message server coupled to the processor, wherein the message server receives the event information, and the message server executes a process corresponding to the event information according to the event information, wherein the process comprises at least one of submitting information, outputting notification information, modifying data, updating data, and recording information.
3 . A data-change-driving execution method, comprising:
capturing modified data in a target database by a processor, wherein the modified data is a difference between a data before and after each of modifications in the target database;
reading a data matching rule stored in a storage device by the processor;
obtaining event information corresponding to the modified data by the processor according to the data matching rule; and
outputting the event information by the processor;
wherein the storage device stores an event converter, and the processor executes the event converter,
wherein the modified data comprises a modified entity and a modified type,
wherein obtaining the event information by the processor according to the data matching rule comprises:
obtaining corresponding event information from the data matching rule by the event converter according to the modified entity and the modified type;
wherein obtaining the event information by the processor according to the data matching rule further comprises:
obtaining a corresponding scenario rule from the data matching rule by the event converter according to the modified entity;
obtaining a corresponding rule from the scenario rule by the event converter according to the modified type; and
matching out the corresponding event information from the rule by the event converter according to modified content of the modified data;
wherein capturing the modified data in the target database by the processor comprises:
analyzing a log in the target database by a data change capturing module to capture the modified data;
wherein the data change capturing module is disposed on a same server as the target database, and the data change capturing module captures the modified data in the target database through an access operation,
wherein capturing the modified data in the target database by the processor comprises:
converting the modified data into a default format by the data change capturing module according to a format rule, and outputting converted modified data to the event converter by the data change capturing module,
wherein the data change capturing module is a trigger, and the log is a binlog.
4 . The data-change-driving execution method according to claim 3 , further comprising:
receiving the event information through a message server, so that the message server executes a process corresponding to the event information according to the event information,
wherein the process comprises at least one of submitting information, outputting notification information, modifying data, updating data, and recording information.