GenDev, Meet MultiOpenCloud: Oracle Cloud World 2024

Something was different this year at Oracle Cloud World 2024: There was a buzz this time that just wasn’t there in the last two OCWs I’d attended. It may have been the ubiquitous presence of Generative AI in just about every event I attended, or acceptance that it’s not the flash in the pan some prognosticators are predicting.

Keynote: One Cloud, One World, Zero Humans

It wouldn’t be OCW without Larry Ellison’s keynote, and he didn’t disappoint us with some surprises. For starters, Ellison announced that AWS and Oracle are partnering to build Exascale technology directly within AWS data centers. This will alleviate some sticking points for folks who want to run Oracle database technology and services within AWS environments. (I didn’t have that one on my OCW24 bingo card!)

The total number of private and public Oracle Cloud sites will top 160+ near the end of this year, with the largest one projected to exceed 1 Gigawatt for power requirements. Ellison has mentioned that he’s even considering using small modular reactor (SMR) technology to power the largest of those planned.

Ellison also talked about the need to dramatically increase the security of any public/private cloud, as Oracle has done within Autonomous Database (ADB). In fact, he said, Oracle will be moving all Oracle Applications within their Cloud environments into ADB to insure the security of autonomous systems.

Passwords are a terrible idea – too easy to steal or compromise! – and are the key infiltration points for any cyberattack. The solution, Ellison said, is to use biometrically authenticated logins for all access to the Oracle Cloud.

Finally, I was thrilled to hear him give a shout-out for Application Express (APEX) as the premier low-code application generation environment, given its capability to build applications from schema to screen without only minimal DBA or developer involvement.

Keynote: Oracle 23ai, APEX, and GenDev

Juan Loaiza, Oracle EVP for Mission Critical Database Technologies, dived in quite a bit deeper during his keynote into what generative AI portends for the future of intelligent application development, which he called Generative Development (GenDev for short).

Juan showed us how APEX – Oracle’s premier low-code application environment – can right now generate a complete application, including the database schema, application pages, and user interfaces with just a few natural language prompts to generative AI. I was glad to see that JSON Relational Duality is one of the cornerstones for removing an inexperienced data engineer or under-qualified Oracle DBA from the schema design process.

Later that day at our Oracle ACE dinner, I had a chance to chat with Juan about his keynote to let him know I really appreciated his perspective on GenDev, and also thank him for all his support for the Oracle ACE Program over the past several years. Juan, ever the humblest C-level executive I’ve met, told me he thought his session was a bit boring. I explained that to the contrary, it was one of the most informative sessions I’d seen recently, as it foretold a future of much simpler application development on the near horizon.

My Sessions: RAG, APEX, AIM, RAS

Turnout for every single one of my three sessions was surprisingly high at OCW24. I led off with a talk on how I’d built a prototype RAG solution for a stalled social media campaign, including all the steps to complete the APEX app, from gathering a corpus to my test results revealing some surprising hallucinations. (You can check out that session’s demo video here.)

I also teamed up with Andy Rivenes, the PM for Database In-Memory technology, to show off the latest features of 23ai Database in that realm. And my colleague and fellow ACE Director Karen Cannell teamed up at the last theatre session of the conference to show off the tricks we’d learned over the past few months when we deployed Real Application Security within a complex government agency’s environment.

All Right, Mr. DeMille, I’m Ready for My Closeup

Since I’m an Oracle ACE Director, I spent a lot of time on the exhibition floor: At the Oracle ACE Lounge, the Database Swag + Sweets booth, and (my personal favorite!) the Generative AI hologram station that Paul Parkinson from Oracle had built (video on that here.)

I’m working on making my events reporting much more dynamic, so this year I brought along a new steady-cam camera rig and remote Bluetooth microphone that let me record videos while walking around the floor and interacting with my fellow ACEs and Oracle staffers. My YouTube OCW24 playlist has a few other impressions too – please have a look, and I’d appreciate some feedback!

OCW25: Predictions

