Autonomous Data Warehouse - Peter Jonathan Wilcheck
Share This
Get in Touch
Scroll Down
//Autonomous Data Warehouse

Autonomous Data Warehouse

We have now entered and firmly established ourselves in the digital era, where artificial intelligence with big data capabilities in both hardware and software are possible and currently widely available.

Ecommerce is thriving in this new digital world of advanced technology, and it has the potential for continuous improvement and to experience exceptional growth far into the future. Large data repository firms have created ‘Autonomous data Warehouses’, most in the form of Cloud services with huge storage capacities that enable online businesses to collect consumer data by simply subscribing to a warehouse service today.

This new AI technology is helping companies to move forward with confidence and to concentrate on other important aspects of the business. These big-data businesses need a suitable environment for data storage and the warehouse provides that facility. Big-data itself is a scale-out technology. Enterprises can receive the benefits with any compute, storage and any other resource that is added to the companies infrastructure. And for that reason, data collection platforms can now think in terms of handling gigantic amounts of consumer data with much effort and more importantly, much less cost.

The current big-data storage facilities are autonomous data platforms that offer big-data infrastructures that manage and optimize themselves to the very highest of standards. The AI technology involved actually learns from understanding how the company uses its data platform. It also observes the queries that are run, and what tables are actually being used at that time, and how many clusters are currently being built, and how efficiently the cluster usage is in the data collection process.

An autonomous data warehouse basically examines everything that is related to how the organization’s big-data infrastructure is used to solve certain business challenges, and it then analyzes that gathered information to help the IT team make initial improvements for future processing, if need be. And with the influx of increased reliability, lower cost and assured performance to extract more value from all the data collected. In computing a data warehouse is a collective system which can be used for data analysis and reporting.

Essentially it is a core ingredient of business intelligence. The storage warehouse is a repository of integrated data from what can be collected from numerous different sources. The facility can store data from past events and store the current data collected by the company in the most efficient manner possible. Storing all that data in one significant place like an ADWC is much more efficient for all business enterprises. Whatever the data entails, it is stored by uploading it from the used operating system. The ADWC can then pass all the data through an online store and may clean it from basic data that is not actually needed by the enterprise.

This cleaning process assures that only the data of quality and the data that is useful to the organization is stored before the intended usage. Now that the cleaning process has been complete, it has been fully transformed and made available to all IT users for data mining, research and analytical purposes. The warehouse will keep a copy of all the data and the information it provides from the transaction system. It will then be able to integrate the data from several different sources and store it as a single database if that is what is wanted by the enterprise in question. This will offer the organization a much better and completely central view across the entire business, which provides added value to the company and its IT processes. The main benefit to the ADWC by Oracle is that all the data collected is properly restructured and will always be presented to the user efficiently and consistently. Therefore organizing and ridding the enterprise of unwanted and repetitive data.

A data warehouse without autonomous capabilities can be a complex assembly of hardware and software which can be extremely time consuming to set-up and manage. Specialist IT teams, including technical data administrators can spend weeks building, tuning and securing a data warehouse. However, there are new unique products and services on the market that are currently changing the game. One of these big data platforms is ‘Oracle Autonomous Data Warehouse Cloud’, (ADWC)This new bit of technological kit is letting business people set-up high-powered data warehouses in less than a minute. All that is needed is to answer several basic questions with logical answers and the individual/team member has created a high-performance data-bank for the organization to use.

The questions involved in the set-up process are:

1.    How many computer’s do you want to set-up?

2.    How much storage do you need?

3.    What is the intended name of the database?

4.    What is the brief description?

5.    What is your password?

It really is that simple, answer those questions and the business is ready to store all data in an autonomous warehousing platform. The warehouse then lets team members analyze and sort through millions of customer records including their buyer information, sales statistics and inventory records. They can quickly load data and begin to test that new knowledge by using the built-in web-based tools. With beneficial factors like this at the businesses disposal, any queries about current performance and expected annual results can be answered in a matter of minutes due to its fast and reliable autonomous capability. Using advanced database platforms and machine learning to help a business operate without human intervention is the future of digital technology, and all e-commerce enterprises should intend to subscribe to these kind of big-data saving services. A data warehouse can tune, optimize and patch itself for high-quality performance without having to actually go offline to do so.

Enterprises currently differentiate themselves through analytics to further their advantage of the competition by extracting value from their data sources. Many other companies are searching for new ways to become data-driven through the modernization of their data management deployments. Strategies like this do include some challenges however, such as, the correct management of large and constantly growing volumes of data. The new age of the digital world is creating data at an explosive rate, and the next big-data wave is expected to be close and certainly on the horizon. It is driven by the emergence of the ‘Internet of Things’ data sources. The past physical data warehouses were good for collecting data from across the organization for analysis, but the storage and compute resources needed to support the current big-data collections are not able to keep the pace with such astounding digital growth. Therefore the cloud is the best option for storage, whether it is hosted locally in a private cloud, outsourced to a public cloud service, or even a mixture of the two. Oracle’s Cloud offers simpler and better management, higher scalability and availability with quality performance, and new ways to reduce costs associated with data storage and processing activities.

