cl-ignition - Common Lisp SPARQL Query Generator

About the Common Lisp library for generating SPARQL query in S-expression.

Transcript

1. 油谷知岐
   DMJHOJUJPO
   $PNNPO-JTQ
   41"32-ΫΤϦδΣωϨʔλ
   ϓϩδΣΫτΛ࢝ΊΑ͏ͱࢥͬͯΔ࿩
   2018-12-15
   

   View Slide

2. LOD
   The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
   -JOLFE0QFO%BUBʢϦϯΫτɾΦʔϓϯɾσʔλɺ໊ུ-0%ʣ͸ɺ
   ΢Σϒ্Ͱίϯϐϡʔλॲཧʹదͨ͠σʔλΛެ։ɾڞ༗͢ΔͨΊͷ
   ٕज़ͷ૯শͰ͋Δɻ
   ैདྷͷ΢Σϒ͕)5.-จॻؒͷϋΠύʔϦϯΫʹΑΔਓؒͷͨΊͷ
   ৘ใۭؒͷߏஙΛ໨తͱ͖ͯͨ͜͠ͱʹରԠͯ͠ɺ
   -JOLFE0QFO%BUBͰ͸ߏ଄Խ͞Εͨσʔλಉ࢜ΛϦϯΫͤ͞Δ͜ͱͰ
   ίϯϐϡʔλ͕ར༻Մೳͳʮσʔλͷ΢ΣϒʯͷߏஙΛ໨ࢦ͓ͯ͠Γɺ
   ηϚϯςΟοΫ΢Σϒͷܗ੒ʹॏཁͳٕज़ͱͳ͍ͬͯΔ>
   ɻ
   ʢ8JLJQFEJBɿ-JOLFE0QFO%BUBΑΓʣ
   

   View Slide

3. SPARQL
   The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
   41"32-ʢεύʔΫϧ>ɺ41"32-1SPUPDPMBOE3%'2VFSZ-BOHVBHFͷ
   ࠶ؼత಄ࣈޠʣ͸ɺ3%'ΫΤϦݴޠͷ̍ͭͰ͋Δɻ3%'ΫΤϦݴޠ͸ɺ
   3FTPVSDF%FTDSJQUJPO'SBNFXPSL 3%'
   Ͱهड़͞Εͨ9.-΍5VSUMFͳͲͷ
   3%'σʔλͷϦιʔεΛऔΓѻ͏ͨΊͷίϯϐϡʔλݴޠͰ͋Δɻ
   41"32-͸ɺΫΤϦͷجຊతͳύλʔϯͰ͋Δ࿦ཧੵ΍࿦ཧ࿨Λ͸͡Ίɺ
   จࣈྻૢ࡞΍ϑΟϧλʔͳͲͷͦͷଞͷύλʔϯΛࢦఆՄೳͰ͋Γ>ɺ
   1ZUIPO΍3VCZͳͲͷϓϩάϥϛϯάݴޠͰ41"32-Λར༻Ͱ͖Δ
   ϥΠϒϥϦ͕ଘࡏ͢Δ>ɻ
   ʢ8JLJQFEJBɿ41"32-ΑΓʣ
   

   View Slide

4. RDF・SPARQL
   The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
   ே೔ωοτɾ41"32- 8$ͷ೔ຊޠ༁
   ɿ
   IUUQXXXBTBIJOFUPSKQdBYTLNUOJOUFSOFUSEGSEGTQBSRM
   RVFSZIUNM
   8$ɾ41"32-ɿ
   IUUQTXXXXPSH53SEGTQBSRMRVFSZ
   

   View Slide

5. DBpedia
   The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
   8JLJQEJB͔ΒσʔλΛऔΓग़͠ɼ-0%ͱͯ͠ެ։͢ΔίϛϡχςΟɾϓϩδΣΫτ
   ຊՈ%#QFEJB͸ɼओʹӳޠ൛ͷ8JLJQFEJBΛର৅
   %#QFEJB೔ຊޠ൛͸ɼӳޠ൛ʴ೔ຊޠ൛8JLJQFEJB
   ൒खಈɾ൒ࣗಈͰσʔλΛ෇༩͍ͯ͠Δͱͷ͜ͱ
   ೔ຊޠ൛
   ɹIUUQKBECQFEJBPSH
   ӳޠ൛
   ɹIUUQTXJLJECQFEJBPSH
   

   View Slide

