Changes between Version 10 and Version 11 of Raw_Images_Files_in_Nebulous

Timestamp:

Feb 29, 2012, 1:12:50 PM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Raw_Images_Files_in_Nebulous

@@ -76 +76 @@
 }}}
 
- * Now to get the histogram of the values in RawImagesWithoutMaximumOta: 
+ * Now to get an idea on how the ota are spread the hosts, let's display the histogram of their values in {{{RawImagesWithoutMaximumOta}}}.
+
+First with a (huge) bucket size of 100,000 (Note the log scale for the y axis):
 {{{
 SELECT ROUND(ota_count, -4) AS bucket, COUNT(*) FROM RawImagesWithoutMaximumOtaNoOutliers GROUP BY bucket;
@@ -83 +85 @@
 [[Image(histogram_RawImagesWithoutMaximumOtaNoOutliers_10000.png)]]
 
-Detail of the first part of the histogram: 
+We are interested in the detail of the first part of the histogram. With a bucket size of 100: 
 {{{
 SELECT ROUND(ota_count, -2) AS bucket, COUNT(*) FROM RawImagesWithoutMaximumOtaNoOutliers GROUP BY bucket LIMIT 150;
@@ -89 +91 @@
 
 [[Image(histogram_RawImagesWithoutMaximumOtaNoOutliers_100.png)]]
+