O'Reilly logo

Query Acceleration for Business Using IBM Informix Warehouse Accelerator by Ramanathan Sivaguru, Keshava Murthy, Holger Kirstein, Frederick Ho, Martin Fuerderer, Nigel Campbell, Whei-Jen Chen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing data marts
This chapter provides an overview of database designs for transactional and analytical database systems. It describes the techniques of dimensional modeling for data warehouses, including star and snowflake database schemas. Also covered are the specific design aspects for data marts in Informix Warehouse Accelerator and practical considerations.
2.1 Relational database design overview
The purpose of a database determines what the schema for the database looks like. When you design the schema for a relational database, consider ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required