Detalle Charlas 2018

SpeakerCharlaDetalles
Connor McDonnaldBuilding great apps with great SQLNo-one becomes an app developer to spend their days doing data processing. We do it to explore complex algorithms, build beautiful applications, and deliver fantastic solutions for our customers. But so often we don't ever get to realize that dream. We're too busy dealing with ORMs and hand-coding all the nuts and bolts of data processing so we're left with precious little time for anything else. There is a better way. By expanding our knowledge of SQL facilities, we can write a lot less middle-tier code, and get performance benefits as an added bonus. This session highlights some SQL techniques to solve problems that would otherwise require a lot of complex coding, freeing up your time to focus on the delivery of great applications.
20 years of hints and tips Your database skill set is more than what you have been read in the documentation, or on blogs, or on StackOverflow. It is the knowledge from trial and error, experimentation and sometimes painful failures. And that takes time, a long time. But this session will fast track that path. I'll share with you a collection of hints, tips, tools, features and techniques that over the years I’ve either seen, built myself or simply picked up from the smartest people in the community.
Jim Czuprynski Saving Your Database from Alzheimer’s: Analytic Performance Improvements From Oracle 12cR2 Database In-Memory (DBIM)Oracle Database 12.2.0.1 (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries. This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and non-resident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory Filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment that shows how best to tackle using these newest DBIM features.
Leveraging Partitioned External Tables: Primer and Practical ExamplesOracle Database 12c is the first release to offer the capability to access a file in HDFS or HIVE format as an EXTERNAL table. Later releases include the capability to partition external tables in just about any file format, as well as retain them in IMCS. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language
Marc SewtzOracle APEX 18.1 New FeaturesOracle Application Express (APEX) 18.1 focuses on declaratively integrating data sources from remote databases and extending applications running on Cloud services via REST. A new Low Code Create Application Wizard enables you to add components and features to new and existing applications. Upgrading to the latest Oracle JET and jQuery JavaScript libraries will further allow APEX to take advantage of the new and improved data visualization components and widgets. In this session we will show those new capabilities and demonstrate some of the numerous enhancements to Oracle JET Charts and the Interactive Grid.
APEX 18.1 and the REST of the worldOne of the marquee features in Oracle Application Express (APEX) 18.1 is the improved support for consuming external REST services and building components using REST-enabled SQL. In this session you will learn how to reference external REST services as Web Source Modules and how to create Reports, Charts, Calendars and other components using these modules. Remote Oracle Databases can be accessed via REST-enabled SQL, i.e. create an APEX component driven by a SQL query as before - but have the SQL be executed on a remote Oracle Database over a REST interface using HTTPS and JSON. This session will also explain how to use external data sources with custom PL/SQL code and how to build plug-ins on the data sources.
Henri TremblayDaddy I want to deploy in the cloud "That's easy kid, which provider do you want."
"Dunno."
"Ok. Let's do them all then. You can choose after."

Take a Java webapp. Deploy it everywhere we can in the time we have. Amazon Web Services, Google Cloud Platform, Microsoft Azure, Heroku, Cloud Foundry, Oracle Cloud and so on. See the differences.
Fun with IoT and Java Make some noise! I will capture it with an arduino.

Send it through MQTT.

Capture and play with it in a web app.

Who's the loudest?
Rollando CarrascoUsing Oracle Intelligent Bot service from the developer point of view In this session you will learn the development part of the Oracle Intelligent Bot service. You will learn how to:
1. Create a conversation using YAML
2. How to create an integration with an external application via APIs calls
3. How to integrate the bot with Facebook
4. How to integrate our bot with an OAuth service, for example: Linkedin
5. How to create mini application within the bot

During the session we will highlight the developer side of building a bot with Oracle Intelligent Bot service. The main objective is to have a session where the developer can learn their role in this brand new service from Oracle and relate with it in such a way that they can start budiling chatbots right away.

The session is targeted for developers. Bulding a chatbot with Oracle Intelligent Bot is quite easy, but there are many things that we need to take care and where developers are key for delivering them. My idea is to higlight the usage of the service but keeping the developers as the important piece of the conversation. We will code a little bit during the session, show how to understand the YAML file that represent the conversation. We will integrate our bot with REST Services (APIs) and also integrate it with external services such as Linkedin and Facebook. The whole idea for this is to engage with the developers and show them how easy is to create a chatbot with the Intelligent Bot. The purpose of my session is to engage with the developers and make them pick the ORacle Intelligent Bot as a serious option for their development of this kind of solutions. I will showcase both the capabilities but also the developer side.
Best Practices for API Design Using Oracle APIARY In this session we will talk about how to design a good API. In this era of modern development, APIs are a very important element in our development, both for consuming and for creating and publishing them. Either we are APIs consumers or we are APIs producers we need to engage them and use them, that is why a good design is critical for the success in their usage and in their development.
We also need to differentiate what an API is, and understand what is their relationship with Services, Microservices, Web Services, etc. In that differentiation is where we need to be very clear and therefore have design principles to build a good, stable, scalable, versionable, secure API. We will share with u design principles for APIs development.

Nowadays there is a lot of information about APIs. We can say that if your product does not provide an API, is not a complete product. We can say that if your organization does not have public APIs, then is not innovating and is not part of the world's digital transformation. But at the same time, we feel there are some misunderstandings on what is an API. People tend to confuse them with Microservices, Services, Web Services or even a basic REST Interface is being called an API.
Developers need to be very clear with this and one way to do it is having design principles for their APIs. In order to be true on what an API is, we think that we can ellaborated in differet design principles and share with the audience best practices around it.

We want to showcase Oracle APIARY to design the APIs and incorporate our design principles and with a live demo incorporate our design principles into an API that we will build during the session.

The idea is to have developers engaging with APIARY to design APIs and use our design principles to model them.
Otavio SantanaJNoSQL: The Definitive Solution for Java and NoSQL DatabaseJNoSQL is a framework and collection of tools that make integration between Java applications and NoSQL quick and easy—for developers as well as vendors. The API is easy to implement, so NoSQL vendors can quickly implement, test, and become compliant by themselves. And with its low learning curve and just a minimal set of artifacts, Java developers can start coding by worrying not about the complexity of specific NoSQL databases but only their core aspects (such as graph or document properties). Built with functional programming in mind, it leverages all the features of Java 8. This session covers how the API is structured, how it relates to the multiple NoSQL database types, and how you can get started and involved in this open source technology.
Making Graph Databases Fun Again With Java NoSQL databases have become more popular in several areas. NoSQL has many different uses, including graph use cases. The graph database has a structure pretty different from relational technology and has a lot of successful cases, such as recommendation systems on Facebook and LinkedIn. This presentation will cover what a graph database is and how to use it with Java
Alexis LopezDesarrollo Java en la nube de Oracle En esta presentación conocerás los diferentes servicios de la nube de Oracle que tienes disponibles para tus desarrollos Java: Java Cloud Service, Application Container Service y Oracle Container Cloud Service. Aprenderás a diferenciar cuando usar uno u otro dependiendo de las necesidades de tu proyecto y cómo integrarlos con la plataforma de Integración/Entrega Continua que ofrece Oracle Developer Cloud Service.
Cris Pedregal Making databases smarter and faster: innovations enabled by engineering software and hardware togetherThis talk presents examples that illustrate how jointly designing a database and its underlying hardware enables innovations that overcome substantial technological challenges. Some are fundamental advances in the state of the art, and all yield reliability and performance improvements that discrete component (“converged”) computer systems can rarely attain. For example, tailoring internal network protocols enables re-ordering of messages to prevent analytics queries from delaying OLTP commits, or to instantly detect a server failure. Likewise, pushing intelligence to storage can reduce both network traffic and disk accesses substantially. Caching and replication across Flash treated as its own memory/storage layer (instead of just a fast block-oriented device) boosts throughput and reliability.
This talk is for anyone interested in infrastructure-grade computer systems — not just database implementation — and will aim to provide a window into the thinking of the hardware and software technical staff at a large-scale development organization with a reputation for building and delivering systems that are critical for IT infrastructure across all sectors of the global economy.
Note: This talk will be given in Spanish with detours into English. Audience questions welcome in Spanish, Portuguese, and English
Maximum Availability Architecture for the Oracle DatabaseAn overview of high availability (HA) best practices from Oracle Database Development. Learn how to optimize all aspects of Oracle Data Guard such as multi-instance redo apply and other enhancements. See how to use Application Continuity, Oracle Database In-Memory with Oracle RAC, and Oracle GoldenGate with Oracle Data Guard to mask outages and planned maintenance from users and accelerate time-to-repair. Learn the latest HA best practices with Oracle’s multitenant solutions. Learn how the new sharded architecture for OLTP applications can achieve even higher HA and fault isolation. See how everything you know about Oracle Maximum Availability Architecture for on-premises deployments can also be applicable in the cloud.
Note: This talk will be given in English with detours into Spanish & Portuguese. Audience questions welcome in Spanish, Portuguese, and English
Matheus BoesingOracle Database Backup Service: Backup of On-Premise Databases to CloudBackup is one of the fundamental Disaster Recovery tools for any business or technology. What happens if you lose your backup with your Data Center?

This session covers the Oracle Backup Service available in Oracle Public Cloud, specially focusing on offsite backups for On-Premise Databases.
It is the less disruptive and easily implementable alternative to have an offsite backup, which is a common need in several business due the Sarbanes-Oxley Act (SOX-2002).
This is also the first step to put Database environments into Oracle Cloud.

The session has a hands-on lab covering installing, configuring, backing up and restoring a corrupted file from Public Cloud.
Oracle Database Migration and Consolidation TechniquesMigrating and Consolidating databases or servers is a regular task for DBAs all over the world, caused mostly by hardware upgrades, RAC revision, application decomissioning and other strategic decisions.
But which tools Oracle provide us to help on this process?

This session covers the main tools and techniques to be used for database and hosts consolidation, including migration tools, workload simulating and go to live strategies.
Amazing Free Tools for Oracle DBAsYour scripts utility belt don't need to cover it all! Know some outstanding free tools to manage and monitor your Oracle Database environment.

In this session we'll get in touch with some amazing free tools to check on the database performance, ongoing issues, tracing, dashboarding and graphing things from your database and server perspectives.
Anil NairOracle RAC Performance Internals This session will cover details of RAC features introduced over the years and enhanced to keep up with the latest technological innnovations. We will delve into details of RAC Cache fusion optimizations,
Recovery, LMS changes, Exadata specific optimizations etc in great detail and learn how these optimizations translate into better availability and Scalability.
To enable screen reader support, press ⌘+Option+Z To learn about keyboard shortcuts, press ⌘slash
Oracle Client Failover Best PracticesThis session will go into details on "how to achieve seamless session failover on Oracle RAC". We will delve into the details of load balancing, Failover of both services. We will introduce SCAN, TAF and how sessions can react to both planned or unplanned downtime. We will also include Oracle RAC in the cloud failover.
Roy SwongerHow to Diagnose Oracle Database Upgrade IssuesAnybody who upgrades an Oracle database may need to analyze results and diagnose issues that might arise during or after the upgrade. This session will describe how Oracle support and development personnel go about evaluating upgrade success, and will show you the steps to follow if issues arise during your upgrade. Among the areas covered will be pre-upgrade validation, upgrade performance analysis, and diagnosing upgrade failures.
Understanding the New Release and Patching Model for Oracle DatabaseYou may have heard that Oracle has changed its database release model and numbering, and on top of that has a new patching paradigm. Yearly releases plus Updates and Revisions may require adjustments in test, development and roll-out strategies as well as patching. What does it mean to you when adopting a new release? What is the best patching strategy for your organization? Are support timelines affected by all this? And how will the transition from the old model to the new model work? This presentation will explain everything you need to know about the new database release model and numbering, give you recommendations for patching strategy, and answer all your questions about this crucial area of operations.
Upgrade to Oracle Database 18c: Live and Uncensored!You plan to upgrade to Oracle Database 18c? See and learn directly from Oracle's Database Upgrade Development team how an upgrade works - live on stage. Get the latest tips and tricks and best practices from the real world before you kick off your own project. This technical session will include a customer case involving a large telco and their upgrades of critical systems.
Rita NunezDesarrollando Aplicaciones Nativas en Bases de Datos en la NubeUso de Bases de Datos en la Nube de Oracle, en particular de Oracle Database Exadata Express, el servicio entry.level. Lenguajes disponibles para desarrollar con esta base de Datos, como conectarse. Como Usar APEX con Oracle Database Exadata Express Cloud Service. DEMO en vivo, del servicio en general y como comenzar a desarrollar una app en APEX con Oracle Exadata Express Cloud Service.