Archives of the TeradataForum
Message Posted: Thu, 02 Aug 2001 @ 19:36:27 GMT
| Subj: || || Re: Object Linking |
| From: || || Steve Hummel |
In a "text mining" project I'm working on right now, we are storing both document metadata, and the documents themselves in Teradata
(V2R4). We use one table for the metadata and a separate table for the documents. The metadata can be used to store things like document
id, title, author, type (e.g., pdf, etc.). The document blobs are stored in 64K VARBYTE "chunks" with a document id and sequence number
which is used in the "order by" clause to ensure that the document body is "pasted back together" for the calling application. Feel free to
email if you'd like more information.
Also, you may want to refer to documentation on the Teradata "Blob Server" that ships as part of the CLI development kit.
Sr. Product Manager
Teradata, a division of NCR