Your host during the day is:
Traditionally when new data management technologies first come out, they are implemented as separate products. For example, when Blockchain first came out, it was a separate stand-alone system that required you to use an entirely different, proprietary way to store and access data.
Oracle’s converged databases delivers a single, unified system that supports IT organizations in achieving peak efficiency and cost savings. Oracle’s converged database provides one database for all development, while allowing APIs and queries to be written across all data types.
Converged databases support Spatial data for location awareness, JSON for document stores, IoT for device integration, in-memory technologies for real-time analytics, and of course, traditional relational data. By providing support for all of these data types, a Converged Database can run all sorts of workloads from IoT to Blockchain to Analytics and Machine Learning. It can also handle any development paradigm, including Microservices, Events, REST, SaaS, and CI/CD, to name a few.
Oracle Database is an excellent example of a converged database, as it provides support for Machine Learning, Blockchain, Graph, Spatial, JSON, REST, Events, Editions, and IoT Streaming as part of the core database at no additional cost. It allows you to support many diverse projects using a single platform, significantly reducing complexity and management overhead, while minimizing risk.
Tips & Tricks of using Exadata since 2010
speaker: Fernando Simon
Exadata is in the market for 11 years and a lot of sessions talk about how to use smart scan, HCC, and how good these features are. But this session is not about that. Working with Exadata since 2010 in this session I will share some tips and tricks about details/features/topics that are not widely seen in other sessions.
In this session I will discuss how IORM is more important than just slice the resource, what are and how important the storage metrics are (and how to read and understand them). Also, details about ASM features that can help when an outage occurs and tricks about the Exadata patch.
The session is not about ExaCC, but you can use a lot of things from this session as well.
Oracle Data Pump is one of the most widely used features by DBAs, and comes free as a part of every database edition. With each release more features and functionality are added to help move large volumes of data and metadata between and into Oracle Database. This session will cover the new features added to Data Pump for Oracle Database 21c Cloud and on-premises and present two cloud migration demos. It also covers several Data Pump best practices and the 19c “SuperPatch” merge patch. Time and interest permitting, it can recap highlights of the new features in 19c, 18c, and 188.8.131.52. Whether you use Data Pump for table-mode exports, schemas, full databases, or transportable tablespace migrations, you will find new features to make your work faster and easier than ever before!
Attendees will understand the details of the new features added to Oracle Data Pump for Oracle Database 21c cloud and on-premises through presentation and demos.
The audience will also learn about several Oracle Data Pump best practices.
Last but not least, attendees will learn about the 19c “SuperPatch” merge patch for Oracle Data Pump that reduces by 60-90% the elapsed time to install a patch with the dpload.sql apply script, decreases invalid objects by 50-90% and decreases contention issues.
Oracle SQL is a powerful language for accessing data. Using Analytical SQL, one can gain valuable insights from the data.
In this presentation, I will discuss “My Journey into Analytic SQL” and how they have been beneficial to resolve various scenarios, over the years. I will demonstrate the basic syntax of how to efficiently use the windowing_clause, Pivoting Rows to Columns, Unpivoting Columns to Rows, use of Listagg and look at some of the methods to fetch Top-N Rows.
This session will be useful for developers and data analysts. Audience should have a basic understanding of Oracle SQL.
The Internet of Things (IoT) has expanded well beyond the hobbyist realm and into the real world, including energy grids, communication networks, policing and security, and modern manufacturing (aka Industrial IoT). This session demonstrates how Fast Ingest and Fast Lookup – part of the new Memoptimized Rowstore features in Oracle 19c – makes short work of capturing and loading IoT data from “edge” sources so that developers and data analysts can take immediate advantage of that information in nearly real time as they transition to a digitally-driven IT organization.