VideoWeb/Models & Controllers

CS290F Fall 2006 - UCSB Computer Science - Thorsten von Eicken

Home | Overview | Models & Controllers | Critical Paths | SQL Statements | Performance | Multi-Server Performance

Models/Tables

• Video: (Title, User, Length, Rating, Tags, Comments, etc...) Keeps information about the videos and validates the data.
• Tag: (Name) A category for videos.
• User: (Comments, Favorite Videos, Favorite Categories, etc...) Keeps a profile specific for a user.
• Comment: (Comments, User, Timestamp) A list of comments pertaining to videos
• Categorization: (Video Id, Tag Id) The association between videos and tags.
• [Optional] User_Tag: (User Id, Tag Id) The association between users and tags.
• [Optional] Favorites: (User Id, Video Id) A list of a user's favorite videos.

Controllers

• Storage: Handles the uploading of a video.
• Browse: Handles the group and individual listing/editing/searching of the videos.
• Review: Handles the adding/editing/deleting of comments for a video.
• Account: Create/Search user accounts.
• [Optional] Preference: Handles user preferences (favorite videos, last viewed videos, etc...).