Centralized vs Distributed Homogeneous vs Heterogeneous Federated DB
![](https://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-1.jpg)
![](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-2.jpg)
![](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-3.jpg)
![](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-4.jpg)
![](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-5.jpg)
![• Centralized vs. Distributed • Homogeneous vs. Heterogeneous – Federated DB, Multi-Database • • Centralized vs. Distributed • Homogeneous vs. Heterogeneous – Federated DB, Multi-Database •](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-6.jpg)
• Centralized vs. Distributed • Homogeneous vs. Heterogeneous – Federated DB, Multi-Database • General Purpose vs. Special Purpose • Main Memory Database – MM, Secondary Storage, Tertiary Storage
![Data Base Management System (DBMS) データベースを作成 し、維持する為の プログラム群 USER Application Program DBMS Query Processor Data Base Management System (DBMS) データベースを作成 し、維持する為の プログラム群 USER Application Program DBMS Query Processor](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-7.jpg)
Data Base Management System (DBMS) データベースを作成 し、維持する為の プログラム群 USER Application Program DBMS Query Processor Access Method Meta Data Base System Database
![](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-8.jpg)
![](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-9.jpg)
![Data Independence(データ独立) • Program-Data Independence – External Scheme & Conceptual Scheme • Logical/Physical Data Data Independence(データ独立) • Program-Data Independence – External Scheme & Conceptual Scheme • Logical/Physical Data](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-10.jpg)
Data Independence(データ独立) • Program-Data Independence – External Scheme & Conceptual Scheme • Logical/Physical Data Independence – Conceptual Scheme & Internal Scheme • Program-Operation Independence – O-O
![](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-11.jpg)
![3層スキーマ External View Conceptual Scheme Internal Scheme External View 3層スキーマ External View Conceptual Scheme Internal Scheme External View](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-12.jpg)
3層スキーマ External View Conceptual Scheme Internal Scheme External View
![Transaction 管理 • ACID – Atomicity – Consistency – Isolation – Durability • データ共有時における一貫性の維持 Transaction 管理 • ACID – Atomicity – Consistency – Isolation – Durability • データ共有時における一貫性の維持](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-13.jpg)
Transaction 管理 • ACID – Atomicity – Consistency – Isolation – Durability • データ共有時における一貫性の維持
![Merits and Demerits • Merits – Reduced Application Development Time No care for Concurrency Merits and Demerits • Merits – Reduced Application Development Time No care for Concurrency](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-14.jpg)
Merits and Demerits • Merits – Reduced Application Development Time No care for Concurrency Control, Access Method Recovery, Integrity Checking – Flexibility by Shared View ← Data Independence • Demerits – Needs more power
![DBA DDL Casual Query Programmer AP preprocessor Dictionary DDLcompiler Catalog Query Compiler DML Host DBA DDL Casual Query Programmer AP preprocessor Dictionary DDLcompiler Catalog Query Compiler DML Host](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-15.jpg)
DBA DDL Casual Query Programmer AP preprocessor Dictionary DDLcompiler Catalog Query Compiler DML Host Lang. DMLcompiler. Compiler Compiled Transaction Concurrency Cont Backup/Recovery Access Methods Run Time Processor DB
![2. データモデル • Data Model is a set of concepts that can be used 2. データモデル • Data Model is a set of concepts that can be used](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-16.jpg)
2. データモデル • Data Model is a set of concepts that can be used to describe the structure of database – Data type, relationship, constraint • High Level Data Model – Entity Relationship Model • Entity: 実体(real world object, concept) – Eg. Employee, Project • Attribute: entitityを記述する属性 • Relationship: entity間の関係
![• Representational Data Model – Relational Model – Network Model – Hierarchical Model • Representational Data Model – Relational Model – Network Model – Hierarchical Model](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-17.jpg)
• Representational Data Model – Relational Model – Network Model – Hierarchical Model – OO Model – OR Model
![Scheme and Instance • Scheme – Student[name, id, address, phone#] • Instance – [鈴木大地、0011, Scheme and Instance • Scheme – Student[name, id, address, phone#] • Instance – [鈴木大地、0011,](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-18.jpg)
Scheme and Instance • Scheme – Student[name, id, address, phone#] • Instance – [鈴木大地、0011, 神奈川県横浜市、0903223333] • Database State = set of instances
![ER-model • Entity-Relationship Model – Popular conceptual data model – Database design tool で広く利用 ER-model • Entity-Relationship Model – Popular conceptual data model – Database design tool で広く利用](http://slidetodoc.com/presentation_image_h/9a8b98883436b863fd7f5b3c1f80e587/image-19.jpg)
ER-model • Entity-Relationship Model – Popular conceptual data model – Database design tool で広く利用
- Slides: 19