《数据库系统原理英》.ppt

该【《数据库系统原理英》 】是由【相惜】上传分享，文档一共【70】页，该文档可以免费在线阅读，需要了解更多关于【《数据库系统原理英》 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。Chapter1IntroductionFebruary20211精选课件MainPartsinThisChapterDatabaseSystemApplicationsPurposeofDatabaseSystemsViewofDataDatabaseLanguagesRelationalDatabaseDatabaseDesignDataStorageandQueryingTransactionManagementDatabaseArchitecturesDatabaseUsersandAdministratorsHistoryofDatabaseSystemsAppendix:Data,Information,Knowledge,§,DBMS,DBSDefinitionsinthetextbookDatabase(DB)—acollectionofinterrelateddata,storedinsystemsasfilesDatabasemanagementsystem(DBMS)—DB,oracollectionofinterrelateddata—essthedatainDBDatabasesystem(DBS)havingthesamedefinitionasDBMSinthetextbookthetermDBSandDBMSareusedinterchangeablyinthetextbookFebruary20213精选课件§,DBMS,DBS(cont.)(DB)—acollectionofinterrelateddata,storedinsystemsasfilesFebruary20214精选课件§,DBMS,DBS(cont.)Definitionsinsomeothertextbooks(cont.)Databasemanagementsystem(DBMS)—asystem/mechanismtomanagedatainDB—or:essthedatainDBDatabasesystem(DBS)—DB+DBMS+Users/AdministersDatabaseapplicationsystem—DB+DBMS+Applicationprograms+Users/AdministersFebruary20215精选课件DBMSApplicationprogram1DBfile…,,JDBCUsersDBMSDBDBS/:alltransactionsAirlines:reservations,schedulesUniversities:registration,gradesSales:customers,products,purchasesManufacturing:production,inventory,orders,supplychainHumanresources:employeerecords,salaries,taxdeductions§,-bankenterpriseessdatafilesAprogramtodebit〔将..记入借方〕orcredit〔将..记入贷方〕ount(帐户〕ountAprogramtofindthebalance〔收付差额,余额〕ountAprogramtogeneratemonthlystatements§(cont.)February20218精选课件DatamanagementonthebasisoffilesystemsExample—customer_record=<c_name,c_id,street,city>inCustomer_Fileessneeds—filename,itemname,lengthofrecord,lengthofitem,positionofitemintherecord,storagestructure,accessmethod,….Demerit—applicationprogramsarenotindependentofthefilesystem(oroperatingsystem)—dependencyamongapplicationprogramsanddata(程序与数据的非独立/依存性〕§(cont.)(,tape)anddataonit(address:cylinder,track,sector)memorycontrollers(),onthebasisofsecondarystorage’sphysicalstructures,suchasstoragestructures,accessmethodaccessprograms(I)essthroughdiskcontroller(I)accessthroughOS’filesystem(II)accessthroughdatabasesystem(DBS)(III)accessprograms(II)accessprograms(III)I/Osystem:driversfilesystem:file’essmethodsDBMS:relationaltables’logicalessmethodssystemcallsrelatedtofilemanagementDBSAPIFebruary202110精选课件