\n\u7b2c2\u56de\u76ee:\u30c7\u30fc\u30bf\u51e6\u7406\u3068\u554f\u984c\u70b9<\/a>
\n\u7b2c3\u56de\u76ee:\u3069\u306e\u3088\u3046\u306b\u6539\u5584\u3057\u305f\u3089\u3044\u3044\u306e\u304b<\/a>
\n\u7b2c4\u56de\u76ee:\u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406(\u4eca\u56de)<\/strong><\/p>\n
\u8ffd\u52a0\u306e\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3\u4f5c\u6210\u53ca\u3073\u30c7\u30fc\u30bf\u30ed\u30fc\u30c9<\/a><\/h2>\n\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb<\/h3>\n
\u6700\u7d42\u7684\u306b\u5b8c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u3082\u306e\u3067\u3059\u3002\u6ce2\u7dda\u306e\u3088\u3046\u306b\u30ea\u30af\u30a8\u30b9\u30c8\u7528\u306e\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3(RE_CATEGORY)\u3068\u5fc5\u9808\u8981\u7d20\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u7528\u306e\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3(FI_CATEGORY)\u3092\u8ffd\u52a0\u3057\u3001\u5c45\u4f4f\u5730\u57df\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u306f\u4eba(:Person)\u306e\u5c5e\u6027(filter_location)\u3068\u3057\u3066\u6301\u305f\u305b\u3066\u3044\u307e\u3059\u3002<\/p>\n
![\"re-datamodel1\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/re-datamodel1.png\")
\nMY:Original\u3000RE:Request\u3000FI:Filter<\/p>\n
\u3053\u308c\u304b\u3089\u3001\u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u57fa\u3065\u3044\u3066\u30ce\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u3044\uff26\u304d\u307e\u3059\u3002\u3053\u306e\u4f5c\u696d\u3092\u884c\u3044\u305f\u304f\u306a\u3044\u65b9\u306f\u3001\u5b8c\u6210\u3057\u305f\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u5229\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9 konkatu-4.gdb.zip<\/a><\/p>\n\u5b8c\u6210\u3057\u305f\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5229\u7528\u3059\u308b\u65b9\u306f\u3001\u300eM04\u3055\u3093\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u3084\u3063\u3066\u307f\u308b<\/a>\u300f\u306b\u9032\u3093\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n\u30ea\u30af\u30a8\u30b9\u30c8\u7528\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3\u306e\u8ffd\u52a0<\/h3>\n
\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u3059\u3079\u3066Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
WITH [\"\u91ce\u7403\",\"\u30b5\u30c3\u30ab\u30fc\",\"\u30d0\u30ec\u30fc\u30dc\u30fc\u30eb\",\"\u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb\",\"\u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9\",\"\u30e8\u30ac\",\"\u6563\u6b69\",\"\u30c0\u30f3\u30b9\",\"\u305d\u306e\u4ed6\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (a1:Sport2 {title: list[i]}))<\/p>\n
WITH [\"\u571f\u65e5\u795d\u65e5\",\"\u5e73\u65e5\",\"\u4e0d\u5b9a\u671f\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (b1:Holiday2 {title: list[i]}))<\/p>\n
WITH [\"\u805e\u304f\u30bf\u30a4\u30d7\",\"\u8a71\u3059\u30bf\u30a4\u30d7\",\"\u3068\u3061\u3089\u3067\u3082\u826f\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (c1:Talk2 {title: list[i]}))<\/p>\n
WITH [\"\u7a4d\u6975\u7684\",\"\u6d88\u6975\u7684\",\"\u3068\u3061\u3089\u3067\u3082\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (d1:Meeting2 {title: list[i]}))<\/p>\n
WITH [140,150,160,170,180,190,200] as list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (e1:Height2 {title: list[i]}))<\/p>\n
WITH [\"\u5916\u5411\u7684\",\"\u5185\u5411\u7684\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (f1:Personality2 {title: list[i]}))<\/p>\n
WITH [\"\u8aad\u66f8\",\"\u6620\u753b\u611f\u60f3\",\"\u97f3\u697d\u611f\u60f3\",\"TV\u611f\u60f3\",\"\u30b2\u30fc\u30e0\",\"\u5bdd\u308b\",\"\u53cb\u305f\u3061\u3068\u304a\u558b\u308a\",\"\u6599\u7406\u3092\u4f5c\u308b\",\"\u305d\u306e\u4ed6\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (g1:Indoor2 {title: list[i]}))<\/p>\n
WITH [\"\u5438\u3046\",\"\u5438\u308f\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (h1:Smoking2 {title: list[i]}))<\/p>\n
WITH [\"\u98f2\u3080\",\"\u98f2\u307e\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (j1:Alcohol2 {title: list[i]}))<\/p>\n
WITH [\"\u597d\u304d\",\"\u5acc\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (k1:Karaoke2 {title: list[i]}))<\/p>\n
WITH [\"\u4fe1\u3058\u308b\",\"\u4fe1\u3058\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (m1:Fortunetelling2 {title: list[i]}))<\/p>\n
WITH [\"\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b\",\"\u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (n1:Healthcare2 {title: list[i]}))<\/p>\n
WITH [\"\u6d77\",\"\u5c71\",\"\u5ddd\",\"\u516c\u5712\",\"\u904a\u5712\u5730\",\"\u3069\u3061\u3089\u3067\u3082\u3044\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (o1:Outdoor2 {title: list[i]}))<\/p>\n
WITH [100,200,300,400,500,600,700,800,900] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (p1:Income2 {title: list[i]}))<\/p>\n
WITH [\"\u5317\u6d77\u9053\",\"\u9752\u68ee\u770c\",\"\u5ca9\u624b\u770c\",\"\u5bae\u57ce\u770c\",\"\u79cb\u7530\u770c\",\"\u5c71\u5f62\u770c\",\"\u798f\u5cf6\u770c\",\"\u8328\u57ce\u770c\",\"\u6803\u6728\u770c\",\"\u7fa4\u99ac\u770c\",\"\",\"\u57fc\u7389\u770c\",\"\u5343\u8449\u770c\",\"\u6771\u4eac\u90fd\",\"\u795e\u5948\u5ddd\u770c\",\"\u65b0\u6f5f\u770c\",\"\u5bcc\u5c71\u770c\",\"\u77f3\u5ddd\u770c\",\"\u798f\u4e95\u770c\",\"\u5c71\u68a8\u770c\",\"\u9577\u91ce\u770c\",\"\u5c90\u961c\u770c\",\"\u9759\u5ca1\u770c\",\"\u611b\u77e5\u770c\",\"\u4e09\u91cd\u770c\",\"\u6ecb\u8cc0\u770c\",\"\u4eac\u90fd\u5e9c\",\"\u5927\u962a\u5e9c\",\"\u5175\u5eab\u770c\",\"\u5948\u826f\u770c\",\"\u548c\u6b4c\u5c71\u770c\",\"\u9ce5\u53d6\u770c\",\"\u5cf6\u6839\u770c\",\"\u5ca1\u5c71\u770c\",\"\u5e83\u5cf6\u770c\",\"\u5c71\u53e3\u770c\",\"\u5fb3\u5cf6\u770c\",\"\u9999\u5ddd\u770c\",\"\u611b\u5a9b\u770c\",\"\u9ad8\u77e5\u770c\",\"\u798f\u5ca1\u770c\",\"\u4f50\u8cc0\u770c\",\"\u9577\u5d0e\u770c\",\"\u718a\u672c\u770c\",\"\u5927\u5206\u770c\",\"\u5bae\u5d0e\u770c\",\"\u9e7f\u5150\u5cf6\u770c\",\"\u6c96\u7e04\u770c\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (q1:Location2 {title: list[i]}))<\/p>\n
WITH [\"\u6709\u308a\",\"\u7121\u3057\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (r1:Maritalhistory2 {title: list[i]}))<\/p>\n
WITH [\"\u72ac\u6d3e\",\"\u732b\u6d3e\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (s1:Pet2 {title: list[i]}))<\/p>\n
WITH [\"\u7fa9\u52d9\u6559\u80b2\",\"\u9ad8\u7b49\u5b66\u6821\",\"\u5404\u7a2e\u5c02\u9580\u5b66\u6821\",\"\u77ed\u5927\u30fb\u9ad8\u5c02\",\"\u5927\u5b66\",\"\u5927\u5b66\u9662\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (t1:Education2 {title: list[i]}))<\/p>\n
WITH [\"\u516c\u52d9\u54e1\",\"\u4f1a\u793e\u54e1\",\"\u81ea\u55b6\u696d\",\"\u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1\",\"\u6559\u5e2b\",\"\u533b\u5e2b\",\"\u533b\u7642\u95a2\u4fc2\",\"\u4fdd\u80b2\u58eb\",\"\u8fb2\u6797\u30fb\u6f01\u696d\",\"\u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8\",\"\u5b66\u751f\",\"\u5bb6\u4e8b\u624b\u4f1d\",\"\u305d\u306e\u4ed6\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (u1:Job2 {title: list[i]}))<\/p>\n
WITH [1995,1994,1993,1992,1991,1990,1989,1988,1987,1986,1985,1984,1983,1982,1981,1980,1979,1978,1977,1976,1975,1974,1973,1972,1971,1970] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (v1:Born2 {title: list[i]}))<\/p><\/blockquote>\n
\u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3001\u30e9\u30d9\u30eb\u3001\u8981\u7d20\u306e\u96c6\u5408\u3001\u8981\u7d20\u6570\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
MATCH (a:Sport2) RETURN labels(a) AS \u30e9\u30d9\u30eb,collect(a.title) AS \u8981\u7d20,length(collect(a.title)) AS \u6570 UNION ALL
\nMATCH (b:holiday2) RETURN labels(b) AS \u30e9\u30d9\u30eb, collect(b.title) AS \u8981\u7d20,length(collect(b.title)) AS \u6570 UNION ALL
\nMATCH (c:Talk2) RETURN labels(c) AS \u30e9\u30d9\u30eb, collect(c.title) AS \u8981\u7d20,length(collect(c.title)) AS \u6570 UNION ALL
\nMATCH (d:Height2) RETURN labels(d) AS \u30e9\u30d9\u30eb, collect(d.title) AS \u8981\u7d20,length(collect(d.title)) AS \u6570 UNION ALL
\nMATCH (e:Personality2) RETURN labels(e) AS \u30e9\u30d9\u30eb, collect(e.title) AS \u8981\u7d20,length(collect(e.title)) AS \u6570 UNION ALL
\nMATCH (f:Indoor2) RETURN labels(f) AS \u30e9\u30d9\u30eb, collect(f.title) AS \u8981\u7d20,length(collect(f.title)) AS \u6570 UNION ALL
\nMATCH (g:Smoking2) RETURN labels(g) AS \u30e9\u30d9\u30eb, collect(g.title) AS \u8981\u7d20,length(collect(g.title)) AS \u6570 UNION ALL
\nMATCH (h:Alcohol2) RETURN labels(h) AS \u30e9\u30d9\u30eb, collect(h.title) AS \u8981\u7d20,length(collect(h.title)) AS \u6570 UNION ALL
\nMATCH (i:Karaoke2) RETURN labels(i) AS \u30e9\u30d9\u30eb, collect(i.title) AS \u8981\u7d20,length(collect(i.title)) AS \u6570 UNION ALL
\nMATCH (j:Fortunetelling2) RETURN labels(j) AS \u30e9\u30d9\u30eb, collect(j.title) AS \u8981\u7d20,length(collect(j.title)) AS \u6570 UNION ALL
\nMATCH (k:Outdoor2) RETURN labels(k) AS \u30e9\u30d9\u30eb, collect(k.title) AS \u8981\u7d20,length(collect(k.title)) AS \u6570 UNION ALL
\nMATCH (l:Income2) RETURN labels(l) AS \u30e9\u30d9\u30eb, collect(l.title) AS \u8981\u7d20,length(collect(l.title)) AS \u6570 UNION ALL
\nMATCH (m:Born2) RETURN labels(m) AS \u30e9\u30d9\u30eb, collect(m.title) AS \u8981\u7d20,length(collect(m.title)) AS \u6570 UNION ALL
\nMATCH (n:Location2) RETURN labels(n) AS \u30e9\u30d9\u30eb, collect(n.title) AS \u8981\u7d20,length(collect(n.title)) AS \u6570 UNION ALL
\nMATCH (o:Pet2) RETURN labels(o) AS \u30e9\u30d9\u30eb, collect(o.title) AS \u8981\u7d20,length(collect(o.title)) AS \u6570 UNION ALL
\nMATCH (p:Education2) RETURN labels(p) AS \u30e9\u30d9\u30eb, collect(p.title) AS \u8981\u7d20,length(collect(p.title)) AS \u6570 UNION ALL
\nMATCH (q:Job2) RETURN labels(q) AS \u30e9\u30d9\u30eb, collect(q.title) AS \u8981\u7d20,length(collect(q.title)) AS \u6570 UNION ALL
\nMATCH (r:Meet2) RETURN labels(r) AS \u30e9\u30d9\u30eb, collect(r.title) AS \u8981\u7d20,length(collect(r.title)) AS \u6570 UNION ALL
\nMATCH (s:Marriage2) RETURN labels(s) AS \u30e9\u30d9\u30eb, collect(s.title) AS \u8981\u7d20,length(collect(s.title)) AS \u6570 UNION ALL
\nMATCH (t:Healthcare2) RETURN labels(t) AS \u30e9\u30d9\u30eb, collect(t.title) AS \u8981\u7d20,length(collect(t.title)) AS \u6570
\n\u30e9\u30d9\u30eb \u8981\u7d20 \u6570
\n[Sport2] [\u91ce\u7403, \u30b5\u30c3\u30ab\u30fc, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb, \u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9, \u30e8\u30ac, \u6563\u6b69, \u30c0\u30f3\u30b9, \u305d\u306e\u4ed6] 9
\n[Talk2] [\u805e\u304f\u30bf\u30a4\u30d7, \u8a71\u3059\u30bf\u30a4\u30d7, \u3068\u3061\u3089\u3067\u3082\u826f\u3044] 3
\n[Height2] [140, 150, 160, 170, 180, 190, 200] 7
\n[Personality2] [\u5916\u5411\u7684, \u5185\u5411\u7684] 2
\n[Indoor2] [\u8aad\u66f8, \u6620\u753b\u611f\u60f3, \u97f3\u697d\u611f\u60f3, TV\u611f\u60f3, \u30b2\u30fc\u30e0, \u5bdd\u308b, \u53cb\u305f\u3061\u3068\u304a\u558b\u308a, \u6599\u7406\u3092\u4f5c\u308b, \u305d\u306e\u4ed6] 9
\n[Smoking2] [\u5438\u3046, \u5438\u308f\u306a\u3044] 2
\n[Alcohol2] [\u98f2\u3080, \u98f2\u307e\u306a\u3044] 2
\n[Karaoke2] [\u597d\u304d, \u5acc\u3044] 2
\n[Fortunetelling2] [\u4fe1\u3058\u308b, \u4fe1\u3058\u306a\u3044] 2
\n[Outdoor2] [\u6d77, \u5c71, \u5ddd, \u516c\u5712, \u904a\u5712\u5730, \u3069\u3061\u3089\u3067\u3082\u3044\u3044] 6
\n[Income2] [100, 200, 300, 400, 500, 600, 700, 800, 900] 9
\n[Born2] [1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970] 26
\n[Location2] [\u5317\u6d77\u9053, \u9752\u68ee\u770c, \u5ca9\u624b\u770c, \u5bae\u57ce\u770c, \u79cb\u7530\u770c, \u5c71\u5f62\u770c, \u798f\u5cf6\u770c, \u8328\u57ce\u770c, \u6803\u6728\u770c, \u7fa4\u99ac\u770c, (empty), \u57fc\u7389\u770c, \u5343\u8449\u770c, \u6771\u4eac\u90fd, \u795e\u5948\u5ddd\u770c, \u65b0\u6f5f\u770c, \u5bcc\u5c71\u770c, \u77f3\u5ddd\u770c, \u798f\u4e95\u770c, \u5c71\u68a8\u770c, \u9577\u91ce\u770c, \u5c90\u961c\u770c, \u9759\u5ca1\u770c, \u611b\u77e5\u770c, \u4e09\u91cd\u770c, \u6ecb\u8cc0\u770c, \u4eac\u90fd\u5e9c, \u5927\u962a\u5e9c, \u5175\u5eab\u770c, \u5948\u826f\u770c, \u548c\u6b4c\u5c71\u770c, \u9ce5\u53d6\u770c, \u5cf6\u6839\u770c, \u5ca1\u5c71\u770c, \u5e83\u5cf6\u770c, \u5c71\u53e3\u770c, \u5fb3\u5cf6\u770c, \u9999\u5ddd\u770c, \u611b\u5a9b\u770c, \u9ad8\u77e5\u770c, \u798f\u5ca1\u770c, \u4f50\u8cc0\u770c, \u9577\u5d0e\u770c, \u718a\u672c\u770c, \u5927\u5206\u770c, \u5bae\u5d0e\u770c, \u9e7f\u5150\u5cf6\u770c, \u6c96\u7e04\u770c] 48
\n[Pet2] [\u72ac\u6d3e, \u732b\u6d3e] 2
\n[Education2] [\u7fa9\u52d9\u6559\u80b2, \u9ad8\u7b49\u5b66\u6821, \u5404\u7a2e\u5c02\u9580\u5b66\u6821, \u77ed\u5927\u30fb\u9ad8\u5c02, \u5927\u5b66, \u5927\u5b66\u9662] 6
\n[Job2] [\u516c\u52d9\u54e1, \u4f1a\u793e\u54e1, \u81ea\u55b6\u696d, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u6559\u5e2b, \u533b\u5e2b, \u533b\u7642\u95a2\u4fc2, \u4fdd\u80b2\u58eb, \u8fb2\u6797\u30fb\u6f01\u696d, \u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8, \u5b66\u751f, \u5bb6\u4e8b\u624b\u4f1d, \u305d\u306e\u4ed6] 13
\n[Healthcare2] [\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, \u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044] 2<\/p><\/blockquote>\n
\u5fc5\u9808\u8981\u7d20\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u7528\u306e\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3\u306e\u8ffd\u52a0<\/h3>\n
\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u3059\u3079\u3066Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
WITH [\"\u91ce\u7403\",\"\u30b5\u30c3\u30ab\u30fc\",\"\u30d0\u30ec\u30fc\u30dc\u30fc\u30eb\",\"\u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb\",\"\u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9\",\"\u30e8\u30ac\",\"\u6563\u6b69\",\"\u30c0\u30f3\u30b9\",\"\u305d\u306e\u4ed6\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (a1:Sport3 {title: list[i]}))<\/p>\n
WITH [\"\u571f\u65e5\u795d\u65e5\",\"\u5e73\u65e5\",\"\u4e0d\u5b9a\u671f\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (b1:Holiday3 {title: list[i]}))<\/p>\n
WITH [\"\u805e\u304f\u30bf\u30a4\u30d7\",\"\u8a71\u3059\u30bf\u30a4\u30d7\",\"\u3068\u3061\u3089\u3067\u3082\u826f\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (c1:Talk3 {title: list[i]}))<\/p>\n
WITH [\"\u7a4d\u6975\u7684\",\"\u6d88\u6975\u7684\",\"\u3068\u3061\u3089\u3067\u3082\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (d1:Meeting3 {title: list[i]}))<\/p>\n
WITH [140,150,160,170,180,190,200] as list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (e1:Height3 {title: list[i]}))<\/p>\n
WITH [\"\u5916\u5411\u7684\",\"\u5185\u5411\u7684\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (f1:Personality3 {title: list[i]}))<\/p>\n
WITH [\"\u8aad\u66f8\",\"\u6620\u753b\u611f\u60f3\",\"\u97f3\u697d\u611f\u60f3\",\"TV\u611f\u60f3\",\"\u30b2\u30fc\u30e0\",\"\u5bdd\u308b\",\"\u53cb\u305f\u3061\u3068\u304a\u558b\u308a\",\"\u6599\u7406\u3092\u4f5c\u308b\",\"\u305d\u306e\u4ed6\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (g1:Indoor3 {title: list[i]}))<\/p>\n
WITH [\"\u5438\u3046\",\"\u5438\u308f\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (h1:Smoking3 {title: list[i]}))<\/p>\n
WITH [\"\u98f2\u3080\",\"\u98f2\u307e\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (j1:Alcohol3 {title: list[i]}))<\/p>\n
WITH [\"\u597d\u304d\",\"\u5acc\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (k1:Karaoke3 {title: list[i]}))<\/p>\n
WITH [\"\u4fe1\u3058\u308b\",\"\u4fe1\u3058\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (m1:Fortunetelling3 {title: list[i]}))<\/p>\n
WITH [\"\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b\",\"\u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (n1:Healthcare3 {title: list[i]}))<\/p>\n
WITH [\"\u6d77\",\"\u5c71\",\"\u5ddd\",\"\u516c\u5712\",\"\u904a\u5712\u5730\",\"\u3069\u3061\u3089\u3067\u3082\u3044\u3044\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (o1:Outdoor3 {title: list[i]}))<\/p>\n
WITH [100,200,300,400,500,600,700,800,900] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (p1:Income3 {title: list[i]}))<\/p>\n
WITH [\"\u6709\u308a\",\"\u7121\u3057\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (r1:Maritalhistory3 {title: list[i]}))<\/p>\n
WITH [\"\u72ac\u6d3e\",\"\u732b\u6d3e\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (s1:Pet3 {title: list[i]}))<\/p>\n
WITH [\"\u7fa9\u52d9\u6559\u80b2\",\"\u9ad8\u7b49\u5b66\u6821\",\"\u5404\u7a2e\u5c02\u9580\u5b66\u6821\",\"\u77ed\u5927\u30fb\u9ad8\u5c02\",\"\u5927\u5b66\",\"\u5927\u5b66\u9662\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (t1:Education3 {title: list[i]}))<\/p>\n
WITH [\"\u516c\u52d9\u54e1\",\"\u4f1a\u793e\u54e1\",\"\u81ea\u55b6\u696d\",\"\u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1\",\"\u6559\u5e2b\",\"\u533b\u5e2b\",\"\u533b\u7642\u95a2\u4fc2\",\"\u4fdd\u80b2\u58eb\",\"\u8fb2\u6797\u30fb\u6f01\u696d\",\"\u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8\",\"\u5b66\u751f\",\"\u5bb6\u4e8b\u624b\u4f1d\",\"\u305d\u306e\u4ed6\"] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (u1:Job3 {title: list[i]}))<\/p>\n
WITH [1995,1994,1993,1992,1991,1990,1989,1988,1987,1986,1985,1984,1983,1982,1981,1980,1979,1978,1977,1976,1975,1974,1973,1972,1971,1970] AS list
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (v1:Born3 {title: list[i]}))<\/p><\/blockquote>\n
\u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3001\u30e9\u30d9\u30eb\u3001\u8981\u7d20\u306e\u96c6\u5408\u3001\u8981\u7d20\u6570\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
MATCH (a:Sport3) RETURN labels(a) AS \u30e9\u30d9\u30eb,collect(a.title) AS \u8981\u7d20,length(collect(a.title)) AS \u6570 UNION ALL
\nMATCH (b:holiday3) RETURN labels(b) AS \u30e9\u30d9\u30eb, collect(b.title) AS \u8981\u7d20,length(collect(b.title)) AS \u6570 UNION ALL
\nMATCH (c:Talk3) RETURN labels(c) AS \u30e9\u30d9\u30eb, collect(c.title) AS \u8981\u7d20,length(collect(c.title)) AS \u6570 UNION ALL
\nMATCH (d:Height3) RETURN labels(d) AS \u30e9\u30d9\u30eb, collect(d.title) AS \u8981\u7d20,length(collect(d.title)) AS \u6570 UNION ALL
\nMATCH (e:Personality3) RETURN labels(e) AS \u30e9\u30d9\u30eb, collect(e.title) AS \u8981\u7d20,length(collect(e.title)) AS \u6570 UNION ALL
\nMATCH (f:Indoor3) RETURN labels(f) AS \u30e9\u30d9\u30eb, collect(f.title) AS \u8981\u7d20,length(collect(f.title)) AS \u6570 UNION ALL
\nMATCH (g:Smoking3) RETURN labels(g) AS \u30e9\u30d9\u30eb, collect(g.title) AS \u8981\u7d20,length(collect(g.title)) AS \u6570 UNION ALL
\nMATCH (h:Alcohol3) RETURN labels(h) AS \u30e9\u30d9\u30eb, collect(h.title) AS \u8981\u7d20,length(collect(h.title)) AS \u6570 UNION ALL
\nMATCH (i:Karaoke3) RETURN labels(i) AS \u30e9\u30d9\u30eb, collect(i.title) AS \u8981\u7d20,length(collect(i.title)) AS \u6570 UNION ALL
\nMATCH (j:Fortunetelling3) RETURN labels(j) AS \u30e9\u30d9\u30eb, collect(j.title) AS \u8981\u7d20,length(collect(j.title)) AS \u6570 UNION ALL
\nMATCH (k:Outdoor3) RETURN labels(k) AS \u30e9\u30d9\u30eb, collect(k.title) AS \u8981\u7d20,length(collect(k.title)) AS \u6570 UNION ALL
\nMATCH (l:Income3) RETURN labels(l) AS \u30e9\u30d9\u30eb, collect(l.title) AS \u8981\u7d20,length(collect(l.title)) AS \u6570 UNION ALL
\nMATCH (m:Born3) RETURN labels(m) AS \u30e9\u30d9\u30eb, collect(m.title) AS \u8981\u7d20,length(collect(m.title)) AS \u6570 UNION ALL
\nMATCH (o:Pet3) RETURN labels(o) AS \u30e9\u30d9\u30eb, collect(o.title) AS \u8981\u7d20,length(collect(o.title)) AS \u6570 UNION ALL
\nMATCH (p:Education3) RETURN labels(p) AS \u30e9\u30d9\u30eb, collect(p.title) AS \u8981\u7d20,length(collect(p.title)) AS \u6570 UNION ALL
\nMATCH (q:Job3) RETURN labels(q) AS \u30e9\u30d9\u30eb, collect(q.title) AS \u8981\u7d20,length(collect(q.title)) AS \u6570 UNION ALL
\nMATCH (r:Meet3) RETURN labels(r) AS \u30e9\u30d9\u30eb, collect(r.title) AS \u8981\u7d20,length(collect(r.title)) AS \u6570 UNION ALL
\nMATCH (s:Marriage3) RETURN labels(s) AS \u30e9\u30d9\u30eb, collect(s.title) AS \u8981\u7d20,length(collect(s.title)) AS \u6570 UNION ALL
\nMATCH (t:Healthcare3) RETURN labels(t) AS \u30e9\u30d9\u30eb, collect(t.title) AS \u8981\u7d20,length(collect(t.title)) AS \u6570
\n\u30e9\u30d9\u30eb \u8981\u7d20 \u6570
\n[Sport3] [\u91ce\u7403, \u30b5\u30c3\u30ab\u30fc, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb, \u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9, \u30e8\u30ac, \u6563\u6b69, \u30c0\u30f3\u30b9, \u305d\u306e\u4ed6] 9
\n[Talk3] [\u805e\u304f\u30bf\u30a4\u30d7, \u8a71\u3059\u30bf\u30a4\u30d7, \u3068\u3061\u3089\u3067\u3082\u826f\u3044] 3
\n[Height3] [140, 150, 160, 170, 180, 190, 200] 7
\n[Personality3] [\u5916\u5411\u7684, \u5185\u5411\u7684] 2
\n[Indoor3] [\u8aad\u66f8, \u6620\u753b\u611f\u60f3, \u97f3\u697d\u611f\u60f3, TV\u611f\u60f3, \u30b2\u30fc\u30e0, \u5bdd\u308b, \u53cb\u305f\u3061\u3068\u304a\u558b\u308a, \u6599\u7406\u3092\u4f5c\u308b, \u305d\u306e\u4ed6] 9
\n[Smoking3] [\u5438\u3046, \u5438\u308f\u306a\u3044] 2
\n[Alcohol3] [\u98f2\u3080, \u98f2\u307e\u306a\u3044] 2
\n[Karaoke3] [\u597d\u304d, \u5acc\u3044] 2
\n[Fortunetelling3] [\u4fe1\u3058\u308b, \u4fe1\u3058\u306a\u3044] 2
\n[Outdoor3] [\u6d77, \u5c71, \u5ddd, \u516c\u5712, \u904a\u5712\u5730, \u3069\u3061\u3089\u3067\u3082\u3044\u3044] 6
\n[Income3] [100, 200, 300, 400, 500, 600, 700, 800, 900] 9
\n[Born3] [1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970] 26
\n[Pet3] [\u72ac\u6d3e, \u732b\u6d3e] 2
\n[Education3] [\u7fa9\u52d9\u6559\u80b2, \u9ad8\u7b49\u5b66\u6821, \u5404\u7a2e\u5c02\u9580\u5b66\u6821, \u77ed\u5927\u30fb\u9ad8\u5c02, \u5927\u5b66, \u5927\u5b66\u9662] 6
\n[Job3] [\u516c\u52d9\u54e1, \u4f1a\u793e\u54e1, \u81ea\u55b6\u696d, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u6559\u5e2b, \u533b\u5e2b, \u533b\u7642\u95a2\u4fc2, \u4fdd\u80b2\u58eb, \u8fb2\u6797\u30fb\u6f01\u696d, \u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8, \u5b66\u751f, \u5bb6\u4e8b\u624b\u4f1d, \u305d\u306e\u4ed6] 13
\n[Healthcare3] [\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, \u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044] 2<\/p><\/blockquote>\n
\u30ea\u30af\u30a8\u30b9\u30c8\u7528\u306e\u95a2\u4fc2\u6027\u306e\u4f5c\u6210<\/h3>\n
\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u3059\u3079\u3066Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\nMATCH
\n(man:Man { name: \"M04\"}),
\n(a1:Alcohol2 { title: \"\u98f2\u3080\" }),
\n(a2:Born2 { title: 1981 }),
\n(b2:Born2 { title: 1982 }),
\n(c2:Born2 { title: 1983 }),
\n(d2:Born2 { title: 1984 }),
\n(e2:Born2 { title: 1985 }),
\n(f2:Born2 { title: 1986 }),
\n(g2:Born2 { title: 1987 }),
\n(h2:Born2 { title: 1988 }),
\n(i2:Born2 { title: 1989 }),
\n(a3:Education2 { title: \"\u77ed\u5927\u30fb\u9ad8\u5c02\" }),
\n(b3:Education2 { title: \"\u5927\u5b66\" }),
\n(c3:Education2 { title: \"\u5927\u5b66\u9662\" }),
\n(a4:Fortunetelling2 { title: \"\u4fe1\u3058\u306a\u3044\" }),
\n(a5:Healthcare2 { title: \"\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b\" }),
\n(a6:Height2 { title : 140 }),
\n(b6:Height2 { title : 150 }),
\n(c6:Height2 { title : 160 }),
\n(a7:Holiday2 { title : \"\u571f\u65e5\u795d\u65e5\" }),
\n(a8:Income2 { title : 100 }),
\n(b8:Income2 { title : 200 }),
\n(c8:Income2 { title : 300 }),
\n(d8:Income2 { title : 400 }),
\n(e8:Income2 { title : 500 }),
\n(f8:Income2 { title : 600 }),
\n(g8:Income2 { title : 700 }),
\n(h8:Income2 { title : 800 }),
\n(i8:Income2 { title : 900 }),
\n(a9:Indoor2 { title : \"\u6620\u753b\u611f\u60f3\" }),
\n(b9:Indoor2 { title : \"\u30b2\u30fc\u30e0\" }),
\n(a10:Job2 { title : \"\u516c\u52d9\u54e1\" }),
\n(b10:Job2 { title : \"\u4f1a\u793e\u54e1\" }),
\n(c10:Job2 { title : \"\u81ea\u55b6\u696d\" }),
\n(d10:Job2 { title : \"\u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1\" }),
\n(e10:Job2 { title : \"\u6559\u5e2b\" }),
\n(f10:Job2 { title : \"\u533b\u5e2b\" }),
\n(g10:Job2 { title : \"\u533b\u7642\u95a2\u4fc2\" }),
\n(h10:Job2 { title : \"\u4fdd\u80b2\u58eb\" }),
\n(i10:Job2 { title : \"\u8fb2\u6797\u30fb\u6f01\u696d\" }),
\n(j10:Job2 { title : \"\u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8\" }),
\n(k10:Job2 { title : \"\u305d\u306e\u4ed6\" }),
\n(a11:Karaoke2 { title : \"\u597d\u304d\" }),
\n(a12:Location2 { title : \"\u57fc\u7389\u770c\" }),
\n(b12:Location2 { title : \"\u5343\u8449\u770c\" }),
\n(c12:Location2 { title : \"\u6771\u4eac\u90fd\" }),
\n(d12:Location2 { title : \"\u795e\u5948\u5ddd\u770c\" }),
\n(a13:Maritalhistory2 { title : \"\u7121\u3057\" }),
\n(a14:Meeting2 { title : \"\u7a4d\u6975\u7684\" }),
\n(a15:Outdoor2 { title : \"\u6d77\" }),
\n(b15:Outdoor2 { title : \"\u5ddd\" }),
\n(a16:Personality2 { title : \"\u5916\u5411\u7684\" }),
\n(b16:Personality2 { title : \"\u5185\u5411\u7684\" }),
\n(a17:Pet2 { title : \"\u732b\u6d3e\" }),
\n(a18:Smoking2 { title : \"\u5438\u308f\u306a\u3044\" }),
\n(a19:Sport2 { title : \"\u91ce\u7403\" }),
\n(b19:Sport2 { title : \"\u30b5\u30c3\u30ab\u30fc\" }),
\n(c19:Sport2 { title : \"\u30d0\u30ec\u30fc\u30dc\u30fc\u30eb\" }),
\n(d19:Sport2 { title : \"\u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb\" }),
\n(e19:Sport2 { title : \"\u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9\" }),
\n(f19:Sport2 { title : \"\u30e8\u30ac\" }),
\n(g19:Sport2 { title : \"\u6563\u6b69\" }),
\n(h19:Sport2 { title : \"\u30c0\u30f3\u30b9\" }),
\n(i19:Sport2 { title : \"\u305d\u306e\u4ed6\" }),
\n(a20:Talk2 { title : \"\u8a71\u3059\u30bf\u30a4\u30d7\" })
\n\/\/RETURN *
\nCREATE
\nman-[:RE_ALCOHOL]->a1,
\nman-[:RE_BORN]->a2,
\nman-[:RE_BORN]->b2,
\nman-[:RE_BORN]->c2,
\nman-[:RE_BORN]->d2,
\nman-[:RE_BORN]->e2,
\nman-[:RE_BORN]->f2,
\nman-[:RE_BORN]->g2,
\nman-[:RE_BORN]->h2,
\nman-[:RE_BORN]->i2,
\nman-[:RE_EDUCATION]->a3,
\nman-[:RE_EDUCATION]->b3,
\nman-[:RE_EDUCATION]->c3,
\nman-[:RE_FORTUNETELLING]->a4,
\nman-[:RE_HEALTHCARE]->a5,
\nman-[:RE_HEIGHT]->a6,
\nman-[:RE_HEIGHT]->b6,
\nman-[:RE_HEIGHT]->c6,
\nman-[:RE_HOLIDAY]->a7,
\nman-[:RE_INCOME]->a8,
\nman-[:RE_INCOME]->b8,
\nman-[:RE_INCOME]->c8,
\nman-[:RE_INCOME]->d8,
\nman-[:RE_INCOME]->e8,
\nman-[:RE_INCOME]->f8,
\nman-[:RE_INCOME]->g8,
\nman-[:RE_INCOME]->h8,
\nman-[:RE_INCOME]->i8,
\nman-[:RE_INDOOR]->a9,
\nman-[:RE_INDOOR]->b9,
\nman-[:RE_JOB]->a10,
\nman-[:RE_JOB]->b10,
\nman-[:RE_JOB]->c10,
\nman-[:RE_JOB]->d10,
\nman-[:RE_JOB]->e10,
\nman-[:RE_JOB]->f10,
\nman-[:RE_JOB]->g10,
\nman-[:RE_JOB]->h10,
\nman-[:RE_JOB]->i10,
\nman-[:RE_JOB]->j10,
\nman-[:RE_JOB]->k10,
\nman-[:RE_KARAOKE]->a11,
\nman-[:RE_LOCATION]->a12,
\nman-[:RE_LOCATION]->b12,
\nman-[:RE_LOCATION]->c12,
\nman-[:RE_LOCATION]->d12,
\nman-[:RE_MARITALHISTORY]->a13,
\nman-[:RE_MEET]->a14,
\nman-[:RE_OUTDOOR]->a15,
\nman-[:RE_OUTDOOR]->b15,
\nman-[:RE_PERSONALITY]->a16,
\nman-[:RE_PERSONALITY]->b16,
\nman-[:RE_PET]->a17,
\nman-[:RE_SMOKING]->a18,
\nman-[:RE_SPORT]->a19,
\nman-[:RE_SPORT]->b19,
\nman-[:RE_SPORT]->c19,
\nman-[:RE_SPORT]->d19,
\nman-[:RE_SPORT]->e19,
\nman-[:RE_SPORT]->f19,
\nman-[:RE_SPORT]->g19,
\nman-[:RE_SPORT]->h19,
\nman-[:RE_SPORT]->i19,
\nman-[:RE_TALK]->a20<\/p>\n<\/blockquote>\n
\u30b0\u30e9\u30d5\u3092\u30b5\u30f3\u30d7\u30ea\u30f3\u30b0\u3057\u3066\u5b9f\u884c\u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u4ee5\u4e0b\u306f\u6559\u80b2\u6c34\u6e96\u306e\u30b0\u30e9\u30d5\u3067\u3059\u3002<\/p>\n
\nMATCH ()-[r:RE_EDUCATION]->() RETURN r<\/p>\n<\/blockquote>\n
![\"re_education\"\/](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/re_education.png\")
<\/p>\n
\u3057\u304b\u3057\u5927\u91cf\u306e\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3057\u305f\u5834\u5408\u3001\u90fd\u5ea6\u76ee\u8996\u3067\u78ba\u8a8d\u3059\u308b\u3053\u3068\u306f\u56f0\u96e3\u3067\u3059\u3002\u6b21\u306e\u3088\u3046\u306b\u30bf\u30a4\u30d7\u3084\u8981\u7d20\u3001\u6570\u3092\u78ba\u8a8d\u3059\u308bCypher\u30af\u30a8\u30ea\u30fc\u3092\u5229\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n
\nMATCH ()-[a:RE_SPORT]->(aa) RETURN type(a) AS \u30bf\u30a4\u30d7,collect(aa.title) AS \u8981\u7d20,length(collect(aa.title)) AS \u6570 UNION ALL
\nMATCH ()-[b:RE_HOLIDAY]->(bb) RETURN type(b) AS \u30bf\u30a4\u30d7,collect(bb.title) AS \u8981\u7d20,length(collect(bb.title)) AS \u6570 UNION ALL
\nMATCH ()-[c:RE_TALK]->(cc) RETURN type(c) AS \u30bf\u30a4\u30d7,collect(cc.title) AS \u8981\u7d20,length(collect(cc.title)) AS \u6570 UNION ALL
\nMATCH ()-[d:RE_HEIGHT]->(dd) RETURN type(d) AS \u30bf\u30a4\u30d7,collect(dd.title) AS \u8981\u7d20,length(collect(dd.title)) AS \u6570 UNION ALL
\nMATCH ()-[e:RE_PERSONALITY]->(ee) RETURN type(e) AS \u30bf\u30a4\u30d7,collect(ee.title) AS \u8981\u7d20,length(collect(ee.title)) AS \u6570 UNION ALL
\nMATCH ()-[f:RE_INDOOR]->(ff) RETURN type(f) AS \u30bf\u30a4\u30d7,collect(ff.title) AS \u8981\u7d20,length(collect(ff.title)) AS \u6570 UNION ALL
\nMATCH ()-[g:RE_SMOKING]->(gg) RETURN type(g) AS \u30bf\u30a4\u30d7,collect(gg.title) AS \u8981\u7d20,length(collect(gg.title)) AS \u6570 UNION ALL
\nMATCH ()-[h:RE_ALCOHOL]->(hh) RETURN type(h) AS \u30bf\u30a4\u30d7,collect(hh.title) AS \u8981\u7d20,length(collect(hh.title)) AS \u6570 UNION ALL
\nMATCH ()-[i:RE_KARAOKE]->(ii) RETURN type(i) AS \u30bf\u30a4\u30d7,collect(ii.title) AS \u8981\u7d20,length(collect(ii.title)) AS \u6570 UNION ALL
\nMATCH ()-[j:RE_FORTUNETELLING]->(jj) RETURN type(j) AS \u30bf\u30a4\u30d7,collect(jj.title) AS \u8981\u7d20,length(collect(jj.title)) AS \u6570 UNION ALL
\nMATCH ()-[k:RE_OUTDOOR]->(kk) RETURN type(k) AS \u30bf\u30a4\u30d7,collect(kk.title) AS \u8981\u7d20,length(collect(kk.title)) AS \u6570 UNION ALL
\nMATCH ()-[l:RE_INCOME]->(ll) RETURN type(l) AS \u30bf\u30a4\u30d7,collect(ll.title) AS \u8981\u7d20,length(collect(ll.title)) AS \u6570 UNION ALL
\nMATCH ()-[m:RE_BORN]->(mm) RETURN type(m) AS \u30bf\u30a4\u30d7,collect(mm.title) AS \u8981\u7d20,length(collect(mm.title)) AS \u6570 UNION ALL
\nMATCH ()-[n:RE_LOCATION]->(nn) RETURN type(n) AS \u30bf\u30a4\u30d7,collect(nn.title) AS \u8981\u7d20,length(collect(nn.title)) AS \u6570 UNION ALL
\nMATCH ()-[o:RE_PET]->(oo) RETURN type(o) AS \u30bf\u30a4\u30d7,collect(oo.title) AS \u8981\u7d20,length(collect(oo.title)) AS \u6570 UNION ALL
\nMATCH ()-[p:RE_EDUCATION]->(pp) RETURN type(p) AS \u30bf\u30a4\u30d7,collect(pp.title) AS \u8981\u7d20,length(collect(pp.title)) AS \u6570 UNION ALL
\nMATCH ()-[q:RE_JOB]->(qq) RETURN type(q) AS \u30bf\u30a4\u30d7,collect(qq.title) AS \u8981\u7d20,length(collect(qq.title)) AS \u6570 UNION ALL
\nMATCH ()-[r:RE_MEET]->(rr) RETURN type(r) AS \u30bf\u30a4\u30d7,collect(rr.title) AS \u8981\u7d20,length(collect(rr.title)) AS \u6570 UNION ALL
\nMATCH ()-[s:RE_MARRIAGE]->(ss) RETURN type(s) AS \u30bf\u30a4\u30d7,collect(ss.title) AS \u8981\u7d20,length(collect(ss.title)) AS \u6570 UNION ALL
\nMATCH ()-[t:RE_HEALTHCARE]->(tt) RETURN type(t) AS \u30bf\u30a4\u30d7,collect(tt.title) AS \u8981\u7d20,length(collect(tt.title)) AS \u6570
\n\u30bf\u30a4\u30d7 \u8981\u7d20 \u6570
\nRE_SPORT [\u91ce\u7403, \u30b5\u30c3\u30ab\u30fc, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb, \u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9, \u30e8\u30ac, \u6563\u6b69, \u30c0\u30f3\u30b9, \u305d\u306e\u4ed6] 9
\nRE_HOLIDAY [\u571f\u65e5\u795d\u65e5] 1
\nRE_TALK [\u8a71\u3059\u30bf\u30a4\u30d7] 1
\nRE_HEIGHT [160, 150, 140] 3
\nRE_PERSONALITY [\u5916\u5411\u7684, \u5185\u5411\u7684] 2
\nRE_INDOOR [\u6620\u753b\u611f\u60f3, \u30b2\u30fc\u30e0] 2
\nRE_SMOKING [\u5438\u308f\u306a\u3044] 1
\nRE_ALCOHOL [\u98f2\u3080] 1
\nRE_KARAOKE [\u597d\u304d] 1
\nRE_FORTUNETELLING [\u4fe1\u3058\u306a\u3044] 1
\nRE_OUTDOOR [\u6d77, \u5ddd] 2
\nRE_INCOME [100, 200, 300, 400, 500, 600, 700, 800, 900] 9
\nRE_BORN [1989, 1988, 1985, 1984, 1987, 1986, 1981, 1983, 1982] 9
\nRE_LOCATION [\u6771\u4eac\u90fd, \u795e\u5948\u5ddd\u770c, \u57fc\u7389\u770c, \u5343\u8449\u770c] 4
\nRE_PET [\u732b\u6d3e] 1
\nRE_EDUCATION [\u77ed\u5927\u30fb\u9ad8\u5c02, \u5927\u5b66, \u5927\u5b66\u9662] 3
\nRE_JOB [\u516c\u52d9\u54e1, \u4f1a\u793e\u54e1, \u81ea\u55b6\u696d, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u6559\u5e2b, \u533b\u5e2b, \u533b\u7642\u95a2\u4fc2, \u4fdd\u80b2\u58eb, \u8fb2\u6797\u30fb\u6f01\u696d, \u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8, \u305d\u306e\u4ed6] 11
\nRE_HEALTHCARE [\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b] 1<\/p>\n<\/blockquote>\n
\u5fc5\u9808\u8981\u7d20\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u7528\u306e\u95a2\u4fc2\u6027\u306e\u4f5c\u6210<\/h3>\n
\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u3059\u3079\u3066Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\nMATCH
\n(man:Man { name:\"M04\"}),
\n(a1:Born3 { title: 1970 }),
\n(b1:Born3 { title: 1971 }),
\n(c1:Born3 { title: 1972 }),
\n(d1:Born3 { title: 1973 }),
\n(e1:Born3 { title: 1974 }),
\n(f1:Born3 { title: 1975 }),
\n(g1:Born3 { title: 1976 }),
\n(h1:Born3 { title: 1977 }),
\n(i1:Born3 { title: 1978 }),
\n(j1:Born3 { title: 1979 }),
\n(k1:Born3 { title: 1980 }),
\n(l1:Born3 { title: 1990 }),
\n(m1:Born3 { title: 1991}),
\n(n1:Born3 { title: 1992}),
\n(o1:Born3 { title: 1993}),
\n(p1:Born3 { title: 1994}),
\n(q1:Born3 { title: 1995}),
\n(a3:Education3 { title: \"\u7fa9\u52d9\u6559\u80b2\" }),
\n(b3:Education3 { title: \"\u9ad8\u7b49\u5b66\u6821\" }),
\n(c3:Education3 { title: \"\u5404\u7a2e\u5c02\u9580\u5b66\u6821\" }),
\n(a4:Height3 { title: 170 }),
\n(b4:Height3 { title: 180 }),
\n(c4:Height3 { title: 190 }),
\n(d4:Height3 { title: 200 }),
\n(a5:Job3 { title: \"\u5bb6\u4e8b\u624b\u4f1d\" }),
\n(b5:Job3 { title: \"\u5b66\u751f\" })
\n\/\/RETURN *
\nCREATE
\nman-[:FI_BORN]->a1,
\nman-[:FI_BORN]->b1,
\nman-[:FI_BORN]->c1,
\nman-[:FI_BORN]->d1,
\nman-[:FI_BORN]->e1,
\nman-[:FI_BORN]->f1,
\nman-[:FI_BORN]->g1,
\nman-[:FI_BORN]->h1,
\nman-[:FI_BORN]->i1,
\nman-[:FI_BORN]->j1,
\nman-[:FI_BORN]->k1,
\nman-[:FI_BORN]->l1,
\nman-[:FI_BORN]->m1,
\nman-[:FI_BORN]->n1,
\nman-[:FI_BORN]->o1,
\nman-[:FI_BORN]->p1,
\nman-[:FI_BORN]->q1,
\nman-[:FI_EDUCATION]->a3,
\nman-[:FI_EDUCATION]->b3,
\nman-[:FI_EDUCATION]->c3,
\nman-[:FI_HEIGHT]->a4,
\nman-[:FI_HEIGHT]->b4,
\nman-[:FI_HEIGHT]->c4,
\nman-[:FI_HEIGHT]->d4,
\nman-[:FI_JOB]->a5,
\nman-[:FI_JOB]->b5<\/p>\n<\/blockquote>\n
\u5c45\u4f4f\u5730\u57df\u3082\u5fd8\u308c\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n
\nMERGE (man:Person:Man { name : \"M04\"})
\nON MATCH SET man.filter_location=\"\u5317\u6d77\u9053|\u9752\u68ee\u770c|\u5ca9\u624b\u770c|\u5bae\u57ce\u770c|\u79cb\u7530\u770c|\u5c71\u5f62\u770c|\u798f\u5cf6\u770c|\u8328\u57ce\u770c|\u6803\u6728\u770c|\u7fa4\u99ac\u770c|\u65b0\u6f5f\u770c|\u5bcc\u5c71\u770c|\u77f3\u5ddd\u770c|\u798f\u4e95\u770c|\u5c71\u68a8\u770c|\u9577\u91ce\u770c|\u5c90\u961c\u770c|\u9759\u5ca1\u770c|\u611b\u77e5\u770c|\u4e09\u91cd\u770c|\u6ecb\u8cc0\u770c|\u4eac\u90fd\u5e9c|\u5927\u962a\u5e9c|\u5175\u5eab\u770c|\u5948\u826f\u770c|\u548c\u6b4c\u5c71\u770c|\u9ce5\u53d6\u770c|\u5cf6\u6839\u770c|\u5ca1\u5c71\u770c|\u5e83\u5cf6\u770c|\u5c71\u53e3\u770c|\u5fb3\u5cf6\u770c|\u9999\u5ddd\u770c|\u611b\u5a9b\u770c|\u9ad8\u77e5\u770c|\u798f\u5ca1\u770c|\u4f50\u8cc0\u770c|\u9577\u5d0e\u770c|\u718a\u672c\u770c|\u5927\u5206\u770c|\u5bae\u5d0e\u770c|\u9e7f\u5150\u5cf6\u770c|\u6c96\u7e04\u770c\"<\/p>\n<\/blockquote>\n
\u30b0\u30e9\u30d5\u3092\u30b5\u30f3\u30d7\u30ea\u30f3\u30b0\u3057\u3066\u5b9f\u884c\u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u4ee5\u4e0b\u306f\u3001\u6559\u80b2\u6c34\u6e96\u306e\u30b0\u30e9\u30d5\u3067\u3059\u3002<\/p>\n
\nMATCH ()-[r:FI_EDUCATION]->() RETURN r<\/p>\n<\/blockquote>\n
![\"fi_education\"\/](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/fi_education.png\")
<\/p>\n
\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u5229\u7528\u3057\u3066\u30bf\u30a4\u30d7\u3084\u8981\u7d20\u3001\u6570\u3092\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n
\nMATCH ()-[a:FI_BORN]->(aa) RETURN type(a) AS \u30bf\u30a4\u30d7,collect(aa.title) AS \u8981\u7d20,length(collect(aa.title)) AS \u6570 UNION ALL
\nMATCH ()-[b:FI_EDUCATION]->(bb) RETURN type(b) AS \u30bf\u30a4\u30d7,collect(bb.title) AS \u8981\u7d20,length(collect(bb.title)) AS \u6570 UNION ALL
\nMATCH ()-[c:FI_HEIGHT]->(cc) RETURN type(c) AS \u30bf\u30a4\u30d7,collect(cc.title) AS \u8981\u7d20,length(collect(cc.title)) AS \u6570 UNION ALL
\nMATCH ()-[d:FI_JOB]->(dd) RETURN type(d) AS \u30bf\u30a4\u30d7,collect(dd.title) AS \u8981\u7d20,length(collect(dd.title)) AS \u6570
\n\u30bf\u30a4\u30d7 \u8981\u7d20 \u6570
\nFI_BORN [1995, 1994, 1993, 1992, 1991, 1990, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970] 17
\nFI_EDUCATION [\u7fa9\u52d9\u6559\u80b2, \u9ad8\u7b49\u5b66\u6821, \u5404\u7a2e\u5c02\u9580\u5b66\u6821] 3
\nFI_HEIGHT [170, 180, 190, 200] 4
\nFI_JOB [\u5bb6\u4e8b\u624b\u4f1d, \u5b66\u751f] 2<\/p>\n<\/blockquote>\n
\u6700\u5f8c\u306b\u3001\u5c45\u4f4f\u5730\u57df\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n
\nMATCH (man:Man { name:\"M04\" }) RETURN split(man.filter_location, \"|\") AS list
\nlist
\n[\u5317\u6d77\u9053, \u9752\u68ee\u770c, \u5ca9\u624b\u770c, \u5bae\u57ce\u770c, \u79cb\u7530\u770c, \u5c71\u5f62\u770c, \u798f\u5cf6\u770c, \u8328\u57ce\u770c, \u6803\u6728\u770c, \u7fa4\u99ac\u770c, \u65b0\u6f5f\u770c, \u5bcc\u5c71\u770c, \u77f3\u5ddd\u770c, \u798f\u4e95\u770c, \u5c71\u68a8\u770c, \u9577\u91ce\u770c, \u5c90\u961c\u770c, \u9759\u5ca1\u770c, \u611b\u77e5\u770c, \u4e09\u91cd\u770c, \u6ecb\u8cc0\u770c, \u4eac\u90fd\u5e9c, \u5927\u962a\u5e9c, \u5175\u5eab\u770c, \u5948\u826f\u770c, \u548c\u6b4c\u5c71\u770c, \u9ce5\u53d6\u770c, \u5cf6\u6839\u770c, \u5ca1\u5c71\u770c, \u5e83\u5cf6\u770c, \u5c71\u53e3\u770c, \u5fb3\u5cf6\u770c, \u9999\u5ddd\u770c, \u611b\u5a9b\u770c, \u9ad8\u77e5\u770c, \u798f\u5ca1\u770c, \u4f50\u8cc0\u770c, \u9577\u5d0e\u770c, \u718a\u672c\u770c, \u5927\u5206\u770c, \u5bae\u5d0e\u770c, \u9e7f\u5150\u5cf6\u770c, \u6c96\u7e04\u770c]<\/p>\n<\/blockquote>\n
M04\u3055\u3093\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u3084\u3063\u3066\u307f\u308b<\/a><\/h2>\n\n\u3053\u3053\u3067\u3001\u3053\u306e\u9023\u8f09\u3092\u611b\u8aad\u3057\u3066\u3044\u308b\u7686\u69d8\u306b\u3054\u4e86\u627f\u3092\u5f97\u305f\u3044\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u7b2c2\u56de\u76ee\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306eCypher\u30af\u30a8\u30ea\u30fc\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u306e\u8a2d\u5b9a\u306b\u9593\u9055\u3044\u304c\u3042\u308b\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3057\u305f\u3002\u307e\u305a\u3001\u7b2c2\u56de\u76ee\u306eCypher\u30af\u30a8\u30ea\u30fc\u306e\u9593\u9055\u3044\u3092\u76f4\u3057\u3066\u5b9f\u884c\u3057\u3066\u307f\u3066\u304b\u3089\u3001\u4eca\u56de\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u3055\u305b\u3066\u9802\u304d\u307e\u3059\u3002\u7533\u3057\u8a33\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<\/blockquote>\n
\u7b2c2\u56de\u76ee\u306eCypher\u30af\u30a8\u30ea\u30fc\u306e\u8a02\u6b63<\/h3>\n
\u4ee5\u4e0b\u306eCypher\u30af\u30a8\u30ea\u30fc\u304c\u7b2c2\u56de\u76ee\u306e\u9593\u9055\u3044\u3092\u8a02\u6b63\u3057\u305f\u30af\u30a8\u30ea\u30fc\u6587\u3067\u3059\u3002\u4eca\u56de\u306e\u5206\u6790\u3067\u5019\u88dc\u800526\u4eba\u306e\u306a\u304b\u3067M04\u3055\u3093\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u306b\u5408\u3063\u3066\u3044\u308b\u4eba\u306f5\u4eba\u3057\u304b\u5b58\u5728\u3057\u306a\u3044\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3057\u305f\u3002<\/p>\n
\nWITH [\"\u98f2\u3080\",1981,1982,1983,1984,1985,1986,1987,1989,\"\u5927\u5b66\",\"\u77ed\u5927\u30fb\u9ad8\u5c02\",\"\u5927\u5b66\u9662\",\"\u4fe1\u3058\u306a\u3044\",\"\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b\",140,150,160,\"\u571f\u65e5\u795d\u65e5\",100,200,300,400,500,600,700,800,900,\"\u6620\u753b\u611f\u60f3\",\"\u30b2\u30fc\u30e0\",\"\u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8\",\"\u8fb2\u6797\u30fb\u6f01\u696d\",\"\u4fdd\u80b2\u58eb\",\"\u81ea\u55b6\u696d\",\"\u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1\",\"\u6559\u5e2b\",\"\u533b\u5e2b\",\"\u516c\u52d9\u54e1\",\"\u4f1a\u793e\u54e1\",\"\u305d\u306e\u4ed6\",\"\u533b\u7642\u95a2\u4fc2\",\"\u597d\u304d\",\"\u6771\u4eac\u90fd\",\"\u795e\u5948\u5ddd\u770c\",\"\u57fc\u7389\u770c\",\"\u5343\u8449\u770c\",\"\u7121\u3057\",\"\u7a4d\u6975\u7684\",\"\u6d77\",\"\u5ddd\",\"\u5916\u5411\u7684\",\"\u5185\u5411\u7684\",\"\u732b\u6d3e\",\"\u5438\u308f\u306a\u3044\",\"\u30c0\u30f3\u30b9\",\"\u6563\u6b69\",\"\u91ce\u7403\",\"\u30b5\u30c3\u30ab\u30fc\",\"\u30d0\u30ec\u30fc\u30dc\u30fc\u30eb\",\"\u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb\",\"\u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9\",\"\u30e8\u30ac\",\"\u8a71\u3059\u30bf\u30a4\u30d7\"] AS list
\nMATCH (woman:Person:Woman)-[*]->(things)
\nWHERE NOT woman-[:DISAGREE|SUCCESS]-()
\nWITH woman, COLLECT(things.title) AS wlist,list, [1980,1979,1978,1977,1976,1975,1974,1973, 1972,1971,1970,1995,1994,1993,1992,1991,1990, \"\u7fa9\u52d9\u6559\u80b2\",\"\u9ad8\u7b49\u5b66\u6821\",\"\u5404\u7a2e\u5c02\u9580\u5b66\u6821\",\"\u5317\u6d77\u9053\",\"\u9752\u68ee\u770c\",\"\u5ca9\u624b\u770c\",\"\u5bae\u57ce\u770c\",\"\u79cb\u7530\u770c\",\"\u5c71\u5f62\u770c\",\"\u798f\u5cf6\u770c\",\"\u8328\u57ce\u770c\",\"\u6803\u6728\u770c\",\"\u7fa4\u99ac\u770c\",\"\u65b0\u6f5f\u770c\",\"\u5bcc\u5c71\u770c\",\"\u77f3\u5ddd\u770c\",\"\u798f\u4e95\u770c\",\"\u5c71\u68a8\u770c\",\"\u9577\u91ce\u770c\",\"\u5c90\u961c\u770c\",\"\u9759\u5ca1\u770c\",\"\u611b\u77e5\u770c\",\"\u4e09\u91cd\u770c\",\"\u6ecb\u8cc0\u770c\",\"\u4eac\u90fd\u5e9c\",\"\u5927\u962a\u5e9c\",\"\u5175\u5eab\u770c\",\"\u5948\u826f\u770c\",\"\u548c\u6b4c\u5c71\u770c\",\"\u9ce5\u53d6\u770c\",\"\u5cf6\u6839\u770c\",\"\u5ca1\u5c71\u770c, \u5e83\u5cf6\u770c\",\"\u5c71\u53e3\u770c\",\"\u5fb3\u5cf6\u770c\",\"\u9999\u5ddd\u770c\",\"\u611b\u5a9b\u770c\",\"\u9ad8\u77e5\u770c\",\"\u798f\u5ca1\u770c\",\"\u4f50\u8cc0\u770c\",\"\u9577\u5d0e\u770c\",\"\u718a\u672c\u770c\",\"\u5927\u5206\u770c\",\" \u5bae\u5d0e\u770c\",\"\u9e7f\u5150\u5cf6\u770c\",\"\u6c96\u7e04\u770c\",\"\u5bb6\u4e8b\u624b\u4f1d\",\"\u5b66\u751f\",170,180,190,200] AS list2
\nWHERE NONE ( x IN wlist WHERE x IN list2)
\nWITH woman, filter( x IN list WHERE x IN wlist) AS shared
\nWITH woman.name AS wlist, shared AS slist, 1.0 * length(shared) \/ 20 AS rank
\nRETURN wlist AS \u540d\u524d, slist AS \u5171\u901a\u8981\u7d20, rank AS \u985e\u4f3c\u6027
\nORDER BY rank DESC
\nLIMIT 10\n<\/p>\n<\/blockquote>\n
\u4ee5\u4e0b\u306f\u51fa\u529b\u3055\u308c\u308b\u7d50\u679c\u306e\u4f8b\u3067\u3059\u3002<\/p>\n
\n\n\u540d\u524d \u5171\u901a\u8981\u7d20 \u985e\u4f3c\u6027
\nW13 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 150, 700, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u6d77, \u5916\u5411\u7684, \u5438\u308f\u306a\u3044, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb] 0.8
\nW24 [1982, \u5927\u5b66, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 140, 600, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u7a4d\u6975\u7684, \u6d77, \u5916\u5411\u7684, \u732b\u6d3e, \u5438\u308f\u306a\u3044, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb] 0.8
\nW14 [\u98f2\u3080, 1983, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, 160, \u571f\u65e5\u795d\u65e5, 400, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u597d\u304d, \u795e\u5948\u5ddd\u770c, \u6d77, \u5185\u5411\u7684, \u732b\u6d3e, \u91ce\u7403, \u8a71\u3059\u30bf\u30a4\u30d7] 0.75
\nW22 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 160, \u571f\u65e5\u795d\u65e5, 300, \u516c\u52d9\u54e1, \u597d\u304d, \u6771\u4eac\u90fd, \u5916\u5411\u7684, \u732b\u6d3e, \u91ce\u7403] 0.7
\nW11 [1986, \u77ed\u5927\u30fb\u9ad8\u5c02, \u4fe1\u3058\u306a\u3044, 150, 300, \u516c\u52d9\u54e1, \u6771\u4eac\u90fd, \u7121\u3057, \u5185\u5411\u7684, \u5438\u308f\u306a\u3044, \u30e8\u30ac] 0.55<\/p>\n<\/blockquote>\n
\u7b2c2\u56de\u76ee\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306eCypher\u30af\u30a8\u30ea\u30fc\u306e\u9593\u9055\u3044\u306f\u6b21\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n
\u30fb\u5fc5\u9808\u6761\u4ef6\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u8981\u7d20\u3092\u5e74\u9f62\u306e\u307f\u306b\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u5b9f\u969b\u306f\u3001\u5e74\u9f62\u3001\u8eab\u9577\u3001\u5b66\u6b74\u3001\u8077\u696d\u3001\u5c45\u4f4f\u5730\u57df\u306e5\u500b\u3067\u3057\u305f\u3002
\n\u30fb\u5fc5\u9808\u6761\u4ef6\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u5b9f\u884c\u3059\u308b\u30af\u30a8\u30ea\u30fc\u30d6\u30ed\u30c3\u30af\u306e\u7b87\u6240\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u8981\u7d20\u3068\u306e\u30d1\u30bf\u30fc\u30f3\u30de\u30c3\u30c1\u3092\u5b9f\u884c\u3057\u3066\u304b\u3089\u884c\u3063\u3066\u3044\u307e\u3057\u305f\u3002\u3053\u308c\u306f\u3001\u30c7\u30fc\u30bf\u51e6\u7406\u91cf\u3092\u6e1b\u3089\u3059\u305f\u3081\u306b\u3082\u3001\u4e0d\u6b63\u78ba\u306a\u30d1\u30bf\u30fc\u30f3\u3092\u898b\u9003\u3055\u306a\u3044\u305f\u3081\u306b\u3082\u3001\u305d\u306e\u524d\u306e\u30af\u30a8\u30ea\u30fc\u30d6\u30ed\u30c3\u30af\u3067\u5b9f\u884c\u3059\u3079\u304d\u3053\u3068\u3067\u3057\u305f\u3002\u6b21\u306e\u69cb\u6587\u306e\u3053\u3068\u3067\u3059\u3002<\/p>\n
WHERE NONE ( x IN wlist WHERE x IN list2)<\/p>\n
\u4eca\u56de\u306e\u51e6\u7406<\/h3>\n
\u4eca\u56de\u306eCypher\u30af\u30a8\u30ea\u30fc\u3067\u306f\u3001\u3059\u3079\u3066\u306e\u30d1\u30bf\u30fc\u30f3\u306e\u53d6\u5f97\u3092Cypher\u30af\u30a8\u30ea\u30fc\u306e\u306a\u304b\u3067\u81ea\u5df1\u5b8c\u7d50\u3057\u3066\u3044\u307e\u3059\u3002\u7b2c2\u56de\u76ee\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306eCypher\u30af\u30a8\u30ea\u30fc\u3068\u6bd4\u8f03\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002\u5404\u7a2e\u30ea\u30b9\u30c8\u306e\u8981\u7d20\u304c\u5265\u304d\u51fa\u3057\u306b\u306a\u3063\u3066\u3044\u308b\u7b87\u6240\u304c\u3059\u3079\u3066\u306a\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
\nMATCH (man:Man{ name:\"M04\"})-[:RE_SPORT|RE_HOLIDAY|RE_TALK|RE_HEIGHT|RE_PERSONALITY|RE_INDOOR|RE_SMOKING|RE_ALCOHOL|RE_KARAOKE|RE_FORTUNETELLING|RE_OUTDOOR|RE_INCOME|RE_BORN|RE_LOCATION|RE_PET|RE_EDUCATION|RE_JOB|RE_MEET|RE_MARITALHISTORY|RE_HEALTHCARE]->(request),
\nman-[:FI_BORN|FI_EDUCATION|FI_HEIGHT|FI_JOB]->(filterCondition)
\nWITH split(man.filter_location, \"|\") AS fitlerLocation, collect(distinct request.title) AS requestList, collect(distinct filterCondition.title) AS filterList
\nMATCH (woman:Person:Woman)-[*]->(things)
\nWHERE NOT woman-[:DISAGREE|SUCCESS]-()
\nWITH woman, COLLECT(things.title) AS womanCondition, fitlerLocation, filterList, requestList
\nWHERE NONE ( x IN womanCondition WHERE x IN filterList) AND NONE ( x IN womanCondition WHERE x IN fitlerLocation)
\nWITH woman, filter( x IN requestList WHERE x IN womanCondition) AS shared, fitlerLocation, filterList
\nWITH woman.name AS wlist, shared AS slist, 1.0 * length(shared) \/ 20 AS rank
\nRETURN wlist AS \u540d\u524d, slist AS \u5171\u901a\u8981\u7d20, rank\u3000AS \u30e9\u30f3\u30af
\nORDER BY rank DESC
\nLIMIT 10\n<\/p>\n<\/blockquote>\n
\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u7d50\u679c\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n
\n\n\u540d\u524d \u5171\u901a\u8981\u7d20 \u30e9\u30f3\u30af
\nW13 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 150, 700, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u6d77, \u5916\u5411\u7684, \u5438\u308f\u306a\u3044, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb] 0.8
\nW24 [1982, \u5927\u5b66, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 140, 600, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u7a4d\u6975\u7684, \u6d77, \u5916\u5411\u7684, \u732b\u6d3e, \u5438\u308f\u306a\u3044, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb] 0.8
\nW14 [\u98f2\u3080, 1983, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, 160, \u571f\u65e5\u795d\u65e5, 400, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u597d\u304d, \u795e\u5948\u5ddd\u770c, \u6d77, \u5185\u5411\u7684, \u732b\u6d3e, \u91ce\u7403, \u8a71\u3059\u30bf\u30a4\u30d7] 0.75
\nW22 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 160, \u571f\u65e5\u795d\u65e5, 300, \u516c\u52d9\u54e1, \u597d\u304d, \u6771\u4eac\u90fd, \u5916\u5411\u7684, \u732b\u6d3e, \u91ce\u7403] 0.7
\nW11 [1986, \u77ed\u5927\u30fb\u9ad8\u5c02, \u4fe1\u3058\u306a\u3044, 150, 300, \u516c\u52d9\u54e1, \u6771\u4eac\u90fd, \u7121\u3057, \u5185\u5411\u7684, \u5438\u308f\u306a\u3044, \u30e8\u30ac] 0.55<\/p>\n<\/blockquote>\n
\u3057\u304b\u3057\u306a\u304c\u3089M04\u3055\u3093\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u306b\u5408\u3063\u3066\u3044\u308b\u4eba\u306f5\u4eba\u3057\u304b\u5b58\u5728\u3057\u306a\u3044\u3053\u3068\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u3002\u3082\u3061\u308d\u3093\u3001\u4eca\u56de\u306e\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u767b\u9332\u3057\u3066\u3044\u308b\u5973\u6027\u306e\u4eba\u6570\u304c\u5c11\u306a\u3044\u305f\u3081\u3067\u3059\u304c\u3001\u305d\u308c\u3067\u308226\u4eba\u306e\u306a\u304b\u3067\u306e5\u4eba\u3068\u3044\u3046\u7d50\u679c\u306f\u5c11\u3057\u5bc2\u3057\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u306d\u3002M04\u3055\u3093\u3001\u9811\u5f35\u3063\u3066\u304f\u3060\u3055\u3044\uff01<\/p>\n
M04\u3055\u3093\u306e\u5019\u88dc\u8005\u3067\u30ea\u30af\u30a8\u30b9\u30c8\u3068\u7570\u306a\u308b\u8981\u7d20\u3092\u307f\u308b<\/h3>\n
\u524d\u9805\u306e5\u4eba\u306e\u5019\u88dc\u8005\u306e\u60c5\u5831\u304b\u3089M04\u3055\u3093\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u3068\u4e00\u81f4\u3057\u306a\u3044\u8981\u7d20\u3092\u51fa\u3057\u3066\u307f\u307e\u3059\u3002\u5fc5\u9808\u6761\u4ef6\u3068\u3057\u3066\u306f\u51fa\u3057\u3066\u306a\u3044\u3067\u3059\u304c\u3001\u5185\u5fc3\u3001\u3053\u308c\u3060\u3051\u306fM04\u3055\u3093\u306e\u6c17\u6301\u3061\u3067\u306f\u52d8\u5f01\u3057\u3066\u307b\u3057\u3044\u3068\u601d\u3046\u3053\u3068\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n
\nMATCH (man:Man{ name:\"M04\"})-[:RE_SPORT|RE_HOLIDAY|RE_TALK|RE_HEIGHT|RE_PERSONALITY|RE_INDOOR|RE_SMOKING|RE_ALCOHOL|RE_KARAOKE|RE_FORTUNETELLING|RE_OUTDOOR|RE_INCOME|RE_BORN|RE_LOCATION|RE_PET|RE_EDUCATION|RE_JOB|RE_MEET|RE_MARITALHISTORY|RE_HEALTHCARE]->(request),
\nman-[:FI_BORN|FI_EDUCATION|FI_HEIGHT|FI_JOB]->(filterCondition)
\nWITH split(man.filter_location, \"|\") AS fitlerLocation, collect(distinct request.title) AS requestList, collect(distinct filterCondition.title) AS filterList
\nMATCH (woman:Person:Woman)-[*]->(things)
\nWHERE NOT woman-[:DISAGREE|SUCCESS]-()
\nWITH woman, COLLECT(things.title) AS womanCondition, fitlerLocation, filterList, requestList
\nWHERE NONE ( x IN womanCondition WHERE x IN filterList) AND NONE ( x IN womanCondition WHERE x IN fitlerLocation)
\nWITH woman, filter( x IN requestList WHERE x IN womanCondition) AS shared, fitlerLocation, filterList, womanCondition, requestList
\nWITH woman.name AS wlist, shared AS slist, 1.0 * length(shared) \/ 20 AS rank , womanCondition, requestList
\nWITH wlist,slist,rank, requestList, womanCondition
\nORDER BY rank DESC
\nLIMIT 10
\nRETURN wlist AS \u540d\u524d, slist AS \u5171\u901a\u8981\u7d20, rank AS \u985e\u4f3c\u6027, filter( x IN womanCondition WHERE NOT(x IN requestList)) AS \u4e0d\u4e00\u81f4\n<\/p>\n<\/blockquote>\n
\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u7d50\u679c\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n
\n\n\u540d\u524d \u5171\u901a\u8981\u7d20 \u985e\u4f3c\u6027 \u4e0d\u4e00\u81f4
\nW13 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 150, 700, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u6d77, \u5916\u5411\u7684, \u5438\u308f\u306a\u3044, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb] 0.8 [\u4e0d\u5b9a\u671f, \u3068\u3061\u3089\u3067\u3082\u826f\u3044, \u6d88\u6975\u7684, \u72ac\u6d3e]
\nW24 [1982, \u5927\u5b66, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 140, 600, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u7a4d\u6975\u7684, \u6d77, \u5916\u5411\u7684, \u732b\u6d3e, \u5438\u308f\u306a\u3044, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb] 0.8 [\u5e73\u65e5, \u3068\u3061\u3089\u3067\u3082\u826f\u3044, \u98f2\u307e\u306a\u3044, \u4fe1\u3058\u308b]
\nW14 [\u98f2\u3080, 1983, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, 160, \u571f\u65e5\u795d\u65e5, 400, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u597d\u304d, \u795e\u5948\u5ddd\u770c, \u6d77, \u5185\u5411\u7684, \u732b\u6d3e, \u91ce\u7403, \u8a71\u3059\u30bf\u30a4\u30d7] 0.75 [\u3068\u3061\u3089\u3067\u3082\u306a\u3044, \u5bdd\u308b, \u5438\u3046, \u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044, \u6709\u308a]
\nW22 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 160, \u571f\u65e5\u795d\u65e5, 300, \u516c\u52d9\u54e1, \u597d\u304d, \u6771\u4eac\u90fd, \u5916\u5411\u7684, \u732b\u6d3e, \u91ce\u7403] 0.7 [\u805e\u304f\u30bf\u30a4\u30d7, \u6d88\u6975\u7684, \u97f3\u697d\u611f\u60f3, \u5438\u3046, \u5c71, \u6709\u308a]
\nW11 [1986, \u77ed\u5927\u30fb\u9ad8\u5c02, \u4fe1\u3058\u306a\u3044, 150, 300, \u516c\u52d9\u54e1, \u6771\u4eac\u90fd, \u7121\u3057, \u5185\u5411\u7684, \u5438\u308f\u306a\u3044, \u30e8\u30ac] 0.55 [\u5e73\u65e5, \u805e\u304f\u30bf\u30a4\u30d7, \u3068\u3061\u3089\u3067\u3082\u306a\u3044, \u97f3\u697d\u611f\u60f3, \u98f2\u307e\u306a\u3044, \u5acc\u3044, \u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044, \u516c\u5712, \u72ac\u6d3e]<\/p>\n<\/blockquote>\n
\u307e\u3068\u3081<\/a><\/h2>\n\u3053\u308c\u3067\u300c\u5a5a\u6d3b\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u300d\u306e\u9023\u8f09\u306f\u7d42\u4e86\u3055\u305b\u3066\u9802\u304d\u307e\u3059\u3002\u4eca\u56de\u306e\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306f\u3001\u73fe\u5b9f\u306e\u4e16\u754c\u306b\u6709\u308a\u5f97\u308b\u3053\u3068\u3092\u7d20\u6750\u306b\u3057\u3066\u306f\u3044\u307e\u3059\u304c\u3001\u69d8\u3005\u306a\u3053\u3068\u3092\u5358\u7d14\u5316\u3057\u3066\u3044\u307e\u3059\u3002\u4eca\u56de\u306e\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u3084\u51e6\u7406\u65b9\u6cd5\u304c\u3001\u3053\u306e\u3088\u3046\u306a\u30b1\u30fc\u30b9\u306b\u304a\u3051\u308b\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3068\u306f\u601d\u3063\u3066\u304a\u308a\u307e\u305b\u3093\u3002\u3082\u3057\u304a\u6c17\u3065\u304d\u306e\u3068\u3053\u308d\u304c\u3042\u308a\u307e\u3057\u305f\u3089\u662f\u975e\u30b3\u30e1\u30f3\u30c8\u3092\u9802\u3051\u308b\u3068\u5e78\u3044\u3067\u3059\u3002\u3053\u3053\u307e\u3067\u611b\u8aad\u3057\u3066\u9802\u3044\u305f\u65b9\u9054\u306b\u4f55\u304b\u5f79\u306b\u7acb\u3064\u3053\u3068\u304c1\u3064\u3067\u3082\u3042\u3063\u305f\u3068\u3059\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n
\n[\u60c5\u5831\u3068\u60c5\u5831\u306e\u7e4b\u304c\u308a\u306f\u4fa1\u5024\u3067\u3042\u308b]
\nGoogle\u3084Facebook, Twitter\u306a\u3069\u3001\u4e16\u754c\u3092\u30ea\u30fc\u30c9\u3059\u308bIT\u4f01\u696d\u3067\u306f\u3001\u65e2\u306b10\u5e74\u4ee5\u4e0a\u524d\u304b\u3089\u300c\u60c5\u5831\u3068\u60c5\u5831\u306e\u7e4b\u304c\u308a\u306f\u4fa1\u5024\u3067\u3042\u308b\u300d\u3044\u3046\u601d\u60f3\u3092\u6301\u3063\u3066\u3044\u305f\u3088\u3046\u3067\u3059\u3002\u3053\u308c\u3089\u306e\u4f01\u696d\u9054\u306f\u3001\u7e4b\u304c\u308a\u3092\u8d77\u696d\u3084\u65b0\u3057\u3044\u30b5\u30fc\u30d3\u30b9\u5c55\u958b\u306e\u305f\u3081\u306e\u4e2d\u6838\u306b\u636e\u3048\u3066\u3044\u305f\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002\u305d\u3057\u3066\u3001\u7e4b\u304c\u308a\u3092\u5229\u7528\u3059\u308b\u305f\u3081\u306e\u624b\u6bb5\uff08\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff09\u306e\u958b\u767a\u3084\u5229\u7528\u306b\u3082\u71b1\u5fc3\u306b\u53d6\u308a\u7d44\u3093\u3067\u304d\u307e\u3057\u305f\u3002\u6c4e\u7528\u578b\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u3082\u8a00\u3048\u308bNeo4j\u3082\u3001\u3053\u308c\u3089\u306e\u4f01\u696d\u306e\u601d\u60f3\u3084\u6280\u8853\u306b\u5f71\u97ff\u3092\u53d7\u3051\u3066\u3044\u308b\u3068\u3044\u308f\u308c\u3066\u3044\u307e\u3059\u3002
\n\u5f93\u6765\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8003\u3048\u65b9\u304b\u3089\u8a00\u3046\u3068\u3001\u7e4b\u304c\u308a\u306fER\u56f3\u3084\u30b8\u30e7\u30a4\u30f3\u306a\u3069\u306e\u305f\u3081\u306e\u7d10\u4ed8\u3068\u8868\u73fe\u3057\u3001\u60c5\u5831\u3092\u691c\u7d22\u3059\u308b\u305f\u3081\u306e\u624b\u6bb5\u3068\u3044\u3046\u4f4d\u7f6e\u3065\u3051\u3067\u3057\u305f\u3002\u3082\u3061\u308d\u3093\u3001\u60c5\u5831\u3092\u691c\u7d22\u3059\u308b\u305f\u3081\u306e\u624b\u6bb5\u3068\u3044\u3046\u306e\u3082\u91cd\u8981\u306a\u3053\u3068\u3067\u3059\u304c\u3001\u300c\u60c5\u5831\u3068\u60c5\u5831\u306e\u7e4b\u304c\u308a\u306f\u4fa1\u5024\u3067\u3042\u308b\u300d\u3068\u3044\u3046\u601d\u60f3\u3068\u306f\u3001\u5927\u304d\u306a\u9694\u305f\u308a\u304c\u3042\u308b\u3088\u3046\u306a\u6c17\u304c\u3057\u307e\u3059\u3002
\n\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5229\u7528\u3059\u308b\u306b\u5f53\u305f\u3063\u3066\u306f\u3001\u3053\u306e\u601d\u60f3\u306e\u9055\u3044\u3092\u7406\u89e3\u3057\u3066\u9802\u304d\u305f\u3044\u3067\u3059\u3002\u65e2\u306b\u5b58\u5728\u3059\u308b\u7e4b\u304c\u308a\u304b\u3089\u65b0\u3057\u3044\u4fa1\u5024\u3092\u767a\u6398\u3059\u308b\u3001\u7e4b\u304c\u308a\u304c\u5b58\u5728\u3057\u306a\u304b\u3063\u305f\u7b87\u6240\u306b\u7e4b\u304c\u308a\u3092\u4f5c\u308b\u3053\u3068\u3067\u3001\u3055\u3089\u306b\u65b0\u3057\u3044\u4fa1\u5024\u9023\u9396\u3092\u5f15\u304d\u8d77\u3053\u3059\u3053\u3068\u304c\u3001\u3053\u308c\u304b\u3089\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u3082\u305f\u3089\u3059\u672a\u6765\u306a\u306e\u304b\u3082\u77e5\u308c\u307e\u305b\u3093\u3002<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"
\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j\u306e\u5b9f\u8df5\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306e1\u4f8b\u3092\u7d39\u4ecb\u3059\u308b\u305f\u3081\u306b\u59cb\u3081\u305f\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u3044\u3088\u3044\u3088\u6700\u7d42\u56de\u3092\u8fce\u3048\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9032\u3081\u3066\u3044\u308b\u306a\u304b\u3067\u767a\u751f\u3057\u305f\u554f\u984c\u70b9\u306a\u3069\u306e\u6539\u5584\u7b56\u3092\u76db\u308a\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u30e2 […]<\/p>\n","protected":false},"author":13,"featured_media":12212,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[61,37],"tags":[],"class_list":["post-12205","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lee","category-neo4j"],"acf":[],"yoast_head":"\n
\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3<\/title>\n<meta name=\"description\" content=\"lee, Neo4j |\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j\u306e\u5b9f\u8df5\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306e1\u4f8b\u3092\u7d39\u4ecb\u3059\u308b\u305f\u3081\u306b\u59cb\u3081\u305f\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u3044\u3088\u3044\u3088\u6700\u7d42\u56de\u3092\u8fce\u3048\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9032\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\" \/>\n<meta property=\"og:description\" content=\"lee, Neo4j |\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j\u306e\u5b9f\u8df5\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306e1\u4f8b\u3092\u7d39\u4ecb\u3059\u308b\u305f\u3081\u306b\u59cb\u3081\u305f\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u3044\u3088\u3044\u3088\u6700\u7d42\u56de\u3092\u8fce\u3048\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9032\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205\" \/>\n<meta property=\"og:site_name\" content=\"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/creationline\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-17T05:47:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-13T06:33:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/re-datamodel1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"855\" \/>\n\t<meta property=\"og:image:height\" content=\"356\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"lee\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@awk256\" \/>\n<meta name=\"twitter:site\" content=\"@creationline\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"lee\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"17\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205\"},\"author\":{\"name\":\"lee\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#\\\/schema\\\/person\\\/7a9c09b6fc036bd56d9a7f7264389616\"},\"headline\":\"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\\\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j\",\"datePublished\":\"2015-12-17T05:47:26+00:00\",\"dateModified\":\"2022-12-13T06:33:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205\"},\"wordCount\":3312,\"image\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/cms_x3GWkuX\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/re-datamodel1.png\",\"articleSection\":[\"lee\",\"Neo4j\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205\",\"url\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205\",\"name\":\"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\\\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/cms_x3GWkuX\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/re-datamodel1.png\",\"datePublished\":\"2015-12-17T05:47:26+00:00\",\"dateModified\":\"2022-12-13T06:33:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#\\\/schema\\\/person\\\/7a9c09b6fc036bd56d9a7f7264389616\"},\"description\":\"lee, Neo4j |\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j\u306e\u5b9f\u8df5\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306e1\u4f8b\u3092\u7d39\u4ecb\u3059\u308b\u305f\u3081\u306b\u59cb\u3081\u305f\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u3044\u3088\u3044\u3088\u6700\u7d42\u56de\u3092\u8fce\u3048\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9032\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205#primaryimage\",\"url\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/cms_x3GWkuX\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/re-datamodel1.png\",\"contentUrl\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/cms_x3GWkuX\\\/wp-content\\\/uploads\\\/2015\\\/12\\\/re-datamodel1.png\",\"width\":855,\"height\":356},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\\\/12205#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"HOME\",\"item\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u30c7\u30fc\u30bf\u200b\u200b\u30de\u30cd\u30b8\u30e1\u30f3\u30c8\",\"item\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Neo4j\",\"item\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/data-management\\\/neo4j\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\\\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/\",\"name\":\"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3\",\"description\":\"\u30a2\u30b8\u30e3\u30a4\u30eb\uff06DevOps\u3001\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u3001AI\uff06LLM\u306e\u5148\u7aef\u6280\u8853\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/#\\\/schema\\\/person\\\/7a9c09b6fc036bd56d9a7f7264389616\",\"name\":\"lee\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g\",\"caption\":\"lee\"},\"description\":\"\u30e2\u30c0\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc\u57fa\u76e4\u306e\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c8\u3068\u3057\u3066\u6d3b\u52d5\u3057\u3066\u3044\u307e\u3059\u3002 [\u8457\u66f8] \u30fbAmazon Cloud\u30c6\u30af\u30cb\u30ab\u30eb\u30ac\u30a4\u30c9\u2015EC2\\\/S3\u304b\u3089VPC\u307e\u3067\u5fb9\u5e95\u89e3\u6790 \u30fbAmazon Elastic MapReduce\u30c6\u30af\u30cb\u30ab\u30eb\u30ac\u30a4\u30c9 \u2015\u30af\u30e9\u30a6\u30c9\u578bHadoop\u3067\u5b9f\u73fe\u3059\u308b\u5927\u898f\u6a21\u5206\u6563\u51e6\u7406 \u30fbCypher\u30af\u30a8\u30ea\u30fc\u8a00\u8a9e\u306e\u4e8b\u4f8b\u3067\u5b66\u3076\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j \u30fbNeo4j\u3092\u4f7f\u3046\u30b0\u30e9\u30d5\u578b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5165\u9580(\u5171\u8457) \u30fbRDB\u6280\u8853\u8005\u306e\u305f\u3081\u306eNoSQL\u30ac\u30a4\u30c9(\u5171\u8457)\",\"sameAs\":[\"https:\\\/\\\/x.com\\\/@awk256\"],\"url\":\"https:\\\/\\\/www.creationline.com\\\/tech-blog\\\/author\\\/lee\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","description":"lee, Neo4j |\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j\u306e\u5b9f\u8df5\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306e1\u4f8b\u3092\u7d39\u4ecb\u3059\u308b\u305f\u3081\u306b\u59cb\u3081\u305f\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u3044\u3088\u3044\u3088\u6700\u7d42\u56de\u3092\u8fce\u3048\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9032","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205","og_locale":"ja_JP","og_type":"article","og_title":"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","og_description":"lee, Neo4j |\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j\u306e\u5b9f\u8df5\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306e1\u4f8b\u3092\u7d39\u4ecb\u3059\u308b\u305f\u3081\u306b\u59cb\u3081\u305f\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u3044\u3088\u3044\u3088\u6700\u7d42\u56de\u3092\u8fce\u3048\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9032","og_url":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205","og_site_name":"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","article_publisher":"https:\/\/www.facebook.com\/creationline","article_published_time":"2015-12-17T05:47:26+00:00","article_modified_time":"2022-12-13T06:33:38+00:00","og_image":[{"width":855,"height":356,"url":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/re-datamodel1.png","type":"image\/png"}],"author":"lee","twitter_card":"summary_large_image","twitter_creator":"@awk256","twitter_site":"@creationline","twitter_misc":{"\u57f7\u7b46\u8005":"lee","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"17\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205#article","isPartOf":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205"},"author":{"name":"lee","@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616"},"headline":"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j","datePublished":"2015-12-17T05:47:26+00:00","dateModified":"2022-12-13T06:33:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205"},"wordCount":3312,"image":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205#primaryimage"},"thumbnailUrl":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/re-datamodel1.png","articleSection":["lee","Neo4j"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205","url":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205","name":"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j - Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","isPartOf":{"@id":"https:\/\/www.creationline.com\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205#primaryimage"},"image":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205#primaryimage"},"thumbnailUrl":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/re-datamodel1.png","datePublished":"2015-12-17T05:47:26+00:00","dateModified":"2022-12-13T06:33:38+00:00","author":{"@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616"},"description":"lee, Neo4j |\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j\u306e\u5b9f\u8df5\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306e1\u4f8b\u3092\u7d39\u4ecb\u3059\u308b\u305f\u3081\u306b\u59cb\u3081\u305f\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u3044\u3088\u3044\u3088\u6700\u7d42\u56de\u3092\u8fce\u3048\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9032","breadcrumb":{"@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205#primaryimage","url":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/re-datamodel1.png","contentUrl":"https:\/\/www.creationline.com\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2015\/12\/re-datamodel1.png","width":855,"height":356},{"@type":"BreadcrumbList","@id":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j\/12205#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"HOME","item":"https:\/\/www.creationline.com\/tech-blog"},{"@type":"ListItem","position":2,"name":"\u30c7\u30fc\u30bf\u200b\u200b\u30de\u30cd\u30b8\u30e1\u30f3\u30c8","item":"https:\/\/www.creationline.com\/tech-blog\/data-management"},{"@type":"ListItem","position":3,"name":"Neo4j","item":"https:\/\/www.creationline.com\/tech-blog\/data-management\/neo4j"},{"@type":"ListItem","position":4,"name":"\u5a5a\u6d3b\u652f\u63f4\u30d7\u30ed\u30b8\u30a7\u30af\u30c8(4\/4): \u6539\u5584\u3057\u305f\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306b\u3088\u308b\u30c7\u30fc\u30bf\u51e6\u7406 #neo4j"}]},{"@type":"WebSite","@id":"https:\/\/www.creationline.com\/tech-blog\/#website","url":"https:\/\/www.creationline.com\/tech-blog\/","name":"Tech Blog\uff5c\u30af\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u30e9\u30a4\u30f3","description":"\u30a2\u30b8\u30e3\u30a4\u30eb\uff06DevOps\u3001\u30af\u30e9\u30a6\u30c9\u30cd\u30a4\u30c6\u30a3\u30d6\u3001AI\uff06LLM\u306e\u5148\u7aef\u6280\u8853","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.creationline.com\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/www.creationline.com\/tech-blog\/#\/schema\/person\/7a9c09b6fc036bd56d9a7f7264389616","name":"lee","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/278a9c7ed6393635496209225c69f2d6caf4f4b360cf0c2a80ada723070d4f94?s=96&d=wp_user_avatar&r=g","caption":"lee"},"description":"\u30e2\u30c0\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc\u57fa\u76e4\u306e\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30a2\u30fc\u30ad\u30c6\u30af\u30c8\u3068\u3057\u3066\u6d3b\u52d5\u3057\u3066\u3044\u307e\u3059\u3002 [\u8457\u66f8] \u30fbAmazon Cloud\u30c6\u30af\u30cb\u30ab\u30eb\u30ac\u30a4\u30c9\u2015EC2\/S3\u304b\u3089VPC\u307e\u3067\u5fb9\u5e95\u89e3\u6790 \u30fbAmazon Elastic MapReduce\u30c6\u30af\u30cb\u30ab\u30eb\u30ac\u30a4\u30c9 \u2015\u30af\u30e9\u30a6\u30c9\u578bHadoop\u3067\u5b9f\u73fe\u3059\u308b\u5927\u898f\u6a21\u5206\u6563\u51e6\u7406 \u30fbCypher\u30af\u30a8\u30ea\u30fc\u8a00\u8a9e\u306e\u4e8b\u4f8b\u3067\u5b66\u3076\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j \u30fbNeo4j\u3092\u4f7f\u3046\u30b0\u30e9\u30d5\u578b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5165\u9580(\u5171\u8457) \u30fbRDB\u6280\u8853\u8005\u306e\u305f\u3081\u306eNoSQL\u30ac\u30a4\u30c9(\u5171\u8457)","sameAs":["https:\/\/x.com\/@awk256"],"url":"https:\/\/www.creationline.com\/tech-blog\/author\/lee"}]}},"_links":{"self":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/12205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/comments?post=12205"}],"version-history":[{"count":7,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/12205\/revisions"}],"predecessor-version":[{"id":57639,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/posts\/12205\/revisions\/57639"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/media\/12212"}],"wp:attachment":[{"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/media?parent=12205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/categories?post=12205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.creationline.com\/tech-blog\/wp-json\/wp\/v2\/tags?post=12205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nMY:Original\u3000RE:Request\u3000FI:Filter<\/p>\n
\u5b8c\u6210\u3057\u305f\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5229\u7528\u3059\u308b\u65b9\u306f\u3001\u300eM04\u3055\u3093\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u3084\u3063\u3066\u307f\u308b<\/a>\u300f\u306b\u9032\u3093\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n \u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u3059\u3079\u3066Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n WITH [\"\u91ce\u7403\",\"\u30b5\u30c3\u30ab\u30fc\",\"\u30d0\u30ec\u30fc\u30dc\u30fc\u30eb\",\"\u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb\",\"\u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9\",\"\u30e8\u30ac\",\"\u6563\u6b69\",\"\u30c0\u30f3\u30b9\",\"\u305d\u306e\u4ed6\"] AS list WITH [\"\u571f\u65e5\u795d\u65e5\",\"\u5e73\u65e5\",\"\u4e0d\u5b9a\u671f\"] AS list WITH [\"\u805e\u304f\u30bf\u30a4\u30d7\",\"\u8a71\u3059\u30bf\u30a4\u30d7\",\"\u3068\u3061\u3089\u3067\u3082\u826f\u3044\"] AS list WITH [\"\u7a4d\u6975\u7684\",\"\u6d88\u6975\u7684\",\"\u3068\u3061\u3089\u3067\u3082\u306a\u3044\"] AS list WITH [140,150,160,170,180,190,200] as list WITH [\"\u5916\u5411\u7684\",\"\u5185\u5411\u7684\"] AS list WITH [\"\u8aad\u66f8\",\"\u6620\u753b\u611f\u60f3\",\"\u97f3\u697d\u611f\u60f3\",\"TV\u611f\u60f3\",\"\u30b2\u30fc\u30e0\",\"\u5bdd\u308b\",\"\u53cb\u305f\u3061\u3068\u304a\u558b\u308a\",\"\u6599\u7406\u3092\u4f5c\u308b\",\"\u305d\u306e\u4ed6\"] AS list WITH [\"\u5438\u3046\",\"\u5438\u308f\u306a\u3044\"] AS list WITH [\"\u98f2\u3080\",\"\u98f2\u307e\u306a\u3044\"] AS list WITH [\"\u597d\u304d\",\"\u5acc\u3044\"] AS list WITH [\"\u4fe1\u3058\u308b\",\"\u4fe1\u3058\u306a\u3044\"] AS list WITH [\"\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b\",\"\u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044\"] AS list WITH [\"\u6d77\",\"\u5c71\",\"\u5ddd\",\"\u516c\u5712\",\"\u904a\u5712\u5730\",\"\u3069\u3061\u3089\u3067\u3082\u3044\u3044\"] AS list WITH [100,200,300,400,500,600,700,800,900] AS list WITH [\"\u5317\u6d77\u9053\",\"\u9752\u68ee\u770c\",\"\u5ca9\u624b\u770c\",\"\u5bae\u57ce\u770c\",\"\u79cb\u7530\u770c\",\"\u5c71\u5f62\u770c\",\"\u798f\u5cf6\u770c\",\"\u8328\u57ce\u770c\",\"\u6803\u6728\u770c\",\"\u7fa4\u99ac\u770c\",\"\",\"\u57fc\u7389\u770c\",\"\u5343\u8449\u770c\",\"\u6771\u4eac\u90fd\",\"\u795e\u5948\u5ddd\u770c\",\"\u65b0\u6f5f\u770c\",\"\u5bcc\u5c71\u770c\",\"\u77f3\u5ddd\u770c\",\"\u798f\u4e95\u770c\",\"\u5c71\u68a8\u770c\",\"\u9577\u91ce\u770c\",\"\u5c90\u961c\u770c\",\"\u9759\u5ca1\u770c\",\"\u611b\u77e5\u770c\",\"\u4e09\u91cd\u770c\",\"\u6ecb\u8cc0\u770c\",\"\u4eac\u90fd\u5e9c\",\"\u5927\u962a\u5e9c\",\"\u5175\u5eab\u770c\",\"\u5948\u826f\u770c\",\"\u548c\u6b4c\u5c71\u770c\",\"\u9ce5\u53d6\u770c\",\"\u5cf6\u6839\u770c\",\"\u5ca1\u5c71\u770c\",\"\u5e83\u5cf6\u770c\",\"\u5c71\u53e3\u770c\",\"\u5fb3\u5cf6\u770c\",\"\u9999\u5ddd\u770c\",\"\u611b\u5a9b\u770c\",\"\u9ad8\u77e5\u770c\",\"\u798f\u5ca1\u770c\",\"\u4f50\u8cc0\u770c\",\"\u9577\u5d0e\u770c\",\"\u718a\u672c\u770c\",\"\u5927\u5206\u770c\",\"\u5bae\u5d0e\u770c\",\"\u9e7f\u5150\u5cf6\u770c\",\"\u6c96\u7e04\u770c\"] AS list WITH [\"\u6709\u308a\",\"\u7121\u3057\"] AS list WITH [\"\u72ac\u6d3e\",\"\u732b\u6d3e\"] AS list WITH [\"\u7fa9\u52d9\u6559\u80b2\",\"\u9ad8\u7b49\u5b66\u6821\",\"\u5404\u7a2e\u5c02\u9580\u5b66\u6821\",\"\u77ed\u5927\u30fb\u9ad8\u5c02\",\"\u5927\u5b66\",\"\u5927\u5b66\u9662\"] AS list WITH [\"\u516c\u52d9\u54e1\",\"\u4f1a\u793e\u54e1\",\"\u81ea\u55b6\u696d\",\"\u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1\",\"\u6559\u5e2b\",\"\u533b\u5e2b\",\"\u533b\u7642\u95a2\u4fc2\",\"\u4fdd\u80b2\u58eb\",\"\u8fb2\u6797\u30fb\u6f01\u696d\",\"\u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8\",\"\u5b66\u751f\",\"\u5bb6\u4e8b\u624b\u4f1d\",\"\u305d\u306e\u4ed6\"] AS list WITH [1995,1994,1993,1992,1991,1990,1989,1988,1987,1986,1985,1984,1983,1982,1981,1980,1979,1978,1977,1976,1975,1974,1973,1972,1971,1970] AS list \u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3001\u30e9\u30d9\u30eb\u3001\u8981\u7d20\u306e\u96c6\u5408\u3001\u8981\u7d20\u6570\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n MATCH (a:Sport2) RETURN labels(a) AS \u30e9\u30d9\u30eb,collect(a.title) AS \u8981\u7d20,length(collect(a.title)) AS \u6570 UNION ALL \u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u3059\u3079\u3066Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n WITH [\"\u91ce\u7403\",\"\u30b5\u30c3\u30ab\u30fc\",\"\u30d0\u30ec\u30fc\u30dc\u30fc\u30eb\",\"\u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb\",\"\u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9\",\"\u30e8\u30ac\",\"\u6563\u6b69\",\"\u30c0\u30f3\u30b9\",\"\u305d\u306e\u4ed6\"] AS list WITH [\"\u571f\u65e5\u795d\u65e5\",\"\u5e73\u65e5\",\"\u4e0d\u5b9a\u671f\"] AS list WITH [\"\u805e\u304f\u30bf\u30a4\u30d7\",\"\u8a71\u3059\u30bf\u30a4\u30d7\",\"\u3068\u3061\u3089\u3067\u3082\u826f\u3044\"] AS list WITH [\"\u7a4d\u6975\u7684\",\"\u6d88\u6975\u7684\",\"\u3068\u3061\u3089\u3067\u3082\u306a\u3044\"] AS list WITH [140,150,160,170,180,190,200] as list WITH [\"\u5916\u5411\u7684\",\"\u5185\u5411\u7684\"] AS list WITH [\"\u8aad\u66f8\",\"\u6620\u753b\u611f\u60f3\",\"\u97f3\u697d\u611f\u60f3\",\"TV\u611f\u60f3\",\"\u30b2\u30fc\u30e0\",\"\u5bdd\u308b\",\"\u53cb\u305f\u3061\u3068\u304a\u558b\u308a\",\"\u6599\u7406\u3092\u4f5c\u308b\",\"\u305d\u306e\u4ed6\"] AS list WITH [\"\u5438\u3046\",\"\u5438\u308f\u306a\u3044\"] AS list WITH [\"\u98f2\u3080\",\"\u98f2\u307e\u306a\u3044\"] AS list WITH [\"\u597d\u304d\",\"\u5acc\u3044\"] AS list WITH [\"\u4fe1\u3058\u308b\",\"\u4fe1\u3058\u306a\u3044\"] AS list WITH [\"\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b\",\"\u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044\"] AS list WITH [\"\u6d77\",\"\u5c71\",\"\u5ddd\",\"\u516c\u5712\",\"\u904a\u5712\u5730\",\"\u3069\u3061\u3089\u3067\u3082\u3044\u3044\"] AS list WITH [100,200,300,400,500,600,700,800,900] AS list WITH [\"\u6709\u308a\",\"\u7121\u3057\"] AS list WITH [\"\u72ac\u6d3e\",\"\u732b\u6d3e\"] AS list WITH [\"\u7fa9\u52d9\u6559\u80b2\",\"\u9ad8\u7b49\u5b66\u6821\",\"\u5404\u7a2e\u5c02\u9580\u5b66\u6821\",\"\u77ed\u5927\u30fb\u9ad8\u5c02\",\"\u5927\u5b66\",\"\u5927\u5b66\u9662\"] AS list WITH [\"\u516c\u52d9\u54e1\",\"\u4f1a\u793e\u54e1\",\"\u81ea\u55b6\u696d\",\"\u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1\",\"\u6559\u5e2b\",\"\u533b\u5e2b\",\"\u533b\u7642\u95a2\u4fc2\",\"\u4fdd\u80b2\u58eb\",\"\u8fb2\u6797\u30fb\u6f01\u696d\",\"\u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8\",\"\u5b66\u751f\",\"\u5bb6\u4e8b\u624b\u4f1d\",\"\u305d\u306e\u4ed6\"] AS list WITH [1995,1994,1993,1992,1991,1990,1989,1988,1987,1986,1985,1984,1983,1982,1981,1980,1979,1978,1977,1976,1975,1974,1973,1972,1971,1970] AS list \u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3001\u30e9\u30d9\u30eb\u3001\u8981\u7d20\u306e\u96c6\u5408\u3001\u8981\u7d20\u6570\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n MATCH (a:Sport3) RETURN labels(a) AS \u30e9\u30d9\u30eb,collect(a.title) AS \u8981\u7d20,length(collect(a.title)) AS \u6570 UNION ALL \u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u3059\u3079\u3066Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n MATCH \u30b0\u30e9\u30d5\u3092\u30b5\u30f3\u30d7\u30ea\u30f3\u30b0\u3057\u3066\u5b9f\u884c\u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u4ee5\u4e0b\u306f\u6559\u80b2\u6c34\u6e96\u306e\u30b0\u30e9\u30d5\u3067\u3059\u3002<\/p>\n MATCH ()-[r:RE_EDUCATION]->() RETURN r<\/p>\n<\/blockquote>\n \u3057\u304b\u3057\u5927\u91cf\u306e\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3057\u305f\u5834\u5408\u3001\u90fd\u5ea6\u76ee\u8996\u3067\u78ba\u8a8d\u3059\u308b\u3053\u3068\u306f\u56f0\u96e3\u3067\u3059\u3002\u6b21\u306e\u3088\u3046\u306b\u30bf\u30a4\u30d7\u3084\u8981\u7d20\u3001\u6570\u3092\u78ba\u8a8d\u3059\u308bCypher\u30af\u30a8\u30ea\u30fc\u3092\u5229\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n MATCH ()-[a:RE_SPORT]->(aa) RETURN type(a) AS \u30bf\u30a4\u30d7,collect(aa.title) AS \u8981\u7d20,length(collect(aa.title)) AS \u6570 UNION ALL \u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u3059\u3079\u3066Web\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u5165\u529b\u3057\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n MATCH \u5c45\u4f4f\u5730\u57df\u3082\u5fd8\u308c\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n MERGE (man:Person:Man { name : \"M04\"}) \u30b0\u30e9\u30d5\u3092\u30b5\u30f3\u30d7\u30ea\u30f3\u30b0\u3057\u3066\u5b9f\u884c\u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u4ee5\u4e0b\u306f\u3001\u6559\u80b2\u6c34\u6e96\u306e\u30b0\u30e9\u30d5\u3067\u3059\u3002<\/p>\n MATCH ()-[r:FI_EDUCATION]->() RETURN r<\/p>\n<\/blockquote>\n \u6b21\u306eCypher\u30af\u30a8\u30ea\u30fc\u3092\u5229\u7528\u3057\u3066\u30bf\u30a4\u30d7\u3084\u8981\u7d20\u3001\u6570\u3092\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n MATCH ()-[a:FI_BORN]->(aa) RETURN type(a) AS \u30bf\u30a4\u30d7,collect(aa.title) AS \u8981\u7d20,length(collect(aa.title)) AS \u6570 UNION ALL \u6700\u5f8c\u306b\u3001\u5c45\u4f4f\u5730\u57df\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n MATCH (man:Man { name:\"M04\" }) RETURN split(man.filter_location, \"|\") AS list \u3053\u3053\u3067\u3001\u3053\u306e\u9023\u8f09\u3092\u611b\u8aad\u3057\u3066\u3044\u308b\u7686\u69d8\u306b\u3054\u4e86\u627f\u3092\u5f97\u305f\u3044\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u7b2c2\u56de\u76ee\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306eCypher\u30af\u30a8\u30ea\u30fc\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u306e\u8a2d\u5b9a\u306b\u9593\u9055\u3044\u304c\u3042\u308b\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3057\u305f\u3002\u307e\u305a\u3001\u7b2c2\u56de\u76ee\u306eCypher\u30af\u30a8\u30ea\u30fc\u306e\u9593\u9055\u3044\u3092\u76f4\u3057\u3066\u5b9f\u884c\u3057\u3066\u307f\u3066\u304b\u3089\u3001\u4eca\u56de\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u3055\u305b\u3066\u9802\u304d\u307e\u3059\u3002\u7533\u3057\u8a33\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<\/blockquote>\n \u4ee5\u4e0b\u306eCypher\u30af\u30a8\u30ea\u30fc\u304c\u7b2c2\u56de\u76ee\u306e\u9593\u9055\u3044\u3092\u8a02\u6b63\u3057\u305f\u30af\u30a8\u30ea\u30fc\u6587\u3067\u3059\u3002\u4eca\u56de\u306e\u5206\u6790\u3067\u5019\u88dc\u800526\u4eba\u306e\u306a\u304b\u3067M04\u3055\u3093\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u306b\u5408\u3063\u3066\u3044\u308b\u4eba\u306f5\u4eba\u3057\u304b\u5b58\u5728\u3057\u306a\u3044\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3057\u305f\u3002<\/p>\n WITH [\"\u98f2\u3080\",1981,1982,1983,1984,1985,1986,1987,1989,\"\u5927\u5b66\",\"\u77ed\u5927\u30fb\u9ad8\u5c02\",\"\u5927\u5b66\u9662\",\"\u4fe1\u3058\u306a\u3044\",\"\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b\",140,150,160,\"\u571f\u65e5\u795d\u65e5\",100,200,300,400,500,600,700,800,900,\"\u6620\u753b\u611f\u60f3\",\"\u30b2\u30fc\u30e0\",\"\u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8\",\"\u8fb2\u6797\u30fb\u6f01\u696d\",\"\u4fdd\u80b2\u58eb\",\"\u81ea\u55b6\u696d\",\"\u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1\",\"\u6559\u5e2b\",\"\u533b\u5e2b\",\"\u516c\u52d9\u54e1\",\"\u4f1a\u793e\u54e1\",\"\u305d\u306e\u4ed6\",\"\u533b\u7642\u95a2\u4fc2\",\"\u597d\u304d\",\"\u6771\u4eac\u90fd\",\"\u795e\u5948\u5ddd\u770c\",\"\u57fc\u7389\u770c\",\"\u5343\u8449\u770c\",\"\u7121\u3057\",\"\u7a4d\u6975\u7684\",\"\u6d77\",\"\u5ddd\",\"\u5916\u5411\u7684\",\"\u5185\u5411\u7684\",\"\u732b\u6d3e\",\"\u5438\u308f\u306a\u3044\",\"\u30c0\u30f3\u30b9\",\"\u6563\u6b69\",\"\u91ce\u7403\",\"\u30b5\u30c3\u30ab\u30fc\",\"\u30d0\u30ec\u30fc\u30dc\u30fc\u30eb\",\"\u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb\",\"\u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9\",\"\u30e8\u30ac\",\"\u8a71\u3059\u30bf\u30a4\u30d7\"] AS list \u4ee5\u4e0b\u306f\u51fa\u529b\u3055\u308c\u308b\u7d50\u679c\u306e\u4f8b\u3067\u3059\u3002<\/p>\n \n\u540d\u524d \u5171\u901a\u8981\u7d20 \u985e\u4f3c\u6027 \u7b2c2\u56de\u76ee\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306eCypher\u30af\u30a8\u30ea\u30fc\u306e\u9593\u9055\u3044\u306f\u6b21\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n \u30fb\u5fc5\u9808\u6761\u4ef6\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u8981\u7d20\u3092\u5e74\u9f62\u306e\u307f\u306b\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u5b9f\u969b\u306f\u3001\u5e74\u9f62\u3001\u8eab\u9577\u3001\u5b66\u6b74\u3001\u8077\u696d\u3001\u5c45\u4f4f\u5730\u57df\u306e5\u500b\u3067\u3057\u305f\u3002 WHERE NONE ( x IN wlist WHERE x IN list2)<\/p>\n \u4eca\u56de\u306eCypher\u30af\u30a8\u30ea\u30fc\u3067\u306f\u3001\u3059\u3079\u3066\u306e\u30d1\u30bf\u30fc\u30f3\u306e\u53d6\u5f97\u3092Cypher\u30af\u30a8\u30ea\u30fc\u306e\u306a\u304b\u3067\u81ea\u5df1\u5b8c\u7d50\u3057\u3066\u3044\u307e\u3059\u3002\u7b2c2\u56de\u76ee\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u6642\u306eCypher\u30af\u30a8\u30ea\u30fc\u3068\u6bd4\u8f03\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002\u5404\u7a2e\u30ea\u30b9\u30c8\u306e\u8981\u7d20\u304c\u5265\u304d\u51fa\u3057\u306b\u306a\u3063\u3066\u3044\u308b\u7b87\u6240\u304c\u3059\u3079\u3066\u306a\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n MATCH (man:Man{ name:\"M04\"})-[:RE_SPORT|RE_HOLIDAY|RE_TALK|RE_HEIGHT|RE_PERSONALITY|RE_INDOOR|RE_SMOKING|RE_ALCOHOL|RE_KARAOKE|RE_FORTUNETELLING|RE_OUTDOOR|RE_INCOME|RE_BORN|RE_LOCATION|RE_PET|RE_EDUCATION|RE_JOB|RE_MEET|RE_MARITALHISTORY|RE_HEALTHCARE]->(request), \u4ee5\u4e0b\u306e\u3088\u3046\u306a\u7d50\u679c\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n \n\u540d\u524d \u5171\u901a\u8981\u7d20 \u30e9\u30f3\u30af \u3057\u304b\u3057\u306a\u304c\u3089M04\u3055\u3093\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u306b\u5408\u3063\u3066\u3044\u308b\u4eba\u306f5\u4eba\u3057\u304b\u5b58\u5728\u3057\u306a\u3044\u3053\u3068\u306f\u5909\u308f\u308a\u307e\u305b\u3093\u3002\u3082\u3061\u308d\u3093\u3001\u4eca\u56de\u306e\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u767b\u9332\u3057\u3066\u3044\u308b\u5973\u6027\u306e\u4eba\u6570\u304c\u5c11\u306a\u3044\u305f\u3081\u3067\u3059\u304c\u3001\u305d\u308c\u3067\u308226\u4eba\u306e\u306a\u304b\u3067\u306e5\u4eba\u3068\u3044\u3046\u7d50\u679c\u306f\u5c11\u3057\u5bc2\u3057\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u306d\u3002M04\u3055\u3093\u3001\u9811\u5f35\u3063\u3066\u304f\u3060\u3055\u3044\uff01<\/p>\n \u524d\u9805\u306e5\u4eba\u306e\u5019\u88dc\u8005\u306e\u60c5\u5831\u304b\u3089M04\u3055\u3093\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u3068\u4e00\u81f4\u3057\u306a\u3044\u8981\u7d20\u3092\u51fa\u3057\u3066\u307f\u307e\u3059\u3002\u5fc5\u9808\u6761\u4ef6\u3068\u3057\u3066\u306f\u51fa\u3057\u3066\u306a\u3044\u3067\u3059\u304c\u3001\u5185\u5fc3\u3001\u3053\u308c\u3060\u3051\u306fM04\u3055\u3093\u306e\u6c17\u6301\u3061\u3067\u306f\u52d8\u5f01\u3057\u3066\u307b\u3057\u3044\u3068\u601d\u3046\u3053\u3068\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n MATCH (man:Man{ name:\"M04\"})-[:RE_SPORT|RE_HOLIDAY|RE_TALK|RE_HEIGHT|RE_PERSONALITY|RE_INDOOR|RE_SMOKING|RE_ALCOHOL|RE_KARAOKE|RE_FORTUNETELLING|RE_OUTDOOR|RE_INCOME|RE_BORN|RE_LOCATION|RE_PET|RE_EDUCATION|RE_JOB|RE_MEET|RE_MARITALHISTORY|RE_HEALTHCARE]->(request), \u4ee5\u4e0b\u306e\u3088\u3046\u306a\u7d50\u679c\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n \n\u540d\u524d \u5171\u901a\u8981\u7d20 \u985e\u4f3c\u6027 \u4e0d\u4e00\u81f4 \u3053\u308c\u3067\u300c\u5a5a\u6d3b\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u300d\u306e\u9023\u8f09\u306f\u7d42\u4e86\u3055\u305b\u3066\u9802\u304d\u307e\u3059\u3002\u4eca\u56de\u306e\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306f\u3001\u73fe\u5b9f\u306e\u4e16\u754c\u306b\u6709\u308a\u5f97\u308b\u3053\u3068\u3092\u7d20\u6750\u306b\u3057\u3066\u306f\u3044\u307e\u3059\u304c\u3001\u69d8\u3005\u306a\u3053\u3068\u3092\u5358\u7d14\u5316\u3057\u3066\u3044\u307e\u3059\u3002\u4eca\u56de\u306e\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u3084\u51e6\u7406\u65b9\u6cd5\u304c\u3001\u3053\u306e\u3088\u3046\u306a\u30b1\u30fc\u30b9\u306b\u304a\u3051\u308b\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9\u3068\u306f\u601d\u3063\u3066\u304a\u308a\u307e\u305b\u3093\u3002\u3082\u3057\u304a\u6c17\u3065\u304d\u306e\u3068\u3053\u308d\u304c\u3042\u308a\u307e\u3057\u305f\u3089\u662f\u975e\u30b3\u30e1\u30f3\u30c8\u3092\u9802\u3051\u308b\u3068\u5e78\u3044\u3067\u3059\u3002\u3053\u3053\u307e\u3067\u611b\u8aad\u3057\u3066\u9802\u3044\u305f\u65b9\u9054\u306b\u4f55\u304b\u5f79\u306b\u7acb\u3064\u3053\u3068\u304c1\u3064\u3067\u3082\u3042\u3063\u305f\u3068\u3059\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n [\u60c5\u5831\u3068\u60c5\u5831\u306e\u7e4b\u304c\u308a\u306f\u4fa1\u5024\u3067\u3042\u308b] \u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9Neo4j\u306e\u5b9f\u8df5\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306e1\u4f8b\u3092\u7d39\u4ecb\u3059\u308b\u305f\u3081\u306b\u59cb\u3081\u305f\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u3044\u3088\u3044\u3088\u6700\u7d42\u56de\u3092\u8fce\u3048\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30c8\u30e9\u30a4\u30a2\u30eb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9032\u3081\u3066\u3044\u308b\u306a\u304b\u3067\u767a\u751f\u3057\u305f\u554f\u984c\u70b9\u306a\u3069\u306e\u6539\u5584\u7b56\u3092\u76db\u308a\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u30e2 […]<\/p>\n","protected":false},"author":13,"featured_media":12212,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[61,37],"tags":[],"class_list":["post-12205","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lee","category-neo4j"],"acf":[],"yoast_head":"\n\u30ea\u30af\u30a8\u30b9\u30c8\u7528\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3\u306e\u8ffd\u52a0<\/h3>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (a1:Sport2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (b1:Holiday2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (c1:Talk2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (d1:Meeting2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (e1:Height2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (f1:Personality2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (g1:Indoor2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (h1:Smoking2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (j1:Alcohol2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (k1:Karaoke2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (m1:Fortunetelling2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (n1:Healthcare2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (o1:Outdoor2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (p1:Income2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (q1:Location2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (r1:Maritalhistory2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (s1:Pet2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (t1:Education2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (u1:Job2 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (v1:Born2 {title: list[i]}))<\/p><\/blockquote>\n
\nMATCH (b:holiday2) RETURN labels(b) AS \u30e9\u30d9\u30eb, collect(b.title) AS \u8981\u7d20,length(collect(b.title)) AS \u6570 UNION ALL
\nMATCH (c:Talk2) RETURN labels(c) AS \u30e9\u30d9\u30eb, collect(c.title) AS \u8981\u7d20,length(collect(c.title)) AS \u6570 UNION ALL
\nMATCH (d:Height2) RETURN labels(d) AS \u30e9\u30d9\u30eb, collect(d.title) AS \u8981\u7d20,length(collect(d.title)) AS \u6570 UNION ALL
\nMATCH (e:Personality2) RETURN labels(e) AS \u30e9\u30d9\u30eb, collect(e.title) AS \u8981\u7d20,length(collect(e.title)) AS \u6570 UNION ALL
\nMATCH (f:Indoor2) RETURN labels(f) AS \u30e9\u30d9\u30eb, collect(f.title) AS \u8981\u7d20,length(collect(f.title)) AS \u6570 UNION ALL
\nMATCH (g:Smoking2) RETURN labels(g) AS \u30e9\u30d9\u30eb, collect(g.title) AS \u8981\u7d20,length(collect(g.title)) AS \u6570 UNION ALL
\nMATCH (h:Alcohol2) RETURN labels(h) AS \u30e9\u30d9\u30eb, collect(h.title) AS \u8981\u7d20,length(collect(h.title)) AS \u6570 UNION ALL
\nMATCH (i:Karaoke2) RETURN labels(i) AS \u30e9\u30d9\u30eb, collect(i.title) AS \u8981\u7d20,length(collect(i.title)) AS \u6570 UNION ALL
\nMATCH (j:Fortunetelling2) RETURN labels(j) AS \u30e9\u30d9\u30eb, collect(j.title) AS \u8981\u7d20,length(collect(j.title)) AS \u6570 UNION ALL
\nMATCH (k:Outdoor2) RETURN labels(k) AS \u30e9\u30d9\u30eb, collect(k.title) AS \u8981\u7d20,length(collect(k.title)) AS \u6570 UNION ALL
\nMATCH (l:Income2) RETURN labels(l) AS \u30e9\u30d9\u30eb, collect(l.title) AS \u8981\u7d20,length(collect(l.title)) AS \u6570 UNION ALL
\nMATCH (m:Born2) RETURN labels(m) AS \u30e9\u30d9\u30eb, collect(m.title) AS \u8981\u7d20,length(collect(m.title)) AS \u6570 UNION ALL
\nMATCH (n:Location2) RETURN labels(n) AS \u30e9\u30d9\u30eb, collect(n.title) AS \u8981\u7d20,length(collect(n.title)) AS \u6570 UNION ALL
\nMATCH (o:Pet2) RETURN labels(o) AS \u30e9\u30d9\u30eb, collect(o.title) AS \u8981\u7d20,length(collect(o.title)) AS \u6570 UNION ALL
\nMATCH (p:Education2) RETURN labels(p) AS \u30e9\u30d9\u30eb, collect(p.title) AS \u8981\u7d20,length(collect(p.title)) AS \u6570 UNION ALL
\nMATCH (q:Job2) RETURN labels(q) AS \u30e9\u30d9\u30eb, collect(q.title) AS \u8981\u7d20,length(collect(q.title)) AS \u6570 UNION ALL
\nMATCH (r:Meet2) RETURN labels(r) AS \u30e9\u30d9\u30eb, collect(r.title) AS \u8981\u7d20,length(collect(r.title)) AS \u6570 UNION ALL
\nMATCH (s:Marriage2) RETURN labels(s) AS \u30e9\u30d9\u30eb, collect(s.title) AS \u8981\u7d20,length(collect(s.title)) AS \u6570 UNION ALL
\nMATCH (t:Healthcare2) RETURN labels(t) AS \u30e9\u30d9\u30eb, collect(t.title) AS \u8981\u7d20,length(collect(t.title)) AS \u6570
\n\u30e9\u30d9\u30eb \u8981\u7d20 \u6570
\n[Sport2] [\u91ce\u7403, \u30b5\u30c3\u30ab\u30fc, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb, \u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9, \u30e8\u30ac, \u6563\u6b69, \u30c0\u30f3\u30b9, \u305d\u306e\u4ed6] 9
\n[Talk2] [\u805e\u304f\u30bf\u30a4\u30d7, \u8a71\u3059\u30bf\u30a4\u30d7, \u3068\u3061\u3089\u3067\u3082\u826f\u3044] 3
\n[Height2] [140, 150, 160, 170, 180, 190, 200] 7
\n[Personality2] [\u5916\u5411\u7684, \u5185\u5411\u7684] 2
\n[Indoor2] [\u8aad\u66f8, \u6620\u753b\u611f\u60f3, \u97f3\u697d\u611f\u60f3, TV\u611f\u60f3, \u30b2\u30fc\u30e0, \u5bdd\u308b, \u53cb\u305f\u3061\u3068\u304a\u558b\u308a, \u6599\u7406\u3092\u4f5c\u308b, \u305d\u306e\u4ed6] 9
\n[Smoking2] [\u5438\u3046, \u5438\u308f\u306a\u3044] 2
\n[Alcohol2] [\u98f2\u3080, \u98f2\u307e\u306a\u3044] 2
\n[Karaoke2] [\u597d\u304d, \u5acc\u3044] 2
\n[Fortunetelling2] [\u4fe1\u3058\u308b, \u4fe1\u3058\u306a\u3044] 2
\n[Outdoor2] [\u6d77, \u5c71, \u5ddd, \u516c\u5712, \u904a\u5712\u5730, \u3069\u3061\u3089\u3067\u3082\u3044\u3044] 6
\n[Income2] [100, 200, 300, 400, 500, 600, 700, 800, 900] 9
\n[Born2] [1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970] 26
\n[Location2] [\u5317\u6d77\u9053, \u9752\u68ee\u770c, \u5ca9\u624b\u770c, \u5bae\u57ce\u770c, \u79cb\u7530\u770c, \u5c71\u5f62\u770c, \u798f\u5cf6\u770c, \u8328\u57ce\u770c, \u6803\u6728\u770c, \u7fa4\u99ac\u770c, (empty), \u57fc\u7389\u770c, \u5343\u8449\u770c, \u6771\u4eac\u90fd, \u795e\u5948\u5ddd\u770c, \u65b0\u6f5f\u770c, \u5bcc\u5c71\u770c, \u77f3\u5ddd\u770c, \u798f\u4e95\u770c, \u5c71\u68a8\u770c, \u9577\u91ce\u770c, \u5c90\u961c\u770c, \u9759\u5ca1\u770c, \u611b\u77e5\u770c, \u4e09\u91cd\u770c, \u6ecb\u8cc0\u770c, \u4eac\u90fd\u5e9c, \u5927\u962a\u5e9c, \u5175\u5eab\u770c, \u5948\u826f\u770c, \u548c\u6b4c\u5c71\u770c, \u9ce5\u53d6\u770c, \u5cf6\u6839\u770c, \u5ca1\u5c71\u770c, \u5e83\u5cf6\u770c, \u5c71\u53e3\u770c, \u5fb3\u5cf6\u770c, \u9999\u5ddd\u770c, \u611b\u5a9b\u770c, \u9ad8\u77e5\u770c, \u798f\u5ca1\u770c, \u4f50\u8cc0\u770c, \u9577\u5d0e\u770c, \u718a\u672c\u770c, \u5927\u5206\u770c, \u5bae\u5d0e\u770c, \u9e7f\u5150\u5cf6\u770c, \u6c96\u7e04\u770c] 48
\n[Pet2] [\u72ac\u6d3e, \u732b\u6d3e] 2
\n[Education2] [\u7fa9\u52d9\u6559\u80b2, \u9ad8\u7b49\u5b66\u6821, \u5404\u7a2e\u5c02\u9580\u5b66\u6821, \u77ed\u5927\u30fb\u9ad8\u5c02, \u5927\u5b66, \u5927\u5b66\u9662] 6
\n[Job2] [\u516c\u52d9\u54e1, \u4f1a\u793e\u54e1, \u81ea\u55b6\u696d, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u6559\u5e2b, \u533b\u5e2b, \u533b\u7642\u95a2\u4fc2, \u4fdd\u80b2\u58eb, \u8fb2\u6797\u30fb\u6f01\u696d, \u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8, \u5b66\u751f, \u5bb6\u4e8b\u624b\u4f1d, \u305d\u306e\u4ed6] 13
\n[Healthcare2] [\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, \u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044] 2<\/p><\/blockquote>\n\u5fc5\u9808\u8981\u7d20\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u7528\u306e\u30b5\u30d6\u30c9\u30e1\u30a4\u30f3\u306e\u8ffd\u52a0<\/h3>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (a1:Sport3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (b1:Holiday3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (c1:Talk3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (d1:Meeting3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (e1:Height3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (f1:Personality3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (g1:Indoor3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (h1:Smoking3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (j1:Alcohol3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (k1:Karaoke3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (m1:Fortunetelling3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (n1:Healthcare3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (o1:Outdoor3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (p1:Income3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (r1:Maritalhistory3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (s1:Pet3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (t1:Education3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (u1:Job3 {title: list[i]}))<\/p>\n
\nFOREACH(i IN range(0, length(list)-1) |
\nCREATE (v1:Born3 {title: list[i]}))<\/p><\/blockquote>\n
\nMATCH (b:holiday3) RETURN labels(b) AS \u30e9\u30d9\u30eb, collect(b.title) AS \u8981\u7d20,length(collect(b.title)) AS \u6570 UNION ALL
\nMATCH (c:Talk3) RETURN labels(c) AS \u30e9\u30d9\u30eb, collect(c.title) AS \u8981\u7d20,length(collect(c.title)) AS \u6570 UNION ALL
\nMATCH (d:Height3) RETURN labels(d) AS \u30e9\u30d9\u30eb, collect(d.title) AS \u8981\u7d20,length(collect(d.title)) AS \u6570 UNION ALL
\nMATCH (e:Personality3) RETURN labels(e) AS \u30e9\u30d9\u30eb, collect(e.title) AS \u8981\u7d20,length(collect(e.title)) AS \u6570 UNION ALL
\nMATCH (f:Indoor3) RETURN labels(f) AS \u30e9\u30d9\u30eb, collect(f.title) AS \u8981\u7d20,length(collect(f.title)) AS \u6570 UNION ALL
\nMATCH (g:Smoking3) RETURN labels(g) AS \u30e9\u30d9\u30eb, collect(g.title) AS \u8981\u7d20,length(collect(g.title)) AS \u6570 UNION ALL
\nMATCH (h:Alcohol3) RETURN labels(h) AS \u30e9\u30d9\u30eb, collect(h.title) AS \u8981\u7d20,length(collect(h.title)) AS \u6570 UNION ALL
\nMATCH (i:Karaoke3) RETURN labels(i) AS \u30e9\u30d9\u30eb, collect(i.title) AS \u8981\u7d20,length(collect(i.title)) AS \u6570 UNION ALL
\nMATCH (j:Fortunetelling3) RETURN labels(j) AS \u30e9\u30d9\u30eb, collect(j.title) AS \u8981\u7d20,length(collect(j.title)) AS \u6570 UNION ALL
\nMATCH (k:Outdoor3) RETURN labels(k) AS \u30e9\u30d9\u30eb, collect(k.title) AS \u8981\u7d20,length(collect(k.title)) AS \u6570 UNION ALL
\nMATCH (l:Income3) RETURN labels(l) AS \u30e9\u30d9\u30eb, collect(l.title) AS \u8981\u7d20,length(collect(l.title)) AS \u6570 UNION ALL
\nMATCH (m:Born3) RETURN labels(m) AS \u30e9\u30d9\u30eb, collect(m.title) AS \u8981\u7d20,length(collect(m.title)) AS \u6570 UNION ALL
\nMATCH (o:Pet3) RETURN labels(o) AS \u30e9\u30d9\u30eb, collect(o.title) AS \u8981\u7d20,length(collect(o.title)) AS \u6570 UNION ALL
\nMATCH (p:Education3) RETURN labels(p) AS \u30e9\u30d9\u30eb, collect(p.title) AS \u8981\u7d20,length(collect(p.title)) AS \u6570 UNION ALL
\nMATCH (q:Job3) RETURN labels(q) AS \u30e9\u30d9\u30eb, collect(q.title) AS \u8981\u7d20,length(collect(q.title)) AS \u6570 UNION ALL
\nMATCH (r:Meet3) RETURN labels(r) AS \u30e9\u30d9\u30eb, collect(r.title) AS \u8981\u7d20,length(collect(r.title)) AS \u6570 UNION ALL
\nMATCH (s:Marriage3) RETURN labels(s) AS \u30e9\u30d9\u30eb, collect(s.title) AS \u8981\u7d20,length(collect(s.title)) AS \u6570 UNION ALL
\nMATCH (t:Healthcare3) RETURN labels(t) AS \u30e9\u30d9\u30eb, collect(t.title) AS \u8981\u7d20,length(collect(t.title)) AS \u6570
\n\u30e9\u30d9\u30eb \u8981\u7d20 \u6570
\n[Sport3] [\u91ce\u7403, \u30b5\u30c3\u30ab\u30fc, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb, \u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9, \u30e8\u30ac, \u6563\u6b69, \u30c0\u30f3\u30b9, \u305d\u306e\u4ed6] 9
\n[Talk3] [\u805e\u304f\u30bf\u30a4\u30d7, \u8a71\u3059\u30bf\u30a4\u30d7, \u3068\u3061\u3089\u3067\u3082\u826f\u3044] 3
\n[Height3] [140, 150, 160, 170, 180, 190, 200] 7
\n[Personality3] [\u5916\u5411\u7684, \u5185\u5411\u7684] 2
\n[Indoor3] [\u8aad\u66f8, \u6620\u753b\u611f\u60f3, \u97f3\u697d\u611f\u60f3, TV\u611f\u60f3, \u30b2\u30fc\u30e0, \u5bdd\u308b, \u53cb\u305f\u3061\u3068\u304a\u558b\u308a, \u6599\u7406\u3092\u4f5c\u308b, \u305d\u306e\u4ed6] 9
\n[Smoking3] [\u5438\u3046, \u5438\u308f\u306a\u3044] 2
\n[Alcohol3] [\u98f2\u3080, \u98f2\u307e\u306a\u3044] 2
\n[Karaoke3] [\u597d\u304d, \u5acc\u3044] 2
\n[Fortunetelling3] [\u4fe1\u3058\u308b, \u4fe1\u3058\u306a\u3044] 2
\n[Outdoor3] [\u6d77, \u5c71, \u5ddd, \u516c\u5712, \u904a\u5712\u5730, \u3069\u3061\u3089\u3067\u3082\u3044\u3044] 6
\n[Income3] [100, 200, 300, 400, 500, 600, 700, 800, 900] 9
\n[Born3] [1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970] 26
\n[Pet3] [\u72ac\u6d3e, \u732b\u6d3e] 2
\n[Education3] [\u7fa9\u52d9\u6559\u80b2, \u9ad8\u7b49\u5b66\u6821, \u5404\u7a2e\u5c02\u9580\u5b66\u6821, \u77ed\u5927\u30fb\u9ad8\u5c02, \u5927\u5b66, \u5927\u5b66\u9662] 6
\n[Job3] [\u516c\u52d9\u54e1, \u4f1a\u793e\u54e1, \u81ea\u55b6\u696d, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u6559\u5e2b, \u533b\u5e2b, \u533b\u7642\u95a2\u4fc2, \u4fdd\u80b2\u58eb, \u8fb2\u6797\u30fb\u6f01\u696d, \u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8, \u5b66\u751f, \u5bb6\u4e8b\u624b\u4f1d, \u305d\u306e\u4ed6] 13
\n[Healthcare3] [\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, \u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044] 2<\/p><\/blockquote>\n\u30ea\u30af\u30a8\u30b9\u30c8\u7528\u306e\u95a2\u4fc2\u6027\u306e\u4f5c\u6210<\/h3>\n
\n
\n(man:Man { name: \"M04\"}),
\n(a1:Alcohol2 { title: \"\u98f2\u3080\" }),
\n(a2:Born2 { title: 1981 }),
\n(b2:Born2 { title: 1982 }),
\n(c2:Born2 { title: 1983 }),
\n(d2:Born2 { title: 1984 }),
\n(e2:Born2 { title: 1985 }),
\n(f2:Born2 { title: 1986 }),
\n(g2:Born2 { title: 1987 }),
\n(h2:Born2 { title: 1988 }),
\n(i2:Born2 { title: 1989 }),
\n(a3:Education2 { title: \"\u77ed\u5927\u30fb\u9ad8\u5c02\" }),
\n(b3:Education2 { title: \"\u5927\u5b66\" }),
\n(c3:Education2 { title: \"\u5927\u5b66\u9662\" }),
\n(a4:Fortunetelling2 { title: \"\u4fe1\u3058\u306a\u3044\" }),
\n(a5:Healthcare2 { title: \"\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b\" }),
\n(a6:Height2 { title : 140 }),
\n(b6:Height2 { title : 150 }),
\n(c6:Height2 { title : 160 }),
\n(a7:Holiday2 { title : \"\u571f\u65e5\u795d\u65e5\" }),
\n(a8:Income2 { title : 100 }),
\n(b8:Income2 { title : 200 }),
\n(c8:Income2 { title : 300 }),
\n(d8:Income2 { title : 400 }),
\n(e8:Income2 { title : 500 }),
\n(f8:Income2 { title : 600 }),
\n(g8:Income2 { title : 700 }),
\n(h8:Income2 { title : 800 }),
\n(i8:Income2 { title : 900 }),
\n(a9:Indoor2 { title : \"\u6620\u753b\u611f\u60f3\" }),
\n(b9:Indoor2 { title : \"\u30b2\u30fc\u30e0\" }),
\n(a10:Job2 { title : \"\u516c\u52d9\u54e1\" }),
\n(b10:Job2 { title : \"\u4f1a\u793e\u54e1\" }),
\n(c10:Job2 { title : \"\u81ea\u55b6\u696d\" }),
\n(d10:Job2 { title : \"\u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1\" }),
\n(e10:Job2 { title : \"\u6559\u5e2b\" }),
\n(f10:Job2 { title : \"\u533b\u5e2b\" }),
\n(g10:Job2 { title : \"\u533b\u7642\u95a2\u4fc2\" }),
\n(h10:Job2 { title : \"\u4fdd\u80b2\u58eb\" }),
\n(i10:Job2 { title : \"\u8fb2\u6797\u30fb\u6f01\u696d\" }),
\n(j10:Job2 { title : \"\u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8\" }),
\n(k10:Job2 { title : \"\u305d\u306e\u4ed6\" }),
\n(a11:Karaoke2 { title : \"\u597d\u304d\" }),
\n(a12:Location2 { title : \"\u57fc\u7389\u770c\" }),
\n(b12:Location2 { title : \"\u5343\u8449\u770c\" }),
\n(c12:Location2 { title : \"\u6771\u4eac\u90fd\" }),
\n(d12:Location2 { title : \"\u795e\u5948\u5ddd\u770c\" }),
\n(a13:Maritalhistory2 { title : \"\u7121\u3057\" }),
\n(a14:Meeting2 { title : \"\u7a4d\u6975\u7684\" }),
\n(a15:Outdoor2 { title : \"\u6d77\" }),
\n(b15:Outdoor2 { title : \"\u5ddd\" }),
\n(a16:Personality2 { title : \"\u5916\u5411\u7684\" }),
\n(b16:Personality2 { title : \"\u5185\u5411\u7684\" }),
\n(a17:Pet2 { title : \"\u732b\u6d3e\" }),
\n(a18:Smoking2 { title : \"\u5438\u308f\u306a\u3044\" }),
\n(a19:Sport2 { title : \"\u91ce\u7403\" }),
\n(b19:Sport2 { title : \"\u30b5\u30c3\u30ab\u30fc\" }),
\n(c19:Sport2 { title : \"\u30d0\u30ec\u30fc\u30dc\u30fc\u30eb\" }),
\n(d19:Sport2 { title : \"\u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb\" }),
\n(e19:Sport2 { title : \"\u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9\" }),
\n(f19:Sport2 { title : \"\u30e8\u30ac\" }),
\n(g19:Sport2 { title : \"\u6563\u6b69\" }),
\n(h19:Sport2 { title : \"\u30c0\u30f3\u30b9\" }),
\n(i19:Sport2 { title : \"\u305d\u306e\u4ed6\" }),
\n(a20:Talk2 { title : \"\u8a71\u3059\u30bf\u30a4\u30d7\" })
\n\/\/RETURN *
\nCREATE
\nman-[:RE_ALCOHOL]->a1,
\nman-[:RE_BORN]->a2,
\nman-[:RE_BORN]->b2,
\nman-[:RE_BORN]->c2,
\nman-[:RE_BORN]->d2,
\nman-[:RE_BORN]->e2,
\nman-[:RE_BORN]->f2,
\nman-[:RE_BORN]->g2,
\nman-[:RE_BORN]->h2,
\nman-[:RE_BORN]->i2,
\nman-[:RE_EDUCATION]->a3,
\nman-[:RE_EDUCATION]->b3,
\nman-[:RE_EDUCATION]->c3,
\nman-[:RE_FORTUNETELLING]->a4,
\nman-[:RE_HEALTHCARE]->a5,
\nman-[:RE_HEIGHT]->a6,
\nman-[:RE_HEIGHT]->b6,
\nman-[:RE_HEIGHT]->c6,
\nman-[:RE_HOLIDAY]->a7,
\nman-[:RE_INCOME]->a8,
\nman-[:RE_INCOME]->b8,
\nman-[:RE_INCOME]->c8,
\nman-[:RE_INCOME]->d8,
\nman-[:RE_INCOME]->e8,
\nman-[:RE_INCOME]->f8,
\nman-[:RE_INCOME]->g8,
\nman-[:RE_INCOME]->h8,
\nman-[:RE_INCOME]->i8,
\nman-[:RE_INDOOR]->a9,
\nman-[:RE_INDOOR]->b9,
\nman-[:RE_JOB]->a10,
\nman-[:RE_JOB]->b10,
\nman-[:RE_JOB]->c10,
\nman-[:RE_JOB]->d10,
\nman-[:RE_JOB]->e10,
\nman-[:RE_JOB]->f10,
\nman-[:RE_JOB]->g10,
\nman-[:RE_JOB]->h10,
\nman-[:RE_JOB]->i10,
\nman-[:RE_JOB]->j10,
\nman-[:RE_JOB]->k10,
\nman-[:RE_KARAOKE]->a11,
\nman-[:RE_LOCATION]->a12,
\nman-[:RE_LOCATION]->b12,
\nman-[:RE_LOCATION]->c12,
\nman-[:RE_LOCATION]->d12,
\nman-[:RE_MARITALHISTORY]->a13,
\nman-[:RE_MEET]->a14,
\nman-[:RE_OUTDOOR]->a15,
\nman-[:RE_OUTDOOR]->b15,
\nman-[:RE_PERSONALITY]->a16,
\nman-[:RE_PERSONALITY]->b16,
\nman-[:RE_PET]->a17,
\nman-[:RE_SMOKING]->a18,
\nman-[:RE_SPORT]->a19,
\nman-[:RE_SPORT]->b19,
\nman-[:RE_SPORT]->c19,
\nman-[:RE_SPORT]->d19,
\nman-[:RE_SPORT]->e19,
\nman-[:RE_SPORT]->f19,
\nman-[:RE_SPORT]->g19,
\nman-[:RE_SPORT]->h19,
\nman-[:RE_SPORT]->i19,
\nman-[:RE_TALK]->a20<\/p>\n<\/blockquote>\n\n
<\/p>\n\n
\nMATCH ()-[b:RE_HOLIDAY]->(bb) RETURN type(b) AS \u30bf\u30a4\u30d7,collect(bb.title) AS \u8981\u7d20,length(collect(bb.title)) AS \u6570 UNION ALL
\nMATCH ()-[c:RE_TALK]->(cc) RETURN type(c) AS \u30bf\u30a4\u30d7,collect(cc.title) AS \u8981\u7d20,length(collect(cc.title)) AS \u6570 UNION ALL
\nMATCH ()-[d:RE_HEIGHT]->(dd) RETURN type(d) AS \u30bf\u30a4\u30d7,collect(dd.title) AS \u8981\u7d20,length(collect(dd.title)) AS \u6570 UNION ALL
\nMATCH ()-[e:RE_PERSONALITY]->(ee) RETURN type(e) AS \u30bf\u30a4\u30d7,collect(ee.title) AS \u8981\u7d20,length(collect(ee.title)) AS \u6570 UNION ALL
\nMATCH ()-[f:RE_INDOOR]->(ff) RETURN type(f) AS \u30bf\u30a4\u30d7,collect(ff.title) AS \u8981\u7d20,length(collect(ff.title)) AS \u6570 UNION ALL
\nMATCH ()-[g:RE_SMOKING]->(gg) RETURN type(g) AS \u30bf\u30a4\u30d7,collect(gg.title) AS \u8981\u7d20,length(collect(gg.title)) AS \u6570 UNION ALL
\nMATCH ()-[h:RE_ALCOHOL]->(hh) RETURN type(h) AS \u30bf\u30a4\u30d7,collect(hh.title) AS \u8981\u7d20,length(collect(hh.title)) AS \u6570 UNION ALL
\nMATCH ()-[i:RE_KARAOKE]->(ii) RETURN type(i) AS \u30bf\u30a4\u30d7,collect(ii.title) AS \u8981\u7d20,length(collect(ii.title)) AS \u6570 UNION ALL
\nMATCH ()-[j:RE_FORTUNETELLING]->(jj) RETURN type(j) AS \u30bf\u30a4\u30d7,collect(jj.title) AS \u8981\u7d20,length(collect(jj.title)) AS \u6570 UNION ALL
\nMATCH ()-[k:RE_OUTDOOR]->(kk) RETURN type(k) AS \u30bf\u30a4\u30d7,collect(kk.title) AS \u8981\u7d20,length(collect(kk.title)) AS \u6570 UNION ALL
\nMATCH ()-[l:RE_INCOME]->(ll) RETURN type(l) AS \u30bf\u30a4\u30d7,collect(ll.title) AS \u8981\u7d20,length(collect(ll.title)) AS \u6570 UNION ALL
\nMATCH ()-[m:RE_BORN]->(mm) RETURN type(m) AS \u30bf\u30a4\u30d7,collect(mm.title) AS \u8981\u7d20,length(collect(mm.title)) AS \u6570 UNION ALL
\nMATCH ()-[n:RE_LOCATION]->(nn) RETURN type(n) AS \u30bf\u30a4\u30d7,collect(nn.title) AS \u8981\u7d20,length(collect(nn.title)) AS \u6570 UNION ALL
\nMATCH ()-[o:RE_PET]->(oo) RETURN type(o) AS \u30bf\u30a4\u30d7,collect(oo.title) AS \u8981\u7d20,length(collect(oo.title)) AS \u6570 UNION ALL
\nMATCH ()-[p:RE_EDUCATION]->(pp) RETURN type(p) AS \u30bf\u30a4\u30d7,collect(pp.title) AS \u8981\u7d20,length(collect(pp.title)) AS \u6570 UNION ALL
\nMATCH ()-[q:RE_JOB]->(qq) RETURN type(q) AS \u30bf\u30a4\u30d7,collect(qq.title) AS \u8981\u7d20,length(collect(qq.title)) AS \u6570 UNION ALL
\nMATCH ()-[r:RE_MEET]->(rr) RETURN type(r) AS \u30bf\u30a4\u30d7,collect(rr.title) AS \u8981\u7d20,length(collect(rr.title)) AS \u6570 UNION ALL
\nMATCH ()-[s:RE_MARRIAGE]->(ss) RETURN type(s) AS \u30bf\u30a4\u30d7,collect(ss.title) AS \u8981\u7d20,length(collect(ss.title)) AS \u6570 UNION ALL
\nMATCH ()-[t:RE_HEALTHCARE]->(tt) RETURN type(t) AS \u30bf\u30a4\u30d7,collect(tt.title) AS \u8981\u7d20,length(collect(tt.title)) AS \u6570
\n\u30bf\u30a4\u30d7 \u8981\u7d20 \u6570
\nRE_SPORT [\u91ce\u7403, \u30b5\u30c3\u30ab\u30fc, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb, \u30c6\u30fc\u30d6\u30eb\u30c6\u30cb\u30b9, \u30e8\u30ac, \u6563\u6b69, \u30c0\u30f3\u30b9, \u305d\u306e\u4ed6] 9
\nRE_HOLIDAY [\u571f\u65e5\u795d\u65e5] 1
\nRE_TALK [\u8a71\u3059\u30bf\u30a4\u30d7] 1
\nRE_HEIGHT [160, 150, 140] 3
\nRE_PERSONALITY [\u5916\u5411\u7684, \u5185\u5411\u7684] 2
\nRE_INDOOR [\u6620\u753b\u611f\u60f3, \u30b2\u30fc\u30e0] 2
\nRE_SMOKING [\u5438\u308f\u306a\u3044] 1
\nRE_ALCOHOL [\u98f2\u3080] 1
\nRE_KARAOKE [\u597d\u304d] 1
\nRE_FORTUNETELLING [\u4fe1\u3058\u306a\u3044] 1
\nRE_OUTDOOR [\u6d77, \u5ddd] 2
\nRE_INCOME [100, 200, 300, 400, 500, 600, 700, 800, 900] 9
\nRE_BORN [1989, 1988, 1985, 1984, 1987, 1986, 1981, 1983, 1982] 9
\nRE_LOCATION [\u6771\u4eac\u90fd, \u795e\u5948\u5ddd\u770c, \u57fc\u7389\u770c, \u5343\u8449\u770c] 4
\nRE_PET [\u732b\u6d3e] 1
\nRE_EDUCATION [\u77ed\u5927\u30fb\u9ad8\u5c02, \u5927\u5b66, \u5927\u5b66\u9662] 3
\nRE_JOB [\u516c\u52d9\u54e1, \u4f1a\u793e\u54e1, \u81ea\u55b6\u696d, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u6559\u5e2b, \u533b\u5e2b, \u533b\u7642\u95a2\u4fc2, \u4fdd\u80b2\u58eb, \u8fb2\u6797\u30fb\u6f01\u696d, \u30d1\u30fc\u30c8\u30fb\u30a2\u30eb\u30d0\u30a4\u30c8, \u305d\u306e\u4ed6] 11
\nRE_HEALTHCARE [\u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b] 1<\/p>\n<\/blockquote>\n\u5fc5\u9808\u8981\u7d20\u30d5\u30a3\u30eb\u30bf\u30fc\u6761\u4ef6\u7528\u306e\u95a2\u4fc2\u6027\u306e\u4f5c\u6210<\/h3>\n
\n
\n(man:Man { name:\"M04\"}),
\n(a1:Born3 { title: 1970 }),
\n(b1:Born3 { title: 1971 }),
\n(c1:Born3 { title: 1972 }),
\n(d1:Born3 { title: 1973 }),
\n(e1:Born3 { title: 1974 }),
\n(f1:Born3 { title: 1975 }),
\n(g1:Born3 { title: 1976 }),
\n(h1:Born3 { title: 1977 }),
\n(i1:Born3 { title: 1978 }),
\n(j1:Born3 { title: 1979 }),
\n(k1:Born3 { title: 1980 }),
\n(l1:Born3 { title: 1990 }),
\n(m1:Born3 { title: 1991}),
\n(n1:Born3 { title: 1992}),
\n(o1:Born3 { title: 1993}),
\n(p1:Born3 { title: 1994}),
\n(q1:Born3 { title: 1995}),
\n(a3:Education3 { title: \"\u7fa9\u52d9\u6559\u80b2\" }),
\n(b3:Education3 { title: \"\u9ad8\u7b49\u5b66\u6821\" }),
\n(c3:Education3 { title: \"\u5404\u7a2e\u5c02\u9580\u5b66\u6821\" }),
\n(a4:Height3 { title: 170 }),
\n(b4:Height3 { title: 180 }),
\n(c4:Height3 { title: 190 }),
\n(d4:Height3 { title: 200 }),
\n(a5:Job3 { title: \"\u5bb6\u4e8b\u624b\u4f1d\" }),
\n(b5:Job3 { title: \"\u5b66\u751f\" })
\n\/\/RETURN *
\nCREATE
\nman-[:FI_BORN]->a1,
\nman-[:FI_BORN]->b1,
\nman-[:FI_BORN]->c1,
\nman-[:FI_BORN]->d1,
\nman-[:FI_BORN]->e1,
\nman-[:FI_BORN]->f1,
\nman-[:FI_BORN]->g1,
\nman-[:FI_BORN]->h1,
\nman-[:FI_BORN]->i1,
\nman-[:FI_BORN]->j1,
\nman-[:FI_BORN]->k1,
\nman-[:FI_BORN]->l1,
\nman-[:FI_BORN]->m1,
\nman-[:FI_BORN]->n1,
\nman-[:FI_BORN]->o1,
\nman-[:FI_BORN]->p1,
\nman-[:FI_BORN]->q1,
\nman-[:FI_EDUCATION]->a3,
\nman-[:FI_EDUCATION]->b3,
\nman-[:FI_EDUCATION]->c3,
\nman-[:FI_HEIGHT]->a4,
\nman-[:FI_HEIGHT]->b4,
\nman-[:FI_HEIGHT]->c4,
\nman-[:FI_HEIGHT]->d4,
\nman-[:FI_JOB]->a5,
\nman-[:FI_JOB]->b5<\/p>\n<\/blockquote>\n\n
\nON MATCH SET man.filter_location=\"\u5317\u6d77\u9053|\u9752\u68ee\u770c|\u5ca9\u624b\u770c|\u5bae\u57ce\u770c|\u79cb\u7530\u770c|\u5c71\u5f62\u770c|\u798f\u5cf6\u770c|\u8328\u57ce\u770c|\u6803\u6728\u770c|\u7fa4\u99ac\u770c|\u65b0\u6f5f\u770c|\u5bcc\u5c71\u770c|\u77f3\u5ddd\u770c|\u798f\u4e95\u770c|\u5c71\u68a8\u770c|\u9577\u91ce\u770c|\u5c90\u961c\u770c|\u9759\u5ca1\u770c|\u611b\u77e5\u770c|\u4e09\u91cd\u770c|\u6ecb\u8cc0\u770c|\u4eac\u90fd\u5e9c|\u5927\u962a\u5e9c|\u5175\u5eab\u770c|\u5948\u826f\u770c|\u548c\u6b4c\u5c71\u770c|\u9ce5\u53d6\u770c|\u5cf6\u6839\u770c|\u5ca1\u5c71\u770c|\u5e83\u5cf6\u770c|\u5c71\u53e3\u770c|\u5fb3\u5cf6\u770c|\u9999\u5ddd\u770c|\u611b\u5a9b\u770c|\u9ad8\u77e5\u770c|\u798f\u5ca1\u770c|\u4f50\u8cc0\u770c|\u9577\u5d0e\u770c|\u718a\u672c\u770c|\u5927\u5206\u770c|\u5bae\u5d0e\u770c|\u9e7f\u5150\u5cf6\u770c|\u6c96\u7e04\u770c\"<\/p>\n<\/blockquote>\n\n
<\/p>\n\n
\nMATCH ()-[b:FI_EDUCATION]->(bb) RETURN type(b) AS \u30bf\u30a4\u30d7,collect(bb.title) AS \u8981\u7d20,length(collect(bb.title)) AS \u6570 UNION ALL
\nMATCH ()-[c:FI_HEIGHT]->(cc) RETURN type(c) AS \u30bf\u30a4\u30d7,collect(cc.title) AS \u8981\u7d20,length(collect(cc.title)) AS \u6570 UNION ALL
\nMATCH ()-[d:FI_JOB]->(dd) RETURN type(d) AS \u30bf\u30a4\u30d7,collect(dd.title) AS \u8981\u7d20,length(collect(dd.title)) AS \u6570
\n\u30bf\u30a4\u30d7 \u8981\u7d20 \u6570
\nFI_BORN [1995, 1994, 1993, 1992, 1991, 1990, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970] 17
\nFI_EDUCATION [\u7fa9\u52d9\u6559\u80b2, \u9ad8\u7b49\u5b66\u6821, \u5404\u7a2e\u5c02\u9580\u5b66\u6821] 3
\nFI_HEIGHT [170, 180, 190, 200] 4
\nFI_JOB [\u5bb6\u4e8b\u624b\u4f1d, \u5b66\u751f] 2<\/p>\n<\/blockquote>\n\n
\nlist
\n[\u5317\u6d77\u9053, \u9752\u68ee\u770c, \u5ca9\u624b\u770c, \u5bae\u57ce\u770c, \u79cb\u7530\u770c, \u5c71\u5f62\u770c, \u798f\u5cf6\u770c, \u8328\u57ce\u770c, \u6803\u6728\u770c, \u7fa4\u99ac\u770c, \u65b0\u6f5f\u770c, \u5bcc\u5c71\u770c, \u77f3\u5ddd\u770c, \u798f\u4e95\u770c, \u5c71\u68a8\u770c, \u9577\u91ce\u770c, \u5c90\u961c\u770c, \u9759\u5ca1\u770c, \u611b\u77e5\u770c, \u4e09\u91cd\u770c, \u6ecb\u8cc0\u770c, \u4eac\u90fd\u5e9c, \u5927\u962a\u5e9c, \u5175\u5eab\u770c, \u5948\u826f\u770c, \u548c\u6b4c\u5c71\u770c, \u9ce5\u53d6\u770c, \u5cf6\u6839\u770c, \u5ca1\u5c71\u770c, \u5e83\u5cf6\u770c, \u5c71\u53e3\u770c, \u5fb3\u5cf6\u770c, \u9999\u5ddd\u770c, \u611b\u5a9b\u770c, \u9ad8\u77e5\u770c, \u798f\u5ca1\u770c, \u4f50\u8cc0\u770c, \u9577\u5d0e\u770c, \u718a\u672c\u770c, \u5927\u5206\u770c, \u5bae\u5d0e\u770c, \u9e7f\u5150\u5cf6\u770c, \u6c96\u7e04\u770c]<\/p>\n<\/blockquote>\nM04\u3055\u3093\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u3084\u3063\u3066\u307f\u308b<\/a><\/h2>\n
\n
\u7b2c2\u56de\u76ee\u306eCypher\u30af\u30a8\u30ea\u30fc\u306e\u8a02\u6b63<\/h3>\n
\n
\nMATCH (woman:Person:Woman)-[*]->(things)
\nWHERE NOT woman-[:DISAGREE|SUCCESS]-()
\nWITH woman, COLLECT(things.title) AS wlist,list, [1980,1979,1978,1977,1976,1975,1974,1973, 1972,1971,1970,1995,1994,1993,1992,1991,1990, \"\u7fa9\u52d9\u6559\u80b2\",\"\u9ad8\u7b49\u5b66\u6821\",\"\u5404\u7a2e\u5c02\u9580\u5b66\u6821\",\"\u5317\u6d77\u9053\",\"\u9752\u68ee\u770c\",\"\u5ca9\u624b\u770c\",\"\u5bae\u57ce\u770c\",\"\u79cb\u7530\u770c\",\"\u5c71\u5f62\u770c\",\"\u798f\u5cf6\u770c\",\"\u8328\u57ce\u770c\",\"\u6803\u6728\u770c\",\"\u7fa4\u99ac\u770c\",\"\u65b0\u6f5f\u770c\",\"\u5bcc\u5c71\u770c\",\"\u77f3\u5ddd\u770c\",\"\u798f\u4e95\u770c\",\"\u5c71\u68a8\u770c\",\"\u9577\u91ce\u770c\",\"\u5c90\u961c\u770c\",\"\u9759\u5ca1\u770c\",\"\u611b\u77e5\u770c\",\"\u4e09\u91cd\u770c\",\"\u6ecb\u8cc0\u770c\",\"\u4eac\u90fd\u5e9c\",\"\u5927\u962a\u5e9c\",\"\u5175\u5eab\u770c\",\"\u5948\u826f\u770c\",\"\u548c\u6b4c\u5c71\u770c\",\"\u9ce5\u53d6\u770c\",\"\u5cf6\u6839\u770c\",\"\u5ca1\u5c71\u770c, \u5e83\u5cf6\u770c\",\"\u5c71\u53e3\u770c\",\"\u5fb3\u5cf6\u770c\",\"\u9999\u5ddd\u770c\",\"\u611b\u5a9b\u770c\",\"\u9ad8\u77e5\u770c\",\"\u798f\u5ca1\u770c\",\"\u4f50\u8cc0\u770c\",\"\u9577\u5d0e\u770c\",\"\u718a\u672c\u770c\",\"\u5927\u5206\u770c\",\" \u5bae\u5d0e\u770c\",\"\u9e7f\u5150\u5cf6\u770c\",\"\u6c96\u7e04\u770c\",\"\u5bb6\u4e8b\u624b\u4f1d\",\"\u5b66\u751f\",170,180,190,200] AS list2
\nWHERE NONE ( x IN wlist WHERE x IN list2)
\nWITH woman, filter( x IN list WHERE x IN wlist) AS shared
\nWITH woman.name AS wlist, shared AS slist, 1.0 * length(shared) \/ 20 AS rank
\nRETURN wlist AS \u540d\u524d, slist AS \u5171\u901a\u8981\u7d20, rank AS \u985e\u4f3c\u6027
\nORDER BY rank DESC
\nLIMIT 10\n<\/p>\n<\/blockquote>\n\n
\nW13 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 150, 700, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u6d77, \u5916\u5411\u7684, \u5438\u308f\u306a\u3044, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb] 0.8
\nW24 [1982, \u5927\u5b66, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 140, 600, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u7a4d\u6975\u7684, \u6d77, \u5916\u5411\u7684, \u732b\u6d3e, \u5438\u308f\u306a\u3044, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb] 0.8
\nW14 [\u98f2\u3080, 1983, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, 160, \u571f\u65e5\u795d\u65e5, 400, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u597d\u304d, \u795e\u5948\u5ddd\u770c, \u6d77, \u5185\u5411\u7684, \u732b\u6d3e, \u91ce\u7403, \u8a71\u3059\u30bf\u30a4\u30d7] 0.75
\nW22 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 160, \u571f\u65e5\u795d\u65e5, 300, \u516c\u52d9\u54e1, \u597d\u304d, \u6771\u4eac\u90fd, \u5916\u5411\u7684, \u732b\u6d3e, \u91ce\u7403] 0.7
\nW11 [1986, \u77ed\u5927\u30fb\u9ad8\u5c02, \u4fe1\u3058\u306a\u3044, 150, 300, \u516c\u52d9\u54e1, \u6771\u4eac\u90fd, \u7121\u3057, \u5185\u5411\u7684, \u5438\u308f\u306a\u3044, \u30e8\u30ac] 0.55<\/p>\n<\/blockquote>\n
\n\u30fb\u5fc5\u9808\u6761\u4ef6\u306e\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u5b9f\u884c\u3059\u308b\u30af\u30a8\u30ea\u30fc\u30d6\u30ed\u30c3\u30af\u306e\u7b87\u6240\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u8981\u7d20\u3068\u306e\u30d1\u30bf\u30fc\u30f3\u30de\u30c3\u30c1\u3092\u5b9f\u884c\u3057\u3066\u304b\u3089\u884c\u3063\u3066\u3044\u307e\u3057\u305f\u3002\u3053\u308c\u306f\u3001\u30c7\u30fc\u30bf\u51e6\u7406\u91cf\u3092\u6e1b\u3089\u3059\u305f\u3081\u306b\u3082\u3001\u4e0d\u6b63\u78ba\u306a\u30d1\u30bf\u30fc\u30f3\u3092\u898b\u9003\u3055\u306a\u3044\u305f\u3081\u306b\u3082\u3001\u305d\u306e\u524d\u306e\u30af\u30a8\u30ea\u30fc\u30d6\u30ed\u30c3\u30af\u3067\u5b9f\u884c\u3059\u3079\u304d\u3053\u3068\u3067\u3057\u305f\u3002\u6b21\u306e\u69cb\u6587\u306e\u3053\u3068\u3067\u3059\u3002<\/p>\n\u4eca\u56de\u306e\u51e6\u7406<\/h3>\n
\n
\nman-[:FI_BORN|FI_EDUCATION|FI_HEIGHT|FI_JOB]->(filterCondition)
\nWITH split(man.filter_location, \"|\") AS fitlerLocation, collect(distinct request.title) AS requestList, collect(distinct filterCondition.title) AS filterList
\nMATCH (woman:Person:Woman)-[*]->(things)
\nWHERE NOT woman-[:DISAGREE|SUCCESS]-()
\nWITH woman, COLLECT(things.title) AS womanCondition, fitlerLocation, filterList, requestList
\nWHERE NONE ( x IN womanCondition WHERE x IN filterList) AND NONE ( x IN womanCondition WHERE x IN fitlerLocation)
\nWITH woman, filter( x IN requestList WHERE x IN womanCondition) AS shared, fitlerLocation, filterList
\nWITH woman.name AS wlist, shared AS slist, 1.0 * length(shared) \/ 20 AS rank
\nRETURN wlist AS \u540d\u524d, slist AS \u5171\u901a\u8981\u7d20, rank\u3000AS \u30e9\u30f3\u30af
\nORDER BY rank DESC
\nLIMIT 10\n<\/p>\n<\/blockquote>\n\n
\nW13 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 150, 700, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u6d77, \u5916\u5411\u7684, \u5438\u308f\u306a\u3044, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb] 0.8
\nW24 [1982, \u5927\u5b66, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 140, 600, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u7a4d\u6975\u7684, \u6d77, \u5916\u5411\u7684, \u732b\u6d3e, \u5438\u308f\u306a\u3044, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb] 0.8
\nW14 [\u98f2\u3080, 1983, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, 160, \u571f\u65e5\u795d\u65e5, 400, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u597d\u304d, \u795e\u5948\u5ddd\u770c, \u6d77, \u5185\u5411\u7684, \u732b\u6d3e, \u91ce\u7403, \u8a71\u3059\u30bf\u30a4\u30d7] 0.75
\nW22 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 160, \u571f\u65e5\u795d\u65e5, 300, \u516c\u52d9\u54e1, \u597d\u304d, \u6771\u4eac\u90fd, \u5916\u5411\u7684, \u732b\u6d3e, \u91ce\u7403] 0.7
\nW11 [1986, \u77ed\u5927\u30fb\u9ad8\u5c02, \u4fe1\u3058\u306a\u3044, 150, 300, \u516c\u52d9\u54e1, \u6771\u4eac\u90fd, \u7121\u3057, \u5185\u5411\u7684, \u5438\u308f\u306a\u3044, \u30e8\u30ac] 0.55<\/p>\n<\/blockquote>\nM04\u3055\u3093\u306e\u5019\u88dc\u8005\u3067\u30ea\u30af\u30a8\u30b9\u30c8\u3068\u7570\u306a\u308b\u8981\u7d20\u3092\u307f\u308b<\/h3>\n
\n
\nman-[:FI_BORN|FI_EDUCATION|FI_HEIGHT|FI_JOB]->(filterCondition)
\nWITH split(man.filter_location, \"|\") AS fitlerLocation, collect(distinct request.title) AS requestList, collect(distinct filterCondition.title) AS filterList
\nMATCH (woman:Person:Woman)-[*]->(things)
\nWHERE NOT woman-[:DISAGREE|SUCCESS]-()
\nWITH woman, COLLECT(things.title) AS womanCondition, fitlerLocation, filterList, requestList
\nWHERE NONE ( x IN womanCondition WHERE x IN filterList) AND NONE ( x IN womanCondition WHERE x IN fitlerLocation)
\nWITH woman, filter( x IN requestList WHERE x IN womanCondition) AS shared, fitlerLocation, filterList, womanCondition, requestList
\nWITH woman.name AS wlist, shared AS slist, 1.0 * length(shared) \/ 20 AS rank , womanCondition, requestList
\nWITH wlist,slist,rank, requestList, womanCondition
\nORDER BY rank DESC
\nLIMIT 10
\nRETURN wlist AS \u540d\u524d, slist AS \u5171\u901a\u8981\u7d20, rank AS \u985e\u4f3c\u6027, filter( x IN womanCondition WHERE NOT(x IN requestList)) AS \u4e0d\u4e00\u81f4\n<\/p>\n<\/blockquote>\n\n
\nW13 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 150, 700, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u6d77, \u5916\u5411\u7684, \u5438\u308f\u306a\u3044, \u30d0\u30b9\u30b1\u30c3\u30c8\u30dc\u30fc\u30eb] 0.8 [\u4e0d\u5b9a\u671f, \u3068\u3061\u3089\u3067\u3082\u826f\u3044, \u6d88\u6975\u7684, \u72ac\u6d3e]
\nW24 [1982, \u5927\u5b66, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 140, 600, \u30b2\u30fc\u30e0, \u81ea\u55b6\u696d, \u597d\u304d, \u57fc\u7389\u770c, \u7121\u3057, \u7a4d\u6975\u7684, \u6d77, \u5916\u5411\u7684, \u732b\u6d3e, \u5438\u308f\u306a\u3044, \u30d0\u30ec\u30fc\u30dc\u30fc\u30eb] 0.8 [\u5e73\u65e5, \u3068\u3061\u3089\u3067\u3082\u826f\u3044, \u98f2\u307e\u306a\u3044, \u4fe1\u3058\u308b]
\nW14 [\u98f2\u3080, 1983, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, 160, \u571f\u65e5\u795d\u65e5, 400, \u4f01\u696d\u7d4c\u55b6\u30fb\u5f79\u54e1, \u597d\u304d, \u795e\u5948\u5ddd\u770c, \u6d77, \u5185\u5411\u7684, \u732b\u6d3e, \u91ce\u7403, \u8a71\u3059\u30bf\u30a4\u30d7] 0.75 [\u3068\u3061\u3089\u3067\u3082\u306a\u3044, \u5bdd\u308b, \u5438\u3046, \u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044, \u6709\u308a]
\nW22 [\u98f2\u3080, 1984, \u5927\u5b66, \u4fe1\u3058\u306a\u3044, \u610f\u8b58\u3057\u3066\u904b\u52d5\u3059\u308b, 160, \u571f\u65e5\u795d\u65e5, 300, \u516c\u52d9\u54e1, \u597d\u304d, \u6771\u4eac\u90fd, \u5916\u5411\u7684, \u732b\u6d3e, \u91ce\u7403] 0.7 [\u805e\u304f\u30bf\u30a4\u30d7, \u6d88\u6975\u7684, \u97f3\u697d\u611f\u60f3, \u5438\u3046, \u5c71, \u6709\u308a]
\nW11 [1986, \u77ed\u5927\u30fb\u9ad8\u5c02, \u4fe1\u3058\u306a\u3044, 150, 300, \u516c\u52d9\u54e1, \u6771\u4eac\u90fd, \u7121\u3057, \u5185\u5411\u7684, \u5438\u308f\u306a\u3044, \u30e8\u30ac] 0.55 [\u5e73\u65e5, \u805e\u304f\u30bf\u30a4\u30d7, \u3068\u3061\u3089\u3067\u3082\u306a\u3044, \u97f3\u697d\u611f\u60f3, \u98f2\u307e\u306a\u3044, \u5acc\u3044, \u7279\u306b\u610f\u8b58\u3057\u3066\u3044\u306a\u3044, \u516c\u5712, \u72ac\u6d3e]<\/p>\n<\/blockquote>\n\u307e\u3068\u3081<\/a><\/h2>\n
\n
\nGoogle\u3084Facebook, Twitter\u306a\u3069\u3001\u4e16\u754c\u3092\u30ea\u30fc\u30c9\u3059\u308bIT\u4f01\u696d\u3067\u306f\u3001\u65e2\u306b10\u5e74\u4ee5\u4e0a\u524d\u304b\u3089\u300c\u60c5\u5831\u3068\u60c5\u5831\u306e\u7e4b\u304c\u308a\u306f\u4fa1\u5024\u3067\u3042\u308b\u300d\u3044\u3046\u601d\u60f3\u3092\u6301\u3063\u3066\u3044\u305f\u3088\u3046\u3067\u3059\u3002\u3053\u308c\u3089\u306e\u4f01\u696d\u9054\u306f\u3001\u7e4b\u304c\u308a\u3092\u8d77\u696d\u3084\u65b0\u3057\u3044\u30b5\u30fc\u30d3\u30b9\u5c55\u958b\u306e\u305f\u3081\u306e\u4e2d\u6838\u306b\u636e\u3048\u3066\u3044\u305f\u3068\u8a00\u308f\u308c\u3066\u3044\u307e\u3059\u3002\u305d\u3057\u3066\u3001\u7e4b\u304c\u308a\u3092\u5229\u7528\u3059\u308b\u305f\u3081\u306e\u624b\u6bb5\uff08\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\uff09\u306e\u958b\u767a\u3084\u5229\u7528\u306b\u3082\u71b1\u5fc3\u306b\u53d6\u308a\u7d44\u3093\u3067\u304d\u307e\u3057\u305f\u3002\u6c4e\u7528\u578b\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u3082\u8a00\u3048\u308bNeo4j\u3082\u3001\u3053\u308c\u3089\u306e\u4f01\u696d\u306e\u601d\u60f3\u3084\u6280\u8853\u306b\u5f71\u97ff\u3092\u53d7\u3051\u3066\u3044\u308b\u3068\u3044\u308f\u308c\u3066\u3044\u307e\u3059\u3002
\n\u5f93\u6765\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8003\u3048\u65b9\u304b\u3089\u8a00\u3046\u3068\u3001\u7e4b\u304c\u308a\u306fER\u56f3\u3084\u30b8\u30e7\u30a4\u30f3\u306a\u3069\u306e\u305f\u3081\u306e\u7d10\u4ed8\u3068\u8868\u73fe\u3057\u3001\u60c5\u5831\u3092\u691c\u7d22\u3059\u308b\u305f\u3081\u306e\u624b\u6bb5\u3068\u3044\u3046\u4f4d\u7f6e\u3065\u3051\u3067\u3057\u305f\u3002\u3082\u3061\u308d\u3093\u3001\u60c5\u5831\u3092\u691c\u7d22\u3059\u308b\u305f\u3081\u306e\u624b\u6bb5\u3068\u3044\u3046\u306e\u3082\u91cd\u8981\u306a\u3053\u3068\u3067\u3059\u304c\u3001\u300c\u60c5\u5831\u3068\u60c5\u5831\u306e\u7e4b\u304c\u308a\u306f\u4fa1\u5024\u3067\u3042\u308b\u300d\u3068\u3044\u3046\u601d\u60f3\u3068\u306f\u3001\u5927\u304d\u306a\u9694\u305f\u308a\u304c\u3042\u308b\u3088\u3046\u306a\u6c17\u304c\u3057\u307e\u3059\u3002
\n\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5229\u7528\u3059\u308b\u306b\u5f53\u305f\u3063\u3066\u306f\u3001\u3053\u306e\u601d\u60f3\u306e\u9055\u3044\u3092\u7406\u89e3\u3057\u3066\u9802\u304d\u305f\u3044\u3067\u3059\u3002\u65e2\u306b\u5b58\u5728\u3059\u308b\u7e4b\u304c\u308a\u304b\u3089\u65b0\u3057\u3044\u4fa1\u5024\u3092\u767a\u6398\u3059\u308b\u3001\u7e4b\u304c\u308a\u304c\u5b58\u5728\u3057\u306a\u304b\u3063\u305f\u7b87\u6240\u306b\u7e4b\u304c\u308a\u3092\u4f5c\u308b\u3053\u3068\u3067\u3001\u3055\u3089\u306b\u65b0\u3057\u3044\u4fa1\u5024\u9023\u9396\u3092\u5f15\u304d\u8d77\u3053\u3059\u3053\u3068\u304c\u3001\u3053\u308c\u304b\u3089\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u3082\u305f\u3089\u3059\u672a\u6765\u306a\u306e\u304b\u3082\u77e5\u308c\u307e\u305b\u3093\u3002<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"