The latest innovations provide native multicloud capabilities and open standard-based data sharing across databases, simplifying data integration and analysis with a unique low-code based tool.
Oracle has announced new capabilities to its Autonomous Data Warehouse, an autonomous database powered by machine learning and optimized for analytics workloads. The new innovations offer native multicloud capabilities, open standard-based data sharing, simplified data integration and analysis with a low-code-based tool, and ultra-fast enterprise storage at the same low cost as object storage.
Breaking through the proprietary and closed nature of traditional data warehouses and data lakes, the latest innovations address challenges faced by customers when analyzing siloed data across on-premises, cloud, and SaaS applications. They provide customers with query, manage, share, and scale capabilities, regardless of location. The innovations also make it easier for customers to rethink their data warehouse and data lake architectures without having to choose between performance and cost.
“We continue to push the boundaries of what’s possible in data management systems to deliver the performance, automation, and multicloud integration for all key database workloads and data types,” said Çetin Özbütün, Executive Vice President, Data Warehouse and Autonomous Database Technologies, Oracle.
The new innovations include expansive multicloud functionality, providing secure access to object storage in AWS, Azure, and Google Cloud; live SQL connections to Azure SQL, PostgreSQL, Apache Hive, MongoDB, Snowflake, Amazon Redshift, and Azure Synapse; and pre-built connectors to ingest data from over 100 data sources.
Oracle’s Autonomous Data Warehouse now includes query access to Apache Iceberg tables and integration with AWS Glue for retrieving data lake schema and metadata automatically. Additionally, the innovations provide customers with low-code-based Oracle Autonomous Database Data Studio, an intuitive self-service cloud console for analysts and data scientists to load, transform, and analyze data without relying on IT. A Google Sheets add-on is now part of Oracle Autonomous Data Warehouse in addition to the already available Microsoft Excel add-in.
The company has also implemented the industry-standard, open-source Delta Sharing protocol, enabling customers to securely share data with anyone using any application or service that supports the protocol. This approach eliminates the use of stale data and inaccurate results, improving business decisions.
The innovations provide high-performance storage at the same cost as object storage. Oracle’s Exadata storage cost may be reduced by over 75%, bringing it in line with the cost of object storage, while delivering up to 20 times faster query performance. Customers can now store all their data in Oracle’s Autonomous Data Warehouse and accelerate time-to-actionable insights at a lower cost.
Oracle Autonomous Database is a self-driving database that runs natively on Oracle Cloud Infrastructure and can automatically secure highly available databases, configure and optimize for specific workloads, and scale resources when needed.
Additional Resources
- Read the Technical Blog
- Learn more about Oracle Autonomous Data Warehouse
- Oracle.com
About Utility Analytics Institute (UAI)
UAI Enables Utility Transformation Through Analytics
UAI is a utility-led membership organization that provides support to the industry to advance the analytics profession and utility organizations of all types, sizes, and analytics maturity levels, as well as analytics professionals throughout every phase of their career.
Transforming into a data decision-based company is one of the most difficult transitions a utility will have to make to thrive in the new energy economy. It’s more than just managing massive amounts of data, implementing the right tools and technology, and people and process management. It’s ensuring you have proper change management processes in place to address cultural challenges, as well as data management and governance plans, and best practice and compliant security strategies in place. It’s implementing the best organizational structure for your utility, and hiring and retaining talented staff, plus so much more! UAI brings together leading utilities who are serious about tackling these challenges and together we concentrate on utility analytics.
What’s UAI Membership all about? UAI serves multiple audiences providing different membership packages for each audience type. Learn more about how UAI unifies our community, serves each audience to help you meet your goals and address challenges, and how each audience collaborates to better serve the utility industry.
The UAI Analytics Architecture & Technology Community meets monthly to focus on identifying architecture and technology patterns that help in creating successful analytics and data science programs.
Contact Kevin Praet, Membership Relations, at kpraet@utilityanalytics.com to learn to benefits of becoming a member of Utility Analytics Institute (UAI).
