Apresenta

1
Towards a Web Service for Geographic and
Multidimensional Processing
Joel da Silva Valéria Cesário Times Robson
Fidalgo Roberto Barros js,vct,rdnf,roberto_at_cin.u
fpe.br
Center for Informatics Federal University of
Pernambuco (Cin/UFPE)
2
Presentation Contents

• Introduction
• Related Work
• Web Services Architecture
• The Architecture of the XML For Analysis (XMLA)
  and Web Feature Service (WFS)
• Mapping the correspondences between the WFS and
  XMLA services
• GMLA Request Schema
• ISAG Model
• GMLA Web Service
• Conclusions

3
Introduction
4
Related Work

• A lot of research has been developed for
  integrating analytic and geographic processing
• The main goal is to provide an environment for
  geographic and multidimensional processing
• However, this integration may not be fully
  achieved yet or may be built by using proprietary
  technologies

5
GOLAPA (Geographical On-Line Analytical
Processing Architecture )
6
Geography Markup Language for Analysis - GMLA
Schema
7
Web Services Architecture

• Distributed computational architecture based on
  auto descriptive services
• Web Services are based on the XML Technology and
  can be published, located and executed over the
  Web
• The WS Architecture have four basic standards
• 1 XML eXtensible Markup Language
• 2 SOAP Simple Object Application
  Protocol
• 3 UDDI Universal Description, Discover
  and Integration
• 4 WSDL Web Services Description Language

8
(No Transcript)
9
The XML For Analysis Service

• XML For Analysis (XMLA) is based on the Web
  Services and XML Technologies to enable the OLAP
  processing over the Web
• XMLA was created by an initiative of the
  Microsoft and Hyperion to provide an open access
  for multidimensional databases
• This standardized access enables a
  non-proprietary communication between client
  applications and OLAP data servers through the
  Internet

10
Web Feature Service (WFS) Architecture

• The WFS is a OGC Specification that provides
  some interfaces for the description of operations
  used to manipulate geographic features over the
  Web
• The geographic features are spatial objects that
  must at least contain one geometric property and
  may have one or more descriptive properties
• The geographic features are coded in Geographic
  Markup Language

11
Mapping of the WFS and XMLA Specifications
Correspondences
12
GMLA Request Schema
13
A Model for the Integration of Analitycal and
Geographical Services (ISAG)
14
GMLA Web Service Architecture
15
Example of a Integration GEOMD Request
ltGmlaRequest xmlnsxsi"http//www.w3.org/2001/XML
Schema-instance" xsinoNamespaceSchemaLocation"D
\GMLARequest.xsd"gt ltGEOMDgt ltGEOMDSchemagtGOLAPA
GMDM001lt/GEOMDSchemagt ltMDgt ltXMLAServiceAddres
sgthttp//localhost/xmla/msxisapi.dlllt/XMLAServiceA
ddressgt ltXMLAMethodgtExecutelt/XMLAMethodgt ltOL
APCubegtSaleslt/OLAPCubegt ltCommandgt ltStatemen
tgt SELECT NON EMPTY(DRILLDOWNLEVEL(Store.S
tore Country.members)) ON COLUMNS,NON
EMPTY(Product.Product Family.members) ON ROWS
FROM Sales lt/Statementgt lt/Comman
dgt ltPropertiesgt ltPropertyListgt ltDataSo
urceInfogtProviderMSOLAPData Sourcelocal
lt/DataSourceInfogt ltCataloggtFoodmart
2000lt/Cataloggt ltFormatgtMultidimensionallt/Form
atgt ltAxisFormatgtTupleFormatlt/AxisFormatgt
lt/PropertyListgt lt/Propertiesgt lt/MDgt ...
16
Example of a Integration GEOMD
Request (Continuation)
...
ltGEOgt ltWFSServiceAddressgthttp//localhost
8080/deegreewfs/deegreewfslt/WFSServiceAddressgt
ltGeoDBgtUsaGeoDBlt/GeoDBgt ltGeoSpacegtUSAGeoSpacelt/
GeoSpacegt ltGeoViewgtUSAGeoViewlt/GeoViewgt ltGet
Featuregt ltwfsGetFeature outputFormat"GML2"
xmlnsgml"http//www.opengis.net/gml"
xmlnswfs"http//www.opengis.net/wfs"
xmlnsogc"http//www.opengis.net/ogc"gt
ltwfsQuery typeName"Country"gt lt/wfsQuerygt lt
wfsQuery typeName"States"gt ltogcFiltergt
ltogcBBOXgt ltwfsPropertyNamegt/States/
Borderlt/wfsPropertyNamegt ltgmlBoxgt
ltgmlcoordgt ltgmlXgt-124.73276978lt/gml
Xgt ltgmlYgt48.99993133lt/gmlYgt
lt/gmlcoordgt ltgmlcoordgt ltgmlX
gt-117.2084lt/gmlXgt ltgmlYgt43.0081lt/gmlY
gt lt/gmlcoordgt lt/gmlBoxgt
lt/ogcBBOXgt lt/ogcFiltergt lt/wfsQuerygt
lt/wfsGetFeaturegt lt/GetFeaturegt lt/GEOgt lt
/GEOMDgt lt/GmlaRequestgt
17
Graphic Visualization of a Integration GEOMD
Request
Features that satisfy the BBOX spatial operator
18
Conclusions

• The integration between analytic and geographic
  processing as a single tool provides a wider
  context for decision support
• Only open and extensible technologies have been
  used in the specification and implementation of
  the integration model
• The layer II of GOLAPA Architecture has been
  implemented
• The presented solutions may be used by some other
  work that aim to integrate GIS and OLAP.

19
Main contributions

• Mapping between the WFS and XMLA services
• GMLA Request Schema
• ISAG Model
• GMLA Web Service
• Graphic User Interface Prototype

20
(No Transcript)