Justin!

How is your work with H2 column store progressing?

/Goran

Skickat från min iPad

> 2 mar 2013 kl. 03:32 skrev Justin Edse <[email protected]>:
> 
> Thank you very much Noel,
> 
> I will take a look at those links. At first I thought I would have to really 
> manipulate the low level guts but perhaps not.
> 
> Thanks again!
> 
> 
> 
>> On Friday, March 1, 2013 1:36:59 AM UTC-5, Noel Grandin wrote:
>> Welcome aboard. 
>> 
>> Rather than messing with H2's internals, your best bet is to start by 
>> implementing a custom TableEngine 
>> 
>> http://h2database.com/html/features.html#pluggable_tables 
>> http://h2database.com/javadoc/org/h2/api/TableEngine.html 
>> http://h2database.com/html/grammar.html#create_table 
>> 
>> On 2013-02-28 20:52, Justin Edse wrote: 
>> > Hello everyone, 
>> > 
>> > In a project for one of my college classes I am doing a project which 
>> > emphasizes turning a relational database into a column store. My 
>> > partner and I went through a couple of different DB's but eventually 
>> > picked H2 because it's written entirely in JAVA and seemed easier to 
>> > understand than SQLite or something else. So, we have an idea of what 
>> > we need to change( things such as how things are read and written from 
>> > memory, column format instead of row, the query executor, storage 
>> > layer, etc. Eventually after we are able to implement column stores 
>> > without compression we will try several algorithms to make querying 
>> > faster. But at this point my partner and I are looking over the 
>> > different packages for H2 in Eclipse and think we know where to begin 
>> > but are not completely sure. We noticed a packages called 
>> > "org.h2.store" and "org.h2.store.fs" and thought this might be 
>> > it.FileStore.java in "org.h2.store" contains methods for reading and 
>> > writing bytes. 
>> > 
>> > So after going through all of these different packages I am asking if 
>> > someone would be kind enough to point us in the right direction. 
>> > Someone who really really knows H2, what packages should be start 
>> > adjusting if we wanted to turn this into a column store rather than a 
>> > row store? 
>> > 
>> > Thank you very much. 
>> > -- 
>> > You received this message because you are subscribed to the Google 
>> > Groups "H2 Database" group. 
>> > To unsubscribe from this group and stop receiving emails from it, send 
>> > an email to [email protected]. 
>> > To post to this group, send email to [email protected]. 
>> > Visit this group at http://groups.google.com/group/h2-database?hl=en. 
>> > For more options, visit https://groups.google.com/groups/opt_out. 
>> > 
>> > 
>> 
> -- 
> You received this message because you are subscribed to the Google Groups "H2 
> Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/h2-database?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>  
>  

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to