I've been thinking of doing something like this for a while. Gops - great suggestion, as usual. Let's spend some time designing this well. Data can always be crowd-sourced the wikipeida-way and should be relatively simple once we have a good design.
Who ever does this, let's follow the open-source philosophy. I'll see if I can work on something and get something that everyone can then pitch in and evolve. Cheers! --- In [email protected], Roshan <c.pix...@...> wrote: > > great job! that is very comprehensive and refined format. > > > > On Wed, Aug 25, 2010 at 2:48 AM, Madhavan Rajan <rsamadhu2...@...>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 <rsamadhu2...@...>wrote: > > > >> > >> > >> On Tue, Aug 24, 2010 at 8:22 PM, Roshan <c.pix...@...> 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...@...>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...@...> 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 >
