Data warehouse, data mart and business intelligence Essay - 1

Data warehouse, entropy mart and business intelligence - Essay Exampleique info structure that allows comparatively rapid and untroubled performance of big and complex queries over large amounts of data (Business Intelligence Secrets, 2012).Additionally, the data warehouse is make to support the business intelligence tasks and conclusiveness support systems of an organization. However, the data warehouse is developed on the root of relational database that supports queries and reporting instead of traditional business feat 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 some other concept link up to business intelligence known as data mart, it is a busines s decision support structure that integrates data from different sources and focuses on major processes or tasks of the business. In addition, the data marts grasp exact business related processes and principles like that forecasting sales, determining performance and twist 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 reorient with specific company motives, system requirements and planning and analysis are performed in an effective manner and as a result implementation, design, installation and testing are less expensive as compared to data warehouses (Demarest, 1993 Firesto ne, 1997).In addition, they can be developed rapidly and they are