5G Private mobile network on OCI

Three years ago, S&T Iskratel decided to develop its own 5G core as part of a comprehensive 5G solution, offering high-quality industrial networks for digital transformation. To quickly introduce modern use cases and scalability requirements, it used the concept of a cloud-based network that enables the 5G core to realize its full potential.

It has successfully deployed the 5G core on both public and private cloud infrastructure, enabling exceptional flexibility and scalability not only for its own core but for the entire 5G solution. Using cloud infrastructure, 5G solutions can be tailored to the needs and demands of customers, providing an optimal user experience. Deploying the 5G core on cloud infrastructure also enables more efficient resource utilization, greater security, and reliability of the entire network.

In this talk, we will address the motivation for transitioning to a cloud-native architecture and the experiences gained in developing and deploying cloud-based solutions. We will highlight the problems and challenges that engineers faced and list the numerous competences that S&T Iskratel also offers its customers in the form of professional services.

An Introduction to Container Management, Kubernetes, and Stateful Apps

Containers are essential enablers for distributed applications following a micro-service pattern. A container is an easy, convenient, and safe way for developers to package their applications. Most importantly the risk of breaking other application’s software and library dependencies is greatly reduced by these self-contained artifacts compared to traditional “app-server” deployments using virtual machines. This is especially true if the container runs a stateless application! The talk features an overview of container technology for Oracle database professionals. It starts with an introduction of running containers locally on a development machine before focusing on more advanced topics. Since running individual containers is complicated container orchestration frameworks have been developed. Today’s best-known container orchestration framework is Kubernetes. Attendees can learn more about this important platform in the second half of the presentation. Many introductory talks on the subject don’t address a very important piece of the landscape: the persistent data store required for any stateful application. There are many ways of using the Oracle database in such application deployments, and attendees can learn about the most common ones in this presentation.

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.

Back to the Future with Analytic Function

Analytic functions in SQL, also known as windowing functions, have been around for quite a while now. Even if you are familiar with the concept of analytic functions and are working with them occasionally, you may not realize the full potential of this feature, and in how many different scenarios it can be used.

In this session, we will go over a few real-life client requirements for which a solution needs to be found. We will go back to the time before analytic functions existed and will try to solve the client requirements without them. Then, we will return to the present where analytic functions exist, taking advantage of them to provide the same results.

So, if you’d like to see how using analytical functions can provide a simpler, more maintainable, and better-performing solution, then prepare to step into your future and come to this session.

Business Inteligence v podporo odločanju na podlagi podatkov.

V predstavitvi bomo prikazali poslovno inteligencni sistem Skrinja in delili izkušnje in dobre prakse pri uporabi uspesne kombinacije: Oracle podatkovnega skladišča z Oracle Data Integratorjem skupaj z Microsoft Power BI sistemom. Skrinja v državni upravi služi predvsem intetaktivni podpori odločanju na podatkov na vseh ravneh. Z uporabo Skrinje dvigujem znanje ter avtomatiziramo, optimiziramo in izboljšujemo delo in odločitve tako odločevalcev kot tudi analitikov in končnih uporabnikov.

Cookie Cutter APEX Applications

In a perfect world your APEX SAAS solution would be deployed with a click of a button, have a separate database for each customer, and can a customer choose when they want to upgrade to the next version. In this perfect world, the customer don't have to worry about default lookup data, because the SAAS provider does that. This perfect world can be created with Application Containers and Oracle APEX. In this session you will learn the basics of Application Containers, how data is shared and separated in each container and how a new version is rolled out.

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.

Generiranje SVG datotek neposredno iz Oracle podatkovne baze

Na predavanju želim predstaviti API za generiranje SVG datotek neposredno iz Oracle podatkovne baze, izključno z uporabo PL/SQL paketa, katerega sem razvil za potrebe mojih projektov. Najprej bom predstavil SVG datoteke – njihovo zgodovino, namen, strukturo, način integracije z CSS in Javascript-om, potem pa uporabo PL/SQL API-ja in konkretne primere implementacije v Oracle APEX aplikaciji. API se je izkazal uporaben, ker za generiranje SVG datotek ne rabimo dodatna orodja ali programske jezike temveč samo PL/SQL znotraj Oracle podatkovne baze.

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

Git for Oracle Developers and DBAs

