Thursday, 18 March 2021 09:52

Oracle Autonomous Data Warehouse aims for end users Featured


The latest enhancements to Oracle Autonomous Data Warehouse are mainly about empowering non-IT users.

Oracle Autonomous Data Warehouse allows businesses to ingest, transform, store, and govern all data from any source to run diverse analytical workloads, from departmental systems to enterprise data warehouses and data lakes, according to the company.

New user-oriented tools cover the loading, transformation and cleansing of data; the guided construction and deployments of machine learning models; and graph modelling and analytics.

Oracle Autonomous Data Warehouse provides support for multi-model, multi-workload, and multi-tenant requirements – all within a single, modern converged database engine – including JSON document, operational, analytic, graph, ML, and blockchain databases and services, Oracle said.

A key focus of the update is the provision of features that make it easier for analysts, citizen data scientists, and line-of-business developers to take advantage of Oracle Autonomous Data Warehouse.

Data from a variety of sources can be loaded and transformed using drag-and-drop tools. From there, anomalies, outliers and hidden patterns can be discovered in the data. Instead of requiring users to know what they are looking for, Oracle Autonomous Data Warehouse identifies factors of potential interest.

The new Oracle Machine Learning AutoML feature provides a no-code user interface for automated machine learning, allowing even non-experts to exploit machine learning. Users can identify the attribute of interest and the system will select the most promising algorithms, explore the effect of changing parameters, and display the results as a leaderboard. Where appropriate, users can opt to use a sample taken from the entire dataset in order to reduce processing time during this exploratory phase.

Data scientists and others who are happy writing Python code can take advantage of Oracle Machine Learning for Python to apply their ML code to warehoused data.

Oracle Machine Learning Services supports the deployment and management of native in-database models and ONNX-format classification and regression models outside Oracle Autonomous Data Warehouse.

ADW BusinessModelwithStarSchema

Users can create graphs within their data warehouse, query graphs using PGQL (property graph query language) and analyse graphs with over 60 in-memory graph analytics algorithms.

Graph Studio UI makes graph analytics easier for beginners, with the automated creation of graph models, notebooks, integrated visualisations and pre-built workflows for different use cases.

Oracle Autonomous Data Warehouse provides access to data lakes including Oracle Cloud Infrastructure Object Storage and Oracle Big Data Service (Hadoop).

The product is also preconfigured for use with Oracle applications including Fusion ERP, HCM, E-Business Suite, Peoplesoft and JD Edwards. It includes prebuilt dashboards and KPIs, but can be extended to meet particular requirements.

Oracle Autonomous Data Warehouse can be used with a variety of other data and analytics tools, including Talend, Infomatica, Tableau and Qlik, and it provides built-in data loading from AWS, Azure and Google object storage.

Self-managed superannuation fund provider Triple A Super is developing a wealth management system.

Managing director Brian Pedretti said, "We wanted to weave together a tapestry of multiple software platforms synchronised with our own internally developed portals to create customised, hierarchical, permission-based dashboards using both predictive and prescriptive analytics that institutions, dealer groups and advisers can also integrate with their own systems.

"They can then share these with individual clients, enabling them see their investments and rich data analytics details such as how compliant they are, impending issues or opportunities that enhance greater client engagement and growth opportunities.

"Using a mix of Oracle Autonomous Data Warehouse and Apex [Oracle's Application Express development tool], we now have a single environment allowing us to do this, and from which we can continue to surface new developments and continue to improve and revitalise the portals we had previously developed. It's certainly increased our development capability."

Other Oracle Autonomous Data Warehouse customers include Lyft, Vodafone, Aon and Accenture.

IDC research vice president for data management software Carl Olofson said "Our research, based on interviews with several customers around the globe, shows that those Oracle Autonomous Data Warehouse customers have achieved approximately 63% reduced total cost of operations, while increasing the productivity of data analytics teams by 27%, with breakeven on their investment having occurred in an average of five months.

"This ROI included significant productivity gains across data, analytics, and developer teams. While individual customer results may vary, the benefits found in this study are indicative of the kind of improvements that most may expect.

"With these new intuitive integrated tools incorporated in Oracle Autonomous Data Warehouse, it is reasonable to expect that productivity gains will further increase, enabling businesses to achieve an even better ROI."

Oracle Autonomous Data Warehouse still allows transactional, analytics, machine learning and other data to be stored in a converged SQL database, and is supplied as a single product so there is no need to acquire software for each function.

The 'autonomous' aspect is that it minimises the need for human administrators, resulting in lower cost, improved reliability and better security,

Subscribe to ITWIRE UPDATE Newsletter here


The much awaited iTWire Shop is now open to our readers.

Visit the iTWire Shop, a leading destination for stylish accessories, gear & gadgets, lifestyle products and everyday portable office essentials, drones, zoom lenses for smartphones, software and online training.

PLUS Big Brands include: Apple, Lenovo, LG, Samsung, Sennheiser and many more.

Products available for any country.

We hope you enjoy and find value in the much anticipated iTWire Shop.



iTWire TV offers a unique value to the Tech Sector by providing a range of video interviews, news, views and reviews, and also provides the opportunity for vendors to promote your company and your marketing messages.

We work with you to develop the message and conduct the interview or product review in a safe and collaborative way. Unlike other Tech YouTube channels, we create a story around your message and post that on the homepage of ITWire, linking to your message.

In addition, your interview post message can be displayed in up to 7 different post displays on our the site to drive traffic and readers to your video content and downloads. This can be a significant Lead Generation opportunity for your business.

We also provide 3 videos in one recording/sitting if you require so that you have a series of videos to promote to your customers. Your sales team can add your emails to sales collateral and to the footer of their sales and marketing emails.

See the latest in Tech News, Views, Interviews, Reviews, Product Promos and Events. Plus funny videos from our readers and customers.


Stephen Withers

Stephen Withers is one of Australia¹s most experienced IT journalists, having begun his career in the days of 8-bit 'microcomputers'. He covers the gamut from gadgets to enterprise systems. In previous lives he has been an academic, a systems programmer, an IT support manager, and an online services manager. Stephen holds an honours degree in Management Sciences and a PhD in Industrial and Business Studies.

Share News tips for the iTWire Journalists? Your tip will be anonymous




Guest Opinion

Guest Interviews

Guest Reviews

Guest Research

Guest Research & Case Studies

Channel News