2000 - 使用新发布的 IBM Informix 15 将 Smartblob 文档外部化.pdf

《2000 - 使用新发布的 IBM Informix 15 将 Smartblob 文档外部化.pdf》由会员分享，可在线阅读，更多相关《2000 - 使用新发布的 IBM Informix 15 将 Smartblob 文档外部化.pdf（45页珍藏版）》请在三个皮匠报告上搜索。

1、Orlando,FLOctober 69IBM TechXchange 202520002000Externalize smartblob documents using IBM Informix 15Vicente SalvadorDEISTER S.A.Externalize smartblobdocuments using IBM Informix 15What you will learn in this session0102030405SmartblobsExternal smartblobsReal case migrationHigh availability ESBExten

2、ded track:internalsIBM TechXchange|2025 IBM CorporationWhat you will learn in this session0102030405SmartblobsExternal smartblobsReal case migrationHigh availability ESBExtended track:internalsIBM TechXchange|2025 IBM CorporationWhy to use Smartblobs?Typically used to store documents such as PDFs,Ex

3、cel files,XML files,and others.Large objects storageAllow access to thisdocuments from anyapplication with databaseconnection permission.SQLDo not require additional infrastructure and is fully integrated with database serverArchitectureIBM TechXchange|2025 IBM Corporation4Smartblobs are a useful In

4、formix feature for storing large amounts of data linked to a row in a table.Smartblob is composed of three data structures:LOHandleLOHandle is present in each row and each BLOB/CLOB column.Its an structure of 76 bytes(Content depends of Big or Low Endian format of platform)MetadataMetadata is stored

5、 in metadata storage pre-allocated in the smartblobspace,its an structure of around 512 bytes.Each smartblobspace can have one metadata area where the translation of LOHandle base info is translated into physical storage pointers.Acts as i-node in filesystems.Each node has a counter of how many LOHa

6、ndlers are pointing to this blob.When this counter reach 0,the blob content and metadata can be can be erased.DataData is the smartblob content.Its stored physically in the data block of smartblobspace at an offset and with a size.The size depends of the smartblob data content.Some smartblobs can ha