SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2011
    Location
    Trinidad and Tobago
    Posts
    194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database Content Metadata

    Hi All,

    I am trying to build a database which will find music that has similar features however to do such I need to enter metadata. I was wondering what is the best way to do such? Currently I have basic data like track name, genre, artist etc. However I want to go deeper than that and define it as something like slow rockers or fast party music or even combining genres. What is the best way to achieve something like that in terms of storing the extra metadata that describes a track and then doing a query to find other tracks that match closely to it?

    Any help will be greatly appreciated.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,270
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    the database would have three tables, tracks, genres, and a relationship table, in the classic many-to-many structure

    retrieving similar tracks based on a track's genre is a medium level difficulty sql query
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Zealot
    Join Date
    Aug 2011
    Location
    Trinidad and Tobago
    Posts
    194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Am looking for something deeper than just genre. For example for rap you can have hardcore conscious club and spoken word. They are are the same genre but signify different types of the same genre. How can this be done? To link tracks that are even different genres but both have a club type.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •