Business Analytics Software supports parallel distributed query.

Press Release Summary:



Powered by shared-everything Massively Parallel Processing architecture, Sybase® IQ 15.3 with PlexQ technology scales to support real-time access to thousands of users, multiple mixed workloads, and massive datasets. Use of columnar data store, shared-everything grid, and logical servers ensures top performance for any query or workload over any dataset. Enterprises can run complex analytical models and algorithms within database, eliminating need for data mining algorithms inside business logic.



Original Press Release:



Sybase Brings 'Intelligence for Everyone' to the Enterprise with New Parallel Distributed Query and Advanced Workload Management Capabilities



Sybase IQ 15.3 Beta Customers See up to 12 Times Performance Improvement with Distributed Query Processing

DUBLIN, Calif., -- Sybase, Inc., an SAP® company (NYSE: SAP) and industry leader in enterprise and mobile software, today announced the general availability of Sybase® IQ 15.3, powered by a new generation of shared everything Massively Parallel Processing (MPP) technology. With this release, enterprise IT departments can overcome scalability limitations of today's data warehouses in many industries including financial services, telecommunications, information providers, healthcare and insurance. By implementing a business analytics information solution that allows sharing of computing and data resources with the innovative Sybase IQ PlexQ(TM) technology, enterprises can lead the next wave of data warehouse transformation by breaking down user and information silos to drive analytics adoption throughout the entire organization.

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 PlexQ - A grid based MPP framework that unleashes the power of multiple CPU cores across many servers on large data sets to provide fast answers across a wide spectrum of complex queries

-- Distributed Query Processing - Execute individual queries across many machines in a PlexQ grid for MPP, yet automatically balance workloads across the grid during peak periods

-- Logical Servers - Group physical servers in a PlexQ grid into virtual clusters in order to optimize analytic workloads, user needs and applications

-- Built-in Web Services API and Ruby-on-Rails language driver - Simplify integration with workflow processes and web-based applications to publish and consume web services that take advantage of a new generation of analytical applications

-- Multimedia API - Integratelibraries for in-database analysis of images, audio, video and other multimedia content that increase the value of business analytics for unstructured as well as structured information

-- InfoPrimer Module - Dramatically simplify and accelerate loading of data into Sybase IQ through Extract, Load, and Transform methodology, allowing data transformations to take place where they make the most sense to the customer

-- Rich, web-based administration and monitoring interface - Leverage Sybase Control Center to greatly simplify operational tasks for DBAs and provides a thin client interface for ease of Sybase IQ administration

Sybase IQ 15.3 Availability

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. Read the Sybase IQ blog: blogs.sybase.com/sybaseiq. See the video "CoreLogic Speaks out on Sybase IQ 15.3 and Superior Query Performance"

About Sybase IQ

Sybase IQ combines extraordinary speed and agility with low total cost of ownership, enabling enterprises to perform the critical business analysis and reporting that was previously impossible, impractical or cost-prohibitive. More than 2,000 customers worldwide have adopted Sybase IQ's innovative, column-based processing approach to power their critical analytical and reporting systems. Sybase IQ solutions empower businesses to more accurately predict outcomes, gain real-time insights into business operations, and actively mitigate risks in today's competitive global climate. To learn more: www.sybase.com/iq or click here to view our Webcast. Read the Sybase Analytics blog: blogs.sybase.com/analytics.

About Sybase

Sybase, an SAP® company, is an industry leader in delivering enterprise and mobile software to manage, analyze and mobilize information. We are recognized globally as a performance leader, proven in the most data-intensive industries and across all major systems, networks and devices. Our information management, analytics and enterprise mobility solutions have powered the world's most mission-critical systems in financial services, telecommunications, manufacturing and government. For more information: www.sybase.com. Read Sybase blogs: blogs.sybase.com.Follow us on Twitter at @Sybase.

(1) "Data Warehousing Trends for the CIO, 2011-2012" Mark A. Beyer, Donald Feinberg, Roxane Edjlali; Gartner (January 2011)

Sybase, Sybase IQ, and PlexQ are registered trademarks of Sybase, Inc. ® indicates registration in the United States. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are the trademarks of their respective companies.

CONTACT: Jeff Neal of Sybase Public Relations, +1-925-236-5035, jeff.neal@sybase.com

Web Site: www.sybase.com

All Topics