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 <dalia.mohso...@hotmail.com> Date: Wed, 25 Jan 2012 17:01:08 To: <u...@hbase.apache.org>; <user@hive.apache.org> Reply-To: user@hive.apache.org 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 ;)