{#example-dataset-the-example-dataset} # 예제 데이터셋 이 매뉴얼의 모든 예제는 영화와 그것을 만든 사람들로 이루어진 하나의 작은 그래프를 대상으로 실행되며, 그래프 이름은 `moviekb`입니다. 한 번 준비해 두면 모든 페이지가 동작합니다. 이 그래프에는 정점 레이블 두 개와 간선 레이블 세 개가 있습니다: ```mermaid graph LR P["person
name, born"] M["movie
title, year, genre,
plot, embedding"] P -- "acted_in { role }" --> M P -- "directed" --> M M -- "related_to { weight }" --> M ``` 그 옆에 보통 테이블인 `rating`이 함께 있습니다. [SQL과 Cypher 섞기](../querying/combining-sql-and-cypher.md) 페이지가 조인할 실제 관계형 데이터를 갖도록 하기 위한 것입니다. {#example-dataset-create-the-graph} ## 그래프 만들기 ```cypher CREATE GRAPH moviekb; SET graph_path = moviekb; CREATE VLABEL movie; CREATE VLABEL person; CREATE ELABEL acted_in; CREATE ELABEL directed; CREATE ELABEL related_to; ``` `graph_path`는 수식되지 않은 레이블 이름이 어느 그래프에 속하는지를 세션에 알려 줍니다. 세션 단위 설정이므로 새 세션마다 다시 설정하거나, 데이터베이스에 설정해 두십시오: ```sql ALTER DATABASE mydb SET graph_path = moviekb; ``` {#example-dataset-load-the-films} ## 영화 적재 각 영화에는 `plot`과 그 줄거리의 `embedding`이 있습니다. 실제 임베딩은 모델에서 나오고 수백 차원을 갖지만, 여기서는 지면에서 기하 구조를 읽을 수 있도록 4차원으로 줄였습니다. [벡터 검색](../guides/search/vector.md)과 [하이브리드 검색](../guides/search/hybrid.md)은 이것을 그대로 사용합니다. ```cypher CREATE (:movie {title: 'The Matrix', year: 1999, genre: 'Action', plot: 'A computer hacker learns about the true nature of reality and joins a rebellion to free humanity from a simulated world controlled by machines.', embedding: [-0.07594558, 0.04081754, 0.29592122, -0.11921061]}), (:movie {title: 'The Matrix Reloaded', year: 2003, genre: 'Action', plot: 'The rebels continue their fight against the machines, uncovering deeper truths about the Matrix and the nature of their mission.', embedding: [0.30228977, -0.22839354, 0.35070436, 0.01262819]}), (:movie {title: 'The Matrix Revolutions', year: 2003, genre: 'Action', plot: 'The final battle between humans and machines reaches its climax as the fate of both worlds hangs in the balance.', embedding: [0.12240622, -0.29752459, 0.22620453, 0.24454723]}), (:movie {title: 'The Matrix Resurrections', year: 2021, genre: 'Action', plot: 'Neo returns to a new version of the Matrix and must once again fight to save the people from the control of the machines.', embedding: [0.34717246, -0.13820869, 0.29214213, 0.08090488]}), (:movie {title: 'Inception', year: 2010, genre: 'Sci-Fi', plot: 'A skilled thief is given a chance at redemption if he can successfully perform an inception: planting an idea into someone''s subconscious.', embedding: [0.03923657, 0.39284106, -0.20927092, -0.17770818]}), (:movie {title: 'Interstellar', year: 2014, genre: 'Sci-Fi', plot: 'A group of explorers travel through a wormhole in space in an attempt to ensure humanity''s survival.', embedding: [-0.29302418, -0.39615033, -0.23393948, -0.09601383]}), (:movie {title: 'Avatar', year: 2009, genre: 'Sci-Fi', plot: 'A paraplegic Marine is sent to the moon Pandora, where he becomes torn between following orders and protecting the world he feels is his home.', embedding: [-0.13663386, 0.00635589, -0.03038832, -0.08252723]}), (:movie {title: 'Blade Runner', year: 1982, genre: 'Sci-Fi', plot: 'A blade runner must pursue and terminate four replicants who have stolen a ship in space and returned to Earth.', embedding: [0.27215557, -0.1479577, -0.09972772, -0.08234394]}), (:movie {title: 'Blade Runner 2049', year: 2017, genre: 'Sci-Fi', plot: 'A new blade runner unearths a long-buried secret that has the potential to plunge what''s left of society into chaos.', embedding: [0.21560573, -0.07505179, -0.01331814, 0.13403069]}), (:movie {title: 'Minority Report', year: 2002, genre: 'Sci-Fi', plot: 'In a future where a special police unit can arrest murderers before they commit their crimes, a top officer is accused of a future murder.', embedding: [0.24008012, 0.44954908, -0.30905488, 0.15195407]}), (:movie {title: 'Total Recall', year: 1990, genre: 'Sci-Fi', plot: 'A construction worker discovers that his memories have been implanted and becomes embroiled in a conspiracy on Mars.', embedding: [-0.17471036, 0.14695261, -0.06272433, -0.21795064]}), (:movie {title: 'Elysium', year: 2013, genre: 'Sci-Fi', plot: 'In a future where the rich live on a luxurious space station while the rest of humanity lives in squalor, a man fights to bring equality.', embedding: [-0.33280967, 0.07733926, 0.11015328, 0.53382836]}), (:movie {title: 'Gattaca', year: 1997, genre: 'Sci-Fi', plot: 'In a future where genetic engineering determines social class, a man defies his fate to achieve his dreams.', embedding: [-0.21629286, 0.31114665, 0.08303899, 0.46199759]}), (:movie {title: 'The Fifth Element', year: 1997, genre: 'Sci-Fi', plot: 'In a futuristic world, a cab driver becomes the key to saving humanity from an impending cosmic threat.', embedding: [-0.11528205, -0.0208782, -0.0735215, 0.14327449]}), (:movie {title: 'The Terminator', year: 1984, genre: 'Action', plot: 'A cyborg assassin is sent back in time to kill the mother of the future resistance leader.', embedding: [0.33666933, 0.18040994, -0.01075103, -0.11117851]}), (:movie {title: 'Terminator 2: Judgment Day', year: 1991, genre: 'Action', plot: 'A reprogrammed Terminator is sent to protect the future leader of the human resistance from a more advanced Terminator.', embedding: [0.34698868, 0.06439331, 0.06232323, -0.19534876]}), (:movie {title: 'Jurassic Park', year: 1993, genre: 'Adventure', plot: 'Scientists clone dinosaurs to create a theme park, but things go awry when the creatures escape.', embedding: [0.01794725, -0.11434246, -0.46831815, -0.01049593]}), (:movie {title: 'The Avengers', year: 2012, genre: 'Action', plot: 'Superheroes assemble to face a global threat from an alien invasion led by Loki.', embedding: [0.00546514, -0.37005171, -0.42612838, 0.07968612]}); ``` {#example-dataset-load-the-people} ## 사람 적재 ```cypher CREATE (:person {name: 'Keanu Reeves', born: 1964}), (:person {name: 'Laurence Fishburne', born: 1961}), (:person {name: 'Carrie-Anne Moss', born: 1967}), (:person {name: 'Lana Wachowski', born: 1965}), (:person {name: 'Lilly Wachowski', born: 1967}), (:person {name: 'Leonardo DiCaprio', born: 1974}), (:person {name: 'Matthew McConaughey', born: 1969}), (:person {name: 'Christopher Nolan', born: 1970}), (:person {name: 'Harrison Ford', born: 1942}), (:person {name: 'Ryan Gosling', born: 1980}), (:person {name: 'Ridley Scott', born: 1937}), (:person {name: 'Denis Villeneuve', born: 1967}), (:person {name: 'Tom Cruise', born: 1962}), (:person {name: 'Sam Neill', born: 1947}), (:person {name: 'Steven Spielberg', born: 1946}), (:person {name: 'Arnold Schwarzenegger', born: 1947}), (:person {name: 'Linda Hamilton', born: 1956}), (:person {name: 'James Cameron', born: 1954}), (:person {name: 'Sam Worthington', born: 1976}), (:person {name: 'Paul Verhoeven', born: 1938}), (:person {name: 'Matt Damon', born: 1970}), (:person {name: 'Neill Blomkamp', born: 1979}), (:person {name: 'Ethan Hawke', born: 1970}), (:person {name: 'Andrew Niccol', born: 1964}), (:person {name: 'Bruce Willis', born: 1955}), (:person {name: 'Luc Besson', born: 1959}), (:person {name: 'Robert Downey Jr.', born: 1965}), (:person {name: 'Joss Whedon', born: 1964}); ``` {#example-dataset-connect-them} ## 연결하기 ```cypher -- Cast: acted_in carries the character name as an edge property. MATCH (p:person {name:'Keanu Reeves'}), (m:movie {title:'The Matrix'}) CREATE (p)-[:acted_in {role:'Neo'}]->(m); MATCH (p:person {name:'Keanu Reeves'}), (m:movie {title:'The Matrix Reloaded'}) CREATE (p)-[:acted_in {role:'Neo'}]->(m); MATCH (p:person {name:'Keanu Reeves'}), (m:movie {title:'The Matrix Revolutions'}) CREATE (p)-[:acted_in {role:'Neo'}]->(m); MATCH (p:person {name:'Keanu Reeves'}), (m:movie {title:'The Matrix Resurrections'}) CREATE (p)-[:acted_in {role:'Neo'}]->(m); MATCH (p:person {name:'Laurence Fishburne'}), (m:movie {title:'The Matrix'}) CREATE (p)-[:acted_in {role:'Morpheus'}]->(m); MATCH (p:person {name:'Laurence Fishburne'}), (m:movie {title:'The Matrix Reloaded'}) CREATE (p)-[:acted_in {role:'Morpheus'}]->(m); MATCH (p:person {name:'Carrie-Anne Moss'}), (m:movie {title:'The Matrix'}) CREATE (p)-[:acted_in {role:'Trinity'}]->(m); MATCH (p:person {name:'Carrie-Anne Moss'}), (m:movie {title:'The Matrix Resurrections'}) CREATE (p)-[:acted_in {role:'Trinity'}]->(m); MATCH (p:person {name:'Leonardo DiCaprio'}), (m:movie {title:'Inception'}) CREATE (p)-[:acted_in {role:'Dom Cobb'}]->(m); MATCH (p:person {name:'Matthew McConaughey'}), (m:movie {title:'Interstellar'}) CREATE (p)-[:acted_in {role:'Cooper'}]->(m); MATCH (p:person {name:'Harrison Ford'}), (m:movie {title:'Blade Runner'}) CREATE (p)-[:acted_in {role:'Rick Deckard'}]->(m); MATCH (p:person {name:'Harrison Ford'}), (m:movie {title:'Blade Runner 2049'}) CREATE (p)-[:acted_in {role:'Rick Deckard'}]->(m); MATCH (p:person {name:'Ryan Gosling'}), (m:movie {title:'Blade Runner 2049'}) CREATE (p)-[:acted_in {role:'K'}]->(m); MATCH (p:person {name:'Tom Cruise'}), (m:movie {title:'Minority Report'}) CREATE (p)-[:acted_in {role:'John Anderton'}]->(m); MATCH (p:person {name:'Sam Neill'}), (m:movie {title:'Jurassic Park'}) CREATE (p)-[:acted_in {role:'Alan Grant'}]->(m); MATCH (p:person {name:'Arnold Schwarzenegger'}), (m:movie {title:'The Terminator'}) CREATE (p)-[:acted_in {role:'The Terminator'}]->(m); MATCH (p:person {name:'Arnold Schwarzenegger'}), (m:movie {title:'Terminator 2: Judgment Day'}) CREATE (p)-[:acted_in {role:'The Terminator'}]->(m); MATCH (p:person {name:'Arnold Schwarzenegger'}), (m:movie {title:'Total Recall'}) CREATE (p)-[:acted_in {role:'Douglas Quaid'}]->(m); MATCH (p:person {name:'Linda Hamilton'}), (m:movie {title:'The Terminator'}) CREATE (p)-[:acted_in {role:'Sarah Connor'}]->(m); MATCH (p:person {name:'Linda Hamilton'}), (m:movie {title:'Terminator 2: Judgment Day'}) CREATE (p)-[:acted_in {role:'Sarah Connor'}]->(m); MATCH (p:person {name:'Sam Worthington'}), (m:movie {title:'Avatar'}) CREATE (p)-[:acted_in {role:'Jake Sully'}]->(m); MATCH (p:person {name:'Matt Damon'}), (m:movie {title:'Elysium'}) CREATE (p)-[:acted_in {role:'Max Da Costa'}]->(m); MATCH (p:person {name:'Ethan Hawke'}), (m:movie {title:'Gattaca'}) CREATE (p)-[:acted_in {role:'Vincent Freeman'}]->(m); MATCH (p:person {name:'Bruce Willis'}), (m:movie {title:'The Fifth Element'}) CREATE (p)-[:acted_in {role:'Korben Dallas'}]->(m); MATCH (p:person {name:'Robert Downey Jr.'}), (m:movie {title:'The Avengers'}) CREATE (p)-[:acted_in {role:'Tony Stark'}]->(m); -- Directors. MATCH (p:person {name:'Lana Wachowski'}), (m:movie {title:'The Matrix'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Lilly Wachowski'}), (m:movie {title:'The Matrix'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Lana Wachowski'}), (m:movie {title:'The Matrix Reloaded'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Lilly Wachowski'}), (m:movie {title:'The Matrix Reloaded'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Lana Wachowski'}), (m:movie {title:'The Matrix Revolutions'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Lilly Wachowski'}), (m:movie {title:'The Matrix Revolutions'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Lana Wachowski'}), (m:movie {title:'The Matrix Resurrections'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Christopher Nolan'}), (m:movie {title:'Inception'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Christopher Nolan'}), (m:movie {title:'Interstellar'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Ridley Scott'}), (m:movie {title:'Blade Runner'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Denis Villeneuve'}), (m:movie {title:'Blade Runner 2049'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Steven Spielberg'}), (m:movie {title:'Minority Report'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Steven Spielberg'}), (m:movie {title:'Jurassic Park'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'James Cameron'}), (m:movie {title:'The Terminator'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'James Cameron'}), (m:movie {title:'Terminator 2: Judgment Day'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'James Cameron'}), (m:movie {title:'Avatar'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Paul Verhoeven'}), (m:movie {title:'Total Recall'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Neill Blomkamp'}), (m:movie {title:'Elysium'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Andrew Niccol'}), (m:movie {title:'Gattaca'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Luc Besson'}), (m:movie {title:'The Fifth Element'}) CREATE (p)-[:directed]->(m); MATCH (p:person {name:'Joss Whedon'}), (m:movie {title:'The Avengers'}) CREATE (p)-[:directed]->(m); -- related_to keeps the search pages' edges and adds a weight for weighted-path examples. MATCH (a:movie {title:'The Matrix'}), (b:movie {title:'The Matrix Reloaded'}) CREATE (a)-[:related_to {weight: 1}]->(b); MATCH (a:movie {title:'The Matrix Reloaded'}), (b:movie {title:'The Matrix Revolutions'}) CREATE (a)-[:related_to {weight: 1}]->(b); MATCH (a:movie {title:'The Matrix Revolutions'}), (b:movie {title:'The Matrix Resurrections'}) CREATE (a)-[:related_to {weight: 1}]->(b); MATCH (a:movie {title:'The Matrix'}), (b:movie {title:'Total Recall'}) CREATE (a)-[:related_to {weight: 4}]->(b); MATCH (a:movie {title:'The Matrix'}), (b:movie {title:'The Terminator'}) CREATE (a)-[:related_to {weight: 3}]->(b); MATCH (a:movie {title:'Total Recall'}), (b:movie {title:'Inception'}) CREATE (a)-[:related_to {weight: 2}]->(b); MATCH (a:movie {title:'The Terminator'}), (b:movie {title:'Terminator 2: Judgment Day'})CREATE (a)-[:related_to {weight: 1}]->(b); MATCH (a:movie {title:'Blade Runner'}), (b:movie {title:'Blade Runner 2049'}) CREATE (a)-[:related_to {weight: 1}]->(b); MATCH (a:movie {title:'Interstellar'}), (b:movie {title:'Avatar'}) CREATE (a)-[:related_to {weight: 5}]->(b); MATCH (a:movie {title:'Jurassic Park'}), (b:movie {title:'The Avengers'}) CREATE (a)-[:related_to {weight: 5}]->(b); MATCH (a:movie {title:'Minority Report'}), (b:movie {title:'Inception'}) CREATE (a)-[:related_to {weight: 2}]->(b); ``` {#example-dataset-add-the-relational-table} ## 관계형 테이블 추가 ```sql CREATE TABLE rating (title text, source text, score numeric(3,1)); INSERT INTO rating VALUES ('The Matrix', 'critics', 8.7), ('The Matrix', 'audience', 9.1), ('The Matrix Reloaded', 'critics', 7.2), ('The Matrix Revolutions', 'critics', 6.7), ('The Matrix Resurrections', 'critics', 5.7), ('Inception', 'critics', 8.8), ('Inception', 'audience', 9.0), ('Interstellar', 'critics', 8.7), ('Interstellar', 'audience', 8.6), ('Blade Runner', 'critics', 8.1), ('Blade Runner 2049', 'critics', 8.0), ('Jurassic Park', 'critics', 8.2), ('The Terminator', 'critics', 8.0), ('Terminator 2: Judgment Day', 'critics', 8.6), ('Avatar', 'critics', 7.9), ('Total Recall', 'critics', 7.5), ('Minority Report', 'critics', 7.6), ('Gattaca', 'critics', 7.8), ('The Fifth Element', 'critics', 7.6), ('Elysium', 'critics', 6.6), ('The Avengers', 'critics', 8.0); ``` {#example-dataset-check-what-you-loaded} ## 적재한 것 확인 ```cypher MATCH (n) RETURN label(n) AS label, count(*) AS n ORDER BY label; ``` | label | n | | --- | --- | | `"movie"` | 18 | | `"person"` | 28 | ```cypher MATCH ()-[e]->() RETURN label(e) AS label, count(*) AS n ORDER BY label; ``` | label | n | | --- | --- | | `"acted_in"` | 25 | | `"directed"` | 21 | | `"related_to"` | 11 | {#example-dataset-the-same-data-as-tables} ## 같은 데이터를 테이블로 보기 그래프는 스키마이고 레이블은 테이블이므로, 방금 만든 그래프는 SQL로 쿼리할 수 있는 보통 테이블 여덟 개이기도 합니다. `\dGv`는 정점 레이블을 나열하고, `\dGe`는 간선 레이블을 나열하며, `\d`는 레이블의 모양을 보여 줍니다: ```sql SELECT id, properties->>'title' AS title FROM moviekb.movie ORDER BY id LIMIT 3; ``` ``` id | title -----+------------------------ 3.1 | The Matrix 3.2 | The Matrix Reloaded 3.3 | The Matrix Revolutions ``` 간선 테이블은 양 끝점의 id도 함께 담고 있습니다: ```sql SELECT id, start, "end", properties FROM moviekb.acted_in ORDER BY id LIMIT 3; ``` ``` id | start | end | properties -----+-------+-----+----------------- 5.1 | 4.1 | 3.1 | {"role": "Neo"} 5.2 | 4.1 | 3.2 | {"role": "Neo"} 5.3 | 4.1 | 3.3 | {"role": "Neo"} ``` [그래프가 어떻게 저장되는가](../concepts/graph-on-postgresql.md)가 그 컬럼들이 무엇이고 어떤 인덱스가 함께 만들어지는지 설명합니다. {#example-dataset-start-over} ## 처음부터 다시 ```cypher DROP GRAPH moviekb CASCADE; ``` ```sql DROP TABLE rating; ```