Finally, I’d be remiss if I didn’t hang out over my skis a bit and make some predictions for Oracle Cloud World 2025 next year:

  • Generative AI will become more focused into generating full-blown applications with even more limited involvement from DBAs, data engineers, and DevOps … which means we all should consider improving our prompt engineering skillsets to stay relevant.
  • LLMs will improve to the point where worrying about things like the proper chunk size for corpus documents will be unnecessary.
  • Security will still be a major focus; the only real unknowns will be how seriously huge the next breach will be and how many millions (or billions!) of people it will affect.

2018 Is Halfway Gone … But Not Forgotten!

It’s hard to believe that 2018 is half over already. I’ve had an incredibly busy six months traveling to and speaking at Oracle user groups events and conferences across the country, so it’s been another exhilarating six months for me … and that means you all have access to some great collateral and code!

I’ve added all four of my most popular presentations as PowerPoint slide shows for download. They’re chock-full of interesting insights into where our world as Oracle DBAs and applications developers is headed, plus some great code samples to boot.

Don’t forget to check out my overview of #SmartDB because it’s got some great examples of how to leverage Edition-Based Redefinition (EBR) and cross-edition triggers to make it simpler to handle application migrations and upgrades with no application downtime. And because everything I’ve shown you is a mere soupcon of how #SmartDB works, don’t forget to take at the links I’ve included in that presentation to (much!) deeper dives on #SmartDB by my colleagues and mentors Bryn Llewelyn and Toon Koopelars.

And the rest of 2018 will be equally busy: I’m headed off to South America to participate int the 2018 Latin America Oracle User CODE events in August, then heading over to ECOUG in September, and wrapping up my October with presentations and learning at OOW18. I hope to see you soon at an upcoming event!

Este Agosto, No Te Pierdas Mis Sesiones En LAOUC!

I am embarrassed to admit that I’ve ignored my dear colleagues just a few thousand kilometres to the south of Chicago for much too long … so it is a great honor to return to South America as part of the 2018 Latin American Oracle User Group (LAOUC) Developer Community Tour conference series this coming August 2018!

For now, here’s the schedule of where I will be presenting … but be sure to check the official LAOUC web site or the links below for the most up-to-date information on registering for these upcoming sessions:

July 31: Asuncion, Paraguay

August 2: Santiago, Chile

August 4: Sao Paolo, Brazil

August 6-7: Montevideo, Uruguay

August 9: Buenos Aires, Argentina

I’ll be talking about several topics that focus on some of the newest tools we can take advantage of for our developers, including how to choose the right Oracle Cloud for your development tasks at hand, with some really neat examples of how easy it is to use APEX in concert with Exadata Express for Oracle 12cR2 as well as DBaaS with Oracle 18c. I’ll also offer my viewpoints and code examples of how best to bring our developers’ application code back inside the Oracle Database in a sensible fashion through the #SmartDB paradigm.

So if you are going to be near any of these venues this August, I hope to see you there! Hasta luego, mis amigos y amigas!

Oracle DBAs Weigh In: Fear Not the Autonomous Database!

I’ve had the honor to share a page in Fortune Voice with some of my most esteemed and respected colleagues – including Michelle Malcher, Nitin Vengurlekar, Russ Lowenthal, and Dan Vlamis – on the topic of what the Oracle Autonomous Database (or what I like to call AuDB) means for Oracle DBAs as they continue to upgrade their careers from DBA 2.0 to DBA 3.0.

Michelle, Nitin, Russ and Dan all offered different viewpoints on what AuDB offers to the common DBA, and I concur heartily! I can’t wait to see what the OLTP version of AuDB will bring for us DBAs who are often tasked with keeping hundreds of different databases up and running in good health. It will be an interesting voyage!

 

2017 Is [Almost] a Wrap: Sample Code, Ruminations, & Portents for 2018

