Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 02 Aug 2001 @ 19:36:27 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

Steve Hummel
Sr. Product Manager
Teradata, a division of NCR

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020