*Database(SQL, NoSQL, Graph, Document etc etc)* 1. Used for Online Transactional Processing (OLTP) but can be used for other purposes such as Data Warehousing. This records the data from the user for history. 2. The tables and joins are complex since they are normalized (for RDMS). This is done to reduce redundant data and to save storage space. 3. Entity – Relational modeling techniques are used for RDMS database design. 4. Optimized for write operation. 5. Performance is low for analysis queries.
*Warehouse* 1. Used for Online Analytical Processing (OLAP). This reads the historical data for the Users for business decisions. 2. The Tables and joins are simple since they are de-normalized. This is done to reduce the response time for analytical queries. 3. Data – Modeling techniques are used for the Data Warehouse design. 4. Optimized for read operations. 5. High performance for analytical queries. 6. Is *usually* a Database. HTH Warm Regards, Tariq https://mtariq.jux.com/ cloudfront.blogspot.com On Sun, Apr 28, 2013 at 10:30 PM, shashwat shriparv < dwivedishash...@gmail.com> wrote: > HBase is a nosql database > > *Thanks & Regards * > > ∞ > Shashwat Shriparv > > > > On Sun, Apr 28, 2013 at 4:42 PM, Em <mailformailingli...@yahoo.de> wrote: > > > I suggest you to read Google's BigTable-paper to understand the > > differences. > > > > Am 28.04.2013 05:12, schrieb Kiran: > > > What is the difference between a NoSQL database like HBase and a data > > > warehouse? Doesn’t both store data from disparate sources and formats? > > > > > > > > > > > > -- > > > View this message in context: > > > http://apache-hbase.679495.n3.nabble.com/HBase-and-Datawarehouse-tp4043172.html > > > Sent from the HBase User mailing list archive at Nabble.com. > > > > > >