VGMdb
Go Back   VGMdb Forums > VGMdb Site Related > Questions and Comments
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Sep 14, 2008, 08:30 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default Proposed change to the way we catalogue tracks

The purpose of this thread is to suggest a change to the current database structure which will allow for more flexible cataloging of game music, and to invite comments or additional suggestions.

I'm going to make this short and simple, so here's a diagram:



(the internal boxes represent examples of table entries and are not meant to be exhaustive)

Essentially, two additional tables will be inserted between tracklists and albums; one for individual tracks and one for media.

Rationale for separating tracks and tracklists:
  • The tracklength field is repeated across different tracklists. This is not necessary, plus we only take the tracklengths from the default tracklist anyway.
  • To ensure that each unique track gets one single entry. We're going to expand upon this aspect in the future with full pages for (selected) individual tracks and inter-track relationships... and track-specific artist credits.
  • Partial translation capability. There's no need to reproduce a track title that's originally in English.

Rationale for the media table:
  • Albums can have different media types packaged together (for example, CD + DVD). There's currently no way to specify this.
  • Media can be directly associated with products (such as game releases) instead of albums. This means game discs with redbook audio can be registered with their own tracklists.
  • Media can have individual catalogue numbers and titles. This can be helpful for searches.

This comes with the implication that certain enclosures which were packaged as part of a game (such as the second disc of a special edition DVD case) should now be directly associated with a product entry rather than an album entry. The album listing display will also be affected (supplemented by non-album media entries). I hope to implement this in such a way that the current album submission procedure will remain largely unchanged.

Questions and suggestions are welcome!
Reply With Quote
  #2  
Old Sep 15, 2008, 11:30 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

We already have a track table, don't we? It sounds like you're talking about some reorganization though, where instead of having the English and Japanese tracks as separate entries, they'd both be attributes of a single track. That would definitely nice, since the time would only need to be stored once.

Media is an interesting idea. I could envision that we'll have media types such as N64 Cart or 3.5" Floppy for some games. I hope that there'll be some kind of dual association so that certain enclosures can be listed and searchable in the album database while retaining their association with the product database.

As for redbooks, this seems like a good way to use the tools available to store information about redbook discs. However, I still don't want to see redbooks in the albums database. If we are going to catalogue music on redbooks, we need to expand the design so that we can handle music information from other formats -- midi, spc, digital music stored in the game data files, etc. In other words, we'd be covering the music from every game in every format, along with the composer associations and all the new metadata types. One nice thing that would fall out of this is that we could effectively provide a recipe for extracting the music from any game.
Reply With Quote
  #3  
Old Sep 15, 2008, 11:38 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

With this design, redbooks won't be in the album database at all, since they'll be associated with product entries rather than album entries. It's a multi-tier design -- the track database can store any kind of music information whether it's contained in game data or on physical media; the media table organizes a subset of tracks into an ordered list, and both the product and album tables further organize subsets of media.

In fact, you could probably directly associate tracks with products, skipping media and albums entirely. There's the possibility of creating yet another table between tracks and products in order to organize such "free-floating" music info into something more coherent.
Reply With Quote
  #4  
Old Sep 16, 2008, 10:49 AM
Eriol's Avatar
Eriol Eriol is offline
VGMdb Staff
 
Join Date: May 2007
Location: U.S.A.
Posts: 194
Default

I was not around when this database was designed. Is there a product table in this database? Does that mean somebody could search on a game disc and get any associated game music enclosures?

Otherwise, your proposal seems like a very normalized database and sounds good for the type of cataloging you are planning to do.
Reply With Quote
  #5  
Old Sep 16, 2008, 12:50 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

We haven't implemented series and products yet, but yeah, eventually you can search for a particular game and see a list of enclosures associated with its various releases, etc.
Reply With Quote
  #6  
Old Sep 17, 2008, 09:49 PM
Kaleb.G's Avatar
Kaleb.G Kaleb.G is offline
VGMdb Staff
VGM Artist
 
Join Date: May 2007
Location: California, USA
Posts: 1,024
Default

Quote:
Originally Posted by Gigablah View Post
stuff in bold
*everyone claps*

Quote:
Originally Posted by Gigablah View Post
This comes with the implication that certain enclosures which were packaged as part of a game (such as the second disc of a special edition DVD case) should now be directly associated with a product entry rather than an album entry. The album listing display will also be affected (supplemented by non-album media entries). I hope to implement this in such a way that the current album submission procedure will remain largely unchanged.
As long as we can still see enclosures/promos included on the site just as we currently do, I approve of all of these changes.

Quote:
Originally Posted by Gigablah View Post
In fact, you could probably directly associate tracks with products, skipping media and albums entirely. There's the possibility of creating yet another table between tracks and products in order to organize such "free-floating" music info into something more coherent.
That seems like it would be an extremely rare case. A product that has no media but has music? Surely you could just put a media of type "other".
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to Change the Name of my Thread Jedi QuestMaster Questions and Comments 2 Nov 18, 2018 05:18 AM
HELPING find Old Cassettes/Records catalogue number depa Anime Music Discussion 6 Nov 18, 2016 03:08 PM
about catalogue sorting Phonograph Questions and Comments 4 Jul 11, 2012 06:24 PM
Entertainment EXPO2002 Catalogue CD Secret Squirrel Album Discussions 3 Aug 24, 2011 03:08 PM
How to find out catalogue number from JAN? Datschge Video Game Music Discussion 1 Jul 2, 2008 08:10 PM