You'll want to review this too... http://hbase.apache.org/book.html#schema
On 10/10/11 2:51 AM, "Sonal Goyal" <[email protected]> wrote: >One possible schema for your case could be: > >rowkey: book. Column familty: author, qualifiers one, two, three... >AND similar table for authors >rowkey: author, Column family books > >Best Regards, >Sonal >Crux: Reporting for HBase <https://github.com/sonalgoyal/crux> >Nube Technologies <http://www.nubetech.co> > ><http://in.linkedin.com/in/sonalgoyal> > > > > > >On Mon, Oct 10, 2011 at 12:05 PM, Syg raf <[email protected]> wrote: > >> I want to be able to get an author or a book and also, i want to be >>able to >> get all the authors of a book and all the books of an author (N to N >> relation in SQL db). Does that give you enough information? >> >> Thanks >> On Mon, Oct 10, 2011 at 2:16 AM, Sonal Goyal <[email protected]> >> wrote: >> >> > How do you want to query your data? This question decides how you can >> save >> > your data. >> > >> > Best Regards, >> > Sonal >> > Crux: Reporting for HBase <https://github.com/sonalgoyal/crux> >> > Nube Technologies <http://www.nubetech.co> >> > >> > <http://in.linkedin.com/in/sonalgoyal> >> > >> > >> > >> > >> > >> > On Mon, Oct 10, 2011 at 11:17 AM, Syg raf <[email protected]> >>wrote: >> > >> > > Thanks Sam for the link, I'm going to get the book ordered. >> > > >> > > Just to start and get familliar with HBase, can yo tell if >>everything >> go >> > > into one table and the data separated into column families? if not, >> based >> > > on >> > > what we create multiple tables ? >> > > >> > > Thanks >> > > >> > > On Mon, Oct 10, 2011 at 1:28 AM, Sam Seigal <[email protected]> >> wrote: >> > > >> > > > Start off with the HBase book, great resource for getting started: >> > > > >> > > > http://ofps.oreilly.com/titles/9781449396107/ >> > > > >> > > > >> > > > On Sun, Oct 9, 2011 at 10:25 PM, Syg raf <[email protected]> >> wrote: >> > > > >> > > > > Hello folks, >> > > > > >> > > > > I'm just starting with HBase and have a couple of rudimentary >> > questions >> > > > > about how to use it: >> > > > > >> > > > > I have a simple Java program that have been developer for the >> purpose >> > > of >> > > > > learning HBase, the program was built with MySQL as database, >>it >> > > contain >> > > > 3 >> > > > > tables: Authors, Books and AuthorBook (for the N to N relation). >> > > > > I am wondering if someone can help me to do the same with HBase, >> what >> > > > could >> > > > > the schema be? >> > > > > Any recommendations are welcome and just keep in mind that I'm >>just >> > > > > beginning, simple explanation would be great. >> > > > > >> > > > > Thanks a lot, >> > > > > Sygura. >> > > > > >> > > > >> > > >> > >>
