In this talk, Tanuj Nayak will present Compiling PL/SQL Away from CIDR 2020. This paper details a method of overcoming current overheads of PL/SQL interpretation by compiling it to SQL Common Table Expressions (CTE) using the WITH RECURSIVE construct. Read More

sled is an embedded database that takes advantage of modern lock-free indexing and flash-friendly storage. rio is a pure-rust io_uring library unlocking the linux kernel's new asynchronous IO interface. This short talk will cover techniques that have been used to take advantage of modern hardware and kernels while optimizing for long term developer happiness in a complex, correctness-critical Rust codebase.... Read More

Oracle Database In-Memory - At the heart of multi-model Convergence Aurosish’s team is responsible for all aspects of the data engine for the Oracle Database, ranging from traditional disk-based data accesses and indexing technologies to state-of-the-art distributed in-memory technologies in Oracle's flagship Database In-Memory engine that provides real time analytics at the speed of thought! Currently, they are building Oracle's... Read More

Ever tried reproducing intermittent failures by rerunning a test 100 times, or stared at core dumps where a variable was obviously wrong but you couldn't figure out why? Mozilla's rr records test execution with minimal overhead, and provides you with compact and deterministic execution traces that you can replay forwards and backwards in time. In this talk, we'll focus on... Read More

Machine learning (ML) has proven itself in high-value web applications such as search ranking and is emerging as a powerful tool in a much broader range of enterprise scenarios including voice recognition and conversational understanding for customer support, auto-tuning for videoconferencing, intelligent feedback loops in large-scale sysops, manufacturing and autonomous vehicle management, complex financial predictions, just to name a few.... Read More

In this talk Dana will provide an update on running OtterTune at SocGen. Or, how OtterTune will take over the world. Read More

Matt Butrovich will present a technical overview of CMU's new DBMS project. This is for Advanced Database Systems (15-721) course. Read More

Self-driving database management systems (DBMSs) are a new family of DBMSs that can optimize themselves for better performance without human intervention. Self-driving DBMSs use machine learning (ML) models that predict system behaviors and make planning decisions based on the workload the system sees. These ML models are trained using metrics produced by different components running inside the system. Self-driving DBMSs... Read More

This talk gives an overview of Oracle NVM Direct, an open source implementation of a C API to simplify application development for byte addressable Non Volatile Memory. NVM Direct consists of two major components, namely: A precompiler that converts a source file containing C extensions for NVM to a standard C source file. A runtime library to implement NVM regions,... Read More

Autonomous / Self-Driving Databases utilize machine learning techniques to eliminate the manual labor associated with database tuning, security, backups, updates, and other routine management tasks traditionally performed by DBAs. This talk will focus specifically on how we implement a self-performing database with Oracle’s Database In-Memory product to automatically tune for query optimization, memory management, and storage management and data tiering.... Read More