数据库原理课件-关系数据库标准语言SQL.pptxVIP

关系数据库标准语言SQL 两个概念Schema (架构，P83)Create schema ... Index (索引，P89) Schema (架构)A schema is essentially a namespace: it contains named objects (tables, data types, functions, and operators) whose names may duplicate those of other objects existing in other schemas. Named objects are accessed either byqualifying?their names with the schema name as a prefix, or by setting a search path that includes the desired schema(s).? Index（索引）索引以某个（或某些）属性值为输入并找出对应属性值符合要求的纪录。具体来说，索引使我们只需查看所有可能记录中的一小部分就能找到所需记录。建立索引的属性（组合）称为查找键（search key），简称键。索引存放记录的块值匹配的记录 稠密索引(Dense Indexes)和稀疏索引(Sparse Indexes)稠密