query.sql

SELECT subblock, compressionRatio, compressionRatioZ
FROM LlcEmeralCherry
WHERE compression = 'BZIP2' AND level = 6

/*
SELECT * FROM
(
SELECT ROUND(AVG(originalSize/1000000.0) / (compressionTimeZ/1000.0),5)
FROM ArtemiaZSect
WHERE compression = 'GZIP' AND level = 6
) a,
(       
SELECT ROUND(AVG(originalSize/1000000.0) / (compressionTimeZ/1000.0),5)
FROM ArtemiaFlash
WHERE compression = 'GZIP' AND level = 6
) af,
(
SELECT ROUND(AVG(originalSize/1000000.0) / (compressionTimeZ/1000.0),5)
FROM LlcEmeralCherry
WHERE compression = 'GZIP' AND level = 6
) llc,
(
SELECT ROUND(AVG(originalSize/1000000.0) / (compressionTimeZ/1000.0),5)
FROM Bit16ZStack
WHERE compression = 'GZIP' AND level = 6
) b16;
*/