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 8089D9C03 for ; Mon, 30 Jan 2012 03:41:45 +0000 (UTC) Received: (qmail 14912 invoked by uid 500); 30 Jan 2012 03:41:42 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 14584 invoked by uid 500); 30 Jan 2012 03:41:36 -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 14576 invoked by uid 99); 30 Jan 2012 03:41:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jan 2012 03:41:31 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of kk.ub@hotmail.com designates 65.55.34.141 as permitted sender) Received: from [65.55.34.141] (HELO col0-omc3-s3.col0.hotmail.com) (65.55.34.141) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jan 2012 03:41:20 +0000 Received: from COL110-W32 ([65.55.34.137]) by col0-omc3-s3.col0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Sun, 29 Jan 2012 19:40:58 -0800 Message-ID: X-Originating-IP: [202.221.224.50] From: Krassimir Kostov To: Cassandra Apache Subject: RE: SQL DB Integration Date: Mon, 30 Jan 2012 12:40:59 +0900 Importance: Normal In-Reply-To: <2C85E14562B39345BCCAD90B8E7955C9084F8B@DKEXC001.adform.com> References: ,<2C85E14562B39345BCCAD90B8E7955C9084F8B@DKEXC001.adform.com> Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginalArrivalTime: 30 Jan 2012 03:40:58.0921 (UTC) FILETIME=[FAE50990:01CCDF00] X-Virus-Checked: Checked by ClamAV on apache.org Hi Viktor=2C =20 Thanks for the comments. True=2C the characteristics that I outlined were = general=2C just to give a background/context to the problem I=92m trying to= solve. Will address more specific questions when it comes to designing an= d implementing the data storage solution and the API to do the integration = of (1) =96 (3) above. =20 Given that our data mining application (IBM SPSS Modeler)=2C our partner pl= atform (Oracle DB data model)=2C used for additional services and our clien= ts=92 DBs are all based on SQL=2C from your experience: =20 (1) Is it a good idea to use Cassandra as a storage solution for SQL data= =2C converted to the NoSQL data model just to be stored on Cassandra? (2) Do you know of any similar cases of using Cassandra as a storage=2C sup= porting SQL data applications=2C or perhaps data model architecture differe= nces and high development costs make no sense for this? (3) If using Cassandra as a storage=2C supporting SQL data applications is = not a good idea=2C do you recommend an alternative SQL cloud DB solution th= at has good scalability?=20 =20 Thanks and regards=2C =20 Krassimir Kostov =