MusicBrainz Database: Difference between revisions

From MusicBrainz Wiki
Jump to navigationJump to search
m (22 revision(s))
mNo edit summary
Line 1: Line 1:
<small>[[Products]] > Database </small>
<small>[[Products]] > Database</small>


=The MusicBrainz Database=
=The MusicBrainz Database=
Line 5: Line 5:
==Introduction==
==Introduction==


The MusicBrainz database stores all the data of the MusicBrainz '''music metadata catalogue'''. This data includes all the data about [[Artist|Artists]], [[Release|Releases]], [[Track|Tracks]], [[Label|Labels]] and [[Advanced Relationships|AdvancedRelationships]] between them, but also the MusicBrainz users ([[Editor|editors]]) and the changes they entered into the database ([[Edit Type|edits]]).
The MusicBrainz database stores all the data of the MusicBrainz '''music metadata catalogue'''. This data includes all the data about [[Artist|artists]], [[Release|releases]], [[Track|tracks]], [[Label|labels]] and [[Advanced Relationships|relationships]] between them, but also the MusicBrainz users ([[Editor|editors]]) and the changes they entered into the database ([[Edit Type|edits]]).


==Data Overview==
==Data Overview==


The MusicBrainz [[Artist]] data includes:
The MusicBrainz [[Artist]] data includes:
* A MusicBrainz ID (MBID)
* A MusicBrainz ID (MBID)
* Name
* Name
* Sortname for displaying the artist name in a sorted list
* Sortname for displaying the artist name in a sorted list
* Common aliases and misspellings
* Common aliases and misspellings
* Type (person/group)
* Type (person/group)
* Begin date, a birth date or formation date, depending on type
* Begin date, a birth date or formation date, depending on type
* End date, a death date or dissolution date, depending on type
* End date, a death date or dissolution date, depending on type
* Comment, a short disambiguation field that distinguishes artists with same or similar names
* Comment, a short disambiguation field that distinguishes artists with same or similar names
* Annotation, a free form text field that allows editors to make notes about the artist
* Annotation, a free form text field that allows editors to make notes about the artist


