数据库基础知识培训胶.pptx
数据库基础知识培训胶片集成产品部
数据库原理
目标通过这部分课程的学习,您将了解以下内容:关系数据库基本概念常用数据库对象常用数据类型
INDatabaseInformixServerSMPSCPSMAPSMAPSMAPThedatabaseplaystheroleofthebase,savingandprocessingthedatathatshouldbeeasilyaccessedbytheuser.Whatisadatabase?Usually,adatabaserunsintheserverparttoserveaccessrequestsfromclients.
DefinitionofaRelationalDatabaseArelationaldatabaseisacollectionofrelationsortwo-dimensionaltables.OracleserverTableName:EMPLOYEESTableName:DEPARTMENTS……
RelationalDatabaseManagementSystemUsertablesDatadictionaryOracleserverRDBMS:RelationalDatabaseManagementSystemArelationaldatabaseconsistsoftablesthataremadeupofrowsandcolumns.
TablesAdatabaseinaRDBMSisacollectionofinformationthatisgroupedintooneormoretables.Atableisanarrayofdataitemsorganizedintorowsandcolumns.Stock
PPSServiceDataTableINServiceDatabaseFPHServiceDataTableSubscriberDataTableTablesarerelationalSubIDBalanceIDDFlag1001100.0001012200.001MSISDNNumBalanceIDDFlagSubID1001100.0001001012200.001101FPHNumBalanceIDDFlagSubID80081012341100.00010080081043212200.001101
RowsStockRowsEachrowofatablestandsforoneinstanceofthesubjectofthetable,whichisoneparticularexampleofthatentity.
ColumnsEachcolumnofatablestandsforoneattribute,whichisonecharacteristic,feature,orfactthatistrueofthesubjectofthetable.ColumnsStock
TheRelationalModelArelationaldatabaseconsistsoftablesthataremadeupofrowsandcolumns.NameIDAddressAgeTom1NewYork,U.S.A.15Mike2London,U.K.17Leon3Beijing,P.R.China21Jack4Tokyo,Japan18Lisa5Paris,France15column=attributerow=instancetable=entity
OperationsonTables
DatabaseObjects1添加标题Object Description4添加标题Sequence Numericvaluegenerator6添加标题Synonym Givesalternativenamestoobjects3添加标题View Logicallyrepresentssubsetsofdatafrom oneormoretables2添加标题Table Basicunitofstorage;composedofrows andcolumns5添加标题I