Did you know that the upcoming version release of SQL Server 2008 has some new datatypes that are going to be available? One of the areas with a number of changes are the datatypes available for storing data related to dates and times in a database.
As I began thinking on some of the impact the following application of this functionality came to mind. Imagine creating a database of your favorite movies and favorite clips within those movies. The new TimeOnly datatype in SQL would allow you to pinpoint and store the specific start and end times within the movie playback that is your favorite scene.
Similarly, image creating a database of your music library and being able to tag each song with the time counts of when each verse starts or chorus, etc.
By storing these types of time point information sets, you could dynamically edit and mash-up a video using a start-stop time for your favorite video clips, and overlay a separate audio track from the choruses of a group of songs in your song library.
As I’m typing this entry I also begin thinking about the opportunity for advertisers to embed advertising information that would synchronize and display as you viewed a video. So, as you watch a TV show online, when the actors got into their car, the ad displayed in the sidebar would switch to a car dealership in your area.