Slide 14
Slide 14 text
3. グラフクエリおよびグラフアルゴリズムを用いた MRP 計算の最適化
Copyright © 2022, Oracle and/or its affiliates
14
ID num
A 1
B 1
C 4
D 2
E 6
F 8
G 40
H 2
I 12
SELECT
p1.id AS p1_id
, p2.id AS p2_id
, SUM(PRODUCT(LISTAGG(e.num, ' ')))
FROM MATCH ALL (p1) (-[e:has_part]->(p)){1,100} (p2)
WHERE p1.id = 'Model1'
GROUP BY p1_id, p2_id
# PRODUCT() is a UDF (user-defined function) on PGX