Grokbase Groups HBase user July 2012
FAQ
Hi,

I have technical problem, and wander whether HBase or Cassandra
support Embedded table data model, or can somebody show me a way to do
this:

1.We have a very large customer entity table which have 100 milliion
rows, each customer row has about 300 attributes(columns).
2.Each customer do about 1000 transactions per year, each transaction
has about 30 attributes(columns), and we just save one year
transactions for each customer

We want a data model that we can get the customer entity with all the
transactions which he did for a single client call within a fixed time
window, according to the customer id (which is the primary key of the
customer table). We do the following in RDBMS,
A customer table with customerid as the primary key, A transaction
table with customer id as a secondary index, and join them , or we
must do two separate calls, and because we have so many concurrent
readers and these two tables are became so large, the RDBMS system
performs poor.


Can we embedded the transactions inside the customer table in HBase or
Cassandra?


Regards,

Xiaobo Gu

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 10 | next ›
Discussion Overview
groupuser @
categorieshbase, hadoop
postedJul 12, '12 at 3:58a
activeJul 13, '12 at 2:55p
posts10
users4
websitehbase.apache.org

People

Translate

site design / logo © 2022 Grokbase