Which infrastructure options are available for creating and managing an autonomous database?
20.Which two are correct actions to take in order to download Autonomous database credentials? Show
34. The Oracle Autonomous database dedicated Exadata infrastructure feature is based upon which oracle cloud resources? Other sets by this creatorOracle’s Autonomous Database was first released in 2019, initially on 18c and now upgraded to 19c. This paper will go over some of the basic concepts and features of Autonomous Database and walk you through a primer on setting up and deploying an Autonomous Database on the Oracle Cloud. Oracle’s “Autonomous Database” – An IntroductionThe Autonomous Database continues to be one of the biggest innovations ever to happen in the Database World since the Oracle Exadata. A 2020 detailed database review, placed Oracle as the most innovative database primarily because of Autonomous Database[1]. Gartner rated Oracle the #1 database in most every major category because of features, Autonomous Database, other innovations that other databases didn’t have, and Exadata leveraging database features (InMemory is a big one). Of course, Autonomous Database always runs on Exadata! Whether it’s in the Oracle Cloud or Cloud at Customer. Some of the main reasons to move, at the minimum, lesser-used & smaller databases to autonomous include:
If you are currently on 12c, you should upgrade to 19c soon. Use Autonomous Database as a great way to try out some of the new features on newer versions of Oracle:
Note: Oracle Machine Learning for Python (OML4PY) gives you a nice and easy-to-use Python interface to Oracle DB Machine Learning algorithms. By default, Autonomous Database’s run on shared Exadata infrastructure, but one has the choice to run on dedicated Exadata infrastructure as well (at a cost). Exadata can also be leveraged without the Autonomous Database in the Oracle Cloud, Cloud at Customer, or On-Premise. Note the incredible Exadata features ( that will make complex Machine Learning algorithms run like a dream. Your next question is where is my data when it makes its way to the Oracle Cloud or to the Autonomous Database? This is another area where Oracle really shines with 29 current Regions to connect to and another 9+ coming (even more than the 36 by 7/2021). New Role for the DBA under Autonomous DatabasesThe role of the DBA is being stretched to include managing not just an ever-growing number of Oracle Databases to manage, but also other data sources, other types of databases, Big Data, and IoT. Oracle is used as the Secure Portal (via Big Data SQL) to get to other data sources like Hadoop[2]. Things to Focus On: Let the Autonomous Database capabilities take some of the load of the DBA work and change the DBA’s focus.
The DBA must also be the agent of change to improve their own role. Leverage Autonomous DB for lesser-used databases, while also ensuring that it is done effectively & efficiently. Oracle’s Andy Mendelsohn recently showed how other vendors built a plethora of databases to solve different data issues, while Oracle’s converged database makes life easier to consolidate any type of database. Converged Database & Oracle Security is why Oracle has remained the #1 database for decades. The DBA will be critical to leverage Oracle with all data types effectively. In other words, DBA is still critical for Autonomous Databases in the future:
The answer is obvious: A DBA, but not a simple DBA; A DBA that has evolved with all this new generation of databases on Cloud. Where Do You Start?You can try out the Autonomous Database for 30 days at cloud.oracle.com/tryit or oracle.com/cloud/free. It will take you to a screen (Figure 1) that will allow you to register for a free trial. The free trial gives you access to many products, but you are able to continue to use the Autonomous Database indefinitely (as long as you are using it regularly). Go through the registration process and then log into your account Figure 1: Set up your free trial todayFigure 2 shows some of the tools that you can also try out during your free trial. The key ones include the Autonomous Data Warehouse, Autonomous Transaction Processing, Bare Metal Database, NoSQL, and Analytics. Figure 2: Some of the free tools to try during your 30-day trialFigure 3 shows some additional tools that you can also try out during your free trial. The main ones include Kubernetes, Big Data, Ravello (for migrating other types of databases to Oracle), Oracle Management Cloud (OMC), IOT (Internet of Things – not listed), and Autonomous JSON. Figure 3: Some additional free tools to try during your 30-day trialOnce you log in, Oracle takes you to the Get Started Screen. Notice that if you want to continue with the free version, this also tells you which products are Always Free Eligible. You can also select these items from the “hamburger icon,” the three lines in the upper left corner of Figure 4. Figure 4: Get started ScreenCreating an Autonomous DatabaseLet’s create an Autonomous Transaction Processing (ATP) Database. Click on the “Create an ATP Database” box in Figure 4. Notice the choices that come up in Figure 5 for ATP (Autonomous Transaction Processing), ADW (Autonomous Data Warehouse), and AJD (Autonomous JSON Database). In this case, we will go ahead with the “transaction Processing” option. Figure 5: Creating an ATP databaseOnce the request is submitted, the provisioning of the ATP database begins (Figure 6). In 2 ½ minutes, the ATP database was provisioned and ready for use (Figure 7). Post provisioning, one can easily scale the database up or down (CPU or DB Size) with a few mouse clicks (Figure 8). If we wish, the oracle cloud will even take care of upgrading the database to 19c at the appropriate time (Figure 9). Finally, Figure 10 is confirming that the 19c ADW database is available & ready for use. Figure 8: Scaling databases up or downFigure 9: Automated upgrade to 19cFigure 10: DW database ready for useBuilding an Autonomous JSON Database (AJD) is also a very similar process, select the AJD option available once we click on the Hamburger icon in the top left corner (Figure 11). Provisioning an AJD took about 5-7 minutes. (tried it twice). Figure 11: Creating an Autonomous JSON DatabaseNote: JSON became the defacto developer’s choice (over XML) largely due to its inherent simplicity and ease of use. Autonomous Database & Machine LearningI believe that leveraging the Autonomous Database for Machine Learning is the best use of all! It makes it easy to use SQL & PL/SQL to leverage built-in algorithms that Oracle’s massive AI, Machine Learning, and Data Science team has put together over the past decade-plus. Figure 12 shows how to go from the Service Console to Development (includes: SQL, APEX, and Machine Learning). Figure 12: Accessing machine Learning Capabilities for ATP databasesFigure 13 shows how to get started, run SQL, or look at some great examples templates made available by Oracle (Figure 14). Figure 13: Access Machine Learning SQL, Notebooks & Examples Figure 14: ML Examples provided by OracleBut, the number of algorithms and business applications are even more numerous (see Figure 15). Figure 15: Algorithms for Machine Learning Oracle provides & other features worth leveragingSummaryWe’ve covered a lot in this Autonomous Database white paper. We started with why you want to use it, your new role if you’re the DBA, how to create it (ATP, ADW, AJD) with a 30-day free trial, how to leverage it for Machine Learning, and finally the benefits of the Exadata. When you look to migrate to 19c, implement ATP, ADW, or AJD; remember to give Viscosity a call to help. References
[1] KuppingerCole Report – Leadership Compass – Enterprise Databases in the cloud- https://www.oracle.com/database/solutions/kuppingercole-database-compass/ [2] https://searchoracle.techtarget.com/feature/Oracle-sees-Autonomous-Database-changing-DBA-roles-for-the-good About the AuthorRich Niemiec is the current Chief Innovation Officer of Viscosity North America. He is an Oracle ACE Director, a world-renowned IT expert, and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. TUSC was the Oracle Partner of the Year in 2002, 2004, 2007, 2008, 2010, & 2011 (Rolta TUSC). Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich is in the Chicago & E&Y National Entrepreneur Hall of Fame. Which two infrastructure options are available for creating and managing an autonomous database?When you create an Autonomous Database, you can deploy it to one of two kinds of Exadata infrastructure:. Shared, a simple and elastic choice. ... . Dedicated on Public Cloud, a private cloud in public cloud choice.. On what infrastructure does the autonomous database run on?By default, Autonomous Database's run on shared Exadata infrastructure, but one has the choice to run on dedicated Exadata infrastructure as well (at a cost).
Which two infrastructure options can you use for deploying an Oracle autonomous database?Oracle Autonomous Database can be deployed in 2 ways – dedicated and serverless.
Which are the three types of autonomous databases you can deploy?According to Oracle, the Oracle Cloud Infrastructure's Autonomous Database (ADB) is a fully-managed, preconfigured database environment with three workload types available; Autonomous Transaction Processing, Autonomous Data Warehouse and Autonomous JSON Database.
|