Chapter 11 - Chapter 11. Warehousing Software A warehousing...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 11. Warehousing Software A warehousing team will require several different types of tools during the course of a warehousing project. These software products generally fall into one or more of the categories illustrated in Figure 11-1 and described below. Figure 11-1 Data Warehouse Software Components Extraction and transformation. As part of the data extraction and transformation process, the warehouse team requires tools that can extract, transform, integrate, clean, and load data from source systems into one or more data warehouse databases. Middleware and gateway products may be required for warehouses that extract data from host-based source systems. Warehouse storage. Software products are also required to store warehouse data and their accompanying metadata. Relational database management systems in particular are well suited to large and growing warehouses. Data access and retrieval. Different types of software are required to access, retrieve, distribute, and present warehouse data to its end users. Tool examples listed throughout this chapter are provided for reference purposes only and are by no means an attempt to provide a complete list of vendors and tools. The tools are listed in alphabetical order by company name; the sequence does not imply any form of ranking.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Also, many of the sample tools listed automate more than one aspect of the warehouse back-end process. Thus, a tool listed in the extraction category may also have features that fit into the transformation or data quality categories. Middleware and Connectivity Tools Connectivity tools provide transparent access to source systems in heterogeneous computing environments. Such tools are expensive but quite often prove to be invaluable because they provide transparent access to databases of different types, residing on different platforms. Examples of commercial middleware and connectivity tools include: IBM. DataJoiner Oracle. Transparent Gateway SAS. SAS/Connect Sybase. Enterprise Connect Extraction Tools There are now quite a number of extraction tools available, making tool selection a potentially complicated process. Tool Selection Warehouse teams have many options when it comes to extraction tools. In general, the choice of tool depends greatly on the following factors: The source system platform and database. Extraction and transformation tools cannot access all types of data sources on all types of computing platforms. Unless the team is willing to invest in middleware, the tool options are limited to those that can work with the enterprise's source systems. Built-in extraction or duplication functionality. The source systems may have built-in extraction or duplication features, either through application code or through database technology. The availability of these built-in tools may help reduce the technical difficulties inherent in the data extraction process.
Background image of page 2
The batch windows of the operational systems.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

Chapter 11 - Chapter 11. Warehousing Software A warehousing...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online