<p>In db query area arguably <em>Provenance Semiring</em> enjoyed the most attention recently. The "provenance" adjective is just marketing connecting it to a large body of research. Nevertheless the idea that one may have much more elegant mathematical foundation for database query languages is compelling. My personal view is that semiring perspective (which works wonders in formal language theory) has to be complemented with <em>Relational Lattice</em>.  </p>

<p>Here is <a href="http://www.google.com/url?sa=t&amp;rct=j&amp;q=libkin%20youtube&amp;source=web&amp;cd=1&amp;sqi=2&amp;ved=0CB4QtwIwAA&amp;url=http://www.youtube.com/watch?v=wxvZePK2rU0&amp;ei=XiowT6XnBYmjiQLC-tHdCg&amp;usg=AFQjCNFNFS2ComBy6LVfkcUqqsAFRGAj3g" rel="noreferrer">another view</a> of what happened in the last decade. (The speaker holds a record of continued PODS admittance:).</p>

<p>On less theoretical note lets mention <em>Dedalus</em>, and plenty of <em>Tutorial D</em> enthusiasts; both, however, are hardly the recent ideas.</p>

CC BY-SA 3.0
2011-10-06T17:19:26.120Z
2012-02-06T19:33:58.480Z
2012-02-06T19:33:58.480Z
Tegiri Nenashi
<p>The biggest "advance" in relational databases has been the cleaving apart of the monolithic RDBMS model into discrete components, that are then put together in novel ways.  These include data stores that have weak consistency (Google Percolator), column stores (NoSQL), and graph databases.  The ideas are not new, but the different ways of combining the components are novel.</p>

CC BY-SA 3.0
2012-01-26T13:49:54.097Z
2012-01-26T13:49:54.097Z
András Salamon
<p>current major shift in db architecture is rise of key-value stores which seem to distribute/scale easier over the cloud (or new highly multicore chips) than relational db's &amp; work well in large modern web sites such as facebook. they are now provided/supported on the basic cloud service sites ie amazon/google app engine. see eg:</p>

<p><a href="http://www.readwriteweb.com/enterprise/2009/02/is-the-relational-database-doomed.php" rel="nofollow">is the relational database doomed?</a> ReadWriteWeb</p>

<p><a href="http://gigaom2.files.wordpress.com/2011/07/facebook-tilera-whitepaper.pdf" rel="nofollow">Many-Core Key-Value Store</a> Berezecki,Frachtenberg,Paleczny [Facebook], Steele [Tilera]. a paper examining a key-value db &amp; measuring performance statistics on various multicore chips from 4 (intel xeon) to 64 (tilera)</p>

CC BY-SA 3.0
2012-01-26T16:04:26.377Z
2012-01-26T16:04:26.377Z
vzn
<p>I'm wondering what are recent advances in relational database theory and related domains?</p>

<p>I'm interested in new approaches, query languages (alternatives to SQL and/or extensions to it), products (proprietary and open source, though I'm much more interested in open source) and research projects developed in last years.</p>

CC BY-SA 3.0
2011-10-05T08:34:32.383Z
Related: http://cstheory.stackexchange.com/questions/2974/what-are-the-prospects-of-research-in-database-field
Dave Clarke
<db.databases><relational-structures>
What are recent advances in relational databases?
andreypopp
# What are recent advances in relational databases?

(Asked by: username_0 on 2011-10-05)

I'm wondering what are recent advances in relational database theory and related domains?

I'm interested in new approaches, query languages (alternatives to SQL and/or extensions to it), products (proprietary and open source, though I'm much more interested in open source) and research projects developed in last years.

**Tags:** db.databases, relational-structures

> **Comments:**
> **username_1**: Related: http://cstheory.stackexchange.com/questions/2974/what-are-the-prospects-of-research-in-database-field  

---

## 3 answers

### Answer by username_2 on 2011-10-06. Score: 10

In db query area arguably *Provenance Semiring* enjoyed the most attention recently. The "provenance" adjective is just marketing connecting it to a large body of research. Nevertheless the idea that one may have much more elegant mathematical foundation for database query languages is compelling. My personal view is that semiring perspective (which works wonders in formal language theory) has to be complemented with *Relational Lattice*.

Here is [another view](http://www.google.com/url?sa=t&rct=j&q=libkin%20youtube&source=web&cd=1&sqi=2&ved=0CB4QtwIwAA&url=http://www.youtube.com/watch?v=wxvZePK2rU0&ei=XiowT6XnBYmjiQLC-tHdCg&usg=AFQjCNFNFS2ComBy6LVfkcUqqsAFRGAj3g) of what happened in the last decade. (The speaker holds a record of continued PODS admittance:).

On less theoretical note lets mention *Dedalus*, and plenty of *Tutorial D* enthusiasts; both, however, are hardly the recent ideas.


---

### Answer by username_3 on 2012-01-26. Score: 4

The biggest "advance" in relational databases has been the cleaving apart of the monolithic RDBMS model into discrete components, that are then put together in novel ways. These include data stores that have weak consistency (Google Percolator), column stores (NoSQL), and graph databases. The ideas are not new, but the different ways of combining the components are novel.


---

### Answer by username_4 on 2012-01-26. Score: 0

current major shift in db architecture is rise of key-value stores which seem to distribute/scale easier over the cloud (or new highly multicore chips) than relational db's & work well in large modern web sites such as facebook. they are now provided/supported on the basic cloud service sites ie amazon/google app engine. see eg:

[is the relational database doomed?](http://www.readwriteweb.com/enterprise/2009/02/is-the-relational-database-doomed.php) ReadWriteWeb

[Many-Core Key-Value Store](http://gigaom2.files.wordpress.com/2011/07/facebook-tilera-whitepaper.pdf) Berezecki,Frachtenberg,Paleczny [Facebook], Steele [Tilera]. a paper examining a key-value db & measuring performance statistics on various multicore chips from 4 (intel xeon) to 64 (tilera)


---

