Relationships

An advanced relationship is a way to represent all the various inter-relationships between entities, as well as relationships from entities to information and resources found outside of the MusicBrainz database.

For example:

• The song Rockafella Skank by Fatboy Slim includes a sample from the Just Brothers song Sliced Tomato.
• Paul Di'Anno was a member of Iron Maiden from 1977 until 1981.
• The Metallica album St. Anger was produced by Bob Rock & Metallica.

All of this information is stored in a single table in the database, and there is a single user interface for adding new information. In this way, MusicBrainz has a fairly simple way to deal with extremely complicated data.

Getting Started

There is a tutorial at How To Make Relationships.

Advanced Relationship Types

Each relationship entered by a user belongs to one relationship type. These types define:

• Which entities will be related (artists, albums, tracks, etc)
• What attributes go along with the relationship
• The link phrases of the relationships, which describe relationship information in an English sentence.

For example, Performer Relationship Type can be used to link an artist (for example, Eric Clapton) to a track on which they performed (for example, Runaway Train). The definition of Performer Relationship Type allows an optional attribute to specify the instrument he played (Instrument Relationship Attribute), so you can say if he played guitar. The definition also says how to construct an English sentence out of this data, so that the website can display the words "Runaway Train was performed by Eric Clapton".

Creating and editing relationships

Advanced relationship types are themselves simply entries in another database table. This means that new ones can be defined, old ones deleted, and existing ones modified through a relatively simple user-interface which does not require hacking the database internals. Since this data is much more important than any other individual entries, editing of advanced relationship types and attributes is limited to selected users, called Relationship Editors. They implement new relationships and changes to existing relationships following the passage of a proposal to do so.

While there are very few relationship editors, anyone can propose new relationships or changes to existing relationships, using said proposal process. Though most editors are not able to directly edit the types of advanced relationships, it can be useful to know what Advanced Relationship Attribute Syntax itself supports, as it will be used to implement any relationship proposal which passes the process.

Style

Please see Advanced Relationship Style.

History

Advanced relationships were first officially proposed here. Dave Evans created the database structure to allow relationships, and wrote tools for allowing the user to define a type of relationship. However, the code for linking two entities together and the UI to manipulate relationships themselves was left undone.

In November of 2004, Robert Kaye took over working on the user interface and Don Redman became the Idea Champion for advanced relationships. The design documents of the time, including the original set of relationship types, make for interesting reading: Simple Advanced Relationships Interface describes the initial development of the UI and model for editing relationships, while Fancy Advanced Relationships Interface describes some then-future ideas for development of that relationships UI and model.

On April 10, 2005, development was completed, and advanced relationship support was officially added to the database.

Robert Kaye and Don Redman defined the original set of relationship types. All additions, removals, and changes to that list of relationship types since then have been made by the Style Council.