store the URL / path to the resource in the db, along with anythign else relevant eg running time, encoding and so on
store any keywords etc in the db.. probably as a sub table.. depends on how many key wprds you want to use/allow/need

store the video clips in a location visible to the server / outside world