Data management
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

Data Management PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

Data Management. Chris Wallace 3P14 [email protected] Book Various Database texts Last year Database Systems Paul Beynon-Davies £24.99 Exam 50% CourseWork 50% Web Site: Lecture 1. Workplan SQL Workbook Basic Terminology -

Download Presentation

Data Management

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

Data management

Data Management

  • Chris Wallace

    • 3P14

    • [email protected]

  • Book

    • Various Database texts

    • Last year Database Systems Paul Beynon-Davies £24.99

  • Exam 50% CourseWork 50%

  • Web Site:

Lecture 1

Lecture 1

  • Workplan

  • SQL Workbook

  • Basic Terminology -

    • Universe of Discourse, Data Schema, FactBase, Integrity, Database functions, Data model, Data/Information/Knowledge



Learning sql workbook

Learning SQL workbook

  • Based on a simple model of employees and departments in a company

  • Workbook takes you through the basics

  • Workbook covers three different DBMSs

    • Access

    • Oracle

    • MySQL

  • You can use any of the DBMSs but MySQL is preferable

Uod database

Universe of Discourse - UoD

Part of Real world of interest


e.g. the real life ‘Mr Smith’


Representaton of UoD

Abstract, Symbolic, Passive

e.g. the record with employee no 7369

UoD <> Database

Schema factbase

Database Schema

A theory of the UoD


e.g. Emp table definition

Develops during design

‘Static’ during use



Facts about the UoD expressed in Schema

Specific to time, place

E.g. employee with empno=7499 has name ‘ALLEN’

Changes during use - Sequence of States


Schema <> Factbase



Factbase agrees with Schema

Internal to DBMS

Defined in Schema - ‘integrity constraints’

Checked by DBMS


Failure causes crash


Factbase agrees with UoD

Between DBMS and UoD

Checked by humans

‘good enough’ - issue of Data Quality

Failure causes errors

Integrity ??

Types of database function


Extracts existing facts and derives new facts

Leaves Factbase unchanged



Reflects some change in the UoD

Changes state of factbase

Must check integrity constraints


Types of Database Function

Data model

Data Schema

e.g. Table definitions for Member, Facility, Booking

Extension of a ‘Meta-model’

Architectural Data Model

e.g. Relational

Access 97, 2002

Oracle 7, 9i

or Object-oriented

Tables for

Table, Field, Relationship, Query


Data Model??

Data information knowledge

Data <> Information <> Knowledge

  • Data - basic facts

    • employee with no=7369 has sal=800

  • Information - deduced facts

    • The President has 3 staff reporting

    • The organisation has 4 levels of hierarchy

  • Knowledge - information in context

    • Staff turnover is low for the size of company and industry sector



  • You will need a login on the Windows 2000 system

  • Open a browser and locate the model home page

  • Locate the SQL workbook. It is easier to copy and paste code from the book but you have a hard-copy to keep notes in as well.

  • Login