Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
speee-kaigi-160629
Search
kawakubox
June 29, 2016
Programming
1
2.5k
speee-kaigi-160629
SpeeeKaigi#1で会社の名寄せにGraphDB(Neo4j)を使ってみた話をした際のスライドです
kawakubox
June 29, 2016
Tweet
Share
More Decks by kawakubox
See All by kawakubox
Kevin Bacon Number with Neo4j
kawakubox
0
1.7k
speee-eng-mtg-20160810
kawakubox
0
1.3k
Other Decks in Programming
See All in Programming
AWS CDKコントリビュートTIPS / aws-cdk-contribution-tips
gotok365
2
170
『Railsオワコン』と言われる時代に、なぜブルーモ証券はRailsを選ぶのか
free_world21
0
160
AWS Application Composerで始める、 サーバーレスなデータ基盤構築 / 20240406-jawsug-hokuriku-shinkansen
kasacchiful
1
260
Komplexe Oberflächen mit SVG und der Web Animation API
joergneumann
0
670
検証も兼ねて個人開発でHonoとかと向き合った話
hanetsuki
1
900
try! Swift Tokyo 初参加報告LT
hinakko2
0
220
Node.js v22 で変わること
yosuke_furukawa
PRO
9
3.3k
Milestoner
bkuhlmann
1
410
dbtのドメイン分割による データ基盤の改善とDigdagとの連携
sakama
0
270
Elm 0.19.0 Changes
bkuhlmann
0
490
大規模UIKitベースアプリへのTCAの段階的導入/gradual-adoption-of-tca-in-a-large-scale-uikit-based-app
takehilo
1
170
Prepare for Jakarta EE 11 - Performance and Developer Productivity
ivargrimstad
0
770
Featured
See All Featured
The Cult of Friendly URLs
andyhume
74
5.7k
The Power of CSS Pseudo Elements
geoffreycrofte
60
5k
The Straight Up "How To Draw Better" Workshop
denniskardys
227
130k
Faster Mobile Websites
deanohume
299
30k
How To Stay Up To Date on Web Technology
chriscoyier
782
250k
Intergalactic Javascript Robots from Outer Space
tanoku
266
26k
Scaling GitHub
holman
457
140k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
241
1.2M
GraphQLとの向き合い方2022年版
quramy
32
12k
What's in a price? How to price your products and services
michaelherold
237
11k
The World Runs on Bad Software
bkeepers
PRO
61
6.7k
GitHub's CSS Performance
jonrohan
1025
450k
Transcript
ձ໊ࣾͷ໊دͤʹάϥϑDBΛ ͬͯΈͨ(wip) 2016.6.29(wed) Տٱอ ൟ࢙
ࣗݾհ • Տٱอ ൟ࢙ (kawakubox) • ւ֎ࣄۀ෦ ਓࡐܥαʔϏεͷEngͬͯ·͢ • ࠷ۙͷ͓ͳ୲ɺΫϩʔϥɺϚελ౷߹
ձࣾϚελͷ౷߹ΛλεΫͱ ๊͍ͯ͑ͯ͠ΔͷͰ͢ ͕ɺɺɺ
໘͍ͯ͠Δ՝ • ձࣾϚελ͕ʑՃ͞Ε͍ͯΔ • Ճ͞ΕΔձ໊ࣾͷදهʹϒϨ͕͋Δ • and more...
ಛఆͷϫʔυ͕ͳ͔ͬͨΓ • The Procter & Gamble Company • Procter &
Gamble Company
ޠॱ͕ҧͬͨΓɺ()͍ͭͯͨΓ • LLC General Mortors Company • General Mortors Company,
LLC (GM)
ͦͦtypoͩͬͨΓ • Business Development Company • Business Deveploment Company
৽چͷձࣾϚελΛ౷߹͢Δࡍɺ୯७ͳ͕ͬͪ ΌΜ͜Ͱͳ͘ɺσʔλΛΩϨΠʹ͍ͨ͠ΑͶ by σΟϨΫλ
໊د͕ͤඞཁͩɺɺɺ
͜Ε·Ͱࢼͨ͜͠ͱ • HighεϖοΫWindowsͰɺExcelͬͯສ ݅نͷϑΝΠϧΛจࣈྻՃΛͯ͠ಥ͖߹Θ ͤͨΓ͍ͯͨ͠ • খจࣈԽɺසग़ϫʔυআɺه߸আ and more...
·͍ͩͬͯΔ • ձ໊ࣾ typo • ୯ޠॱংͷલޙ
ͳΜ͔͍͍ํ๏ͳ͍͔ɺɺɺ
άϥϑDB(Neo4j)ͬͯͳΜ ͔Ͱ͖Δ͔!! SpeeeKaigi ͷωλ࡞ΓʹͳΔ͠ɺɺɺ
άϥϑDBͱɺɺɺ ϊʔυ()ͱϦϨʔγϣϯ(ઢ)ͱ͍͏2ͭͷ֓೦Ͱ σʔλͷؔੑΛ֨ೲ͢Δσʔλϕʔε
ࠓճͷ໊دʹ༻͍ͨσʔλϞσϧ Node • CompanyName • ձ໊ࣾ • Word • ձ໊ࣾΛߏ͢Δ୯ޠ
ࠓճͷ໊دʹ༻͍ͨσʔλϞσϧ Relation • has [CompanyName -> Word] • ձ໊ࣾ ͕
୯ޠ Λ͍࣋ͬͯΔؔΛද͢ • similar [Word -> Word] • ୯ޠ ͱ ୯ޠ ͕ࣅ͍ͯΔؔΛද͢ • ϨʔϕϯγϡλΠϯڑ͕͔ۙͬͨΓɺྨ ٛޠͩͬͨΓ
ࠓճͷ໊دʹ༻͍ͨσʔλϞσϧ
ࠓճͷ໊دʹ༻͍ͨσʔλϞσϧ
ຊ൪ڥͷσʔλΛೖ • Node • CompanyName … 25,947 • Word …
16,944 • Relation • has … 99,526 • similar … 11,546 • σʔλαΠζ … ͓Αͦ 90MB
GraphDBͰݕࡧͯ͠ΈΔ MATCH (base: CompanyName {text: LOWER('AKR Land Deveploment PT')}) MATCH
p=(base)-[*1..2]->()<--(c) WHERE SIZE((base)-[*1..2]->()<--(c)) > base.word_count - 1 RETURN DISTINCT c AKR Land Deveploment PT ͱ͍͏typo͍ͯ͠Δ ձ໊ࣾͰݕࡧΛ͔͚Δͱɺɺɺ akr land development, pt akr land development pt ͕ݕࡧ݁Ռͱͯ͠දࣔ͞ΕΔɻ
ͬͯΈͯ • Pros • RDBMSͰ͋Γ͕ͪͳςʔϒϧ࠶ؼ݁߹ͷί ετθϩ • ܦ࿏୳ࡧϥΫ • Cons
• Cypher ͱ͍͏൚༻Ͱ͖ͳ͍ΫΤϦݴޠ • Wordϊʔυ͕ଟ͍ͷͰ Wordؒͷؔ
(wip) ͱ͍͏͜ͱͰ·ͩϩʔ ΧϧڥͰಈ͍͍ͯΔ͚ͩͳ ͷͰ͕͢ɺಋೖͯ͠Έ͍ͨ ͬ!!