Within the zEnterprise announcement in July 2010 there were several exciting comments about the new query performance within the IBM Smart Analytics Optimizer. This smart system leverages the integrated platform, providing industry leading scalability for data warehouse and business intelligence capabilities.
Queries that scanned entire terabytes of data that were previously avoided can now be executed in seconds through the IBM Smart Analytics Optimizer processing. This capability provides data mining features for quickly getting answers to the clustering, associations, classification and predictions within your data warehousing environment.
Within some of the documentation, IBM testing of the Smart Analytics Optimizer shows huge performance boosts. Queries that scanned and then subsequently optimized sometimes showed an improvement of 54 times, the cost of the query 711 times. This type of improvement is very exciting and especially what new data warehousing and business intelligence workloads need on the zEnterprise platform.
Check out all the zEnterprise documentation—especially the information on the IBM Smart Analytics Optimizer. This was just the beginning of a resurgence of the new mainframe that supports any mainframe, UNIX or windows workload. Known as a company’s “private cloud,” it allows IT departments to leverage tremendous performance improvements while reducing query cost substantially.