Oracle9i Application Developer's Guide - Large Objects (LOBs) Release 1 (9.0.1) Part Number A88879-01 |
|
LOBs Case Studies, 3 of 3
Design and Build a LOB and interMedia Based Web Site. The web site must include video 'thumbnails' where by users can click on a specific thumbnail to see a short 6 - 8 second video clip.
Here are some ideas for setting up your LOB-based web-site:
create table video_clips ( move_id integer, thumbnail ordsys.ordimage, movie ordsys.ordvideo);
See Note 2.
Your disk space depends on the frame size, frame rate, and compression settings. One second of video, at 720x480 pixels, 30 frames per second (fps), takes roughly 3.6MB of disk space. 720x480 is pretty big for the web but should be fine if this is on an intranet. 30 fps looks very smooth but might not be necessary. Test a sample to see what 320x240 looks like. Check if there is sufficient detail present. If not, increase the resolution until you are satisfied.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|