Sybase Speeds Up Business Intelligence Performance
Updated · Aug 11, 2010
Sybase is speeding up business intelligence (BI) and analytics with the latest version of Sybase Replication Server.
The database company, which was acquired by SAP (NYSE: SAP) last month, is making a number of product announcements at its TechWave conference this week, including a business intelligence reference architecture with HP and a number of mobile CRM and other applications with SAP.
David Jonker, Sybase group manager for product marketing, suggested that more integration with SAP products could come later this month. Sybase gives SAP database technology it previously had to get from competitors Oracle (NASDAQ: ORCL), IBM (NYSE: IBM) and Microsoft (NASDAQ: MSFT).
Replication Server is Sybase's database replication product. It supports rapid data distribution and synchronization across heterogeneous database environments for faster analytics, reporting, distributed operations and disaster recovery.
Version 15.5 includes High Volume Adaptive Replication (HVAR), which can quickly analyze changing data and deliver only final outcomes, for “dramatically higher performance compared to existing replication methods,” according to the company.
Real-Time Loading with continuous change data capture (CDC) technology loads transactional data from Sybase Adaptive Server Enterprise (ASE) into the Sybase IQ analytics server, a database built for business intelligence and data warehousing by storing data in columns instead of rows, allowing for faster data access and movement and bulk data loading.
Jonker said one customer using the technology was able to do a job that previously took hours in less than five minutes. “We're seeing dramatic performance improvement for our customers,” he said.
Sybase also claims improved performance in Oracle, IBM DB2 and Microsoft SQL Server environments with parallel Data Server Interface (DSI), and customers can now maintain warm standby applications for Oracle databases.
In-Memory Database Replication allows ASE on-disk databases to be replicated to ASE in-memory databases.
For more information, visit www.sybase.com/replicationserver.
Paul Ferrill has been writing for over 15 years about computers and network technology. He holds a BS in Electrical Engineering as well as a MS in Electrical Engineering. He is a regular contributor to the computer trade press. He has a specialization in complex data analysis and storage. He has written hundreds of articles and two books for various outlets over the years. His articles have appeared in Enterprise Apps Today and InfoWorld, Network World, PC Magazine, Forbes, and many other publications.