kingcastle
asked on
Database for files
Hi
Just wondering if anyone could advise of a database system out there that can manage adobe files.
We would have 10's of thousands of abode cad files stored on windows shares but it's becoming a nightmare for the cad users to find anything.
Is there a database solution out there that could house these files and add some custom attributes to the data that we would use?
Thanks
Just wondering if anyone could advise of a database system out there that can manage adobe files.
We would have 10's of thousands of abode cad files stored on windows shares but it's becoming a nightmare for the cad users to find anything.
Is there a database solution out there that could house these files and add some custom attributes to the data that we would use?
Thanks
IMHO files belong into a file system, not a DB. Any of the available DBMS is able to manage additional info and the path name of the file, and a simple DB application (e.g. Access) can be used as frontend without much of effort.
most of the database systems can store these files, for example in case of sql server, you can use FileStream
ASKER
What DBMS would you think of ?
So can you link a database front end to a windows folder structure for searching and extra attribute purposes?
Cheers
So can you link a database front end to a windows folder structure for searching and extra attribute purposes?
Cheers
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you - is the article attached?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Consider adding tags to each file. Everyone should agree on the words to be used in tags.
Some Ideas on using tags
http://www.makeuseof.com/answers/organize-files-tags-folders-windows-7/
http://www.techrepublic.com/blog/windows-and-office/tag-your-files-for-easier-searches-in-windows-7/
This free ELYSE program might be all you need
http://www.cnet.com/how-to/how-to-organize-all-your-files-using-tags/
Here are some general ideas on organising your files
http://www.seagate.com/do-more/organizing-your-digital-files-master-dm/
When you have settled on a tagging system, then the boring bit begins .... tagging thousands of files and probably deleting hundreds of duplicates and unnecessary intermediate versions in the process.
Some Ideas on using tags
http://www.makeuseof.com/answers/organize-files-tags-folders-windows-7/
http://www.techrepublic.com/blog/windows-and-office/tag-your-files-for-easier-searches-in-windows-7/
This free ELYSE program might be all you need
http://www.cnet.com/how-to/how-to-organize-all-your-files-using-tags/
Here are some general ideas on organising your files
http://www.seagate.com/do-more/organizing-your-digital-files-master-dm/
When you have settled on a tagging system, then the boring bit begins .... tagging thousands of files and probably deleting hundreds of duplicates and unnecessary intermediate versions in the process.