This is a static snapshot of one version of the database running on one version of the database code. Thus it doesn't report on the exact current AR population, but it does give useful information for talking generally about the population.

This is a static snapshot of one version of the database running on one version of the database code. Thus it doesn't report on the exact current AR population, but it does give useful information for talking generally about the population.

+

+

'''N.B.''': this snapshot is very old, from '''27 January 2008'''. I keep it as a historical record. As of October 2011, the page http://mb.lmfao.org.uk/reltype has a census which seems to be refreshed fairly regularly. [[User:JimDeLaHunt|JimDeLaHunt]] 21:36, 30 October 2011 (UTC)

This is a static snapshot of one version of the database running on one version of the database code. Thus it doesn't report on the exact current AR population, but it does give useful information for talking generally about the population.

N.B.: this snapshot is very old, from 27 January 2008. I keep it as a historical record. As of October 2011, the page http://mb.lmfao.org.uk/reltype has a census which seems to be refreshed fairly regularly. JimDeLaHunt 21:36, 30 October 2011 (UTC)

Legend for Census report

type0, type1: Gives the types of the two MusicBrainz entities which this AdvancedRelationship links. Possible types are: Artist, "album" (an old name for Release still used in the database), Track, Label, or URL. Where type0 and type1 differ, the links are reversed if needed so that type0 is less than type1, e.g. all Track-Artist relationships are reversed into Artist-Track relationships.

id: An integer which, together with type0 and type1, is the unique technical identifier for the AdvancedRelationshipType.

linkphrase: An English-language phrase which states the nature of the relationship between the two entities. It describes the relationship, but type0, type1, id is sufficient to identify the AdvancedRelationshipType

Report is sorted in order of "Short link phrase", which is similar to "linkphrase" but more succinct, then by type0 and type1. This lists together those relationships with similar meaning but different type0 and type1 values. The report is not in alphabetical order by link phrase or id.

Some AdvancedRelationshipTypes are headers for a group of related AR types. For example, remixes is a header for is a remix of, DJ-mixed by, etc. Such AR types may have zero entries.

SQL Query for Census report

This is the SQL query code, which, run on a standalone copy of the MusicBrainzDatabase, generated this report. It took about 8 seconds on JimDeLaHunt's machine.

Whither this content?

JimDeLaHunt created this page under a user directory as a way of publishing the information without needing to work out where or how this information should best be presented. I think it would be great for it to become a report or entry on the statistics page. -- JimDeLaHunt 2008-01-26