bcc: asynchbase@

On Sat, Feb 16, 2013 at 12:28 PM, Steve Berg <[EMAIL PROTECTED]> wrote:
> I have some questions for HBase DB:

Hi Steve,
I'm moving this thread to the HBase user mailing list.

> How to ensure data integrity?

Data stored by HBase in HDFS has 3 replicas of the data and checksums.

> Are there methods ensure the integrity?

It's all built-in, I'm not sure what you meant by "methods" here.

> Does HBase primary key? or alternatives

HBase has only one primary key per table.
You may wanna look at the HBase Book, Chapter 5. "Data Model":
http://hbase.apache.org/book.html#datamodel

> Foreign key?

No.

> Referential Integrity?

No.

> How are the ACID properties to be implemented?

http://hbase.apache.org/acid-semantics.html

--
Benoit "tsuna" Sigoure

Also check out this blog post for a detailed explanation of ACID in HBase: http://hadoop-hbase.blogspot.com/2012/03/acid-in-hbase.html

________________________________
 From: tsuna <[EMAIL PROTECTED]>
To: Steve Berg <[EMAIL PROTECTED]>
Cc: HBase users <[EMAIL PROTECTED]>
Sent: Saturday, February 16, 2013 4:48 PM
Subject: Re: HBase and Data Integrity
 
bcc: asynchbase@

On Sat, Feb 16, 2013 at 12:28 PM, Steve Berg <[EMAIL PROTECTED]> wrote:
> I have some questions for HBase DB:

Hi Steve,
I'm moving this thread to the HBase user mailing list.

> How to ensure data integrity?

Data stored by HBase in HDFS has 3 replicas of the data and checksums.

> Are there methods ensure the integrity?

It's all built-in, I'm not sure what you meant by "methods" here.

> Does HBase primary key? or alternatives

HBase has only one primary key per table.
You may wanna look at the HBase Book, Chapter 5. "Data Model":
http://hbase.apache.org/book.html#datamodel

> Foreign key?

No.

> Referential Integrity?

No.

> How are the ACID properties to be implemented?

http://hbase.apache.org/acid-semantics.html

--
Benoit "tsuna" Sigoure

Some addendum to Benoit's answers.
In HBase you can setup Constraint for your table. From javadoc:

 * Apply a {@link Constraint} (in traditional database terminology) to a
HTable.

 * Any number of {@link Constraint Constraints} can be added to the table,
in

 * any order.
See hbase-server/src/main/java/org/apache/hadoop/hbase/constraint/Constraint.java

Cheers

On Sat, Feb 16, 2013 at 4:48 PM, tsuna <[EMAIL PROTECTED]> wrote:

> bcc: asynchbase@
>
> On Sat, Feb 16, 2013 at 12:28 PM, Steve Berg <[EMAIL PROTECTED]>
> wrote:
> > I have some questions for HBase DB:
>
> Hi Steve,
> I'm moving this thread to the HBase user mailing list.
>
> > How to ensure data integrity?
>
> Data stored by HBase in HDFS has 3 replicas of the data and checksums.
>
> > Are there methods ensure the integrity?
>
> It's all built-in, I'm not sure what you meant by "methods" here.
>
> > Does HBase primary key? or alternatives
>
> HBase has only one primary key per table.
> You may wanna look at the HBase Book, Chapter 5. "Data Model":
> http://hbase.apache.org/book.html#datamodel
>
> > Foreign key?
>
> No.
>
> > Referential Integrity?
>
> No.
>
> > How are the ACID properties to be implemented?
>
> http://hbase.apache.org/acid-semantics.html
>
> --
> Benoit "tsuna" Sigoure
>

Yes, but implementing a constraint requires implementing a coprocessor,
which is not something I'd recommend to users as a general practice. HBase
doesn't offer referential integrity as commonly understood in the RDBMS
world (foreign keys, etc.) out of the box.
On Sat, Feb 16, 2013 at 6:52 PM, Ted Yu <[EMAIL PROTECTED]> wrote:

> Some addendum to Benoit's answers.
> In HBase you can setup Constraint for your table. From javadoc:
>
>  * Apply a {@link Constraint} (in traditional database terminology) to a
> HTable.
>
>  * Any number of {@link Constraint Constraints} can be added to the table,
> in
>
>  * any order.
> See
> hbase-server/src/main/java/org/apache/hadoop/hbase/constraint/Constraint.java
>
> Cheers
>
> On Sat, Feb 16, 2013 at 4:48 PM, tsuna <[EMAIL PROTECTED]> wrote:
>
> > bcc: asynchbase@
> >
> > On Sat, Feb 16, 2013 at 12:28 PM, Steve Berg <[EMAIL PROTECTED]>
> > wrote:
> > > I have some questions for HBase DB:
> >
> > Hi Steve,
> > I'm moving this thread to the HBase user mailing list.
> >
> > > How to ensure data integrity?
> >
> > Data stored by HBase in HDFS has 3 replicas of the data and checksums.
> >
> > > Are there methods ensure the integrity?
> >
> > It's all built-in, I'm not sure what you meant by "methods" here.
> >
> > > Does HBase primary key? or alternatives
> >
> > HBase has only one primary key per table.
> > You may wanna look at the HBase Book, Chapter 5. "Data Model":
> > http://hbase.apache.org/book.html#datamodel
> >
> > > Foreign key?
> >
> > No.
> >
> > > Referential Integrity?
> >
> > No.
> >
> > > How are the ACID properties to be implemented?
> >
> > http://hbase.apache.org/acid-semantics.html
> >
> > --
> > Benoit "tsuna" Sigoure
> >
>

