http://www.4shared.com/file/3_BIOAIK/MusicDB.html
I work as a Database Developer and I am hobby musician. Combining those two interests I once put some effort into creating a database around ARR's music. My goal was to capture all the information that is usually associated with a typical ARR's album (Track Lists, Singers, Musicians, Engineers involved, Studios involved etc). But besides this, I also wanted something along the lines of Music Genome Project, wherein some musical attributes are identified in each ARR's song/album. And the third goal (though, I assume it would be a bit hard to reach) is to identify the gear used in ARR's songs. This would include the software used, the different kinds of Mics used, Effect Boxes (Equalizers, Compressors etc) used and so forth. The first goal of getting various credits involved is the one that can be easily done. This is usually available in different formats and that could be massaged per the DB design. The second goal of associating some musical attributes can be a bit hard and involves some work from musically knowledgeable people. I did some as sample data and we could proceed along those lines (please look into the attachment). The third goal of getting all the gear used might be the toughest one (and to an extent could be ARR's trademark secrets, so cannot be let known to general public), but if any data/information is be available through ARR's associates or other knowledgeable people, it would add a great deal of knowledge. In the west we see a great deal of information being shared on the gear being used and how. I would love to see that kind of information coming out of our Indian musicians and studios. ARR himself mentions some of the gear/production techniques he uses in his interviews with Music vendors (for example, on Apple website, ARR mentioned he processed drums in Ringa Ringa through Native Instruments Guitar Rig and so on). Anyways, I came up with a scratch design some time back. Attached in this email are the various files regarding this (will explain what each file is shortly). The third goal which I mention above is not yet included in this design. But the other two are in there, atleast in a first draft format. The attachment in the link (http://www.4shared.com/file/3_BIOAIK/MusicDB.html ) has the following: 1. ARRMusic.bak - This is the backup file of the database I built in SQL Server 2000. 2. MusicDB ERD.vsd - This is the ERD (MS Visio format) of the above database. This should give you an idea of what I tried then. 3. Object Script.sql - A Simple script used to create the tables and some sample views 4. Sample Data Entry.sql - A script I used to enter some sample data (most of this data is accurate, some changes might be required here and there). 5. Sample Queries.sql - Some typical queries 6. Export - Sample Data.xls - An export of the sample data entered above in excel format 7. Export - Sample Queries.xls - Some sample data queried based on the data entered. Please let me know if I can be of any assistance in this matter. Or if this design would be of any use (we can change as needed). Regards, Sam
