I am a novice to DB design, so upfront please excuse any ignorance on my part. I would like to know what is the best solution (from a high level) given the below scenario.
Over 50, 000 documents exist in a windows tree directory. Due to directory size and hierarchal structure, people are finding it more and more difficult to locate documents they are looking for. The two most used search tools in locating a document are either the Windows search tool or asking someone else.
I see an opportunity where a SQL DBMS system can be more effective than a file structure based on search capabilities. However, I’m a little fuzzy on how to implement this via the relational data model. Must attributes manually be collected against each and every document? Do attributes have to be the same for all documents? Is there a more simple idea to this?
Any information provided would be of great assistance.