News & Events

[DB Seminar] Fall 2018: Tianyu Li, Matt Butrovich, Sivaprasad Sudhir

Dec 7, 2018

Project 1: Storage Engine (Tianyu Li & Matt Butrovich) In this talk, we will discuss the work we've done on terrier's storage engine over the semester. We will cover the implementation of write-ahead logging and our proposed model for recovery, implementation of indexes, and our roadmap for the storage engine next semester. The immediate future direction for the storage work is to support Apache Arrow natively as our storage format to reduce ETL overhead to a data science pipeline, while Read More

[DB Seminar] Fall 2018: Lin Ma

Nov 20, 2018

n the last two decades, both researchers and vendors have built advisory tools to assist database administrators (DBAs) in various aspects of system tuning and physical design. Most of this previous work, however, is incomplete because they still require humans to make the final decisions about any changes to the database and are reactionary measures that fix problems after they occur. What is needed for a truly self-driving database management system (DBMS) is a new architecture that is designed for Read More

Carnegie Mellon Database Group Wins 2018 IEEE ICDM Test-of-Time Paper Award

Nov 11, 2018

Singapore - The Carnegie Mellon Database Group is pleased to announce that their 2009 paper PEGASUS: A Peta-Scale Graph Mining System - Implementation and Observations has won the 2018 IEEE ICDM Test-of-Time Award. The authors were CMU Ph.D. students U Kang and Charalampos Tsourakakis, in collaboration with Prof. Christos Faloutsos. This paper on the PEGASUS project showed how to apply graph-mining algorithms on a Map-Reduce platform. The main insight was that a wide range of graph mining algorithms eventually require Read More

[DB Seminar] Fall 2018: Ethan Zhang (VoltDB)

Nov 11, 2018

Following from the idea that "one size no longer fits for all", a family of "NewSQL" specialized databases arose. To handle OLTP, researchers at MIT and Brown (and a few other places) built H-Store, a distributed, shared-nothing, in-memory database that got rid of locking, latching, buffering, and logging, beating the performance of traditional OLTP RDBMSs by nearly two orders of magnitude. This prototype was commercialized in 2009 as VoltDB. Since then, the two have lived full and productive lives in Read More

[DB Seminar] Fall 2018: Yihan Sun

Oct 24, 2018

Modern query-heavy applications of database systems especially require minimal delays to OLAP queries, as well as allowing the lasted OLTP updates to be visible in time. A popular mechanism for fast response to OLAP queries is to use snapshot isolation (SI) for multi-version concurrency control (MVCC), as it allows readers to make progress regardless of concurrent writers. Many other optimizations for OLAP queries include denormalization, materialization view and table partitioning. However, most existing solutions to these optimizations do not support Read More

[Hardware Accelerated Databases] Richard Heyns (Brytlyt)

Oct 15, 2018

In this talk, we will cover how the implementation of GPU database management systems are different than CPU database systems and provide evidence that shows how much of the performance gains with these systems are achieved via just GPUs. We will also discuss how we are solving the problems of tomorrow – making AI smarter, faster and more intuitive with Brytlyt's BrytMind by combining SQL with its GPU Manager and AI. We will also explore the different ways GPU Databases Read More

[Hardware Accelerated Databases] Karsten Rönner (Swarm64)

Oct 9, 2018

Online Analytical Processing (OLAP) of very large data sets and/or high-velocity data is a workload that strains all parts of a compute system: storage bandwidth, IO-subsystem throughput, main-memory bandwidth, instruction-level concurrency and thread-parallelism. Swarm64 seeks to improve the effective throughput and the compute efficiency of OLAP workloads by adding FPGAs as additional compute element to standard compute servers. The hard- and software stack performing OLAP workloads, the S64 DA, has been designed to integrate into popular SQL open-source databases through Read More