I am a Musical Director working on a cruise ship and I have a Windows 7 folder with in excess of 19,000 files, which are all music arrangements in PDF format (an arrangment is a collection of parts for different instruments, eg Piano and Bass and Drums and Trumpet and Sax and Trombone. The last three are collectively known as ‘horns’ (short for ‘horn section’) The files are all named according to the following standard:
Name (composer) - description - vocal - Arranger.pdf
the description field is used to identify the numer of parts to the arrangement, eg “13 Horns”, “Piano Only”, “Rhythm section only”, etc.
The ‘vocal’ field signifies whether this is a vocal arrangement; if it’s an instrumental arrangement then the field is blank and the “-” separators are not included.
I want to be able to search all this data and I think I need to create a searchable database to do it. I’m aware that Windows Search will look at all the files and search for whatever my search term is, but I want to go further and have 2 or 3 search parameters, possibly searching on every field. I also want to include an element of fuzzy logic.
Can anyone tell me how to go about creating a database where each record is generated from these filenames?
And what clever things can I do with the database once created?
Thanks for your help.