NETWORK (CODASYL DBTG) DATA MODEL PROPOSAL OF RELATIONAL DATA MODEL ENTITY RELATIONS.pdfVIP

?Shamkant B. Navathe 1 Database Technology and Challenge of Emerging Applications Shamkant B. Navathe Georgia Institute of Technology Atlanta, GA 30332 sham@ /~sham ?Shamkant B. Navathe 2 DATABASE TECHNOLOGIES ?Shamkant B. Navathe 3 History of Database Management Technology 1965-1980 Dominance of Hierarchical Model (IBM’s IMS) and Network Based Systems IDS (Honeywell - Bull ) IDMS (Goodrich -- Cullinet -- CA) DMS 1100 (Univac -- Unisys) TOTAL/SUPRA (Cincom) VAX DBMS( Digital -- Compaq) 1980’s -- Commercial Entry of the Relational Model IBM’s SQL/DS, DB2, DB2/2 INGRES, ORACLE, INFORMIX,SYBASE, ALLBASE(H-P) 1990’s Increasing acceptance of O-O and other DBMSs Late 90’s: The Object Relational Approach 2000 and beyond: ?? Proliferation of Non-standard data formats and standards ?Shamkant B. Navathe 4 MODELS OF DATA - continued 1964/1965 HIERARCHICAL DATA MODEL NETWORK (CODASYL/ DBTG) DATA MODEL 1970 PROPOSAL OF RELATIONAL DATA MODEL 1976 ENTITY RELATIONSHIP DATA MODEL 1982 ADVENT OF RELATIONAL DBMSs (IBM) Early 90’s Object Oriented Database Model 1993 – WWW (with HTML) Late 90’s XML and related family of markup languages I I / I I I I I I j i l i l il l ?Shamkant B. Navathe 5 SOURCES OF DATA File Systems Based Data Record-based Database Systems Based Data Structured Data Formatted Data Largely Numeric Passive and Static Data Newer Forms of Data Web-based Unstructured Mostly text and images “Dynamic Data” il t t t t t t t t tt t l i i t ti t f t t t tl t t i i t ?Shamkant B. Navathe 6 TYPES AND FORMATS OF DATA Levels of Abstraction Conceptual Logical Physical Formats Net CDF : multidimensional array data ASN.1: networks, genome data management AceDB : Genetic Database for Unstructured Data Terrain 3-D data : DEM (digital elevation model) TIN (traingular irregular network) l i t l i l i l t : lti i i l t . : t , t t : ti t f t t t i t : i it l l ti l I t i l i l t ?Shamkant B. Navathe 7 DBMS Product