IntroductiontoDatabaseSystemsChapter1.pptVIP

7 20 21 22 Database Management Systems, R. Ramakrishnan and J. Gehrke * Introduction to Database SystemsChapter 1 Instructor: Johannes Gehrkejohannes@cs.cornell.edu What Is a DBMS? A very large, integrated collection of data. Models real-world enterprise. Entities (e.g., students, courses) Relationships (e.g., Madonna is taking CS564) A Database Management System (DBMS) is a software package designed to store and manage databases. Historical Perspective Early 1960s Integrated data store, first general-purpose DBMS designed by Charles Bachman at GE Formed basis for network data model Bachman received Turing Award in 1973 for his work in database area Historical Perspective Late 1960s IBM developed Information Management System (IMS), used even today in many major installations IMS formed the basis for hierarchical data model American Airlines and IBM jointly developed SABRE for making airline reservations SABRE is used today to populate Web-based travel services such as Travelocity Historical Perspective 1970 Edgar Codd, at IBM’s San Jose Research Laboratory, proposed relational data model. It sparked the rapid development of several DBMSs based on relational model, along with a rich body of theoretical results that placed the field on a firm foundation. Codd won 1981 Turing Award. Database systems matured as an academic discipline The benefits of DBMS were widely recognized, and the use of DBMSs for managing corporate data became standard practice. Historical Perspective 1980s Relational data model consolidated its position as dominant DBMS paradigm, and database systems continued to gain widespread use SQL query language, developed as part of IBM’s System R project, is now the standard query language SQL was standardized in late 1980s, and current standard SQL:1999 was adopted by ANSI and ISO Historical Perspective Late 1980s till 1990s Considerable research into more powerful query language and richer data model, with emphasis on supporting complex analys