Applications developed using Nucleus technology can automatically update a data warehouse.

Each Nucleus application generates a real-time transaction record documenting any changes in the data as well as date, time, user, port, account, file and ID of each record modified.

Real-time transaction records can be processed to.

• Roll-out the “before” data from a data warehouse
• Roll-in the modifications data
• Update data warehouse repositories under IBM MITS with Blade technology
• Update Business Intelligence applications (BI)
• Update Oracle, DB2 or other databases
• Other "replication" facilities

As transaction records provide both before and after conditions of changed fields, update and rollbacks are easy to implement. On-line, real-time data-warehouse information is easily achieved with Nucleus technology.

Nucleus technology – Accelerating change