just to add : on this table there will be lakhs of select queries to get tagcombinationid fro a partial set of tags...
On Tue, Jan 21, 2014 at 2:33 PM, Naresh Yadav <nyadav....@gmail.com> wrote: > Hi, > > I need to design a table which will give a UUID to set of tags. > Each tag itself has unique UUID > > *TagCombination* table > TC1 -> India, Pen > TC2 -> Shampoo, U.K > TC3 -> Team1, Product1, Location1 > TC4 -> Office1, India, Pen > > I can have *billion *of such unique combinations and there can be *million > *of unique tags but each combination will have 2 to 10 tags max. > > As data comes daily there would be new combination registered if not > exists. > > *Query on this table :* > 1. Give me list of tags for Tagcombination Id=TC1 > 2. A set of tags comes in which Tagcombination Ids > If i say India,Pen comes then it comes in TC1, TC4 > There can be exact match or partial match on tags to get TCids > > Please suggest design for this so that this table can handle bigdata. > > Thanks > Naresh > >
