Sybase Does More Big Data Analytics With Native MapReduce and Hadoop Integration

New Version of Sybase IQ, Industry-Leading MPP Column-Based Database Unlocks Value of Big Data with new Advanced Analytics Techniques that Run In-Database

Nov 01, 2011, 09:00 ET from Sybase, Inc.

DUBLIN, Calif., Nov. 1, 2011 /PRNewswire/ -- Sybase, Inc., an SAP® company (NYSE: SAP) and industry leader in enterprise and mobile software, today launched the new version of the Sybase® IQ high performance column-based analytics database. The new features of Sybase IQ 15.4 provide advanced techniques to address the new generation of Big Data and unlock critical business insights.


"The core applications for Big Data are in extremely scalable analytics, where the extremes involve processing a heavy volume, high velocity, staggering variety, and unpredictable variability of data types," according to the October 2011 Forrester Research, Inc. report Enterprise Hadoop: The Emerging Core Of Big Data. "This growing tsunami of intelligence feeds downstream business processes in both the front and back office, helping organizations optimize their interactions and operations through powerful analytics."

Today's growing demand for analytics to spot trends, correlate cause and effect, identify patterns, or ask "what if?" questions necessitates new analytics techniques, such as the use of advanced tools and the execution of analytical algorithms close to the data stored in the database. The new release of Sybase IQ expands support for in-database analytics, including a native MapReduce API, Predictive Model Markup Language (PMML) support, integration with Hadoop, and an expanded library of statistical and data mining algorithms that leverage the power of Sybase IQ PlexQ® massively parallel processing (MPP) technology. New APIs enable developers to quickly and safely implement in-database algorithms achieving greater than 10x performance acceleration over existing approaches.

"Sybase IQ delivers the breadth of tools like native MapReduce and advanced Hadoop integration that data scientists need to analyze unstructured and structured data together to discover and predict deeper, more accurate insight into business performance and market dynamics," said Brian Vink, vice president, database products, Sybase, an SAP company. "The latest release of Sybase IQ combines this breadth of tools with the ability for enterprises and application vendors to design high performance data analysis techniques to fully unlock the true potential of Big Data analytics."

"Sybase IQ 15.4 provides Fuzzy Logix with an opportunity to further innovate on our certified flagship offering for Sybase IQ – DB Lytix - a quantitative library for high performance in-database analytics," said Jim Zhang, vice president of Analytics, Fuzzy Logix. "By taking advantage of Sybase IQ 15.4's highly versatile and parallel native MapReduce API, we can quickly integrate new data mining algorithms and boost the performance of many existing functions. This new version of DBLytix for Sybase IQ allows customers to quickly invoke sophisticated advanced analytics models to analyze Big Data using simple SQL statements and to run the models in a massively parallel fashion in Sybase IQ's advanced PlexQ technology framework."

The ability to execute models in the industry standard Predictive Model Markup Language (PMML) format in-database within Sybase IQ allows data scientists to build predictive models in industry standard analytics tools and then automate their execution in Sybase IQ. The PMML capability combined with existing capabilities for text and multimedia analytics provides enterprises with a breadth of available techniques for analyzing Big Data.

"Zementis delivers standards-based analytics solutions focused on the Predictive Modeling Markup Language," said Michael Zeller, CEO, Zementis. "Using Sybase IQ 15.4's new JAVA API we were able to provide a Universal PMML Plug-In for Sybase IQ. This solution allows external predictive models created in the PMML standard to be parsed, ingested and executed In-database in Sybase IQ. This unique capability will appeal to most enterprises that leverage multiple data mining tools or seek to deploy their existing predictive models closer to the data for better performance and broader applicability."

Sybase IQ 15.4 delivers APIs to execute proprietary algorithms in-database providing differentiated analytic capabilities with unmatched performance. Using these new APIs developers and data scientists can integrate and execute certified function libraries from Sybase partners and custom-developed models, analytic algorithms, and data mining technologies inside a Sybase IQ database server, easily giving 10x performance gains over traditional approaches. Key capabilities include:

  • Native MapReduce API using In-Database Analytics and SQL interfaces enabling data scientists to use alternative techniques to analyze massive data sets.
  • Hadoop integration offering different techniques to integrate Hadoop data and analysis with Sybase IQ.
  • In-database Analytics APIs and tools: A new Java API and new extensions to the C++ APIs allowing implementation of high performance proprietary or certified ISV algorithms in-database that run 10x faster. Additionally, the new in-database analytics simulation environment eases development and testing.
  • Predictive Model Markup Language (PMML) support through a certified plug-in from Zementis to automate the in-database execution of analytic models created in industry standard data mining tools and other popular predictive workbench products.
  • Updated in-database statistical and data mining library, DBLytix from Fuzzy Logix, harnesses the power of Native MapReduce API (TPF) to deliver high performance analysis.
  • Better compression of text data than commonly found in Big Data scenarios.
  • Faster bulk loading of large data sets through ODBC and JDBC interfaces.


Sybase IQ 15.4 will be generally available by November 30, 2011, and also introduces a free Express Edition, enabling IT departments, developers and application vendors to easily download and start developing with Sybase IQ. Visit: Read blogs:

In Related News

Sybase today unveiled its new guide on Big Data analytics titled Intelligence for Everyone: Transforming Business Analytics Across the Enterprise. The guide demonstrates through facts and examples there are tools and methods to make sense of new and massive data sets, service all users at all levels, and analyze many different data types to provide actionable answers. To download a copy of go to:

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: Read Sybase blogs: Follow us on Twitter at @Sybase.

Sybase and, Sybase IQ, and PlexQ are registered trademarks of Sybase, Inc. ® indicates registration in the United States of America.  All other product and service names mentioned are the trademarks of their respective companies.

Forward-looking Statement

Any statements contained in this document that are not historical facts are forward-looking statements as defined in the U.S. Private Securities Litigation Reform Act of 1995. Words such as "anticipate," "believe," "estimate," "expect," "forecast," "intend," "may," "plan," "project," "predict," "should" and "will" and similar expressions as they relate to SAP are intended to identify such forward-looking statements. SAP undertakes no obligation to publicly update or revise any forward-looking statements. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. The factors that could affect SAP's future financial results are discussed more fully in SAP's filings with the U.S. Securities and Exchange Commission ("SEC"), including SAP's most recent Annual Report on Form 20-F filed with the SEC. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates.

SOURCE Sybase, Inc.