A system and method for extracting advertising segments from a video source, stores the extracted segments in a stractured database to be used in various applications. The system for extracting advertising, or other promotional segments, from a video signal converts the video signal to a digital format, if requied, stores the video signal in a database, scans the video signal for the presence of predetermined characteristics and uses the characteristics to locate a start and an end of each segment.