Abstract: A method and apparatus that catalogs the characteristics and scheduling of multiple ETL procedures or processes as the multiple ETL procedures extract, transform data from a first database to load the data to a second database. The method and apparatus catalogs the progress and success of execution of multiple ETL procedures. The method and apparatus determines the necessary scheduling for cleansing operations of the first database, then initiates the cleansing operation of the first database, and then catalogs the progress of a cleansing process performed on a database to eliminate inconsistencies, redundancies, and corruptions of the database. The method and apparatus determines any errors in the execution of the ETL procedures and transmits an error message describing the errors to a person.

Abstract: An interactive data processing system and/or method is a management tool for a manufacturing plant including a shop floor control system. A server contains a data engine for extracting data, a load and transform data unit, and a database management storage unit. Data from the shop floor control system is supplied to the data engine in the server. The data engine can run the shop floor control system. The data engine supplies data received from the shop floor control system to the load and transform data unit. The load and transform data unit supplies data to the database management storage unit where the data is stored in a disk storage unit in storage space allocated to a conventional database management system employed for the purpose of management of data. The database management storage unit supplies data to an interactive graphic user interface.