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

Get Query Acceleration for Business Using IBM Informix Warehouse Accelerator now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.