Difference between revisions of "SimpleGraph Semantic Media Wiki Module"

From BITPlan E-Bike Wiki
Jump to navigation Jump to search
 
(80 intermediate revisions by the same user not shown)
Line 6: Line 6:
 
;subfooter: [https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2018 SMW CON Fall 2018 Regensburg]
 
;subfooter: [https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2018 SMW CON Fall 2018 Regensburg]
 
</slideshow>
 
</slideshow>
==⌘⌘ Intro ==
 
  
[[File:Saturnia_Cascate_del_Mulino.jpg|800px]]
 
 
Von Markus Bernet - Eigenes Werk, CC BY-SA 2.5, [https://commons.wikimedia.org/w/index.php?curid=1137376 File:Saturnia Cascate del Mulino.jpg]
 
 
=== ⌘⌘ Wolfgang Fahl ===
 
=== ⌘⌘ Wolfgang Fahl ===
 
[[File:Wfjuggling.png|left]]
 
[[File:Wfjuggling.png|left]]
* [http://semantic-mediawiki.org/wiki/User:WolfgangFahl Wolfgang] [mailto:wf@bitplan.com wf@bitplan.com] is from germany.  
+
{|
* He is a teacher for software architecture
+
|-
* He has been working with MediaWiki since 2007
+
|colspan="2"|
* He has started learning english in England
+
* [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 ===
 
=== ⌘⌘ Previous SMW Talks ===
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
! Topic !! SMWCon
+
| [[File:wikicms.png|200px|frame|WikiCMS|link=http://royal-family.bitplan.com/index.php?title=WikiCMS&action=slide]]  
|-
+
Wiki Content Management System
| [[File:wikicms.png|300px|frame|WikiCMS|link=http://royal-family.bitplan.com/index.php?title=WikiCMS&action=slide]]  
+
|[[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]]
| [[File:IMG 0865 Shark.JPG|300px|frame|SMWCon Fall 2017 Rotterdam|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2017]]
+
SMW Quiz
|-
+
| [[File:officelogos.png|200px|frame|Office integragion=|link=http://wiki.bitplan.com/index.php?title=SMWConTalk2015-05&action=slide|Office integration]]
|[[File:QuizcardExample.jpeg|200px|frame|Using Semantic MediaWiki for managing quizzes for knowledge examination and evaluation]]
+
Smart and professional integration of office documents
| SWMCon Fall 2016 Frankfurt
+
| [[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]
 
|-
 
|-
| Smart and professional integration of office documents
+
| [[File:IMG 0865 Shark.JPG|200px|frame|SMWCon Fall 2017 Rotterdam|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2017]]
| [[File:fcb.png|300px|frame|SMWCon Fall 2015 Barcelona|link=link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2015]]
+
SMWCon Fall 2017 Rotterdam
|-
+
| [[File:FrauRauscher.png|200px|frame|SWMCon Fall 2016 Frankfurt|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2016]]
| smartMediaWiki || SMWCon Spring 2015 St. Louis
+
SWMCon Fall 2016 Frankfurt
|-
+
| [[File:fcb.png|200px|frame|SMWCon Fall 2015 Barcelona|link=https://www.semantic-mediawiki.org/wiki/SMWCon_Fall_2015]]
| Introduction to Semantic Concepts || SWMCon Spring 2015 St. Louis
+
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 ===
 
===⌘⌘ Agenda ===
 +
* What is a Graph?
 +
* The Simple Graph Navigation Language Idea
 
* What is Apache TinkerPop/Gremlin?
 
* What is Apache TinkerPop/Gremlin?
 
* What is SimpleGraph?
 
* What is SimpleGraph?
* Example: Planning a bike tour to tuscany thermal baths
+
* Example: Planning bike tours
== ⌘⌘ SPARQL Query ==
+
 
 +
===⌘⌘ 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!]
 
[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
# taken from
 
# http://wiki.bitplan.com/index.php/SPARQL#Hotsprings_in_Italy
 
# Created 2018-11 by Wolfgang Fahl BITPlan GmbH
 
#
 
 
# display the results as a map
 
# display the results as a map
 
#defaultView:Map
 
#defaultView:Map
#
 
 
# select the hot spring and its coordinates
 
# select the hot spring and its coordinates
 
SELECT ?hotspring ?coord ?range WHERE {
 
SELECT ?hotspring ?coord ?range WHERE {
Line 60: Line 143:
 
</source>
 
</source>
  
== Hotsprings in Tuscany ==
+
== ⌘⌘ 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'>
 
<source lang='sparql'>
 
# Find Tuscany hot springs using the Wikidata Query service
 
# Find Tuscany hot springs using the Wikidata Query service
Line 85: Line 169:
 
}
 
}
 
</source>
 
</source>
 +
== ⌘⌘ Combining 5 modules ==
 +
[[File:NiftyExcelTrick.png|400px|right]]
  
== ⌘⌘ Thermal Baths ==
+
#[https://github.com/BITPlan/com.bitplan.simplegraph/blob/master/simplegraph-bundle/src/test/java/com/bitplan/simplegraph/bundle/TestThermalBathInTuscany.java SimpleGraph-Bundle Junit TestCase]
<youtube>PiNJZ4vg5ts</youtube>
+
#[[: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 ==
 
== ⌘⌘ Questions/Discussion ==
 
[[File:Bitplanpartner.png]]
 
[[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 ModuleProfiwikiicon.png
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

Wfjuggling.png
Peugeot Ion
Peugeot Ion
Giant Explore
Giant Explore

⌘⌘ Previous SMW Talks

WikiCMS

Wiki Content Management System

Using Semantic MediaWiki for managing quizzes for knowledge examination and evaluation

SMW Quiz

Office integration

Smart and professional integration of office documents

Introduction to Semantic Concepts

Introduction to Semantic Concepts smartMediaWiki

SMWCon Fall 2017 Rotterdam

SMWCon Fall 2017 Rotterdam

SWMCon Fall 2016 Frankfurt

SWMCon Fall 2016 Frankfurt

SMWCon Fall 2015 Barcelona

SMWCon Fall 2015 Barcelona

SMWCon Spring 2016 St. Louis
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?

Graph

⌘⌘ The Simple Graph Navigation Language Idea

⌘⌘ What is Apache TinkerPop/Gremlin?

Gremlin programming language.png Apache Tinkerpop is an Open Source project.

⌘⌘ What is SimpleGraph?

Toskana2019planning.png

⌘⌘ Example: Planning bike tours

Explore2018-06Portobello.png

Tools:

⌘⌘ SPARQL Query Hot Springs in Italy

try it!

MapOfThermalBathsTuscanyWikiData.png
# 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

try it!

# 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

NiftyExcelTrick.png
  1. SimpleGraph-Bundle Junit TestCase
  2. File:TuscanyPlan2018-12-13.xlsx

⌘⌘ Outlook: Dragtop

DragTopExample1.png

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.

⌘⌘ Questions/Discussion

Bitplanpartner.png

http://wiki.bitplan.com