ch02 - 2 0 ˆ i ¸ª 8fl 0 DBMS 0 i¸ • DBMS(1(1 — ...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2. 0 ˆ i ¸ª* 8fl% ¶ 0 DBMS 0 i¸ • * DBMS (1) (1) — ¶ E @ ¿ ­+ • ¶ 1 ¨˝ • 2 ¨˝ • 3 ...... ¨˝ • n 1 ( ) 2 ( ¨ ˝ • “ ) ( ...... 3 ) ( n ) 2 DBMS ¨ 0 ï· i¸ DBMS * (2) (2) 7 @ ˜ a P - i. 9 P - ii. ` P - • “ * ( K E — •E @ • E 7 iii. ☞ Note Note ` 9 - + + • “ * ( 3 DBMS ) í· i¸ DBMS 0 * * (3) (3) º -+ @ R @ • ! ¨ 7í ( K º ª * c g r + B 7 3 @ 0 ` P - + ª * (Data Dependency) (Data ) 8 ª * (Data Redundancy) (Data . · B 7 @ D D 3 3 3 (consistency) (security) (economics) (integrity) 4 DBMS ¸ 0 ï· i¸ DBMS * * (ÐK (4) (4) ... ... ˜a P - 1 à æ ` • “ E ‚` • 2 ‚` • 3 ‚` • n ( ‚ ` • “ ) ( 1 ) 2 ( 3 ) ( ‚ ` • “ ) ... ... ( n ) 5 3 0a 9 % ­ + 0 ˆ i¸ “* à •“* ( ¶ E Ð ‘9%- + (DBMS) D ? (DBMS) 0 ˆ •E 7 @ @ •E 7 @ 3 •1 3 • 2 ...... 3 • n à E ¶ 3 •“* 3 • “ * (DBMS) 1 3 2 n 6 DBMS ˜ 0 ð· i¸ DBMS * * (1) (1) @ @ E D (definition) D 0ˆ B 7 3 r – h ` 9 % + ` 9 % + D / ˜ Š ª * (mapping) 3 7 DBMS X 0 ð· i¸ DBMS * (2) * (3 ,3 ,3 ,3 ) (manipulation) D 0ˆ D `9P - + ` 9 - + Ø ­ + - + • * (control) D 0ˆ ( Kåº * Ø á g ­ + ­ + D (integrity) 3 3 , X Š · ª X ‚ · ª (concurrency control) 8 DBMS 0 i¸ ª • “ DBMS 3 ø ˆ ð ª * (redundancy) s ï · ª ø ð · w (sharing) 3 (consistency) 3 3 (integrity) 3 3 (security) 3 3 (standardization) 3 ` S - k 3 ` S - s Ì • * Ра 9 3 ¨ Ï ï i “* * 0 0 ª (Data Independency) (Data DBMS x 0 ï· i¸ ª ª D ¨ ˇ ï· * i. 0 • n ˜ a ˜ a % - + Ì ï · * ˜ a 9 - + Ï ï % - + Ì ï • * ( K “ * ( K ( K ii. u - + i · E ( ” * cg + ‘ % - + 0 • n + D ‘ 9 - + à æ E 10 D (mapping) C K å i “ * Æ g E ­ 0 ª à ¶ • “ * 1 ¨ • “ * 2 ...... A B C D B E F ...... G A D ’Ð ¶ E • “ * n •“ “ * A B C D E F G H ... •“ * ¨ “ * ¨ A D G B C EF H ... • “* “* 11 3 0 a 9i S f k 0 • “ * ( 0 ‚ª * à ¶ E Ð 1 D DBMS(first-generation DBMS) 0 Integrated Data Store(IDS) ˜ a9 - k z Ç ï · ª K å º 1960 C Ç · General Electric 3 Charles Bachman 8 ï · w o S ( network data model) ( Bachman o S ¹ (data structure diagram) ( IMS(Information Management System) DBMS 1960 C Ç · ª IBM ( (hierarchical data model) ( 1970 ˜ a S - k O ï · ª C DBMS 8 Ë K · ª 12 ▶ ▶ 2 D DBMS 0 0ˆ (relational à (relational data model) IBM 3 E.F.Codd ( ‘9S - k 1980 3 DBMS 9S - “ SQL IBM x ï· DBMS X í· ‘ S - Æ DBMS æ¶ Oracle, Ingres, Sybase, Informix Access, FoxPro, dBase, Paradox 13 PC D DBMS PC 0 ˆ ▶ ▶ 3 D DBMS 0 0ˆ Ê É + + h € ð· h€ æ ¶ • Ð ç E @¿ f ¢ • æ ¶ • E ç ¶ E DBMS(object-oriented DBMS, OODBMS) · ª DBMS(object-relational DBMS, O-RDBMS) xÀ ï ª 2 D DBMS M i 3 D DBMS M i¸ 0ˆ 0 0 0 14 ...
View Full Document

This note was uploaded on 11/03/2009 for the course CS db taught by Professor Prof.kim during the Fall '09 term at 홍익대학교.

Ask a homework question - tutors are online