April 2020 - ripe-db-requirements-tf

Database Usage Survey Results
by Boris Duval 16 Nov '21

16 Nov '21

Dear colleagues, We just closed the Database usage survey and collected 206 responses. Please find the survey results attached to this email. Thank you all for your input! Along with other sources of data, this feedback is really valuable to the current DBTF work. We plan to collate the open questions results and send them to the mailing list as soon as possible. Best, Boris Duval RIPE NCC

2 1

RIPE Database Requirements Task Force BoF
by Bijal Sanghani 06 May '20

06 May '20

Dear colleagues, The RIPE Database Requirements Task Force (DBTF) will organise its BoF on Wednesday, 6 May from 14h00-15h00 CEST via Zoom. During this BoF, the DBTF will present its latest work and invite participants to discuss what functionality the RIPE Database should provide in the future. The presentation will include quick polls and will be followed by a moderated Q&A. You can register for the BoF at (no Zoom account required): https://ripe.zoom.us/meeting/register/tJMkd-yhrz4uHNDuOIBm8hGvcj8DSDK1Ybog <https://ripe.zoom.us/meeting/register/tJMkd-yhrz4uHNDuOIBm8hGvcj8DSDK1Ybog> We look forward to discussing the future of the RIPE Database with you! Kind regards, Bijal Sanghani on behalf of the DBTF

2 1

More Specific Resources per LIR organisation
by Edward Shryane 28 Apr '20

28 Apr '20

Dear all, The DB team counted more-specific resources under IPv4 and IPv6 allocations registered in the RIPE database for all LIR organisations. We found that some LIRs have registered significantly more resources than others. Of 14,164 LIR organisations with more specific resources, 13,956 organisations have registered less than 1,000 of them. I've attached a count of more-specific resources (by LIR, using an anonymised label) for the remaining 206 LIRs. Let me know if you need any more information. Regards Ed

1 0

Notes from 17 April 2020 Meeting
by Boris Duval 24 Apr '20

24 Apr '20

Dear all, Here's the meeting notes from our last call. Best, Boris *RIPE Requirements Database Task Force Meeting Notes* 17 April 2020 Attendees: Nick Hilliard, Shane Kerr, James Kennedy, Peter Koch, Sara Marcolla, Bijal Sanghani, Edward Shryane, Boris Duval Agenda: 1. Review action points Ed sent IRT statistics and the DBTF will now analyse them. Boris looked into interactivity options to use during the BoF and proposed to use Zoom polls. The DBTF agreed. 2. Preparation for remote RIPE meeting The DBTF decided not to present at the DB-WG during RIPE 80 as they will give an update during the Community Plenary. - BoF The DBTF decided to host their BoF on Wednesday, 6 May via Zoom. They will ask the PC if they agree to have the BoF outside of the RIPE 80 schedule. The DBTF discussed which topics will be the most interesting to raise with the community at the BoF and mentioned IPAM, accuracy and personal information. The DBTF also agreed to try to publish a first draft of the requirements document before the BoF, so that they can have time to discuss it with the community . 3. Next steps and actions Each member of the DBTF will finalise its work on the first draft of the requirements document by next call. Bijal and Boris will contact the PC to organise the BoF in the week before RIPE 80. 4. AOB There was no further business. 5. Next call The next DBTF call will take place on Tuesday, 28 April.

1 0

Notes from 6 April 2020 Meeting
by Boris Duval 15 Apr '20

15 Apr '20

Dear all, Here's the meeting notes from our last call. Best, Boris *RIPE Requirements Database Task Force Meeting Notes* 6 April 2020 Attendees: Nick Hilliard, Shane Kerr, James Kennedy, Peter Koch, Bijal Sanghani, Edward Shryane, Maria Stafyla, Boris Duval Agenda: 1. Review action points Shane drafted a text breaking down the meaning of geolocation in the RIPE Database and is waiting for feedback from the DBTF. Boris sent a new version of the open-ended survey results including a cross-analysis. 2. Preparation for remote RIPE meeting - Community Plenary The DBTF will prepare an update for the Community Plenary. - BoF BoFs are going ahead at the virtual RIPE Meeting and the DBTF will have a time slot. The DBTF needs to investigate how to best collect feedback before and during the BoF as everything will be online. The DBTF discussed asking for feedback to the community before the BoF to save time. 3. Next steps and actions Nick will contact the Routing WG chairs about RPSL. Shane will send an email to the ripe-list to discuss IPAM usage within the community related to the recent DBTF survey results. Ed will explore more statistics on how IRT objects are used. Bijal will draft slides for the Community Plenary and schedule calls for next meetings to discuss next steps and how to prepare for RIPE 80. Boris will look into which tools/platforms can be used to foster engagement before and during the BoF. Each member of the DBTF will continue its work on a different RIPE Database purpose/requirement. 4. AOB - Denis Walker questions to the DBTF The DBTF acknowledged Denis’ questions sent via the DB-WG mailing list and will reply to him as soon as possible. - COVID19 and upcoming meetings As COVID-19 disrupted everybody’s schedule, the DBTF agreed to have more frequent calls in the coming weeks to better prepare for RIPE 80 and advance its work. 5. Next call The next DBTF call will take place in two weeks.

1 0

IRT Query Statistics
by Edward Shryane 08 Apr '20

08 Apr '20

Hi all, Here are some statistics on IRT queries for January. How much usage do these IRT objects get? Some background reading on IRT objects: https://www.ripe.net/manage-ips-and-asns/db/irt https://www.ripe.net/manage-ips-and-asns/db/support/documentation/ripe-data… The IRT object is meant to be used by Incident Response Teams directly, and "abuse-c:" is meant for general abuse complaints. IRT objects are *not* returned by default in Whois queries. Users must either specify the -c / --irt flag on an IP lookup, or specify the IRT-* primary key. There are about 400 IRT objects in the Whois database. To reference an IRT object from an IP range, you must add an "mnt-irt" attribute (and authenticate with the IRT object). I found 12,694 references to IRT objects from inetnums, and 901 references from inet6nums. A total of 174 distinct IRT objects are referenced (leaving 226 unreferenced). Out of 2 billion Whois queries in January, I found 204,318 queries with the irt flag (or ~7k/day), and 546 queries (or about 18/day) for an IRT object using the primary key. Let me know if you have any questions or would like more details. Regards Ed Shryane RIPE NCC

1 1