These documents provide a general overview of IBM® InfoSphere® Warehouse.
- InfoSphere Warehouse V9.7.3 Announcement: This website announces InfoSphere Warehouse V9.73 and includes the full announcement letter in PDF format. The announcement letter includes introductory and planning information for InfoSphere Warehouse. It also describes the new features in V9.7.3.
- Data Warehousing and Analytics: This website provides an overview of data warehousing and analytic solutions, from traditional multidimensional and data mining to mashups and high-speed streaming.
- InfoSphere Warehouse Product page: This website provides an overview of InfoSphere Warehouse, a complete data warehousing platform that delivers superior scalability and availability, design, build, and management tooling, and business analytics.
- InfoSphere Warehouse forum: This community forum provides a place to discuss topics of interest to developers and users of InfoSphere Warehouse.
- IBM Smart Analytics System: This website provides an overview of the IBM Smart Analytics System.
These documents provide information about how to install InfoSphere Warehouse.
- Installing InfoSphere Warehouse: This is the starting point for installing and configuring InfoSphere Warehouse.
- InfoSphere Warehouse installation requirements: This page links to the hardware and software requirements for the installation launchpads, data warehouse server, application server, and InfoSphere Warehouse clients.
Tutorials and samples
You can explore InfoSphere Warehouse by following the tutorials. The tutorials use sample data in sample projects that are ready to run in your environment.
- SQL Warehousing tutorial: This tutorial teaches you the basics of SQL warehousing, including how to create a physical data model, data flows that transform your data, control flows that run your data flows, and how to deploy a data warehouse application.
- Cubing Services tutorial: This tutorial teaches you the basics of cubing and how Cubing Services can simplify and expedite queries against your database. You will design and deploy a data model, complete with a sales cube model and the SalesCube.
- Mining tutorial: This tutorial teaches you how to design mining flows and visualize the patterns that mining models discover. You will also learn how to deploy your mining models to a production environment and schedule them to run regularly.
- Sample data: InfoSphere Warehouse provides a sample database that contains sales information for a fictional company and a sample Cubing Services cube that contains sample sales and marketing metadata.
- Trials and demos: This website provides links to the InfoSphere Warehouse free trial and a demo.
- "Text analysis in InfoSphere Warehouse, Part 1: Architecture overview and example of information extraction with regular expressions:" This article provides an architecture overview of the text analysis capabilities in InfoSphere Warehouse and shows how to use regular expressions to extract concepts from free-form (unstructured) text.
- "Text analysis in InfoSphere Warehouse, Part 2: Dictionary-based information extraction combined with IBM Cognos reporting:" This article provides an overview of how to use dictionaries for concept extraction and how to use taxonomies to structure them. It also explains how you can present the results in an interactive IBM Cognos® report.
- "Text Analysis in InfoSphere Warehouse, Part 3: Develop and integrate custom UIMA text analysis engines:" This article describes how to use the Unstructured Information Management Architecture (UIMA) framework to create a custom text annotator and use it in InfoSphere Warehouse.
Use these resources to find information to help you develop the data flows, control flows, and mining models that make up a data warehouse application.
- Designing a data flow: This topic explains how to design and create data flows.
- Designing control flows: This topic explains how to design and create control flows.
- Designing cube models and cubes: This topic provides information about how to design a complete OLAP model with InfoSphere Warehouse metadata objects. A complete OLAP model documents the relationships that exist within your relational data.
- Designing mining flows: This topic provides information about how to design and create mining flows.
Use these resources to help you deploy data warehouse applications.
- Deploying control flows: This topic provides an overview of data warehouse application deployment and delta deployment, and also links to detailed information.
- Managing OLAP and cubing administration tasks: This topic provides information about using the Design Studio to import and export metadata objects to your data design project or your InfoSphere database.
- Deploying your mining flow: This topic explains how you can generate code from your mining flows so that you can deploy them with your business applications or reporting tool of choice.
These documents provide information about how to best administer InfoSphere Warehouse to meet your needs.
- "Getting started and setting up:" This article provides detailed information about setting up the Administration Console.
- Administering control flows: This topic explains how to update, enable, disable, and uninstall the data warehouse applications you deploy.
- Managing metadata: This topic explains how to create, modify, and drop database metadata objects.
- Creating database connections: This topic explains how to define the database connections for InfoSphere Warehouse.
- Creating system resources: This topic explains how to create the system resources for InfoSphere Warehouse.
You can use the InfoSphere Warehouse Design Studio to control and manage the workloads in your warehouse database.
- Managing database work: The InfoSphere Warehouse Design Studio supports the ongoing development, refinement, validation, and monitoring of a workload management solution called a workload management scheme.
IBM offers education that is tailored to help you to learn, install, and use InfoSphere Warehouse.
- Certification exam for InfoSphere Warehouse solution designer: This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to perform the intermediate and advanced skills required to design, develop, and support InfoSphere Warehouse V9.5 applications.
- Classes for InfoSphere Warehouse: A series of online courses on InfoSphere Warehouse components, including the SQL Warehousing Tool, Cubing Services, Data Mining, and Text Analysis.
Administrators of InfoSphere Warehouse should be familiar with relational database management systems and understand how the InfoSphere Warehouse product components work. These topics provide an overview of the InfoSphere Warehouse product components.
- Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services: This Redbooks describes a multidimensional data warehousing infrastructure that can enable solutions for complex problems in an efficient and effective manner.
- Enabling Robust Business Analytics with InfoSphere Warehouse Cubing Services: This Redbooks describes how you can develop an environment that will enable you to perform more detailed analytics on your data and turn it into powerful information and business insight for making better informed decisions.
- InfoSphere Warehouse: Cubing Services and Client Access Interfaces: This Rebooks provides a brief overview of InfoSphere Warehouse, with the primary objective of describing the capabilities of InfoSphere Warehouse Cubing Services.
- InfoSphere Warehouse Cubing Services Cube Server – Best Practices: This white paper explores the performance, scalability, and sizing characteristics of the cube server for InfoSphere Warehouse Cubing Services.
- Dynamic Warehousing: Data Mining Made Easy: This Rebooks describes the methodology and selected techniques of embedded data mining and shows how sophisticated technologies can be used in today's business environment to create significant business value.
When a problem occurs, you must determine the scope of the problem and which InfoSphere Warehouse product components are involved. The resources in this section provide information about identifying and solving problems.
- IBM Software Support for InfoSphere Warehouse: This website provides links to documents that can help you solve problems with InfoSphere Warehouse. These self-help documents include frequently asked questions (FAQs), hints and tips, Technotes, and IBM Redbooks®. From this website, you can submit and track problems, read the latest product flashes and announcements, and download fixpacks.
- IBM Software Support for DB2 for Linux®, UNIX®, and Windows®: This website provides links to documents that can help you solve problems with DB2. These self-help documents include Frequently ask questions (FAQs), Hints and tips, Technotes, and IBM Redbooks. From this website you can submit and track problems, read the latest product flashes and announcements, and download fix packs.