资源描述：
《数据库系统概念01-概述.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、数据库系统Chapter1:Introduction概论要点,第一章PurposeofDatabaseSystems目的ViewofData数据视图DatabaseLanguages数据库语言RelationalDatabases关系数据库DatabaseDesign数据库绍设计Object-basedandsemistructureddatabases面向对象数据库DataStorageandQuerying数据存储和查询TransactionManagement事务管理DatabaseArchitecture数据库体系结构DatabaseUsersandAdminis
2、trators用户和管理员OverallStructure总体结构HistoryofDatabaseSystems数据库历史1.1DatabaseManagementSystem(DBMS)Cp1Collectionofinterrelateddata相关的数据集合Setofprogramstoaccessthedata用一组程序存取DBMScontainsinformationaboutaparticularenterprise企业信息DBMSprovidesanenvironmentthatisbothconvenientandefficienttouse.提供有效方
3、便的环境DatabaseApplications:数据库应用Banking:alltransactions银行Airlines:reservations,schedules机场，订票，计划Universities:registration,grades大学，注册，记分Sales:customers,products,purchases销售Manufacturing:production,inventory,orders,supplychain制造Humanresources:employeerecords,salaries,人事工资Databasestouchallasp
4、ectsofourlives数据库渗透到各行各业DatabaseManagementSystem(DBMS)Collectionofinterrelateddata相关的数据集合Setofprogramstoaccessthedata用一组程序存取DBMScontainsinformationaboutaparticularenterprise企业信息DBMSprovidesanenvironmentthatisbothconvenientandefficienttouse.提供有效方便的环境DatabaseApplications:数据库应用Banking:alltra
5、nsactions银行Airlines:reservations,schedules机场，订票，计划Universities:registration,grades大学，注册，记分Sales:customers,products,purchases销售Manufacturing:production,inventory,orders,supplychain制造Humanresources:employeerecords,salaries,人事工资Databasestouchallaspectsofourlives数据库渗透到各行各业上页已讲1.2PurposeofData
6、baseSystemDB目的ep2Intheearlydays,databaseapplicationswerebuiltontopoffilesystems70年代，数据库实质上是文件系统Drawbacksofusingfilesystemstostoredata:文件系统的不足Dataredundancyandinconsistency冗余Multiplefileformats,duplicationofinformationindifferentfiles格式多杂Difficultyinaccessingdata不易存取Needtowriteanewprogramt
7、ocarryouteachnewtaskDataisolation—multiplefilesandformats孤立Integrityproblems完整性不好Integrityconstraints(e.g.accountbalance>0)becomepartofprogramcode完整性约束如余额不能为负Hardtoaddnewconstraintsorchangeexistingones6/65PurposeofDatabaseSystems(Cont.)Drawbacksofusingfilesystems(co
