Hi all
Several years ago we did look at deleting not only individual objects or pairs,
but whole clusters of objects (PERSON, ROLE, MNTNER, ORGANISATION (org-type:
other), KEY-CERT) if non of these objects in a cluster were referenced by any
operational objects. It is easy to build up a collection of objects now that
will never be deleted, but which serve no useful purpose in the database.
Personally I think it is time to take a more serious look at cleaning out any
data that has no reason to be there.
cheersdenisco-chair DB WG
From: Christoffer Dam Hansen via db-wg <db-wg@ripe.net>
To: Tim Bruijnzeels <t...@ripe.net>
Cc: Database WG <db-wg@ripe.net>
Sent: Sunday, 12 November 2017, 21:01
Subject: Re: [db-wg] Clean up unreferenced maintainers (after 90 days)
+1
Should have been implemented long ago in my opinion.
Christoffer
On 12 November 2017 at 07:12, Tim Bruijnzeels via db-wg <db-wg@ripe.net> wrote:
Dear Working Group,
In the light of data protection we already clean up unreferenced organisation,
person and role objects, and also mntner-role and mntner-person pairs, 90 days
after such objects become unreferenced.
So-far unreferenced maintainers are not cleaned up. We have about 8k such
objects in the database. These objects are often syntactically incorrect and
poorly maintained - so we would like to clean them up automatically 90 days
after they become unused.
Please let us know if you see any issues with this.
Kind regards,
Tim Bruijnzeels
Assistant Manager Software Engineering and Senior Technology Officer
RIPE NCC
