Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Structured vs Unstructured Choice

593354Jan 5 2009 — edited Jan 6 2009
Our company is at the initial phases of replacing all our invoice storage from PDFs into XML Db. This is roughly 80,000 invoices created and stored monthly, printed immediatly with moderate web access for historical reference. The schema definition is subject to change periodically as new fields and requirements dictate additional information be contained on the invoice. Past data stored will never be updated, but again, queried based on 3 nodes (cutomer, date and invoice number) and also searched via full text for keywords predicated on 1, 2 or 3 of the same nodes.
The question is based on these requirements, would structured or unstructured storage be a better fit. I have read the appropriate documentation that compares the two approaches, and have not reached a clear decision. We already know that we will want to partition this data (by month) and that will require upgrading to 11g. Any recommendations with appropraite rationale would be appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2009
Added on Jan 5 2009
5 comments
945 views