Image | Audio | Video |
---|---|---|
X |
µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡ ºñµð¿À ³»¿ëÀ» ÀúÀåÇÕ´Ï´Ù. ºñµð¿À ¼Ò½º´Â Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ, Ŭ¶óÀÌ¾ðÆ® ÆÄÀÏ ¶Ç´Â ¼¹ö ÆÄÀÏ¿¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ºñµð¿À´Â BLOBÀ¸·Î µ¥ÀÌÅͺ£À̽º Å×À̺íÀ̳ª, ¼¹ö ÆÄÀÏ(µ¥ÀÌÅͺ£À̽º Å×À̺íÀÌ ÂüÁ¶ÇÏ´Â)¿¡ ÀúÀåµÉ ¼ö ÀÖ½À´Ï´Ù. ºñµð¿À ¼Ò½º´Â DB2 Video Extender°¡ ÀúÀ念¿ª¿¡ ´ëÇÑ ¼Ó¼ºÀ» Ç¥½ÃÇÏ´Â °æ¿ì¿¡´Â Áö¿øµÇ´Â Çü½ÄÀ¸·Î ÀÖÀ» ¼ö ÀÖ°í, ¶Ç´Â ¼Ó¼ºÀÌ UDF¿¡ ÁöÁ¤µÇ¾î¾ß ÇÏ´Â °æ¿ì¿¡ Áö¿øµÇÁö ¾ÊÀº Çü½ÄÀ¸·Î ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù.
Include ÆÄÀÏ
dmbvideo.h
±¸¹®
¹öÆÛ³ª Ŭ¶óÀÌ¾ðÆ® ÆÄÀϷκÎÅÍ ³»¿ë ÀúÀå
>>-DB2Video--(--dbname--,--content--,--format--,----------------> >----target_file--,--comment--)--------------------------------><
±¸¹®
¼¹ö ÆÄÀϷκÎÅÍ ³»¿ë ÀúÀå
>>-DB2Video--(--dbname--,--source_file--,--format--,--stortype--,--> >---comment--)-------------------------------------------------><
±¸¹®
¹öÆÛ ¶Ç´Â Ŭ¶óÀÌ¾ðÆ® ÆÄÀϷκÎÅÍ »ç¿ëÀÚ Á¦°ø ¼Ó¼ºÀ¸·Î ³»¿ë ÀúÀå
>>-DB2Video--(--dbname--,--content--,--target_file--,-----------> >----comment--,--attrs--,--thumbnail--)------------------------><
±¸¹®
¼¹ö ÆÄÀϷκÎÅÍ »ç¿ëÀÚ Á¦°ø ¼Ó¼ºÀ¸·Î ³»¿ë ÀúÀå
>>-DB2Video--(--dbname--,--source_file--,--stortype--,--comment--,--> >---attrs--,--thumbnail--)-------------------------------------><
¸Å°³º¯¼ö(µ¥ÀÌÅÍ À¯Çü)
¸®ÅÏ °ª(µ¥ÀÌÅÍ À¯Çü)
ºñµð¿À ÇÚµé(DB2VIDEO)
¿¹
Anita Jones¿ë ºñµð¿À Ŭ¸³ÀÌ ÀÖ´Â ·¹Äڵ带 employee Å×ÀÌºí¿¡ »ðÀÔÇϽʽÿÀ. ºñµð¿À ¼Ò½º´Â Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ¿¡ ÀÖ½À´Ï´Ù. BLOBÀ¸·Î Å×ÀÌºí¿¡ ºñµð¿À Ŭ¸³À» ÀúÀåÇϽʽÿÀ.
EXEC SQL BEGIN DECLARE SECTION SQL TYPE IS BLOB (8M) vid; EXEC SQL END DECLARE SECTION; EXEC SQL INSERT INTO EMPLOYEE VALUES( '128557', 'Anita Jones', DB2VIDEO( CURRENT SERVER, :vid, 'MPEG1', CAST(NULL as LONG VARCHAR), 'Anita''s video'));
Robert SmithÀÇ ºñµð¿À Ŭ¸³ÀÌ ÀÖ´Â ·¹Äڵ带 employee Å×ÀÌºí¿¡ »ðÀÔÇϽʽÿÀ. ºñµð¿À ¼Ò½º´Â ¼¹ö ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù. employee Å×ÀÌºí ·¹ÄÚµå´Â ÆÄÀÏÀ» Áö½ÃÇÒ °ÍÀÔ´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION; long hvStorageType; EXEC SQL END DECLARE SECTION; hvStorageType = MMDB_STORAGE_TYPE_EXTERNAL; EXEC SQL INSERT INTO EMPLOYEE VALUES( '384779', 'Robert Smith', DB2VIDEO( CURRENT SERVER, '/employee/videos/rsmith.mpg', 'MPEG1', :hvStorageType, 'Robert''s video'));
ºñµð¿À Ŭ¸³ÀÌ ÀÖ´Â ·¹Äڵ带 µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡ »ðÀÔÇϽʽÿÀ. ¼¹ö ÆÄÀÏ¿¡ ÀÖ´Â ¼Ò½º ºñµð¿À Ŭ¸³Àº »ç¿ëÀÚ Á¤ÀÇ Çü½ÄÀ» °®½À´Ï´Ù. ¼¹ö ÆÄÀÏ¿¡ ÀÖ´Â ºñµð¿À ³»¿ëÀ» À¯ÁöÇϽʽÿÀ.(µ¥ÀÌÅͺ£À̽º ·¹ÄÚµå´Â ÆÄÀÏÀ» Áö½ÃÇÒ °ÍÀÔ´Ï´Ù.) ºñµð¿À¸¦ ³ªÅ¸³»´Â ½æ³×ÀÏÀ» ÀúÀåÇϽʽÿÀ.
EXEC SQL BEGIN DECLARE SECTION; long hvStorageType; struct { short len; char data[400]; }hvVidattrs; struct { short len; char data[10000]; }hvThumbnail; EXEC SQL END DECLARE SECTION; MMDBVideoAttrs *pvideoAttr; hvStorageType = MMDB_STORAGE_TYPE_EXTERNAL; pvideoAttr=(MMDBVideoAttrs *)hvVidattrs.data; strcpy(pvideoAttr>cFormat,"Formatv"); pvideoAttr.len=sizeof(MMDBVideoAttrs);
·
·
·
/* Generate thumbnail and assign data */ /* in video structure */
·
·
·
EXEC SQL INSERT INTO EMPLOYEE VALUES( '128557', 'Anita Jones', DB2VIDEO( CURRENT SERVER, '/employee/videos/ajones.vid', :hvStorageType, 'Anita''s video', :hvVidattrs, :hvThumbnail) );