资源描述：
《数据库系统原理（英文）课件.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、Chapter1 IntroductionFebruary20071DatabaseSystemConcepts-Chapter1Introduction-MainPartsinThisChapterDatabaseSystemApplicationsPurposeofDatabaseSystemsViewofDataDatabaseLanguagesDatabaseDesignDataStorageandQueryingTransactionManagementDatabaseArchitecturesDatabaseUsersan
2、dAdministratorsHistoryofDatabaseSystemsAppendix:Data,Information,Knowledge,etc.§1.0DB,DBMS,DBSDefinitionsinthetextbookDatabase(DB)—acollectionofinterrelateddata,storedinsystemsasfilesDatabasemanagementsystem(DBMS)—DB,oracollectionofinterrelateddata—setofprogramstoaccesst
3、hedatainDBDatabasesystem(DBS)havingthesamedefinitionasDBMSinthetextbookthetermDBSandDBMSareusedinterchangeablyinthetextbook§1.0DB,DBMS,DBS(cont.)DBMSprovidesanenvironmentthatisbothconvenientandefficientforstoreandretrieveinformationdefinitionofstructuresforstorageofinfor
4、mationdatamanipulationmechanismsdatasafetymechanismsDefinitionsinsomeothertextbooksFig.1.0.1Database(DB)—acollectionofinterrelateddata,storedinsystemsasfiles§1.0DB,DBMS,DBS(cont.)Definitionsinsomeothertextbooks(cont.)Databasemanagementsystem(DBMS)—asystem/mechanismtomana
5、gedatainDB—or:setofprogramstoaccessthedatainDBDatabasesystem(DBS)—DB+DBMS+Users/AdministersDatabaseapplicationsystem—DB+DBMS+Applicationprograms+Users/AdministersDBMSApplicationprogram1DBfile…DBquerylanguagee.g.SQLAPI,e.g.ODBC,JDBCUsersDBMSDBDBS/DBASFig.1.0.1DBSandDBASAp
6、plicationprogram1§1.1DatabaseSystemApplicationsDatabasesandDBStouchallaspectsofourlivesBanking:alltransactionsAirlines:reservations,schedulesUniversities:registration,gradesSales:customers,products,purchasesManufacturing:production,inventory,orders,supplychainHumanresour
7、ces:employeerecords,salaries,taxdeductionsIntheearlydays,databaseapplicationswerebuiltontopoffilesystemsE.g.Saving-bankenterpriseanumberofapplicationprogramstoaccessdatafilesAprogramtodebit（将..记入借方）orcredit（将..记入贷方）anaccount(帐户）AprogramtoaddanewaccountAprogramtofindtheba
8、lance（收付差额，余额）ofanaccountAprogramtogeneratemonthlystatements§1.2PurposeofDatabaseSystemsDatamanagemento
