Oracle DatabaseWorld 2022
2022-04-20..2022-04-25
-- online --
[Oracle DatabaseWorld 2021, Oracle DatabaseWorld 2022, Oracle DatabaseWorld: AI Edition 2024]
who it's for
database administrators, database developers, cloud architects, data engineers, application developers, security engineers, site reliability engineers
topics
Autonomous Database with Exadata; in-storage query offload (Exadata); Oracle APEX low-code mobile apps; SQL macros and CTE refactoring; JSON storage and MongoDB API; in-database machine learning algorithms; Active Data Guard and MAA; sharding for large-scale databases; Transparent Data Encryption and Database Vault; building a cloud data mart; SQL Developer Web and ORDS
| title | author | length |
|---|---|---|
| Oracle's vision for simplifying data-driven apps and analytics | Juan Loaiza | 24m |
Oracle claims a single converged database that natively handles JSON, graph, spatial, blockchain and SQL so apps add a SQL statement not a new DB; examples… | ||
| Application development made simple | Gerald Venzl | 17m |
Claims Oracle Database exposes over 100 built-in ML algorithms, hundreds of spatial operators and over 50 analytical functions callable via SQL/REST and… | ||
| Mission-critical databases made simple | Maria Colgan, Ashish Ray | 19m |
Five concrete ingredients: Exadata Database Service for fault‑tolerant, mirrored storage with hot‑swap hardware and persistent memory plus hybrid columnar… | ||
| How to build a cloud data mart in 20 minutes | Patrick Wheeler | 19m |
A cloud data mart is built in 20 minutes on Autonomous Database by provisioning an ADB (8 OCPUs with auto‑scale to 24), loading four CSV dimension files and… | ||
| Simplify data and event-driven microservices with Oracle Database | Paul Parkinson | 22m |
Demo GrabDish app and workshop show Oracle Database hosting JSON, relational, graph and spatial data, running an in‑DB messaging engine (AQ/TEQ) that gives… | ||
| Database developer productivity tips and tricks | Jeff Smith | 20m |
Live demo of SQL Developer Web and ORDS shows concrete, usable features: browser file loading of SQL/JSON/Avro/XML, a PL/SQL editor with clickable compiler… | ||
| Examining the relationship between brain activity and video game performance | Todd Sharp | 21m |
Hacked a Mindflex EEG with an Arduino to publish samples via MQTT, ingests Call of Duty API JSON into an Autonomous Database materialized view, and links… | ||
| From zero to hero: Rapidly building a mobile F1 app using Oracle APEX | Jayson Hanes | 19m |
Builds a working mobile F1 app from a JSON file of 22 rows using Oracle APEX low‑code in about 20 minutes, claiming rapid delivery of dashboards, a faceted… | ||
| How to write powerful SQL that's easy to maintain | Chris Saxon | 18m |
Starts from a real report example counting employees per department and shows refactors: use WITH clause for CTEs, collapse common joins into views, then… | ||
| Speed up transparent performance with Exadata: What, when, how, and why | KOTHANDA UMAMAGESWARAN | 19m |
Explains how Exadata sends queries to storage so storage does row filtering and column projection, cutting bytes returned by up to 3000X in examples (173 GB… | ||
| Complete database security in 4 simple steps | Russ Lowenthal | 22m |
Four concrete steps: 1) assess configuration with DBSAT (download via note 2138254.1) or Data Safe—example finding: 10 users lack a password complexity… | ||
| Never-down applications with Oracle Maximum Availability Architecture | MARKUS MICHALEWICZ | 21m |
Oracle MAA shows concrete features that keep apps running: Transparent Application Continuity and AC capture and replay in-flight transactions (ACchk reports… | ||
| Simplify application development with Oracle Real Application Clusters | ANIL NAIR | 24m |
Oracle RAC claims to remove most failure-detection and retry code by routing clients through a SCAN (Single Client Access Name) and service-based connect… | ||
| How to evolve your database applications entirely online | Ludovico Caldara | 23m |
Claim: evolve database-backed apps without downtime by combining Oracle Cloud CI/CD, SQLcl, Liquibase, OCI wallets and database features. Pipeline clones… | ||
| Deep dive: Data loading | Bud Endress | 21m |
Oracle Autonomous Database’s Data Load GUI performs real-world loading without scripting: it creates tables, infers columns and types from Excel and JSON… | ||
| Tips and tricks: Data warehousing for Oracle E-Business Suite and SaaS data | Jayant Mahto | 20m |
Shows a concrete pipeline: ODI Web Edition (drag‑and‑drop ELT in Autonomous Database) connects to Fusion SaaS via BICC, reverse‑engineers entities, filters… | ||
| Predict the future (or don't) with machine learning in applications | Mark Hornick | 22m |
Demonstrates building in-database models with Oracle Machine Learning (AutoML UI, OML4Py, SQL) to train a Random Forest and SVM (Gaussian) on a 60/40 split… | ||
| Graph analytics: From zero to hero | Melli Annamalai | 18m |
Creates a property graph inside Oracle Graph Studio from CUSTOMER, MOVIE and CUSTSALES tables in Autonomous Database, runs PGQL queries and Notebook… | ||
| Store and analyze JSON data using the Oracle API for MongoDB and SQL/JSON | Josh Spiegel | 23m |
Loads 1,600 stations and 20,000 status records into Autonomous JSON Database using mongoimport and mongosh, builds a Spring Boot REST microservice that reads… | ||
| nothing matches | ||