Skip to main content

SQLite Musicbrainz database

Here is a rar file with a stripped down SQLite Musicbrainz database. The compressed file is about 700 MB, so it will take around 10 min to download with a good connection.

This database is for educational purposes. I have not deleted tuples from the main tables, just removed some columns and tables I thought weren't necessary to experience and understand the data.

Here is a database schema diagram and a file with create table statements and explanatory comments. Also here is a Toad data model.

The raw data used for the database was downloaded from Musicbrainz on Oct 14, 2012.  
Labels:

Comments

  1. MOINSBDJanuary 27, 2015 at 7:56 PM

    Alex.
    Can you please show me how can i import musicbrainz data dump on phpPGadmin? I have no idea about any database system but i have tried all possible ways. But i can't did that so.
    So may be your help will help me.
    I need to export this again as MySQL but for that i have some tools but i can't import it on phpPGadmin.
    Thanks :)
    my email: moinsbd@moinsbd.com

    ReplyDelete

Post a Comment

Popular posts from this blog

Latent Semantic Analysis Tutorial

I wrote a tutorial on Latent Semantic Analysis (LSA). It can be accessed by following this link . I believe LSA is a very interesting method for ranking documents in response to a query. LSA is a method for discovering hidden concepts in document data. Each document and term (word) is expressed as a vector with elements corresponding to these concepts. Each element in a vector gives the degree of participation of the document or term in the corresponding concept. The goal is not to describe the concepts verbally, but to be able to represent the documents and terms in a unified way for exposing document-document, document-term, and term-term similarities or semantic relationship which are otherwise hidden. An Example Suppose we have the following set of five documents d1 : Romeo and Juliet. d2 : Juliet: O happy dagger! d3 : Romeo died by dagger. d4 : “Live free or die”, that’s the New-Hampshire’s motto. d5 : Did you know, New-Hampshire is in New-England. and search query: dies , dagger ...
7 comments
Read more

Sanctuary Sneakers

Sanctuary Sneakers is a local early-stage startup that aggregates and leverages all available sneaker data in one place to compare prices and reveal the best deals. Their web app digs up real-time prices, inventory, and more information for both new & used sneakers from the most popular online marketplaces and stores so you don't have to! It is a perfect example of data integration from different disparate data sources. Check them out at https://sanctuarysneakers.com
Post a Comment
Read more