DBcompact Technology

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.

Deployment Architecture

The key elements of the architecture are:

DBcompact Loader: reads the data from the source database or flat files, then compresses and stores the data in the compressed schema.

DBcompact Loader can load and compress one terabyte of data in 24 hours with a four-CPU core machine. Additional CPU capacity will further accelerate the loading process.

Compressed Database: compressed tables are persisted as standard Oracle tables. The compressed data itself is stored in the BLOB section of the table. As this is a standard Oracle construct, all maintenance procedures, such as backup/restore, can use familiar Oracle tools and procedures.

DBcompact ODBC Driver: processes the SQL requests from end users, applications or BI tools, reads the relevant rows from the database, decompresses the data and returns it using a standard ODBC protocol.

With DBcompact you can also access the data using the Oracle Gateway with standard SQL. In this case there is no need to change application code.