6. SPARQLクエリ
   The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
   جຊతͳ4FMFDUจ
   TFMFDUEJTUJODUXIFSF\IUUQKBECQFEJBPSHSFTPVSDF౦ژ౎
   ɹɹɹɹɹɹɹɹIUUQECQFEJBPSHPOUPMPHZMFBEFS/BNF P^
   TFMFDUදࣔର৅DPOEJUJPO\lओޠlड़ޠzl໨తޠ^MJNJU
   l౦ژ౎zͷzϦʔμʔz͸ʁ
   4FMFDUྫ %#QFEJB
   
   IUUQKBECQFEJBPSHSFTPVSDFદఴཁҰ
   

   View Slide

7. SPARQLクエリ
   The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
   TFMFDUEJTUJODUXIFSF\IUUQKBECQFEJBPSHSFTPVSDF౦ژ౎
   ɹɹɹɹɹɹɹɹ QIUUQKBECQFEJBPSHSFTPVSDFદఴཁҰ^
   l౦ژ౎zͱlદఴཁҰzͱͷlؔ܎z͸ʁ
   4FMFDUྫ %#QFEJB
   
   IUUQECQFEJBPSHPOUPMPHZMFBEFS/BNF
   IUUQECQFEJBPSHPOUPMPHZXJLJ1BHF8JLJ-JOL
   IUUQKBECQFEJBPSHQSPQFSUZ஌ࣄ
   

   View Slide

8. 日本語版DBpediaはHPで
   SPARQLエンドポイントも
   公開してくれてる
   The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
   ˞41"32-ΤϯυϙΠϯτɿ41"32-ΫΤϦΛ࣮ߦ͢ΔΠϯλϑΣʔε
   

   View Slide

9. SPARQL実行例(DBpedia)
   The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
   IUUQKBECQFEJBPSH
   

   View Slide

10. SPARQL実行例(DBpedia)
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    IUUQKBECQFEJBPSHTQBSRM
    

    View Slide

11. SPARQL実行例(DBpedia)
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    IUUQKBECQFEJBPSHTQBSRM
    ΫΤϦೖྗͯ͠
    

    View Slide

12. SPARQL実行例(DBpedia)
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    IUUQKBECQFEJBPSHTQBSRM
    ग़ྗܗࣜΛࢦఆͯ͠
    

    View Slide

13. SPARQL実行例(DBpedia)
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    IUUQKBECQFEJBPSHTQBSRM
    ࣮ߦ͢Δͱ
    

    View Slide

14. SPARQL実行例(DBpedia)
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    IUUQKBECQFEJBPSHTQBSRM
    

    View Slide

15. SPARQL実行例(DBpedia)
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    IUUQKBECQFEJBPSHTQBSRM
    ग़ྗܗࣜʹ͸
    

    View Slide

16. SPARQL実行例(DBpedia)
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    l౦ژ౎zͷzϦʔμʔz͸ʁ
    TFMFDUEJTUJODUXIFSF\IUUQKBECQFEJBPSHSFTPVSDF౦ژ౎
    IUUQECQFEJBPSHPOUPMPHZMFBEFS/BNF P^
    ֤Ϧιʔε͸جຊ63*Ͱදݱ͞ΕΔ
    

    View Slide

17. SPARQL実行例(DBpedia)
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    l౦ژ౎zͱlદఴཁҰzͱͷlؔ܎z͸ʁ
    TFMFDUEJTUJODUXIFSF\IUUQKBECQFEJBPSHSFTPVSDF౦ژ౎ɹ
    QIUUQKBECQFEJBPSHSFTPVSDFદఴཁҰ^
    

    View Slide

