1 / 16

Class Agenda – 09/05/2013

Class Agenda – 09/05/2013. Answer questions about the course logistics for tutorials and assignments. Reminder about team declaration. Present concepts of computer data organization. Discuss the different levels of software available to manage data on a computer.

chadwick-ewing
Download Presentation

Class Agenda – 09/05/2013

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Class Agenda – 09/05/2013 • Answer questions about the course logistics for tutorials and assignments. • Reminder about team declaration. • Present concepts of computer data organization. • Discuss the different levels of software available to manage data on a computer. • Explore the functions of a DBMS vs. an operating system to manage data. • Discuss the relative data management capabilities of a DBMS vs. a spreadsheet.

  2. Views of Computer Data Organization & Access Conceptual Physical • I want to buy music on iTunes. • I want to see if that shirt is available in blue in a size medium. Primary Storage/Main Memory Processor ALU Secondary Storage/Disk Data and Programs

  3. Computer Data Organization Vocabulary Windows Library: View Folders Database Program Files Data Files Records Fields Bytes Bits

  4. How does it work? Primary Storage/Main Memory Processor Data and Programs when they are being processed ALU Secondary Storage/Disk Data and Programs when they are not being processed

  5. What is an operating system? • Examples: • Windows • Unix • Mac OS X • IBM z/OS, z/VM, UTS • Unisys OS2200 • Definition: Set of software that manages a computer’s operations.

  6. What does an operating system do? • Manage hardware and software resources: • Allocate main memory. • Direct processor activities. • Track all program activities. • Manage network connections. • Allocate secondary storage. • Move data and programs from secondary storage to main memory and back again. • Manage users (a little…).

  7. Moving data between primary and secondary storage Operating System MS Excel Firefox Neverwinter MS Word Secondary Storage/Disk Primary storage/main memory

  8. What is a DBMS? • A set of software that facilitates storage and access of data on a computer. • Designed to work with a specific operating system. • Examples from vendors. • Microsoft products: Access, FoxPro, SQL Server • Oracle products: Oracle, MySQL • SAP: Sybase, HANA • IBM products: Informix, DB2 • Open-ish: PostgreSQL

  9. What does a DBMS do? • Data structure maintenance: add, delete, change data objects. • Data maintenance: add, delete, change data. • Data backup and recovery. • Concurrency control. • Data access (query) optimization. • Security. • Distributed data management.

  10. What does MS Access do? • Data structure maintenance: add, delete, change tables for data storage. • Data maintenance: add, delete, change data in tables. • Provide user-friendly tools for data access. • Forms. • Reports. • Integration with other software such as Excel.

  11. Why do we store data in a database? • To protect the “integrity” of the data. • To make data more accessible. • To make an application more adaptable.

  12. What other software is available for data storage? • Word processing • Spreadsheets • Application programs • Examples: TurboTax, QuickBooks • Data storage: files, or enhanced file structures • Some application programs rely on a DBMS

More Related