New MySQL Storage Engine for Effective Storage of Historical Data

Algorego storage engine for MySQL is designed to efficiently store historical data by compressing it yet ensuring standard database functionality regarding the compressed data.
Algorego storage engine is designed for MySQL v5.1 and can be simply added or removed. The technology of the Algorego storage engine for MySQL is based on thoroughly tested Algorego database technology that stores data in compressed format that saves up to 40 times of disk space. The technology has undergone thorough testing which proves stable performance of the technology and data throughput rate that is comparable to other relational databases.
The use of Algorego storage engine is simple and straightforward. MySQL inherently supports several storage engines and therefore changing them is a standard and simple feature provided by MySQL system architecture. Users of MySQL are used to applying different storage engines within one database system to combine the strengths of all of them. By adding Algorego storage engine to your system, you bring in the power to deal with much larger amount of data as you could imagine before.

Main Features:

Large table support

Maximum table size – 2^64, maximum row size – 20mb, maximum number of rows: 2^48 and maximum of 1,000 columns per table.

High data compression

Data compression is the key functionality of Algorego database technology. In multiple tests data compression ratio reaches 1:40

• Data encryption
• Reliability, fault recovery
• Consistent performance for huge data
• Reliable work for huge data
• Unique and nonunique indexes
• data organized for fast index retrieval, with “clustering indexes” (also called “index-organized tables”)
• supports full MySQL SQL language
• supports all MySQL data types,
• supports AUTO-INCREMENT