~/talk

Superfast event stream processing with a converged database

Talkat Oracle DatabaseWorld 2021 · 2021-12-01..12-02· [data-engineering, databases]
links:none on file
slides:none on file

Oracle’s converged database uses Oracle GoldenGate for parallel capture and a Memoptimized Rowstore for burst ingest, claiming 25 million rows per second and even “more than 21 trillion inserts per day on a single two‑socket server.” Partitioning, RAC and sharding split workload; in‑memory columnar scans run analytics at billions of rows/sec; automatic data optimization plus DBMS_SCHEDULER handles rollups. A demo replaces Prometheus: 100 hosts sending 150,000 metrics every 15s, Grafana queries run PromQL translated to SQL and alerts fire from DBMS jobs, proving the pipeline works end‑to‑end.

AI-written summary · about

  1. 0:00Intro
  2. 0:27What is Event Data?
  3. 1:11Properties of Event Data
  4. 2:01What is Event Stream Processing?
  5. 3:42Event Stream Processing Architecture Choices
  6. 5:41JSON in Oracle Ideal for Event Stream Processing
  7. 6:37Oracle Golden Gate for Fast Data Capture Leading real-time data capture engine, available as a fully managed Service
  8. 7:48Memoptimized Rowstore
  9. 8:57Partitioning Paralelism and Elliciency for Event Stream Processing
  10. 10:03Real Application Clusters (RAC) Industry-Leading Scale-Out For Event Stream Processing
  11. 15:35Attribute Clustering Data organization to maximize event analytics performance
  12. 16:52SQL for Event Stream Processing
  13. 19:17Oracle Machine Learning for Event Streams
  14. 20:51Automatic Data Optimization and Database Scheduler
  15. 23:16Downsampling Event Streams Using Database Scheduler
  16. 28:35Event Streams Demo Setup A DevOps Deployment
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.