数据库系统原理(英文)-3-09.pptVIP免费

PART2RELATIONALDATABASESChapter3SQLMarch2009DatabaseSystemConcepts-Chapter3SQL-3UsageofSQLdatadefinition:§3.2,DDLdataquery/retrieve:§3.3——§3.8,Selectclausedatamanipulation:§3.9ModificationoftheDatabaseThreePartsinChapter3March2009DatabaseSystemConcepts-Chapter3SQL-4DatabasequerylanguagescommercialimplementationofrelationaloperationsinDBSinteractivetoolsforuserstodevelop,use/access,andmaintainDBSDBSaccess:create,retrieval,insert,delete,update,etc“Query”generalizeddefinitiondefine,retrieve,modify,controletc.onDB§3.1BackgroundMarch2009DatabaseSystemConcepts-Chapter3SQL-5SQLStructuredQueryLanguageonthebasisoftherelationalalgebraandthetuplerelationalcalculusfirstimplementedinSystemRbyIBMin1970sstandardizedbyANSIandISO,SQL-86,SQL-89,SQL-92,SQL-99,OO-SQL,themostrecentversionisSQL-2003widelyusedforcommercialDBS3.1Background(cont.)March2009DatabaseSystemConcepts-Chapter3SQL-6Parts/functionsofSQLdatadefinitionlanguage(DDL)define,delete,modifyonschemas,viewsandindexinteractivedata-manipulationlanguage(DML)query/retrieve,insert,delete,updateontuplesinDBdatacontrolintegrityconstraintsspecifyingauthorization:securitycontrol,specifyingaccessrightstransactionmanagementembeddedanddynamicSQL3.1Background(cont.)March2009DatabaseSystemConcepts-Chapter3SQL-79basicoperatorsinSQL3.1Background(cont.)datamanipulationSelect(onrelations)Insert,Delete,Update(onrelations)datadefinitionCreate,Drop,Alter(onschema)datacontrolGrant,Revoke(inChapter4)March2009DatabaseSystemConcepts-Chapter3SQL-8Casestudyusedinthischapterreturn3.1Background(cont.)Fig.3.1SchemaofbankingenterpriseMarch2009DatabaseSystemConcepts-Chapter3SQL-9DDLinSQLallowsthespecificationofinformationabouteachrelation,includingtheschemaforeachrelationorview-----createtable/viewthedomainofvaluesassociatedwitheachattributeintegrityconstraintsthesetofindicestobemaintainedforeachrelationssecurityandauthorizationinformationforeachrelationthephysicalstoragestr...