资源描述
Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,Copyright,2001 Global Business Solutions,Inc.,*,Define Database Objects,Copyright,2001 Global Business Solutions,Inc.,DefineDatabaseObjects,OBJECTIVES,DefineTablespaces,DefineTablesandIndexes,DefineSegments,Extents,andBlocks,Copyright,2001GlobalBusinessSolutions,Inc.,DefineDatabaseObjectsOverview,Database,Tablespace,Tables,indexes,etc.,Datafiles,Segment,Extent,Blocks,Copyright,2001GlobalBusinessSolutions,Inc.,Tablespaces,Largestlogicalunitofspace,Consistofoneormoredatafiles,SYSTEMtablespacemustexist,Tablespace,Copyright,2001GlobalBusinessSolutions,Inc.,TypesofTablespaces,System/Nonsystem,Online/Offline,Read-Write/Read-Only,Transportable,Copyright,2001GlobalBusinessSolutions,Inc.,SystemandNonsystemTablespaces,System,Atleastone,DataDictionary,Rollback,Nonsystem,FacilitatesAdministration,User/ApplicationData,Indexes,RollbackandTemporarySegments,Copyright,2001GlobalBusinessSolutions,Inc.,OnlineandOfflineTablespaces,Online,Availabletoapplications,Typicallytablespacesonline,Offline,Notavailabletousers,evenifdatabaseisavailable,Useformaintenance,troubleshooting,orhistoricaldatanolongerneeded,Online,Offline,Copyright,2001GlobalBusinessSolutions,Inc.,Read-WriteandRead-OnlyTablespaces,Read-Write,Create,alter,anddropdatabaseobjects,Default,Read-Only,Cannotcreateoralterdatabaseobjects,Candropcertainobjects,CanresideonWormdeviceorCDROM,Eliminateredundantdatabackups,IdealforDataWarehouseapplicationsandLookuptables,Read-Write,Read-Only,Copyright,2001GlobalBusinessSolutions,Inc.,TipsforRead-Only Tablespaces,Organizebymodificationrequirements,Frequency ofdata change,Backup requirement,Securityrequirement,Userrequirement,Associated datafilecannot be:,Resizedor haveautoextendsetto on,Renamedto anewdatafile name or directory,Offline,Copyright,2001GlobalBusinessSolutions,Inc.,Transportable Tablespaces,System Tablespace,Transportable,Tablespace,System Tablespace,Export,Import,Copy,Utility,Transportable,Tablespace,Source,Database,Target,Database,Copyright,2001GlobalBusinessSolutions,Inc.,UsesofTransportable Tablespaces,ArchiveOLTPanddata warehousesystems,Transferdata from OLTPto datawarehouse staging systems,Loadingdatamarts fromcentraldatawarehouses,Publishdata,Moveindex dataandavoid rebuilds,Copyright,2001GlobalBusinessSolutions,Inc.,Tables,Stored in Tablespaces,Organized inrows and columns,Containdata,Tablespace,Tables,indexes,etc.,Datafiles,Segment,Extent,Blocks,Copyright,2001GlobalBusinessSolutions,Inc.,Table Datatypes,CHAR,VARCHAR2,NUMBER,DATA,LOB,Customers,NameAddressPhone,.,George.123Cherry555-5555,Copyright,2001GlobalBusinessSolutions,Inc.,Large ObjectDatatype,Store Unstructured Information,Textdocuments,Static images,Video,Audio,Customers,NameAddress.PhotoGreeting,George.123 Cherry,Copyright,2001GlobalBusinessSolutions,Inc.,LOBTypes,CLOBstorescharacter data,NCLOB storesdouble-bytecharacter data,BLOBstoresbinary data:graphics,video,sound,BFILE storespointers toexternal files,ExternalFile,System,Customers,Name,HistoryPhotoGreeting,George,Copyright,2001GlobalBusinessSolutions,Inc.,ExternalFile,System,LOBLocators,LOBdatastoredseparatefrom non-LOB data,BFILE data stored separate fromdatabase,Tablespace A,Table,NameAdd,*(,Locatorspoint to LOB and BFILELocations),Tablespace B,Copyright,2001GlobalBusinessSolutions,Inc.,Temporary Tables,Store session/transaction specificdata,Showdata only to creating session,Discarddataoncommit or preserve datauntil session ends,Tablespace A,Temp01,Temp02,Copyright,2001GlobalBusinessSolutions,Inc.,Customers Index,#Name,1 Acme Inc.,2 Zacharys,3 Maries,4 Chimney,Indexes,Optimizequeries,ROWID(Block#.Row#.File#),Stored independent of tables,Consumeminimalspace,Reduce I/O,Index onWHERE clause columns,Customers Table,#NameAddre.,3 Maries4456 Si,1 Acme Inc.1236Ch,4 Chimney9024 F,2 Zacharys1234Br,Copyright,2001GlobalBusinessSolutions,Inc.,Index Types,Unique,Duplicates not allowed,Non-unique,Duplicates allowed,X,Copyright,2001GlobalBusinessSolutions,Inc.,Index Types,Single Column,IndexRowid,OrderNoBlock#.Seq#.File#,0070000000,A.0004.0003,0070000000A.0005.0003,OrderNo ItemNo Cust.,006989 001,ABC,006989 002 XYZ,006989 003 USA,007000 001 USA,007000 002 GBSI,007000 003 TEST,007000 004 XYZ,007234 005 WEST,ORDER TABLE,Copyright,2001GlobalBusinessSolutions,Inc.,Index Types,Multi-Column,Concatenated,composite,IndexRowid,OrderNo ItemNo Block#.Seq#.File#,006989 001 0000,A.0005.0003,006989 002 0000A.0006.0003,OrderNoItemNo Cust.,007000001,USA,007000002GBSI,007000003TEST,007234005WEST,006989001ABC,006989002XYZ,ORDER TABLE,Copyright,2001GlobalBusinessSolutions,Inc.,BalancedIndex Tree(B*Tree),ROOT,BRANCH,ROWID,POINTER,DATA,SEGMENT,0,0000,2000,4000,0000,2000,2001,2499,3000,3001,4001,4999,5000,7000,9000,5000,5999,7000,7200,8100,9000,9999,ROWID|1/4,”,”RolledSheet|100Feet|5Days|C.O.D.,LEAF,Copyright,2001GlobalBusinessSolutions,Inc.,BitmapIndex,Bitmapcreatedforeachcolumnvalue,CommonUsage,VeryLargeTables,Low-C
展开阅读全文