Caché vs Oracle vs RDBMS - Please add your 2 cents!
770225Apr 15 2011 — edited Apr 20 2011Hi All,
I have recently “discovered” the Caché DBMS and realised just how little information there is out there. Apart from a few forums and a few vendor websites (mostly InterSystems) I haven’t been able to find much documentation or FAQ’s or user guides/manuals about the MUMPS (and Caché) database. HOWEVER(!) I have found two articles (funnily enough published by the Caché vendor InterSystems) about how much faster Caché is compared to Oracle. So the reason I’m posting here to (hopefully) start a discussion and get some input from Oracle users out there who have user Caché.
There are many claims by Caché users about how ultra-fast it is, how easy it to write application code (since the DBMS is object oriented), how the databases run with next to no intervention by DBA's, etc, etc. So if, as they claim, it's such a fantastic product how come 99% of the time I draw a blank when I ask other people in the field about Caché? Absolutely no one in my organisation knows how to use the Caché DB that we use. The end users access the Application...and that's it! And if the Caché technology is genuinely fast and efficient shouldn't the big 3 (Oracle, MS, IBM) include Caché like technology in their products or at least introduce competing?
Don't get me wrong. This is not an attempt to say one DBMS is better than the other. I just want to see how many have heard of/used Caché and what the general consensus is about Caché. And what do you think about OO-DBMS, is it the future? There's a link below that says how OO-DBMS' are the best options for large-scare Internet systems (citing Google's BigTable and Amazon's SimpleDB), do you agree?
Some links:
http://www.computerworld.com/s/article/101591/Looking_Beyond_the_Big_Three
http://labsoftnews.typepad.com/lab_soft_news/2010/05/persistence-of-the-mumps-programming-language-in-healthcare.html
http://labsoftnews.typepad.com/lab_soft_news/2010/10/more-on-mumps.html
http://www.faqs.org/faqs/m-technology-faq/part1/
http://www.cs.uni.edu/~okane/source/ISR/isr.html#ex01
http://www.cachewiki.org/index.php/About
http://bytes.com/topic/oracle/answers/65655-comments-intersystems-cache-database-platform
http://dbaspot.com/forums/object-database-technologies/196842-help-problems-intersystems-cache.html
http://www.intersystems.com/cache/whitepapers/pdf/BestKeptSecret.pdf
http://www.outoftheslipstream.com/node/124
http://www.dbms2.com/2010/01/15/intersystems-cache-highlights/#more-1400
Edited by: feersum_endjinn on 15-Apr-2011 07:28
Edited by: feersum_endjinn on 15-Apr-2011 07:31