Business Production and Document Storage

Archive for the ‘Document Storage’ Category

In order to move data between an XML document and a database and vice versa, the data in the database must be mapped to the XML document structure. The simple way, the entire XML document is mapped to a single column in the database. More complex strategies include mapping each element to a corresponding column in the database or mapping the structure of the XML document to the database.

Existing strategies can be broken down into three basic methods:

1 .- Store the entire document in text form as a binary large object (BLOB) in a relational database.

This is a good strategy if the XML document contains static content that can only be changed when the full document is replaced. This strategy is common for document-centric data as these data are typically collected and stored as a unit. Store the entire document in text format is easy to implement since no mapping or translation is needed, but may also limit the search, indexing and granularity of the collection of XML documents. On the other hand, the XML document is kept as it was before being stored, minimizing the work of rearming after collection. Read the rest of this entry »