MusicBrainz Database: Difference between revisions
PavanChander (talk | contribs) mNo edit summary |
PavanChander (talk | contribs) (Update page for NGS (finally!)) |
||
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 [[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. |
||
==Introduction== |
|||
⚫ | The |
||
==Data Overview== |
==Data Overview== |
||
=== Core data === |
|||
* A MusicBrainz ID (MBID) |
|||
* Name |
|||
* Sort name 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 |
|||
⚫ | |||
⚫ | |||
: Name, sort name, aliases, type, begin and end dates, disambiguation comment, MBID |
|||
* A MusicBrainz ID (MBID) |
|||
* Title |
|||
⚫ | |||
* Type (album, single, EP, compilation, soundtrack, spokenword, interview, audiobook, live, remix, other) |
|||
;[[Release]] |
; [[Release Group]]s |
||
: Title, artist credit, type, 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 country |
|||
⚫ | |||
** Catalog number |
|||
** Barcode (EAN/UPC) |
|||
** Format (CD, cassette, vinyl, wax cylinder, etc.) |
|||
⚫ | |||
;[[Track]] data includes: |
|||
: Title, artist credit, type, status, language, medium(s), disc ID, release event(s) (date, country, label, catalog number, barcode), ASIN, disambiguation comment, MBID |
|||
* 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 |
|||
; [[Medium]]s |
|||
;[[Label]] data includes: |
|||
: Format, list of tracks (title, artist credit, duration) |
|||
* A MusicBrainz ID (MBID) |
|||
* Name |
|||
* Sort name 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]) |
|||
; [[Recording]]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. |
|||
: Title, artist credit, duration, ISRC, relationships, disambiguation comment, MBID |
|||
; [[Work]]s |
|||
: Title, relationships, disambiguation comment, MBID |
|||
⚫ | |||
: Name, sort name, aliases, country, type, code, begin and end dates, disambiguation comment, MBID |
|||
; [[URL]]s |
|||
: |
|||
; [[Relationship]]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 === |
|||
⚫ | |||
* user submitted annotations and tags |
|||
* derived statistics |
|||
* search indexes |
|||
* edit history |
|||
* non-personal user data |
|||
==Download== |
==Download== |
||
⚫ | |||
: [[Image:download.gif]] [[MusicBrainz 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 placed into the [http://creativecommons.org/licenses/publicdomain/ 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 with a Creative Commons [http://creativecommons.org/licenses/by-nc-sa/2.0/ Attribution-NonCommercial-ShareAlike] license. This allows for non-commercial use of the data as long as MusicBrainz is given credit and that derivative works (works based on MusicBrainz CC licensed data) are also made available under the same license. |
|||
All of our data is available for commercial licensing. If you are interested in licensing this data for commercial use, please [[Contact Us|contact us]]. |
|||
==Live |
==Live Data Feed== |
||
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. |
|||
[[Category:WikiDocs Page]] [[Category:Products]] [[Category:Database |
[[Category:WikiDocs Page]] [[Category:Products]] [[Category:Database]] |
Revision as of 17:43, 17 April 2012
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.
Data Overview
Core data
- Artists
- Name, sort name, aliases, type, begin and end dates, disambiguation comment, MBID
- Release Groups
- Title, artist credit, type, disambiguation comment, MBID
- Releases
- Title, artist credit, type, status, language, medium(s), disc ID, release event(s) (date, country, label, catalog number, barcode), ASIN, disambiguation comment, MBID
- Mediums
- Format, list of tracks (title, artist credit, duration)
- Recordings
- Title, artist credit, duration, ISRC, relationships, disambiguation comment, MBID
- Works
- Title, relationships, disambiguation comment, MBID
- Labels
- Name, sort name, aliases, country, type, code, begin and end dates, disambiguation comment, MBID
- Relationships
- 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 and tags
- derived statistics
- search indexes
- edit history
- non-personal user data
Download
The database is built on PostgreSQL and thus the data files provided are only suitable for importing to another PostgreSQL database. See the database schema documentation for a description of the schema.
License
- Core data
- The core data, as noted above, is placed 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 with a Creative Commons Attribution-NonCommercial-ShareAlike license. This allows for non-commercial use of the data as long as MusicBrainz is given credit and that derivative works (works based on MusicBrainz CC licensed data) are also made available under the same license.
All of our data is available for commercial licensing. If you are interested in licensing this data for commercial use, please contact us.
Live Data Feed
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.