Most tutorials covering frontend development include a section about Version Control Systems and their importance during the development process. The same can’t necessarily be said about tutorials describing backend or database development. This might be a fact explaining the difference in adoption. Not using a Version Control System in support of database development is a missed opportunity though, especially since it’s a lot less difficult than one might expect. A plethora of tools such as Liquibase exist to help database developers generate scripts for applying their schema changes to databases. Repeatedly, securely, audited, and of course, version controlled. These scripts can easily be stored in a VCS, enabling entirely different, and more open, ways for developers to collaborate. This talk introduces Oracle developers and administrators alike to the virtues of git in conjunction with Liquibase as the deployment tool of choice. You can learn more about local repositories, branching, merging and how to use remote repositories to work with your peers. Once git’s key concepts are understood using it becomes a lot less scary and can turn into a fun activity

Huh? Is It Fixed in 23c? Seriously!

No matter how long you’ve worked with Oracle Database, you’ll benefit from hearing our database upgrade team’s insider insights. Follow as we describe how a service request becomes a patch. Learn about the time it takes to deliver a patch, what the requirements are to include a fix in a future release update (RU), and why certain patches may never be in a Release Update for your current database release. When do you need a merge patch? And why is Windows different? And where can you find all this information? Find out all this and more.

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.

Koliko časa traja »restore«? Nič!

»Koliko časa traja restore?« je najpogostejše vprašanje strank, ko se pogovarjamo o backup strategijah. Zanimivo, da skoraj nikogar ne zanima, koliko traja in kolikšen vpliv na poslovanje ima izvajanje backupa, čeprav se ta izvaja redno ves čas, restavriranje pa … če imamo srečo, sploh nikoli.

V preteklosti smo zelo optimizirali backup postopke. Shranjujemo transakcije zbirk podatkov, uporabljamo bitmap indekse za označevanje spremenjenih blokov podatkov, da jih hitro najdemo in shranimo.

Ker pa to ne rešuje naslovnega vprašanja, smo v zadnjem času veliko truda vložili tudi v »restore«. Izkušenejši uporabniki se zatečejo k matematiki in znajo izračunati, da skozi gigabitni kanal dobimo približno 100 MB/s. Obnova 10 TB podatkov torej pri gigabitni hitrosti traja približno 24 ur, pri večji hitrosti sorazmerno manj. Matematika se tu zdi neizprosna.

Z inovativnimi postopki lahko matematiko pretentamo. Izhajamo s predpostavke, da kopijo podatkov že imamo. Zakaj bi te prepisovali na njihovo originalno mesto in ČAKALI, da se prepišejo? Zakaj preprosto teh podatkov ne bi kar uporabili TAKOJ – na mestu, kjer so. Čas nedostopnosti storitev se tako skrajša na samo aktivacijo podatkov – skoraj na NIČ. Ko storitve že delujejo, pa lahko v ozadju premeščamo podatke na originalno mesto.

Kosilo

My view on Oracle’s position in Gartner Magic Quadrants for Analytics and Business Intelligence Platforms

OCI Vision and Oracle Analytics: Just like a Box of Chocolates

OCI Vision is a self-service AI Service, which applies computer vision to analyze image-based content. It allows developers easily integrate pre-trained models into their applications with APIs or custom training models to meet their specific use cases. In our example, I will explore how to use OCI Vision service to create a custom-built model to detect pneumonia infected lungs on a fresh dataset of X-ray images. In this example, I am using rather large dataset of X-ray images found on Kaggle.com. Oracle Analytics is then used as a front-end tool to use the model to classify new images for pneumonia.

What to expect to see in this presentation? In the first place, we will demonstrate and explore the whole process from “plain” X-ray image to identifying pneumonia infected lungs using OCI services:

Gathering and storing images to OCI Object Storage. Labeling images depending on whether they represent normal or pneumonia infected lungs using Data Labeling service. Building and training an image classification model using OCI Vision. Registering an OCI Vision model with Oracle Analytics. Applying a model in Oracle Analytics’ Data Flows. Visualizing everything at the end by using Oracle Analytics Data Visualization. Why is this relevant?

Firstly, it shows the flexibility and usability of the OCI ecosystem, specifically Data Lakehouse services. Secondly, the whole process (with exception of data labeling which is done programmatically) is codeless, with not too many steps in the process, and the process itself is really very simple to use. This implies possibilities which can be explored by much wider range of users comparing to the situation today, where all depends on skilled developers and data scientists. And the bottom line, this can have very positive impact on business.

Odmor

Odmor

Odmor

Odmor

Odmor - kava

Odmor - kava