It seems to me that many of us are going to try to collect data about YouTube videos independently. As the season picks up it is going to become a huge task to keep up with the data. Can we do this together? Can someone build a Web application that will feed data into a relational database? The database would contain two tables -- a table of video URL's and a table holding relationships between rows in the first table. It could, of course, be more elaborate, including a table of tags and a table holding relationships between the "video" table and the "tag" table. I could help design the relational database but i don't have the programming skills to build the Web application and implement the database. There would need to be some query buttons on the Web application. One would be to add a video. The videos do not appear to have date of upload available. The number of views changes every day. Some people may make their video a response (child) of multiple other videos. Some videos will be deleted by the authors. Do we want to keep track of authorship of videos? Some authors may upload many videos. This is a huge effort, especially if we do the tagging. I wonder if YouTube makes available any Web service that we might be able to tap into to automate some of the updating of the database. We will need a relational database if we hope to build a social network model.
Comments (1)
Bruce Neubauer said
at 8:43 pm on Jun 22, 2008
Under "Utilities" on this wiki there is a link to TubeKit for crawling YouTube. It looks pretty challenging to set up.
You don't have permission to comment on this page.