DaWeS: Data Warehouse fed with Web Services

We present a prototype, called DaWeS, which is a Data Warehouse fed with Web

Services. The main feature of DaWeS is to use a mediation approach (data integration without

materialization) as the ETL tool (data extraction, transformation and loading). This approach

enables to automate many steps of the ETL process, while facilitating human interventions by

exclusively relying on declarative languages (datalog queries, SQL, XSD, XSLT). The context

of this work consists of the mostly used (because the simplest) web services standards (HTML,

HTTP, REST, XML, JSON), and not of the more complex but less used ones (SOAP, UDDI,

WSDL, SA-WSDL, OWL-S, hRESTS). In terms of applications, the aim is to allow a DaWeS

administrator to provide to small and medium companies a service to store and query their

business data coming from their usage of third-party services, without having to manage their

own warehouse. In particular, DaWeS enables the easy design of personalized performance

indicators.