I am not sure it would lend itself to fans for querying.
Warm Regards ~~~~~~~~~~~~~~~ Vinayak http://www.flickr.com/photos/rightplacerighttime/ On Sun, Aug 22, 2010 at 6:27 AM, Gopal Anandan <agop...@yahoo.com> wrote: > > > Why not create one on wiki? > > --- On *Sat, 21/8/10, Vinayakam Murugan <mvinayakam.li...@gmail.com>*wrote: > > > From: Vinayakam Murugan <mvinayakam.li...@gmail.com> > Subject: [arr] Song Database Structure [1 Attachment] > To: arrahmanfans@yahoogroups.com > Date: Saturday, 21 August, 2010, 3:56 PM > > > > > Hello Friends > > I decided to change the Subject line to make it more relevant. > > Here is a scratch Db Structure. Like I have seperated Films / Albums from > Songs, we should seperate Singers & Awards also from Songs. However that > could be better achieved through a Db than excel. This sheet is for > illustration purposes only. Further Db normalization is required. > > > Warm Regards > ~~~~~~~~~~~~~~~ > Vinayak > > http://www.flickr.com/photos/rightplacerighttime/ > > > On Fri, Aug 20, 2010 at 8:02 AM, raj > <arr_naga...@yahoo.com<http://mc/compose?to=arr_naga...@yahoo.com> > > wrote: > > > > Ok..I make a living by Databases and Databases only :) > I am a DBA. So yes..I can help. As a first step, it would be great > if someone can comeup with a excel containing the following fields. > > 1) Film_name > 2) Song_name > 3) Singers_name ( comma seperated ) > 4) date of release > 5) Genre of the song ( Western,fusion,carnatic classical,quawalli ) > 6) Director of the film > 7) Lead actor > 8) Actress > 9) Ragaa of the song ( if possible ) > 10) Language > 11) is_dubbed_film ( yes/no) > 12) Producer of the film > 13) Lyricst. > 14) Miscellaneous. > > You can add few more fields if you feel like. I am keeping it simple > as of now and we can change the DB design( (De)Normalize ) depending upon > our needs. As a first step, someone can create a document on google docs and > start updating the same. As its on Google docs, most of us can contribute > and we can get these details soon. Once the data > collection is complete, DB design can be adjusted and we can start working > on the application. > > > --- In > arrahmanfans@yahoogroups.com<http://mc/compose?to=arrahmanfans%40yahoogroups.com>, > Indmov Buff <indmovb...@...> wrote: > > > > Fantastic! The majority vote is for a database it seems. > > > > I don't have any skills in database but open to learning. Also, I'd be > happy to > > allocate time to sit through the group mails for the information that > will make > > it a good database. I am mainly interested in the research aspects of the > work > > involved in finishing this database that we are after. So happy to > contribute in > > the form getting the data together , more on the creative side rather > than the > > technical side. So I guess, we should start off with a list of people who > are > > willing to help. And this has got to be a bit of a commitment given that > we will > > need to co-ordinate with members around the world with different work and > social > > commitments. I am up for it! > > > > > > > > ________________________________ > > From: Gopal Srinivasan <catchg...@...> > > > To: > > arrahmanfans@yahoogroups.com<http://mc/compose?to=arrahmanfans%40yahoogroups.com> > > Sent: Wed, 18 August, 2010 16:51:43 > > Subject: Re: [arr] Database for group of contents from useful e-mails > > > > > > Glad to see this outpouring of enthusiasm. Hopefully, it will sustain. I, > among > > others, have tried various forms of this previously that did not > culminate in > > anything (beyond my discography, which too hasn't been updated in a year) > as > > time turned out to be a major constraint. Some of the modes we have > considered > > includes static web lists, wikis and databases. In my opinion, a database > at the > > backend is probably the best with front end forms for querying. Depending > on how > > simple or complex it turns out, something like Zoho Creator might work > too. > > What's needed is the involvement of people who are well versed with > database > > design AND those that can source information. If we can do a good enough > job of > > this there is potential to make it official. Next steps perhaps include > forming > > a core team, identifying the types of information we want stored, design > the > > schema and then create and populate. > > > > > > On Wed, Aug 18, 2010 at 06:31, Roshan <c.pix...@...> wrote: > > > > > > > > > >I can work on the technical side of it. (Development and design). But > will > > >really appreciate if someone can assist as well. I will need some help > from you > > >guys about collecting the info from the group. it seems like a lot. but > if we > > >collectively do it, we can finish it in within a month or two (including > the > > >development). > > > > > >I will also need some input in choosing the domain > > > > > >I thought of some > > > > > >ARDB.in > > > > > >arrinfo.org > > > > > >i tried some domains that has ar rahman in the name, but they all seem > to have > > >been taken. > > > > > >As for hosting and domain, I don't mind paying for it. I have a > dedicated server > > >where I host my clients. > > > > > >so, to sum it up > > > > > >1. website as a database of information on ar rahman and his music. > > > > > >2. categorized, search-able contents like Reviews, Information, Singers, > > > >Instrumentalists, Instruments Used, Places performed, Debuts, quotes, > interviews > > >etc. > > > > > >3. Quality contents from the group. like awesome reviews of AJ and > Gayathri and > > >the rest of those people who write good contents. of course, with > credits and > > >links to their blogs / websites etc, if they have any. > > > > > >please contribute your suggestions. > > > > > > > > > > > > > > > > > > > > >On Wed, Aug 18, 2010 at 4:14 AM, Indmov Buff <indmovb...@...> wrote: > > > > > > > > >>Me too! Like where we can sort by singer name or raaga name etc. Just > info. IT > > >>savvy people out there- what's the best way to go about this? > > >> > > >> > > >> > > >> > > >> > > >> > > >> > > ________________________________ > > From: Roshan <c.pix...@...> > > > >>To: > > >>arrahmanfans@yahoogroups.com<http://mc/compose?to=arrahmanfans%40yahoogroups.com> > > >>Sent: Tue, 17 August, 2010 21:45:59 > > >>Subject: Re: [arr] Database for group of contents from useful e-mails > > >> > > >> > > >>That gives me another idea. how about a website with all the info about > AR > > >>Rahman, his singers, his songs, Genres, and all the other info we find > from our > > >>group ? we can make it as an extension of this group. there won't be > any forum > > >>or anything.. just info. > > >> > > >>I would love to do it. > > >> > > >> > > >>On Tue, Aug 17, 2010 at 6:53 PM, ARRvind <arr_arv...@...> wrote: > > >> > > >> > > >>>Nice initiative.! Would mean a lot to this group.! Lets get Gopal > bro's comment > > >>>on this! > > >>> > > >>>--- On Tue, 8/17/10, Indmov Buff <indmovb...@...> wrote: > > >>> > > >>> > > >>>>From: Indmov Buff <indmovb...@...> > > > >>>>Subject: [arr] Database for group of contents from useful e-mails > > >>>>To: "A R" > > >>>><arrahmanfans@yahoogroups.com<http://mc/compose?to=arrahmanfans%40yahoogroups.com> > > > > >>>>Date: Tuesday, August 17, 2010, 12:54 PM > > >>>> > > >>>> > > >>>> > > >>>> > > >>>>Hi Gopal and the rest, > > >>>> > > >>>> > > >>>>I have read many e-mails containing useful data in this group before. > Just like > > >>>>Arvind's unique list of intro songs for singers there have been other > lists such > > >>>>as Mother songs, child singers lists, raaga based lists and several > other > > >>>>extremely interesting lists. I strongly feel that we should have all > of this > > >>>>documented as part of the group? Any suggestions on how this can be > done? > > >>>>Database? I am happy to put in time to dig out useful data from old > e-mails. > > >>>> > > >>>> > > >>>> > > >>>> > > >>>> > > >>> > > >> > > >> > > >> > > >>-- > > >>----------------------------------- > > >>http://roshanravi.com > > >>http://ramblingsoul.com > > >>http://cssheaven.org > > >> > > >> > > >> > > > > > > > > >-- > > >----------------------------------- > > >http://roshanravi.com > > >http://ramblingsoul.com > > >http://cssheaven.org > > > > > > > > > > > > > > > > > > >
