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
In this session, get an inside look at the OCI Enterprise AI product roadmap, with updates across AI agents, model access, and governance. See OCI Enterprise AI in action through demonstrations of an autonomous order fulfillment agent, the Enterprise AI model playground, and AI guardrails for content moderation, sensitive…
In this session, explore the latest Oracle Fusion Data Intelligence (FDI) roadmap updates across ERP, HCM, SCM, CX, and platform capabilities. Learn how Oracle is expanding analytics coverage with new subject areas, prebuilt content, and deeper operational insights, while advancing AI-enabled workbooks, chat-based…
In this session, learn about the latest Oracle AI Data Platform product roadmap updates and see newly released and planned features in action. Explore visual agent building, multi-agent workflows, knowledge bases, MCP integrations, and more. The session also demonstrates how Codex skills can streamline data engineering and…
Customers are encouraged to join this quarterly virtual meeting to hear the latest updates from Oracle Product Strategy and Product Management. There will be time at the end to network with your peers and connect with other customers who are turning their data into actionable insights with Oracle Analytics and Oracle AI…
Register today! Description: Enterprise AI initiatives need more than a promising use case. They need trusted data, the right business context, and governance from the start. Join Oracle and Vertice to explore how organizations can bring these elements together to move AI use cases into production In this webinar, Oracle…
Join the FDI HCM Product Management Team in this live webinar to go over the topics related to Release 26R3 Agentic Capabilities Fusion Agents & Agentic Apps FDI MCP Tools OAC Data Agents delivered via FDI Content Library Workforce Scheduling - New Subject Area Learning - Analytical Currency, E-learning,…
