Database cleanup 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	APNIC maintained ranges include allocations made by IANA and records to be transferred to APNIC as part of the ERX project.
2.	Remove records not referenced by valid APNIC Internet resources	This includes contact person, role, and maintainer objects.
3.	Update records that are not RPSL compliant

To minimise disruption and to 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

This project is created to maintain the three most important attributes of the 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

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 Seoul, Korea, 20 August 2003 Project Report (168.7 kb) Project Report (259.5 kb)
November 2003	Unreferenced object cleanup completed Affected objects included: Person/role objects Maintainer objects Maintainer objects Ongoing cleanup begins.

APNIC 15 - Taipei

Taiwan, 24-28 Feb 2003