| 摘要 |
PROBLEM TO BE SOLVED: To inexpensively and efficiently update, according to the change of corporate information in a certain information processing apparatus, the duplication data of corporate information to be used by the other information processing apparatus.SOLUTION: A corporate information update processing system 10 includes: a definition file specification part 110 for retrieving a cooperative processing definition file by using table identification information shown by change data as a key, and for specifying the cooperative processing definition file concerning a change object table; a record retrieving part 111 for reading a conditional formula from the cooperative processing definition file specified concerning the change object table, and for retrieving update object records matched with the conditional formula from the pertinent table; and an SQL issuing part 112 for generating an SQL sentence for record update including a sentence designating the change object table as the object of processing, a sentence using the data of prescribed items included in the update object records as a conditional formula for record selection, and a sentence designating a field name included in change data and a set value to the pertinent field, and for issuing the SQL sentence to a relational database management system. |
