Too long; Didn't watch! extracting relevant fragments from software development video tutorials

When knowledgeable colleagues are not available, developers resort to offine and online resources, e.g., tutorials, mailing lists, and Q&A websites. These, however, need to be found, read, and understood, which takes its toll in terms of time and mental energy. A more immediate and accessible resource are video tutorials found on the web, which in recent years have seen a steep increase in popularity. Nonetheless, videos are an intrinsically noisy data source, and finding the right piece of information might be even more cumbersome than using the previously mentioned resources. We present CodeTube, an approach which mines video tutorials found on the web, and enables developers to query their contents. The video tutorials are split into coherent fragments, to return only fragments related to the query. These are complemented with information from additional sources, such as Stack Overow discussions. The results of two studies to assess CodeTube indicate that video tutorials|if appropriately processed|represent a useful, yet still under-utilized source of information for software development.