--
Best regards,

   - Andy

Problems worthy of attack prove their worth by hitting back. - Piet Hein
(via Tom White)

Hi,

I'm looking for an example of the constraints in HBase with |void check
(put p)|, this is indeed possible, but how? Does anyone possible
examples (code) to?

Ever advance thank you!

best regards!

Am 18.02.2013 01:15, schrieb Andrew Purtell:
> Yes, but implementing a constraint requires implementing a
> coprocessor, which is not something I'd recommend to users as a
> general practice. HBase doesn't offer referential integrity as
> commonly understood in the RDBMS world (foreign keys, etc.) out of the
> box.
>
>
> On Sat, Feb 16, 2013 at 6:52 PM, Ted Yu <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>> wrote:
>
>     Some addendum to Benoit's answers.
>     In HBase you can setup Constraint for your table. From javadoc:
>
>      * Apply a {@link Constraint} (in traditional database
>     terminology) to a
>     HTable.
>
>      * Any number of {@link Constraint Constraints} can be added to
>     the table,
>     in
>
>      * any order.
>     See
>     hbase-server/src/main/java/org/apache/hadoop/hbase/constraint/Constraint.java
>
>     Cheers
>
>     On Sat, Feb 16, 2013 at 4:48 PM, tsuna <[EMAIL PROTECTED]
>     <mailto:[EMAIL PROTECTED]>> wrote:
>
>     > bcc: asynchbase@
>     >
>     > On Sat, Feb 16, 2013 at 12:28 PM, Steve Berg
>     <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
>     > wrote:
>     > > I have some questions for HBase DB:
>     >
>     > Hi Steve,
>     > I'm moving this thread to the HBase user mailing list.
>     >
>     > > How to ensure data integrity?
>     >
>     > Data stored by HBase in HDFS has 3 replicas of the data and
>     checksums.
>     >
>     > > Are there methods ensure the integrity?
>     >
>     > It's all built-in, I'm not sure what you meant by "methods" here.
>     >
>     > > Does HBase primary key? or alternatives
>     >
>     > HBase has only one primary key per table.
>     > You may wanna look at the HBase Book, Chapter 5. "Data Model":
>     > http://hbase.apache.org/book.html#datamodel
>     >
>     > > Foreign key?
>     >
>     > No.
>     >
>     > > Referential Integrity?
>     >
>     > No.
>     >
>     > > How are the ACID properties to be implemented?
>     >
>     > http://hbase.apache.org/acid-semantics.html
>     >
>     > --
>     > Benoit "tsuna" Sigoure
>     >
>
>
>
>
> --
> Best regards,
>
>    - Andy
>
> Problems worthy of attack prove their worth by hitting back. - Piet
> Hein (via Tom White)

I have some questions for HBase DB:

    How to ensure data integrity?
    Are there methods ensure the integrity?
    Does HBase primary key? or alternatives
    Foreign key?
    Referential Integrity?
    How are the ACID properties to be implemented?

Ever Thanks for a possible feedback

best regards - SB -
--
View this message in context: http://apache-hbase.679495.n3.nabble.com/HBase-and-Data-Integrity-tp4040042.html
Sent from the HBase User mailing list archive at Nabble.com.

Hi SB,

I have written a few blog posts about various topics.

For ACID and consistency questions this might help: http://hadoop-hbase.blogspot.com/2012/03/acid-in-hbase.html
As a general quick introduction this might be of help: http://hadoop-hbase.blogspot.com/2011/12/introduction-to-hbase.html
As Stack says, for general questions I would start by perusing the material on http://hbase.apache.org/ and potentially buy one of the books about HBase.

Thanks.

-- Lars
----- Original Message -----
From: viv1d <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc:
Sent: Monday, March 11, 2013 1:25 PM
Subject: HBase and Data Integrity

I have some questions for HBase DB:

    How to ensure data integrity?
    Are there methods ensure the integrity?
    Does HBase primary key? or alternatives
    Foreign key?
    Referential Integrity?
    How are the ACID properties to be implemented?

Ever Thanks for a possible feedback

best regards - SB -
--
View this message in context: http://apache-hbase.679495.n3.nabble.com/HBase-and-Data-Integrity-tp4040042.html
Sent from the HBase User mailing list archive at Nabble.com.

On Mon, Mar 11, 2013 at 1:25 PM, viv1d <[EMAIL PROTECTED]> wrote:

> I have some questions for HBase DB:
>
>     How to ensure data integrity?
>     Are there methods ensure the integrity?
>     Does HBase primary key? or alternatives
>     Foreign key?
>     Referential Integrity?
>     How are the ACID properties to be implemented?
>
> Ever Thanks for a possible feedback
>

Please do a bit of background reading first before asking questions on the
list.  Big general questions such as yours are usually already answered
multiple times over.  See our refguide:
http://hbase.apache.org/book.html For constraints, see
http://hbase.apache.org/book.html#constraints  Our limited ACID is also
explained therein (The book points to this page:
http://hbase.apache.org/acid-semantics.html).  If you search the list for
'referential integrity', you will find the question was answered a few days
ago already (none).

Thanks,
St.Ack