RDB’s Data Warehousing service covers the whole DW Lifecycle from Dimensional Modeling, through the ETL process and ultimately the Business Intelligence Application.
We also include logical and physical database design, population and performance tuning.
We implement and optimise warehousing specific features of the database such as:
- Partitioning
- Suitable block size usage
- DDL and DML parallelisation
- Choice of index type
- Large object placement
- Optimiser specific requirements
- Maximised table and index storage
- Maximised I/O performance
