Sybase IQ 15.1 – More than meets the eye…
Sybase announced Sybase IQ version 15.1 this week with some powerful new capabilities. Most noteworthy are 2 new in-database analytics capabilities, both game-changers if your needs include fast, easy, low-latency statistical analysis or predictive modeling. Also announced are new tools to speed reporting and simplify information lifecycle management.
Sybase IQ 15.1 speeds statistical analytics, at game-changing latency levels, by running complex analytic queries and statistical functions directly within Sybase IQ. In contrast to other approaches, Sybase IQ 15.1 does NOT require data to be moved outside the database into multi-dimensional structures and pre-aggregations in order to run HOLAP/MOLAP analyses.
In-database analytics contrasts with traditional approaches by slashing latency previously expended to move data from the database into multidimensional structures for analytic operations. Think of it as “cube performance without the cube engine”.
It gets better. Sybase IQ 15.1 also contains APIs through which Sybase will facilitate addition of plug-in routines for yet more in-database operations. The first partner to exploit the capability is Fuzzy Logix, LLC, who have certified plug-in analytic and modeling functions including monte carlo simulation, clustering analysis, neural networks and regressions. These facilities can now run directly inside Sybase IQ 15.1 engine, with direct access to data. This avoids expensive movement or denormalization of the data. These in-database capabilities promise to be “game changing” for real-time advanced analytics.
I can hear the question bubbling already. “We run these types of analytics now, so what’s new?” If this is your situation, ask your admin team how long it takes, after data is loaded into the database, for that data to be re-loaded into aggregate structures, either in the database or beneath the analytics tool they’re using. Ask them how much time they spend adapting cubes to fit the latest queries (or vice versa) and how often ad-hoc queries that fall beyond that data in the cube are drilling back into the RDBMS, killing performance for all users.
If you’re running complex analytics today, and need to cut latency or complexity, then you’re a candidate for leveraging the speed of in-database analytics.
But wait, there’s more!
Beyond in-database analytics, we’ll soon make complex VLDB management easier, with a new release Sybase PowerDesigner and it’s plug-in version for Sybase WorkSpace. These new VLDB capabilities arrive as part of new information lifecycle models in PowerDesigner version 15.1. They rely on object placement and table partitioning capabilities that are new with Sybase IQ 15, and makes those two powerful features GUI-based.
With these new capabilities in PowerDesigner, it’s easy to segregate new or frequently-used data onto your fast storage devices, and migrate aging or infrequently-used data onto lower-cost storage. This slashes the cost of storage by allowing you to concentrate your storage expenditures where it does the most good, and simplifies back-up processes to boot.
You will also find that Sybase’s eclipse-based tool framework, Sybase WorkSpace Data Analytics IDE, has been enhanced to include a very capable reporting services application called BIRT, from Actuate Corporation. BIRT is one of the best-known open-source business intelligence toolsets in market today, and its inclusion allows you to do more with less – less time and expense creating user visualization during the application development process.
And so, with two powerful new versions of Sybase IQ already released this year, plus new PowerDesigner and WorkSpace Data Analytics IDE capabilities, we’re hoping to make you the hero – the person who delivers real-time analytics and predictive modeling below budget, without working weekends, and perhaps one of the few people who have budget money left at the end of the year for a few well-earned bonuses for your team.