<P> A data warehouse maintains a copy of information from the source transaction systems . This architectural complexity provides the opportunity to: </P> <Ul> <Li> Integrate data from multiple sources into a single database and data model . Mere congregation of data to single database so a single query engine can be used to present data is an ODS . </Li> <Li> Mitigate the problem of database isolation level lock contention in transaction processing systems caused by attempts to run large, long running, analysis queries in transaction processing databases . </Li> <Li> Maintain data history, even if the source transaction systems do not . </Li> <Li> Integrate data from multiple source systems, enabling a central view across the enterprise . This benefit is always valuable, but particularly so when the organization has grown by merger . </Li> <Li> Improve data quality, by providing consistent codes and descriptions, flagging or even fixing bad data . </Li> <Li> Present the organization's information consistently . </Li> <Li> Provide a single common data model for all data of interest regardless of the data's source . </Li> <Li> Restructure the data so that it makes sense to the business users . </Li> <Li> Restructure the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the operational systems . </Li> <Li> Add value to operational business applications, notably customer relationship management (CRM) systems . </Li> <Li> Make decision--support queries easier to write . </Li> <Li> Optimized data warehouse architectures allow data scientists to organize and disambiguate repetitive data . </Li> </Ul> <Li> Integrate data from multiple sources into a single database and data model . Mere congregation of data to single database so a single query engine can be used to present data is an ODS . </Li> <Li> Mitigate the problem of database isolation level lock contention in transaction processing systems caused by attempts to run large, long running, analysis queries in transaction processing databases . </Li>

Explain the data warehousing architecture with suitable diagram