Category: Conferences

Posted on

Oracle Autonomous Database: A DBA Perspective

When more people started using Autonomous Database services, more Admin tools are made available as well. When ADW was introduced, all the DBA had for monitoring or diagnosis or utilization was only the Service Console. Here are some administrative enhancements in ATP/ADW we saw in the past 1+ year.

  • July 2018: SQL Developer 18.2.0 and later allows for setting up connections without the need for Keystore passwords.
  • September 2018: Autonomous Data Warehouse allows users to create partitioned tables, indexes, and materialized views. 
  • March 2019: Autonomous Database provides cloning where you can choose to clone either the full database or only the database metadata. 
  • April 2019: A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. 
  • May 2019: Oracle Management Cloud supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. 
  • May 2019: It is possible to create a database link from an ADW instance to any database that is accessible from an ADW/ATP including other ADW/ATP instances.
  • June 2019: You can select auto-scaling during provisioning or later using the Scale-Up/Down button on the Oracle Cloud Infrastructure console.
  • June 2019: Oracle Rest Data Services (ORDS) is included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. 
  • June 2019: Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. 
  • June 2019: Autonomous Database includes Oracle’s premiere low-code development platform: Application Express (APEX). 
  • July 2019: Customers can get a real-time and historical view of performance data directly on the OCI console using Performance Hub.
  • August 2019: Autonomous Database supports multiple directories which makes it even easier for customers to migrate their existing applications to ADB.

Oracle Open World 2019 announced that there are two autonomous databases included in the Always Free tier! Great news!! Now, DBAs and developers have no reason not to get into Autonomous Database and start playing. Maybe you can develop an application using APEX and ATP for your favorite local charity 🙂

I will be comparing the traditional DBA activities against the activities you can do on ATP or ADW of Autonomous Database service in my talk “Autonomous Database: What’s the Admin’s Role?” on Sep 27th at the Arizona User Group meeting.

https://www.meetup.com/Arizona-Oracle-User-Group/events/264171869/
Posted on

#CodeOne Session: Let’s Talk AI, ML & DL

Date: Tuesday, 2019-Sep-17 6:00 PM
Location: Moscone South – Room 202
Session: DEV2161

Abstract: You hear everywhere that your job will be taken over by machines and that you need to be doing something else to be relevant. If the job involves making a decision based on a pattern or data analysis (radiology, for example), you can be sure that such a position will undergo a drastic transformation soon. Uber completed 10 billion rides in 2018, almost doubling the number of trips from 2017 to 2018. AI is used everywhere possible in Uber. Uber has changed your life and impacted millions of taxi drivers. This session goes over the basics of artificial intelligence, machine learning, and deep learning (DL) and discusses how these technologies impact you as a human being and as an IT pro. The future is bright; AI is a partnership, not a war.

The movies we watch usually portray intelligent machines being bad and set to destroy humans. Thanks to my colleagues who told me about the War Games movie. This one and the Terminator movie were released in the ’80s. AI is pure fiction in these movies, and give the notion that AI is something the humans must be scared of. AI has come a long way since the ’80s. Now AI is is part of our everyday life – We talk to “Siri”, ask “Alexa” to turn the light on or to play music.

The other aspect of AI is automation. They say the typical jobs that exist today will go away (like the DBA job). I think it is partly true – any job that involves repetitive tasks or analyzing images (radiology) will go through a transformation in the era of automation. That does not mean the job will go away. What you do may have to change.

AI and ML are going to play a major role in enterprises. To be successful and relevant, you must at least know the basics of AI & ML and understand how to use the AI/ML systems. If you are not familiar with Machine Learning, come to this introductory session to learn the basics, a few terminologies and most importantly what you can do to prepare yourself. Will share the job market trends and what is required to be a “Data Architect” or “Data Scientist”.