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.

Percentiles, lies, and database performance monitoring

It is becoming increasingly popular these days to put response time percentiles into the SLAs and OLAs. But, unfortunately, most people do it wrong. In this presentation, we will explain the most common failure modes regarding performance metrics and how to handle situations when someone comes complaining with a 99th percentile graph.

Response times are often not normally distributed, and averages and dispersions are just garbage. The simplest way to make sense of such data is to use percentiles. Popular choices are 50th (median) and 99th percentiles. By definition, there can be values larger than 99th percentile, so adding 99th percentile to the SLA will hide outliers.

Oracle provides histograms for the wait events, for query response times it is still only averages. The only way to get a hold of the outliers is ASH or event 10046 traces. As always, these options come with their own challenges.

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.

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.

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.

Real life ORDS; REST in pieces

ORDS plays an important role in the APEX architecture. Next to the database and the browser it is a key component to run any APEX application. But on top of "just" running your APEX application, it also opens up the possibilities of using all kind of RESTful services and features to enhance your application with data that comes from or is send to other sources. This session will cover a number of examples that we created in order to build the application landscape we have today.

Stop editing code in Production database - a journey from 90's to CICD

Source control in databases is a difficult problem. There are tools like Liquibase or Flyway but none of those is fully addressing all challenges of applying changes to databases. This presentation is based on real life implementation and shows a story of a company moving from direct PL/SQL code edit on production server to CICD pipeline.

List of the typical challenges covered in the presentation: - how to design a source control repository, - how to keep a DDL changes, - code merges, - continuous deployment without production outages - rollback - pipeline implementations

Presentation will finish with lesson learned and potential process and tools improvements including Oracle Cloud DevOps tools.