#chiroito ’s blog

Java を中心とした趣味の技術について

Data Miner のAssociation結果をそれっぽく見せる

select antecedent_items, p2.attribute_subname as consequent_item, p0.support, confidence, lift, p3.number_of_items
from dm$p0assoc_ap_1_1 p0

left outer join (
select ip4.itemset_id, listagg(ip2.attribute_subname, ',') within group (order by ip2.item_id) as antecedent_items
from dm$p4assoc_ap_1_1 ip4
left join dm$p2assoc_ap_1_1 ip2 on ip2.item_id = ip4.item_id
group by ip4.itemset_id
) p4 on p4.itemset_id = p0.antecedent_itemset_id

left outer join dm$p2assoc_ap_1_1 p2 on p2.item_id = p0.consequent_itemset_id

left outer join dm$p3assoc_ap_1_1 p3 on p3.itemset_id = p0.antecedent_itemset_id