Konzept #293

Define the Sequences

Added by Alexander Blum about 7 years ago. Updated over 4 years ago.

Status:ErledigtStart date:
Priority:HochDue date:
Assignee:Alexander Blum% Done:

0%

Category:-Estimated time:0.50 h
Target version:Repertoire 3) Testing phase III

Description

The sequences define the c3s internal reference to an object, which is communicated to the web user.

Right now, there exist sequences for Artists and Creations. I assume, we should also define sequences for Releases, too?

  • Is an ordinary increment ok?
  • Should there be padding?
  • Any pre-/postfixes?

Related issues

Related to collecting_society - Datenbank #329: Implement the sequences Erledigt

History

#1 Updated by Meik Michalke about 7 years ago

can you give an example? from what i get this could be something like

a00000012 r000003036 c00000064722

?

#2 Updated by Meik Michalke about 7 years ago

  • Assignee changed from Meik Michalke to Alexander Blum

#3 Updated by Alexander Blum about 7 years ago

  • Status changed from Neu to Feedback
  • Assignee changed from Alexander Blum to Meik Michalke

Exactly (suffixes are also possible).

The attributes of a sequence are

  • prefix (String)
  • suffix (String)
  • padding (Integer)

Something reasonable would be: perhaps a prefix for the sequence type (artists, creations, releases(?)) and a padding, which reflects the expected total number of objects. As these sequences are the "official" identifiers for the objects, their definitions are not technical, but administrative in nature.

#4 Updated by Meik Michalke about 7 years ago

  • Assignee changed from Meik Michalke to Alexander Blum

I assume, we should also define sequences for Releases, too?

yes.

perhaps a prefix for the sequence type (artists, creations, releases(?)) and a padding, which reflects the expected total number of objects.

agreed, it's what i had in mind with:

a00000012 r000003036 c00000064722

not sure about the numer of zeroes, i'd look at the stats of musicbrainz and discogs and make sure it won't need fixing in the next 100 years ;-)

#5 Updated by Alexander Blum about 7 years ago

  • Assignee changed from Alexander Blum to Meik Michalke

From https://musicbrainz.org/statistics

Artists:   1,196,253
Releases:  1,779,175
Tracks:   22,211,592

So, what about a padding of 10 (10 billion - 1)? And big letters (better clarity)?

  • Artists: A##########
  • Releases: R##########
  • Creations: C##########

It's a bit of trouble to write that down, if needed, but would be save for quite a while.

#6 Updated by Meik Michalke about 7 years ago

  • Assignee changed from Meik Michalke to Alexander Blum

+1

#7 Updated by Alexander Blum about 7 years ago

  • Status changed from Feedback to Erledigt

Implementation in #329

#8 Updated by Alexander Blum about 7 years ago

#9 Updated by Alexander Blum over 4 years ago

  • Target version changed from 3) Testing phase III to Repertoire 3) Testing phase III

#10 Updated by Alexander Blum over 4 years ago

  • Project changed from repertoire to collecting_society

Also available in: Atom PDF