Oracle sets 12-month window for AI Lakehouse semantic layer

On Oct. 26, Oracle announced new capabilities for Autonomous AI Lakehouse, including a Business Semantic Layer, agentic metadata enrichment for AI Data Catalog, expanded Apache Iceberg support and new governance controls. Oracle said the catalog’s agentic capabilities and the semantic-layer capabilities will become available within 12 months; it did not present either as generally available at launch.

The underlying Autonomous AI Lakehouse is available now on Oracle Cloud Infrastructure, Amazon Web Services, Microsoft Azure, Google Cloud, Oracle Exadata Cloud@Customer and OCI Dedicated Region, according to Oracle. The existing infrastructure lets customers query supported operational databases, object stores and lakehouse tables without first moving all of the data into a separate system. Oracle intends the roadmap additions to put shared business definitions and policy controls over those distributed sources.

Oracle described the Business Semantic Layer as a reusable definition system for dimensions, measures, metrics, hierarchies, calculations and key performance indicators. The system would give analysts, applications and AI agents the same vocabulary for interpreting fields and calculating business measures. Oracle said the layer would draw on catalog annotations, imported Oracle AI Database SQL annotations and AI-suggested analytic views to support natural-language-to-SQL, retrieval and analytics.

The AI Data Catalog can mount external catalogs, Oracle and non-Oracle databases, Iceberg tables, applications and object-store data without duplicating them, Oracle said. The planned agentic features would continuously enrich metadata with business meaning, lineage, workload patterns, relationships and retrieval signals. Oracle said those additions are designed to narrow searches to relevant assets and improve discovery and natural-language analytics. It did not give a date more precise than the 12-month window.

Oracle also detailed expanded native Iceberg support, including the ability to create, populate, update and delete Iceberg tables with Oracle SQL, plus time travel for auditing and recovery. Oracle’s release grouped those functions with the new and expanded capabilities but did not assign them an explicit availability date. Oracle, however, said Data Studio now offers an AI-assisted workspace through an OCI account, connects to more than 100 data sources and accepts natural language, SQL or Python.

For governance, Oracle said AI Data Catalog provides role-based, object-level controls across supported Oracle, non-Oracle and Iceberg data. Oracle’s technical post says those policies work alongside, rather than replace, controls enforced by the underlying source systems. Oracle also claimed Data Lake Accelerator enhancements ran queries up to three times faster on a 100 TB TPC-DS data set and increased maximum cluster size from 32 to 100 nodes; the supplied sources did not independently validate that benchmark.

Oracle did not disclose exact general-availability dates or pricing for the catalog’s agentic capabilities or the Business Semantic Layer. Its future-product disclaimer says the description is not a delivery commitment and that development, release, timing and pricing may change at Oracle’s discretion.