Revisiting this in case someone has a suggestion:
I've been asked to either create or find a system that meet the following requirements...
1) Allow upload of video files - Current solution: PHP to upload to a directory above the web root, and then I'll verify users before allowing access to stream.
2) Tag the files with meta info about the participant in the video (these are surveys) for later searching. - Current solution: keyword text area separating items by ";" then parsing items into a "keywords" table in DB for searching later.
3) Transcribe the text for a full text search later, so if the participant states, "I like to swim, bike, run" later a search for "run" would find this result (triathlon would have probably been entered in the meta fields) - Current solution: use service to do transcriptions. Then upload text in a full text indexed field.
The info will be made available for clients with subscriptions, so in the example above, companies that deal with swimming, biking, running may be able to get this result, but ice cream vendors may not. - Current solution: assign categories to subscribers as well as videos during the sign up and check in phases. Make sure they match.
Seems like there will be a lot of manual setup, so if anyone has any better ideas for automating or controlling, please let me know.
Thanks for suggestions.