资源描述:
《浙江大学数据库系统概念PPT第一课时,对应原版教材第五版.ppt》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、DatabasesystemIntroductionWhatisDatabaseSystems?PurposeofDatabaseSystemsDataAbstractionDatabaseLanguagesDatabaseUsersDatabaseSystemStructureApplicationArchitecturesHistoryofDatabaseSystemsDatabaseSystemDatabaseSystemDatabaseDBMSDatabase:Collectionofinterrelateddata(informationab
2、outaparticularenterprise)Largeamountofinformation(data)Wellorganized:DefinitionandManipulationShareamongseveralusers,avoidpossibleanomalousresultsSafetyoftheinformationstored,despitesystemcrashorunauthorizedaccessDBMSisasoftware:SetofprogramstoaccessthedataBeabletomanagedatabase
3、s.Providesanenvironmentthatisbothconvenientandefficienttouse.DatabaseApplicationsDatabasetouchallaspectsofourlivesBanking:alltransactionsAirlines:reservations,schedulesUniversities:registration,gradesSales:customers,products,purchasesManufacturing:production,inventory,orders,sup
4、plychainHumanresources:employeerecords,salaries,taxdeductionsUseofdatabasegrewlastfourdecadesVeryfewpeopleinteracteddirectlywithdatabasesystem,customdidnotknowthebackenddatabase,theygotprintedreport,etc.Somecustomsaccesssystemviaphoneinterface.DirectuseraccessviaInternet.Thepurp
5、oseofthecourseistounderstandthefundamentalofDatabaseSystem.HowtouseDBMS.(included)HowDBMSworks.(Abriefintroduction)PurposeofDatabaseSystemsIntheearlydays,databaseapplicationswerebuiltontopoffilesystemsDrawbacksofusingfilesystemstostoredata:DataredundancyandinconsistencyMultiplef
6、ileformats,duplicationofinformationindifferentfilesDifficultyinaccessingdataNeedtowriteanewprogramtocarryouteachnewtaskDataisolation—multiplefilesandformatsIntegrityproblemsIntegrityconstraints(e.g.accountbalance>0)becomepartofprogramcodeHardtoaddnewconstraintsorchangeexistingon
7、esPurposeofDatabaseSystems(Cont.)Drawbacksofusingfilesystems(cont.)AtomicityofupdatesFailuresmayleavedatabaseinaninconsistentstatewithpartialupdatescarriedoutE.g.transferoffundsfromoneaccounttoanothershouldeithercompleteornothappenatallConcurrentaccessbymultipleusersConcurrentac
8、cessedneededforperformanceUncontrolledconcurren