Getting to grips with JSON in the database

With Oracle 21c and 23c, JSON in the database is now a reality. Mixed relational-JSON databases are on the verge of becoming mainstream.

In this session, using practical examples in the Oracle Cloud, we'll look at:

Generating JSON objects from relational data using SQL and PL/SQL

• JSON_OBJECT
• JSON object types
• apex_json

PLSQL's Believe it or not

The basics of the PLSQL language are very easy to learn. Deceivingly easy. At one customer I saw what happens when people, after a brief introduction to PLSQL, think "This is simple, I can do this". I worked for this customer (no, I will not reveal their name) where the databases that I had to work with were built by people with obviously just a very basic understanding of the Oracle database and especially PLSQL. Many times a day I was shaking my head over the solutions that had been invented and the fixes if things didn't work. I would like to take you along on a journey through some of the things that I saw there. Come see how to not do a calculation in PLSQL, how not to get to know the number of rows in a collection, how not to repond when utl_file 'ignores line endings', why they claimed that Oracle's error messages have noting to do with what is actually wrong, and many more. And of course I'll also show you how it can be done better, just in case you don't know already. Mainly for fun, because I hope you will already know that these things are not the way to do it. However, if you see something and think "that's how I would have done it", don't be ashamed. None of us knows everything. We all make mistakes. We all do stupid things. But, if you think "I could have done that" with all of the examples ...... I know just the workplace for you :D

CI/CD of relational databases

Continuous Integration and Delivery (CI/CD) for database applications is becoming more common. Many projects create CI/CD pipelines to make their work easier and improve integration and deployment quality. Many tools promise a comprehensive solution for implementing database CI/CD and solving all kinds of problems. But what is known about database CI/CD from a scientific point of view? What elements are necessary for efficient and effective CI/CD? What improves team performance and reduces the risk of releases? This talk will present the latest data from a database CI/CD research project and examples of database CI/CD pipelines.

PLSQL's Believe it or not

The basics of the PLSQL language are very easy to learn. Deceivingly easy. At one customer I saw what happens when people, after a brief introduction to PLSQL, think "This is simple, I can do this". I worked for this customer (no, I will not reveal their name) where the databases that I had to work with were built by people with obviously just a very basic understanding of the Oracle database and especially PLSQL. Many times a day I was shaking my head over the solutions that had been invented and the fixes if things didn't work. I would like to take you along on a journey through some of the things that I saw there. Come see how to not do a calculation in PLSQL, how not to get to know the number of rows in a collection, how not to repond when utl_file 'ignores line endings', why they claimed that Oracle's error messages have noting to do with what is actually wrong, and many more. And of course I'll also show you how it can be done better, just in case you don't know already. Mainly for fun, because I hope you will already know that these things are not the way to do it. However, if you see something and think "that's how I would have done it", don't be ashamed. None of us knows everything. We all make mistakes. We all do stupid things. But, if you think "I could have done that" with all of the examples ...... I know just the workplace for you :D

Oracle The Most Mysterious Cases

It was on a cold day in November when the silence was broken by a desperate scream: ‘Kill it! Kill it!”. The boss immediately pushed the button and brutally terminated the session. It has happened again… The Performance was murdered. Boss flicked through the case files. There were no usual suspects. Where is the murderer hiding then? The desk was buried under the cases’ files similar to this one. The File that hasn’t been seen in production for 6 months, the whole team has been looking for it, but there was no progress, not even a clue… Another reported missing - Data has left the Source System but never reached the Destination server…Nobody has seen it again… This is too much for one person. And that’s why I need YOUR help! During the session, we will solve all the mysterious cases together and we will find out what is responsible for the strange behavior of the system. Is the source of the problem a huge design error or a small decision at one of the stages of development? How minor design decisions can affect the system's performance and vulnerability to errors? Who is the murderer? The answer may surprise you!

Merjenje performanc pred in po Oracle migraciji

Kako ugotoviti ali se baza na novem strežniku, drugi platformi ali celo na drugi ediciji (enterprise/standard), odziva hitreje ali počasneje? Kako identificirati SQL stavke, ki so bili po migraciji počasnejši? Zakaj in za koliko so bili hitrejši v novem okolju?

Marsikatera organizacija se za odgovore na tovrstna vprašanja zanaša na dolgoletne izkušnje DBA-ja. Mi pa bomo tokrat prikazali, kako lahko pridemo do teh odgovorov tudi brez pisanja SQL stavkov, tako na Standard kot tudi na Enterprise Edition.

Kako lahko pohitrimo razvoj z Oracle tehnologijo

Zavod ima že zelo dolgo zgodovino razvoja programske opreme. V zadnjih dobrih desetih letih smo s prenovo celotnega informacijskega sistema prešli na nove tehnologije in platforme. S tem smo močno povečali in pohitrili razvoj poslovnih rešitev. S prehodom na bazo Oracle se je to samo še povečalo. Na predavanju bomo predstavili integracijo programskih rešitev zavoda, kjer uporabljamo tehnologije Oracle. Osredotočili se bomo predvsem na integracijo izvedb aplikacij (različnih tehnologij) v naše okolje DevOps, ki v celoti temelji na produktih odprtih standardov in uporabo ""free"" orodij (integracija SQLcl, plsql2gitlab). Ena od razvojnih tehnologij, ki temelji na Oracle je tudi platforma RASD. S prehodom na DevOps smo avtomatizirali in poenotili nameščanje (testiranje) aplikacij prek vseh okolij zavoda (razvojno, testno, produkcijsko, javno). Poleg tega bomo prikazali ključne komponente tehnologije Oracle, ki jih uporabljamo v razvoju. To so komponente za sinhronizacijo podatkov med različnimi platformami, napredno nadzorno orodje in drugo.

JSON Relational Duality

Oracle JSON Relational Duality technology allows developers to store and query JSON data in an Oracle database using SQL, while also preserving the hierarchical structure of the JSON data. This technology allows for seamless integration of JSON data with traditional relational data in the same database, providing a way to work with both structured and semi-structured data in one system.