Oracle Magazine, May/June 2019
Emerging Technologies MACHINE LEARNING The important data point here is the AFFINITY_ CARD value And the question is which of the other demographic and sales data has the highest influence on the AFFINITY_ CARD value When that is known Marketing can tailor its campaigns accordingly ATTRIBUTE RANKING Theres more than one way to solve most problems Jane reminds everyone in the room Oracle Autonomous Data Warehouse offers many utilities to perform machine learning on the data Jane offers to show one of those utilities Attribute Ranking Functionality in which the machine learning model identifies the strength of any correlation between the various attributes and ranks them in order of influence on the dependent variable In Oracle Autonomous Data Warehouse the utility is available through functions of the DBMS_ PREDICTIVE_ ANALYTICS package One such function is called EXPLAIN which computes the rank of the attributes influencing the dependent variable which is AFFINITY_ CARD in this case Jane pulls up the notebook and enters the simple SQL statement ORACLE MAGAZINE MAY JUNE 2019 99 select from sh supplementary_ demographics to show all the records from SUPPLEMENTARY_ DEMOGRAPHICS and then clicks the execution button the right arrow icon Figure 10 shows the SQL statement the execution button in the red circle and the output This is how a notebook functions Jane tells her audience The SQL statement is entered in a field which is called a paragraph The output comes immediately afterward The user can modify the paragraph but not the output Another paragraph opens up just under the output where the user can enter another command which can be in SQL or PL SQL
You must have JavaScript enabled to view digital editions.