ebook 165-1

Size: px

Start display at page:

Download "ebook 165-1"

鑫熊
9 years ago
Views:

1 1 2 A N S I / S PA R C 3 4 S Q L C E L L A R ( i n s e r t ) ( c h a n g e ) ( d e l e t e ) ) 1-1 C E L L A R ( t a b l e ) (relational table)

2 2 1-1 CELLAR / / 2) ) W I N E P R O D U C E R 3 4 5

3 1 3 4) B I N # C E L L A R B I N # 1-1 5) S E L E C T I N S E RT U P D AT E D E L E T E S Q L S Q S Q L s e q u e l S Q L e s s - c u e - e l l 6) S Q L U P D AT E u p d a t e I N S E RT U P D AT E D E L E T E U P D AT E 7) (DBMS) ( ) 1. (

4 4 ) ( ) 1-4 ( 5 ) ( ) ( ) EMPLOYEE ( ) E N R O L L M E N T ( ) E M P L O Y E E E N R O L L M E N T ( 1-5 ) E N R O L L M E N T E M P L O Y E E 1-5 EMPLOYEE ENROLLMENT E M P L O Y E E

5 I / O I / O ( ) 3. ( D B M S ) D B M S D B M S 1. 1 D B M S D B M S 1. 1 S Q L D B M S D B M S (TP monitor) 2 3 D B M S I B M O S / 390 DB2 Universal Database D B M S ( i n s t a n c e ) D B M S X Y 4. C O B O L P L / I C + + J a v a 2 D B M S S Q L ( b u i l t i n )

6 6 D B M S S E L E C T I N S E RT 1. 1 S Q L S E L E C T I T I I S C O B O L 1-4 D B A D B M S D B M S : 1) 2) 3) 4) 5) 1) 2) 3)

7 1 7 4) 5) ( K n o w Wa r e ) KnowWare / (E/R) 1-6 S P P J W P S P

8 E / R ) S P J ( ) a. ( S m i t h ) ( M a n h a t t a n ) : b. c. d. b c d a b c d ( Jz) ( Sx) ( Py) Sx Py Jz 2) P P 3) 1-6 E J M J ( ) P 4 W 8 ( ) 3. S C I T Y

9 D B M S S 1 [ 1. 2 ] 1-1 BIN# 72 Bin Rafanelli Zinfandel 2003 Z i n f a n d e l 2003 b i n Z i n f a n d e l ( i m p l e m e n t a t i o n ) : ( ) ( ) ( ) (

10 10 K n o w Wa r e ) 1.4 ( 1-1 ) D A D B A D B A I T

11 ) ) ) E 3 D 8 D B M S D B M S D B M S 4) A B A B ) D B A

12 12 8 6) 7) 8) [ 1. 3 ~ 1. 4 ]

13 1 13 1) A B A B D B M S B 2) D B A Y 2 K 2 D B A 1-7 PFILE 1-7

14 14 D B A E M P L O Y E E D E PA RT M E N T C O B O L D B A C O B O L D B M S D B A A S C I I E B C D I C U n i c o d e 1 = 2 =

15 1 15 ( ) 1. 3 S Q L S Q L S Q L ~ 1970

16 16 ( 1. 1 ) 1) 2) a C E L L A R 1-1 C E L L A b SQL I B M I M S ( ) 1-8 [ 1. 5 ] ( n e t w o r k ) ( n e t w o r k ) CODASYL D B T G C O D A S Y L D B T G

17 1 17 Computer Associates International I D M S ( ) IBM D B 2 Computer Associates International Ingres II Informix Software Informix Dynamic Server Microsoft SQL Server O r a c l eo r a c l e 8i Sybase Sybase Adaptive Server D B 2 I n g r e s I n f o r m i x SQL Server O r a c l e S y b a s e D B 2 I n f o r m i x GemStone Systems GemStone Versant Object Technology Versant ODBMS ( D B A ) D B A ( ) S Q L S Q L S E L E C T I N S E RT U P D AT E D E L E T E S Q L S Q L 1.1

18 18 / C E L L A R S Q L S Q L

19 S Q L (a) Geyser Peak b i n (b) 5 b i n (c) b i n (d) b i n 30 3 (e) C h a r d o n n a y (f) 12 Gary Farrell Merlot b i n CD / L P / S i b e l i u s Simon Rattle ( A r t h u r G r u m i a u x ) 5 the NYPO violin concerto ( Kronos Quartet) 1-6 / 1 1 E. F.Codd : Data Models in Database Management Proc.Workshop on Data Abstraction D a t a b a s e and Conceptual Modelling Pingree Park Colo.(June 1980);ACM SIGART N e w s l e t t e r No.74 (January 1981);ACM SIGMOD Record 11 No.2(February 1981);ACM SIGPLAN Notice 1 6 No.1(January 1981) C o d d [ 5. 1 ] C o d d 1.2 Hugh Darwen: What a Database Really Is: Predicates and Propositions in C.J.Date Hugh Darwen and David McGoveran Relational Database Wr i t i n g s Reading Mass.: Addison-Wesley (1998) ( ) 1.3 C.J.Date and P.Hopewell: Storage Structure and Physical Data Independence, Proc.1971 ACM SIGFIDET Workshop on Data Definition A c c e s s and Control San Diego California (November 1971). 1.4 C.J.Date and P.Hopewell: File Definition and Logical Data Independence Proc.1971 ACM SIGFIDET Workshop on Data Definition A c c e s s and Control San Diego California (November 1971). [ 1. 3 ~ 1. 4 ] 1 5 C.J.Date: Relational Database Wr i t i n g s R e a d i n g Mass.: Addison- We s l e y ( ). 1.3

20 a R a f a n e l l i Z i n f a n d e l Z i n f a n d e l R a f a n e l l i 1 8 (a) C E L L A R B i n # 8 0 (b) Bin# C E L L A R (c) Bin# (d) c C E L L A R { B I N #} (a) SELECT BIN# W I N E B O T T L E S FROM CELLAR WHERE PRODUCER='Geyser Peak'; ( b ) SELECT BIN# WINE FROM CELLAR WHERE BOTTTLES>5; ( c ) SELECT BIN# FROM CELLAR WHERE WINE='Cab.Sauvignon' OR WINE='Pinot Noir' OR WINE='Zinfandel' OR WINE='Syrah' OR...;

21 1 21 D B M S ( ) Pinot Noir ( d ) UPDATE CELLAR SET BOTTLES=BOTTLES+3 WHERE BIN#=30; ( e ) D E L E T E FROM CELLAR WHERE WINE='Chardonay'; ( f ) I N S E R T INTO CELLAR(BIN# W I N E P R O D U C E R Y E A R B O T T L E S R E A D Y ) V A L U E S ( 55 ' M e r l o t ' 'Gary Farrell' );

R D B M S O R D B M S R D B M S / O R D B M S R D B M S O R D B M S 4 O R D B M S R D B M 3. ORACLE Server O R A C L E U N I X Windows NT w w

R D B M S O R D B M S R D B M S / O R D B M S R D B M S O R D B M S 4 O R D B M S R D B M 3. ORACLE Server O R A C L E U N I X Windows NT w w 1 1.1 D B M S To w e r C D 1. 1 968 I B M I M S 2 0 70 Cullinet Software I D M S I M S C O D A S Y L 1971 I D M S containing hierarchy I M S I D M S I M S I B M I M S I D M S 2 2. 18 R D B M S O R D B