资源描述：
《oracle数据库基本概念》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、oracle数据库基本概念2,data,news,informationData:acollectionofsymbolsdescribingthebasicfeaturesofthingsMessage:acollectionofdatathatdescribesaclassofthingsinaunifiedwayMessage:valuablenews3,datastoragemode(1)artificialstoragestage(2)filestoragephase;(3)databasestoragephase3,database(1)intheoryAsoftwareto
2、olthatusesarangeofdatastoragemodelstostoreandmanagedata(2)popularAcollectionofsoftwarethatphysicallystoresdatahardwareandmanagesdatalogicallyDatabase2,datastoragemodel(1)hierarchical(2)reticulartype;(3)relational1970largerelationaldatabasestoragemodel"Usingtwo-dimensionalstructuretostoredataTuple
3、recordProperty-fieldRelationshipdatabase5.DatabasemanagementsystemDBMSAcollectionofhardware,software,data,users,andnetworkenvironments6、relationaldatabasemanagementsystemRDBMSDesktopRDBMS:stand-aloneversionofaccessVFDistributedRDBMS:sqlserver,Oracle,DB2,sysbase,mysql,NoSQL7,thedevelopmentofOracle
4、1979.ThefirstcommercialdatabaseproductOracleOracle1984Oracle19970racle8Java19980racle8iInternet20010racle9i2004OraclelOg(GridComputing)2007oraclelli8,Oracleinstallationanduninstall(1)premiseMemory1G,diskspace5G,thecacheshouldbemorethan4timesthephysicalmemory(2)installationnotice;A:installationdir
5、ectoryDonotappearinChinese・ItisnotrecommendedtoputtheOraclesystemfilestogetherwiththeOSsystemfilesB:databaseversionEnterpriseEdition:implementsthefunctionsofOLTPandOLAPtomeettheneedsofenterpriselevelserversStandardVersion:toachieveOLTPbetter,toachieveroutinedatastorageandmanagement,applicabletode
6、partmentstostoredataPersonalEditionC:databasenamingGlobaldatabasename:inthewebenvironment,uniquelymarksthenameofeachdatabase,format:databasename・DomainnameSID:systemtoken,whichuniquelyidentifiesthenameofeachdatabaseonthecurrentmachine,format:databasename,alsoknownasinstancename・(1)thestructureaft
7、ertheinstallationA:ServiceApartialversioncreates4or5services・Consoleservice:dbconsole:isusedtostarttheenterprisemanager(adminconsole),optionallystarting・Jobschedulingservice:JobScheduler,toachievetheworkofOracletimer,o
