Sfdv3002
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

SFDV3002 PowerPoint PPT Presentation


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

SFDV3002. Introduction to Databases Spring, 2012. Major theme of SFDV3002. Database management systems (DBMS): What are they and what do they do? Defining, accessing, controlling Efficient multi-user access Database programming. Motivation. Databases are everywhere : Hospitals

Download Presentation

SFDV3002

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


Sfdv3002

SFDV3002

Introduction to Databases

Spring, 2012


Major theme of sfdv3002

Major theme of SFDV3002

Database management systems (DBMS):

  • What are they and what do they do?

  • Defining, accessing, controlling

  • Efficient multi-user access

  • Database programming

SFDV3002


Motivation

Motivation

  • Databases are everywhere:

    • Hospitals

    • Local government

    • Human Genome

    • Virtual sports

    • Student records

  • Must design, implement, access and manage large, efficient, multi-user, corporate databases.

large amounts of data often

accessed simultaneously

by large numbers of people

SFDV3002


How many databases are you listed in

How many databases are you listed in?

**Insert montage of local and international business and organisation logos (e.g., banks, government, police, retailers, financial, utilities, online services, etc., etc.). Examples above to get things started. Could animate appearance into logical groupings as listed in the notes. Suggest starting with your University logo.**

SFDV3002


Abstract vs concrete

Abstract vs. concrete

Abstract:

  • Systems (database) analysis and design

  • Conceptual modelling

  • “Traditional” (ERD) vs. object (UML) modelling

    Concrete (SFDV3002):

  • The Relational Model of Data

  • Database implementation and access

  • Management of large databases with multiple concurrent users

SFDV3002


The three schema ansi sparc architecture

Conceptual level (e.g., ERD)

Logical level (e.g., relational, SQL)

Physical level (blocks, files, pointers)

The “three-schema” (ANSI/SPARC) architecture

SFDV3002


Putting sfdv3002 in context

**modify as appropriate**

Putting SFDV3002 in context

  • SFDV2002

  • Information systems modelling and design

  • SFDV2004

  • Application software development

  • SFDV3002

  • SQL

  • Multi-user DBMS

  • Database applications

  • SFDV3003

  • Systems analysis

  • Conceptual & logical modelling (relational, object)

  • SFDV3007

  • Database admin

  • Distributed data management

  • Object DBMS

  • Decision support

SFDV3002


Assumed knowledge skills

Assumed knowledge & skills

  • Basic conceptual modelling (ERDs) (see Kifer ch. 4)

  • Basic relational model (relations, attributes, keys)

SFDV3002


Overview of sfdv3002

Overview of SFDV3002

Chapter 1: Relational database management systems

  • Motivation and functions

  • The Relational Model of Data

  • Relational Algebra

    Chapter 2 :

  • Conceptual Model Translation

  • Normalization

SFDV3002


Overview of sfdv30021

Overview of SFDV3002

Chapter 3: SQL

  • Database definition (tables, constraints, etc.)

  • Data manipulation (inserting, querying, etc.)

    Chapter 4: Multi-user database issues

  • Security

  • Transactions

  • Concurrent access and locking

    • Advanced integrity checking with triggers

SFDV3002


Overview of sfdv30022

Overview of SFDV3002

Chapter 5: Database programming with SQL

  • Server-side SQL programming

    • Oracle10g PL/SQL

    • Cursors

    • Procedures

    • Functions

    • Triggers

    • Packages

SFDV3002


Why no objects

Why no objects?

  • Concepts applicable to both relational and object DBMSs.

  • RDBMSs predominant.

  • Lack of effective standards (ODMG).

  • Briefly revisit in SFDV3007.

SFDV3002


Recall the e r approach kifer ch 4

Recall: the E-R approach(Kifer ch. 4)

“many”

“one”

  • PowerDesigner (Finkelstein) notation.

  • Conceptual model for data analysis.

  • Entities, relationships, attributes.

  • Cardinality, participation.

Order_head

Customer

relationship

“optional”

“mandatory”

SFDV3002


Recall the e r approach kifer ch 41

Recall: the E-R approach(Kifer ch. 4)

“many”

“one”

  • Oracle Designer (Barker) notation.

  • Conceptual model for data analysis.

  • Entities, relationships, attributes.

  • Cardinality, participation.

Order_head

Customer

relationship

“mandatory”

“optional”

SFDV3002


Recall the relational model of data kifer ch 3

Recall: the Relational Model of Data(Kifer ch. 3)

  • Logical or implementation data model for most commercial DBMSs.

  • Relations/tables, attributes/columns, tuples/rows.

  • Candidate, primary & alternate keys.

  • Foreign keys.

  • Functional dependencies & normalisation.

SFDV3002


What s next

What’s next?

Relational database management systems

  • What are they?

  • Why are they useful?

  • What do/should they do?

  • The Relational Model of Data in more depth

    • Structural aspects

    • Operations

    • Integrity

SFDV3002


  • Login