• How Autonomous database and AI change the work of database administrators

  • Feb 6 2024
  • Duración: 24 m
  • Podcast

How Autonomous database and AI change the work of database administrators Por arte de portada

How Autonomous database and AI change the work of database administrators

Escúchala gratis

Ver detalles del espectáculo

  • Resumen

  • Artificial intelligence or AI is everywhere from movies to healthcare. In this episode, Tyra Crockett Peirce speaks with Oracle database expert Ace Director, Jim Czuprynski, about how AI is changing the jobs of database administrators and the skills that students need to learn if they want to pursue a career as a DBA. -------------------------------------------------------- Episode Transcript: 00;00;09;03 - 00;00;27;21 Welcome to the Oracle Academy Tech Chat. This podcast provides educators and students in-depth discussions with thought leaders around computer science, cloud technologies and software design to help students on their journey to becoming industry ready technology leaders of the future. Let's get started. 00;00;27;29 - 00;00;57;02 Welcome to Oracle Academy Tech Chat, where we discuss how Oracle Academy helps prepare our next generation's workforce. I'm your host, Tyra Crockett. Artificial Intelligence, or A.I., is everywhere, from the movies to health care. In this episode, I speak with Oracle database expert and ace director Jim Czuprynski about how it is changing the jobs of database administrators and the skills that students need to learn if they want to pursue a career as a DBA. 00;00;57;14 - 00;01;24;03 Jim Czuprynski has been an Oracle DBA for 20 plus years. During that time, he's taught 2000 plus students in the finer points of Oracle database administration. As an Oracle University instructor coauthored four books on Oracle technology and has spoken dozens of times at user group conferences around the world. During that time, he's seen plenty of dramatic changes to the DBA role, especially after autonomous database was introduced. 00;01;24;14 - 00;01;25;09 Welcome, Jim. 00;01;25;19 - 00;01;27;05 Thank you, Tyra. It's great to be here. 00;01;27;11 - 00;01;32;15 To go ahead and get started off, can you give me a little bit about your background and your current job role? 00;01;32;26 - 00;01;56;08 Absolutely. These days, I'm more of a technology advocate, but to be honest, I'm still at heart an Oracle DBA, as I have been for over 20 years. I go back all the weight. Oracle 81723. So as you might imagine, I've seen quite a few changes in the Oracle database and the hardware that it runs on over that time. 00;01;56;18 - 00;02;20;18 These days I'm actually kind of back into some of the really neat features that are built into just about every Oracle database. Especially Oracle 23. See our latest release that's almost ready for general availability. And most platforms. And I really enjoy delving into things like graph and spatial and machine learning and analytics. 00;02;21;18 - 00;02;31;27 So my next question is kind of a little bit along those lines. The Oracle Autonomous Database was launched a few years ago. How does it differ from previous versions? 00;02;32;15 - 00;02;59;12 Wow. The autonomous database, or most of us call it ADB for short. It has features that are already present in the most stable release of the Oracle database. That's typically on premises right inside an organization's local data center or maybe even an on premises data center. But the big difference about autonomous database, first off, is that it runs inside ORCL cloud infrastructure. 00;02;59;19 - 00;03;27;25 And best of all, it runs on, in my opinion, the best hardware ever built for Oracle database workloads. Oracle Exadata, which is an extremely robust environment. It eliminates a lot of performance bottlenecks that are inherent in traditional on premises database hardware and I speak from experience. I built servers back in the day to run Oracle 8 and 9 even 10. 00;03;28;19 - 00;03;35;22 It's not trivial to build a robust database working environment. 00;03;36;09 - 00;03;44;00 So let's kind of go on to AI a little bit. So how is a I used in an autonomous database or ADB? 00;03;44;27 - 00;04;20;19 That's a great question. EDB uses A.I. in many different forms underneath the covers, and it really automates a lot of tasks that a typical DBA doesn't necessarily have the bandwidth to perform everything from something called automatic indexing. We'll talk about that a little bit later, I hope. Things like automatic scaling of CPU's based on demand that it observes automated database patching, and even the ability to automatically identify. 00;04;20;19 - 00;04;47;01 And this is really cool, a poorly executing SQL statement and essentially quarantined them so that somebody from the DevOps slash DB 18 can scrutinize them and go, Why are these things taking up so much bandwidth as the next release? Oracle 23 C rolls out for ADP. There are several new AI controlled features, including and these are really cool. 00;04;47;10 - 00;05;17;29 Automatic transaction rollback, for example, a transaction might be holding a roll lock and blocking a higher priority transaction. You can actually configure that so that that will happen within boundaries automatically. Another thing ...
    Más Menos
activate_primeday_promo_in_buybox_DT
Más Menos

Lo que los oyentes dicen sobre How Autonomous database and AI change the work of database administrators

Calificaciones medias de los clientes

Reseñas - Selecciona las pestañas a continuación para cambiar el origen de las reseñas.

Reseñas de Audible.com

Opiniones de Amazon
No hay comentarios disponibles