Skip to main content

Oracle 18c Goes for Database Automation in the Cloud

In what was probably the most important announcement made during 2017 ’s version of Oracle’s OpenWorld conference, the company announced the release of version 18c of its worldwide known database management system which includes two key features: to be a fully automated.

Oracle’s founder and CTO Larry Ellison made the announcement of the autonomous database, which includes database and cyber-security automation because, according to Mr. Ellison, “human processes stink”.


According to Oracle, the autonomous database will practically eliminate all human intervention associated with all database managing activities like tuning, patching, updating and maintenance by including major capabilities:

  • Self-Driving: Provides continuous adaptive performance tuning based on machine learning. Automatically upgrades and patches itself while running. Automatically applies security updates while running to protect against cyber-attacks.
  • Self-Scaling: Instantly resizes compute and storage without downtime. Cost savings are multiplied because Oracle Autonomous Database Cloud consumes less compute and storage than Amazon, with lower manual administration costs.
  • Self-Repairing: Provides automated protection from downtime. SLA guarantees 99.995 percent reliability and availability, which reduces costly planned and unplanned downtime to less than 30-minutes per year.

To achieve it, the new autonomous database has integrated applied machine learning techniques to deliver without human intervention, self-driving, self-tuning, self-recovering, and self-scaling management capabilities which aims to streamline operations and provide more efficient consumption of resources as well as higher security and reliability.

But first... the Data Warehouse

Oracle’s autonomous database service can handle different workload types including transactional, non-transactional, mixed or graph and IoT workloads yet, while the automated OLTP version is scheduled to be available by June 2018, Oracle’s first autonomous database service will be directed to data warehouse workloads, planned to be available 2017.

Much as like all their services, the design of Oracle’s Autonomous Database Cloud Service for Data Warehouse relies on machine-learning to enable automatic tune and performance optimization. By using artificial intelligence and machine learning, Oracle aims achieve autonomous control to offer reliability, performance and highly elastic data management services as well as to enable fast deployments that can be done in seconds.
(post-ads)
According to Oracle, some features to be offered by the new service include capabilities to:
  • Execute high-performance queries and concurrent workloads with optimized query performance and with pre-configured resource profiles for different types of users
  • Deploy highly elastic pre-configured compute and storage architectures to instantaneously scale up or down, avoiding overpay for fixed blocks of resources
  • Integrate Oracle SQL DWCS all business analytics tools that support Oracle database
  • Make use of its built-in web-based Apache Zeppelin based notebooks
  • Deploy a self Driving fully automated database for self-tuning patch, upgrade itself while the system is running
  • Take advantage of its database migration utility dedicated cloud-ready migration tools for easy migration from Amazon AWS Redshift, SQL Server and other databases
  • Perform cloud-based scalable data-loading from Oracle Object Storage, AWS S3, or on-premises
  • Deploy under an enterprise grade security schema on which data is encrypted by default in the cloud, as well as in transit and at rest
The new Oracle autonomous database cloud service for data warehouse aims to eliminate manual configuration errors and ensure continuous reliability and self-correction, It also includes, according with Oracle unlimited concurrent access and an advanced clustering technology to enable organizations to scale without any downtime.

With the inclusion of this service, Oracle is expanding its data warehouse software stack portfolio, expanding its services for both on-premises and cloud platforms and with different data services, aiming to reach a greater number of organizations each with different data warehousing management needs and complexities such is the case for existing data warehouse services available within Oracle Exadata, Exadata Cloud, and now the autonomous database cloud service.

The Rise of the Automated Database?

The ideal to achieve full database automation is not new and many, if not all, software vendors have made important efforts to automate different aspects of a database administration cycle —examples include Teradata and Attunity for automating data ingestion and data warehouse or those efforts made by third party software providers like BMC with BladeLogic Database Automation— and yet, until now full automation seemed to be an impossible task.

One main reason is that database automation involves not just the ability to achieve automation for common repetitive database configuration tasks including those involved with initial schema and security configuration but much more complex tasks including database tuning and performance monitoring which requires the ability adapt to changing conditions and require the system’s ability to learn and adapt.

The evolution of machine learning, artificial intelligence and cognitive computing technologies is certainly making this automation efforts possible and of course, Oracle deserves significant credit for embracing these technologies and taking a step further and aiming to achieve fully database automation.

As we should expect, it will not take long for other software providers to join the race and join the ranks of vendors offering fully automated database solutions, so as a cautionary message, it will be critical, in my view, to start by making comprehensive assessments of these solutions capabilities and accuracy before rushing to push the automatic pilot button and get rid of your DBA’s just yet.

