MusicBrainz Database: Difference between revisions

From MusicBrainz Wiki
Jump to navigationJump to search
 
(14 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<small>[[Products]] > MusicBrainz Database</small>
<small>[[Products]] > MusicBrainz Database</small>


The MusicBrainz Database is built on the PostgreSQL relational database engine and contains all of MusicBrainz' music metadata. This data includes information about [[Artist|artists]], [[Release Group|release groups]], [[Release|releases]], [[Recording|recordings]], [[Work|works]], and [[Label|labels]], as well as the many [[Relationships|relationships]] between them. The database also contains a full history of all the changes that the MusicBrainz community has made to the data.
==Introduction==


For details on commercial use, please visit the [https://metabrainz.org/supporters/account-type MetaBrainz Foundation] site.
The '''MusicBrainz Database''' is built on the PostgreSQL relational database engine, it's used to store all of MusicBrainz' music metadata. This data includes information about [[Artist|artists]], [[Release Group|release groups]], [[Release|releases]], [[Track|tracks]], [[Label|labels]] and the many [[Advanced Relationships|relationships]] between them. The database also contains a full history of all the changes that the MusicBrainz community has made to the data.


==Data Overview==
==Data overview==


;[[Artist]] data includes:
=== Core data ===
* 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


; [[Area]]s
;[[Release Group]] data includes:
: Name, aliases, type, ISO codes, begin and end dates, disambiguation comment, MBID
* A MusicBrainz ID (MBID)
* Title
* Artist
* Type (album, single, EP, compilation, soundtrack, spokenword, interview, audiobook, live, remix, other)


; [[Artist]]s
;[[Release]] data includes:
: Name, sort name, areas, IPI, ISNI, aliases, type, begin and end dates, disambiguation comment, MBID
* 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 [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 the release
* Disc ID (zero or more disc IDs that allow audio CD identification)
* Amazon ASIN, an Amazon product code that is 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.)


; [[Event]]s
;[[Track]] data includes:
: Name, aliases, type, begin and end dates, time, setlist, disambiguation comment, MBID (performers / location indicated through relationships)
* A MusicBrainz ID (MBID)
* Title
* Artist
* Duration (in milliseconds)
* Annotation, a free form text field that allows editors to make notes about the track
* PUID, the [http://musicip.com MusicIP] acoustic fingerprint identifier for the track
* ISRC


; [[Genre]]s
;[[Label]] data includes:
: Name, aliases, disambiguation comment, MBID
* 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|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 ([http://www.iso.org/iso/country_codes/iso_3166_code_lists/english_country_names_and_code_elements.htm ISO 3166 Codes])


; [[Instrument]]s
The various [[Artist|artists]], [[Release|releases]], and [[Track|tracks]] can be linked together with [[Advanced Relationships|relationships]] that enrich the depth of collectible data. For example, relationships can provide information about web resources (e.g. Wikipedia pages, download locations, review pages, etc), or 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 notes of an Audio CD.
: Name, description, aliases, type, disambiguation comment, MBID

; [[Label]]s
: Name, area, IPI, ISNI, aliases, type, code, begin and end dates, disambiguation comment, MBID

; [[Medium]]s
: Format, list of tracks (title, artist credit, duration)

; [[Place]]s
: Name, aliases, area, type, code, begin and end dates, disambiguation comment, MBID

; [[Recording]]s
: Title, artist credit, duration, ISRC, PUIDs, disambiguation comment, MBID

; [[Release Group]]s
: Title, artist credit, type, disambiguation comment, MBID

; [[Release]]s
: Title, artist credit, type, status, language, date, country, label, catalog number, barcode, medium(s), disc ID(s), ASIN, disambiguation comment, MBID

; [[Series]]
: Name, aliases, type, disambiguation comment, MBID (parts indicated through relationships)

; [[Work]]s
: Title, ISWC, disambiguation comment, MBID (writers indicated through relationships)

; [[Relationship]]s & [[URL]]s
: Relationships are a way to link the above entities together and allow MusicBrainz to capture most of the data contained in the liner notes of a CD.

; [[CD Stub]]s
: Title, artist, barcode, disc ID, disambiguation comment

=== Supplementary data ===

Supplementary data includes:
* user submitted annotations, tags (including genre associations) and ratings
* derived statistics
* search indexes
* edit history
* non-personal user data

== Schema ==
For more information, see our [[/Schema|Schema details]].


==Download==
==Download==


A complete data snapshot of the entire database is generated twice a week. These snapshots are split into several different files organized by license and contents.
Since the database is built on PostgreSQL and the data files are provided in the PostgreSQL "COPY TO" format, the files are only suitable for restoring to a PostgreSQL database. See the [[Database Schema|database schema]] documentation for a description of the schema, and what each of the tables are used for.

: [[Image:download.gif]] [[Database Download|Download and/or install the database]].
: [[Image:download.gif]] [[MusicBrainz Database/Download|Download and/or install the database]].


==License==
==License==
:'' See [[MusicBrainz License|the license page]] for full details.


; Core data
The majority of the data is released into the public domain, with the remaining portions released with a Creative Commons Attribution-NonCommercial-ShareAlike license. All of our data is available for commercial licensing. If you are interested in licensing this data for commercial use, please [http://metabrainz.org/contact/index.html contact us].
: The core data, as noted above, is licensed under the [http://creativecommons.org/publicdomain/zero/1.0/ CC0], which is effectively placing the data into the Public Domain. This means that anyone can download and use the core data in any way they see fit. No restrictions, no worries!

; Supplementary data
: The supplementary data, as noted above, is released under the Creative Commons [http://creativecommons.org/licenses/by-nc-sa/3.0/ Attribution-NonCommercial-ShareAlike 3.0] license. This allows for non-commercial use of the data as long as MusicBrainz is given credit and that derivative works (works based on the CC licensed data) are also made available under the same license.

==Commercial Use & Live Data Feed==


All of our data is available for commercial licensing. For details on commercial use, please visit the [https://metabrainz.org/supporters/account-type MetaBrainz Foundation] site.
==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 sync with the main server (See [[Live Data Feed|live data-feed]] for more details).
Consumers of our database may be interested in our replicated [[Live Data Feed]]. This feed operates in conjunction with the [[MusicBrainz Server]] software and enables a local database to automatically stay in sync with the main server. To access the Live Data Feed for commercial or personal use, please sign up at the [https://metabrainz.org/supporters/account-type MetaBrainz Foundation] site.


[[Category:WikiDocs Page]] [[Category:Products]] [[Category:Database]]
[[Category:WikiDocs Page]] [[Category:Products]] [[Category:Database]]

Latest revision as of 12:46, 26 May 2022

Products > MusicBrainz Database

The MusicBrainz Database is built on the PostgreSQL relational database engine and contains all of MusicBrainz' music metadata. This data includes information about artists, release groups, releases, recordings, works, and labels, as well as the many relationships between them. The database also contains a full history of all the changes that the MusicBrainz community has made to the data.

For details on commercial use, please visit the MetaBrainz Foundation site.

Data overview

Core data

Areas
Name, aliases, type, ISO codes, begin and end dates, disambiguation comment, MBID
Artists
Name, sort name, areas, IPI, ISNI, aliases, type, begin and end dates, disambiguation comment, MBID
Events
Name, aliases, type, begin and end dates, time, setlist, disambiguation comment, MBID (performers / location indicated through relationships)
Genres
Name, aliases, disambiguation comment, MBID
Instruments
Name, description, aliases, type, disambiguation comment, MBID
Labels
Name, area, IPI, ISNI, aliases, type, code, begin and end dates, disambiguation comment, MBID
Mediums
Format, list of tracks (title, artist credit, duration)
Places
Name, aliases, area, type, code, begin and end dates, disambiguation comment, MBID
Recordings
Title, artist credit, duration, ISRC, PUIDs, disambiguation comment, MBID
Release Groups
Title, artist credit, type, disambiguation comment, MBID
Releases
Title, artist credit, type, status, language, date, country, label, catalog number, barcode, medium(s), disc ID(s), ASIN, disambiguation comment, MBID
Series
Name, aliases, type, disambiguation comment, MBID (parts indicated through relationships)
Works
Title, ISWC, disambiguation comment, MBID (writers indicated through relationships)
Relationships & URLs
Relationships are a way to link the above entities together and allow MusicBrainz to capture most of the data contained in the liner notes of a CD.
CD Stubs
Title, artist, barcode, disc ID, disambiguation comment

Supplementary data

Supplementary data includes:

  • user submitted annotations, tags (including genre associations) and ratings
  • derived statistics
  • search indexes
  • edit history
  • non-personal user data

Schema

For more information, see our Schema details.

Download

A complete data snapshot of the entire database is generated twice a week. These snapshots are split into several different files organized by license and contents.

download.gif Download and/or install the database.

License

Core data
The core data, as noted above, is licensed under the CC0, which is effectively placing the data into the Public Domain. This means that anyone can download and use the core data in any way they see fit. No restrictions, no worries!
Supplementary data
The supplementary data, as noted above, is released under the Creative Commons Attribution-NonCommercial-ShareAlike 3.0 license. This allows for non-commercial use of the data as long as MusicBrainz is given credit and that derivative works (works based on the CC licensed data) are also made available under the same license.

Commercial Use & Live Data Feed

All of our data is available for commercial licensing. For details on commercial use, please visit the MetaBrainz Foundation site.

Consumers of our database may be interested in our replicated Live Data Feed. This feed operates in conjunction with the MusicBrainz Server software and enables a local database to automatically stay in sync with the main server. To access the Live Data Feed for commercial or personal use, please sign up at the MetaBrainz Foundation site.