Center for Informatics Federal University of Pernambuco (Cin/UFPE)

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}@cin.ufpe.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. XML Web Services JAVA XML Schema XSLT UDDI Java Script JMI XMI SOAP SVG XPath HTTP Java Servlet XLink WSDL JWSDP GML XPointer GLUE GOLAPA OLAP GIS DSS SDSS GMLA Request Schema GAM Slice/Dice GDW GeoMDM ISAG Geographical DB GeoMD Features Rotate/Pivot GMLA Schema Drill-Down/Drill-Up GMLA WS DW Spatial Operators Metadata XMLA BBox Filter Encoding MDR Execute MOF DescribeFeatureType WFS MDX Overlaps Discover CWM Equals Properties RequestType Contains MetadataAccess OMG Intersects mdXML Restrictions GetFeature MetadataManager GetCapabilities 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. Data, Services and Graphic User Interface Support to operational data ..........and building of the ........Geographic Data Warehouse GOLAPA (Geographical On-Line Analytical Processing Architecture )

6. XMLA GML 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

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 XMLASpecifications Correspondences

12. New Elements MD: Multidimensional Request XMLA New Elements GEO: Geographical Request WFS / Filter Encoding GEOMD: Geographical Multidimensional Request - Mapping or Integration New Element GMLA Request Schema

13. A Model for the Integration of Analitycal and Geographical Services (ISAG)

14. GMLA Web Service Architecture

15. Multidimensional Expression: List the totals of product sales, classifying the result by product category and by state and country where the sales were made Example of a Integration GEOMD Request <GmlaRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="D:\GMLARequest.xsd"> <GEOMD> <GEOMDSchema>GOLAPAGMDM001</GEOMDSchema> <MD> <XMLAServiceAddress>http://localhost/xmla/msxisapi.dll</XMLAServiceAddress> <XMLAMethod>Execute</XMLAMethod> <OLAPCube>Sales</OLAPCube> <Command> <Statement> SELECT NON EMPTY(DRILLDOWNLEVEL([Store].[Store Country].members)) ON COLUMNS,NON EMPTY([Product].[Product Family].members) ON ROWS FROM Sales </Statement> </Command> <Properties> <PropertyList> <DataSourceInfo>Provider=MSOLAP;Data Source=local </DataSourceInfo> <Catalog>Foodmart 2000</Catalog> <Format>Multidimensional</Format> <AxisFormat>TupleFormat</AxisFormat> </PropertyList> </Properties> </MD> ...

16. Definition of the Feature Type (Themes) that will be present in the request Filter Expression with the BBOX Spatial Operator Example of a Integration GEOMD Request (Continuation) ... <GEO> <WFSServiceAddress>http://localhost:8080/deegreewfs/deegreewfs</WFSServiceAddress> <GeoDB>UsaGeoDB</GeoDB> <GeoSpace>USAGeoSpace</GeoSpace> <GeoView>USAGeoView</GeoView> <GetFeature> <wfs:GetFeature outputFormat="GML2" xmlns:gml="http://www.opengis.net/gml" xmlns:wfs="http://www.opengis.net/wfs" xmlns:ogc="http://www.opengis.net/ogc"> <wfs:Query typeName="Country"></wfs:Query> <wfs:Query typeName="States"> <ogc:Filter> <ogc:BBOX> <wfs:PropertyName>/States/Border</wfs:PropertyName> <gml:Box> <gml:coord> <gml:X>-124.73276978</gml:X> <gml:Y>48.99993133</gml:Y> </gml:coord> <gml:coord> <gml:X>-117.2084</gml:X> <gml:Y>43.0081</gml:Y> </gml:coord> </gml:Box> </ogc:BBOX> </ogc:Filter> </wfs:Query> </wfs:GetFeature> </GetFeature> </GEO> </GEOMD> </GmlaRequest>

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