Data warehouse, data mart and business intelligence Essay - 1

Data warehouse, data mart and business intelligence - Essay Example ique data structure that allows comparatively rapid and trouble-free performance of big and complex queries over large amounts of data (Business Intelligence Secrets, 2012). Additionally, the data warehouse is built to support the business intelligence tasks and decision support systems of an organization. However, the data warehouse is developed on the basis of relational database that supports queries and reporting instead of traditional business transaction processing. Moreover, it typically holds historical data resulting from transaction data; as well it can gather data from other corporate sources. Also, it divides bossiness analysis workload from corporate operations workload and allows a business to merge data from numerous sources (Oracle Corporation, 2002; Einbinder, Scully, Pates, Schubart, & Reynolds, 2001). There is another concept related to business intelligence known as data mart, it is a business decision support structure that integrates data from different sources and focuses on major processes or tasks of the business. In addition, the data marts encompass exact business related processes and principles like that forecasting sales, determining performance and influence of marketing promotions, assessing the influence of new product launching on business income or calculating and forecasting the working of a new business division or department. In fact, data marts are strictly business related software systems. Though, data marts can capture large amounts of data, even hundreds of gigabytes, but it cannot be larger than the data warehouse, which is also used by similar businesses. On the other hand, data marts are more aligned with specific company motives, system requirements and planning and analysis are performed in an effective manner and as a result implementation, design, i nstallation and testing are less expensive as compared to data warehouses (Demarest, 1993; Firestone, 1997). In addition, they can be developed rapidly and they are