Oracle Data Mining2

Oracle®DataMiningConcepts10gRelease2(10.2)B14339-01June2005OracleDataMiningConcepts,10gRelease2(10.2)B14339-01Copyright©2005,Oracle.Allrightsreserved.PrimaryAuthors:MargaretTaft,RamkumarKrishnan,MarkHornick,DenisMuhkin,GeorgeTang,ShibyThomas,PeterStengardContributingAuthors:CharlieBerger,MarcosCampos,BorianaMilenova,SunilVenkaylaContributor:RobertHaberstrohThePrograms(whichincludeboththesoftwareanddocumentation)containproprietaryinformation;theyareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandarealsoprotectedbycopyright,patent,andotherintellectualandindustrialpropertylaws.Reverseengineering,disassembly,ordecompilationofthePrograms,excepttotheextentrequiredtoobtaininteroperabilitywithotherindependentlycreatedsoftwareorasspecifiedbylaw,isprohibited.Theinformationcontainedinthisdocumentissubjecttochangewithoutnotice.Ifyoufindanyproblemsinthedocumentation,pleasereportthemtousinwriting.Thisdocumentisnotwarrantedtobeerror-free.ExceptasmaybeexpresslypermittedinyourlicenseagreementforthesePrograms,nopartoftheseProgramsmaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,foranypurpose.IftheProgramsaredeliveredtotheUnitedStatesGovernmentoranyonelicensingorusingtheProgramsonbehalfoftheUnitedStatesGovernment,thefollowingnoticeisapplicable:U.S.GOVERNMENTRIGHTSPrograms,software,databases,andrelateddocumentationandtechnicaldatadeliveredtoU.S.GovernmentcustomersarecommercialcomputersoftwareorcommercialtechnicaldatapursuanttotheapplicableFederalAcquisitionRegulationandagency-specificsupplementalregulations.Assuch,use,duplication,disclosure,modification,andadaptationofthePrograms,includingdocumentationandtechnicaldata,shallbesubjecttothelicensingrestrictionssetforthintheapplicableOraclelicenseagreement,and,totheextentapplicable,theadditionalrightssetforthinFAR52.227-19,CommercialComputerSoftware—RestrictedRights(June1987).OracleCorporation,500OracleParkway,RedwoodCity,CA94065TheProgramsarenotintendedforuseinanynuclear,aviation,masstransit,medical,orotherinherentlydangerousapplications.Itshallbethelicensee'sresponsibilitytotakeallappropriatefail-safe,backup,redundancyandothermeasurestoensurethesafeuseofsuchapplicationsiftheProgramsareusedforsuchpurposes,andwedisclaimliabilityforanydamagescausedbysuchuseofthePrograms.Oracle,JDEdwards,PeopleSoft,andRetekareregisteredtrademarksofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.TheProgramsmayprovidelinkstoWebsitesandaccesstocontent,products,andservicesfromthirdparties.Oracleisnotresponsiblefortheavailabilityof,oranycontentprovidedon,third-partyWebsites.Youbearallrisksassociatedwiththeuseofsuchcontent.Ifyouchoosetopurchaseanyproductsorservicesfromathirdparty,therelationshipisdirectlybetweenyouandthethirdparty.Oracleisnotresponsiblefor:(a)thequalityofthird-partyproductsorservices;or(b)fulfillinganyofthetermsoftheagreementwiththethirdparty,includingdeliveryofproductsorservicesandwarrantyobligationsrelatedtopurchasedproductsorservices.Oracleisnotresponsibleforanylossordamageofanysortthatyoumayincurfromdealingwithanythirdparty.iiiContentsPreface................................................................................................................................................................viiIntendedAudience.....................................................................................................................................viiDocumentationAccessibility....................................................................................................................viiRelatedDocuments...................................................................................................................................viiiConventions...............................................................................................................................................viii1IntroductiontoOracleDataMiningWhatisDataMining?..............................................................................................................................1-1WhatIsDataMiningintheDatabase?................................................................................................1-1WhatIsOracleDataMining?.................................................................................................................1-2DataMiningFunctions......................................................................................................................1-2NewFeatures.............................................................................................................................................1-32DataforOracleDataMiningData,Cases,andAttributes....................................................................................................................2-1DataRequirements..................................................................................................................................2-2ODMDataTableFormat...................................................