18. SPARQLをS式で表したい！
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    

    View Slide

19. ない(？)から作ろうや
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    

    View Slide

20. The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    Common Lisp
    SPARQLクエリGenerator
    プロジェクト
    CL-Ignition
    IUUQTHJUIVCDPNECZNDMJHOJUJPO
    

    View Slide

21. Common Lisp
    SPARQLクエリGenerator
    プロジェクト
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    CL-Ignition
    IUUQTHJUIVCDPNECZNDMJHOJUJPO
    

    View Slide

22. cl-ignitionで出来る
    (ようにしたい)こと
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    ɾ41"32-ͷΫΤϦੜ੒
    ɾ41"32-ͷ࣮ߦ
    ɾ41"32-࣮ߦ݁Ռͷར༻ิॿ
    ɾͦͷଞΫΤϦߏஙิॿػೳ
    

    View Slide

23. クエリ生成
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    ɾ41"32-ͷΫΤϦੜ੒
    ɾ41"32-ͷ࣮ߦ
    ɾ41"32-࣮ߦ݁Ռͷར༻ิॿ
    

    View Slide

24. 基本的な関数・マクロ
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    ؔ਺
    ϚΫϩ
    ɾXJUIQSFpYɿ41"32-ΫΤϦ࣮ߦ݁ՌΛγϯϘϧʹଋറ
    ɾDPOWFSURVFSZɿΫΤϦΦϒδΣΫτΛΫΤϦจࣈྻʹม׵
    ɾSFTVMUpMUFSɿΫΤϦ࣮ߦ݁Ռ͔ΒσʔλΛநग़
    ɾHFUTJOHMFLFZɿಉ্ ʴฦ٫σʔλͷΩʔΛ͚ͭͩࢦఆ
    
    ɾSFRVFTUECQFEJBɿ%#QFEJBͷ41"32-αʔόʔʹ໰߹Θͤ
    

    View Slide

25. SPARQLのPrefix
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    TFMFDUEJTUJODU 1 0XIFSF\IUUQKBECQFEJBPSHSFTPVSDF෺ޠ
    IUUQECQFEJBPSHPOUPMPHZBCTUSBDU 0^
    13&'*9ECQFEJBKBIUUQKBECQFEJBPSHSFTPVSDF
    13&'*9POUPMPHZIUUQECQFEJBPSHPOUPMPHZ
    TFMFDUEJTUJODUXIFSF\ECQFEJBKB෺ޠPOUPMPHZBCTUSBDU P^
    cc
    ୺తʹ͸লུදه
    

    View Slide

26. 基本的な使い方例
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    RMRVJDLMPBEDMJHOJUJPO
    
    DMJHOJUJPOXJUIQSFpY WBM
    
    ECQFEJBKQIUUQKBECQFEJBPSHSFTPVSDF
    
    POUPMPHZIUUQECQFEJBPSHPOUPMPHZ
    
    
    TFMFDU OJM Q P
    
    EJTUJODUU
    TVCKFDU ECQFEJBKQ෺ޠ
    
    QSFEJDBUF POUPMPHZBCTUSBDU
    
    
    
    DMJHOJUJPODPOWFSURVFSZWBM
    
    
    lTFMFDUEJTUJODU 1 0XIFSF\IUUQKBECQFEJBPSHSFTPVSDF෺ޠ
    IUUQECQFEJBPSHPOUPMPHZBCTUSBDU 0^
    

    View Slide

27. 基本的な使い方例
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    RMRVJDLMPBEDMJHOJUJPO
    
    DMJHOJUJPOXJUIQSFpY WBM
    
    ECQFEJBKQIUUQKBECQFEJBPSHSFTPVSDF
    
    POUPMPHZIUUQECQFEJBPSHPOUPMPHZ
    
    
    TFMFDU OJM Q P
    
    EJTUJODUU
    TVCKFDU ECQFEJBKQ෺ޠ
    
    QSFEJDBUF POUPMPHZBCTUSBDU
    
    
    
    DMJHOJUJPODPOWFSURVFSZWBM
    
    
    lTFMFDUEJTUJODU 1 0XIFSF\IUUQKBECQFEJBPSHSFTPVSDF෺ޠ
    IUUQECQFEJBPSHPOUPMPHZBCTUSBDU 0^
    ੜ੒͞ΕΔ41"32-ΫΤϦΦϒδΣΫτΛ
    ଋറ͢Δม਺
    

    View Slide

