A statistical model is only as good as its training data. Systematic errors can arise when data are integrated from untrustworthy sources, collected in mixed formats, or contain inconsistent references of the same real-world entities. This talk describes the classical relational database topic of "data cleaning", i.e., the process of transforming the data to remove such issues, from a modern... Read More

Analytic workloads in data management systems are dominated by joins, aggregations, scan and filtering costs. In-Memory columnar databases have significantly optimized scans using compressed data formats and SIMD vectorization techniques, but have made little impact to the rest of the query execution plan. The Oracle Database In-Memory (DBIM) Option introduced new SQL execution operators that accelerate a wide range of... Read More

Read More

High-resolution, continuously-recording, and nearly-ubiquitous cameras provide great value for retrospective video analysis tasks in areas such as crime investigations and scientific research. This kind of video analysis task is often both interactive and exploratory in nature, where multiple queries are tried, aborted, refined, and re-executed in an iterative fashion. This exploratory video analysis usage model presents some unique challenges and... Read More

We are at an exciting point in the evolution of memory technology. Device manufacturers have created a new non-volatile memory (NVM) technology that can serve as both system memory and storage. NVM supports fast reads and writes similar to volatile memory, but all writes to it are persistent like a solid-state disk. The advent of NVM invalidates decades of design... Read More

Abstract: Lock-free data structures have long been rumored to provide better performance and scalability than their lock-based counterparts. On the other hand, however, there are state-of-the-art in-memory indices using various fine-grained synchronization techniques that outperform the classical lock coupling implementation. In this talk, we investigate into a concrete, optimized implementation of a lock-free B+Tree, the Bw-Tree[1], and then conduct an... Read More

For the first time since Von Neumann's architecture of the 1940s, device manufacturers have created a new non-volatile memory (NVM) technology that can serve as both system memory and storage. NVM supports low-latency byte-addressable reads and writes similar to volatile memory, but all writes to it are persistent like a solid-state disk. The advent of NVM invalidates decades of design... Read More

Read More

For decades the industry has sought solutions to the challenge of efficient distributed transactions, and ideally to elastically-scalable distributed transactions.  The opportunity for such systems is to provide on-demand capacity, redundancy-based uptime models, and automation of labor-intensive administrative tasks.  Additionally Elastic SQL systems may provide a route to geo-distributed transactions processing.  The approaches to this challenge have all involved very... Read More

For the first time in 25 years, a new non-volatile memory (NVM) category is being created that is two orders of magnitude faster than current durable storage devices. The advent of NVM fundamentally changes the dichotomy between memory and durable storage in database systems. These new NVM devices are almost as fast as DRAM, but all writes to it are... Read More