엔터프라이즈 AI를 위한
통합 그래프·벡터·관계형 DBMS

-- HNSW 인덱스 생성
CREATE INDEX ON retail_graph.v_customer USING vectoron (embedding vector_l2_ops);
CREATE INDEX ON retail_graph.v_item USING vectoron (embedding vector_l2_ops);

-- 탐색 깊이 설정
SET vectoron.hnsw_ef_search = 64;

-- 상위 소비자 5명이 구매한 상품 검색
SELECT first_name, last_name, product_name, price
FROM akasicdb.cypher('retail_graph', $$
MATCH (v:v_customer)
WITH v.vertex_id AS customer_top_k
ORDER BY v.embedding <-> '[0.15,0.15,0.35]'
LIMIT 5
MATCH (c:v_customer)-[:buy]->(i:v_item)
WHERE c.vertex_id = customer_top_k
RETURN
    c.first_name AS first_name,
    c.last_name AS last_name,
    i.name AS product_name,
    i.price AS price
$$) AS (
    first_name VARCHAR,
    last_name VARCHAR,
    product_name VARCHAR,
    price DECIMAL
)
ORDER BY first_name, last_name, product_name;