DATABASE COOPERATING SYSTEM AND DATABASE COOPERATING PROGRAM

摘要

To enable databases to be integrated by creating a cleansing definition interactively without depending on a batch processing and performing cleansing in real time.;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.

主权项

1. A database cooperating system in which data of tables stored in databases are integrated to construct a virtual database, thereby performing cooperation between the databases, the system comprising:
a designating operation accepting unit for accepting an operation for selecting any of the tables constituting the databases to display a cleansing screen having an interface capable of performing a user operation and accepting an operation for designating a data item of a processing target, a function for conversion of a data granularity, and a parameter to be used for the function respectively through the cleansing screen; a cleansing executing unit for generating an SQL sentence based on a designated content accepted by the designating operation accepting unit, executing a cleansing processing for the selected table in accordance with the SQL sentence and previewing a result of the execution on the cleansing screen; and a virtual table saving unit for saving SQL defining the cleansing processing as a virtual table in a storing unit.