Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I work at a print shop that has a decent sized archive of old print jobs. Currently, to find a job we have to search the SMB share (on win2000 server), which looks through a few hundred thousand files.

Our job data is organized by: Year>Month>Customer_Name_Job# and then the contents of the job are inside the last folder.

Is there a way to create a database so that we can query a job desc. or job number? Basically just a simple search that is faster than searching with windows search would be great. I tried the windows index service but it only finds .doc file, not folder names or PDFs.

In the future we are planning on making a SQL database where complete info will be entered when the job is created so it is easily queried in the future. I was hoping to throw together something that will make it easier to search older orders.

share|improve this question

2 Answers 2

up vote 4 down vote accepted

I personally wouldn't try to design a database from the ground up for this one -- what you're looking for in the library and archives field would be called a 'digital repository' (one step abstracted from a 'digital library', which usually is only tracking bibliographic items). In the business world, they talk about stuff like Digital Asset Management, but sometimes that's done through registries, not repositories; the different being that in a registry, you only track information about the object, but it only points to the object, rather than storing the authoritative copy of the object.

See if one of these projects could be adapted to fit your needs:

Or, see a larger list of free & open source digital repository software

share|improve this answer
    
WOW.....WOW, that's perfect :) I need to check the others further, but the demo video for Dspace looks amazing! That would even be worth manually re-filing all the old jobs. Thanks!!! –  SkinnyGeek1010 Feb 23 '11 at 13:22
    
@skinny Welcome to the site "If you like this, please vote it up. It's important for the community!" Please see this post for more information. We're glad we could help –  Larry Feb 23 '11 at 18:08

You could use a Document-oriented database for this. You could then create a program in your preferred language to import the existing documents into the db, parsing the folder structure for the metadata (customer, job#, etc).

share|improve this answer
    
Thanks!, I was having trouble googling what I needed, this gives me a great start! –  SkinnyGeek1010 Feb 20 '11 at 16:30

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.