The transformative power of business analytics cannot be fully realized until IT departments provide all users with real-time access to information assets across the enterprise and enable integration of analytics directly into core operational processes. Yet current Enterprise Data Warehouse solutions are not meeting the need. "More than 70% of so-called enterprise data warehouses actually serve only back-office or limited departmental use cases," according to Gartner research(1) and, "Exploration of alternative data warehouse infrastructures increased in 2010." Driving the next wave of adoption in business analytics requires new approaches to data warehousing that overcome the user scalability, application workload and dataset limitations of the current generation of Enterprise Data Warehouse solutions.
The release of Sybase IQ 15.3 with PlexQ technology redefines enterprise-wide business analytics with a shared-everything MPP architecture that scales to support real-time access to thousands of users, multiple mixed workloads and massive datasets. With Sybase IQ PlexQ, IT departments can implement virtual data marts in order to optimize the experience for different applications and user communities. Sybase IQ PlexQ dynamically balances query workloads across nodes on the grid for massively parallel processing of complex analytics at speeds 10 to 100 times faster than traditional data warehouses. Unlike current shared-nothing MPP architectures that are optimized for certain workloads, the combination of Sybase IQ's columnar data store, shared-everything grid, and logical servers ensures top performance for any query, any workload over any dataset.
"Through our participation as a Sybase IQ 15.3 beta test site, we have experienced its disruptively fast query performance, due to the truly revolutionary new features that allow more servers to work on queries in parallel," said Scott Smith, vice president, comScore, Inc. "We at comScore have a significant investment in Sybase IQ Multiplex and are very excited about the new Sybase IQ 15.3 release. I think Sybase engineering has really 'hit the nail on the head' with the new MPP 'share everything' architecture. These features will allow us to continue down the path of inexpensive commodity servers that improve our query performance, and we even expect to see higher hardware utilization numbers."
Sybase IQ 15.3 continues to expand Sybase IQ's capacity to integrate business analytics into applications and business workflows - a growing trend among leading enterprises, by delivering APIs for both popular and emerging programming languages as well as a new Web Services interface that simplifies integration for software developers. With Sybase IQ, enterprises can run complex analytical models and algorithms within the database, eliminating the need for data mining algorithms inside business logic and accelerating overall performance of complex queries. Sybase IQ also supports the analysis of unstructured data often used in business workflows, such as proprietary document formats, emails, Web content, and now enables fast analysis of unstructured multi-media data within the database, further unifying disparate analysis and enabling customers to implement a business analytics information solution.
"Enterprise IT departments are demanding new ways to enhance their enterprise data warehouse systems to increase intelligence, productivity and analytics capability across the enterprise," said Brian Vink, Vice President, product management, Sybase, an SAP company. "Sybase IQ, with its PlexQ technology, brings customers a powerful, yet simplified, approach that overcomes traditional data warehouse limitations. IT departments can now support users across the enterprise with many concurrent workloads and large datasets on a single, highly scalable elastic grid, significantly increasing analytics intelligence across the enterprise while reducing IT administration burden."
Sybase IQ 15.3 key new features include:
Sybase IQ 15.3 is generally available. To learn more about Sybase IQ and the additional features and benefits of version 15.3, visit: www.sybase.com/iq.