This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: BUS 237 1 Lecture 5: Databases and Content Management BUS 237 Information Systems in Business BUS 237 Agenda • Questions? • Assignment #1 • Group Assignment teams • MyMISLab • Content Management • Organizing content • Relational Databases • DBMS & Database applications • OLTP & OLAP • Using organizational data BUS 237 2 This Could Happen to You • A manager selected Moveable Type application program for the blog • Needs database program to store blog • Consultant suggested MySQL • Network standardized on Oracle • may not be able to run Moveable Type • will require revision of labor estimates • IT resists installing MySQL BUS 237 3 Questions to Consider BUS 237 4 Q1. What is content? Q2. How can content be organized? Q3. What is the purpose of a database? Q4. What does a database contain? Q5. What is a DBMS, and what does it do? Q6. What is a database application? Q7. What is the difference between an enterprise and a personal DBMS? Q1. What is content? • Content is related to intellectual property • a form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography • Varies by industry • Organizations may store data, documents, spreadsheets, presentations, web pages, text from blogs and discussion boards, graphics, video files, audio files, etc. BUS 237 5 Q2. How can content be organized? • Content management includes • management of content data • Database Management Systems (DBMS) • presentation of content • Content Management Systems (CMS) • Content management challenge • processing and storing the right content • getting the right content to the right person in the right format at the right time BUS 237 6 BUS 237 2 Content Management and SFU • How do you get something listed on the main SFU website? • What steps are involved? • Who is in charge of it? • What are the policies about web content? • Does SFU have a brand? • Should a University be “branded”? • How do you enforce a brand within the university? BUS 237 7 Q3. What is the purpose of a database? • Spreadsheet and database keep track of things • Spreadsheets • Keep lists of single concept • Databases • Keep lists that involve multiple themes BUS 237 8 Q4. What does a database contain? • A database is a self-describing collection of integrated records • Hierarchy of data elements • Byte is a character of data • Bytes are grouped into columns/fields • Columns are grouped into rows/records • Rows are grouped into tables/files BUS 237 9 Storing Data • Character: the most basic logical data element – single alphabetic, numeric or symbol – typically a Byte • Field: typically a group of characters (could be one) – represents an attribute (characteristic or quality) of an entity (object, person, or place) • Record: related fields of data grouped together – can be either fixed length (e.g. Address) or variable length either fixed length (e....
View Full Document
This note was uploaded on 02/18/2012 for the course BUSE 237 taught by Professor Sf during the Spring '12 term at Simon Fraser.
- Spring '12