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 huge amount of historical data which is not dependent on the data that is required in realtime. It would be very helpful if you could elaborate a typical analytics use case and a typical realtime use case that you want to be handled.
- Rohit Kelkar On Thu, Jan 26, 2012 at 3:43 PM, Dalia Sobhy <[email protected]> wrote: > 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" <[email protected]> wrote: > >> >> 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" <[email protected]> wrote: >> >>> 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, [email protected] wrote: >>> >>>> 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 like queries. >>>> >>>> >>>> >>>> Regards >>>> Bejoy K S >>>> >>>> -----Original Message----- >>>> From: Dalia Sobhy <[email protected]> >>>> Date: Wed, 25 Jan 2012 17:01:08 >>>> To: <[email protected]>; <[email protected]> >>>> Reply-To: [email protected] >>>> Subject: Important Question >>>> >>>> >>>> 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 suits my application Hbase or Hive or another >>>> method ?? >>>> Please reply quickly bec this is critical thxxx a million ;) >>>> >>> >> >>
