<html>
<head>
	<title></title>
</head>
<body>
<p>&nbsp;</p>

<p>
<video controls="" height="420" width="640"><source src="uploads/Data-Encrption.mp4" type="video/mp4" /></video>
</p>

<p><strong>Benefits of data warehouse</strong></p>

<p>&nbsp;</p>

<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. More congregation of data to single database so a single query engine can be used to present data in 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&rsquo;s information consistently.</li>
	<li>Provide a single common data model for all data of interest regardless of the data&rsquo;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&ndash;support queries easier to write.</li>
	<li>Organize and disambiguate repetitive data.</li>
</ul>
</body>
</html>
