APNIC Home
APNIC Logo

Database cleanup project

About the project

In the Database SIG at APNIC 15, consensus was given to establish a project to clean up the APNIC Whois Database. The project has three actions:

  1. Remove resource records outside APNIC maintained ranges

  2. APNIC maintained ranges include allocations made by IANA and records to be transferred to APNIC as part of the ERX project.

  3. Remove records not referenced by valid APNIC Internet resources

  4. This includes contact person, role, and maintainer objects

  5. Update records that are not RPSL compliant

To minimise disruption and keep APNIC members informed of the progress, the APNIC Secretariat will:

  • Notify the APNIC community of the project timing and plan
  • Notified record holders affected by the cleanup by all means available. For confidentiality reasons, the list of records to be updated or deleted will specify primary keys only.
  • Remove/update records no less than 60 days after record holders have been notified
  • Report cleanup activities in the Database SIG and Annual Members Meeting

Motivation

This project is created to maintain the three most important attributes of APNIC Whois Database:

  1. Quality
    • APNIC Whois Database must contain correct data
  2. Performance
    • Unused objects creates unnecessary burden to the server
  3. Usability
    • RPSL non-compliant historical data cannot be updated to reflect the resource holder's current contact and maintainer information.

Key dates

May 2003

Database cleanup begins

  • Admin-c, tech-c and zone-c for affected objects notified by email
  • List of affected objects published on APNIC website

July 2003

Unreferenced objects deleted

  • This includes resources that are from non-APNIC ranges
  • APNIC Secretariat to archive original objects indefinitely

August 2003

Correct RPSL non-compliant objects

  • APNIC Secretariat to archive original objects indefinitely

September 2003

Presentation at APNIC 16 Database SIG

  • Database cleanup update [ppt | pdf]

November 2003

Unreferenced object cleanup completed. Affected objects included:

  • Person/role objects
  • Maintainer objects
  • Inetnum objects

Ongoing cleanup begins.

For more information, contact the APNIC Membership Services helpdesk.

Top  |  Database