[MUSIC] Welcome to Oracle University's Oracle Cloud infrastructure course on the Oracle autonomous database. Today I'm going to describe the autonomous database architecture and integrations. My name is Kay Malcolm I am a Senior Director of database product management here at Oracle. After our time together as up, you're going to be able to define the architectural components of ATB and its key features. So let's dive right in. What does Oracle Autonomous Database or ADB do to help customers, you? The biggest benefit is the massive decrease in time spent managing databases. ADB eliminates the complexity of operating and securing Oracle database. While giving you the highest levels of performance, scalability, and availability. Operational costs are reduced a whopping 90% by automating every aspect of the stack. From the infrastructure to the database to machine learning based automation, ADB ushers in a new era in data management. Radically changing the way that companies deal with the database and in data management in general. This new class of databases are based on the world's most secure available performant and reliable database, you guessed it Exadata. This new era is available in both the public cloud and on prem. We're going to talk about that a little later. And it's not just for new applications, the four nines of uptime, so 99.995% ensures that even mission critical applications are always available. The largest enterprises and governments already run their mission critical workloads with the Oracle database on Exadata. ADB offers them the safest Transition to the cloud. Administering a mission critical database is traditionally really expensive, because it requires manual provisioning, securing, monitoring, patching, backing up, upgrading, recovering, troubleshooting, testing. And running of a complex, highly available Scale out deployment with disaster recovery protection. The extensive automation provided by autonomous database drastically simplifies these tasks, reducing administration costs by up to 80%. New application development often suffers from many months of delays. Waiting for database provisioning, testing, tuning with ADB new applications don't have to wait at all. Saving 10s of 1000s of dollars. Per application and enabling much faster innovation incremental changes around the edges aren't enough to answer these challenges. Even moving the entire enterprise computing estate to the cloud is only a partial solution. Because, it just shifts many of the same management difficulties to a different infrastructure. Instead, IT leaders need to strike at the heart of the matter, rethink data management for cloud native world. They need data management that can manage on its own. The core activities are performance, security and availability, this new approach to data management. Has to make data appear as if it were stored in a shape and made available at a scale ideal for the current workload without having to predict it ahead of time. To deliver data management service like this, IT leaders need a new kind of database. Downtime for critical applications. Causes severe financial and reputational damage. IT leaders must be sure that the cloud architecture they adopt handles every threat to availability. From software and hardware failures and maintenance to natural disasters. ADB is more reliable than a manually operated database. At startup, it automatically establishes a triple mirrored configuration in one regional Oracle Cloud Data Center. With an operational full standby copy in another region. ADB automatically recovers from any physical failures. Whether at the server or the data level. ADB's fault tolerant scale out cluster that works transparently for both OLTP and analytic workloads, make it uniquely capable of running mission critical workloads. Flexibility is built into ADB on purpose to ensure the smoothest and easiest transition. Now there are two deployment options I'm going to talk to you about today, shared and dedicated. Shared infrastructure provides a simple and elastic database. Dedicated infrastructure provides a private database cloud that enables IT to achieve the highest degree of security and governance. While providing a completely self service database experience to its users. It's easy. Oracle automates and manages everything deployment life cycle, software updates, patching. The customer that's you, simply choose his database compute, storage and the region. It's elastic. There's a low minimum size of one 1OCPU, a low minimum time commitment of 1 hour, and it automatically scales online for true pay per use. Dedicated infrastructure provides complete isolation for a single tenant. Adding the ability to customize operational policies to allow align Oracle's autonomous operations with application life cycles, dedicated infrastructure delivers a win win. Providing it with control over governance, best practices and budgeting. While providing developers complete independence of execution with agile self service and self tuning capabilities and databases. The simple fact of the matter is everyone can pick up and move to the public cloud. There are certain regulations around certain data, they require it to remain in a specific place. Whether that's latency issues, applications that need to integrate with that data that prevent from moving to the public cloud. A big concern depending on the nature of the data is sharing the cloud with other customers. Not an issue for ADB autonomous database runs in both the Oracle public cloud and cloud at customer environments to address those concerns, can't move to the cloud. We bring the cloud to you dedicated region cloud at customer, where consumers get an entire slice of OCI or Oracle Cloud infrastructure that's compute, network and storage. And all Oracle past service offerings like autonomous database and Exadata Cloud at customer Both running inside the customer's data center. Autonomous database on exadata cloud@customer is where customers get to run their databases on the autonomous cloud service in their data center. We've touched on ADB features. Let's talk about it a bit more like an autonomous car. Oracle autonomous database provides a level of performance and reliability that manually managed databases just can't deliver. It can provision, secure and manage in a way manual databases cannot. Let's look at provision. Oracle quickly deploys a mission critical database on our exadata infrastructure cloud, a platform optimized for Oracle database. The database is created as a rack cluster so it can scale out seamlessly, but also protect the database in case of a server failure. In order to protect the system against a complete failure,we also create a standby system, using active data guard in a different region in the cloud, to protect against regional failures. Let's talk about security. Once provisioned, the system needs to be secured. By default, we encrypt all the data in the database. But encrypting the data at rest is just not enough. All connections to the database better be fully encrypted to. To ensure systems are not exposed to any security vulnerabilities. We also apply security patches as soon as they're available. Oracle applies all the OS, VM and database patches plus we diagnose all problems. We use machine learning to help us detect and diagnose errors. ADB detects and protects from system failures and user errors automatically, and provides failover to standby databases with zero data loss. It provisions highly available databases, configures in tunes for specific workloads, and scales compute resources when needed. All done automatically. To enable true pay-per-use. Without human direction, ADB uses indexers, optimizer statistics and plans and optimized data format to run workloads and achieve the best performance. Autonomous Database consists of a single set of technologies Available in multiple products, each tailored to a different workload. The Oracle autonomous data warehouse or ADW is the simplest and most efficient database for data Mart's reporting databases and data warehousing. The Oracle autonomous transaction processing, or ATP, is designed for all enterprise applications, from simple web apps, to your more complex, mission critical, enterprise applications. Including mixed workloads ,and real-time analytics, with no compromise on app performance. AWS ATP organize data differently at W uses a columnar format, while ATP uses a row format. The memory in ATW is used to speed up joins and aggregations while an ATP memory is used for caching in ATW. The subscription also includes a subset Database in memory and advanced analytics. With ADB, you are not locked into an expensive large configuration. You can manually scale the databases based number of CPUs. Up or down at any time, CPU scaling does not require any downtime. Auto scaling can be used to increase cores in use automatically and decrease them when they're not needed. To wrap up, the ATP architecture decreases the time spent managing the database by decreasing complexity. Thanks for watching. Now go spin up an ADB instance. It's free
