<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1510143306444_323487"><span>Hi all</span></div><div><span><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510143306444_323552"><span id="yui_3_16_0_ym19_1_1510143306444_323595">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.<br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510143306444_323818"><span id="yui_3_16_0_ym19_1_1510143306444_323595"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510143306444_323820"><span id="yui_3_16_0_ym19_1_1510143306444_323595">Personally I think it is time to take a more serious look at cleaning out any data that has no reason to be there.</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510143306444_323822"><span id="yui_3_16_0_ym19_1_1510143306444_323595"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510143306444_323824"><span id="yui_3_16_0_ym19_1_1510143306444_323595">cheers</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510143306444_323826"><span id="yui_3_16_0_ym19_1_1510143306444_323595">denis</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510143306444_323816"><span id="yui_3_16_0_ym19_1_1510143306444_323595">co-chair DB WG</span></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1510143306444_323488"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1510143306444_323831" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1510143306444_323830"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1510143306444_323829"> <div dir="ltr" id="yui_3_16_0_ym19_1_1510143306444_323828"> <font id="yui_3_16_0_ym19_1_1510143306444_323833" size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Christoffer Dam Hansen via db-wg <db-wg@ripe.net><br> <b><span style="font-weight: bold;">To:</span></b> Tim Bruijnzeels <tim@ripe.net> <br><b><span style="font-weight: bold;">Cc:</span></b> Database WG <db-wg@ripe.net><br> <b><span style="font-weight: bold;">Sent:</span></b> Sunday, 12 November 2017, 21:01<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [db-wg] Clean up unreferenced maintainers (after 90 days)<br> </font> </div> <div class="y_msg_container"><br><div id="yiv6882489698"><div><div dir="ltr"><div class="yiv6882489698gmail_default" style="font-family:monospace, monospace;">+1</div><div class="yiv6882489698gmail_default" style="font-family:monospace, monospace;"><br clear="none"></div><div class="yiv6882489698gmail_default" style="font-family:monospace, monospace;">Should have been implemented long ago in my opinion.</div><div class="yiv6882489698gmail_default" style="font-family:monospace, monospace;"><br clear="none"></div><div class="yiv6882489698gmail_default" style="font-family:monospace, monospace;">Christoffer</div></div><div class="yiv6882489698yqt9926398500" id="yiv6882489698yqt83297"><div class="yiv6882489698gmail_extra"><br clear="none"><div class="yiv6882489698gmail_quote">On 12 November 2017 at 07:12, Tim Bruijnzeels via db-wg <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:db-wg@ripe.net" target="_blank" href="mailto:db-wg@ripe.net">db-wg@ripe.net</a>></span> wrote:<br clear="none"><blockquote class="yiv6882489698gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Dear Working Group,<br clear="none">
<br clear="none">
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.<br clear="none">
<br clear="none">
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.<br clear="none">
<br clear="none">
Please let us know if you see any issues with this.<br clear="none">
<br clear="none">
Kind regards,<br clear="none">
<br clear="none">
Tim Bruijnzeels<br clear="none">
Assistant Manager Software Engineering and Senior Technology Officer<br clear="none">
RIPE NCC<br clear="none">
</blockquote></div><br clear="none"></div></div></div></div><br><br></div> </div> </div> </div></div></body></html>