Database linkage system and database linkage program

摘要

There are provided a designating operation accepting unit 11 for accepting a designation of a data item of a processing target, a function for converting a data granularity, and a parameter to be used for the function respectively in relation to a selected table, a cleansing executing unit 12 for generating an SQL sentence based on a designated content and executing a cleansing processing in accordance with the SQL sentence, and previewing a result of the execution, and a virtual table saving unit 13 for saving SQL defining the cleansing processing as a virtual table in a storing unit 20, and a user can create a proper cleansing definition while optionally designating a data item, a function and a parameter and confirming an execution result of the cleansing processing based on the designated content through preview.