MOLAP Cube Reconstruction via Backup Tables

The patent applies preliminary action by creating a backup copy of the old cube data before deletion. The backup is stored in a backup table with the same structure as the original cube table, preserving all data before any reconstruction operations occur. This ensures that even if database data is lost or corrupted during reconstruction, the original cube data can be restored from the backup, thereby maintaining data integrity while enabling model updates.

The patent extracts only the necessary data for reconstruction from the backup table rather than retrieving all data from the database. The system identifies and extracts only the data that needs to be updated or reconstructed, leaving the rest of the cube data intact in the backup. This selective extraction significantly reduces reconstruction time while maintaining the simplicity of the reconstruction process.

The patent applies beforehand cushioning by creating a backup copy of the old cube data before any deletion or reconstruction operations. The backup table stores a complete copy of the original cube data, serving as a safety cushion against potential data loss. If the reconstruction process encounters issues or if database data is unavailable, the original data can be restored from the backup, preventing data loss while still allowing new cube models to be created.