December 5 - December 8, 2022
Strategic insight and how-to education for Oracle users of all levels
Quest Experience Week: Database and Technology Day
Thursday, December 9
Database and Technology Day is packed full of digital education designed to provide strategic insights and how-to-education for database users of all levels. Best of all? Registration is free, so please join us!
Have questions or need help? Contact us at [email protected].
Database & Technology Day Sessions
11:00 am – 12:00 pm ET
Automating Data Management for All
Presented by Gerald Venzl – Distinguished Product Manager, Oracle
Abstract:
Oracle Autonomous Database has simplified the management of operational and analytical database workloads. This keynote discusses how the innovation continues to improve analyst, data scientist, and developer productivity.
12:30 pm – 1:30 pm ET
Database Migration across technologies Sybase 2 Oracle
Presented by Valli Ramanathan, Sr Specialist Leader, Maximus Attain
Abstract:
We are faced with database migrations very often and have to deal with a variety of issues like data types compatibility, version issues, database size and restrictions regarding downtime, performance on the new platforms, special requirements associated with the application to name just a few. A database migration if well planned and executed can be very smooth and seamless and we can even have a value add of – increased performance on the destination platform or can end up with an excruciatingly long and tedious process plagued with errors and failures – in short a nightmare. After having managed many migrations from variety of database technologies, one does assemble a few main tasks to focus on and tips and tricks which will ensure a smooth migration. Using a couple of use cases from federal space I would like to highlight some methodologies that I have followed to create a repeatable process for Sybase to Oracle migration.
Using REST APIs to Enable Microservices Architecture with your Converged Oracle Database
Presented by Jeff Smith – Distinguished Product Manager, Oracle
Abstract:
Having a single SQL and PL/SQL layer to work with any workload or data handled by your Oracle Database allows for seamless integration and communication between different microservices. Whether you’re working with a blockchain, JSON Collections, spatial coordinates, or relational tables with traditional rows and columns, a single SQL implementation in the database engine is used to access those securely and quickly.
Accessing your data and application logic inside the database from your automation tasks, reports, applications, or even end-users is further simplified by having a single protocol that can be used from any application platform or programming language, HTTPS. REST APIs for the Oracle Database can be a critical component to making your microservices come to life!
This session will demonstrate how you can use REST APIs to work with different types of data, database workloads, and even across multiple databases or pluggable databases, all secured with your application server security model or OAuth2 Clients. We’ll also cover how to document those APIs so your application developers can take advantage of them!
Building a Highly Available and Scalable Logistics Platform with Oracle 19c and Goldengate 19c
Presented by Nikitas Xenakis, Principal Solutions Architect, Cooperative Group
Abstract:
The Co-op is the UK’s leading convenience retailer, with 14 distribution centers and a turnover of $15.2 billion, servicing more than 10,000 outlets through its retail, wholesale, and franchise proposition. This session explores the platform built for its mission-critical logistics network including Oracle Real Application Clusters 19c, Oracle Active Data Guard, Oracle Grid Infrastructure bundled agents, and Database File System (DBFS) combined with Oracle Multitenant and Oracle GoldenGate 19c microservices in an Oracle Maximum Availability Architecture configuration, providing real-time replication between operational and analytical systems and the ability to upgrade without downtime. It also examines how the platform evolved by incorporating Oracle Autonomous Database.
MAA
Oracle Maximum Availability Architecture (MAA) SIG- Oracle RAC Internals- The Performance Edition
Presented by Anil Nair, Oracle & Alfredo Abate, Senior Oracle Application Database, BBT Industries LLC
Abstract:
This session will cover us the Oracle Internals focusing on Performance DBA’s who work on Oracle RAC will benefit from understanding the details of Oracle Cache Fusion related wait events. We will cover some AWR reports where interesting problems were reported and the steps that were recommended to help improve performance.
2:00 pm – 3:00 pm ET
APEX 21 New Features
Presented by Marc Sewtz – Director, Software Development, Oracle
Abstract:
Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere. Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. In this session, we are showing what’s new in APEX 21.1 and APEX 21.2. We’ll demonstrate the new maps region, support for spatial data types and the new geolocation item type. You’ll see several enhancements to Faceted Search, including support for the new Cards region and multi-value columns. We’ll round out this session with a preview of the new built-in support for progressive web apps (PWA).
Database 12c to 21c, Journey of key feature sets
Presented by Anuj Mohan, Principal Enterprise Architect, Big River Steel
Abstract:
This presentation will look at 12c to 21c new features that should be investigated for use which include Multitenant, IN-Memory and Oracle 19c Automatic Indexing, and many more. I will discuss the 12c to 21c Journey for these new features with examples and sample code. Attendees can expect a brief introduction of all the new features with deep dive into Multitenant, IN-Memory, and Automatic Indexing.
High Availability and/or Standby Database – which solution should I choose?
Presented by Axel vom Stein, DBA, BSS Bohnenberg GmbH
Abstract:
When using Oracle you will find more than enough solutions for High Availability and Data Security. If you have never been confronted with this topic before, you might ask yourself what solutions are there anyway and which one is right for my problem. Without delving too deeply into technical details such as setup and operation, a few of the most common solutions (Standby Database with Standard Edition via Scripting, Dbvisit, Refreshable PDB, Oracle Data Guard, Oracle Failover Cluster, Oracle RAC One Node and Oracle RAC) will be touched upon briefly and compared with each other. The comparison of the different solutions provides a decision-making for your environment.
3:30 pm – 4:30 pm ET
Simplifying Microservices
Presented by Vishal Mehra – Developer Evangelist, Oracle
Abstract:
In this talk we present an overall development architecture – app tier and data tier – for building scalable Microservices with the Converged Oracle database. The talk covers a mobile food delivery app – GrabDish – to illustrate business data, spatial, graph, document/JSON data types – with the containerized, multi-tenant aspects of the data platform, while also showing aspects of docker containers and Kubernetes that are available both on Oracle Gen2 cloud and the on-premises Oracle Linux stack. The attendees will be able to complete self-guided hands-on-labs to get familiar with the code and extend it to build their own microservices. We will share an open platform technology stack for Microservices that helps with a multi-cloud deployment strategy.
From DBA to a DevOps Engineer – a DBaaS ramp up experience
Presented by Martin Berger, Platform Architect, Trivadis AG
Abstract:
What do you need to build a fully automated Oracle DBaaS stack? Hardware, Software and a heterogenous team with a passion for automation. I am proud to be part of the team which has ramped up in the last months a DBaaS for a large Swiss customer with a huge bandwidth of technology. From PCA to ZDLRA, from VMWare vRA to Ansible Tower, from Jira Tasks to Scaled Agile Framework, each team member brought in his expertise to bring the service to the market. I will show you what you need to build such a service from scratch. What we have learned when setting up DevOps tools like Ansible and git. And what I can tell you, the passionate team is the key to success. I am not talking only about tech stuff, we want to see what is required in the back, and how long the way is from the first sprint planning to customer readiness.
Thanks to our Database & Technology Day sponsors:
