What is oracle autonomous database – definition from whatis.com data recovery iso

Oracle autonomous database is a cloud-based technology designed to automate many of the routine tasks required to manage oracle databases, which oracle says can free up database administrators ( dbas) to do higher-level and more strategic work. Introduced in 2017, the technology combines the company’s oracle database 18c software with a set of automated administration services that use machine learning algorithms. Oracle 18c itself isn’t autonomous — the automation capabilities are provided by what oracle has added on top of it to create autonomous database. The combination is offered as a cloud service called oracle autonomous database cloud, which oracle describes as "self-driving, self-securing and self-repairing."

Oracle autonomous

Because of its machine learning functionality, oracle autonomous database is able to assimilate the information that it needs to take care of itself.

For example, the autonomous software provisions databases on its own, finding, allocating and configuring all of the necessary hardware and software for users.

Oracle autonomous database also doesn’t require manual tuning to optimize performance; the technology tunes itself, including automatic creation of database indexes to help improve application performance. It also automatically applies database updates and security patches, backs up databases and encrypts data to protect information against unauthorized access.Oracle autonomous

The system patches itself on a regular quarterly schedule, although users can override this feature and reschedule the automatic patches if desired. Oracle autonomous database can also apply out-of-cycle security updates when necessary — for example, if oracle releases an emergency patch to address a zero-day exploit. Additionally, the technology uses oracle’s database vault tool to prevent oracle dbas from seeing user data and the company’s data masking feature to identify and conceal sensitive data.

Oracle autonomous database can scale itself up as needed; it also monitors capacity limits and bottlenecks in key system components in an effort to avoid performance problems.Oracle databases updates are applied in a rolling fashion across a clustered system’s compute nodes so applications can continue to run during the process, and autonomous database automatically repairs itself in the event of a system failure, according to oracle, which guarantees 99.995% uptime on the cloud service.

The technology gathers statistics as new data is uploaded, and regularly runs tests to ensure that all changes and upgrades are safe. It scans for issues across all layers of the technology stack using diagnostic tools such as orachk, exachk, oswatcher and procwatcher. If an error occurs, autonomous database collects relevant diagnostic data, analyzes logs to establish a timeline and works backward to solve the problem.Oracle autonomous for example, it can back out data errors made by users. Benefits of using autonomous database

Oracle autonomous database is likely to change the way that oracle dbas function in organizations that adopt the technology. Because many of the more mundane tasks that dbas now handle will be automated, oracle says they’ll be able to focus on things like data security, data lifecycle management, data architecture and data modeling. Additionally, dbas could gain more time to work on new projects and help both development teams and end users to take better advantage of oracle databases.

From an organizational standpoint, using autonomous database could reduce the need for human labor on oracle data management teams, although oracle says it expects the autonomous software to alter DBA jobs instead of eliminating them outright in most cases.Autonomous database the technology could also minimize data loss and human error in oracle databases, while cutting back substantially on both planned and unplanned downtime.

Oracle autonomous database runs on the company’s exadata hardware platform and can be used either in the oracle cloud or via cloud at customer, a service that deploys systems based on oracle’s cloud technologies in on-premises data centers.

Oracle is developing multiple product offerings as part of the oracle autonomous database cloud service. The first was an implementation for data warehousing that became available in late 2017 to support business intelligence and analytics uses; other versions will follow for transaction processing workloads and nosql databases, according to oracle.Oracle databases

Related terms correlated subquery A correlated subquery is a SQL query that depends on values executed by the outer query in order to complete.

See complete definition oracle timesten in-memory database the oracle timesten in-memory database is an in-memory relational database in which all data is located in random access memory (…

See complete definition virtual private database (VPD) A virtual private database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be …