Business Rules Influenced Quasi-Cubes with Higher Diligence of Data Optimization

摘要

The present specification relates to data warehousing, and, more specifically, to systems and methods for optimizing the preparation and use of data cubes (a/k/a quasi-cubes) based on inputs such as particular rules/decisions designed to appropriately size the cubes by effectively removing the static piling of unwarranted dimensions from the each instance/cycle of aggregated schema which are used for neither analysis nor by business intelligence reporting.

主权项

1. A computer implemented method for optimizing the preparation and use of a data cube, the method comprising:
providing a data cube containing data stored in dimensions with a first configuration; inputting at least one of master source data, past refreshed cube data, dimension pattern distribution data, business specific driver data, and data cube usage data to a rules/decisions module; analyzing said at least one of master source data, past refreshed cube data, dimension pattern distribution information, business specific driver data, and data cube usage data by said rules/decisions module; developing rules and/or decisions based on said step of analyzing by said rules/decisions module; and reconfiguring said data cube to a second configuration based on the application of said rules and/or decisions by said rules/decisions module.