This is a list of ideas on what to try query the database for.
The actually SQL queries, the results and a discussion of each follow.

<h3>AS Path questions</h3>
<ul>
<li>Does the source AS always match the first AS in the path? (<a href="sql/matchAS.sql"> SQL </a>,<a href="sql/matchAS.out"> Result </a>, <a href="sql/matchAS.txt">Discuss</a> )
<li>What is the average length of the path? (<a href="sql/pathLength.sql"> SQL </a>,<a href="sql/pathLength.out"> Result </a>, <a href="sql/pathLength.txt">Discuss</a> )
<li>How has the average length changed over the years from 1997- 2003? (<a href="sql/pathLengthVariation.sql"> SQL </a>,<a href="sql/pathLengthVariation.out"> Result </a>, <a href="sql/pathLengthVariation.txt">Discuss</a> )
<li>How many ASes are there? How has that changed over the years? (Interesting to correlate data from BGP updates with information from the regional registries.)
<li>Does there exists alternative paths to the destination?
<li>What kind of symmetry exists on the paths?

</ul>
<h3>IP Address block sizes</h3>
<ul>
<li>What is the average size of the address blocks being announced/withdrawn?
<li>How often do we see announcements/withdrawals for the same prefix? How many for the most accessed prefix?  More generally, a histogram over all prefixes?
</ul>

<h3>3 different administative matches (IP to ASN) (These require whois info)</h3>
<ul>
<li>Does the whois information match for PeerIP and PeerAS? 
<li>Does PeerAS match the first AS in the ASPath? 
<li>Which AS's whois informatoion matches the whois information for NextHop? 
</ul>


<h3>Anomalys</h3>
<ul>
<li> We have observed repeition of the same AS number in an AS parth. How often does that happen? Can we explain why?
<li> Why are there not messages from DID 5475, 5477, 5478? (<a href="sql/5475.sql"> SQL </a>,<a href="sql/5475.out"> Result </a>, <a href="sql/5475.txt">Discuss</a> )

</ul>