The current landscape at enterprises is that they have adopted a number of data management technologies, both a combination of traditional SQL ones and new ones such as NoSQL, NewSQL, in-memory analytics and so on. This trend is resulting in what has been so-called Polyglot Persistence, that is, having data stored on different kinds of databases. The adoption of new technologies such as NoSQL has enabled to solve issues such as having more suitable data models and associated query languages/APIs for dealing with some data management problems. Examples of this are key-value data stores, document-oriented data stores and graph databases.
However, the Polyglot Persistence has raised new challenges and created new difficulties. Two main pains in Polyglot Persistence environments are related to the updates and queries across data stores. The first pain is related to the consistency of updates. Most NoSQL data stores are non-transactional what is an actual pain by itself since consistency is not guarantee for business operations that require to modify multiple rows. The problem is worsened in the polyglot persistence scenario, since now a business operation might require to modify multiple data stores and a failure or concurrent access might result in getting an inconsistent polyglot database due to the lack of transactional consistency guarantees. There are also pains with the queries. This pain lies in that different databases speak different query languages or APIs and when a query across data stores is needed this is simply not supported because maybe a database speaks SQL and another a proprietary API, as it happens with MongoDB.
CoherentPaaS addresses the aforementioned pains of Polyglot Persistence environments. It leverages a novel technology able to scale out transactional processing. This technology is being integrated with different data stores such as SQL, NoSQL, in-memory analytics, etc. This results in individual data stores with full ACID properties such as a full ACID MongoDB. But more interestingly, since all these data stores get integrated with the same scalable transactional engine, CoherentPaaS supports queries across data stores. The approach adopted by CoherentPaaS is quite novel. It enables to combine the native query languages of the underlying data stores with SQL.
CoherentPaaS combines in an integrated platform SQL (OLTP, in-memory analytics, OLAP), NoSQL (key-value, document-oriented and graph databases) and CEP/data streaming. In this platform applications can start global transactions and update any combination of data stores with full transactional semantics. Applications can also make queries across data stores combining the simplicity of SQL with the power of the underlying native query languages.
More details can be found at the original web site: http://coherentpaas.eu/