Chapter 5 - Database and Content Management.docx

4 Pages
Unlock Document

Computer Science
Computer Science 1032A/B
Diane Goldstein

Chapter 5 – Database and Content Management ­ DBMS: Database Management System What is Content? ­ content is property ­ closely related to intellectual property  form of creative endeavor that can be protected through a trademark, patent, copyright, industrial design or integrated circuit topography ­ varies by industry ­ challenge is to present it appropriately, not just collect and distribute How can Content be Organized? ­ challenge in content management is indexing or cataloguing the right information, processing and storing it and then getting it to the right person at the right time ­ all data in computing systems are reped by bytes  data management focuses on how to store and process bytes ­ presentation of content through company websites o handled through a series of steps supported by software o web content management systems have been developed to help companies organize this process o when employee wants to place content or website: 1. Access web content management system (CMS) 2. Loads raw content into web CMS system 3. Copy editor reviews document and makes changes 4. Passes content onto layout artists, prepare content for presentation ▯ Content and presentation stored with help of DBMS 5. Manager in charge will review content and presentation and publish work to live website o web CMS helps manage each step of the process and enables a company to standardize the look and feel of a website and control the info available to customers and ees ­ CMS grown beyond original role of organizing documents for corporate websites ­ Systems now actively seek out documents located across an organization and automatically manages access to content ­ Documents can be categorized and searched by CMS (ex. word doc, html, etc) increased organization ­ Can also handle document archiving and the increase use of electronic files for document management What is the Purpose of a Database? ­ keep track of things that involve more than one theme ­ fig 5-1  single theme; student grades ­ fig 5-2  multiple themes: student grades, emails, office visits ­ lists that involve a single theme can be stored in a spreadsheet, lists that involve multiple themes require a database What Does a Database Contain? ­ database: self describing collection of integrated records ­ byte: character of data ­ bytes are grouped into columns  ex. Student number, student name ­ columns are also called fields ­ columns/fields are grouped into rows also called records ­ fig 5-4 ­ fig 5-5  database is a collection of tables + relationships among the rows in those table + special data called metadata: describes structure of the database Relationships among Records ­ Fig 5-6 ­ Values in one table relate rows of that table to rows in a second table ­ Key: column or group of columns that identifies a unique row in a table  will only appear once ­ Every table must have a key ­ Sometimes more than one column is needed to form a unique identifier  ex table called city; (city, province) is needed because a city name can appear in more than one province ­ Foreign key: columns that fulfill a role like that of student number in email and office visit  because such columns are keys but they are keys of a different (foreign) table from the one in which they reside ­ Relational database: databases that carry their data in the form of tables and that represent relationships using foreign keys ­ Relation aka table Metadata ­ database is self describing  contains within itself, a description of its contents aka contain not only data, but data about the data in the database ­ metadata: data that describe data ­ fig 5-7 ­ field name  contains name of the column ­ data type  shows type of data the column may hold ­ description  contains notes that explain the source or use of the column ­ Field properties  more metadata ­ To find out what a database contains, we look at the metadata inside the database What is a DBMS and What Does it Do? ­ database all by itself is not useful; database data is correct but in raw form is not useful ­ fig 5-8 ­ database application system: o consists of: o user o database app
More Less

Related notes for Computer Science 1032A/B

Log In


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.