版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领
文档简介
DefineDatabaseObjectsCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsCopyrig1DefineDatabaseObjectsOBJECTIVESDefineTablespacesDefineTablesandIndexesDefineSegments,Extents,andBlocksCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsOBJECTI2DefineDatabaseObjectsOverviewDatabaseTablespaceTables,indexes,etc.DatafilesSegmentExtentBlocksCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsOvervi3TablespacesLargestlogicalunitofspaceConsistofoneormoredatafilesSYSTEMtablespacemustexistTablespaceCopyright©2001GlobalBusinessSolutions,Inc.TablespacesLargestlogicaluni4TypesofTablespacesSystem/NonsystemOnline/OfflineRead-Write/Read-OnlyTransportableCopyright©2001GlobalBusinessSolutions,Inc.TypesofTablespacesSystem/Non5SystemandNonsystemTablespacesSystemAtleastoneDataDictionaryRollbackNonsystemFacilitatesAdministrationUser/ApplicationData,IndexesRollbackandTemporarySegmentsCopyright©2001GlobalBusinessSolutions,Inc.SystemandNonsystemTablespac6OnlineandOfflineTablespacesOnlineAvailabletoapplicationsTypicallytablespacesonlineOfflineNotavailabletousers,evenifdatabaseisavailableUseformaintenance,troubleshooting,orhistoricaldatanolongerneededOnlineOfflineCopyright©2001GlobalBusinessSolutions,Inc.OnlineandOfflineTablespaces7Read-WriteandRead-OnlyTablespacesRead-WriteCreate,alter,anddropdatabaseobjectsDefaultRead-OnlyCannotcreateoralterdatabaseobjectsCandropcertainobjectsCanresideonWormdeviceorCDROMEliminateredundantdatabackupsIdealforDataWarehouseapplicationsandLookuptablesRead-WriteRead-OnlyCopyright©2001GlobalBusinessSolutions,Inc.Read-WriteandRead-OnlyTable8TipsforRead-OnlyTablespacesOrganizebymodificationrequirementsFrequencyofdatachangeBackuprequirementSecurityrequirementUserrequirementAssociateddatafilecannotbe:ResizedorhaveautoextendsettoonRenamedtoanewdatafilenameordirectoryOfflineCopyright©2001GlobalBusinessSolutions,Inc.TipsforRead-OnlyTablespaces9TransportableTablespacesSystemTablespaceTransportableTablespaceSystemTablespaceExportImportCopyUtilityTransportableTablespaceSourceDatabaseTargetDatabaseCopyright©2001GlobalBusinessSolutions,Inc.TransportableTablespacesSyste10UsesofTransportableTablespacesArchiveOLTPanddatawarehousesystemsTransferdatafromOLTPtodatawarehousestagingsystemsLoadingdatamartsfromcentraldatawarehousesPublishdataMoveindexdataandavoidrebuildsCopyright©2001GlobalBusinessSolutions,Inc.UsesofTransportableTablespa11TablesStoredinTablespacesOrganizedinrowsandcolumnsContaindataTablespaceTables,indexes,etc.DatafilesSegmentExtentBlocksCopyright©2001GlobalBusinessSolutions,Inc.TablesStoredinTablespacesTab12TableDatatypesCHARVARCHAR2NUMBERDATALOBCustomersName
Address
Phone…..George..123Cherry555-5555Copyright©2001GlobalBusinessSolutions,Inc.TableDatatypesCHARCustomersCo13LargeObjectDatatypeStoreUnstructuredInformationTextdocumentsStaticimagesVideoAudioCustomersNameAddress...PhotoGreetingGeorge..123Cherry
Copyright©2001GlobalBusinessSolutions,Inc.LargeObjectDatatypeStoreUns14LOBTypesCLOBstorescharacterdataNCLOBstoresdouble-bytecharacterdataBLOBstoresbinarydata:graphics,video,soundBFILEstorespointerstoexternalfilesExternalFileSystemCustomersName…History
Photo
GreetingGeorge
Copyright©2001GlobalBusinessSolutions,Inc.LOBTypesCLOBstorescharacter15ExternalFileSystemLOBLocatorsLOBdatastoredseparatefromnon-LOBdataBFILEdatastoredseparatefromdatabaseTablespaceA
TableName
Add…
*(LocatorspointtoLOBandBFILELocations)TablespaceB
Copyright©2001GlobalBusinessSolutions,Inc.ExternalFileLOBLocatorsLOB16TemporaryTablesStoresession/transactionspecificdataShowdataonlytocreatingsessionDiscarddataoncommitorpreservedatauntilsessionendsTablespaceA
Temp01
Temp02Copyright©2001GlobalBusinessSolutions,Inc.TemporaryTablesStoresession/17CustomersIndex#Name
1AcmeInc.2Zachary’s3Marie’s4ChimneyIndexesOptimizequeriesROWID(Block#.Row#.File#)StoredindependentoftablesConsumeminimalspaceReduceI/OIndexonWHEREclausecolumnsCustomersTable#NameAddre..3Marie’s 4456Si1AcmeInc. 1236Ch4Chimney 9024F2Zachary’s 1234BrCopyright©2001GlobalBusinessSolutions,Inc.CustomersIndexIndexesOptimize18IndexTypesUniqueDuplicatesnotallowedNon-uniqueDuplicatesallowedXCopyright©2001GlobalBusinessSolutions,Inc.IndexTypesUniqueXCopyright©19IndexTypesSingleColumnIndex RowidOrderNo Block#.Seq#.File#007000 0000A.0004.0003007000 0000A.0005.0003OrderNoItemNoCust.006989 001 ABC006989 002 XYZ006989 003 USA007000 001 USA007000 002 GBSI007000 003 TEST007000 004 XYZ007234 005 WESTORDERTABLECopyright©2001GlobalBusinessSolutions,Inc.IndexTypesSingleColumnIndex 20IndexTypesMulti-ColumnConcatenated,compositeIndexRowidOrderNoItemNoBlock#.Seq#.File#006989 001 0000A .0005 .0003006989 002 0000A .0006 .0003OrderNoItemNoCust.007000001USA007000002GBSI007000003TEST007234005WEST006989001ABC006989002XYZORDERTABLECopyright©2001GlobalBusinessSolutions,Inc.IndexTypesMulti-ColumnIndex21BalancedIndexTree(B*Tree)ROOTBRANCHROWIDPOINTERDATASEGMENT0000020004000000020002001249930003001400149995000700090005000599970007200810090009999ROWID|1/4”RolledSheet|100Feet|5Days|C.O.D.LEAFCopyright©2001GlobalBusinessSolutions,Inc.BalancedIndexTree(B*Tree)RO22BitmapIndexBitmapcreatedforeachcolumnvalueCommonUsageVeryLargeTablesLow-CardinalityColumnsFeaturesRequiresminimalstorageImprovesperformance‘F’BILLLISAANNTED10010110‘M’GENDERCopyright©2001GlobalBusinessSolutions,Inc.BitmapIndexBitmapcreatedfor23FunctionBasedIndexCreateonfunctionsorexpressionsUsergeneratedPL/SQLSQLfunctions(non-aggregate)Externalprogram(Ccallout)600500300250900660550330275990SALARY*1.10SALARYFunction-BasedSingleSQL>SELECTsalary,salary*1.10FROMemployees;Copyright©2001GlobalBusinessSolutions,Inc.FunctionBasedIndexCreateon24PartitionDataDecomposetablesandindexesEachpartitioncanbestoredindifferenttablespaceCustomerCustNo
CustName
State…1KodakNYOracleCAUSSteelPA6QuestWA7MotorolaTX
CustomersAL…INCustomersKS…NYCustomersOH…WYCopyright©2001GlobalBusinessSolutions,Inc.PartitionDataDecomposetables25AdvantagesofPartitionsReducetimefordataloadsandindexcreationIncreaseavailabilityofmission-criticaldatabasesCreatepartitionindependenceEnableconcurrentoperationsonseparatepartitionsExecutequeriesonpartitionsinsteadoffulltablescanCopyright©2001GlobalBusinessSolutions,Inc.AdvantagesofPartitionsReduce26AdvantagesofPartitionsControldatastorageacrossphysicaldevicesMaintainpartitiontransparencyProgramsdonotneedtoreferencepartitionsProgramscantakeadvantageofpartitionsCopyright©2001GlobalBusinessSolutions,Inc.AdvantagesofPartitionsContro27EquipartitionsDatabaseobjectshavesamelogicalpartitionsExamplesMasteranddetailtableTableandindexOrderTableItemTableCustomerTableCustomerbyStateCopyright©2001GlobalBusinessSolutions,Inc.EquipartitionsDatabaseobjects28GlobalPartitionedIndexesCanimproveperformanceCancontainkeysfromallpartitionsofcorrespondingtableCustomerSalesIndexCustomersAL…INCustomersKS…NYCustomersOH…WYCopyright©2001GlobalBusinessSolutions,Inc.GlobalPartitionedIndexesCan29IndexOrganizedTablesDatastoredwithB*TreeindexTablemusthaveprimarykey,whichactsasindexAppropriateforcomplexorunstructureddataSpatialOLAPDataDataData90009999DataDataDataDataDataData3001400149990000020004000DataDataData5000700090005000799900002999Copyright©2001GlobalBusinessSolutions,Inc.IndexOrganizedTablesDatasto30TablespaceandDatafileRelationshipTablespaceTables,indexes,etc.DatafilesSegmentExtentAtablespaceiscreatedwithoneormore datafilesDatafilesaremadeupofblocksBlocksCopyright©2001GlobalBusinessSolutions,Inc.TablespaceandDatafileRelati31StorageObjectandSegmentRelationshipCreateastorageobjectintablespaceTables,indexes,etc.arepreallocatedtosegmentsSegmentExtentSegmentMySegmentBlocksCopyright©2001GlobalBusinessSolutions,Inc.StorageObjectandSegmentRel32DatabaseSegmentsSetofextentscontainingspecifictypesofdataBootstrapSegmentTemporarySegmentRollbackSegmentIndexSegmentDataSegmentExtentExtentExtentCopyright©2001GlobalBusinessSolutions,Inc.DatabaseSegmentsSetofextent33DataSegmentsStoresrowsforTablesTablefeaturesContainsuserdataContainsDataDictionarydataRowFeaturesContainunlimitednumberofrowsSpanblocks(chaining)ColumnsstoredsidebysideBootstrapSegmentRollbackSegmentIndexSegmentDataSegmentCopyright©2001GlobalBusinessSolutions,Inc.DataSegmentsStoresrowsforT34IndexSegmentsCreatedforeveryindexExistasseparatephysicalsegmentsfromdatasegmentUsuallymuchsmallerthanassociateddatasegmentBootstrapSegmentRollbackSegmentIndexSegmentIndexSegmentCopyright©2001GlobalBusinessSolutions,Inc.IndexSegmentsCreatedforever35RollbackSegmentsRecordbeforeimageofmodifieddataAllowchangestobeundonebeforecommitSupportreadconsistencySupportdataconcurrencySupportdatabaserecoveryASYSTEMrollbacksegmentisrequiredBootstrapSegmentRollbackSegmentIndexSegmentRollbackSegmentCopyright©2001GlobalBusinessSolutions,Inc.RollbackSegmentsRecordbefore36RollbackSegmentTypesPrivateMustincludesegmentnameinROLLBACK_SEGMENTSparameterPublicApoolofrollbacksegmentsthatmaybeacquiredbyanyinstancemountingdatabaseDeferredCreatedinSYSTEMtablespacewhentablespacetakenofflineandtransactionscannotberolledbackCopyright©2001GlobalBusinessSolutions,Inc.RollbackSegmentTypesPrivateC37RollbackSegmentUsageUndodataiswrittentosegmentEachextentsupportsmultipletransactionsEachtransactionwritestoitsownblock(s)Ifextentfills,automaticallyextendsIfallextentsfill,segmentwrapsIfsegmentwraps,undodataoverwrittenIfundodatanotavailable,erroroccurs“Snapshottooold”“Cannotallocateextent”Copyright©2001GlobalBusinessSolutions,Inc.RollbackSegmentUsageUndodat38ReadConsistencyWhenqueryexecutes:CurrenttimedeterminedBlockswithsametimereadNewerblocksreconstructedwithrollbacksegmentsCustomers#NameAddress…1AcmeInc.123Ch2Zachary’s1234Br3Marie’s4456Si4Chimney9024FSELECT*FROMcustomerUPDATEcustomer...Copyright©2001GlobalBusinessSolutions,Inc.ReadConsistencyWhenqueryexe39TemporarySegmentsProvidetemporaryworkspaceCreatedautomaticallyforjoins,indexes,sortsCreatedondiskwhenmemoryfullSizedbyDEFAULTSTORAGEclauseoftablespaceReclaimedbySMONBootstrapSegmentRollbackSegmentIndexSegment
TemporarySegmentCopyright©2001GlobalBusinessSolutions,Inc.TemporarySegmentsProvidetemp40BootstrapSegmentContainsdictionarydefinitionsloadedonopenIsnotuseraccessibleResidesinSYSTEMtablespaceRequiresnoDBAmaintenanceBootstrapSegmentRollbackSegmentIndexSegmentBootstrapSegmentCopyright©2001GlobalBusinessSolutions,Inc.BootstrapSegmentContainsdict41DatabaseExtentsConsistofasetofcontiguousblocksServeasspaceallocationforsegmentDe-allocatedwhensegmentisremovedFirstextentcreatedasInitialExtentGrowbyNextExtentSegmentExtentExtentExtentCopyright©2001GlobalBusinessSolutions,Inc.DatabaseExtentsConsistofas42DatabaseBlocksAre:smallestunitofstoragesizedbyDB_BLOCK_SIZEsameasbufferindatabasebuffercacheCorrespondtoO/SblockTypicallysizedas2k,4k,8k,or16kSegmentExtentBlocksCopyright©2001GlobalBusinessSolutions,Inc.DatabaseBlocksAre:Correspond43DefineDatabaseObjectsSummaryTablespacesarelogicalcollectionsofdatabaseobjectswithoneormoredatafilesUponcreation,spaceispreallocatedfortablespacesTablespaceTables,indexes,etc.DatafilesSegmentExtentBlocksCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsSummar44DefineDatabaseObjectsSummarySegmentsarepreallocatedwhenobjectscreatedSegmentsconsistofextentsExtentsareasetofcontiguousblocksAsdataisadded,segmentsfillupStoragemanagementisessentialDataSegmentCustomers#NameAddress…1AcmeInc.123Ch2Zachary’s1234Br3Marie’s4456Si4Chimney9024FCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsSummar45DefineDatabaseObjectsCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsCopyrig46DefineDatabaseObjectsOBJECTIVESDefineTablespacesDefineTablesandIndexesDefineSegments,Extents,andBlocksCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsOBJECTI47DefineDatabaseObjectsOverviewDatabaseTablespaceTables,indexes,etc.DatafilesSegmentExtentBlocksCopyright©2001GlobalBusinessSolutions,Inc.DefineDatabaseObjectsOvervi48TablespacesLargestlogicalunitofspaceConsistofoneormoredatafilesSYSTEMtablespacemustexistTablespaceCopyright©2001GlobalBusinessSolutions,Inc.TablespacesLargestlogicaluni49TypesofTablespacesSystem/NonsystemOnline/OfflineRead-Write/Read-OnlyTransportableCopyright©2001GlobalBusinessSolutions,Inc.TypesofTablespacesSystem/Non50SystemandNonsystemTablespacesSystemAtleastoneDataDictionaryRollbackNonsystemFacilitatesAdministrationUser/ApplicationData,IndexesRollbackandTemporarySegmentsCopyright©2001GlobalBusinessSolutions,Inc.SystemandNonsystemTablespac51OnlineandOfflineTablespacesOnlineAvailabletoapplicationsTypicallytablespacesonlineOfflineNotavailabletousers,evenifdatabaseisavailableUseformaintenance,troubleshooting,orhistoricaldatanolongerneededOnlineOfflineCopyright©2001GlobalBusinessSolutions,Inc.OnlineandOfflineTablespaces52Read-WriteandRead-OnlyTablespacesRead-WriteCreate,alter,anddropdatabaseobjectsDefaultRead-OnlyCannotcreateoralterdatabaseobjectsCandropcertainobjectsCanresideonWormdeviceorCDROMEliminateredundantdatabackupsIdealforDataWarehouseapplicationsandLookuptablesRead-WriteRead-OnlyCopyright©2001GlobalBusinessSolutions,Inc.Read-WriteandRead-OnlyTable53TipsforRead-OnlyTablespacesOrganizebymodificationrequirementsFrequencyofdatachangeBackuprequirementSecurityrequirementUserrequirementAssociateddatafilecannotbe:ResizedorhaveautoextendsettoonRenamedtoanewdatafilenameordirectoryOfflineCopyright©2001GlobalBusinessSolutions,Inc.TipsforRead-OnlyTablespaces54TransportableTablespacesSystemTablespaceTransportableTablespaceSystemTablespaceExportImportCopyUtilityTransportableTablespaceSourceDatabaseTargetDatabaseCopyright©2001GlobalBusinessSolutions,Inc.TransportableTablespacesSyste55UsesofTransportableTablespacesArchiveOLTPanddatawarehousesystemsTransferdatafromOLTPtodatawarehousestagingsystemsLoadingdatamartsfromcentraldatawarehousesPublishdataMoveindexdataandavoidrebuildsCopyright©2001GlobalBusinessSolutions,Inc.UsesofTransportableTablespa56TablesStoredinTablespacesOrganizedinrowsandcolumnsContaindataTablespaceTables,indexes,etc.DatafilesSegmentExtentBlocksCopyright©2001GlobalBusinessSolutions,Inc.TablesStoredinTablespacesTab57TableDatatypesCHARVARCHAR2NUMBERDATALOBCustomersName
Address
Phone…..George..123Cherry555-5555Copyright©2001GlobalBusinessSolutions,Inc.TableDatatypesCHARCustomersCo58LargeObjectDatatypeStoreUnstructuredInformationTextdocumentsStaticimagesVideoAudioCustomersNameAddress...PhotoGreetingGeorge..123Cherry
Copyright©2001GlobalBusinessSolutions,Inc.LargeObjectDatatypeStoreUns59LOBTypesCLOBstorescharacterdataNCLOBstoresdouble-bytecharacterdataBLOBstoresbinarydata:graphics,video,soundBFILEstorespointerstoexternalfilesExternalFileSystemCustomersName…History
Photo
GreetingGeorge
Copyright©2001GlobalBusinessSolutions,Inc.LOBTypesCLOBstorescharacter60ExternalFileSystemLOBLocatorsLOBdatastoredseparatefromnon-LOBdataBFILEdatastoredseparatefromdatabaseTablespaceA
TableName
Add…
*(LocatorspointtoLOBandBFILELocations)TablespaceB
Copyright©2001GlobalBusinessSolutions,Inc.ExternalFileLOBLocatorsLOB61TemporaryTablesStoresession/transactionspecificdataShowdataonlytocreatingsessionDiscarddataoncommitorpreservedatauntilsessionendsTablespaceA
Temp01
Temp02Copyright©2001GlobalBusinessSolutions,Inc.TemporaryTablesStoresession/62CustomersIndex#Name
1AcmeInc.2Zachary’s3Marie’s4ChimneyIndexesOptimizequeriesROWID(Block#.Row#.File#)StoredindependentoftablesConsumeminimalspaceReduceI/OIndexonWHEREclausecolumnsCustomersTable#NameAddre..3Marie’s 4456Si1AcmeInc. 1236Ch4Chimney 9024F2Zachary’s 1234BrCopyright©2001GlobalBusinessSolutions,Inc.CustomersIndexIndexesOptimize63IndexTypesUniqueDuplicatesnotallowedNon-uniqueDuplicatesallowedXCopyright©2001GlobalBusinessSolutions,Inc.IndexTypesUniqueXCopyright©64IndexTypesSingleColumnIndex RowidOrderNo Block#.Seq#.File#007000 0000A.0004.0003007000 0000A.0005.0003OrderNoItemNoCust.006989 001 ABC006989 002 XYZ006989 003 USA007000 001 USA007000 002 GBSI007000 003 TEST007000 004 XYZ007234 005 WESTORDERTABLECopyright©2001GlobalBusinessSolutions,Inc.IndexTypesSingleColumnIndex 65IndexTypesMulti-ColumnConcatenated,compositeIndexRowidOrderNoItemNoBlock#.Seq#.File#006989 001 0000A .0005 .0003006989 002 0000A .0006 .0003OrderNoItemNoCust.007000001USA007000002GBSI007000003TEST007234005WEST006989001ABC006989002XYZORDERTABLECopyright©2001GlobalBusinessSolutions,Inc.IndexTypesMulti-ColumnIndex66BalancedIndexTree(B*Tree)ROOTBRANCHROWIDPOINTERDATASEGMENT0000020004000000020002001249930003001400149995000700090005000599970007200810090009999ROWID|1/4”RolledSheet|100Feet|5Days|C.O.D.LEAFCopyright©2001GlobalBusinessSolutions,Inc.BalancedIndexTree(B*Tree)RO67BitmapIndexBitmapcreatedforeachcolumnvalueCommonUsageVeryLargeTablesLow-CardinalityColumnsFeaturesRequiresminimalstorageImprovesperformance‘F’BILLLISAANNTED10010110‘M’GENDERCopyright©2001GlobalBusinessSolutions,Inc.BitmapIndexBitmapcreatedfor68FunctionBasedIndexCreateonfunctionsorexpressionsUsergeneratedPL/SQLSQLfunctions(non-aggregate)Externalprogram(Ccallout)600500300250900660550330275990SALARY*1.10SALARYFunction-BasedSingleSQL>SELECTsalary,salary*1.10FROMemployees;Copyright©2001GlobalBusinessSolutions,Inc.FunctionBasedIndexCreateon69PartitionDataDecomposetablesandindexesEachpartitioncanbestoredindifferenttablespaceCustomerCustNo
CustName
State…1KodakNYOracleCAUSSteelPA6QuestWA7MotorolaTX
CustomersAL…INCustomersKS…NYCustomersOH…WYCopyright©2001GlobalBusinessSolutions,Inc.PartitionDataDecomposetables70AdvantagesofPartitionsReducetimefordataloadsandindexcreationIncreaseavailabilityofmission-criticaldatabasesCreatepartitionindependenceEnableconcurrentoperationsonseparatepartitionsExecutequeriesonpartitionsinsteadoffulltablescanCopyright©2001GlobalBusinessSolutions,Inc.AdvantagesofPartitionsReduce71AdvantagesofPartitionsControldatastorageacrossphysicaldevicesMaintainpartitiontransparencyProgramsdonotneedtoreferencepartitionsProgramscantakeadvantageofpartitionsCopyright©2001GlobalBusinessSolutions,Inc.AdvantagesofPartitionsContro72EquipartitionsDatabaseobjectshavesamelogicalpartitionsExamplesMasteranddetailtableTableandindexOrderTableItemTableCustomerTableCustomerbyStateCopyright©2001GlobalBusinessSolutions,Inc.EquipartitionsDatabaseobjects73GlobalPartitionedIndexesCanimproveperformanceCancontainkeysfromallpartitionsofcorrespondingtableCustomerSalesIndexCustomersAL…INCustomersKS…NYCustomersOH…WYCopyright©2001GlobalBusinessSolutions,Inc.GlobalPartitionedIndexesCan74IndexOrganizedTablesDatastoredwithB*TreeindexTablemusthaveprimarykey,whichactsasindexAppropriateforcomplexorunstructureddataSpatialOLAPDataDataData90009999DataDataDataDataDataData3001400149990000020004000DataDataData5000700090005000799900002999Copyright©2001GlobalBusinessSolutions,Inc.IndexOrganizedTablesDatasto75TablespaceandDatafileRelationshipTablespaceTables,indexes,etc.DatafilesSegmentExtentAtablespaceiscreatedwithoneormore datafilesDatafilesaremadeupofblocksBlocksCopyright©2001GlobalBusinessSolutions,Inc.TablespaceandDatafileRelati76StorageObjectandSegmentRelationshipCreateastorageobjectintablespaceTables,indexes,etc.arepreallocatedtosegmentsSegmentExtentSegmentMySegmentBlocksCopyright©2001GlobalBusinessSolutions,Inc.StorageObjectandSegmentRel77DatabaseSegmentsSetofextentscontainingspecifictypesofdataBootstrapSegmentTemporarySegmentRollbackSegmentIndexSegmentDataSegmentExtentExtentExtentCopyright©2001GlobalBusinessSolutions,Inc.DatabaseSegmentsSetofextent78DataSegmentsStoresrowsforTablesTablefeaturesContainsuserdataContainsDataDictionarydataRowFeaturesContainunlimitednumberofrowsSpanblocks(chaining)ColumnsstoredsidebysideBootstrapSegmentRollbackSegmentIndexSegmentDataSegmentCopyright©2001GlobalBusinessSolutions,Inc.DataSegmentsStoresrowsforT79IndexSegmentsCreatedforeveryindexExistasseparatephysicalsegmentsfromdatasegmentUsuallymuchsmallerthanassociateddatasegmentBootstrapSegmentRollbackSegmentIndexSegmentIndexSegmentCopyright©2001GlobalBusinessSolutions,Inc.IndexSegmentsCreatedforever80RollbackSegmentsRecordbeforeimageofmodifieddataAllowchangestobeundonebeforecommitSupportreadconsistencySupportdataconcurrencySupportdatabaserecoveryASYSTEMrollbacksegmentisrequiredBootstrapSegmentRollbackSegmentIndexSegmentRollbackSegmentCopyright©2001GlobalBusinessSolutions,Inc.RollbackSegmentsRecordbefore81RollbackSegmentTypesPrivateMustincludesegmentnameinROLLBACK_SEGMENTSparameterPublicApoolofrollbacksegmentsthatmaybeacquiredbyanyinstancemountingdatabaseDeferredCreatedinSYSTEMtablespacewhentablespacetakenofflineandtransactionscannotberolledbackCopyright©2001GlobalBusinessSolutions,Inc.RollbackSegmentType
温馨提示
- 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2024版合法借款合同模板
- 2024年度电机维修配件销售与代理合同
- 2024年保险合同（财产）
- 2024年度智能物流系统研发与实施合同
- 2024年度租赁合同标的及服务内容详细描述
- 2024年卫星发射服务提供商与客户的发射合同
- 0架AC3A直升机购销合同（二零二四年版）
- 2024年度城市轨道交通建设施工合同
- 2024年家具采购合同注意事项
- 2024年度技术服务合同：人工智能公司与制造企业间的智能制造解决方案
- 2024版《糖尿病健康宣教》课件
- ktv保安管理制度及岗位职责(共5篇)
- 脑出血试题完整版本
- 义务教育信息科技课程标准(2022年版)考试题库及答案
- 建筑施工安全生产责任书
- 新员工三级安全教育考试试题参考答案
- 公司年会策划及执行服务合同
- 概算审核服务投标方案（技术方案）
- 人教版（2019）选择性必修第二册Unit 2 Bridging Cultures Learning About Language教学设计
- 数学史简介课件可编辑全文
- 化工原理课程设计附录二
评论
0/150
提交评论