数据库基础知识培训胶.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