Lade Veranstaltungen
  • Diese Veranstaltung hat bereits stattgefunden.

SOUG Day in Winterthur

17. Mai 2022

Next Generation Oracle

Wir freuen uns für und mit Euch den SOUG Day zum Thema Next Generation Oracle im Haus Adeline Favre», Departement Gesundheit zu gestalten.

Für SOUG Mitglieder, Studenten und Dozenten von anerkannten Ausbildungsstätten ist die Teilnahme kostenlos. Gäste können ein Tagesticket für 350.- kaufen.

Stream 1 – Raum MGE0.088

Host: Dani Schnider
09:00 – 09:15 Uhr
sprache-de

Begrüssung und News Andri Fäber und Thierry Bosshart

09:15 – 10:00 Uhr
sprache-de

Key Note Cloud Readiness Assessment für grosse OCI Transformationen

Matthias Farwick
Txture – The Cloud Transformation Platform
10:00 – 10:15 Uhr

grosse Pause mit Kafi&Gipfeli

10:15 – 11:00 Uhr
sprache-en

Kickoff Terraform CI / CD into the Oracle Cloud

Inhalt
This session handles abour Infrastructure As Code, in terms of how this fits into the Cloud Infrastructure, using tools as Terraform and how build a pipeline with Jenkins(X), Tekton and Git.It elaborates about cloudnative tooling to accomplish an automation level of rolling out infrastructure along with application CI CD pipelines. Some of these cloudnative tools are discussed about how they fit into a Cloud environment, rolling out A managed Kubernetes Engine, Appservers, bastion hosts and so on. It is also a good starting point for newcomers, who aren’t familiar with all these buzzwords and new technologies, methods, to get a first glimpse what they might expect. Especially if they are used to the tradional way of rolling out, they can gain new insights of how they can innovate in this area.
11:00 – 11:10 Uhr

Pause

11:10 – 11:55 Uhr
sprache-de

Automatic Oracle databases provisioning in multi-cloud environment

Inhalt
Nowadays it’s possible to run your Oracle Database on many environments (On-prem, OCI, AWS, …). This allows you to move your Oracle database workload from one Cloud provider to another for instance. However the setup of these infrastructure can be tricky and time consuming, mainly because of Cloud providers’ specificities. With the help of Ansible we achieved to provision and configure your Oracle databases from a single interface on all Cloud provider platform. The only remaining task would be to move your data. A last question is of course how and where to handle your repository. Is there any central one available? Join us and find it out! This session will include a demo with the 3 main Cloud providers for Oracle databases (OCI, AWS, Azure)
Herve Schweizer
dbi services AG
11:55 – 13:00 Uhr

Lunch

13:00 – 13:45 Uhr
sprache-de

Vom Sensor zur Datenanalyse mit OCI

Inhalt

Wie kann man die Oracle Cloud nutzt, um Daten von verschiedenen Sensoren zu sammeln und zu analysieren? Die Sensoren sind mit einem Controller, z.B. einem Raspberry Pi, verbunden. Dieser Controller sendet die Sensordaten mit Hilfe einer REST-API an die Oracle Cloud. Dann können die Daten direkt in Oracle oder mit einem Python Notebook analysiert werden.

Das klingt alles sehr einfach. Dennoch gibt es einige Punkte, bei denen man sich schwer tun kann. Bei der Vorbereitung eines Studentenprojekts habe ich das ausprobiert und dabei neue Dinge gelernt, wie z.B. den Anschluss der Sensoren und die Programmierung des Controllers. Ein wichtiger Punkt ist das Datenmodell. Es sollte sowohl für das Schreiben von Daten als auch für die Analyse von Daten einfach sein. Das gewählte Datenmodell wird vorgestellt, ebenso wie die REST-API zum Schreiben und Lesen von Daten. Während der Präsentation werden die Sensoren in Betrieb sein, so dass wir am Ende die gesammelten Daten sehen und auswerten können.

Andrea Kennel
InfoPunkt Kennel GmbH
13:45 – 14:00 Uhr

Pause

14:00 – 14:45 Uhr
sprache-de

Licensing Considerations for Multicloud Scenarios

Inhalt

Oracle Software Investment Advisory (SIA) is a team of experts, focusing on make our customers understand Oracle licenses and subscriptions. In conjunction with implementing your cloud strategy for Oracle, SIA provides recommendations to help optimize your Oracle investment.

Migrating to the cloud is technically easy, before you do that, you should be aware of the commercial impacts and your flexibility going forward. We will explain the basic elements you need to know for an educated business decision, including all the buzzwords like BYOL and Authorized Cloud Environments. This will be for everyone, regardless where and how you currently run Oracle, have narrowed down your choices of Cloud vendors or have already started your Cloud journey.

