Analytical processing databases are not very normalized. The operations which are used are read most databases. It is used to extract the data that are ancient and accumulated over long period of time. For this purpose de-normalization occurs that provide smart BUSINESS applications. Dimensional tables in star schema are good example of de-normalized data. The de-normalized form must be controlled while extracting, transforming, loading and processing. There should be constraint that user should not be allowed to view the STATE till it is CONSISTENT. It is used to INCREASE the performance on many SYSTEMS without RDBMS platform.

Analytical processing databases are not very normalized. The operations which are used are read most databases. It is used to extract the data that are ancient and accumulated over long period of time. For this purpose de-normalization occurs that provide smart business applications. Dimensional tables in star schema are good example of de-normalized data. The de-normalized form must be controlled while extracting, transforming, loading and processing. There should be constraint that user should not be allowed to view the state till it is consistent. It is used to increase the performance on many systems without RDBMS platform.