PDA

View Full Version : Bangadesh Cricket Database With On Line Access


crikfan
August 28, 2004, 07:33 PM
Dear All,

I have developed a database (Thanks to Mustafiz for the idea) to store match statistics for all matches played by Bangladesh at a very granular level such that it makes it very easy to analyze the cricketing data pertaining to Bangladesh. This would enable us to form opinions based on facts.

This database can be accessed on line http://obaid.no-ip.info/my/cricket/index.html It captures many details for every match, batsman, bowler, wicket and over.

For example, if you would like to learn how many runs were scored by (Rajin Saleh) (http://obaid.no-ip.info/my/cricket/query.jsp?query=SELECT+m.team2+%27AGAINST+TEAM%27% 2C%0D%0A+++++++m.description%2C+%0D%0A+++++++mb.ba tsman%2C+%0D%0A+++++++mb.runs%2C+%0D%0A+++++++++++ ++++++mb.balls%2C+%0D%0A+++++++mb.minutes%0D%0AFRO M+++matches+m%2C+match_batsmen+mb%0D%0AWHERE++m.ma tch_id+%3D+mb.match_id%0D%0AAND++++mb.batsman+LIKE +%27Rajin%25%27%0D%0AAND++++m.match_type+%3D+%27ON EDAY%27%0D%0AORDER+BY+m.match_id+DESC%0D%0A&border=1&exec=Execute) or what were bowing figures for (Rafique) (http://obaid.no-ip.info/my/cricket/query.jsp?query=SELECT+mb.bowler%2C%0D%0A+++++++m. team2+%27AGAINST+TEAM%27%2C%0D%0A+++++++OVERS%2C++ ++++++%0D%0A+++++++MAIDENS%2C++++++++%0D%0A+++++++ RUNS%2C++++++++%0D%0A+++++++WICKETS%2C++++++++%0D% 0A+++++++NOBALLS%2C++++++++%0D%0A+++++++WIDEBALLS+ +++%0D%0AFROM+++matches+m%2C+match_bowlers+mb%0D%0 AWHERE++m.match_id+%3D+mb.match_id%0D%0AAND++++mb. bowler+LIKE+%27Mohammad%25Rafique%25%27%0D%0AAND++ ++m.match_type+%3D+%27ONEDAY%27%0D%0AORDER+BY+m.ma tch_id+DESC%0D%0A&border=1&exec=Execute) in the last ten matches, you can now find that with a click of a button. This is just one example, any interesting question that you ever had about our team now can now answered instantly.

This database contains all ODI and Test matches Bangladesh have ever played (with a few exceptions). Although, you can write interesting queries on your own if you know SQL, nevertheless, there is a link to request the query in plain English as well, with a 24 hour turn around time. There is much more useful information that can be found at the site mentioned above about the tool.

I would like to welcome you all to use the tool and give me any feedback that you may have. Looking forward to hearing from you guys. Thanks.

-CrikFan

Mahmood
August 28, 2004, 08:02 PM
Great Job. You should email this to all BD newspapers also, just so they can use it for research.

Send it in a press release format, with some luck, you may find it published on some newspapers so fans can know about it.

chinaman
August 28, 2004, 08:09 PM
Even though I don't know much about data, let alone the database, I can tell that you spend significant time and effort into that. My salute to you.

About using the database, a lame person like myself is used to using cricinfo, cricketarchive and channel4 with visual type query. So I don't find your database much user friendly, please forgive my data knowledge.

Lastly, what extra info could we get from the database that are not currently available from the above mentioned sources?

Again, thank you very much for your wonderful effort.

Mahmood
August 28, 2004, 08:23 PM
Well, you have to know SQL or request in english what you want and he will email you the SQL to get that. Or me / Nasif can do that for you.

This will give you a way to come up with any kind of stat. For example, lets say you want to see which bowlers got bashar out how many time. This site will give that to you in one query. Then you will know whats his weakness.

I think you get the idea how this can be usefull.

chinaman
August 28, 2004, 08:34 PM
Great. Let's give it a test drive with the following 4 queries.

What are the average number of overs we manage to stay at the crease in both ODI and Test?
How many times we were not all out in ODI?
What the average number of wicket we loose at the 45th over and 50th over in ODI?
How many times we managed to take 10 wickets both in ODI and Test?

Rubu
August 29, 2004, 12:45 AM
to add a few to chinaman's list:

i'd a hard time finding all 13 captains of bangladesh. how many matches each of them captained so far?

crikfan
August 29, 2004, 01:07 AM
First of all thanks for the kind words.

You have asked some very very interesting questions. I have written up the SQL to retrieve those answers. I will post these SQLs in the common query section of the tool. To retrieve your answers simply click "Answer" link below the question.

4. How many times we managed to take 10 wickets both in ODI and Test?

Answer (http://obaid.no-ip.info/my/cricket/query.jsp?query=SELECT+m.description%2C+team2+%27A GAINST+TEAM%27%0D%0AFROM+++matches+m%2C+match_wick ets+mw%0D%0AWHERE++m.match_id+%3D+mw.match_id%0D%0 AAND++++mw.batting_team+%3C%3E+%27Bangladesh%27%0D %0AGROUP+BY+mw.match_id%0D%0AHAVING+max%28wicket_n um%29+%3D+10%0D%0AORDER+BY+m.match_id+DESC%0D%0A&border=1&exec=Execute)

3. What the average number of wicket we loose at the 45th over and 50th over in ODI?

Answer (http://obaid.no-ip.info/my/cricket/query.jsp?query=SELECT+over_id+%27OVER+NUMBER%27%2 C+round%28avg%28wickets%29%2C+2%29+%27AVG+WICKETS% 27+%0D%0AFROM+++matches+m%2C+match_overs+mo%0D%0AW HERE++m.match_id+%3D+mo.match_id%0D%0AAND++++mo.ba tting_team+%3D+%27Bangladesh%27%0D%0AAND++++match_ type+%3D+%27ONEDAY%27%0D%0AGROUP+BY+over_id%3B%0D% 0A&border=1&exec=Execute)

2. How many times we were not all out in ODI?

Answer (http://obaid.no-ip.info/my/cricket/query.jsp?query=SELECT+m.description%2C+max%28wick et_num%29+%0D%0AFROM+++matches+m%2C+match_wickets+ mw%0D%0AWHERE++m.match_id+%3D+mw.match_id%0D%0AAND ++++mw.batting_team+%3D+%27Bangladesh%27%0D%0AAND+ +++match_type+%3D+%27ONEDAY%27%0D%0AGROUP+BY+mw.ma tch_id%0D%0AHAVING+max%28wicket_num%29+%3C+10%0D%0 AORDER+BY+m.match_id+DESC%0D%0A&border=1&exec=Execute)

1. What are the average number of overs we manage to stay at the crease in both ODI and Test?

Answer (http://obaid.no-ip.info/my/cricket/query.jsp?query=SELECT+m.match_id%2C+m.description %2C+max%28over_id%29+over%0D%0AFROM+++matches+m%2C +match_overs+mo%0D%0AWHERE++m.match_id+%3D+mo.matc h_id%0D%0AAND++++mo.batting_team+%3D+%27Bangladesh %27%0D%0AGROUP+BY+m.match_id%2C+mo.inning_id&border=1&exec=Execute)

crikfan
August 29, 2004, 01:10 AM
AgentSmith,

I just saw your query, unfortunately at this point I have not captured the captaincy information. But this is a good feedback, I will keep that in my to do list. Thanks for the interest.

chinaman
August 29, 2004, 02:32 AM
Thanks a lot for the quick answers. Please keep up the good works. :clap:

Mahmood
August 29, 2004, 10:28 AM
Originally posted by AgentSmith
to add a few to chinaman's list:

i'd a hard time finding all 13 captains of bangladesh. how many matches each of them captained so far?

You wont find all 13 Captain of BD national team in ODI and Test stats. Since BD didnt start playing ODI untill Lipu was the Captain, all the previous captains lead the national team against touring clubs.

Ibrahim
August 29, 2004, 01:55 PM
Very good job.