1 2 A N S I / S PA R C 3 4 S Q L 1 1.1 1-1 C E L L A R 1-2 1-3 ( i n s e r t ) ( c h a n g e ) ( d e l e t e ) 3 4 5 1) 1-1 C E L L A R ( t a b l e ) (relational table) 1. 3 1. 6
2 1-1 CELLAR 1-2 1-3 / / 2) 1. 3 1. 6 3) W I N E P R O D U C E R 3 4 5
1 3 4) B I N # C E L L A R B I N # 1-1 5) 1-2 1-3 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) 4. 7 3 4 1.2 (DBMS) 1-4 1-4 ( ) 1. (
4 ) ( ) 1-4 ( 5 ) ( ) 2 1. 4 ( ) 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 1. 5 2 3 9 1. 3
1 5 2. 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 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 1. 4 2 2. 7 1.3 1. D B M S D B M S : 1) 2) 3) 4) 5) 1) 2) 3)
1 7 4) 5) 21 2. ( K n o w Wa r e ) 1-6 1-6 KnowWare / (E/R) 1-6 S P P J W P S P
8 1-1 3 1-6 E / R 13 1-6 1) 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
1 9 5 4. D B M S S 1 [ 1. 2 ] 1-1 BIN# 72 Bin 72 1995 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 2003 1. 6 ( i m p l e m e n t a t i o n ) : ( ) ( ) ( ) (
10 K n o w Wa r e ) 1.4 ( 1-1 ) 1. 1. 2 D A D B A D B A I T
1 11 2 2. 1) 1. 2 2) 1. 2 3) E 3 D 8 D B M S D B M S D B M S 4) A B A B 14 15 5) 400 40 D B A
12 8 6) 7) 8) 2 20 1.5 [ 1. 3 ~ 1. 4 ] 2 3 9 1-5
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 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 =
1 15 ( ) 1. 3 S Q L S Q L S Q L 1.6 1. 3 30 1969 ~ 1970
16 ( 1. 1 ) 1) 2) 3 5 13 1-8 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
1 17 Computer Associates International I D M S 20 70 80 ( ) 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 21 23 1.7 ( 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 / 1 2 1 3 1 4 1 5 1 6 1-1 C E L L A R S Q L 1.7 1. 6 1.8 1-1 S Q L
1 19 1.9 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 5 5 1 996 2001 1.10 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 1 9 9 4-1 9 9 7. Reading Mass.: Addison-Wesley (1998). 1. 3 ( ) 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 1 9 9 1-1 9 9 4 R e a d i n g Mass.: Addison- We s l e y ( 1 9 9 5 ). 1.3
20 1.6 1.7 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# 4 5 4 8 6 4 7 2 C E L L A R (c) Bin# 5 0 5 (d) c C E L L A R { B I N #} 8 1.9 (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...;
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' 1 996 1 2 2 001 );