Data warehouses of all types are simply getting pounded these days. As end users continue to discover the value of business intelligence and analytic applications, they are launching more queries than ever. Unfortunately, most data warehouses are built on top of SQL databases that were never designed to handle that kind of load.
To help alleviate that problem the folks at Jaspersoft have figured out that most of those queries are repetitive. Many end users are simply launching the same query over and over again to see if they get different results at different points in time. In recognition of that fact, Jaspersoft this week released a Jaspersoft Business Intelligence 4.7 upgrade that includes a new Jasper ReportsServer.
According to Mike Boyarski, Jaspersoft director of product marketing, the basic idea is to utilize cache memory to create a snapshot of a report that an end user can continually refresh. That capability allows the IT organizations to more easily identify “hot data” that is regularly accessed versus the majority of the data that is rarely accessed.
That’s becoming an increasingly important requirement, says Boyarski, in a Big Data era where the massive volumes of data are overwhelming the internal IT department.
Boyarski concedes that we’re still a ways away from being able to allow end users to instantly ask interactive questions based on the results of a previous query. But Jasper ReportsServer is a significant step in the right direction in terms of making it easier to manage the overall query process.
When it comes to handling queries these days, IT organizations need all the help they can get. Fortunately, the availability of more in-memory cache on servers creates a new resource for processing queries that, when used properly, will take the pressure off data warehouses that are already filled the to the data gills.