The MusicBrainz [[Release]] data includes:
The MusicBrainz [[Release]] data includes:
* A MusicBrainz ID (MBID)
* A MusicBrainz ID (MBID)
* Title
* Title
* Artist
* Artist
* Type (Album, single, EP, compilation, soundtrack, spokenword, interview, audiobook, live, remix, other)
* Type (album, single, EP, compilation, soundtrack, spokenword, interview, audiobook, live, remix, other)
* Status (Official, promotion, bootleg, pseudo-release)
* Status (official, promotion, bootleg, pseudo-release)
* Language (see [http://www.loc.gov/standards/iso639-2/php/code_list.php ISO 639])
* Language (see [http://www.loc.gov/standards/iso639-2/php/code_list.php ISO 639])
* Annotation, a free form text field that allows editors to make notes about this release
* Annotation, a free form text field that allows editors to make notes about this release
* Discid (zero or more Discids that allow Audio CD-ROM identification)
* Disc ID (zero or more disc IDs that allow audio CD identification)
* Amazon ASIN, an Amazon.com product code, suitable for linking to cover art.
* Amazon ASIN, an Amazon.com product code, suitable for linking to cover art.
* Release events that each contain:
* Release events that each contain:
** Release date
** Release date
** Release country
** Release country
** Label
** Label
** Catalog number
** Catalog number
** Barcode (EAN/UPC)
** Barcode (EAN/UPC)
** Format (CD, Tape, Vinyl, Wax Cylinder, etc.)
** Format (CD, cassette, vinyl, wax cylinder, etc.)


The MusicBrainz [[Track]] data includes:
The MusicBrainz [[Track]] data includes:
* A MusicBrainz ID (MBID)
* A MusicBrainz ID (MBID)
* Title
* Title
* Artist
* Artist
* Duration (in milliseconds)
* Duration (in milliseconds)
* Annotation, a free form text field that allows editors to make notes about this
* Annotation, a free form text field that allows editors to make notes about this
* PUID, the [http://musicip.com MusicIP] acoustic fingerprint identifier for this track.
* PUID, the [http://musicip.com MusicIP] acoustic fingerprint identifier for this track.


The MusicBrainz [[Label]] data includes:
The MusicBrainz [[Label]] data includes:
* A MusicBrainz ID (MBID)
* A MusicBrainz ID (MBID)
* Name
* Name
* Sortname for displaying the label name is a sorted list
* Sortname for displaying the label name is a sorted list
* Common aliases and misspellings
* Common aliases and misspellings
* Type (original production, bootleg production, reissue production, distributor, holding)
* Type (original production, bootleg production, reissue production, distributor, holding)
* Code, the IFPI [[Label Code|LabelCode]]
* Code, the IFPI [[Label Code]]
* Begin date (formation date)
* Begin date (formation date)
* End date (dissolution date)
* End date (dissolution date)
* Comment, a short disambiguation field that distinguishes labels with same or similar names
* Comment, a short disambiguation field that distinguishes labels with same or similar names
* Annotation, a free form text field that allows editors to make notes about the label
* Annotation, a free form text field that allows editors to make notes about the label
* Country ([http://www.iso.org/iso/country_codes/iso_3166_code_lists/english_country_names_and_code_elements.htm ISO 3166 Codes])
* Country ([http://www.iso.org/iso/country_codes/iso_3166_code_lists/english_country_names_and_code_elements.htm ISO 3166 Codes])


Each of these [[Artist]], [[Release]], [[Track]] and [[Label]] entities can be linked by [[Advanced Relationships|AdvancedRelationships]] that provide a rich tapestry of data relationships. Advanced relationships provide information about web resources (e.g. Wikipedia pages, download locations, etc) for entities and they can indicate instrument/vocal performances on a piece of music. These relationships allow [[MusicBrainz]] to capture most of the data contained in the liner and liner notes for an Audio CD. For more details on these relationships, please read our [[Advanced Relationships|AdvancedRelationships]] page.
Each of these [[Artist]], [[Release]], [[Track]] and [[Label]] entities can be linked by [[Advanced Relationships]] that provide a rich tapestry of data relationships. Advanced relationships provide information about web resources (e.g. Wikipedia pages, download locations, etc) for entities and they can indicate instrument/vocal performances on a piece of music. These relationships allow MusicBrainz to capture most of the data contained in the liner and liner notes for an Audio CD. For more details on these relationships, please read our [[Advanced Relationships]] page.


==Download==
==Download==


The MusicBrainz database is built on the [http://postgresql.org/ Postgres] relational database engine. Therefore the data files are provided in the Postgres "COPY TO" format, only really suitable for restoring to a Postgres database. See the [[Database Schema|DatabaseSchema]] documentation for a description of the schema, and what each of the tables are used for.
The MusicBrainz database is built on the PostgreSQL relational database engine. Therefore the data files are provided in the PostgreSQL "COPY TO" format, only really suitable for restoring to a PostgreSQL database. See the [[Database Schema]] documentation for a description of the schema, and what each of the tables are used for.
<ul><li style="list-style-type:none">[[Image:download.gif]] see the [[Database Download|DatabaseDownload]] page for instructions on how to download the dumps.
* [[Image:download.gif]] see the [[Database Download]] page for instructions on how to download the dumps.
</ul>


==Installation==
==Installation==


There are a few contributed guidelines how to setup the database on different systems. See [[Database Setup|DatabaseSetup]] for the list of available documents. The easiest way to get a running database is to install a [[Virtual MusicBrainz Server|VirtualMusicBrainzServer]].
There are a few contributed guidelines how to setup the database on different systems. See [[Database Setup]] for the list of available documents. The easiest way to get a running database is to install a [[Virtual MusicBrainz Server]].


==License==
==License==


The data collected by the MusicBrainz project is made available to the public under open licenses. Some of the data is available under the '''Public Domain''', and some under the '''Creative Commons Attribution-NonCommercial-ShareAlike''' license (See [[MusicBrainz License|MusicBrainzLicense]] for more details).
The data collected by the MusicBrainz project is made available to the public under open licenses. Some of the data is available under the '''Public Domain''', and some under the '''Creative Commons Attribution-NonCommercial-ShareAlike''' license (See [[MusicBrainz License]] for more details).


==Live data-feed (or Replication)==
==Live data-feed (or Replication)==


The live data-feed enables a server running a PostgreSQL database in conjunction with the MusicBrainz [[Server]] to automatically stay in synch with the main server (See [[Live Data Feed|LiveDataFeed]] for more details).
The live data-feed enables a server running a PostgreSQL database in conjunction with the MusicBrainz [[Server]] to automatically stay in synch with the main server (See [[Live Data Feed]] for more details).


[[Category:To Be Reviewed]] [[Category:WikiDocs Page]] [[Category:Products]] [[Category:Development]]
[[Category:To Be Reviewed]] [[Category:WikiDocs Page]] [[Category:Products]] [[Category:Development]]

Revision as of 12:07, 31 March 2009

Products > Database

The MusicBrainz Database

Introduction

The MusicBrainz database stores all the data of the MusicBrainz music metadata catalogue. This data includes all the data about artists, releases, tracks, labels and relationships between them, but also the MusicBrainz users (editors) and the changes they entered into the database (edits).

Data Overview

The MusicBrainz Artist data includes:

  • A MusicBrainz ID (MBID)
  • Name
  • Sortname for displaying the artist name in a sorted list
  • Common aliases and misspellings
  • Type (person/group)
  • Begin date, a birth date or formation date, depending on type
  • End date, a death date or dissolution date, depending on type
  • Comment, a short disambiguation field that distinguishes artists with same or similar names
  • Annotation, a free form text field that allows editors to make notes about the artist

The MusicBrainz Release data includes:

  • A MusicBrainz ID (MBID)
  • Title
  • Artist
  • Type (album, single, EP, compilation, soundtrack, spokenword, interview, audiobook, live, remix, other)
  • Status (official, promotion, bootleg, pseudo-release)
  • Language (see ISO 639)
  • Annotation, a free form text field that allows editors to make notes about this release
  • Disc ID (zero or more disc IDs that allow audio CD identification)
  • Amazon ASIN, an Amazon.com product code, suitable for linking to cover art.
  • Release events that each contain:
    • Release date
    • Release country
    • Label
    • Catalog number
    • Barcode (EAN/UPC)
    • Format (CD, cassette, vinyl, wax cylinder, etc.)

The MusicBrainz Track data includes:

  • A MusicBrainz ID (MBID)
  • Title
  • Artist
  • Duration (in milliseconds)
  • Annotation, a free form text field that allows editors to make notes about this
  • PUID, the MusicIP acoustic fingerprint identifier for this track.

The MusicBrainz Label data includes:

  • A MusicBrainz ID (MBID)
  • Name
  • Sortname for displaying the label name is a sorted list
  • Common aliases and misspellings
  • Type (original production, bootleg production, reissue production, distributor, holding)
  • Code, the IFPI Label Code
  • Begin date (formation date)
  • End date (dissolution date)
  • Comment, a short disambiguation field that distinguishes labels with same or similar names
  • Annotation, a free form text field that allows editors to make notes about the label
  • Country (ISO 3166 Codes)

Each of these Artist, Release, Track and Label entities can be linked by Advanced Relationships that provide a rich tapestry of data relationships. Advanced relationships provide information about web resources (e.g. Wikipedia pages, download locations, etc) for entities and they can indicate instrument/vocal performances on a piece of music. These relationships allow MusicBrainz to capture most of the data contained in the liner and liner notes for an Audio CD. For more details on these relationships, please read our Advanced Relationships page.

Download

The MusicBrainz database is built on the PostgreSQL relational database engine. Therefore the data files are provided in the PostgreSQL "COPY TO" format, only really suitable for restoring to a PostgreSQL database. See the Database Schema documentation for a description of the schema, and what each of the tables are used for.

Installation

There are a few contributed guidelines how to setup the database on different systems. See Database Setup for the list of available documents. The easiest way to get a running database is to install a Virtual MusicBrainz Server.

License

The data collected by the MusicBrainz project is made available to the public under open licenses. Some of the data is available under the Public Domain, and some under the Creative Commons Attribution-NonCommercial-ShareAlike license (See MusicBrainz License for more details).

Live data-feed (or Replication)

The live data-feed enables a server running a PostgreSQL database in conjunction with the MusicBrainz Server to automatically stay in synch with the main server (See Live Data Feed for more details).

Retrieved from "https://wiki.musicbrainz.org/index.php?title=MusicBrainz_Database&oldid=29065"