Oracle Community Membership Statistics
Here are some interesting statistics about the members of OracleCommunity.net:
- Total number of members as of February 23, 2009: 4,505 members
- Percentage of females: 13.04 %
- Percentage of males: 86.96 %
- Average member age: 32 years
- Top five countries where members come from:
- India 30.38 %
- United States 26.06 %
- Pakistan 5.67 %
- United Kingdom 3.11 %
- Egypt 3%
- Webmail war among Gmail, Yahoo mail and Hotmail:
- Gmail: 51.71 %
- Yahoo: 34.65 %
- Hotmail: 13.64 %
I calculated the above statistics by first exporting the list of members from OracleCommunity.net as a CSV file. I then used Oracle SQL developer to import the data in the CSV file into a new table in my local Oracle XE database.
I issued the following queries. The function RATIO_TO_REPORT came in handy.
Total count:
SELECT COUNT ( * ) total_member_count FROM "oc"
TOTAL_MEMBER_COUNT
----------------------
4505
1 rows selected
Gender:
SELECT "Gender",
COUNT ( * ) member_count,
ROUND (ratio_to_report (COUNT ( * )) OVER () * 100, 2)
member_percent
FROM "oc"
WHERE "Gender" IS NOT NULL -- Not all members provide this info
GROUP BY "Gender"
Gender MEMBER_COUNT MEMBER_PERCENT
------ ---------------------- ----------------------
Female 442 13.04
Male 2947 86.96
2 rows selected
Age:
WITH ma AS (SELECT TO_NUMBER ("Age") age
FROM "oc"
WHERE "Age" IS NOT NULL -- Not all members provide this info
AND TO_NUMBER ("Age") BETWEEN 18 AND 65)
SELECT TRUNC (AVG (age)) average,
TRUNC (STDDEV (age)) dev,
TRUNC (VARIANCE (age)) var
FROM ma
AVERAGE DEV VAR
---------------------- ---------------------- ----------------------
32 7 56
1 rows selected
Country:
SELECT "Country",
COUNT ( * ) member_count,
ROUND (ratio_to_report (COUNT ( * )) OVER () * 100, 2)
member_percent
FROM "oc"
WHERE "Country" IS NOT NULL -- Not all members provide this info
GROUP BY "Country"
ORDER BY 2 DESC
Country MEMBER_COUNT MEMBER_PERCENT
------------------------------------------ ---------------------- ----------------------
India 1034 30.38
United States 887 26.06
Pakistan 193 5.67
United Kingdom 106 3.11
Egypt 102 3
Netherlands 72 2.12
Turkey 67 1.97
Indonesia 62 1.82
Canada 54 1.59
Australia 53 1.56
Saudi Arabia 49 1.44
United Arab Emirates 38 1.12
Singapore 36 1.06
Germany 33 0.97
Brazil 32 0.94
Bangladesh 30 0.88
Israel 28 0.82
Italy 24 0.71
Kuwait 23 0.68
Mexico 22 0.65
China, mainland 21 0.62
France 20 0.59
Spain 18 0.53
Malaysia 18 0.53
Ireland 15 0.44
Iran 15 0.44
Argentina 15 0.44
Thailand 14 0.41
South Africa 13 0.38
Switzerland 12 0.35
Romania 12 0.35
Russian Federation 12 0.35
Portugal 11 0.32
Norway 11 0.32
Peru 11 0.32
Belgium 10 0.29
Ukraine 9 0.26
Philippines 9 0.26
Slovenia 9 0.26
Sweden 8 0.24
Chile 8 0.24
Greece 8 0.24
Czech Republic 8 0.24
Nigeria 7 0.21
Japan 7 0.21
Qatar 6 0.18
Austria 6 0.18
Ecuador 5 0.15
Vietnam 5 0.15
Hong Kong 5 0.15
Poland 5 0.15
Jordan 5 0.15
Taiwan 5 0.15
Kenya 4 0.12
Denmark 4 0.12
Slovakia 4 0.12
Algeria 4 0.12
Oman 4 0.12
Botswana 4 0.12
Iceland 4 0.12
New Zealand 4 0.12
Serbia and Montenegro 4 0.12
Hungary 4 0.12
Bulgaria 4 0.12
Yemen 4 0.12
United States Minor Outlying Islands 4 0.12
Morocco 4 0.12
Panama 3 0.09
Colombia 3 0.09
Sri Lanka 3 0.09
Korea, Republic of 3 0.09
Mauritius 3 0.09
Nepal 3 0.09
Ghana 3 0.09
Palestinian Territory, Occupied 3 0.09
European Union 2 0.06
Iraq 2 0.06
Azerbaijan 2 0.06
Georgia 2 0.06
Madagascar 2 0.06
Costa Rica 2 0.06
Malta 2 0.06
Macedonia, The Former Yugoslav Republic of 2 0.06
Moldova, Republic of 1 0.03
Venezuela 1 0.03
Lithuania 1 0.03
Papua New Guinea 1 0.03
Croatia 1 0.03
Benin 1 0.03
Cyprus 1 0.03
Trinidad and Tobago 1 0.03
Dominican Republic 1 0.03
Brunei Darussalam 1 0.03
Lebanon 1 0.03
Sudan 1 0.03
Mozambique 1 0.03
Senegal 1 0.03
Finland 1 0.03
Netherlands Antilles 1 0.03
Puerto Rico 1 0.03
Congo, The Democratic Republic Of The 1 0.03
Cayman Islands 1 0.03
Uganda 1 0.03
103 rows selected
Webmail:
SELECT gmail,
ROUND (gmail / (gmail + hotmail + yahoo) * 100, 2) gmail_pct,
hotmail,
ROUND (hotmail / (gmail + hotmail + yahoo) * 100, 2) hotmail_pct,
yahoo,
ROUND (yahoo / (gmail + hotmail + yahoo) * 100, 2) yahoo_pct
FROM (SELECT SUM(CASE
WHEN INSTR ("Email", 'gmail') > 0 THEN 1
ELSE 0
END)
gmail,
SUM(CASE
WHEN INSTR ("Email", 'hotmail') > 0 THEN 1
ELSE 0
END)
hotmail,
SUM(CASE
WHEN INSTR ("Email", 'yahoo') > 0 THEN 1
ELSE 0
END)
yahoo
FROM "oc"
WHERE "Email" IS NOT NULL)
GMAIL GMAIL_PCT HOTMAIL HOTMAIL_PCT YAHOO YAHOO_PCT
------------ ------------ ------------ ------------ ------------ ------------
1600 51.71 422 13.64 1072 34.65
1 rows selected
The OTN Effect
I have noticed a surge in the number of visitors to my blog since yesterday. It is more than double the traffic on any normal day.
After looking at my web statistics, I noticed that the extra traffic is coming from OTN. My Oracle Firefox extensions and plugins have been featured on OTN’s home page under the Blogs and Opinion section.
This reminds me of last August, when Tom Kyte linked to my blog from AskTom’s home page.
The effect was similar. I guess Oracle find my Firefox extensions and plugins useful. Thanks guys.
4 Comments | Filed in Oracle, Personal | Tags: blog, statisticsHit every minute
Today, and for the first time (and hopefully the last), I had to deny an IP address access to my site. Starting at around 9:00 AM, I had the following IP hitting the same post on my blog at a rate of once per minute: Continue reading…
7 Comments | Filed in Personal | Tags: blog, statistics
