From user-return-31679-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Wed Feb 6 06:19:34 2013 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6D5A2D728 for ; Wed, 6 Feb 2013 06:19:34 +0000 (UTC) Received: (qmail 42402 invoked by uid 500); 6 Feb 2013 06:19:31 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 42361 invoked by uid 500); 6 Feb 2013 06:19:31 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 42344 invoked by uid 99); 6 Feb 2013 06:19:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Feb 2013 06:19:31 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [203.199.18.84] (HELO mail1.impetus.co.in) (203.199.18.84) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Feb 2013 06:19:22 +0000 Received: from MAIL2.impetus.co.in (192.168.100.8) by mail1.impetus.co.in (192.168.100.28) with Microsoft SMTP Server (TLS) id 14.2.283.3; Wed, 6 Feb 2013 11:48:59 +0530 Received: from MAIL3.impetus.co.in ([fe80::443f:4f25:6889:b268]) by Mail2.impetus.co.in ([fe80::9453:16e7:f5d0:4746%11]) with mapi id 14.02.0283.003; Wed, 6 Feb 2013 11:48:58 +0530 From: Rishabh Agrawal To: "user@cassandra.apache.org" Subject: RE: DataModel Question Thread-Topic: DataModel Question Thread-Index: Ac4ECSwg+LuDKyd2QHepHwyoDMOidgAKBuqA Date: Wed, 6 Feb 2013 06:18:58 +0000 Message-ID: References: <57C7C3CBDCB04F45A57AEC4CB21C0CCD1DB1F7C1@mbx024-e1-nj-6.exch024.domain.local> In-Reply-To: <57C7C3CBDCB04F45A57AEC4CB21C0CCD1DB1F7C1@mbx024-e1-nj-6.exch024.domain.local> Accept-Language: en-ZA, en-IN, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.41.138] Content-Type: multipart/alternative; boundary="_000_D5515937F9B7CC409E7561CBF5124A645F0E2A47Mail3impetuscoi_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_D5515937F9B7CC409E7561CBF5124A645F0E2A47Mail3impetuscoi_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello, Composite keys are always good and model looks clean to me. Run pilot with= around 10 GB or more data and compare it with RDBMS and make changes accor= dingly. Thanks and Regards Rishabh Agrawal From: Kanwar Sangha [mailto:kanwar@mavenir.com] Sent: Wednesday, February 06, 2013 7:10 AM To: user@cassandra.apache.org Subject: DataModel Question Hi - We are designing a Cassandra based storage for the following use case= s- * Store SMS messages * Store MMS messages * Store Chat history What would be the ideal was to design the data model for this kind of appli= cation ? I am thinking on these lines .. Row-Key : Composite key [ PhoneNum : Day] * Example: 19876543456:05022013 Dynamic Column Families * Composite column key for SMS [SMS:MessageId:TimeUUID] * Composite column key for MMS [MMS:MessageId:TimeUUID] * Composite column key for user I am chatting with [UserId:19876543= 2345] - This can have multiple values since each chat conv can have many me= ssages. Should this be a super column ? 19866666666:05022013 SMS:xxxx:ttttttt SMS:xxx12:ttttttt MMS:xxxx:ttttttt XXXX:1933333333 19877777777:05022013 19878888888:05022013 Thanks, Kanwar ________________________________ NOTE: This message may contain information that is confidential, proprietar= y, privileged or otherwise protected by law. The message is intended solely= for the named addressee. If received in error, please destroy and notify t= he sender. Any use of this email is prohibited when received in error. Impe= tus does not represent, warrant and/or guarantee, that the integrity of thi= s communication has been maintained nor that the communication is free of e= rrors, virus, interception or interference. --_000_D5515937F9B7CC409E7561CBF5124A645F0E2A47Mail3impetuscoi_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

 

Composite keys are alw= ays good  and model looks clean to me. Run pilot with around 10 GB or = more data and compare it with RDBMS and make changes accordingly.

 

Thanks and Regards

Rishabh Agrawal=

 

From: Kanwar= Sangha [mailto:kanwar@mavenir.com]
Sent: Wednesday, February 06, 2013 7:10 AM
To: user@cassandra.apache.org
Subject: DataModel Question

 

Hi –  We are designi= ng a Cassandra based storage for the following use cases-

 

·      =    Store SMS messages

·      =    Store MMS messages

·      =    Store Chat history

 

What would be the ideal was to = design the data model for this kind of application ? I am thinking on these= lines ..

 

Row-Key :  Composite key [= PhoneNum : Day]

 

·      =    Example:   19876543456:= 05022013

 

Dynamic Column Families<= /p>

 

·      =    Composite column key for SMS [SMS= :MessageId:TimeUUID]

·      =    Composite column key for MMS [MMS= :MessageId:TimeUUID]

·      =    Composite column key for user I a= m chatting with [UserId:198765432345] – This can have multiple values= since each chat conv can have many messages. Should this be a super column= ?

 

 

19866666666:05022013

SMS:xxxx:ttttttt

SMS:xxx12:ttttttt

MMS:xxxx:ttttttt

XXXX:1933333333

19877777777:05022013

 

 

 

 

19878888888:05022013

 

 

 

 

 

 

Thanks,

Kanwar

 









NOTE: This message may contain information that is confidential, proprietar= y, privileged or otherwise protected by law. The message is intended solely= for the named addressee. If received in error, please destroy and notify t= he sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant = and/or guarantee, that the integrity of this communication has been maintai= ned nor that the communication is free of errors, virus, interception or in= terference.
--_000_D5515937F9B7CC409E7561CBF5124A645F0E2A47Mail3impetuscoi_--