What is Content?
Intellectual property – Creative content that is protected through copyright, trademark, patent, industrial design, integrated circuit topography
Content differs from industry to industry
o Ex. Bank content = account information, advertising = commercials
Computers and the internet have created more types of content and increased distribution ability
o Makes it more difficult to use content effectively
Problem actually lies with presenting content appropriately for shareholders & etc
How can Content Be Organized?
Important issue in content management is cataloguing the right information, processing, storing, & getting information to the right person in the right
format at the right time
Concerned with efficiently and effectively storing/processing bytes of data
Web content management systems today help companies/employees with the presentation of data on websites as the old practice did not provide
consistency and left room for inaccuracy
Content management System
o Located on company website server
o Employee loads raw content copy editor reviews and edits layout artist prepares content for presentation stored in DBMS manager
does final review and publishes
o Current CMSs find documents located across organizations and automatically manages access to content, document archiving, increased use of
Word doc, html pages
What is the Purpose of a Database?
Used for organization and record keeping
Spreadsheets can be used for single themed (simple)
Databases required for multiple themed lists
What Does a Database Contain?
Database = self-describing collection of integrated records.
Byte = character of data
Bytes organized into columns/fields
Columns/fields grouped into rows/records
Group of similar rows/records called table/file
Database (stored on hard disk) = Tables/Files/Relations + Relationships among rows in Tables + Metadata
Relationship among Records
o Key = column/group of columns that identify a unique row in a table
Ex. In e-mail table seeing the student number check student number in student table see when they have visited the office in
office visit table
o Foreign Keys = keys from 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
Non-relational databases have nearly disappeared
o Self-describing – Contains within itself a description of its contents data about the data (metadata)
o Field properties – describes format, default value for Access to supply when new row is created and value constraints for that row
o Always part of a database
What is a DBMS, and What Does it Do?
Database Application System – applications that make database data more accessible and useful
o Forms, formatted reports, queries, application programs
These then call upon database management system to process database tables
Database Management System (DMBS)
o Software used to create, process, administer a database
o Popular DMBSs – DB2 from IBM,