Sorry! My previous email went premature... After reading Gopal's suggestion, I gave a thought of what kind of information is needed to make a detailed database. I have put together all the fields that came through my mind considering the details of the Songs, the entire album credits, and the awards received by AR or by any other artist for an AR album. Please find the attached excel that contains three sheets. This is just a scratch and please suggest to add more fields / modify existing fields. It would be ideal to have various information related to a song / album in different sheets keeping a primary field in all sheets, like song name, instead of trying to fill multiple information in the same sheet which may not be possible.
Regarding collection of the basic data of songs and artist information, if one has songs ripped from original cd into iTunes playlist, it is easy to obtain the track details from Gracenote (for many if not all) and export the playlist into a text file which can further be edited in an excel file. However, this is a later step. Please feel free to suggest your thoughts. On Wed, Aug 25, 2010 at 2:25 AM, Madhavan Rajan <rsamadhu2...@gmail.com>wrote: > > > On Tue, Aug 24, 2010 at 8:22 PM, Roshan <c.pix...@gmail.com> wrote: > >> >> >> thanks gops >> >> I agree. we need to decide on types of information and fields before even >> putting them in a db. >> >> and we will start using the fields from Vinayak's format as a start. and >> we can add the columns later. >> >> >> >> On Tue, Aug 24, 2010 at 7:55 PM, Gopal Srinivasan <catchg...@gmail.com>wrote: >> >>> >>> >>> Thanks to everyone that agreed to participate. The enthusiasm to get >>> things rolling is encouraging. However, I would caution against adhoc >>> development. Between ourselves, we have 90%-95% of the data we need. So, >>> that need not be the focus. In my view, the focus needs to be on designing a >>> database that is robust and extensible in design. It should allow for >>> backend storage and front end ingestion and retrieval of data. Extensibility >>> is particularly important because there may be views of data that we don't >>> conceive now but will be come apparent in future. A relational database >>> schema seems like the best approach to take. Let me illustrate that with an >>> example - in some cases you have credits for musicians for a song and in >>> many cases only for an entire album. This is true for awards too. The only >>> way this can be handled is through relational databases with well >>> thought-through entity-relationships. I would therefore request that let >>> our initial focus be on defining what kind of information are we seeking to >>> archive and then design the database before getting down to implementation. >>> Populating it with data is a relatively trivial task. Suggestions welcome. >>> >>> On Mon, Aug 23, 2010 at 19:48, Roshan <c.pix...@gmail.com> wrote: >>> >>>> >>>> >>>> Thank you everyone who took the time to compile the list for the db. >>>> >>>> >>>> i have just created a form to collect the data directly to MySQL. so >>>> that exporting it to any db would be easier. >>>> >>>> http://sandbox.roshanravi.com/arrdb/use/ARRahmanDatabase/form1.html >>>> >>>> i will be adding in teh album names from the excel file we have when i >>>> get a chance, but if you want to add something by yourself, please feel >>>> free.. >>>> >>>> >>>> it is just using a form generator. the only goal is to collect the >>>> data. >>>> >>>> >>>> these are the updated fields for Album. yet to do the songs db section. >>>> >>>> *Film Or Album* *Language**Dubbed**Year of Movie Release* *Year of >>>> Audio Release**Genre**Audio Company* *Actors**director **Movie >>>> Genre**Awards >>>> Won for music* *Awards Nominated for music**AWards won for movie**awards >>>> nominated for movie* *Other notes* >>>> >>>> >>>> -- >>>> ----------------------------------- >>>> http://roshanravi.com >>>> http://ramblingsoul.com >>>> http://cssheaven.org >>>> >>>> >>> >> >> >> -- >> ----------------------------------- >> http://roshanravi.com >> http://ramblingsoul.com >> http://cssheaven.org >> >> >> > > > > -- > Cheers, > Madhavan.R > Be a Music Fan; not a Music Pirate! > -- Cheers, Madhavan.R Be a Music Fan; not a Music Pirate!
