I think the average number of properties users would add to a specific page should be estimated. I guess, about 99.9% pages would not be associated with too many properties. The others can be handled with special solution. Saving properties as columns is a good way to this problem, I think.
On Tue, Mar 20, 2012 at 5:04 PM, Konrad Tendera <[email protected]> wrote: > But what about multiple properties? Every user can use any number of > properties. > > On Tue, 20 Mar 2012 14:26:52 +0530 > Laxman <[email protected]> wrote: > > > Do we see any problem with the below schema? > > > > family "info": > > "info:pg" - keeps page number > > "info:id" - sender ID > > "info:nm" - pdf name > > "info:prop_name" - column to hold property name > > "info:prop_value" - column to hold property value > > family "data": > > "data:blob" - blob of pdf file > > > > -- > > Regards, > > Laxman > > > -----Original Message----- > > > From: Konrad Tendera [mailto:[email protected]] > > > Sent: Monday, March 19, 2012 8:22 PM > > > To: [email protected] > > > Subject: Rows vs. Columns > > > > > > Hello, > > > > > > I'm designing some schema for my use case and I'm considering what will > > > be better: rows or columns. Here's what I need - my schema actually > > > looks like this (it will be used for keeping not large pdf files or > > > single pages of larger document) > > > table files: > > > family "info": > > > "info:pg" - keeps page number > > > "info:id" - sender ID > > > "info:nm" - pdf name > > > *** > > > family "data": > > > "data:blob" - blob of pdf file > > > > > > Now let's get back to ***: each user can add multiple of additional > > > properties ("name" - "value"), but let's assume that every user will be > > > so creative that there won't be two same names. I don't know how solve > > > this problem: each "name" will be new column ("info:name") or I should > > > try to do this like it is said here: > > > http://hbase.apache.org/book.html#schema.smackdown.rowscols and make > > > new > > > row for earch property? > > > > > > K. > > > > > -- > Konrad Tendera > -- With Regards! Ye, Qian
