Database design question - URGENT [message #101814] |
Thu, 18 October 2001 12:59 |
Sherry Irani
Messages: 1 Registered: October 2001
|
Junior Member |
|
|
I have a requirement wherein i need to edit and save word documents and associate them with records in Oracle database table. My question is what are the pros and cons of storing the doc as a BLOB field in the database Vs. storing it in the file system as a word document and associating it through another table that links the rec to the location of the document.
----------------------------------------------------------------------
|
|
|
Re: Database design question - URGENT [message #101844 is a reply to message #101814] |
Mon, 29 October 2001 18:48 |
JRW
Messages: 8 Registered: October 2001
|
Junior Member |
|
|
1) If you use IFS, the document is part of the database and can be backedup as part of DB
2) Other than that, I personally don't see any other advantage
----------------------------------------------------------------------
|
|
|