讲稿01.pptVIP

DATE2/15/2004 PAGE：* * THE DATABASE APPLICATION TECHNOLOGY Jin Zhan COURSE BOOK: Microsoft SQL Server 2000 Programming by Example Que? Corporation. REFERENCES: An introduction to Database System C. J. Date, China Machine Press. Inside Microsoft SQL Server 2000 Kalen Delaney , Microsoft Press. SQL Server 2000 程序设计 隆华软件工作室，清华大学出版社. MS ODBC 3.0Programmer’s Reference and SDK Guide 程序员参考及SDK指南, Microsoft Press. SQL Server 2000 与 Visual Basic.Net 编程 Microsoft Press. 清华大学出版社(译). search more from internet … … … CONTENT: Review Database Principles Introduction to Microsoft SQL Server 2000 Database Application Case Study Using Database in Web Applications 1. OVERVIEW 1.OVERVIEW DATABDSE and DBMS DATE2/15/2004 PAGE：* DATABASE A database is a collection of data, typically describing the activities of one or more related organizations. For example, a university database might contain information about the following: Entities such as students, faculty, courses, and classrooms. Relationships between entities, such as students enrollment in courses, faculty teaching courses, and the use of rooms for courses. DBMS A database management system, or DBMS, is software designed to assist in maintaining and utilizing large collections of data, and the need for such systems. DATABASE SYSTEM A database system = DATABASE + DBMS 1.OVERVIEW ADVANTAGES of DBMS DATE2/15/2004 PAGE：* Data independence: The DBMS can provide an abstract view of the data to insulate application code from such details. Efficient data access: A DBMS utilizes a variety of sophisticated techniques to store and retrieve data efficiently. Data integrity and security: DBMS can enforce integrity constraints on the data. Data administration: When several users share the data, centralizing the administration Concurrent access and crash recovery: A DBMS schedules concurrent accesses to the data in such a manner that users can think of the data as being accessed b