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


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

Chapter 2 : (Database Systems Architecture)

3204-2005

By Juthawut Chantharamalee


Chapter 2 database systems architecture

  • 3 ANSI-SPARC

  • 3 ANSI-SPARC

  • (Schema) (Mapping) (Instance)


Chapter 2 database systems architecture

()

-

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

......

......

.....


Chapter 2 database systems architecture

  • (Entity), (Relation) (Table)

  • (Tuple) (Row) Record

  • (Attribute) (Column), Field

  • (Cardinality) (Number of Rows)

  • (Primary Key) (Unique Identifier)


Entity

(Entity)

  • - , ,

    - , ,

  • (Attribute)

  • (Tuple)


Attribute

(Attribute)


Chapter 2 database systems architecture

()

()

Key ?

()


Chapter 2 database systems architecture

2

-

3

1

DATABASE


Chapter 2 database systems architecture

DBMS

Database system

DATABASE


Chapter 2 database systems architecture

Database management systems : DBMS

  • DBMS

    • SQL (Structure Query Language)

    • (General Utilities)

    • (Applicaton and Report Generators)

    • (Data Dictionary)


Chapter 2 database systems architecture

Database management systems : DBMS

  • data dictionary


Chapter 2 database systems architecture


Chapter 2 database systems architecture

-

-

-

-

-

    • -

  • -

-


Chapter 2 database systems architecture

  • ()


Chapter 2 database systems architecture

  • (architecture for ad database system)


Chapter 2 database systems architecture

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

  • 3

    • (External level)

    • (Concept level)

    • (Internal level)


Chapter 2 database systems architecture

...

1

2

n

External level

(Schema)

(Global logical view)

Conceptual level

Physical

Storage

of data

Internal level


Schema instant

Schema Instant

  • (Database Schema) (Description)

  • (Schema Diagram) (Database schema)

  • Schema construct (Schema) STUDENT,COURSE

  • Database Instant (Database State) Occurrence


Schema diagram

(Schema diagram)

(Schema diagram)


Database schema database state

(Database Schema) (Database State)

  • (Database State)

  • (Initial Database State)

  • Valid State

  • (Distinction)

    - (Database Schema) (Database State)

    - (Schema) Intention (State)

    Extension


Chapter 2 database systems architecture

...

1

2

n

External level

(Schema)

(Global logical view)

Conceptual level

Physical

Storage

of data

Internal level


1 external level

1.(External Level)

  • (view)

  • (External Schema)


1 external level view

(User View 1)

MGRNO

(User View2)

(User View3)

(User View4)

1. (External Level, View)

  • (View)


External level

(External Level)


2 conceptual level

2. (Conceptual Level)

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


2 conceptual level1

2. (Conceptual Level)

    • Entity (Table)

    • (DBA)


Conceptual level

(Conceptual Level)

Employee

Dep1

Dep2

Dep3


3 internal or physical level

3. (Internal or Physical Level)

(External Level)


Chapter 2 database systems architecture

  • 3

  • 1.

  • 2.


Chapter 2 database systems architecture

  • 3. (DBA)

  • 4.


Chapter 2 database systems architecture

1

2

External Level

Conceptual Level

Internal Level


Chapter 2 database systems architecture

3

    • DBMS (track cylinder )


Chapter 2 database systems architecture

  • (external level) (User View)

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

  • (Conceptuallevel) (mapping) (data independence)


Chapter 2 database systems architecture

Mapping

  • ANSI/SPARC Mapping 2

  • 1. Conceptual/Internal Mapping

  • 2. External/Conceptual Mapping


Chapter 2 database systems architecture

Mapping


Chapter 2 database systems architecture

Mapping

1. Conceptual/Internal Mapping

Conceptual Internal Conceptual Record Field Conceptual Internal


Chapter 2 database systems architecture

Mapping

2. External/Conceptual Mapping

External Conceptual Record Field


Data independence

(Data Independence)

  • Data Dependence


Chapter 2 database systems architecture

(Data Independence)

  • 3 2

  • 1. (Logical Data Independence)

  • 2. (Physical Data Independence)


Data independence1

(Data Independence)

  • (Logical Data Independence)

  • (Physical Data Independence)


Chapter 2 database systems architecture

1 2 3

COBOL

PASCAL

SQL

DBMS


Chapter 2 database systems architecture

  • (architecture for ad database system)

  • 3


Chapter 2 database systems architecture

  • (logical data independence)

  • (physical data independence)


Chapter 2 database systems architecture

2

  • 1.

  • 2. 3

  • 3.

  • 4.

  • 5.


The end chapter 2

The End Chapter 2

3204-2005


  • Login