28. 基本的な使い方例
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    RMRVJDLMPBEDMJHOJUJPO
    
    DMJHOJUJPOXJUIQSFpY WBM
    
    ECQFEJBKQIUUQKBECQFEJBPSHSFTPVSDF
    
    POUPMPHZIUUQECQFEJBPSHPOUPMPHZ
    
    
    TFMFDU OJM Q P
    
    EJTUJODUU
    TVCKFDU ECQFEJBKQ෺ޠ
    
    QSFEJDBUF POUPMPHZBCTUSBDU
    
    
    
    DMJHOJUJPODPOWFSURVFSZWBM
    
    
    lTFMFDUEJTUJODU 1 0XIFSF\IUUQKBECQFEJBPSHSFTPVSDF෺ޠ
    IUUQECQFEJBPSHPOUPMPHZBCTUSBDU 0^
    লུදهͷͨΊͷ1SFpYએݴ
    1SFpY໊l1SFpYͷத਎z
    
    ʜ
    
    

    View Slide

29. 基本的な使い方例
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    RMRVJDLMPBEDMJHOJUJPO
    
    DMJHOJUJPOXJUIQSFpY WBM
    
    ECQFEJBKQIUUQKBECQFEJBPSHSFTPVSDF
    
    POUPMPHZIUUQECQFEJBPSHPOUPMPHZ
    
    
    TFMFDU OJM Q P
    
    EJTUJODUU
    TVCKFDU ECQFEJBKQ෺ޠ
    
    QSFEJDBUF POUPMPHZBCTUSBDU
    
    
    
    DMJHOJUJPODPOWFSURVFSZWBM
    
    
    lTFMFDUEJTUJODU 1 0XIFSF\IUUQKBECQFEJBPSHSFTPVSDF෺ޠ
    IUUQECQFEJBPSHPOUPMPHZBCTUSBDU 0^
    4ࣜΫΤϦຊମ
    TFMFDU දࣔ͢Δର৅
    
    EJTUJODUUPSOJM
    PCKFDUʜ
    QSFEJDBUFʜ
    TVCKFDUʜ
    
    
    

    View Slide

30. 基本的な使い方例
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    RMRVJDLMPBEDMJHOJUJPO
    
    DMJHOJUJPOXJUIQSFpY WBM
    
    ECQFEJBKQIUUQKBECQFEJBPSHSFTPVSDF
    
    POUPMPHZIUUQECQFEJBPSHPOUPMPHZ
    
    
    TFMFDU OJM Q P
    
    EJTUJODUU
    TVCKFDU ECQFEJBKQ෺ޠ
    
    QSFEJDBUF POUPMPHZBCTUSBDU
    
    
    
    DMJHOJUJPODPOWFSURVFSZWBM
    
    
    lTFMFDUEJTUJODU 1 0XIFSF\IUUQKBECQFEJBPSHSFTPVSDF෺ޠ
    IUUQECQFEJBPSHPOUPMPHZBCTUSBDU 0^
    ΫΤϦΦϒδΣΫτΛ
    จࣈྻʹม׵
    

    View Slide