14:45 – 15:05 Uhr

grosse Pause mit Kafi & etwas Süssem

15:05 – 15:50 Uhr
sprache-en

Enterprise Manager as a Service

Inhalt

See the best of Enterprise Manager as a cloud service in this live demonstration of Oracle Cloud’s Observability & Management Platform. For a long time, Enterprise Manager has been a key tool on-premises to monitor and manage Oracle databases. Now we see a shift away from on-premises tools managed by enterprises and towards tools as cloud services managed by Oracle. It removes obstacles to reach key insights for key decisions with minimal effort. Don’t focus on managing the infrastructure running your monitoring tools. Instead, focus on monitoring databases to optimize performance and increase value.

Oracle’s Observability & Management (O&M) Platform delivers Enterprise Manager’s monitoring tools as a managed cloud service. It also adds new features empowered by machine learning. O&M’s holistic suite of services collects metrics, traces, and logs from databases and application servers running on-premises, in the cloud, or both. Monitor and analyze databases individually or at the fleet level – from resource utilization to workload analysis, SQL tuning, and advanced log visualizations. O&M can contain all this data in elastic cost-efficient cloud storage for years. Use this historical archive to analyze long-term trends and forecast future behavior for proactive remediation. Take advantage of machine learning to get key insights without manually going through heaps of metrics and logs with the risk of human errors. View all your databases and their history through a single pane of glass managed by Oracle Cloud.

15:50 – 16:00 Uhr

Pause

16:00 – 16:45 Uhr
sprache-de

Key Note: Huh? It is fixed in Oracle 23c? Seriously? – Or how Database Development at Oracle works

Inhalt

Have you ever heard from Oracle Support “It will be fixed in 21c or 23c”? And wondered if you should upgrade now, and how you should upgrade when the release is not there yet? In this talk we will give rare insights into how Oracle Database Development works. We will explain why it takes more than a few minutes to complete a regression test suite, why you don’t get one-off patches on Windows – and why you need a backport to have “this” issue fixed on 19.11.0. We are fully aware that you will need some beer to relax – and that everybody has a story to tell. Our focus will be to shed some light on the black box “Oracle Database Development” to get you a better understanding why things work as they work – and why miracles happen not every day but sometimes take longer.

16:45 – 18:00 Uhr

Closing, Austausch und Apéro

Stream 2 – Raum MGO1.142

Host: Philipp Salvisberg
10:00 – 10:15 Uhr

Grosse Pause mit Kafi & Gipfeli

10:15 – 11:00
sprache-de

Trainingsdaten in KI-Projekten verwalten

Inhalt

Trainingsdaten in KI-Projekten verwalten
Die zunehmende Leistungsfähigkeit unterschiedlicher KI-Modelle verlangt nach einer immer grösseren Menge an Trainingsdaten. Zum Beispiel können Transformermodelle mit zunehmender Anzahl Parameter immer bessere Texte generieren, brauchen jedoch viele Beispieltexte, damit sie für einen bestimmten Zweck mittels Fine-Tuning angepasst werden können.

Im Unterschied zu der in Data Science-Vorhaben häufig eingesetzten, programmatischen Verarbeitung von CSV-Dateien, können Datenbanken bei der Verwaltung von Trainingsdaten wertvolle Dienste leisten.

In diesem Vortrag zeigen wir am Beispiel von Angewandte Forschung und Entwicklung-Vorhaben, mit welchen Rohdaten, Algortihmen und Datenmangement-Technologien Trainingsdaten erzeugt und in verschiedenen Varianten genutzt wurden.

11:00 – 11:10 Uhr

Pause
11:10 – 11:55 Uhr
sprache-de

Oracle APEX + Server-side JavaScript = Awesome!

Inhalt

Welcome to the future! Starting with Oracle Database 21c, developers can now execute JavaScript within the database. This functionality is enabled by the Multilingual Engine (MLE), powered by GraalVM. And APEX 20.2 is the first (and only) low code framework on the planet which natively supports server-side JavaScript, out of the box!

In this workshop, we will be joined by Lucas Braun, ETH alumnus and Program Manager for Oracle Labs in Zurich. Lucas is also a core contributor to the MLE feature which was developed to large extents in Zurich. You will learn: 1. how MLE works and how it enables server-side JavaScript in APEX 2. see numerous real-world demonstrations 3. learn everything you need to do so that you can try this yourself today, and for free in an Always Free Oracle Database

Dr. Lucas Braun
Oracle Labs

11:55 – 13:00 Uhr

Lunch
13:00 – 13:45 Uhr
sprache-en

PLSQL-OO an object oriented approach to table API’s

