Data-models

Getting the data-model correct for your core storage in the warehouse and for your all important data-marts is paramount. We can utilise tools like ERWin and Oracle Designer to produce designs that are rich in meta-data and tailor made to obtain the highest levels or performance possible from your database.

We consider which aggregates to produce and how your database's optimiser will choose to execute the queries generated by your BI tool.

Choosing how best to index and partition the data storage can be make or break when meeting the expectations of your business users. We want to make sure that your business user's expectations are exceeded.