MusicBrainz Database: Difference between revisions

From MusicBrainz Wiki
Jump to navigationJump to search
((Imported from MoinMoin))
 
mNo edit summary
(35 intermediate revisions by 9 users not shown)
Line 1: Line 1:
=The MusicBrainz Database=
<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 stores all the data of the MusicBrainz '''music metadata catalogue'''. This data includes all the data about [[Artist|Artists]], [[Release|Releases]], [[Track|Tracks]], [[Advanced Relationships|AdvancedRelationships]] between them, but also the MusicBrainz users ([[Editor|editors]]) and the changes they entered into the database ([[Edit Type|edits]]).

==Data overview==

=== Core data ===

; [[Artist]]s
: Name, sort name, IPI, aliases, type, begin and end dates, 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

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

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

; [[Work]]s
: Title, ISWC, relationships, disambiguation comment, MBID

; [[Label]]s
: Name, sort name, aliases, country, type, code, begin and end dates, disambiguation comment, MBID

; [[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 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.
The MusicBrainz database is built on the [http://postgresql.org/ Postgres] relational database engine. Therefore the data files are provided in the Postgres "dump" 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.

<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]] [[MusicBrainz Database/Download|Download and/or install the database]].
</ul>


==License==
==License==


; Core data
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 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==
==Live data-feed (or Replication)==


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.
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).


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]]
<small>Author: [[User:Keschte|Keschte]] </small>
[[Category:To Be Reviewed]] [[Category:WikiDocs Page]] [[Category:Products]] [[Category:Development]]

Revision as of 18:54, 23 May 2015

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

Artists
Name, sort name, IPI, 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, date, country, label, catalog number, barcode, medium(s), disc ID(s), ASIN, disambiguation comment, MBID
Mediums
Format, list of tracks (title, artist credit, duration)
Recordings
Title, artist credit, duration, ISRC, PUIDs, relationships, disambiguation comment, MBID
Works
Title, ISWC, relationships, disambiguation comment, MBID
Labels
Name, sort name, aliases, country, type, code, begin and end dates, disambiguation comment, MBID
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 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.