???????(DBMS)??????????????,?????????,???????????????????? - PowerPoint PPT Presentation

1 / 39

About This Presentation

Title:

???????(DBMS)??????????????,?????????,????????????????????

Description:

Title: 2 Author: ljf Last modified by: Tiyzhao Created Date: 7/20/2005 5:21:00 AM Document presentation format – PowerPoint PPT presentation

Number of Views:15

Avg rating:3.0/5.0

Slides: 40

Provided by: LJF9

Category:

more less

Transcript and Presenter's Notes

Title: ???????(DBMS)??????????????,?????????,????????????????????

1
??? ???????????
2
??? ???????????
????????
3
3.1 ??????
????????? 1. ?????????? 2. ????? 3.
???????? 4. ????? 5. ????????
4
3.1 ??????
???????????? (?)?????? (?)??????
(?)??????? ?3-1 ?????????????
???? ???? ?????
?????? ??(???) ???? ?????
?????? ?????? ?????? ??????
?????? ??? ???,??? ???,???
?????? ???? ???? ????
?????? ??? ?????,????? ?????
5
3.1 ??????
??????? (?)??? ???????????????????????
??? (?)????? ?????????????????????/???
??,?????????????????????????????? (?)???????
???????(DBMS)??????????????,?????????,?
???????????????????
6
3.1 ??????
?????????? (?)????
1.???? ?????????????????????,
???????????????
??????????
2.???? ??????????????????????

?,???????????????
7
3.1 ??????
???????? ??(Entity)???????????????
?????????? ????????????? ??(Attribute)????????,
?????? ????? ????????????????????????
?? ? ??(Key)??????????????? ??????????????????
? ???(Entity Set)??????????????
?? ??????????
8
3.1 ??????
??????? a. ?????(11) ???????????????,?????
??????????,???????????????? b.?????(1n)
????????????,??????????????,????????????????
c.?????(mn) ???????????????,???????????????,??
??????????????
9
3.1 ??????
3.???? ???????????,?????????????
???????????,?????????????
??(Fields)???????????????(????)
???????????????????? ??(Record)???????????
??(File)????????????
???????????????
10
3.1 ??????
????????????????????? ?????
11
3.1 ??????
(?)?????? 1?????
12
3.1 ??????
2.????
??
??
??
?3-6 ????
13
3.1 ??????
3.????
?3-3 ?????????
?? ?? ??
0411001 ??? ?
0411002 ??? ?
0411003 ??? ?
.
14
3.1 ??????
??????????? ???????????????
???????????????? ????????????????
????????????????,??? ???????????
?????????
15
3.1 ??????
(?)??????????
???A
???B
DBMS
OS
?3-7 ??????????
16
3.1 ??????
1.??? ?????????????,????????????,????
?????????,?????????????????????,??????? 2.??
?????????????,??????????????????????,?????
???????? 3.??? ?????????,?????????????
???,??????????????,????????,????????????
17
3.1 ??????

18
3.1 ??????
??????? (?)???????? (?)???????
???????????,??????????-????,????E-R(Entity-Relatio
nship)?????????????? (?)??????
?????????????E-R????????????????????,?????????????
(?)?????? ???????????????????????????????
????,???????
19
3.1 ??????
?????????? (?)?????? ??????????????,???????
????????,?????????????????????? (?)??????
????????????????????????,??????????????????,??????
????????????????,?????????????????,?????????????
20
3.2 ?????????
?????????
21
3.2 ?????????
?????? (?)???????
????????????????????????????????????????????????
(?)??????? 1?????????????????????
2????????? 3????????????????
(?)?????????
22
3.2 ?????????
?????? (?)???????
???????????????????????????????????????????????
(?)??????? 1.?????(database
marketing) ?????????????????????????????
????????????????? 2.????(basket
analysis)? ?????????????(?POS???)???????
?????
23
3.3 ??????????
?????? 1.??????? 2.?????? 3.???????
4.????????? 5.Internet 6.???????
24
3.3 ??????????
????????? (?)????
??????????????????????,???????????????
(?)???? ????????????,????????,?????????
???????,???????????????????,??????????????????????
???
25
3.3 ??????????
(?)?????/????? ??????/??????,???????
???????????????? (?) ???(Client)/???(Server
)(C/S)?? ????/??????(??3-19??),??????????
????????????,??????????????????????????????????,??
???????????????????
26
3.3 ??????????

????????
(?) ??????
??????????????????????????????????(?????)?
?????
(?)??????????
1??????????????
???????????? ,???????????????????????
?????????? ,?????????????????????????

27
3.3 ??????????

2. ??????
??????
?????
?????
3. ??????
???
????
??
??????

28
3.3 ??????????

4. ??????
??????
??????
??????
??????
5. ???????????
????
??
???

29
3.3 ??????????
????????? (?)???????? 1?????
2????? 3?????????????? 4????????????
(?)?????? ????????????????????? ,?????
30
3.3 ??????????
? 3-27 ??????
31
3.3 ??????????

(?)?????
1?????????????
???
???
???
2??????????
????
???
???
?????

32
3.3 ??????????

(?)???????
?????
?????
?????
???
???
??
???
??

33
3.3 ??????????

???????????
(?)?????????
(?)??????????
????????????,????????????????? ? ?????? ???
???? ? ??? ???? ????
(?)Internet?????
TCP/IP??????????????????????????????

34
3.3 ??????????

??Internet
Internet????????,???????????????
????E-mail
WWW
?????BBS
??????Usenet
??????FTP
????Telnet

35
3.3 ??????????
????????? (?)?????(Intranet)????
Intranet???Internet?????????? ,?WWW???????????????
???Intranet???????????Internet?????,????????????,?
?????????????????????????????????????????????????
(?)?????(Extranet)????
Extranet(?????)?Intranet?????,?????????????,??????
????Intranet??????,?????????????
Extranet??????????????????,????????????????(??????
??????????????????)?
36
3.3 ??????????
(?)?????? ???????????????,???????
???????????????????????????,??????????????????????
?????????????? (?)POS??
POS(Point Of Sales)?????????????????????,?????????
??????????????????,????????????????????
(?)????????EDI ????????(Electronic Data
Interchange,??EDI)????????????????????????????,???
???????,???????,??????????????????????,???????????
?????
37
???
38
On-Demand Computing At Qantas Airways and Ford
Motor Company Europe

Qantas ????????????,??????,?????30????????
????,?4.5??IBM??10???????(On-Demand Computing)
????
??Ford ??IBM????????????
Both companies pay IBM a basic fee for an
anticipated level of service and then pay IBM
additional fees for any spikes if they use more
computing resources than planned.

39
Question