2017 has been an incredibly busy year! Besides speaking at half a dozen different Regional Oracle User Groups this year, I co-authored two new books, experimented in depth with Oracle Public Cloud, and helped my latest employer, ViON Corporation, build out their Oracle Gold partnership from the ground up, one customer at a time. It’s been an exhilarating experience for me, but for you, it means access to some great collateral and code:

  • I’ve added all three of my most popular presentations as PowerPoint slide shows for download. Many folks have asked me for the sample code in the two most technical presentations on Oracle 12cR2 Database In-Memory feature explorations and Analytic views. Just in case you missed out on seeing me present at one of my numerous conference engagements this past year, I hope these presentations help you with your experimentation.
  •  I’ve also added a link to all of the code examples for my most recent book, PDB Me to Oracle Cloud Pocket Solutions Guide: A Lazy DBA’s Guide to Mastering Multitenant Features on Oracle Cloud, that I co-authored with good friend and fellow Oracle ACE Director Charles Kim from Viscosity NA. It’s a great little handbook that explores some of the neatest features of Oracle 12cR2 multitenancy, including the ability to move a PDB between different CDBs without ever facing any application downtime. Oh, and by the way – it’s all done in the Oracle Public Cloud!
  • Check out my most recent article on IOUG SELECT that include my impressions from Oracle OpenWorld 2017. I review what Larry Ellison’s keynotes revealed for the future of Oracle and what those revelations most likely mean for the role of Oracle DBA in the coming months and years.
  • Finally, Oracle Technology Network just published my latest article that explores the unique advantages of leveraging Oracle Public Cloud’s Exadata Express features for a robust, automatic, and powerful Cloud-based platform, especially for experimenting with Oracle 12cR2 Database In-Memory features at a reasonable cost before investing in it for your on-premises databases.

Enjoy, my colleagues! Here’s to a 2018 that’s full of surprises. Only good ones!

SANGAM17: India, Here I Come At Last

At the request of my colleagues in India – especially the ever-persistent Oracle ACE Director Sai Janakiram – I have at last found a window of time during which I can attend the annual SANGAM17 event in Hyderabad. (It helped that Sai apparently recruited our fellow ACE Director Bjoern Rost to call me out as a wimp for not being willing to travel halfway around the world 24+ hours to India and to provide some much-needed mentoring for our younger colleagues there. Hint: Don’t ever call a guy from Chicago a wimp.)

I’ll be presenting three of my favorite topics, plus a brand-new one tailored specifically for my brother and sister Oracle colleagues in India:

DBA 2.0 Is Dead. Long Live DBA 3.0!

Cloud. DevOps. Agile. Big Data. 12cR2. So much to worry about if you’re an Oracle DBA who hasn’t made the transition from DBA 2.0 to DBA 3.0! Let me help you make the transition with a brief presentation – no code samples, just my viewpoints! – about the the future history of the DBA role in the USA.

Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS

I’ll discuss and demonstrate what I’ve discovered about several aspects of Oracle Database 12cR2’s newest Database In-Memory features, including In-Memory Expressions, ILM ADO Policies for In-Memory Objects, and improvements to In-Memory Joins and In-Memory Filtering.

Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2

I’ll discuss and demonstrate how to leverage the unique features of Analytic Views in 12cR2 that can save an Oracle DBA and application developers from writing inordinately complex code to solve multi-dimensional analytic queries.

Want to Be Successful In IT? Follow the PRIYA Principle.

As SANGAM17 draws to a close, I’ll be speaking at some length about the essential qualities of a true Information Technology professional. I’m honored to have a chance to present my observations from my 35+ years in IT and explain what I believe you’ll need to do to stay ahead of the curve in the coming years as the demand for professional resources increases.

Forestall Failure Before You Upgrade With Oracle 12cR1 RAT

TIOUG_Logohe second part of my two-part series entitled Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database Real Application Testing (RAT) Suite has just been published in IOUG SELECT Journal’s 4th Quarter 2016 edition. This part of the article series show how I leveraged RAT’s Database Replay features to evaluate Oracle Database 12.1.0.2’s Database In-Memory features. If you don’t have an IOUG membership, you can still browse a copy of my article in PDF format … but seriously, shouldn’t you become a member of one of the best Oracle User Groups in North America?