The phrase ‘data is the new oil’ is no longer a particularly profound observation, especially in today’s rapidly advancing world of innovation. Businesses are fundamentally built on the foundations of how information flows between various parties and functions. As more data becomes available from external sources such as the Internet of Things and connected devices, greater storage and computing power are required if organisations are to realise the full potential of this valuable resource.
In this blog, we’re going to take a closer look at how automation, enabled by AI and machine learning, is transforming the way organisations manage and utilise data, through the recent adoption of the Oracle Autonomous Data Warehouse Cloud.
This is a database, designed for data warehousing, that’s capable of self-patching, self-tuning and upgrading—all while running normally—so as to eliminate these manual, human, error-prone tasks. The simple elasticity of the data warehouse also gives businesses the freedom to scale when needed, preventing unnecessary overspend on unused compute or storage capacity during periods of lower demand. Furthermore, you can immediately run analyses on your data with included web tools or use popular market BI analytics tools.
So what do users think about it and what value does it deliver? Let’s hear about two different types of organisation.
From figurative to literal oil
Measured by production, AkerBP is the one of the largest independent oil companies in Europe. For legal reasons, the company needed to be able to provide reporting on a number of alarm systems—some of which were offshore—however the requests can be very sporadic. Sometimes the calls wouldn’t need to be made for weeks, and the cadence was not predictable.
AkerBP Database Architect, Erik Dvergnes, experienced how easy it was to test the Autonomous Data Warehouse Cloud platform for this purpose. By setting up the account, creating an instance and copying several data exports to the store, he was able to connect the database with SQL Developer and immediately start running queries. Despite the size of the data sets—1.1 billion rows in some instances—the queries ran in seconds rather than minutes, and could be turned off when not required. He was impressed that this met his needs:
“The flexibility of Autonomous Data Warehouse Cloud in terms of CPU usage is outstanding and unique in the market.”
Calling on all database admins
The second largest telephone assistance and online search directory in Germany, 11880.com, needed a data warehouse and reporting solution to support their business reporting. They discovered that Autonomous Data Warehouse Cloud’s performance was both comparable with existing in-memory data warehouse databases and also worked smoothly with their Informatica platform and their Oracle BI tools.
11880.com’s chief executive, Christian Maar, was delighted that it’s freed up his DBA’s time to focus on architecture and application optimisation, rather than admin tasks. He was also hugely impressed by its speed, availability and scalability:
“Autonomous Data Warehouse Cloud is the optimal solution for a medium-size company like 11880.com. Fast, flexible, no admin and in the Cloud.”