资源描述：
《数据库系统基础教程Database Systems(1)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、Departmentofcomputerscience&technologyNJUSTDatabaseSystems数据库系统DatabaseSystems2.5学分上课、0.5学分上机，共3学分。学习目的：掌握数据库系统的基本概念、原理和方法；学会有效地使用数据库管理系统，完成数据库的设计和对数据库的编程。学习方法：理论结合实践。考核方式及要求：作业（20％）：按时认真完成作业。实验（10％）：完成上机实验并提交实验报告。闭卷考试（70％）：英文试卷。DatabaseSystemsReferencebooksJeffreyD.Ullman,Jenni
2、ferWidom.数据库系统基础教程(原书第3版).岳丽华等译.机械工业出版社.2009.AbrahamSilberschatz,HenryF.Korth,S.Sudarshan.DatabaseSystemConcepts(FourthEdition).机械工业出版社.http://www-db.stanford.edu/~ullman/fcdb.htmlTheWorldsofDatabaseSystemTheRelationalModelofData*DesignTheoryforRelationalDatabasesHigh-LevelDatab
3、aseModelsAlgebraicandLogicalQueryLanguage*TheDatabaseLanguageSQLConstraintsandTriggersViewsandIndexesSQLinaServerEnvironmentAdvancedtopicsinRelationalDatabasesAFirstCourseinDatabaseSystems1TheWorldsofDatabaseSystemsTheEvolutionofDatabaseSystemsOverviewofaDBMSOutlineofDatabase-Sy
4、stemStudies1.1TheEvolutionofDatabaseSystemsWhat’sadatabase?Inessence,adatabaseisacollectionofinformationthatexistsoveralongperiodoftime,oftenmanyyears.Incommonparlance(说法),adatabaseisacollectionofdatathatismanagedbyadatabasemanagementsystem(DBMS).1.1TheEvolutionofDatabaseSystems
5、DatabaseApplications:Banking:alltransactions(交易)Airlines:reservations(预定),schedules(航班表)Universities:registration,gradesSales:customers,products,ordersManufacturing:production,inventory(库存),orders,supplychainHumanresources:employeerecords,salaries,taxdeductionsDatabasestouchalla
6、spectsofourlives.1.1TheEvolutionofDatabaseSystemsADBMSisexpectedto:DataDefinitionLanguage(DDL):createdatabasesandspecifytheirschema(模式).AschemaisagroupofcollectionsofsentencesthatareexpressedbyDDLtodescribethelogicalstructureofthedatabasecompletely.DataQueryLanguageandDataManipu
7、lationLanguage:query（查询）andmodify（更新）thedatabasedontheschemaofthedatabase.Supportthestorageofverylargeamountsofdata:manyterabytes(1012bytes)ormore,overalongperiodoftime,allowingefficientaccess.1.1TheEvolutionofDatabaseSystemsADBMSisexpectedto:Enabledurability(持久):therecoveryofth
8、edatabaseinthefaceoffailures(故障),errorsofmanyki
