Lot of customers have asked us what should be factors that need to be factored in while deciding on creation of Aggregation tables vs Materialized views.The blog tries to discuss the considerations while deciding between the two
Helpful!
Users should also look at the 'Analytic Views' (AVs) functionality of Oracle database. It simplifies analytical reporting significantly. There is no need to create Summary table or MVs. BI Data Model (including hierarchies, attributes and measures) is pushed inside database.
All data exists at all levels of all dimensions, and no need for SUM..GROUPBY queries.
The new sql syntax (of AVs) simplifies creation of calculations - like Time Series calcs.
All queries are simple SELECT..FROM…WHERE types of queries - with no need for JOINs and aggregation.
OAC DV has a separate data source for 'Analytic Views' in addition to Oracle Autonomous Database.
Even Essbase Federated Partitions (in essbase-cloud) use 'Analytic Views' features of autonomous database - behind the scenes. https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html
There is a livelab at:
https://apexapps.oracle.com/pls/apex/r/dbpm/livelabs/view-workshop?wid=3594
Bud Endress has many videos on YouTube about 'Analytic Views'.
He has also written some blogs about it:
https://blogs.oracle.com/datawarehousing/authors/william-endress
Did
Explore the latest Oracle Analytics product roadmap updates for October 2026. See Deep Insight Agents tackle complex data questions through multistep analysis, and learn how planned integration between Oracle Analytics Cloud and Oracle AI Data Platform will let users access and work with catalog assets across both…
In this session, explore the latest Oracle Fusion Data Intelligence product roadmap updates across ERP, HCM, SCM, CX, and platform and infrastructure analytics. Learn about new subject areas, AI agents and agentic applications, and enhancements to the data and content platform. The session also covers the new Fusion…
In this session, explore the latest Oracle AI Data Platform product roadmap updates and the platform’s direction. See demonstrations of Data Lineage, integration with AI Lakehouse using Iceberg format, MLOps deployment of models as endpoints, and agent file reading and writing. Learn about upcoming AI Data Platform…
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Oracle AI Data Platform Hackathon at Oracle AI World 2026 Sunday, October 25, 2026 12:00–5:00 p.m. PT Request your spot at the AI Data Platform Hackathon Join us in person for the Oracle AI Data Platform Hackathon on Sunday, October 25, from 12:00–5:00 p.m. PT in Las Vegas at Oracle AI World. Lunch will be provided.…
Oracle AI Data Platform team will host an in-person Customer Advisory Council for AIDP customers attending Oracle AI World 2026 on October 26, from 1–3 PM PT. Join Oracle AI Data Platform executive leaders and selected customers for interactive discussions on our product roadmap, priorities, and future direction. Share…
