Difference between revisions of "SimpleGraph Semantic Media Wiki Module"
Jump to navigation
Jump to search
(Created page with "<source lang='sparql'> # Find Italian hot springs using the Wikidata Query service # taken from # http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_worldwide # Created 2018-...") |
|||
(108 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | __NOCACHE__ | ||
+ | <slideshow style="bitplan" headingmark="⌘⌘" incmark="…" scaled="true" font="Comic Sans MS, Calibri, cursive" > | ||
+ | ;title: <br><span style='font-size:150%'>SimpleGraph Semantic Media Wiki Module</span>[[File:Profiwikiicon.png]] | ||
+ | ;author: <span style='font-size:50%'>[http://semantic-mediawiki.org/wiki/User:WolfgangFahl Wolfgang Fahl] [mailto:info@bitplan.com info@bitplan.com]</span> | ||
+ | ;footer: Integrating Semantic Media Wiki with multiple other systems via Apache TinkerPop/Gremlin | ||
+ | ;subfooter: [https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2018 SMW CON Fall 2018 Regensburg] | ||
+ | </slideshow> | ||
+ | |||
+ | === ⌘⌘ Wolfgang Fahl === | ||
+ | [[File:Wfjuggling.png|left]] | ||
+ | {| | ||
+ | |- | ||
+ | |colspan="2"| | ||
+ | * [http://semantic-mediawiki.org/wiki/User:WolfgangFahl Wolfgang] [mailto:wf@bitplan.com wf@bitplan.com] is from Willich/Germany. | ||
+ | * I am a teacher for [http://training.bitplan.com/index.php/Software_Architektur_(CPSA-F) software architecture] | ||
+ | * My first contact with MediaWiki was [http://www.waihekepedia.org/index.php/Main_Page about the Waiheke Island community wiki] in 2008 | ||
+ | * You'll find the electric vehicles of our company and family on the internet: | ||
+ | |- | ||
+ | | [[File:Ion2017-02-04.png|250px|link=http://ion.bitplan.com/index.php/Ion2017-02-04|Peugeot Ion]]<br>Peugeot Ion | ||
+ | | [[File:Explore2018-06Portobello.png|link=http://ebike.bitplan.com|250px|Giant Explore]]<br>Giant Explore | ||
+ | |} | ||
+ | |||
+ | === ⌘⌘ Previous SMW Talks === | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | | [[File:wikicms.png|200px|frame|WikiCMS|link=http://royal-family.bitplan.com/index.php?title=WikiCMS&action=slide]] | ||
+ | Wiki Content Management System | ||
+ | |[[File:QuizcardExample.jpeg|200px|frame|link=http://wiki.bitplan.com/index.php?title=SMWConTalk2016-09&action=slide|Using Semantic MediaWiki for managing quizzes for knowledge examination and evaluation]] | ||
+ | SMW Quiz | ||
+ | | [[File:officelogos.png|200px|frame|Office integragion=|link=http://wiki.bitplan.com/index.php?title=SMWConTalk2015-05&action=slide|Office integration]] | ||
+ | Smart and professional integration of office documents | ||
+ | | [[File:cat20170811_125134.jpg|200px|frame|Introduction to Semantic Concepts|link=http://wiki.bitplan.com/index.php?title=SMWConTalk2015-05-01&action=slide]] | ||
+ | Introduction to Semantic Concepts | ||
+ | [http://wiki.bitplan.com/index.php?title=SMWConTalk2015-05&action=slide smartMediaWiki] | ||
+ | |- | ||
+ | | [[File:IMG 0865 Shark.JPG|200px|frame|SMWCon Fall 2017 Rotterdam|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2017]] | ||
+ | SMWCon Fall 2017 Rotterdam | ||
+ | | [[File:FrauRauscher.png|200px|frame|SWMCon Fall 2016 Frankfurt|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016]] | ||
+ | SWMCon Fall 2016 Frankfurt | ||
+ | | [[File:fcb.png|200px|frame|SMWCon Fall 2015 Barcelona|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2015]] | ||
+ | SMWCon Fall 2015 Barcelona | ||
+ | | [[File:route66.png|200px|frame|SMWCon Spring 2016 St. Louis|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Spring_2015]]SMWCon Spring 2015 St. Louis | ||
+ | |} | ||
+ | |||
+ | ===⌘⌘ Agenda === | ||
+ | * What is a Graph? | ||
+ | * The Simple Graph Navigation Language Idea | ||
+ | * What is Apache TinkerPop/Gremlin? | ||
+ | * What is SimpleGraph? | ||
+ | * Example: Planning bike tours | ||
+ | |||
+ | ===⌘⌘ What is a graph? === | ||
+ | {{Link|target=Graph}} | ||
+ | <graphviz> | ||
+ | digraph Tuscany { | ||
+ | Tuscany [ URL="https://en.wikipedia.org/wiki/Tuscany" ] | ||
+ | |||
+ | Arezzo [ URL="https://en.wikipedia.org/wiki/Province_of_Arezzo" ] | ||
+ | Florence [ URL="https://en.wikipedia.org/wiki/Province_of_Florence" ] | ||
+ | Grossetto [ URL="https://en.wikipedia.org/wiki/Province_of_Grosseto" ] | ||
+ | Livorno [ URL="https://en.wikipedia.org/wiki/Province_of_Livorno" ] | ||
+ | Lucca [ URL="https://en.wikipedia.org/wiki/Province_of_Lucca" ] | ||
+ | Massa [ label="Massa and Carrara" URL="https://en.wikipedia.org/wiki/Province_of_Massa_and_Carrara" ] | ||
+ | Pisa [ URL="https://en.wikipedia.org/wiki/Province_of_Pisa" ] | ||
+ | Pistoia [ URL="https://en.wikipedia.org/wiki/Province_of_Pistoia" ] | ||
+ | Prato [ URL="https://en.wikipedia.org/wiki/Province_of_Prato" ] | ||
+ | Siena [ URL="https://en.wikipedia.org/wiki/Province_of_Siena" ] | ||
+ | |||
+ | Saturnia [ URL="https://en.wikipedia.org/wiki/Saturnia" ] | ||
+ | BagniDiLucca [ label="Bagni di Lucca" URL="https://de.wikipedia.org/wiki/Bagni_di_Lucca" ] | ||
+ | |||
+ | ThermalBath [URL="https://de.wikipedia.org/wiki/Liste_der_Thermalb%C3%A4der_in_der_Toskana"] | ||
+ | Provinces [ URL="https://en.wikipedia.org/wiki/Category:Provinces_of_Tuscany"] | ||
+ | |||
+ | ThermalBath -> Saturnia | ||
+ | ThermalBath -> BagniDiLucca | ||
+ | |||
+ | Saturnia -> Grossetto | ||
+ | BagniDiLucca -> Lucca | ||
+ | |||
+ | Provinces -> Tuscany | ||
+ | Tuscany -> ThermalBath | ||
+ | Arezzo -> Provinces | ||
+ | Florence -> Provinces | ||
+ | Grossetto -> Provinces | ||
+ | Livorno -> Provinces | ||
+ | Lucca -> Provinces | ||
+ | Massa -> Provinces | ||
+ | Pisa -> Provinces | ||
+ | Pistoia -> Provinces | ||
+ | Prato -> Provinces | ||
+ | Siena -> Provinces | ||
+ | } | ||
+ | </graphviz> | ||
+ | |||
+ | ===⌘⌘ The Simple Graph Navigation Language Idea === | ||
+ | * [http://wiki.bitplan.com/index.php/SiGNaL SiGNaL] | ||
+ | <graphviz> | ||
+ | digraph EM { | ||
+ | rankdir="LR" | ||
+ | Earth [ fontcolor="white" fontsize="32" URL="https://www.wikidata.org/wiki/Q2" image="Earth200.jpeg" ] | ||
+ | Moon [ fontcolor="white" fontsize="32" URL="https://www.wikidata.org/wiki/Q405" image="Moon200.jpeg" ] | ||
+ | Moon -> Earth [ label="orbits" fontsize="32"] | ||
+ | } | ||
+ | </graphviz> | ||
+ | |||
+ | ===⌘⌘ What is Apache TinkerPop/Gremlin? === | ||
+ | [[File:Gremlin programming language.png|400px]] | ||
+ | {{Link|target=http://tinkerpop.apache.org/|title=Apache Tinkerpop}} is an Open Source project. | ||
+ | * [https://en.wikipedia.org/wiki/Online_transaction_processing OLTP - Online Transaction Processing - Navigation and Processing] | ||
+ | * [https://en.wikipedia.org/wiki/Online_analytical_processing OLAP - Online Analytical Processing - Queries] | ||
+ | * [https://www.wikidata.org/wiki/Q79972 - Example - Ancestors of King James] | ||
+ | |||
+ | ==⌘⌘ What is SimpleGraph? == | ||
+ | [[File:toskana2019planning.png|800px|center|link=http://www.bitplan.com/index.php/SimpleGraph#Module_Hub_and_Spoke]] | ||
+ | |||
+ | == ⌘⌘ Example: Planning bike tours == | ||
+ | [[File:explore2018-06Portobello.png|300px|link=http://ebike.bitplan.com/index.php/Main_Page]] | ||
+ | |||
+ | * 2018: [http://wiki.bitplan.com/index.php/SPARQL#Whisky_Distilleries_in_Scotland_by_geographic_coordinates Scotland: Visiting Whisky-distilleries] | ||
+ | * 2019: [http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_in_Italy Tuscany: Visiting hotsprings/thermal bath] | ||
+ | Tools: | ||
+ | * [http://www.bitplan.com/index.php/SimpleGraph-HTML HTML (Web)] | ||
+ | * [http://wiki.bitplan.com/index.php/SimpleGraph-WikiData Wikidata (SPARQL)] | ||
+ | * [http://www.bitplan.com/index.php/SimpleGraph-MediaWiki Mediawiki (Wikipedia)] | ||
+ | * [http://wiki.bitplan.com/index.php/SimpleGraph-SMW Semantic Media Wiki] | ||
+ | * [http://wiki.bitplan.com/index.php/SimpleGraph-Excel Excel] | ||
+ | |||
+ | == ⌘⌘ SPARQL Query Hot Springs in Italy == | ||
+ | [https://query.wikidata.org/#%23%20Find%20Italian%20hot%20springs%20using%20the%20Wikidata%20Query%20service%0A%23%20taken%20from%0A%23%20http%3A%2F%2Fwiki.bitplan.com%2Findex.php%2FSPARQL%23Hotsprings_worldwide%0A%23%20Created%202018-11%20by%20Wolfgang%20Fahl%20BITPlan%20GmbH%0A%23%20%0A%23%20display%20the%20results%20as%20a%20map%0A%23defaultView%3AMap%0A%23%0A%23%20select%20the%20hot%20spring%20and%20its%20coordinates%0ASELECT%20%3Fhotspring%20%3Fcoord%20%3Frange%20WHERE%20%7B%0A%20%20%3Fhotspring%20wdt%3AP31%20wd%3AQ177380.%0A%20%20%3Fhotspring%20%3Frange%20wd%3AQ38.%0A%20%20%3Fhotspring%20wdt%3AP625%20%3Fcoord.%0A%7D%0A try it!] | ||
+ | [[File:MapOfThermalBathsTuscanyWikiData.png|400px|left]] | ||
<source lang='sparql'> | <source lang='sparql'> | ||
# Find Italian hot springs using the Wikidata Query service | # Find Italian hot springs using the Wikidata Query service | ||
+ | # display the results as a map | ||
+ | #defaultView:Map | ||
+ | # select the hot spring and its coordinates | ||
+ | SELECT ?hotspring ?coord ?range WHERE { | ||
+ | ?hotspring wdt:P31 wd:Q177380. | ||
+ | ?hotspring ?range wd:Q38. | ||
+ | ?hotspring wdt:P625 ?coord. | ||
+ | } | ||
+ | </source> | ||
+ | |||
+ | == ⌘⌘ SPARQL Query Hotsprings in Tuscany == | ||
+ | [https://query.wikidata.org/#%23%20Find%20Tuscany%20hot%20springs%20using%20the%20Wikidata%20Query%20service%0A%23%20taken%20from%0A%23%20http%3A%2F%2Fwiki.bitplan.com%2Findex.php%2FSPARQL%23Hotsprings_tuscany%0A%23%20Created%202018-12-07%20by%20Wolfgang%20Fahl%20BITPlan%20GmbH%0A%23%20%0A%23%20display%20the%20results%20as%20a%20map%0A%23defaultView%3AMap%0A%23%0A%23%20select%20the%20hot%20spring%20and%20its%20coordinates%0ASELECT%20%3Fhotspring%20%3Fcoord%20%20WHERE%20%7B%0A%20%20%23%20Ravenna%0A%20%20wd%3AQ13364%20wdt%3AP625%20%3FNECorner%20.%0A%20%20%23%20Aleria%20Corsica%0A%20%20wd%3AQ212399%20%20wdt%3AP625%20%3FSWCorner%20.%0A%20%20%3Fhotspring%20wdt%3AP31%20wd%3AQ177380.%0A%20%20%3Fhotspring%20wdt%3AP625%20%3Fcoord.%0A%20%20SERVICE%20wikibase%3Abox%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP625%20%3Fcoord%20.%0A%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3AcornerSouthWest%20%3FSWCorner%20.%0A%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3AcornerNorthEast%20%3FNECorner%20.%0A%20%20%20%20%7D%0A%7D%0A try it!] | ||
+ | <source lang='sparql'> | ||
+ | # Find Tuscany hot springs using the Wikidata Query service | ||
# taken from | # taken from | ||
− | # http://wiki.bitplan.com/index.php/SPARQL# | + | # http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_tuscany |
− | # Created 2018- | + | # Created 2018-12-07 by Wolfgang Fahl BITPlan GmbH |
# | # | ||
# display the results as a map | # display the results as a map | ||
Line 9: | Line 155: | ||
# | # | ||
# select the hot spring and its coordinates | # select the hot spring and its coordinates | ||
− | SELECT ?hotspring ?coord | + | SELECT ?hotspring ?coord WHERE { |
+ | # Ravenna | ||
+ | wd:Q13364 wdt:P625 ?NECorner . | ||
+ | # Aleria Corsica | ||
+ | wd:Q212399 wdt:P625 ?SWCorner . | ||
?hotspring wdt:P31 wd:Q177380. | ?hotspring wdt:P31 wd:Q177380. | ||
− | |||
?hotspring wdt:P625 ?coord. | ?hotspring wdt:P625 ?coord. | ||
+ | SERVICE wikibase:box { | ||
+ | ?item wdt:P625 ?coord . | ||
+ | bd:serviceParam wikibase:cornerSouthWest ?SWCorner . | ||
+ | bd:serviceParam wikibase:cornerNorthEast ?NECorner . | ||
+ | } | ||
} | } | ||
</source> | </source> | ||
+ | == ⌘⌘ Combining 5 modules == | ||
+ | [[File:NiftyExcelTrick.png|400px|right]] | ||
+ | |||
+ | #[https://github.com/BITPlan/com.bitplan.simplegraph/blob/master/simplegraph-bundle/src/test/java/com/bitplan/simplegraph/bundle/TestThermalBathInTuscany.java SimpleGraph-Bundle Junit TestCase] | ||
+ | #[[:File:TuscanyPlan2018-12-13.xlsx]] | ||
+ | |||
+ | == ⌘⌘ Outlook: Dragtop == | ||
+ | [[File:DragTopExample1.png|400px|left]] | ||
+ | The [http://www.bitplan.com/index.php/Dragtop Dragtop Open Source Software] makes the [http://www.bitplan.com/index.php/SimpleGraph SimpleGraph] modules available for direct access from your Desktop. | ||
+ | By simple drag and drop of the input onto the dragtop and then dropping a "tool" onto the dragtop you can combine the module functionality as you see fit. | ||
+ | |||
+ | == ⌘⌘ Questions/Discussion == | ||
+ | [[File:Bitplanpartner.png]] | ||
+ | <youtube>PiNJZ4vg5ts</youtube> | ||
+ | |||
+ | http://wiki.bitplan.com |
Latest revision as of 11:47, 13 December 2018
<slideshow style="bitplan" headingmark="⌘⌘" incmark="…" scaled="true" font="Comic Sans MS, Calibri, cursive" >
- title
SimpleGraph Semantic Media Wiki Module- author
- Wolfgang Fahl info@bitplan.com
- footer
- Integrating Semantic Media Wiki with multiple other systems via Apache TinkerPop/Gremlin
- subfooter
- SMW CON Fall 2018 Regensburg
</slideshow>
⌘⌘ Wolfgang Fahl
| |
Peugeot Ion |
Giant Explore |
⌘⌘ Previous SMW Talks
Wiki Content Management System |
SMW Quiz |
Smart and professional integration of office documents |
Introduction to Semantic Concepts smartMediaWiki |
SMWCon Fall 2017 Rotterdam |
SWMCon Fall 2016 Frankfurt |
SMWCon Fall 2015 Barcelona |
SMWCon Spring 2015 St. Louis |
⌘⌘ Agenda
- What is a Graph?
- The Simple Graph Navigation Language Idea
- What is Apache TinkerPop/Gremlin?
- What is SimpleGraph?
- Example: Planning bike tours
⌘⌘ What is a graph?
⌘⌘ What is Apache TinkerPop/Gremlin?
Apache Tinkerpop is an Open Source project.
- OLTP - Online Transaction Processing - Navigation and Processing
- OLAP - Online Analytical Processing - Queries
- - Example - Ancestors of King James
⌘⌘ What is SimpleGraph?
⌘⌘ Example: Planning bike tours
Tools:
⌘⌘ SPARQL Query Hot Springs in Italy
# Find Italian hot springs using the Wikidata Query service
# display the results as a map
#defaultView:Map
# select the hot spring and its coordinates
SELECT ?hotspring ?coord ?range WHERE {
?hotspring wdt:P31 wd:Q177380.
?hotspring ?range wd:Q38.
?hotspring wdt:P625 ?coord.
}
⌘⌘ SPARQL Query Hotsprings in Tuscany
# Find Tuscany hot springs using the Wikidata Query service
# taken from
# http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_tuscany
# Created 2018-12-07 by Wolfgang Fahl BITPlan GmbH
#
# display the results as a map
#defaultView:Map
#
# select the hot spring and its coordinates
SELECT ?hotspring ?coord WHERE {
# Ravenna
wd:Q13364 wdt:P625 ?NECorner .
# Aleria Corsica
wd:Q212399 wdt:P625 ?SWCorner .
?hotspring wdt:P31 wd:Q177380.
?hotspring wdt:P625 ?coord.
SERVICE wikibase:box {
?item wdt:P625 ?coord .
bd:serviceParam wikibase:cornerSouthWest ?SWCorner .
bd:serviceParam wikibase:cornerNorthEast ?NECorner .
}
}
⌘⌘ Combining 5 modules
⌘⌘ Outlook: Dragtop
The Dragtop Open Source Software makes the SimpleGraph modules available for direct access from your Desktop. By simple drag and drop of the input onto the dragtop and then dropping a "tool" onto the dragtop you can combine the module functionality as you see fit.