数据库-序章(精品·公开课件).ppt

Problem (6) of Megatron 2000 No reliability e.g., - Can lose data - Can leave operations half done Problem (7) of Megatron 2000 No security e.g., - File system insecure - File system security is coarse Problem (8) of Megatron 2000 No application program interface (API) e.g., How can a payroll program get at the data? Problem (9) of Megatron 2000 Cannot interact with other DBMSs. Problem (10) of Megatron 2000 Poor dictionary facilities Problem (11) of Megatron 2000 No GUI Overview of a Database Management System Storage Storage manager Buffer manager Index/file/rec- Ord manager Execution engine Query Compiler Transaction Manager Logging and Recovery Buffers DDL Compiler Concurrency Control Lock table User/application queries, updates transaction commands Database administrator query plan Index, file, and record requests page commands read/write pages log pages data, metadata, indexes metadata statistics metadata DDL Commands It is responsible for storing data, metadata, indexes, and logs. An important storage management component is the buffer manager, which keeps portions of the data contents in main memory. Storage Management A user or an application program initiates query to extract data from the database. The query is parsed and optimized by a query compiler. The resulting query plan is executed by the execution engine. Query Processing Transaction Management Logging and Recovery Concurrency Control Deadlock Resolution 大数据时代企业数据管理面临的挑战 第一、在大数据愈演愈烈之时，对于企业来说，如何经济、高效访问数据值得探讨。 第二，如何组织、检索、存储、处理分析这些大数据。 第三，数据备份。 第四、重复数据删除。 第五，如何节省电力、节约空间、节约成本等。 Course Overview Storage-Management Overview C2 Memory hierarchy C3 Storage of data elements C4 one-dimensional indexes C5 Multidimensional indexes Query Processing C6 Query Execution C7 Query compiler and optimizer Transaction-Processing C8 System failures C9 Concurrency control C10 More about transaction management Information integrat