Cognos 8 BI leverages Teradata data warehouse technology across clients, servers and the Web on Windows, UNIX and Linux platforms.
Key integration points
- Cognos software leverages the TERADATA OPTIMIZER to automatically generate version-specific, optimized, and native Teradata SQL.
- Cognos tools are 100% schema-neutral (3NF, Snowflake, STAR) and leverage Teradata's high-performance normalized models and supporting performance optimizing techniques such as Soft Referential Integrity, Join Indexes, Aggregate Join Indexes, Partitioned Primary Indexes and more.
- Use any combination of LDAP, OS or RDMS security. SSL protocol ensures secure delivery outside the firewall.
- Produce native queries using Teradata Database standards and protocols without users needing to know how to write SQL.
The IBM Cognos 8 - Teradata Performance Management Overview
Click the thumbnail to view a larger version
| Analytical Processing Technology | Teradata Optimization |
|---|---|
| ROLAP (Relational On-line Analytical Processing) - Data remains in relational database and relies heavily on the database engine to perform calculations and aggregations. |
Pre-calculated aggregations with Aggregate Join Indexes (AJI) provide fast query response. Uses Teradata parallel engine for fast query response. Leverages Teradata Optimizer to automatically generate version-specific, optimized, and native Teradata SQL. |
| MOLAP (Multi-dimensional On-line Analytical Processing) - Data to be analyzed is identified, extracted, pre-calculated, aggregated, and stored in mid-tier data store or "cube". | Uses Aggregate Join Indexes and Teradata load tools to speed cube creation and updates. |
