Home >  Business Continuity Suite

Zero Downtime, Disaster Recovery, and Second Site Availability for Sybase IQ

Today’s successful enterprises recognize the value of business information and depend on electronic data for sustaining and advancing the business. Electronic data is a key business asset, directly responsible for business revenue generation.

Sybase IQ retains business data and delivers mission-critical analytic Business Intelligence, driving day-to-day business decisions. Being able to efficiently grow their data warehouses while keeping costs down and reliably backup and restore multi-terabytes of data as needed or protect from catastrophic failures, are some of the challenges Sybase IQ customers face.

One of the biggest challenges is efficiently growing the data warehouse and providing high uptime and availability of IQ. Reliable backup and restore of 1TB-500TB of data is needed, as well as the ability to have data and service securely copied and available from a second site. Traditional methods for backing a 1TB-500TB data warehouse to tape simply doesn't cut it anymore: ever restore 20 TB from tape? Some examples of large data warehouse challenges include:

• Backup and restore of 10 TB of warehoused data takes days using conventional backup tools that copy data to/from disk/tape



• High-availability is complex (and not very HA) and with 3^rd party software there are integration and compatibility issues



• Disaster recovery is very complex with logistics, synchronization, and connectivity issues. Often a DR site is passive and used only for “fire-drill” exercises 1-2 times per year



• Protection from data errors (bad data loaded into a data warehouse)



• Protection from administration errors (delete the table)



• Providing full-size test-bed for new applications



• Data compliance (must continue to store data for compliance reasons)



• Litigation hold (records involved in litigation must not be deleted)



• Cross analytics of unstructured and structured data



• Long-term archiving



• Real-time data load

To address these challenges, mLogica and Sybase provide the Business Continuity Suite for Sybase IQ (BCS – IQ), already used by many of the largest and most demanding IQ customers. This overview explains the value proposition, technology components, configuration information, and a service offering for quick deployment of in customer environments.

BCS offers similar functionality to many enterprise data warehouses: Oracle, DB2, Teradata and Microsoft. BCS also supports all leading storage and SAN providers, such as EMC, NetApps, Sun, IBM, etc.

BCS leveraging Sybase IQ Virtual Backup and Virtual Restore features in conjunction with storage and replication software, is a solution proven to deliver reliable backups and rapid restores of multi-terabytes of data. Storage arrays with integrated ATA drives allow Sybase IQ customers to efficiently grow their data warehouses while keeping costs down.

BCS has undergone extensive validation testing. The observed test results confirm the integration of Sybase IQ Virtual Backup and Virtual Restore with storage and replication software works under various loads and delivers excellent results across various fault conditions.

mLogica provides the BSC and specialized consulting services to protect your IQ data warehouse from data loss, service loss, and to extend data protection to other data types.