From Model Interoperability
to Data Transformation
Steve Grise
ESRI
Overview
• Detailed approach for Schema
mapping for Euroroads example
• Interoperability and semantics
tools
• Some attempts at answers to
questions
2
EuroRoads for Geodatabase
• Created EuroRoads Geodatabase UML,
exported to XMI, used ArcCatalog
Schema wizard to create Geodatabase
• Started with Canadian National Road
Network (NRN) data in GML
• Mapped schema from NRN to EuroRoad
target (data interoperability extension)
• Downloaded GML sample for the Yukon
Territory
• Created geoprocessing model to load
the Yukon data into the model
• Used XML Schema tools in ArcGIS to
create export dataset
3
EuroRoads for Geodatabase
• Usually start with an Analysis Diagram
– Simplified UML
– Stepping stone between ideas and
implementation
– Example from Ontario roads prototype
below
– Would do Analysis Diagram to handle the
more complex event/attributes for
implementation model for EuroRoadS
R o a d L in e E v e n t
R o a d J u ris d ic tio n
R o a d Ju risd ictio n ID
R o a d Ju risd ictio n
R o a d Ju risd ictio n Z o n e
N u m b e rO fL a n e
N u m b e rO fLa n e s
RoadNam e
R o a d N a m e ID
D e scrip tio n
R o a d N a m e In d ica to r
R o a d S tre e tN a m e
R o a d S tre e tD ire ctio n P re fix
R o a d S tre e tD ire ctio n
R o a d S tre e tT yp e
R o a d Ju risd ictio n ID fk
4
EuroRoads for Geodatabase
E S R I C la sse s ::F e a tu re
CASE Tool UML
+ S h a p e : e sriF ie ld T yp e G e o m e try
E R _ R o a d F e a tu re
-P e rm a n e n tID : e sriF ie ld T yp e S trin g
-V e rsio n ID : e sriF ie ld T yp e S trin g
-A lte rn a te ID : e sriF ie ld T yp e S trin g
E R _ R o a d n e tL in k
-S ta rtD a te T im e : e sriF ie ld T yp e D a te
-E n d D a te T im e : e sriF ie ld T yp e D a te
ER _R oadN ode
E R _ R o a d L in k
E R _ F e rry L in k
-E R _ L e ve l : E R _ R o a d N o d e L e ve l = E R _ Ju n ctio n
-F o rm O fN o d e : E R _ F o rm O fN o d e = E R _ R o u n d a b o u t
-E R _ L e ve l : E R _ R o a d L in kL e ve l = E R _ R o a d E le m e n t
-F o rm O fW a y : E R _ F o rm O fW a y = E R _ S in g le C a rria g e w a y
-N a tio n a lR o a d C la ss : E R _ N a tio n a lR o a d C la ss = E R _ M a in R o a d
-E R _ L e ve l : E R _ F e rryL in kL e ve l = E R _ F e rry
-F o rm O fF e rry : E R _ F o rm O fF e rry = E R _ T ra in
5
EuroRoads for Geodatabase
« C o d e d V a lu e D o m a in » E R _ R o a d N o d e L e v e l
« C o d e d V a lu e D o m a in » E R _ R o a d L in k L e v e l
« C o d e d V a lu e D o m a in » E R _ F e rry L in k L e v e l
+ F ie ld T yp e : e sriF ie ld T yp e = e sriF ie ld T yp e S trin g
+ M e rg e P o licy : e sriM e rg e P o licyT yp e = e sriM P T D e fa u ltV a lu e
+ S p litP o licy : e sriS p litP o licyT yp e = e sriS P T D e fa u ltV a lu e
+ E R _ Ju n ctio n : < u n sp e cifie d > = E R _ Ju n ctio n
+ E R _ In te rse ctio n : < u n sp e cifie d > = E R _ In te rse ctio n
+ F ie ld T yp e : e sriF ie ld T yp e = e sriF ie ld T yp e S trin g
+ M e rg e P o licy : e sriM e rg e P o licyT yp e = e sriM P T D e fa u ltV a lu e
+ S p litP o licy : e sriS p litP o licyT yp e = e sriS P T D e fa u ltV a lu e
+ E R _ R o a d E le m e n t : < u n sp e cifie d > = E R _ R o a d E le m e n t
+ E R _ R o a d : < u n sp e cifie d > = E R _ R o a d
+ F ie ld T yp e : e sriF ie ld T yp e = e sriF ie ld T yp e S trin g
+ M e rg e P o licy : e sriM e rg e P o licyT yp e = e sriM P T D e fa u ltV a lu e
+ S p litP o licy : e sriS p litP o licyT yp e = e sriS P T D e fa u ltV a lu e
+ E R _ F e rryC o n n e ctio n : < u n sp e cifie d > = E R _ F e rryC o n n e ctio n
+ E R _ F e rry : < u n sp e cifie d > = E R _ F e rry
« C o d e d V a lu e D o m a in » E R _ F o rm O fN o d e
+ F ie ld T yp e : e sriF ie ld T yp e = e sriF ie ld T yp e S trin g
+ M e rg e P o licy : e sriM e rg e P o licyT yp e = e sriM P T D e fa u ltV a lu e
+ S p litP o licy : e sriS p litP o licyT yp e = e sriS P T D e fa u ltV a lu e
+ E R _ R o u n d a b o u t : < u n sp e cifie d > = E R _ R o u n d a b o u t
+ E R _ E n clo se d T ra fficA re a : < u n sp e cifie d > = E R _ E n clo se d T ra fficA re a
+ E R _ P se u d o N o d e : < u n sp e cifie d > = E R _ P se u d o N o d e
+ E R _ G ra d e S e p a ra te d C ro ssin g : < u n sp e cifie d > = E R _ G ra d e S e p a ra te d C ro ssin g
« C o d e d V a lu e D o m a in » E R _ F o rm O fF e rry
CASE Tool UML
+ F ie ld T yp e : e sriF ie ld T yp e = e sriF ie ld T yp e S trin g
+ M e rg e P o licy : e sriM e rg e P o licyT yp e = e sriM P T D e fa u ltV a lu e
+ S p litP o licy : e sriS p litP o licyT yp e = e sriS P T D e fa u ltV a lu e
+ E R _ S h ip O rH o ve rcra ft : < u n sp e cifie d > = E R _ S h ip O rH o ve rcra ft
+ E R _ T ra in : < u n sp e cifie d > = E R _ T ra in
« C o d e d V a lu e D o m a in » E R _ F o rm O fW a y
« C o d e d V a lu e D o m a in » E R _ N a tio n a lR o a d C la s s
+ F ie ld T yp e : e sriF ie ld T yp e = e sriF ie ld T yp e S trin g
+ M e rg e P o licy : e sriM e rg e P o licyT yp e = e sriM P T D e fa u ltV a lu e
+ S p litP o licy : e sriS p litP o licyT yp e = e sriS P T D e fa u ltV a lu e
+ E R _ M o to rw a y : < u n sp e cifie d > = E R _ M o to rw a y
+ E R _ M u ltiC a rria g e W a y : < u n sp e cifie d > = E R _ M u ltiC a rria g e W a y
+ E R _ R o u n d a b o u tC ircle : < u n sp e cifie d > = E R _ R o u n d a b o u tC ircle
+ E R _ T ra fficS q u a re : < u n sp e cifie d > = E R _ T ra fficS q u a re
+ E R _ E n clo se d T ra fficA re a : < u n sp e cifie d > = E R _ E n clo se d T ra fficA re a
+ E R _ S lip R o a d : < u n sp e cifie d > = E R _ S lip R o a d
+ E R _ S e rvice R o a d : < u n sp e cifie d > = E R _ S e rvice R o a d
+ E R _ E n tra n ce O rE xitC a rP a rk : < u n sp e cifie d > = E R _ E n tra n ce O rE xitC a rP a rk
+ E R _ E n tra n ce O rE xitS e rvice : < u n sp e cifie d > = E R _ E n tra n ce O rE xitS e rvice
+ E R _ U n d e fin e d F o rm O fW a y : < u n sp e cifie d > = E R _ U n d e fin e d F o rm O fW a y
+ E R _ S in g le C a rria g e w a y : < u n sp e cifie d > = E R _ S in g le C a rria g e w a y
+ F ie ld T yp e : e sriF ie ld T yp e = e sriF ie ld T yp e S trin g
+ M e rg e P o licy : e sriM e rg e P o licyT yp e = e sriM P T D e fa u ltV a lu e
+ S p litP o licy : e sriS p litP o licyT yp e = e sriS P T D e fa u ltV a lu e
+ E R _ M a in R o a d : < u n sp e cifie d > = E R _ M a in R o a d
+ E R _ F irstC la ss : < u n sp e cifie d > = E R _ F irstC la ss
+ E R _ S e co n d C la ss : < u n sp e cifie d > = E R _ S e co n d C la ss
+ E R _ T h ird C la ss : < u n sp e cifie d > = E R _ T h ird C la ss
+ E R _ F o u rth C la ss : < u n sp e cifie d > = E R _ F o u rth C la ss
+ E R _ F ifth C la ss : < u n sp e cifie d > = E R _ F ifth C la ss
+ E R _ S ixth C la ss : < u n sp e cifie d > = E R _ S ixth C la ss
+ E R _ S e ve n th C la ss : < u n sp e cifie d > = E R _ S e ve n th C la ss
+ E R _ E ig h th C la ss : < u n sp e cifie d > = E R _ E ig h th C la ss
+ E R _ N in th C la ss : < u n sp e cifie d > = E R _ N in th C la ss
+ E R _ T e n th C la ss : < u n sp e cifie d > = E R _ T e n th C la ss
+ E R _ U n d e fin e d N a tio n a lR o a d C la ss : < u n sp e cifie d > = E R _ U n d e fin e d N a tio n a lR o a d C la ss
6
EuroRoads for Geodatabase
• Mapping File (Road Node)
7
EuroRoads for Geodatabase
8
EuroRoads for Geodatabase
9
EuroRoads for Geodatabase
• XML Schema excerpt
10
Semantic Interoperability
Catalogs and Searching
• Search support
– Thesauri
– English/other Languages
– Geo
– Euro SDI
– Key is management of terms and
relationships between concepts in real
datasets
– W3C and other standards exist
– Some key geo pieces missing
– Standards needed in this area
• Basically the same problem as
conceptual schema mapping, but done
at the dataset/catalog level (and the
feature level)
12
W3C Options
• XML Schema
– Structure/hierarchies, i.e. “Family”
• Resource Description Framework
(RDF), (RDFS)
– “Parents and children”
• Ontology Web Language (OWL)
– “Cousins” and other more complex
relationships
13
Results
• Better search results
– “parcel” search returns “Cadastre”
– “Cadastral” search returns “Parcel”,
“Corner”, other datasets
– Some basic structure / semantics
missing for Geo
– Alexandria Digital Library
– ISO Categories
– … are both too general for Semantic Web
needs (maybe even basic searches)
14
A Few Tools
• Protégé
– Stanford, Open Source
– Developed for medical ontology work
(initially)
– protégé.stanford.edu
• LegendBurster
– GeoReference Online, Commercial
tools
– Developed for mineral exploration
market (initially)
– www.georeferenceonline.com
15
Protégé Example
16
LegendBurster Example
• TreeList Editor
– Standalone tool
• Query Tools
– Complex searches
– Results stored as attribute
– Complex mapping results
17
LegendBurster Example
18
Summary
• Euroroads schema mapping
– Implementation tools available
– Alternative approach
– Uml-xmi-gdb-xml (+ other)
• Need to work on semantics and
relationships between datasets
– Important for searching
– Tools available
– Small group should try to manage
relationships
19
Q&A
• Do conceptual modeling languages satisfy Geo
needs?
– UML missing spatial patterns
– UML probably too complex for most people
– No other current alternative for graphical
representation
– Need to add simple, graphical examples to aid
communication and comprehension
– Consider information products and demonstration
systems now, in parallel with CSL work
• Harmonize?
– Content, not necessarily CSL
– Keep it simple at first
– Meta model for cataloging and searching between
terms
– Watch for mixing of concepts and formats
20
Q&A
• Is a common conceptual schema
needed?
– Challenge is to be convinced that it
adds value, makes things easier for
partners/designers
– Should target more broad audience
than Euro community
• UML extensions feasible?
– Conceptual models – yes
– Transition to logical models should
be considered
21
Q&A
• Representing constraints?
– Difficult to get agreement on behavior other
than basic data integrity constraints
– Suggest keep this as simple as possible
– Different technologies and architectures means
major differences in logical models
• Relationship to Ontologies?
– Catalog/search tool problem for a small
group of people
– Start work on this now in parallel with other
activities
22
Descargar

ESDI Workshop