oracle對象定義(英文版)-文庫吧
2025-01-26 07:35 本頁面
【正文】 nized in rows and columnsn Contain dataTablespaceTables, indexes, etc.DatafilesSegmentExtentBlocksCopyright 169。 2023 Global Business Solutions, Inc.Table Datatypesn CHARn VARCHAR2n NUMBERn DATAn LOBCustomersName Address Phone…..Gee..123 Cherry 555 5555 Copyright 169。 2023 Global Business Solutions, Inc.Large Object Datatypen Store Unstructured Informationl Text documentsl Static imagesl Videol AudioCustomersName Address... Photo Greeting Gee.. 123 Cherry Copyright 169。 2023 Global Business Solutions, Inc.LOB Typesn CLOB stores character datan NCLOB stores doublebyte character datan BLOB stores binary data: graphics, video, soundn BFILE stores pointers to external filesExternal File SystemCustomersName … History Photo GreetingGee Copyright 169。 2023 Global Business Solutions, Inc.External File SystemLOB Locatorsn LOB data stored separate from nonLOB data n BFILE data stored separate from databaseTablespace A TableName Add… * (Locators point to LOB and BFILE Locations)Tablespace B Copyright 169。 2023 Global Business Solutions, Inc.Temporary Tablesn Store session/ transaction specific datan Show data only to creating sessionn Discard data on mit or preserve data until session endsTablespace A Temp01 Temp02Copyright 169。 2023 Global Business Solutions, Inc.Customers Index Name 1 Acme Inc. 2 Zachary’s 3 Marie’s 4 Chimney Indexesn Optimize queriesl ROWID (Block.Row.File)n Stored independent of tablesn Consume minimal spacen Reduce I/On Index on WHERE clause columnsCustomers Table Name Addre..3 Marie’s 4456 Si 1 Acme Inc. 1236 Ch4 Chimney 9024 F 2 Zachary’s 1234 BrCopyright 169。 2023 Global Business Solutions, Inc.Index Typesn Uniquel Duplicates not allowedn Nonuniquel Duplicates allowedXCopyright 169。 2023 Global Business Solutions, Inc.Index Typesn Single ColumnIndex RowidOrderNo Block.Seq.File007000 0000A .0004 .0003007000 0000A .0005 .0003OrderNo ItemNo Cust.006989 001 ABC 006989 002 XYZ006989 003 USA007000 001 USA007000 002 GBSI007000 003 TEST007000 004 XYZ007234 005 WESTORDER TABLECopyright 169。 2023 Global Business So
試題試卷相關(guān)推薦
鄂ICP備17016276號-1