hbase-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dima Spivak <dspi...@cloudera.com>
Subject Fwd: data base design question
Date Thu, 12 Feb 2015 20:12:23 GMT
Forwarding to users@, moving dev@ to bcc. People on the user list might be
more helpful here, Jignesh.

Cheers,
  Dima

---------- Forwarded message ----------
From: *Jignesh Patel* <jigneshmpatel@gmail.com>
Date: Thursday, February 12, 2015
Subject: data base design question
To: "dev@hbase.apache.org" <dev@hbase.apache.org>


I have a requirement where I have to define two entities: orders and
results.
Now each order can have multiple results, for db design I will have two
options:

Option 1: Create an embedded entity of results and store it as list object
inside order tabel as one of the column field.
Option 2. Create a separate table of orders and results and build secondary
index inside solr where for given order id, multiple results ids are mapped.

Is there a better alternative than  above options for one to many
relationships?

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message