Chapter Five- Textbook Notes.docx

2 Pages
Unlock Document

Western University
Computer Science
Computer Science 1032A/B
Diane Goldstein

CompSci 1021a Taylor Ward December 2011 Chapter Five: Database and Content Management Content: - Related to intellectual property: form of creative endeavour that protected through trademark, patent, copyright, industrial design, or integrated circuit topography; varies by industry - Organizations may store data, documents, spreadsheet, presentations, web pages, text from blogs and discussion boards, graphics, video files, audio files Organizing Content - Content management challenge: processing and storing the right content, getting the right content to right person in right format at right time Content Management - Management of content: Database Management Systems (DBMS) effectively and efficiently storing and processing data - Presentation of content: Content Management System (CMS) organizing documents, seek out documents and organize access Spreadsheet vs. Database - Keeping track of things: spreadsheets lists of single concept, databases keep lists involve multiple things Relational Database - Conceptually simple, easy to understand, relationships aren’t predefined, database can evolve as required, relationships are implied in the data A Database - Self-describing collection of integrated records - Hierarchy of Data Elements: Byte is character of data, grouped into columns, columns or groups grouped into rows (also called records), group of similar rows or records is called table or file Components of Database: tables or files + relationships among rows in tables + metadata (structure of database) Relationships among Records - Primary keys: columns that identify unique row in table, each table has key - Foreign keys: primary keys from a different table - Relational database: databases using tables, primary keys and foreign keys Metadata - Databases are self-describing: contain description of its content - Metadata is data that describes data, makes databases more useful and easier to use Database Management System (DBMS) - Program creates, processes, administers database - Usually licensed from vendors (Microsoft Access, Oracle, DB2, MySQL) - Different from database (software program vs. collection of tables, relationships, and metadata) - Function: create tables and relationships in data
More Less

Related notes for Computer Science 1032A/B

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.