Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 36335 invoked from network); 22 Jun 2010 19:44:30 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 22 Jun 2010 19:44:30 -0000 Received: (qmail 31704 invoked by uid 500); 22 Jun 2010 19:44:29 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 31608 invoked by uid 500); 22 Jun 2010 19:44:28 -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 31600 invoked by uid 99); 22 Jun 2010 19:44:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jun 2010 19:44:28 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of craig.faulkner@wallst.com designates 209.234.229.50 as permitted sender) Received: from [209.234.229.50] (HELO mail-gw.wallst.com) (209.234.229.50) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Jun 2010 19:44:22 +0000 Received: from IS-EXCHANGEC101.wsod.local ([10.2.10.38]) by IS-EXCHANGEC101.wsod.local ([10.2.10.38]) with mapi; Tue, 22 Jun 2010 15:44:01 -0400 From: Craig Faulkner To: "user@cassandra.apache.org" Date: Tue, 22 Jun 2010 15:43:59 -0400 Subject: SQL Server to Cassandra Schema Design - Ideas Anyone? Thread-Topic: SQL Server to Cassandra Schema Design - Ideas Anyone? Thread-Index: AcsSPfIqbbMw6FG0S+2z6JR2XJ+0SwABAhpQ Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org I'm having a little block in converting an existing SQL Server schema that = we have into Cassandra Keyspace(s). The whole key-value thing has just not= clicked yet. Do any of you know of any good examples that are more comple= x than the example in the readme file? We are looking to report on web traffic so things like hits, page views, un= ique visitors,... All the basic web stuff. I'm very sure that one of you,= likely many more, is already doing this. Here are two queries just to give you a few key works related to the metric= s that we want to move into Cassandra: /* Data logged */ select t.Datetime,c.CustomerNumber,ct.cust_type,ws.SiteNumber,ws.SiteName ,f.Session,wa.page,wa.Note,f.CPUTime,f.DCLWaitTime,f.DCLRequestCount,'clien= tip' =3D dbo.u_IpInt2Str(ClientIP) from warehouse.dbo.fact_WebHit f join Warehouse.dbo.dim_Time t on t.ID =3D f.TimeID join Warehouse.dbo.dim_CustomerType ct on ct.ID =3D f.CustomerTypeID join Warehouse.dbo.dim_Customer c on c.ID =3D f.CustomerID join Warehouse.dbo.dim_Symbol s on s.ID =3D f.SymbolID join Warehouse.dbo.dim_WebAction wa on wa.ID =3D f.WebActionID join Warehouse.dbo.dim_WebSite ws on ws.ID =3D f.WebSiteID /* Data with surrogate keys */ select f.Timeid,f.CustomerID,f.CustomerTypeID,f.WebSiteID ,f.Session,f.WebA= ctionID,f.CPUTime ,f.DCLWaitTime,f.DCLRequestCount,ClientIP from warehouse.dbo.fact_WebHit f Any good info would be appreciated. I have of course checked the main web = sites but I could have missed something along the way. Craig