You might realize it will take some time before you can lower your IT footprint.

Comments? Let me know your thoughts

Comments

  1. Despite the new features of Oracle Database 18c that are supposed to transform it into an autonomous database, the “Autonomous Database” remains a cloud service. As such, you will need to run the “Autonomous Database Service” on Oracle Public Cloud; simply installing Oracle Database 18c on premises – or in the Oracle Cloud – will not get you an autonomous database. Thanks!
    =================================
    https://astarios.com/dedicated-development-team/

    ReplyDelete
  2. Databases are a rather complex branch of computer science. At one time I studied databases and all my time was spent on studying databases. So I had to buy papers from BuyPaperCheap net 500 word paragraph service because I didn't have time to do anything. Despite the fact that I really like to write papers and I always do it only on my own, I had to order them, because the database section captured all of me and I could not stop to learn them, because I could hardly stay afloat.

    ReplyDelete
  3. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share. smart home surat

    ReplyDelete
  4. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. Visitor Management

    ReplyDelete
  5. The purpose behind executing automation in the retail market is an absence of abilities, assets, cash, and aptitudes. factory material handling self-driving vehicle

    ReplyDelete
  6. I like viewing this web page which comprehend the price of delivering the excellent useful resource free of charge and truly adored reading your posting. Thank you!
    Data Science Certification Course

    ReplyDelete
  7. Oracle 18c helps you to analyze your data with the help of Oracle Data Visualization and Data Discovery tools. The data visualization tools allow you to explore your data and find insights with charts, graphs, and maps. The data discovery tools allow you to explore data by filtering and sorting your data in many different ways. Oracle 18c can be used for tasks such as querying, reporting, and analyzing data. Oracle 18c can be used for enterprises, organizations, and government agencies. can i upload a pre recorded video to facebook live

    ReplyDelete
  8. This is very useful post for me. This will absolutely going to help me in my project stucco contractors Edmonton

    ReplyDelete
  9. I really thank you for the valuable info on this great subject and look forward to more great posts Industry Leading Degassing Solution

    ReplyDelete
  10. Great info! I recently came across your blog and have been reading along speciality coffee abu dhabi

    ReplyDelete

Post a Comment

Popular posts from this blog

Machine Learning and Cognitive Systems, Part 2: Big Data Analytics

In the first part of this series, I described a bit of what machine learning is and its potential to become a mainstream technology in the industry of enterprise software, and serve as the basis for many other advances in the incorporation of other technologies related to artificial intelligence and cognitive computing. I also mentioned briefly how machine language is becoming increasingly important for many companies in the business intelligence and analytics industry. In this post I will discuss further the importance that machine learning already has and can have in the analytics ecosystem, especially from a Big Data perspective. Machine learning in the context of BI and Big Data analytics Just as in the lab, and other areas, one of the reasons why machine learning became extremely important and useful in enterprise software is its potential to deal not just with huge amounts of data and extract knowledge from it—which can somehow be addressed with disciplines such as data

Next-generation Business Process Management (BPM)—Achieving Process Effectiveness, Pervasiveness, and Control

The range of what we think and do is limited by what we fail to notice. And because we fail to notice that we fail to notice there is little we can do to change until we notice how failing to notice shapes our thoughts and deeds. —R.D. Laing Amid the hype surrounding technology trends such as big data, cloud computing, or the Internet of Things, for a vast number of organizations, a quiet, persistent question remains unanswered: how do we ensure efficiency and control of our business operations? Business process efficiency and proficiency are essential ingredients for ensuring business growth and competitive advantage. Every day, organizations are discovering that their business process management (BPM) applications and practices are insufficient to take them to higher levels of effectiveness and control. Consumers of BPM technology are now pushing the limits of BPM practices, and BPM software providers are urging the technology forward. So what can we expect from the next

SAP Data Hub and the Rise of a New Generation of Analytics Solutions

“Companies are looking for a unified and open approach to help them accelerate and expand the flow of data across their data landscapes for all users. SAP Data Hub bridges the gap between Big Data and enterprise data, enabling companies to build applications that extract value from data across the organization, no matter if it lies in the cloud or on premise, in a data lake or the enterprise data warehouse, or in an SAP or non-SAP system.” This is part of what Bernd Leukert, SAP’s member of the executive board for products & innovation mentioned during SAP’s Big Data Event held at the SAP Hudson Yards office in New York City as part of the new SAP Data Hub announcement and one that, in my view, marked the beginning of a small yet important trend within analytics consisting on the launch or renewed and integrated software platforms for analytics, BI and data science. This movement, marked by other important announcements including Teradata’s New Analytics Platform as well