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...

• Type: Conference
• Year: 2009
• Where: EDBT
• Authors: Umeshwar Dayal, Malú Castellanos, Alkis Simitsis, Kevin Wilkinson
• Keywords: Data Integration, Data Integration Pipeline, Data Warehouse, Database, EDBT 2009