DataBase System ta Unit 3 SQL 3.1 Introduction 13.2 Setting Up the database 4 3.3 Queries 43. 4 View 43.5 Data manipulation M 3.6 Security Haichang Gao, Software School, Xidian University 3
DataBase System Haichang Gao , Software School , Xidian University 3 Unit 3 SQL 3.1 Introduction 3.2 Setting Up the Database 3.3 Queries 3.4 View 3.5 Data manipulation 3.6 Security
DataBase System About SQL g SQL is of the ability to implementing database in a computerized environment G The sQL is an non-procedural language G Power of SQL E Data definition ( DDL) ( Include Other database object definition E Interactive Data manipulation(DML) H Embedded SQL and dynamic SQL(数据库应用课讲) A Integrity Authorization (Security) Transaction Control Haichang Gao, Software School, Xidian University
DataBase System Haichang Gao , Software School , Xidian University 4 About SQL SQL is of the ability to implementing database in a computerized environment. The SQL is an non-procedural language. Power of SQL: Data definition (DDL) ( Include Other database object definition ) Interactive Data manipulation (DML) Embedded SQL and dynamic SQL(数据库应用课讲) Integrity Authorization (Security) Transaction Control
DataBase System 多 History of SQL H IBM Sequel (specifying QUeries As Relational Expression, 1972)language developed as part of System R project at the IBM San Jose research lab H SEQUEL (Structured English QUEry language, 1974) Renamed SQL( Structured Query Language, 1976) E ANSI and ISO standard SQL SQL-86, SQL-89(SQL1) >SQL-92 (SQL2 SQL: 1999(SQL3) SOL:2003 A Commercial systems offer most, if not all, sQL-92 features plus varying feature sets from later standards and special proprietary features Haichang Gao, Software School, Xidian University
DataBase System Haichang Gao , Software School , Xidian University 5 History of SQL IBM Sequel (Specifying QUeries As Relational Expression, 1972) language developed as part of System R project at the IBM San Jose Research Lab SEQUEL (Structured English QUEry Language,1974) Renamed SQL (Structured Query Language, 1976) ANSI and ISO standard SQL: ➢ SQL-86, SQL-89 (SQL1) ➢ SQL-92 (SQL2) ➢ SQL:1999 (SQL3) ➢ SQL:2003 Commercial systems offer most, if not all, SQL-92 features, plus varying feature sets from later standards and special proprietary features
DataBase System ta Unit 3 SQL 43.1 Introduction 43.2 Setting Up the Database 4 3.3 Queries 43. 4 View 43.5 Data manipulation M 3.6 Security Haichang Gao, Software School, Xidian University 6
DataBase System Haichang Gao , Software School , Xidian University 6 Unit 3 SQL 3.1 Introduction 3.2 Setting Up the Database 3.3 Queries 3.4 View 3.5 Data manipulation 3.6 Security
DataBase System Data Definition Language Data Definition Language Ddl) provide the abilities to setting up a database Cg Ddl allows the specification of not only a set of relations but also information about each relation Including s The schema for each relation t The domain of values associated with each attribute u Integrity constraints a The set of indices to be maintained for each relations H Security and authorization information for each relation H The physical storage structure of each relation on disk Haichang Gao, Software School, Xidian University
DataBase System Haichang Gao , Software School , Xidian University 7 Data Definition Language Data Definition Language (DDL) provide the abilities to setting up a database. DDL allows the specification of not only a set of relations but also information about each relation, including: The schema for each relation. The domain of values associated with each attribute. Integrity constraints The set of indices to be maintained for each relations. Security and authorization information for each relation. The physical storage structure of each relation on disk