应用程序1 应用程序2 应用程序N DBMS DBMS DBNS

《数据库原理》第4章(图4)

5.1概述 5.1.1查询处理的一般过程 5.1.2例子 问题:选修了CS01的学生姓名? SELECT SNAME FROM S,SC WHERE S.S#=SC.S# AND C#='CS01' 5.1.3查询优化

7.1数据库安全 计算机系统的三类安全问题:技术安全管理安全,政策法律 1985 DOD Trusted Computer System Evaluation Criteria)) TCSEC将系统分为四组七个等级:D,(c,c2)(b1,b2,b3)a

9.1引论 数据库设计工作 信息需求,处理需求 数据库设计的主要方法 面向数据(信息需求为主) 面向过程(处理需求为主)

Agenda SQL Server Overview SQL Server Architecture Storage and Access Methods Query Processing and Optimization Transaction Processing Other Topics

Too complex for complete analysis Separation into non-interacting subsystems distorts the results The most important properties are emergent Too organized for statistics Too much underlying structure that distorts the statistics Organized Complexity\(Weinberg) Copyright Nancy Leveson, Sept 1999

Requirements specification: A structured document that sets out the services the system is expected to provide Should be precise so that it can act as a contract between the system procurer and software developer and thus needs to be understandable by procurers and developers

design: added inheritance, multiple inheritance, and polymorphism to ADT In process added complexity and increased some types of connectivity Lots of claimed advantages -- so far empirical evaluation is not supporting them well

State Machine specifications Define behavior using states and transitions between states