I agree fully! I think, we need to think about what we want out of this with the future in mind. More of a brain storming session to have a framework of the database we want/need. I also think that we should try and keep these e-mails separate to the group mail until a framework is finalised in order to help focus on the issues.
________________________________ From: Gopal Srinivasan <catchg...@gmail.com> To: arrahmanfans@yahoogroups.com Sent: Tue, 24 August, 2010 15:25:50 Subject: Re: [arr] songs database 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 > >