There are many advantages that in-memory database reporting has over relying on disk memory.
With disk memory, slow query responses often place a burden on the IT department to increase performance speed. If IT fails to provide this improvement, users will often change their approach and stop asking complicated questions of their data. This is one of the reasons why BI is all too often left to the experts; regular users don't have time to spend hours answering business questions.
When data is stored in RAM, queries can be answered at a much faster rate. The speed-of-thought response time on complex queries encourage users to ask more questions and create more ad-hoc reports.
In-memory architecture is constructed by extracting a large amount of data from a data warehouse or other data source and loading that data into memory. The user only interacts with cached data, not the actual data source.
The disadvantage of working in-memory is that you are limited in how much cached data you can store. And having only one kind or a certain amount of data available in RAM can limit the flexibility necessary to make ad hoc reports.
So using a purely in-memory BI solution means your reporting and analytics capabilities are limited by the size of memory in the BI server.
InetSoft's unique combination of these two options provides the speed of in-memory database reporting, while still allowing an unlimited size and volume of data sources to be used. Timeliness of data required, as well as system capabilities and performance requirements all vary, and InetSoft's solution is agile enough to meet a large variety of different demands.
While the software can access data in real time from a variety of sources, it also features a cutting edge data grid cache. This feature automatically uploads and stores whatever data is needed for reporting, including any data that may be needed for applying drilldown, filters, and any other interactive features. The data grid cache loads compressed indexes in a Hadoop like architecture, storing data in a columnar format. If enough system memory is available, the entire measure column will be loaded, but this is not necessary. This flexibility enables interactive features to be utilized with much greater speed.
InetSoft's data grid caching solution suffers from no limits on data volume or size, and can scale up as performance, usage concurrency, and database size grow.
Since 1996 InetSoft has been delivering easy, agile, and robust business intelligence software that makes it possible for organizations and solution providers of all sizes to deploy or embed full-featured business intelligence solutions.
Application highlights include visually-compelling and interactive dashboards that ensure greater end-user adoption plus pixel-perfect report generation, scheduling, and bursting.
InetSoft's patent pending Data Block™ technology enables productive reuse of queries and a unique capability for end-user defined data mashup.
This capability combined with efficient information access enabled by InetSoft's visual analysis technologies allows maximum self-service that benefits the average business user, the IT administrator, and the developer.
InetSoft solutions have been deployed at over 5,000 organizations worldwide, including 25% of Fortune 500 companies, spanning all types of industries.
InetSoft Technology Corp.
InetSoft Technology Corp.