ORACLE DATAMING APPLICATION DEVELOPER GUIDE

Oracle®DataMiningApplicationDeveloper'sGuide11gRelease1(11.1)B28131-03April2008OracleDataMiningApplicationDeveloper'sGuide,11gRelease1(11.1)B28131-03Copyright©2005,2008,Oracle.Allrightsreserved.ThePrograms(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).OracleUSA,Inc.,500OracleParkway,RedwoodCity,CA94065.TheProgramsarenotintendedforuseinanynuclear,aviation,masstransit,medical,orotherinherentlydangerousapplications.Itshallbethelicensee'sresponsibilitytotakeallappropriatefail-safe,backup,redundancyandothermeasurestoensurethesafeuseofsuchapplicationsiftheProgramsareusedforsuchpurposes,andwedisclaimliabilityforanydamagescausedbysuchuseofthePrograms.Oracle,JDEdwards,PeopleSoft,andSiebelareregisteredtrademarksofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.TheProgramsmayprovidelinkstoWebsitesandaccesstocontent,products,andservicesfromthirdparties.Oracleisnotresponsiblefortheavailabilityof,oranycontentprovidedon,third-partyWebsites.Youbearallrisksassociatedwiththeuseofsuchcontent.Ifyouchoosetopurchaseanyproductsorservicesfromathirdparty,therelationshipisdirectlybetweenyouandthethirdparty.Oracleisnotresponsiblefor:(a)thequalityofthird-partyproductsorservices;or(b)fulfillinganyofthetermsoftheagreementwiththethirdparty,includingdeliveryofproductsorservicesandwarrantyobligationsrelatedtopurchasedproductsorservices.Oracleisnotresponsibleforanylossordamageofanysortthatyoumayincurfromdealingwithanythirdparty.iiiContentsPreface.................................................................................................................................................................vAudience.......................................................................................................................................................vDocumentationAccessibility.....................................................................................................................vRelatedDocumentation..............................................................................................................................viConventions.................................................................................................................................................vi1DataMiningAPIUseCasesAnalyzeCustomerDemographicsandBuyingPatterns..................................................................1-1EvaluatetheSuccessofaMarketingCampaign................................................................................1-4UsePredictiveAnalyticstoCreateaCustomerProfile.....................................................................1-52ATouroftheDataMiningAPIsDataMiningPL/SQLPackages.............................................................................................................2-1DataMiningDataDictionaryViews....................................................................................................2-3DataMiningSQLFunctions..................................................................................................................2-3DataMiningJavaAPI..............................................................................................................................2-43CreatingtheCaseTableRequirements............................................................................................................................................3-1AboutAttributes.......................................................................................................................................3-3Nested