Newer
Older
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
SELECT width, height
FROM DiffPrevFrameBenchmark
WHERE filename = 'AxioZoom_Artemia_AT-1Ch-Z_sect.czi' limit 1
-- DIFFERENCE BENCHMARK
SELECT * FROM
(
SELECT ((16.0-ROUND(AVG(BitsUsed),5)) * width * height) / (8.0 * 1000.0) as [artemia]
FROM DiffPrevFrameBenchmark
WHERE filename = 'AxioZoom_Artemia_AT-1Ch-Z_sect.czi' and diffType = 'PrevFrameDiff_VBC' and
compression = 'BZIP2' AND level = 6
) a,
(
SELECT ((16.0-ROUND(AVG(BitsUsed),5)) * width * height) / (8.0*1000.0) as [artemia_flash]
FROM DiffPrevFrameBenchmark
WHERE filename = '40x075_Artemia-Flash-AT-1Ch-Z-sect.czi' and diffType = 'PrevFrameDiff_VBC' and
compression = 'BZIP2' AND level = 6
) af,
(
SELECT ((16.0-ROUND(AVG(BitsUsed),5)) * width * height) / (8.0*1000.0) as [llc]
FROM DiffPrevFrameBenchmark
WHERE filename = 'LLC-PK1_TubX-emerald_H2B-mCherry-2chZ(SD).czi' AND diffType = 'PrevFrameDiff_VBC' and
compression = 'BZIP2' AND level = 6
) llc,
(
SELECT ((16.0-ROUND(AVG(BitsUsed),5)) * width * height) / (8.0*1000.0) as [16BitZStack]
FROM DiffPrevFrameBenchmark
WHERE filename = '16Bit-ZStack.czi' and diffType = 'PrevFrameDiff_VBC' and
compression = 'BZIP2' AND level = 6
) b16;
/*
SELECT * FROM
(
SELECT ROUND((vbc.cr - fbc.cr),5) as [artemia_div] FROM
(
SELECT AVG(compressionRatio) as [cr]
FROM DiffPrevFrameBenchmark
WHERE filename = 'AxioZoom_Artemia_AT-1Ch-Z_sect.czi' and diffType = 'PrevFrameDiff' and compression = 'BZIP2' AND level = 6
) fbc,
(
SELECT AVG(compressionRatio) as [cr]
FROM DiffPrevFrameBenchmark
WHERE filename = 'AxioZoom_Artemia_AT-1Ch-Z_sect.czi' and diffType = 'PrevFrameDiff_VBC' and compression = 'BZIP2' AND level = 6
) vbc
) artemia_diff,
(
SELECT ROUND((vbc.cr - fbc.cr),5) as [artemia_flash_diff] FROM
(
SELECT AVG(compressionRatio) as [cr]
FROM DiffPrevFrameBenchmark
WHERE filename = '40x075_Artemia-Flash-AT-1Ch-Z-sect.czi' and diffType = 'PrevFrameDiff' and compression = 'BZIP2' AND level = 6
) fbc,
(
SELECT AVG(compressionRatio) as [cr]
FROM DiffPrevFrameBenchmark
WHERE filename = '40x075_Artemia-Flash-AT-1Ch-Z-sect.czi' and diffType = 'PrevFrameDiff_VBC' and compression = 'BZIP2' AND level = 6
) vbc
) artemia_flash_diff,
(
SELECT ROUND((vbc.cr - fbc.cr),5) as [llc_diff] FROM
(
SELECT AVG(compressionRatio) as [cr]
FROM DiffPrevFrameBenchmark
WHERE filename = 'LLC-PK1_TubX-emerald_H2B-mCherry-2chZ(SD).czi' and diffType = 'PrevFrameDiff' and compression = 'BZIP2' AND level = 6
) fbc,
(
SELECT AVG(compressionRatio) as [cr]
FROM DiffPrevFrameBenchmark
WHERE filename = 'LLC-PK1_TubX-emerald_H2B-mCherry-2chZ(SD).czi' and diffType = 'PrevFrameDiff_VBC' and compression = 'BZIP2' AND level = 6
) vbc
) llc_diff,
(
SELECT ROUND((vbc.cr - fbc.cr),5) as [bit16_diff] FROM
(
SELECT AVG(compressionRatio) as [cr]
FROM DiffPrevFrameBenchmark
WHERE filename = '16Bit-ZStack.czi' and diffType = 'PrevFrameDiff' and compression = 'BZIP2' AND level = 6
) fbc,
(
SELECT AVG(compressionRatio) as [cr]
FROM DiffPrevFrameBenchmark
WHERE filename = '16Bit-ZStack.czi' and diffType = 'PrevFrameDiff_VBC' and compression = 'BZIP2' AND level = 6
) vbc
) bit16_diff;
*/
SELECT ROUND(AVG(compressionRatioZ) - AVG(compressionRatio),5)
FROM CompressionBenchmark
WHERE filename = 'AxioZoom_Artemia_AT-1Ch-Z_sect.czi' and
compression = 'BZIP2' AND level = 6
SELECT ROUND(AVG(compressionRatioZ) - AVG(compressionRatio),5)
FROM CompressionBenchmark
WHERE filename = '40x075_Artemia-Flash-AT-1Ch-Z-sect.czi' and
compression = 'BZIP2' AND level = 6
SELECT ROUND(AVG(compressionRatioZ) - AVG(compressionRatio),5)
FROM CompressionBenchmark
WHERE filename = 'LLC-PK1_TubX-emerald_H2B-mCherry-2chZ(SD).czi' AND
compression = 'BZIP2' AND level = 6
SELECT ROUND(AVG(compressionRatioZ) - AVG(compressionRatio),5)
FROM CompressionBenchmark
WHERE filename = '16Bit-ZStack.czi' and
compression = 'BZIP2' AND level = 6
) b16;
*/