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.

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.

Game, Set and Match

The tagline of the Game of Set is: The Family Game of Visual Perception. It is a game of finding matching cards in a selected group of cards. Being a SQL guy, I read this as: SET: The GAME of MATCHing cards. In any database we can select SETs using MATCHing criteria. Where is the GAME? Well, for me, it is a game of trying to solve this puzzle using SQL. You will see how you can use the different SET operators in Oracle, how you can use JOINs to create a SET of cards, from which you can SELECT a puzzle and also find the SETs in that puzzle.

APEX Application lifecycle with feature based deployment

APEX application deployment is mostly done by exporting the application and importing it into the target environment. But what if your team continuously develops (as they should), where do you stop developing to start preparing your release-deployment? You should be able to deploy based on features; without your developers having to halt their development. Using the deployment-method explained in this presentation you will be able to do just that. The method includes things like Code versioning (GIT), Feature-tickets (Jira), Code Review (Quality), Automated Deployment using Jenkins and Flyway. When implemented you will be able to successfully and predictively deploy your APEX applications (including underlying database objects) to the different deployment-environments. With a few modifications you can even upgrade the methodology to be a ""continuous delivery"" methodology.

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

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.

Understanding auto-rest (ORDS on steroids)

The Oracle Restful Data Services allow to "rest-enable" database objects like Tables, Views, Procedures and Functions. This includes data-retrieval and data-manipulation. Using a few simple directives in the URL you can search for specific records, order the result set or even limit the amount of records retrieved. On top of that the ORDS will automatically show you the resulting JSON The session focuses on the creation and use of autorest enabled services on objects. The creation section (1st half) focuses on the right format of your JSON result. The seconds half covers consuming these services; how to do CRUD operations, how to search the for data, how to paginate etc.

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.