Data warehousing

The segregation of write and read schema or databases fit well with data warehousing [] - i.e. a system used for reporting and data analysis.

One of the important features of data warehousing is caching aggregates [] over the data.

Note that it's common for data sent to a data warehouse to require data cleansing []

This is the process of detecting and correcting/removing corrupt or inaccurate records from a record set, table, or database and refers to identifying incomplete, incorrect, inaccurate or irrelevant parts of the data and then replacing, modifying, or deleting the dirty or coarse data.