Re: Important Question

2012-01-26 Thread Rohit Kelkar
Dalia, You mentioned realtime, which of your use cases are realtime and whats an acceptable response time for it? You may want to try a combination of sql and nosql. Nosql to store your data for analytics purposes and the sql for realtime. I am assuming that your analytics needs would be based on h

Re: Important Question

2012-01-26 Thread Dalia Sobhy
Hii Doug, How can i talk to you for the Explorsys may be it suits my application ?? Contact me asap.. Sent from my iPhone On 2012-01-25, at 6:45 PM, "Doug Meil" wrote: > > Because you specifically cited the medical domain in your question, I > think you might want talk to Explorys (disclaime

RE: Important Question

2012-01-26 Thread Dalia Sobhy
what about Pig?? Please check this and tell me ur opinions.. http://hstreaming.com/docs/developer-guide/pig/ > To: dalia.mohso...@hotmail.com > CC: user@hbase.apache.org > Subject: RE: Important Question > From: mspre...@us.ibm.com > Date: Wed, 25 Jan 2012 16:28:42 -0500 >

RE: Important Question

2012-01-25 Thread Dalia Sobhy
Yes that's right!! > To: dalia.mohso...@hotmail.com > CC: user@hbase.apache.org > Subject: RE: Important Question > From: mspre...@us.ibm.com > Date: Wed, 25 Jan 2012 16:04:57 -0500 > > Just a couple more questions. Your data will all be in one place, this is >

RE: Important Question

2012-01-25 Thread Dalia Sobhy
for your sincere help :) > From: doug.m...@explorysmedical.com > To: user@hbase.apache.org > Subject: Re: Important Question > Date: Wed, 25 Jan 2012 21:23:13 + > > > Hi there- > > As someone who works with medical data I take such analysis very > seriously, but

RE: Important Question

2012-01-25 Thread Mike Spreitzer
A bit more grist for our mill: what transaction rate do you need to support? Are you concerned with a lookup or aggregation query "correctly" including a record that is being concurrently updated? Thanks, Mike

Re: Important Question

2012-01-25 Thread Doug Meil
by >name/ID, count the number of people who are suffering from measles in >Alexandria Egypt. >Something like that so I am wondering which best suits my API ?? > >> To: dalia.mohso...@hotmail.com >> CC: user@hbase.apache.org; u...@hive.apache.org >> Subject: Re: Impor

Re: Important Question

2012-01-25 Thread Ulrich Staudinger
Hey everybody, with the risk of being flamed and bbqued... to be absolutely honest, I think the NoSQL approach and with it HBase and all other alternatives don't fit your use case at all. You have a complex domain model, where it is very likely that you will want to search through your domain spac

RE: Important Question

2012-01-25 Thread Mike Spreitzer
Just a couple more questions. Your data will all be in one place, this is not a federated architecture, right? How much data are we talking about? It sounds like you want to find/create/update/delete individual records and do simple aggregations over records identified by a conjunction of pre

RE: Important Question

2012-01-25 Thread Dalia Sobhy
wondering which best suits my API ?? > To: dalia.mohso...@hotmail.com > CC: user@hbase.apache.org; u...@hive.apache.org > Subject: Re: Important Question > From: mspre...@us.ibm.com > Date: Wed, 25 Jan 2012 12:05:39 -0500 > > BTW, what do you mean by "realtime"? Do you m

Re: Important Question

2012-01-25 Thread Mike Spreitzer
rg" Cc: "u...@hive.apache.org" , "user@hbase.apache.org" Date: 01/25/2012 11:34 AM Subject:Re: Important Question So what about HBQL?? And if i had complex queries would i get stuck with HBase? Also can anyone provide me with examples of a table in RDBMS tra

Re: Important Question

2012-01-25 Thread Doug Meil
Because you specifically cited the medical domain in your question, I think you might want talk to Explorys (disclaimer: I work there). Otherwise, you probably want to look at the HBase book. On 1/25/12 11:30 AM, "Dalia Sobhy" wrote: >So what about HBQL?? >And if i had complex queries would

Re: Important Question

2012-01-25 Thread Ioan Eugen Stan
Pe 25.01.2012 18:30, Dalia Sobhy a scris: So what about HBQL?? And if i had complex queries would i get stuck with HBase? Hbql seems to be unmaintained. Last update seems to be in jan 2011, one year ago. Also can anyone provide me with examples of a table in RDBMS transformed into hbase,

Re: Important Question

2012-01-25 Thread Dalia Sobhy
So what about HBQL?? And if i had complex queries would i get stuck with HBase? Also can anyone provide me with examples of a table in RDBMS transformed into hbase, realtime query and analytical processing.. Sent from my iPhone On 2012-01-25, at 6:15 PM, bejoy...@yahoo.com wrote: > Real Time..

Re: Important Question

2012-01-25 Thread bejoy_ks
Real Time.. Definitely not hive. Go in for HBase, but don't expect Hbase to be as flexible as RDBMS. You need to choose your Row Key and Column Families wisely as per your requirements. For data mining and analytics you can mount Hive table over corresponding Hbase table and play on with SQL li

Re: Important Question

2012-01-25 Thread Ioan Eugen Stan
Pe 25.01.2012 17:01, Dalia Sobhy a scris: Dear all, I am developing an API for medical use i.e Hospital admissions and all about patients, thus transactions and queries and realtime data is important here... Therefore both real-time and analytical processing is a must.. Therefore which best sui