????????????SQL Server 2005 Express

1
???????Database System
???
2
Chapter 2 Outline

• 2-1 ??????
• 2-2 ?????????????????
• 2-3 ?????????
• 2-4 ???????????
• 2-5 ??????????
• 2-6 ??????????
• 2-7 SQL Server 2005 Express?????
• 2-8 ????

3
2-1 ??????
??-1
??-1
??-2
??-2
??
??-n
??-n
?2-1.1 ????
4
2-2 ?????????????????-1

• ???(Database)
• ???????????????????
• ?????????????,?????????????????
• ???????????????????,???????????????????????????

5
2-2 ?????????????????-2

• ???????
• (Database Management System/DBMS)
• ??(Defining)???
• ??(Constructing)???
• ??(Manipulating)???

6
2-2 ?????????????????-3

• ????????????????????
• ???(User)
• ??(Data)
• ??(Software)
• ??(Hardware)

7

• ?????(Database System)?????

8
2-3 ?????????

• ???
• ?????(End Users)
• ???????(Application Programmers)
• ??????(Database Administrators/DBA)
• ??
• ????(?????????)
• Metadata(???Data about Data ),??
• ????,???????????
• ??????,????????????
• ??????(Integrity Constraints)
• ???????(Trigger)

9
2-3 ?????????(?)

• ???????????(DBMS)?????(Application Software/AP)
• ??DBMS??????????
• ????????(Non-procedural Language)
• ?????(Form Generators)
• ?????(Report Generators)
• ?????(Program Generators)
• ?????(Graphics Generators)

10
2-3 ?????????(?)

• ???????????????,?????????(Reliability)???????????
  ?????,?????? CPU???????????????????(RAID-0/1/5)??

11
2-4 ???????????

• ?????????
• ??
• ????????,?????????,??????
• ??
• ????????????????????????
• ??
• ??????????
• ??
• ???????????????????

12
2-4???????????(?)

• ??????????
• ????
• ???????
• ??????????
• ????????
• ????????
• ?????????
• ????????
• ?????(Data Independence)

13
2-4???????????(?)

• ??????????
• ????
• ???????,????????????
• DBA????
• ????????

14
2-5 ??????????

• DBMS??????????
• ????(Data Model)
• ?????(Number of Users)
• ????(Number of Sites)

15
2-5 ??????????(?)

• ????(Data Model)
• ???DBMS????????????
• ???(Relational)
• ?????(Object-relational)
• ???(Hierarchical)
• ???(Network)

16
2-5 ??????????(?)

• ?????
• ????????????????
• ??????(Single-user System)
• ??????(Multi-user System)
• ????
• ??????????????????
• ???DBMS (Centralized DBMS)
• ???DMBS (Distributed DBMS)

17
2-6 ??????????

• ???????(Centralized System)

18
2-6 ??????????(?)

• ?????(Client/Server)

19
2-6-2 ?????????
20
2-6-2 ?????????

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

21
2-6-2 ???????(?)

• ???(Two-tier)
• ??????
• ?????
• (User Interface/UI)
• ????
• (Application Logic)
• ????
• (Business Rules)
• ????
• (Data Access)

22
2-6-2 ???????(?)

• ???(Three-tier)??????

23
2-7 SQL Server 2005?????

• SQL Server 2005 Express???????????(Two-tier)???(Mu
  lti-tier)??????????????????
• ??????????SSMSE???????
• ??????????????????????????

24
?????,?????????????SQL Server Express
?????,??????????????????(IIS?Apache???)???????????
?????????????
25
2-8 ????

• ????????????????????????
• ????????
• ???(User) ? ??(Data) ??? (Software) ?
  ??(Hardware)
• ???DBMS????????(Relational)??????(Object-relation
  al)????(Hierarchical)?????(Network)
• ?????(Client/Server)
• ?????(Three-tier)