Which database is the most economical in size

Question

We are currently using Oracle to store registration information. One of the columns is a blob that stores the XML payload. We archive the logging scheme every week, but we still get> 1 TB per week.

Goal: reduce the database database area

Solution 1: Compress the XML payload before putting it in a BLOB.

Solution 2: Look for a database (noSQL or another relational database) that already compresses the default data. The JDBC driver must be available.

Does anyone know a database that fits into solution 2? So that we do not need to change the application, we just need to change the database and update the JDBC drivers.

Answer 1

Oracle supports several different compression levels - this is suitable for solution 2 with minimal effort. (Compress table / row / lob)

Answer 2

All the dbms I know about this support compression and JDBC.

• Oracle
• SQL Server
• DB2
• Teradata li>

PostgreSQL relies on the underlying storage operating system. You could probably build PostgreSQL tablespaces in a compressed file system.

Answer 3

First, I would say if you have an enterprise, then split this xml table and periodically make a backup and crop it (if it is divided by a date range and then deletes partitions older than x). If this is not an option, you can try storing noSQL data.

There are many noSQL options. One of them that I played with (not yet released) is mongoDB . It stores data in binary JSON (BSON) format and can be compressed. It seems to be advancing with larger companies . I once worked on a similar b-tree file system some time ago, it was very fast. However, you will not have features like RDBMS. The good thing about mongoDB is that its commercial support is 10gen (again, it cannot say how good this support is, but what is important for some stores).

Here's a good article that discusses the pros and cons of the great noSQL options.

And no, I do not work for 10gen;) Of course, do more research and decide what is best for your needs.