Re: Data Model Design for Login Servie

2011-11-20 Thread Maciej Miklas
I will follow exactly this solution - thanks :) On Fri, Nov 18, 2011 at 9:53 PM, David Jeske wrote: > On Thu, Nov 17, 2011 at 1:08 PM, Maciej Miklas > wrote: > >> A) Skinny rows >> - row key contains login name - this is the main search criteria >> - login data is replicated - each possible l

Re: Data Model Design for Login Servie

2011-11-18 Thread David Jeske
On Thu, Nov 17, 2011 at 1:08 PM, Maciej Miklas wrote: > A) Skinny rows > - row key contains login name - this is the main search criteria > - login data is replicated - each possible login is stored as single row > which contains all user data - 10 logins for single customer create 10 rows, whe

Re: Data Model Design for Login Servie

2011-11-18 Thread Mohit Anchlia
ase (high read load, many unique values). > > > > [1] http://www.datastax.com/docs/1.0/ddl/indexes > > > > Dan > > > > From: Maciej Miklas [mailto:mac.mik...@googlemail.com] > Sent: November-18-11 1:39 > To: user@cassandra.apache.org > Subject: Re: Data Mod

RE: Data Model Design for Login Servie

2011-11-18 Thread Dan Hendry
...@googlemail.com] Sent: November-18-11 1:39 To: user@cassandra.apache.org Subject: Re: Data Model Design for Login Servie but secondary index is limited only to repeating values like enums. In my case I would have performance issue. right? On 18.11.2011, at 02:08, Maxim Potekhin wrote: 1122

Re: Data Model Design for Login Servie

2011-11-17 Thread Maciej Miklas
but secondary index is limited only to repeating values like enums. In my case I would have performance issue. right? On 18.11.2011, at 02:08, Maxim Potekhin wrote: 1122: { gender: MALE birthdate: 1987.11.09 name: Alfred Tester pwd: e72c504dc16c8fcd2fe8c7

Re: Data Model Design for Login Servie

2011-11-17 Thread Maxim Potekhin
1122: { gender: MALE birthdate: 1987.11.09 name: Alfred Tester pwd: e72c504dc16c8fcd2fe8c74bb492affa alias1: alfred.tes...@xyz.de alias2: alf...@aad.de alias3: a...@dd.de

RE: Data Model Design for Login Servie

2011-11-17 Thread Dan Hendry
, benchmark against your specific case. Dan From: Maciej Miklas [mailto:mac.mik...@googlemail.com] Sent: November-17-11 16:08 To: user@cassandra.apache.org Subject: Data Model Design for Login Servie Hallo all, I need your help to design structure for simple login service. It contains about

Data Model Design for Login Servie

2011-11-17 Thread Maciej Miklas
Hallo all, I need your help to design structure for simple login service. It contains about 100.000.000 customers and each one can have about 10 different logins - this results 1.000.000.000 different logins. Each customer contains following data: - one to many login names as string, max 20 UTF-8