Class agenda 09 05 2013
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

Class Agenda – 09/05/2013 PowerPoint PPT Presentation


  • 38 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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.

  • 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.


Views of computer data organization access

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


Computer data organization vocabulary

Computer Data Organization Vocabulary

Windows Library: View

Folders

Database

Program Files

Data Files

Records

Fields

Bytes

Bits


How does it work

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


What is an operating system

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.


What does an operating system do

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…).


Moving data between primary and secondary storage

Moving data between primary and secondary storage

Operating System

MS Excel

Firefox

Neverwinter

MS Word

Secondary Storage/Disk

Primary storage/main memory


What is a dbms

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


What does a dbms do

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.


What does ms access do

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.


Why do we store data in a database

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.


What other software is available for data storage

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


  • Login