If you are looking for a column based dbms, you might want to check out
Monet - it is a columnar database.
http://monetdb.cwi.nl/
For some applications, columnar databases can be much faster than
traditional rdbms systems. However, column based databases are not a
'one size fits all' answer.
Joshua Tolley wrote:
http://en.wikipedia.org/wiki/Column_oriented_database
This has come up on the lists from time to time; the short answer is it's
really hard.
indeed. among other issues is, just what order should those columns be
stored in? database tables have no implicit order, they
Got it thanks!
On Fri, May 8, 2009 at 2:57 PM, Christophe wrote:
>
> On May 8, 2009, at 11:25 AM, John R Pierce wrote:
>>
>> you read your tables by column, rather than by row??
>> SQL queries are inherently row oriented, the fundamental unit of storage
>> is a 'tuple', which is a representatio
On Fri, May 08, 2009 at 11:25:30AM -0700, John R Pierce wrote:
> Mag Gam wrote:
>> Is it possible to tweak (easily) Postgresql so the storage is column
>> oriented versus row-oriented? We would like to increase read
>> optimization on our data which is about 2TB.
>>
>>
>
> you read your tables b
On May 8, 2009, at 11:25 AM, John R Pierce wrote:
you read your tables by column, rather than by row??
SQL queries are inherently row oriented, the fundamental unit of
storage is a 'tuple', which is a representation of a row of a table.
I believe what is referring to is the disk storage orga
Mag Gam wrote:
Is it possible to tweak (easily) Postgresql so the storage is column
oriented versus row-oriented? We would like to increase read
optimization on our data which is about 2TB.
you read your tables by column, rather than by row??
SQL queries are inherently row oriented, the
