数据库技术和应用1TheWorldsofDatabaseSystem”.pptVIP

软件层面 应用语言级机器 高级语言级机器 汇编语言级机器 操作系统级机器 传统机器级机器 微程序机器级机器 电子线路级机器 设备层面 数据库原理、应用 软件工程 人工智能 数字信号、多媒体处理 程序设计基础及语言 编译原理 汇编语言程序设计 软件体系结构 算法与数据结构 离散结构 接口 技术 组成原理 模拟与数字逻辑电路 系统结构 嵌入式系统 信号与系统、控制技术 计算机网 络技术类 操作系统 1.2 Overview of a DBMS Application 1 Application 2 . . . Application n DBMS database Database Management System 手机微博 网页微博 门户登录 read/write pages Storage manager Storage index, file, and record requests index/file/ record manger DDL commands Queries, updates Query compiler User/application DDL compiler Database administrator Lock table Logging and recovery Concurrency control log pages page commands Buffer manager buffers data, metadata, indexs metadata Query plan Execution engine Metadata, statistics 单线框 系统成分 双线框 内存中的数据结构 实线 控制和数据流 虚线 数据流 略 Transaction manager Transaction commands 略 1.2 Overview of a DBMS Two types of user: Conventional users and application programs.用户 A database administrator(DBA 数据库管理员): a person or persons responsible for the structure or schema of the database. Three kinds of commands to the DBMS: Queries , updates : commands to extract(提取) data from the database or affect the content of the database .(查询、更新) Transaction commands: commands to tell the transaction manager when transactions begin and end. (事务) DDL commands: commands to change the schema of the database or create a new database by DBA. (管理员更改数据库结构/模式设计) 1.2 Overview of a DBMS Storage and buffer manager: (skip) includes the storage manager and the buffer manager: storage manager: controls the placement of data on disk and its movement between disk and main memory, keeps track(跟踪) of the location of files on the disk and obtains the block or blocks containing a file on request from the buffer manager. buffer* manager: partition(分割) the available main memory into buffers. read/write pages Storage manager Storage Buffer manager buffers User/application………… 略 1.2 Overview of a DBMS The kinds of information: Data: the contents of the database itself. Metadata(元数