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 ;) >> >