Many e-commerce professionals have noted this advanced intelligence created by Oracle Cloud, as the service provides direct integration with the full spectrum of business analytics, big-data storage and the ‘Internet of Things’ capacity within Oracle’s wide range of integrated cloud products and services. The manual process is no longer feasible because Oracle Autonomous Data Warehouse Cloud Service has taken a gigantic leap to help the digitally inclined enterprises. By removing the need for tedious, time-taking tasks like manual set-up efforts that include finding the correct hardware and installing software, creating data administrators, managing schemas, etc. It gives the organization the opportunity to prioritize elsewhere and become more productive in other fundamental aspects of the business.

Everything is done automatically and autonomously with data warehousing. The incessant optimization of the system’s resources is always administered based on the initial queries that are reaching the cloud, which helps to keep a high-performance without the need for any human intervention and manual tuning. The level of simplicity that it offers the user is outstanding. It is considered the highest level of self-service within a database warehousing system that business intelligence professionals have been waiting for. Oracle’s data cloud also comes with a library of machine learning algorithms that are the very best in analytical innovation. Technology like this is truly changing how e-commerce interacts with their customers and stores consumer data. It is the next-generation cloud service aimed at the entire e-commerce workplace.

The revolutionary autonomous database has many different benefits, including:

·        Easy to use: Warehouse provisioning enables it easy to spin up a secure data storage facility with automatic back-up, encryption, and an available architecture in seconds. The actual migration process to cloud is simple due to its compatibility with existing organizational databases.

·        Fast and reliable: It offers the user the very best of query performance and with no additional tuning required. Oracle’s Cloud is super-fast and it comes with a guarantee that it is capable of the same workload at half the cost of other branded web service providers.

·        Elasticity: The autonomous database is fully independent with online scaling of compute and storage capability. It has the artificial intelligence to either dynamically shrink or grow resources when needed, enabling true pay-per-usage cost which dramatically lowers company expenditure.

·        Self-driving: The self-drive features eliminate the need for human interaction therefore also eliminating human error. The warehousing platform provisions, monitors, tunes, secures, backs up, troubleshoots and recovers the database. Whilst automatically upgrading and patching itself when running.

·        Self-securing: It offers protection from external attacks and malicious programs or user integrity issues. Applying security updates including encrypted data to withstand cyberattacks.

·        Self-repairing: Providing automated protection from downtime with up to 99.995% availability, which results in no more than 2.5 minutes of downtime each month. All of that with the added bonus of planned maintenance availability, the benefits of Oracle Autonomous Data Warehouse Cloud as an advanced, analytical tool are substantial.

Connecting the ADWC is slightly similar to the regular Oracle database connections. But it is much easier as there is no need to specify a host, port and SID/ service name, etc. The product and the service that it provides is based on the Oracle Exadata Database Server technology and it still supports PL/SQL, full insert/update/delete/select support in SQL, and parallel query, which is enabled by default, and it also offers hybrid columnar compression. Oracle are basically serving e-commerce enterprise customers with the ADWC service and its superb elasticity. It has made it super-easy to create a secure, fully managed Data Warehouse service in the cloud. E commerce users can start loading and analyzing data as soon as the AI hardware/software is set-up, which is configured and handled by Autonomous Data Warehouse Cloud. It provides fully automated warehouse specific features that deliver an exceptional query performance, and the service is run on an optimized high-end Oracle hardware system. The ADWC takes care of everything for you. Selecting the exact combination of storage and CPU’s to fit a business’s project and budget expectation is no longer an issue. And it is complete with a web-based notebook and reporting services to help the firm both to build and share big-data analysis within the organization.

There is no need for any database administration with ADWC as it uses the most advanced artificial intelligence to deliver reliable results. Furthermore, the cloud by Oracle is an open source that lets the subscriber utilize the service in a hybrid cloud model. This type of open-source solution combined with the fully-integrated and comprehensive cloud concept will set an e-commerce enterprise on the path to success. It drives forward the fundamentality’s of collaborations and productivity within the company, and with others in a B2B process, if desired. Team members can access, edit and share data or documentation at any time, anywhere, and from any connected device. The cloud can also reduce reliance on legacy data center infrastructure by allowing the user to connect to publicly available networks and other services. It does that by adopting the standard approach, such as Health and Social Care through HSCN, or the educational and research approach through JANET.

To ensure that the connected enterprise gains maximum value from ADWC, it is wise to examine certain criteria, which many include options of the best network connectivity model or service provider is being used to suit the business’s specific project requirements. The cloud connectivity challenge is made easy because Oracle have identified the main steps to transform any network to become cloud-ready and easily assessable. Those steps are:

