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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
