数据库系统原理(英文)-1-09.pptVIP免费

Chapter1IntroductionFebruary2009DatabaseSystemConcepts-Chapter1Introduction-2MainPartsinThisChapterDatabaseSystemApplicationsPurposeofDatabaseSystemsViewofDataDatabaseLanguagesRelationalDatabaseDatabaseDesignDataStorageandQueryingTransactionManagementDatabaseArchitecturesDatabaseUsersandAdministratorsHistoryofDatabaseSystemsAppendix:Data,Information,Knowledge,etc.February2009DatabaseSystemConcepts-Chapter1Introduction-3§1.0DB,DBMS,DBSDefinitionsinthetextbookDatabase(DB)—acollectionofinterrelateddata,storedinsystemsasfilesDatabasemanagementsystem(DBMS)—DB,oracollectionofinterrelateddata—setofprogramstoaccessthedatainDBDatabasesystem(DBS)havingthesamedefinitionasDBMSinthetextbookthetermDBSandDBMSareusedinterchangeablyinthetextbookFebruary2009DatabaseSystemConcepts-Chapter1Introduction-4§1.0DB,DBMS,DBS(cont.)DBMSprovidesanenvironmentthatisbothconvenientandefficientforstoreandretrieveinformationdefinitionofstructuresforstorageofinformationdatamanipulationmechanismsdatasafetymechanismsDefinitionsinsomeothertextbooksFig.1.0.1Database(DB)—acollectionofinterrelateddata,storedinsystemsasfilesFebruary2009DatabaseSystemConcepts-Chapter1Introduction-5§1.0DB,DBMS,DBS(cont.)Definitionsinsomeothertextbooks(cont.)Databasemanagementsystem(DBMS)—asystem/mechanismtomanagedatainDB—or:setofprogramstoaccessthedatainDBDatabasesystem(DBS)—DB+DBMS+Users/AdministersDatabaseapplicationsystem—DB+DBMS+Applicationprograms+Users/AdministersDBMSApplicationprogram1DBfile…DBquerylanguagee.g.SQLAPI,e.g.ODBC,JDBCUsersDBMSDBDBS/DBASFig.1.0.1DBSandDBASApplicationprogram1February2009DatabaseSystemConcepts-Chapter1Introduction-7DatabasesandDBStouchallaspectsofourlivesBanking:alltransactionsAirlines:reservations,schedulesUniversities:registration,gradesSales:customers,products,purchasesManufacturing:production,inventory,orders,supplychainHumanresources:employeerecords,salaries,taxdeductions§1.2PurposeofDatabaseSystemsFe...