January 7, 2011 at 12:37 pm
What is the best Schema to use for a 'document tracking' database?
January 7, 2011 at 12:59 pm
Are you asking for a logical design for the database?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 7, 2011 at 1:03 pm
yep
January 7, 2011 at 1:33 pm
I'd say start with your business needs and work from there. If you want someone to design it for you, hire a contractor.
There are off-the-shelf products that do that kind of thing too.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 7, 2011 at 1:34 pm
Do you think Documentum or SharePoint are the best document management tools? Hard to say right? But they each one use a different schema, so saying, "This schema is best for document management" is pretty hard to do. I'd suggest looking around on the internet at the various types of designs that are out there and see which one is more in line with the requirements you have to meet.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 7, 2011 at 1:58 pm
Okay thanks guys
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply