资源描述:
《《数据库系统原理英》PPT课件》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、Chapter1IntroductionMainPartsinThisChapterDatabaseSystemApplicationsPurposeofDatabaseSystemsViewofDataDatabaseLanguagesRelationalDatabaseDatabaseDesignDataStorageandQueryingTransactionManagementDatabaseArchitecturesDatabaseUsersandAdministratorsHistoryofDatabaseS
2、ystemsAppendix:Data,Information,Knowledge,etc.February20112DatabaseSystemConcepts-Chapter1Introduction-§1.0DB,DBMS,DBSDefinitionsinthetextbookDatabase(DB)—acollectionofinterrelateddata,storedinsystemsasfilesDatabasemanagementsystem(DBMS)—DB,oracollectionofinterrela
3、teddata—setofprogramstoaccessthedatainDBDatabasesystem(DBS)havingthesamedefinitionasDBMSinthetextbookthetermDBSandDBMSareusedinterchangeablyinthetextbookFebruary20113DatabaseSystemConcepts-Chapter1Introduction-§1.0DB,DBMS,DBS(cont.)DBMSprovidesanenvironmentthatisbo
4、thconvenientandefficientforstoreandretrieveinformationdefinitionofstructuresforstorageofinformationdatamanipulationmechanismsdatasafetymechanismsDefinitionsinsomeothertextbooksFig.1.0.1Database(DB)—acollectionofinterrelateddata,storedinsystemsasfilesFebruary20114Da
5、tabaseSystemConcepts-Chapter1Introduction-§1.0DB,DBMS,DBS(cont.)Definitionsinsomeothertextbooks(cont.)Databasemanagementsystem(DBMS)—asystem/mechanismtomanagedatainDB—or:setofprogramstoaccessthedatainDBDatabasesystem(DBS)—DB+DBMS+Users/AdministersDatabaseapplicatio
6、nsystem—DB+DBMS+Applicationprograms+Users/AdministersFebruary20115DatabaseSystemConcepts-Chapter1Introduction-DBMSApplicationprogram1DBfile…DBquerylanguagee.g.SQLAPI,e.g.ODBC,JDBCUsersDBMSDBDBS/DBASFig.1.0.1DBSandDBASApplicationprogram1February20116DatabaseSystemCo
7、ncepts-Chapter1Introduction-DatabasesandDBStouchallaspectsofourlivesBanking:alltransactionsAirlines:reservations,schedulesUniversities:registration,gradesSales:customers,products,purchasesManufacturing:production,inventory,orders,supplychainHumanresources:employeer
8、ecords,salaries,taxdeductions§1.2PurposeofDatabaseSystemsFebruary20117DatabaseSystemConcepts-Chapter1Introduction-Intheearlydays,datamanagementap