Re: Opportunity for a Radical Changes in Database Software - Mailing list pgsql-hackers

From J. Andrew Rogers
Subject Re: Opportunity for a Radical Changes in Database Software
Date
Msg-id 5C8EC50A-11B4-4EE3-A77C-701A1CF22D2C@neopolitan.com
Whole thread Raw
In response to Re: Opportunity for a Radical Changes in Database Software  (Florian Weimer <fw@deneb.enyo.de>)
Responses Re: Opportunity for a Radical Changes in Database Software
List pgsql-hackers
On Oct 27, 2007, at 2:20 PM, Florian Weimer wrote:
> * J. Andrew Rogers:
>
>> Everything you are looking for is here:
>>
>> http://web.mit.edu/dna/www/vldb07hstore.pdf
>>
>> It is the latest Stonebraker et al on massively distributed in-memory
>> OLTP architectures.
>
> "Ruby-on-Rails compiles into standard JDBC, but hides all the  
> complexity
> of that interface. Hence, H-Store plans to move from C++ to
> Ruby-on-Rails as our stored procedure language."  This reads a bit
> strange.


Yeah, that's a bit of a "WTF?".  Okay, a giant "WTF?".  I could see  
using Ruby as a stored procedure language, but Ruby-on-Rails seems  
like an exercise in buzzword compliance.  And Ruby is just about the  
slowest language in its class, which based on the rest of the paper  
(serializing all transactions, doing all transactions strictly in- 
memory) means that you would be bottlenecking your database node on  
the procedural language rather than the usual I/O considerations.

Most of the architectural stuff made a considerable amount of sense,  
though I had quibbles with bits of it (I think the long history of  
the design makes some decisions look silly in a world that is now  
multi-core by default).  The Ruby-on-Rails part is obviously  
fungible.  Nonetheless, it is a good starting point for massively  
distributed in-memory OLTP architectures and makes a good analysis of  
many aspects of database design from that perspective, or at least I  
have not really seen anything better.  I prefer a slightly more  
conservative approach that generalizes better in that space than what  
is suggested personally.

Cheers,

J. Andrew Rogers



pgsql-hackers by date:

Previous
From: "Alvaro Herrera"
Date:
Subject: Re: [COMMITTERS] pgsql: Allow an autovacuum worker to be interrupted automatically when
Next
From: "Henry B. Hotz"
Date:
Subject: Re: 8.3 GSS Issues