Since the compression is attribute level. can someone help to locate the places where i need to add the compression(insert query) and decompression(select query) codes?
What about writing your compression routines as user-defined data types? http://db.apache.org/derby/docs/10.8/devguide/cdevspecialudt.html Then, you can build some benchmarks that explore both the space utilization and the system overhead, with and without the use of your data types, in a very straighforward fashion. thanks, bryan