Inhalt
The PLSQL Language offers great possibilities. Not only in handling vast amounts of data, but also Object Oriented possibilities are present. This short introduction uses a table-API example to get familiar with the PLSQL-OO structures within the language
Richard Martens
SMART4Solutions BV

13:45 – 14:00 Uhr

Pause

14:00 – 14:45 Uhr
sprache-de

Working effectively with (-support-) the community

Inhalt

This talk is for those who are new to PostgreSQL or those who just started, or all the others that want to hear a personal story: When I started with PostgreSQL around 10 years ago, I came with an Oracle background. It took me quite some time to understand how the PostgreSQL project is organized, how the community is working and how to deal with issues I’ve faced when I needed support. This is not a technical talk at all, but it should save you quite some time in your journey with PostgreSQL.

Daniel Westermann
dbi services AG

14:45 – 15:05 Uhr

grosse Pause mit Kafi & etwas Süssem

15:05 – 15:50 Uhr
sprache-en

Application Modernization Pathways

Inhalt

During this Session we will discuss the Application Modernization Pathways. We will go through the challenges faced by businesses and how to choose the right modernisation journey for their existing solution.

Does it have to be a complete re-write of the solution with latest trending technologies? moving to cloud or reposting to cloud or is there a way to have best of bread. Join me and see how Oracle Enterprise Cloud Native Java team is help address and solve such challenges.

Sid Joshi
Oracle

Stream 3 – Raum MGO1.143

Host: Christian Marquardt

10:00 – 10:15 Uhr

grosse Pause mit Kafi & Gipfeli

10:15 – 11:00
sprache-en

Analysis of Database Issues using AHF and Machine Learning

Inhalt

Oracle Autonomous Health Framework (AHF) is Oracle’s Artificial Intelligence Operations platform for autonomous database health management. This session will focus on enhancements to current functionality and new features in 21c. We will discuss how to use the data which is derived from the Bayesian Net framework of AHF to conduct root cause analysis, telemetry and remediations for issues. You will learn to utilize these features to determine workload footprint, ongoing monitoring, early detection of anomalies and performance issues, their root causes and corrective actions, prevention of node or database failures, and targeted postmortem analysis enabling quick resolution.

11:00 – 11:10 Uhr
Pause
11:10 – 11:55 Uhr
sprache-de

Oracle Database Vault – Schutz vor Räubern, Schlangen

Inhalt

Oracle Database Vault ist nun bereits seit ein paar Jahren am Markt. Das Produkt wurde über die Jahr stetig verbessert. Doch wo lohnt sich der Einsatz? Welche Sicherheitsmassnahmen können damit umgesetzt werden? Und vor wem schützt mich DB Vault überhaupt? Im Rahmen von dieses Vortrages werden neben den Erfahrungen aus zwei Kundenprojekten die technischen Möglichkeiten von Database Vault 19c / 21c erläutert. Wir versuchen aufzuzeigen, wo sich unter umständen den Einsatz von Database Vault lohnt und unter welchen Bedingungen eher nicht. Dazu gehört auch, ob der Schutz vor Schlangen und Räubern sichergestellt wird. PS: Ich habe meine Kinder gefragt was für ein Vortrag ich einreichen soll. Die Antworten waren Schlangen, Räuber und Geparde…

Stefan Oehrli
Trivadis
11:55 – 13:00 Uhr
Lunch
13:00 – 13:45 Uhr
sprache-en

Major database maintenance (and upgrades) without downtime. Myth or reality?

Inhalt
Myth: Major database upgrades and other pervasive maintenance tasks require hours of downtime. Reality: they will take the time of an (Active) Data Guard switchover. How? Oracle 12c introduced DBMS_ROLLING a few years ago. It is a bullet-proof solution, perfected over the years, that allows executing hours of maintenance on a “transient” logical standby while the primary database keeps receiving application workload. Do you want to know more? This session is for you!
13:45 – 14:00 Uhr

Pause

14:00 – 14:45 Uhr
sprache-de

Oracle Multitenant Application Container – Eine Einführung

Inhalt

Bereits mit der Oracle Version 12.2 hat Oracle das Feature Multitenant Application Container eingeführt welches ein “Manage many as One” innerhalb der Datenbank erlaubt. Es wird aufgezeigt wie Application Container funktionieren, welche Use Cases sie bieten und wie Sie konfiguriert werden.

Alain Fuhrer
dbi services
14:45 – 15:05 Uhr

grosse Pause mit Kafi & etwas Süssem

15:05 – 15:50 Uhr
sprache-en

Tips & Tricks from 20K+ hours DBA oncall

Details

Datum:
17. Mai 2022
Veranstaltungskategorie:

Veranstaltungsort

Haus Adeline Favre
Katharina-Sulzer-Platz 9
Winterthur, 8400 Schweiz