Dalia your requirements appear to be transaction oriented and thus OLTP systems - i.e. regular relational databases - are more likely to be suitable than a hive (/hadoop) based solution. Hive is more for business intelligence and certainly includes latencies - which by saying 'realtime' - would likely not be acceptable for your application.
stephenb 2012/1/25 Dalia Sobhy <dalia.mohso...@hotmail.com> > I will explain to u more Mike. > > I am building a Software Oriented Architecture, I want my API to provide > some services such as Add/Delete Patients, Search for a patient 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: u...@hbase.apache.org; user@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 mean you want to run some > > non-trivial query quickly enough for some sort of interactive use? Can > > you give us a feel for the sort of queries that interest you? > > > > Thanks, > > Mike > > > > > > > > From: Dalia Sobhy <dalia.mohsobhy@hotm ail.com> > > To: "u...@hbase.apache.org" <u...@hbase.apache.org> > > Cc: "user@hive.apache.org" <user@hive.apache.org>, > > "u...@hbase.apache.org" <u...@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 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.. 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 ;) > > > > > ** >