Computer Science 1032A/B Lecture Notes - Lecture 3: Database, Database Application, Content Management

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Louis Magguilli

Document Summary

Presentations, web pages, text from blogs and discussion boards, graphics, video files, audio files. Challenge is not collecting, but distributing and presenting the content. Is processing and storing the right content and getting the right content to the right person in the right format at the right time. Dbms- effectively and efficiently storing & processing data. Cms- organizing documents and seek out documents & organize access. Keep lists of single concept i. e records simple lists of student grades. Keep lists that involve multiple themes i. e records students grades, emails, and office visits. Administers database: usually licensed from vendors. Databases are just collection of tables, relationships, and metadata: forms reports queries. Standard functions: application programs that process a database. Process logic specific to business need enables database processing over. Dbms software program reads data, inserts data, modifies data, deletes data. Use in administration for security (levels), access to the database, backup, improve performance, and archival of data no longer needed.