Data integration flows for business intelligence

14 years 1 months ago
Data integration flows for business intelligence
Business Intelligence (BI) refers to technologies, tools, and practices for collecting, integrating, analyzing, and presenting large volumes of information to enable better decision making. Today’s BI architecture typically consists of a data warehouse (or one or more data marts), which consolidates data from several operational databases, and serves a variety of front-end querying, reporting, and analytic tools. The back-end of the architecture is a data integration pipeline for populating the data warehouse by extracting data from distributed and usually heterogeneous operational sources; cleansing, integrating and transforming the data; and loading it into the data warehouse. Since BI systems have been used primarily for off-line, strategic decision making, the traditional data integration pipeline is a oneway, batch process, usually implemented by extract-transformload (ETL) tools. The design and implementation of the ETL pipeline is largely a labor-intensive activity, and typic...
Umeshwar Dayal, Malú Castellanos, Alkis Sim
Added 19 May 2010
Updated 19 May 2010
Type Conference
Year 2009
Where EDBT
Authors Umeshwar Dayal, Malú Castellanos, Alkis Simitsis, Kevin Wilkinson
Comments (0)