Earlier this week we began our enterprise cloud series and gave you three telltale signs to help determine whether or not a software solution is truly made for a cloud environment. Today, we go inside the advanced architecture behind Adaptive’s enterprise cloud platform and discuss the “in-memory” technology inside Adaptive’s Planning, Consolidation and Discovery Solutions.
In-memory databases are all the craze these days. All the cool kids are talking about it…or cool companies at least. So what is it exactly?
“In-memory” refers to a database management system that relies on main memory, which is the storage system that has direct access to a CPU. Still with me? Good.
So in-memory databases are faster than disk storage databases because, with direct access to the main memory, such a system completely eliminates “seek time” when searching for data. The result is much faster, more predictable performance; something particularly useful when gathering data analytics.
Adaptive delivers in-memory capabilities as part of our entire CPM software application suite. It’s one of the main reasons why we’re able to deliver such great data, user, and application scalability.
Keep in mind that, when it comes to in-memory technology, one size doesn’t fit all. For maximum effectiveness, these databases have to be designed according to specific application requirements.
In-memory for Adaptive Planning and Adaptive Consolidation
Adaptive Planning and Adaptive Consolidation use in-memory technology for business rule
centric modeling and to manage changing versions and scenarios. This allows users to calculate traditionally complex “what-if” comparisons of changing scenarios, completely on-the-fly.
Adaptive Planning’s and Adaptive Consolidation’s in-memory stores contain everything about financial models, including accounts, levels, dimensions, and organizational levels. Then there are separate in-memory storage versions for data and formulas. As planning versions increase, Adaptive automatically provisions new in-memory version stores in order to deliver greater performance to handle the increased complexity.
In-Memory for Adaptive Discovery
The in-memory technology within Adaptive Discovery, our visual analytics solution, operates a bit differently. In Discovery, in-memory is designed to handle rapid query time aggregation of very large data volumes. It also uses a columnar data arrangement, enabling sub-second response when rolling up millions of rows of data.
For example, if you search for “Revenue by 2013,” or “Sales for North America,” Adaptive Discovery’s in-memory database will pull these analytics almost instantaneously, while simultaneously supporting thousands of users.
Now THAT is truly advanced technology, delivered as cloud service for optimal data, user, and application scalability. And that’s just the tip of the iceberg. Next week, our enterprise cloud series covers the elasticity of the Adaptive cloud.