Highlights:

  • The Autonomous Data Warehouse is used by businesses to analyze their business data for beneficial insights.
  • The new Autonomous Data Warehouse has enhanced analytics. Most of the new capabilities increase interoperability with popular open-source and commercial analytics tools.

Oracle Corporation is introducing a new version of its Autonomous Data Warehouse platform with enhanced analytical capabilities that aims to simplify enterprise analytics projects and reduce the costs.

The Autonomous Data Warehouse is used by businesses to analyze their business data for beneficial insights. According to Oracle, the platform is suitable for duties such as monitoring the financial performance of subsidiaries and tracing the purchasing preferences of customers. In addition, it offers capabilities for conducting machine learning models.

The Autonomous Data Warehouse is provided by Oracle as a managed service. Customers are not required to invest in maintenance activities such as obtaining security updates and provisioning infrastructure. The platform utilizes machine learning to automate certain administrative tasks.

Unveiling of a new iteration of the Autonomous Data Warehouse includes an expansion of its analytic capabilities. The majority of the new features aim to improve the platform’s compatibility with prominent open-source and commercial analytics tools.

As part of the update, the Autonomous Data Warehouse will receive support for Delta Sharing, an open-source technology. The 2021 rollout of this technology by Databricks Inc. facilitates the transfer of data between various analytics applications. It is supported by the Databricks analytics platform, the Microsoft Power BI business intelligence application, and several other products.

The ability to readily transfer data between applications is beneficial in a variety of situations.

Typically, organizations maintain their business data across multiple systems. Delta Sharing enables the Autonomous Data Warehouse to consume and analyze data from other systems more efficiently. Additionally, the technology facilitates the task of data sharing between companies, which is required for certain types of collaborative analytics initiatives.

Çetin Özbütün, Oracle’s Executive Vice President of Data Warehouse and Autonomous Database Technologies, said, “Customers face many obstacles when analyzing siloed data across on-premises, cloud, and SaaS applications, especially the lack of multicloud and data lake interoperability. The latest Oracle Autonomous Data Warehouse innovations make it easier for customers to query, manage, share, and scale their data — regardless of location.”

Additionally, the most recent version of Autonomous Data Warehouse introduces support for Apache Iceberg. Companies use this open-source tool to organize data into tables, or collections of rows and columns. In certain ways, tables are simpler to process than other file types, which facilitates analysis.

In addition to support for Delta Sharing and Iceberg, Autonomous Data Warehouse will integrate with two commercial analytics products.

Google Sheets, the spreadsheet editor integrated into Google Workspace, is the first product. In addition to allowing users to organize data into rows and columns, it provides a number of built-in analytic functions. Oracle claims that a newly introduced add-on will enable clients to analyze Autonomous Data Warehouse data using the Google Sheets interface.

Additionally, the company is revising the data warehouse to include enhanced support for AWS Glue. It is a service provided by Amazon Web Services that assists businesses in preparing their business data for analysis more rapidly. Using Glue, a team of analysts can integrate business records from multiple sources, eliminate duplicates, and complete related duties.

Oracle is introducing the new features concurrently with a price reduction. The cost of the Exadata storage infrastructure that clients use to fuel their Autonomous Data Warehouse deployments has decreased by 75%, according to the company. According to the announcement, the move aligns pricing with object storage infrastructure, which consists of hardware used to store unstructured data.