1.   Preparing your devices

2.   Ensuring all applications are cloud-ready

3.   Virtualizing the infrastructure

4.   Assessing bandwidth needs

5.   Defining the correct approach

6.   Accessing public and/or private networks

The basic autonomous data platforms offer a three-layer emergence. These layers include, Alerts/Insights/Recommendations:

·        Alerts; are basically a passive form of intelligence. They provide the company with information about the infrastructure, but they do not actually do anything, such as rectify an issue. An alert might entail something like, ‘Did you realize that the cluster is running and no data is being processed?’ the alert simply informs the business about a situation that may seem out of the ordinary at that given moment. It will take no action.

·        Insights; provide a snippet of analysis, and that can mean taking out-of-the-ordinary information and then analyzing it to offer a conclusion of the issue. Insights are like alerts, as in they are both passive forms of intelligence. The data is offered, but no action is undertaken,

·        Recommendations; are the next level up from insights. It takes the analysis and uses it to suggest/recommend the step to be taken to provide the correct outcome after the action has been completed. A useful recommendation could include something like, ‘This field is often used as a filter process in queries or sort fields and indexing it will improve future performance’. The recommendation is offered however no action is taken automatically by the platform therefore the team member will still have to issue the action for the procedure to be completed.

Fully autonomous automation is where the platform collects all the information then analyzes it and makes the decision for the organization. It will act without asking for permission or any guidance, but the decision it takes is mainly always correct due to its outstanding AI capability. Oracle’s Autonomous Data Warehouse Cloud will observe things like, if there are a number of queries using a specific field and then it will determine that if an index on that field would improve performance. Likewise it will determine that if partitioning a table in a certain way would also add to the overall performance standards. It can also detect that a cluster is too small to meet an SLA and resize it dynamically. Because it is a ‘closed-loop’, it would be able to observe if the change had the desired impact, etc. The fully self-optimizing platform offered by Oracle’s ADWC will allow an e-commerce enterprise’s data team to focus more on business outcomes as opposed to constantly troubleshooting, and performance tuning actions. With automation, the data team can work on higher order, and more valuable problems within the business by fully-focusing on the data and not the actual data platform, to help achieve big-data success.

Autonomous data warehouses such as Oracle’s Cloud offer:

·        Always-on reliability

·        Accelerated analytics and data insight extraction

·        Big data enablement

·        Reduced costs and risk

·        Simplified deployment


The Oracle Autonomous Data Warehouse Cloud uses applied machine learning to self-tune and automatically optimize performance while the database is still running. It is built on the next generation database technology using artificial intelligence to deliver unprecedented reliability, performance and high elastic data management to enable data warehouse deployment in seconds. With so many features that offer fantastic benefits to the customer, it is easy to see why so many companies are jumping on the big-data bandwagon and introducing the cloud service to their online organizational practices.

The key features are:

High-performance queries and concurrent workloads – Optimized query performance with pre-configured resource profiles for different types of users.

  • Oracle SQL – DWCS is compatible with all business analytics tools that support Oracle Database.
  • Autonomous – The world’s first self-driving database cloud is designed to perform maintenance tasks such as patch, update, back-up, all without any human intervention, and while the database runs.
  • Cloud-based data loading – Fast, scalable data-loading from Oracle’s Object Store. AWS S3, or on-premises.
  • Instant elasticity – Pre-configured compute and storage shapes can independently scale up and down, without any downtime.
  • Built-in Web-based SWL tool – Apache Zeppelin based notebooks ready to run from any browser.
  • Database migration utility – Dedicated cloud-ready migration tools for easy migration from Amazon AWS Redshift, SQL Server and other databases.
  • Enterprise grade security – Self-upgrades of security patches. Data is encrypted by default in cloud, as well as in transit and at rest.


The end-game for any e-commerce business is to observe and take advantage of all the data that is at their disposal, and to make it accessible to the team within the organization that has a need for it, to get insights and to use those insights to make the business run more smoothly. The ADWC by Oracle is designed to deliver industry-leading database technology with unmatched flexibility, enterprise scale and simplicity. The goal is to ensure that businesses get more value quickly from their collection of data and manage it more efficiently.

The machine learning process and systems stemmed from this advanced artificial intelligence do not just extract insights from the data fed. They actually change the underlying algorithms based on everything that is learned from the data collection process. Many companies are already using ADWC artificial intelligence to enhance their enterprises. Business leaders state that the Autonomous Data Warehouse Cloud is and will continue to be fundamental to future e-commerce success. The time is now to decide on data management strategies, new technologies and the best practices that will be essential for company growth and overall business success.

Every enterprise in this digital era will benefit from a single platform that empowers the entire organization to ask any question of any data type.

Oracle’s Autonomous Data Warehouse is offering that…!

Peter Jonathan Wilcheck – October 2018

  • 0 Comment


Get in Touch