Using wordpress as a searchable database?

Hello,

My name is Ricky. I currently run a wordpress site for my personal business “on the side job”, and am now looking to see if I could build a searchable database for my “day job”.

I have roughly 70,000 PDF documents which I search through using Google Desktop. I know what I’m looking for, so it’s fairly effective. I’d like to make the system more user friendly though, so others can search for documents on their own.

I’ve attached 2 files. The first is the front end example, where I’d like to have some drop down menus (or something similar) where the users can choose the search requirements. The second is an example document.

The way I see this working is that the documents will have organized meta data, perhaps a csv. file where the search data can be organized under corresponding headers to the search, such as “Product Series” or “Product Type”. It’ll take some time to populate the database and fill in all the back end data, but in the end it’ll be worth it!

So, once the user fills in the search, then the “search engine” will sort through the .csv files and show only the files with matching search requirements.

My question is – am I crazy, or is this actually possible to do with wordpress? Each document could be a “blog post”, therefore the search engine would be looking for individual “blog posts” and then listing the matching ones.

Thanks so much for your help 🙂

Ricky