Extreme Database Compression for Cost-Effective Data Retention

Zettapoint’s DBcompact delivers lossless compression of over 90% for structured data. It transforms multi-terabyte databases into fully indexed, online and easily accessible Oracle databases that are 5-10% of their original size.

DBcompact is quick, easy and cost-effective to implement. It is installed on your existing Oracle database platform - so there is no need for a proprietary database - and does not require any changes to the application code. DBcompact supports standard SQL queries and delivers high-speed data access.

With DBcompact, you will cut storage space and storage TCO dramatically, while ensuring data retention compliance with high-performance access.

DBcompact Benefits:

• Retain huge historical data sets on-line with high-speed access
• Dramatically reduce the TCO of data storage and data retention compliance
• Support database lifecycle management policies quickly and cost-effectively
• Accelerate disaster recovery processes while reducing bandwidth costs
• Reduce power consumption and floor space

Extreme Cluster-based Compression with High-Speed Query Performance

DBcompact utilizes Zettapoint’s clustering compression technology to achieve extreme compression rates. This technology analyzes the distribution of data in the database table and then clusters data based on the cluster ID (e.g. customer ID, product ID etc.), rather than by date or insertion time. DBcompact then stores all the data for the same cluster ID in the same or adjacent data blocks. By significantly reducing the database’s footprint, DBcompact delivers many tangible benefits:

• Reduce Storage TCO: Compressed data requires significantly less storage space and memory.
• Deliver High-Speed Query Performance: As most historical queries are based on a cluster ID, DBcompact delivers high-speed access to the data.
• Improve I/O Efficiency: Every compressed data block contains 10-20 times more data therefore the number of physical I/Os required is significantly reduced, and far more data can persist in the cache.
• Reduce Cost of Remote Site Replication and Disaster Recovery: Using DBcompact the data footprint transferred over expensive (and often slow) network links is reduced significantly. This both speeds up and reduces the costs of remote site replication, disaster recovery and backup/restore.

Small Indexes for High-Speed Query Performance

DBcompact’s revolutionary compression technology creates indexes that are significantly smaller than equivalent standard Oracle indexes. In addition to the small index footprint, DBcompact enables you to create multiple indexes on many, or even all, of the columns of a multi-terabyte size table simultaneously.

• High-Speed Query Performance: 2-10x faster query performance.
• Fast Index Creation: All indexes can be created during a single pass of the base table data.
• Enables Indexing of Cluster/Detail Tables: Delivers quick and easy querying of cluster/detail tables.

DBcompact Technical Highlights

• Extreme lossless compression of 90-95%
• Software only solution. Compressed data is stored in an Oracle database so there is no need for a proprietary database
• Ingests any structured data including: Oracle, SQL server, DB2, and flat files
• Supports standard SQL queries, and enables fast, ad-hoc multi-dimensional querying
• Delivers full application transparency through the Oracle Gateway, with standard SQL