Chapter 2 database systems architecture
This presentation is the property of its rightful owner.
Sponsored Links
1 / 45

Chapter 2 : สถาปัตยกรรมระบบฐานข้อมูล (Database Systems Architecture ) PowerPoint PPT Presentation


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

Chapter 2 : สถาปัตยกรรมระบบฐานข้อมูล (Database Systems Architecture ). 3204-2005 ระบบฐานข้อมูล. By Juthawut Chantharamalee. วัตถุประสงค์. ทราบถึงแนวคิดและความสำคัญของสถาปัตยกรรมระบบฐานข้อมูล บอกวัตถุประสงค์ของสถาปัตยกรรม 3 ระดับของ ANSI-SPARC ได้

Download Presentation

Chapter 2 : สถาปัตยกรรมระบบฐานข้อมูล (Database Systems Architecture )

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


Chapter 2 : (Database Systems Architecture)

3204-2005

By Juthawut Chantharamalee


  • 3 ANSI-SPARC

  • 3 ANSI-SPARC

  • (Schema) (Mapping) (Instance)


()

-

B00514 34 025478556 12/01/1977

A00128 126 026441255 09/07/1986

A01245 49/2 014544255 05/11/1971

C13244 66 066458554 26/04/1980

......

......

.....


  • (Entity), (Relation) (Table)

  • (Tuple) (Row) Record

  • (Attribute) (Column), Field

  • (Cardinality) (Number of Rows)

  • (Primary Key) (Unique Identifier)


(Entity)

  • - , ,

    - , ,

  • (Attribute)

  • (Tuple)


(Attribute)


()

()

Key ?

()


2

-

3

1

DATABASE


DBMS

Database system

DATABASE


Database management systems : DBMS

  • DBMS

    • SQL (Structure Query Language)

    • (General Utilities)

    • (Applicaton and Report Generators)

    • (Data Dictionary)


Database management systems : DBMS

  • data dictionary



-

-

-

-

-

    • -

  • -

-


  • ()


  • (architecture for ad database system)


  • ANSI /SPARC(American National Standards Institute/System Planning and Requirements Committee) 1975

  • 3

    • (External level)

    • (Concept level)

    • (Internal level)


...

1

2

n

External level

(Schema)

(Global logical view)

Conceptual level

Physical

Storage

of data

Internal level


Schema Instant

  • (Database Schema) (Description)

  • (Schema Diagram) (Database schema)

  • Schema construct (Schema) STUDENT,COURSE

  • Database Instant (Database State) Occurrence


(Schema diagram)

(Schema diagram)


(Database Schema) (Database State)

  • (Database State)

  • (Initial Database State)

  • Valid State

  • (Distinction)

    - (Database Schema) (Database State)

    - (Schema) Intention (State)

    Extension


...

1

2

n

External level

(Schema)

(Global logical view)

Conceptual level

Physical

Storage

of data

Internal level


1.(External Level)

  • (view)

  • (External Schema)


(User View 1)

MGRNO

(User View2)

(User View3)

(User View4)

1. (External Level, View)

  • (View)


(External Level)


2. (Conceptual Level)

(logical) (relationship) (data model) (External Level)


2. (Conceptual Level)

    • Entity (Table)

    • (DBA)


(Conceptual Level)

Employee

Dep1

Dep2

Dep3


3. (Internal or Physical Level)

(External Level)


  • 3

  • 1.

  • 2.


  • 3. (DBA)

  • 4.


1

2

External Level

Conceptual Level

Internal Level


3

    • DBMS (track cylinder )


  • (external level) (User View)

  • (internal level) (DBMS) (Operating System)

  • (Conceptuallevel) (mapping) (data independence)


Mapping

  • ANSI/SPARC Mapping 2

  • 1. Conceptual/Internal Mapping

  • 2. External/Conceptual Mapping


Mapping


Mapping

1. Conceptual/Internal Mapping

Conceptual Internal Conceptual Record Field Conceptual Internal


Mapping

2. External/Conceptual Mapping

External Conceptual Record Field


(Data Independence)

  • Data Dependence


(Data Independence)

  • 3 2

  • 1. (Logical Data Independence)

  • 2. (Physical Data Independence)


(Data Independence)

  • (Logical Data Independence)

  • (Physical Data Independence)


1 2 3

COBOL

PASCAL

SQL

DBMS


  • (architecture for ad database system)

  • 3


  • (logical data independence)

  • (physical data independence)


2

  • 1.

  • 2. 3

  • 3.

  • 4.

  • 5.


The End Chapter 2

3204-2005


  • Login