Distributed and Client/Server Database Systems ?????????????????????? ??????????????/???????????

1
Distributed and Client/Server Database
Systems????????????????????????????????????/???
????????

• ?.?????? ?????????

2
?????????????

• ?????? ?????????
• Suthida Chaichomchuen
• SCC
• ???? 210 ???????????????????????
• http//ced.kmitnb.ac.th/scc
• std_at_kmitnb.ac.th

3
???????????????
?????????????????????????????????????????????????
???????????????? ?????????????????????????????????
????? ? ??????????????????????????????????????????
??????????????/??????????? ???????????????????????
??????????????????????????????????????????????????
???
4
???????????????
... ?????????????????????????????????????????
??????????????????????????????????????????????????
??????/??????????? ??????????????????????????????
??????????????????????????? ??????????????????????
????? ?????????????????????????????????????/??????
?????
5
???????????????
????????????????????????????????????????????????
????????????/??????????? ??????????????????????
????????????????????????????? ???????????????????
?????????????????????????????????????????
?????????????????????? ???????????????
????????????????????????
6
???????????????
????????????????????????????????????????????????
???? ????????????????????? ??????????????????
??????????????????????????????????????????????????
???/???????????
7
????????????????????????

• 1.?????????????????????????????????
• 2.????????????????????????????????????
• 3.??????????????????????????????????
• 4.?????????????????????????????
• 5.??????????????????????????????????????????
• 6.???????????????????????????-???????
• 7.???????????????????????????????????
• 8.???????????????????????????????????????
• ...

8
????????????????????????

• ???????????????????????????????????
• ????????? ? ???
• 10.??????????????????????????????????
• 11.???????????????????????????????????
• ?????????
• 12.????????????????????????????????????
• ???????????????
• 13.???????????????????????????????????

9
????????????????????????

• 14. ????????????????????????????????????????
• ????????????????????????????
• 15. ???????????????????????????????????????
• ???????????????????????/??????????????
• 16. ??????????????????????????????????????
• ??????????????????????????????????/
• ???????????

10
????????????????????????

• 17. ??????????????????????????????????????
• ???????????????????????????????
• 18. ???????????????????????????????????
• ??????????????/?????????????????????
• 19.?????????????????????????????/??????????????

11
??????????????

• Database System
• Introduction to databases
• File-based approach
• Database approach
• Advantages disadvantages of database systems
• Database Environment
• Architecture for database system
• Database Languages
• Data Models

12
??????????????

• Database Management System DBMS
• Functions of DBMS
• Component of DBMS
• Multi-User DBMS Architecture
• The Relational Model
• Relational Integrity
• Relational Languages
• Views

13
??????????????

• Database Application Lifecycle
• Database Planning
• Database Design
• Database Administration
• CASE support
• Entity-Relationship Modeling
• Normalization
• Logical Database Design Methodology
• Physical Database Design Methodology

14
??????????????

• Database Languages
• SQL
• Advanced SQL
• View
• Query
• Integrity and Security
• Risk Analysis

15
??????????????

• Transaction Management
• Concurrency control
• Recovery control
• Distributed Database Systems
• Overview of networking
• Architecture for a DDBMS
• Architecture of Client/Server Database Systems

16
??????????????

• Distributed Relational Database Design
• Distributed Transaction Management
• Distributed Concurrency Control
• Distributed Deadlock Management
• Distributed Recovery Control
• Distributed Security Control

17
??????????????

• Application Design with Graphics User Interface
• Performance Measurement
• Software Distribution
• Trends in Distributed and Client/Server Database
  System

18
??????????????

• 16 ???????
• ?????????? 9 ??????????
• ?????????? 15-16 ????????????????
• ?????????? 17 ??????????

19
??????????????????

• ????????????????? 30
• ??????????????? (25-30 ?.?.) 30
• ??????????????? (20-30 ?.?.) 40

20
????????

• ????????
• ??????????? T-Score
• ?????????????????????? C ? A

21
?????????????????

• Database Systems
• A Practical Approach to Design, Implementation
  and Management
• Thomas M. Connolly
• Carolyn E. Begg
• Anne D. Strachan
• Addison-Wesley
• 4th Edition

22
?????????????????

• ???????????????????????/???????????, ????????
• ????? ???????????
• ??????????????

23
?????????????????

• ????????????????????
• ????? ?????????????
• ????? ??????????
• ???.??????
• 399.-

24
???????????????????????????????

• ????????????????????????????????????????????
• ????????????????????????????? 210
• ?????????????????? ???????????????????
• ??????????????????????????????????????????
• ???????????????????????????????????????????
• ????? ????????????? ????????????????
• ??????????????????????????/???????????????

25
??????????

• ??? ?????????? ???????????
• ???? ????????????? ?????????????? ?????????????
  ????????????????????????????????
  ?????????????????????????????????? (???? ?????
  ??????)
• ????????????