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, 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…
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…
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Agenda Presentation: FDI Security & Deep Dive into GL Segment Security. We are revisiting FDI Security - a top topic requested by our Office Hours attendees. We will begin with an overview of key security concepts and how security is managed in FDI. We will then dive deeper into GL Segment Security across Fusion and FDI…
