Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of ivarley@salesforce.com
 designates 64.18.3.24 as permitted sender)
From: Ian Varley <ivarley@salesforce.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Date: Thu, 23 Feb 2012 06:16:59 -0800
Subject: Re: Seeking HBase schema design examples
Thread-Topic: Seeking HBase schema design examples
Thread-Index: AczyNc6HvgbWXsB8QD6eSYFxx5hUjg==
Message-ID: <04F99E49-ECC8-4656-A0ED-C22D22C34939@salesforce.com>
References: <B3510F52-197E-41CE-9BC3-34340D1F1DE5@salesforce.com>
 <CAO1Khk-vVY+nW8etpaSKjc+6QQO1URq22i+R1FsQdHNhVtkw3g@mail.gmail.com>
In-Reply-To: 
 <CAO1Khk-vVY+nW8etpaSKjc+6QQO1URq22i+R1FsQdHNhVtkw3g@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_04F99E49ECC84656A0EDC22D22C34939salesforcecom_"
MIME-Version: 1.0

--_000_04F99E49ECC84656A0EDC22D22C34939salesforcecom_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Yes, that's a great one - and it's one of the few schemas I've found that's=
 published online and well explained. I think we need more of that! :)

Ian

On Feb 23, 2012, at 1:23 AM, Igor Lautar wrote:

I've found OpenTSDB interesting:

http://opentsdb.net/schema.html


On Wed, Feb 22, 2012 at 10:40 PM, Ian Varley <ivarley@salesforce.com> wrote=
:

All:

I=92m doing a study on HBase schema design, with a goal of contributing bac=
k
a presentation or summary about how data modeling is practically done in
HBase. I'd like to base it as much as possible on real world examples (i.e.
things that are running in production today). I=92ve got several examples
already, but I=92d love more input from the community. If you have designed
an HBase schema that worked really well (or, conversely, that failed in an
instructive way), and feel like sharing it with me, I=92d love to hear abou=
t
it (you can email me directly, or share it on the list). If you'd like the
source or identifying details to be obfuscated, that's totally doable.

In particular, I would *love* to hear about people doing complex things
within a single HBase row (like, storing several entities=92 worth of data =
in
columns / column families of the same HBase row, for atomicity or other
reasons). Also interested in nifty stuff using atomic increments, check &
sets, etc. Generally, any clever insights you have about how to make
conceptual data models work well on HBase are what I'd love to digest and
share with the community.

Thanks!
Ian


--_000_04F99E49ECC84656A0EDC22D22C34939salesforcecom_--