(数据库原理课件）Chapter1 Introduction知识讲稿.pptVIP

* School of software, Yunnan University Chapter 1 Introduction 何婧 hejing@ Part I Database System Design Database Design. School of software Objective Introduce the development of database systems. Explain the concepts of client/server and multi-tire architectures Review relational database systems Explain what is NoSQL Database Design. School of software 1.1 The Development of Database System 1960s, navigational DBMS 1970s, relational DBMS E.F.Codd (1923－2003) A Relational Model of Data for Large Shared Data Banks. Communications of the ACM, Vol.13(6), 1970. Codd received the Turing Award in 1981 1980s, object-oriented Database Design. School of software 1.1 The Development of Database System 2000s, NoSQL and NewSQL Not Only SQL Key-Value stores Document-oriented databases Colum-oriented database Graph-oriented database Database Design. School of software Query Observe Data Analysis Analyze Information Data mining Predict Knowledge elevate From Data to Knowledge Database Design. School of software Two-Tier Client/Server Architecture Client side presented two problems preventing true scalability: ‘Fat’ client, requiring considerable resources on client’s computer to run effectively. Significant client side administration overhead. By 1995, three layers proposed, each potentially running on a different platform. Database Design. School of software Three-Tier Client/Server Architecture Exhibit 1-3: Three-tier Architecture User Interface Business and Data processing logic Data Access Logic “Thin” Client Database Design. School of software Three-Tier Client/Server Architecture Database Design. School of software Three-Tier Client/Server Architecture Advantages: ‘Thin’ client, requiring less expensive hardware. Application maintenance centralized. Easier to modify or replace one tier without affecting others. Separating business logic from database functions makes it easier to implement load balancing. Maps quite naturally to Web environment. Database