After winning a CSC Leading Edge Forum (LEF) research grant, I (Paul Colmer) wanted to publish some of the highlights of my research to share with the wider technology community.
What is an In Memory Data Grid?
It is not an in-memory relational database, a NOSQL database or a relational database. It is a different breed of software datastore.
In summary an IMDG is an ‘off the shelf’ software product that exhibits the following characteristics:
The data model is distributed across many servers in a single location or across multiple locations. This distribution is known as a data fabric. This distributed model is known as a ‘shared nothing’ architecture.
There are also hardware appliances that exhibit all these characteristics. I use the term in-memory data grid appliance to describe this group of products and these were excluded from my research.
There are six products in the market that I would consider for a proof of concept, or as a starting point for a product selection and evaluation:
And here are the rest of products available in the market now, that I consider IMDGs:
Relative newcomers to this space, and worthy of watching closely are Microsoft and Tibco.
Why would I want an In Memory Data Grid?
Let’s compare this with our old friend the traditional relational database:
How does an In Memory Data Grid map to real business benefits?
How do use an In Memory Data Grid?
With a partitioned and replicated cache, you simply partition the cache on the servers that best suits the business needs to trying to fulfil, and the replicated part ensures there are sufficient copies across all the servers. This means that if a server dies, there is no effect on the business service. Providing you have provisioned enough capacity of course.
The key here is to design a topology that mitigates all business risk, so that if a server or a site is inoperable, the service keeps running seamlessly in the background.
There are also some tough decisions you may need to make regarding data consistency vs performance. You can trade the performance to improve data consistency and vice versa.
Are there any proven use cases for In Memory Data Grid adoption?
Oh yes, and if you’re a competitor in these markets, you may want to rethink your solution.
Financial Services: Improve decision-making, profitability and market competitiveness through increased performance in financial stock-trading markets. Reduction in processing times from 60 minutes to 60 seconds.
Online Retailer: Providing a highly available, easily maintainable and scalable solution for 3+ million visitors per month in the online card retailer market.
Aviation: Three-site active / active / active flight booking system for a major European budget-airline carrier. Three sites are London, Dublin and Frankfurt.
Check out the VMware Gemfire and Alachisoft NCache websites for more details on these proven use cases.
About the Author:
Paul Colmer is a technology consultant working for CSC and director and active professional musician for Music4Film.net. He specialises in Cloud Computing, Social Business and Solution Architecture. He is based in Brisbane, Australia. http://www.linkedin.com/pub/paul-colmer/6/894/539