great job! that is very comprehensive and refined format.
On Wed, Aug 25, 2010 at 2:48 AM, Madhavan Rajan <[email protected]>wrote: > > [Attachment(s) <#12aa7199635f4e82_TopText> from Madhavan Rajan included > below] > > 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 <[email protected]>wrote: > >> >> >> On Tue, Aug 24, 2010 at 8:22 PM, Roshan <[email protected]> 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 >>> <[email protected]>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 <[email protected]> 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! > > -- ----------------------------------- http://roshanravi.com http://ramblingsoul.com http://cssheaven.org
