Oracle Database Data Warehousing Guide 10g Releas

Oracle®DatabaseDataWarehousingGuide10gRelease1(10.1)PartNo.B10736-01December2003OracleDatabaseDataWarehousingGuide,10gRelease1(10.1)PartNo.B10736-01Copyright©2001,2003OracleCorporation.Allrightsreserved.PrimaryAuthor:PaulLaneContributingAuthors:VivSchupmann,IngridStuart(ChangeDataCapture)Contributors:PatrickAmor,HermannBaer,MarkBauer,SubhransuBasu,SrikanthBellamkonda,RandyBello,TolgaBozkaya,LucyBurgess,RushanChen,BenoitDageville,JohnHaydu,LilianHobbs,HakanJakobsson,GeorgeLumpkin,AlexMelidis,ValarieMoore,CetinOzbutun,AnanthRaghavan,JackRaitto,RayRoccaforte,SankarSubramanian,GregorySmith,MuraliThiyagarajan,AshishThusoo,ThomasTong,Jean-FrancoisVerrier,GaryVincent,AndreasWalter,AndyWitkowski,MinXiao,Tsae-FengYuThePrograms(whichincludeboththesoftwareanddocumentation)containproprietaryinformationofOracleCorporation;theyareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandarealsoprotectedbycopyright,patentandotherintellectualandindustrialpropertylaws.Reverseengineering,disassemblyordecompilationofthePrograms,excepttotheextentrequiredtoobtaininteroperabilitywithotherindependentlycreatedsoftwareorasspecifiedbylaw,isprohibited.Theinformationcontainedinthisdocumentissubjecttochangewithoutnotice.Ifyoufindanyproblemsinthedocumentation,pleasereportthemtousinwriting.OracleCorporationdoesnotwarrantthatthisdocumentiserror-free.ExceptasmaybeexpresslypermittedinyourlicenseagreementforthesePrograms,nopartoftheseProgramsmaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,foranypurpose,withouttheexpresswrittenpermissionofOracleCorporation.IftheProgramsaredeliveredtotheU.S.GovernmentoranyonelicensingorusingtheprogramsonbehalfoftheU.S.Government,thefollowingnoticeisapplicable:RestrictedRightsNoticeProgramsdeliveredsubjecttotheDODFARSupplementarecommercialcomputersoftwareanduse,duplication,anddisclosureofthePrograms,includingdocumentation,shallbesubjecttothelicensingrestrictionssetforthintheapplicableOraclelicenseagreement.Otherwise,ProgramsdeliveredsubjecttotheFederalAcquisitionRegulationsarerestrictedcomputersoftwareanduse,duplication,anddisclosureoftheProgramsshallbesubjecttotherestrictionsinFAR52.227-19,CommercialComputerSoftware-RestrictedRights(June,1987).OracleCorporation,500OracleParkway,RedwoodCity,CA94065.TheProgramsarenotintendedforuseinanynuclear,aviation,masstransit,medical,orotherinherentlydangerousapplications.Itshallbethelicensee'sresponsibilitytotakeallappropriatefail-safe,backup,redundancy,andothermeasurestoensurethesafeuseofsuchapplicationsiftheProgramsareusedforsuchpurposes,andOracleCorporationdisclaimsliabilityforanydamagescausedbysuchuseofthePrograms.Oracleisaregisteredtrademark,andExpress,Oracle8i,Oracle9i,OracleStore,PL/SQL,Pro*C,andSQL*PlusaretrademarksorregisteredtrademarksofOracleCorporation.Othernamesmaybetrademarksoftheirrespectiveowners.iiiContentsSendUsYourComments..............................................................................................................xxixPreface........................................................................................................................................................xxxiAudience............................................................................................................................................xxxiiOrganization......................................................................................................................................xxxiiRelatedDocumentation..................................................................................................................xxxivConventions.......................................................................................................................................xxxvDocumentationAccessibility.......................................................................................................xxxviiiWhat'sNewinOracleDatabase?.............................................................................................xxxixOracleDatabase10gRelease1(10.1)NewFeaturesinDataWarehousing..................................xlVolume1PartIConcepts1DataWarehousingConceptsWhatisaDataWarehouse?...............................................................................................................1-2SubjectOriented............................................................................................................................1-2Integrated.......................................................................................................................................1-2Nonvolatile....................................................................................................................................1-3TimeVariant..................................................................................................................................1-3ContrastingOLTPandDataWarehousingEnvironments.....................................................1-3DataWarehouseArchitectures..........................