Question: We have a case where a data mart is being built on Oracle HR application. Due to the complexity of the application the data model for data mart has ended up being a 3NF. Because of this design there are a lot of performance issues. One of the solutions could be the creation of materialized views to mask the 3NF in the reporting tool for reports and for access through the reporting tool. Is there any other way to improve performance of data access through the reporting tool? ETL performance is also a problem. Are there any tried and tested practices to be followed in such cases for improving performance? Currently incremental loads are being executed.

Sid Adelman's Answer: Before you look at solutions, you need to know why there are performance problems on both the BI and the ETL sides which could be caused by any number of factors with many of them related and interdependent. Your question gave no specifics on your diagnosis of the performance problem. We have seen organizations throw money and effort at parts of the system that don't have a problem. What parts of your system have you monitored and what have you determined from the monitoring? Only after you have discovered where you have the problems should you evaluate solutions to address them.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access