Data Warehouse and its Trends Driving the Revolution

This paper exhibits information related to data warehouse and its trends. Data warehouse is one of the hot topics in computer technology application. It's a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.The term "data warehouse" itself might still endure, the demands of today's always-on global economy have shattered that old-fashioned metaphor of a limited-access and static warehouse and have inspired leading companies to think instead of relentlessly enriching their data, accelerating it, manipulating it, and ensuring it gets into the hands of as many relevant people as possible. The significance of these changes is that just as manufacturing and logistical prowess were once indispensable qualities of leading businesses, today's battles for competitive advantage will be won by those companies with superior capabilities in business analytics, the democratization of data encompassing not just employees but also partners and customers, and the ability to turn Big Data into Big Opportunities.In the spirit of capturing and describing this data-warehouse revolution, this paper highlights the most noteworthy trends such as On-demand analytics environments meet the growing demand for rapid prototyping and information discovery ,In-database analytics simplify analysis, Database platforms support mixed workloads.