Microsoft SQL Server’s In-Memory OLTP Architecture and Capabilities (Michael Zwilling)

Speaker:

Michael Zwilling

System:

SQL Server

Video:

YouTube

In-Memory OLTP (formerly known as Hekaton) is a key feature in the In-Memory offerings of Microsoft's SQL Server 2014 product. In this talk we will discuss the hardware trends, user scenarios, and history that prompted its key architectural pillars of main-memory optimization, lock/latch-free concurrency control and SQL compilation to native code, as well as how the technology is integrated into... Read More

DB Seminar [Fall 2014]: Pengtao Xie

Speaker:

Pengtao Xie

Many graph mining and analysis services have been deployed on the cloud, including Neo4j, GraphDB, Dydra, Infinity Graph, GraphLab, System G, to name a few. Cloud based graph analytics can alleviate users from the burden of implementing and maintaining graph algorithms. However, it invades the security and privacy of users' graph data. To solve this problem, we propose CryptGraph, which runs graph analytics on encrypted graph... Read More

DB Seminar [Fall 2014]: Joy Arulraj

Speaker:

Joy Arulraj

The advent of non-volatile memory (NVM) technologies will fundamentally change the dichotomy between transitory memory and durable storage in database management systems (DBMSs). These new NVM devices are almost as fast as DRAM but all writes are persistent even after power loss. Existing DBMSs are unable to take full advantage of this new technology because their internal architectures are predicated... Read More

MemSQL: A Distributed In-Memory SQL Database (Ankur Goyal)

Speaker:

Ankur Goyal

System:

MemSQL

Video:

YouTube

This talk will cover the major architectural design decisions with discussion on specific technical details as well as the motivation behind the big decisions. We will cover lockfree, code generation, durability/replication, distributed query execution, and clustering in MemSQL. We will then discuss some of the new directions for the product. Part of the "Seven Databases in Seven Weeks" Seminar Series:... Read More

DB Seminar: First Meeting 2014

This is the first meeting of the CMU DB Group for the Fall 2014 semester. There will not be a speaker. Instead, we will discuss the following agenda: Introductions Assigning roles: Managing Twitter, Website, Weekly Meetings Fall DB/PDL/SDI Seminar Series Christos' bacchanalian trip to Las Vegas All are welcome. Read More

DB Seminar: Atreyee Maiti

Speaker:

Atreyee Maiti

Transactions in on-line transaction processing (OLTP) workloads typically have the following characteristics: (1) they are short-lived, (2) they work on a small subset of the data, (3) they are repetitive. Traditional disk-based database management systems (DBMS) incur too much overhead for OLTP datasets that could simply be memory resident. This is because of the presence of heavyweight concurrency control and... Read More

DB Seminar: Jay-Yoon Lee

Speaker:

Jay-Yoon Lee

How can we visualize billion-scale graphs? How to spot outliers in such graphs quickly? Visualizing graphs is the most direct way of understand- ing them; however, billion-scale graphs are very difficult to visualize since the amount of information overflows the resolution of a typical screen. In this paper we propose NET-RAY, an open-source package for visualization- based mining on billion-scale... Read More

Mike Cafarella (University of Michigan)

Speaker:

Mike Cafarella

Trained systems that apply machine learning to very large datasets, such as web search and IBM's Watson question-answering system, are among the most important and sophisticated software systems being constructed today. Such trained systems are frequently based on supervised learning tasks that require features, signals extracted from the data that distill complicated raw data objects into a small number of... Read More

Database Group Meeting (April 21, 2014)

Speaker:

Vagelis Papalexakis

How can we correlate the neural activity in the human brain as it responds to typed words, with properties of these terms (like ’edible’, ’fits in hand’)? In short, we want to find latent variables, that jointly explain both the brain activity, as well as the behavioral responses. This is one of many settings of the Coupled Matrix- Tensor Factorization... Read More

Datomic (Rich Hickey)

Speaker:

Rich Hickey

System:

Datomic

Proponents of functional programming tout its many benefits, most of which are available only within a particular process, or afforded by a particular programming language feature. Anything outside of that is considered I/O, dangerous and difficult to reason about. But real systems almost always cross process and language boundaries, and most require, crucially, a very gnarly bit of shared state... Read More