31. 基本的な使い方例
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    EFGVOHFUBCTUSBDU SFTPVSDFOBNF
    
    DMJHOJUJPOXJUIQSFpY WBM
    
    ECQFEJBKQIUUQKBECQFEJBPSHSFTPVSDF
    
    POUPMPHZIUUQECQFEJBPSHPOUPMPHZ
    
    
    TFMFDU OJM Q P
    
    EJTUJODUU
    TVCKFDU ECQFEJBKQSFTPVSDFOBNF
    
    QSFEJDBUF POUPMPHZBCTUSBDU
    
    
    
    DMJHOJUJPOSFRVFTUECQFEJB
    DMJHOJUJPODPOWFSURVFSZWBM
    
    
    
    
    
    
    ྫ͑͹ɼݕࡧର৅ͷ໊લ͚ͩΛҾ਺ͱͯ͠༩͑Δؔ਺Ͱϥοϓ͢Ε͹ɽɽɽ
    

    View Slide

32. 基本的な使い方例
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    $-64&3 HFUBCTUSBDUl෺ޠz
    
    ෺ޠʢ΋ͷ͕ͨΓʣͱ͸ɺ࿩͠ޠΔ͜ͱɻ͞·͟·ͷࣄฑʹ͍ͭͯ࿩͢͜ͱɻಛఆͷࣄ
    ฑͷҰ෦࢝ऴΛޠΔ͜ͱɺ͋Δ͍͸ݹ͔͘ΒޠΓ఻͑ΒΕͨ࿩Λ͢Δ͜ͱɻจֶܗࣜͷͻͱ
    ͭɻ࡞ऀ͕ݟͨ͜ͱ΍ฉ͍ͨ͜ͱ΍ɺ·ͨ͸૝૾Λجૅͱ͠ɺਓ෺΍ࣄ݅ʹ͍ͭͯঀड़ͨ͠
    ࢄจͷจֶ࡞඼ʢڱٛʣ্هͷจֶ࡞඼ͷதͰɺಛʹฏ҆࣌୅͔Βࣨொ࣌୅·Ͱͷ΋ͷɻฏ
    ҆࣌୅ͷʰ஛औ෺ޠʱʰӉ௡อ෺ޠʱͳͲͷ࡞Γ෺ޠɺʰҏ੎෺ޠʱʰେ࿨෺ޠʱͳͲͷՎ
    ෺ޠΛܦͯɺʰݯࢯ෺ޠʱ΁ͱల։͠ɺח૔࣌୅ʹ͓͚Δٖݹ෺ޠʹࢸΔ·Ͱͷ΋ͷΛࢦ͢ɻ
    ਓܗড়ྤཨ΍Վ෣بͷ࣌୅෺ʹ͓͍ͯɺओ໾͕ࢥ͍ग़΍৺৘ͳͲΛޠΔ৔໘ͷ͜ͱɻ·ͨɺ
    ͦ͏ͨ͠ԋग़ͷ͜ͱɻˢˢˢˢˢz
    ྫ͑͹ɼݕࡧର৅ͷ໊લ͚ͩΛҾ਺ͱͯ͠༩͑Δؔ਺Ͱϥοϓ͢Ε͹ɽɽɽ
    

    View Slide

33. The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    Έ͍ͨͳͶʂ
    

    View Slide

34. 現状
    The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    ɾ1SFpY෇͖ͷ؆୯ͳ4FMFDUจ͕͔͚Δఔ౓
    ɾBOEPSݕࡧɾෳ਺ΫΤϦʹ͸ະରԠ
    ɾࠓޙগͣͭ͠ൃలͤͯ͞ɼߴ౓ͳҙຯॲཧٕज़ʹෆՄܽ
    ɹͳଘࡏͱͯ͠$PNPO-JTQΛച͍ͬͯ͘ࡐྉʹͳΔͱخ͍͠
    ɹϓϩδΣΫτ
    ɾݱঢ়ͰͰ͖Δ͜ͱͷྫ͸ɼHJUIVCʹΞοϓ͍ͯ͠Δίʔυͷ
    ɹDMJHOJUJPOFYBNQMF಺ʹ͋Δ΋ͷ͘Β͍ͳͷͰɼྑ͚Ε͹
    ɹ͓ࢼ͋͠Ε
    

    View Slide

35. The 8th Conference of Kansai Lisp Users Group　2018ー12ー15
    ޙ͸σϞʂ
    

    View Slide