Skip to Content
[CAIDA - Center for Applied Internet Data Analysis logo]
Center for Applied Internet Data Analysis
www.caida.org > data : peeringdb
PeeringDB
This page documents peeringdb dataset.
|   Download PeeringDB Dataset   |

Description

PeeringDB, an online database of peering policies, traffic volumes and geographic presence of participating networks. PeeringDB, a non-profit member-based organization, has been established to support practical needs of network operators. However, it is also a valuable source of information for researchers. The first version of PeeringDB resided in a MySQL database, which was not scalable and lacked security features and data validation mechanisms. It presented potential risks of exposing contact information to spammers, and contained typos. Starting at the end of March 2016, PeeringDB switched to a new data schema and API. CAIDA manages the only repository of historic PeeringDB data, which includes daily sql snapshots from July 2010 till March 2016.

Format

The daily snapshots are in both sql and sqlite formats. The schemas of the snapshots are not uniform; we suggest using sqlite3 to explore the structure of the snapshots.

Example:

  sqlite3 peeringdb_dump_2016_03_14.sqlite 
  sqlite> .table 
  sqlite> .schema mgmtFacilities 

Funding

Collection of this dataset was funded under "The economics of transit and peering interconnections in the Internet" grant

Acceptable Use Agreement

Access to these data is subject to the terms of the following CAIDA Acceptable Use Agreement (printable version in PDF format)

When referencing this data (as required by the AUA), please use:

The CAIDA UCSD PeeringDB Dataset, <date range used>
http://www.caida.org/data/peeringdb.xml
Also, please, report your publication to CAIDA.

Data Access

Access the public CAIDA UCSD PeeringDB Dataset

Related Work

References

[LODHI] A. Lodhi, Larson N., Dhamdhere A., Dovrolis C., Claffy K., Using PeeringDB to Understand the Peering Ecosystem, ACM SIGCOMM Computer Communication Review (CCR), 2014.

  Last Modified: Thu Jun-22-2017 06:58:33 PDT
  Page URL: http://www.caida.org/data/peeringdb/index.xml