Planet NoSQL

The feature demands for NoSQL databases are increasing, many of it to catch up or merge the ones already in RDBMS. Here's the holiday wish list for a NoSQL Nirvana database. NoSQL Nirvana = SQL API+             NoSQL API +             Graph Database              Flexible Schema +             Spatial +             Timeseries +             Text Indexing +             Hybrid Access +             Distributed Joins (and optimizer) +        ACID Transaction +        BASE support+        Scale UP (SMP) +        Scale out (web-scale, MPP) +        High Availability & Seamless Failover +       ...

On December 17th, John Miller talked about Informix NoSQL hybrid storage. The presentation and audio will soon be posted at: http://ibm.co/JFkr1B In Q&A, there was a question and comment by Lyn Robison from Gartner on advising customers to use the right data model for the right problem/application. We completely agree. We'd like customers to use the right model for the right problem. With informix not only you can use either standard relational model or flexible schema with JSON for your appdev. Obviously, this can create data silos if your API is tied to specific data model. We believe data model should not restrict data access. Hence the hybrid access. So, how does this hybrid access work in Informix NoSQL? Informix provides both SQL and NoSQL semantics. You can define regular relational schema or simply use MongoAPI and Informix creates the database, collections and documents just like MongoDB does. Let’s look at the implementation details. Some of these are already ...