Simplify data analysis using analytic views
summary
Claims that Oracle Database (12.2+) includes analytic views as a zero‑cost feature that stores a semantic model in the data dictionary, generates SQL/MDX/REST, and hides joins and calculations behind simple hierarchical or relational queries. Shows use of the AV_AGGREGATE pass‑through for computed measures, optional aggregate caches/materialized views that cut long queries (200-query test drops many >5s runs to fast), and tooling in Autonomous Database and SQL Developer plus Live SQL tutorials.
AI-written summary · about
chapters (15)
- 0:00Introduction
- 0:38BI requirements
- 2:03BI applications
- 4:15What are analytic views
- 8:49Problem with analytic views
- 9:50Defining the analytic view
- 10:59Hidden complexity
- 11:42Example
- 13:15Querying
- 14:52Aggregation
- 16:19calculative measures
- 18:13Dimensional structure
- 22:56Defining analytic views
- 24:49Autonomous
- 25:55Wrap up
related talks
30mSelf-service data warehousing
24mOracle's vision for simplifying data-driven apps and analytics
12mSolve Problems by Understanding Data and Graphs
49mHow Oracle Analytics Empowers Every Business User with AI
18mData Superpowers with Oracle Database 23ai
24mFuture of Data and AI
25mSimplify Property Graphs Using SQL with Database 23ai
14mMulticloud Analytics Made Simple