skip to main content
10.1145/1806338.1806364acmotherconferencesArticle/Chapter ViewAbstractPublication PagesiiwasConference Proceedingsconference-collections
research-article

A service-oriented approach to web warehousing

Published:14 December 2009Publication History

ABSTRACT

Data warehouses integrate and aggregate data from various sources to support decision making within an enterprise. Usually, it is assumed that data are extracted from operational databases used by the enterprise. Web warehousing relaxes this view permitting data sources to be located anywhere on the world-wide web. In this paper we even go one step further and propose that web warehousing should exploit data-intensive web services. For this we adopt the view of the recently introduced model of abstract state services (ASSs). An ASS combines a hidden database layer with an operation-equipped view layer, and can be anything from a simple function to a full-fledged Web Information System, thus provides an abstraction of web services that can be made available for use by other systems, e.g. via the web. We demonstrate how data warehouses and OLAP systems can be considered in a natural way as ASSs, i.e. selected data and functionality of a data warehouse may be made available in the form of a generalised web service, and consequently ASS composition can be used for web warehousing. In order to become workable the model of ASSs has to be extended in a way that allows services to be searched for. For this we propose federations of services together with an ontology that specifies their semantics.

References

  1. F. Baader et al., editors. The Description Logic Handbook: Theory, Implementation and Applications. Cambridge University Press, 2003.Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. B. Benatallah, F. Casati, and F. Toumani. Representing, analysing and managing web service protocols. Data and Knowledge Engineering, 58(3):327--357, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. E. Börger and R. Stärk. Abstract State Machines. Springer-Verlag, Berlin Heidelberg New York, 2003.Google ScholarGoogle Scholar
  4. M. R. Brenner and M. R. Unmehopa. Service-oriented architecture and web services penetration in next-generation networks. Bell Labs Technical Journal, 12(2):147--159, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. E. Christensen et al. Web services description language (WSDL) 1.1, 2001. http://www.w3c.org/TR/wsdl.Google ScholarGoogle Scholar
  6. J. Gurevich. Sequential abstract state machines capture sequential algorithms. ACM Transactions on Computational Logic, 1(1):77--111, 2000. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. S. J. Hegner. Information-optimal reflections of view updates on relational database schemata. In S. Hartmann and G. Kern-Isberner, editors, Foundations of Information and Knowledge Systems -- 5th International Symposium (FoIKS 2008), volume 4932 of Lecture Notes in Computer Science, pages 112--131. Springer-Verlag, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. W. Inmon. Building the Data Warehouse. Wiley & Sons, New York, 1996.Google ScholarGoogle Scholar
  9. R. Kimball. The Data Warehouse Toolkit. John Wiley & Sons, 1996.Google ScholarGoogle Scholar
  10. S. Kumaran et al. Using a model-driven transformational approach and service-oriented architecture for service delivery management. IBM Systems Journal, 46(3):513--530, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. M. Lawrence and A. Rau-Chaplin. Dynamic view selection for OLAP. In A. M. Tjoa and J. Trujillo, editors, Data Warehousing and Knowledge Discovery -- DaWaK 2006, volume 4081 of Lecture Notes in Computer Science, pages 33--44. Springer-Verlag, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. J. Lewerenz, K.-D. Schewe, and B. Thalheim. Modelling data warehouses and OLAP applications using dialogue objects. In J. Akoka, M. Bouzeghoub, I. Comyn-Wattiau, and E. Métais, editors, Conceptual Modeling -- ER'99, volume 1728 of LNCS, pages 354--368. Springer-Verlag, 1999. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. H. Ma, K.-D. Schewe, B. Thalheim, and Q. Wang. Abstract state services. In I.-Y. Song et al., editors, Advances in Conceptual Modeling -- Challenges and Opportunities, ER 2008 Workshops, volume 5232 of LNCS, pages 406--415. Springer-Verlag, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. H. Ma, K.-D. Schewe, B. Thalheim, and Q. Wang. A theory of data-intensive software services. (submitted for publication), 2009.Google ScholarGoogle Scholar
  15. M. P. Papazoglou and W.-J. van den Heuvel. Service oriented architectures: Approaches, technologies and research issues. VLDB Journal, 16(3):389--415, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. K.-D. Schewe and Q. Wang. A customised ASM thesis for database transformations, 2008. submitted for publication.Google ScholarGoogle Scholar
  17. K.-D. Schewe and J. Zhao. Typed abstract state machines for data-intensive applications. Knowledge and Information Systems, 15(3):381--391, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. Y. Tanaka. Meme Media and Meme Market Architectures. IEEE Press, Wiley-Interscience, USA, 2003.Google ScholarGoogle Scholar
  19. B. Thalheim. Entity-Relationship Modeling: Foundations of Database Technology. Springer-Verlag, 2000. Google ScholarGoogle ScholarDigital LibraryDigital Library
  20. B. Thalheim. Model suites. In Second International Workshop on Knowledge Cluster Systems, pages 20--40. IOS Press, 2008.Google ScholarGoogle Scholar
  21. D. Theodoratos, T. Dalamagas, A. Simitsis, and M. Stavropoulos. A randomized approach for the incremental design of an evolving data warehouse. In Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling, volume 2224 of LNCS, pages 325--338. Springer-Verlag, 2001. Google ScholarGoogle ScholarDigital LibraryDigital Library
  22. D. Theodoratos and T. Sellis. Dynamic data warehouse design. In Data Warehousing and Knowledge Discovery -- DaWaK'99, volume 1676 of LNCS, pages 1--10. Springer-Verlag, 1999. Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. D. Theodoratos and T. Sellis. Incremental design of a data warehouse. Journal of Intelligent Information Systems, 15(1):7--27, 2000. Google ScholarGoogle ScholarDigital LibraryDigital Library
  24. E. Thomson. OLAP Solutions: Building Multidimensional Information Systems. John Wiley & Sons, 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  25. W3C. Web ontology language (OWL). http://www.w3c.org//OWL/.Google ScholarGoogle Scholar
  26. Q. Wang and K.-D. Schewe. Axiomatization of database transformations. In Proceedings of the 14th International ASM Workshop (ASM 2007), University of Agder, Norway, 2007.Google ScholarGoogle Scholar
  27. J. Zhao and H. Ma. ASM-based design of data warehouses and on-line analytical processing systems. Journal of Systems and Software, 79(5):613--629, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  28. J. Zhao, K.-D. Schewe, and H. Köhler. Dynamic data warehouse design with abstract state machines. Journal of Universal Computer Science, 15(1):355--397, 2009.Google ScholarGoogle Scholar

Index Terms

  1. A service-oriented approach to web warehousing

    Recommendations

    Comments

    Login options

    Check if you have access through your login credentials or your institution to get full access on this article.

    Sign in
    • Published in

      cover image ACM Other conferences
      iiWAS '09: Proceedings of the 11th International Conference on Information Integration and Web-based Applications & Services
      December 2009
      763 pages
      ISBN:9781605586601
      DOI:10.1145/1806338

      Copyright © 2009 ACM

      Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

      Publisher

      Association for Computing Machinery

      New York, NY, United States

      Publication History

      • Published: 14 December 2009

      Permissions

      Request permissions about this article.

      Request Permissions

      Check for updates

      Qualifiers

      • research-article
    • Article Metrics

      • Downloads (Last 12 months)1
      • Downloads (Last 6 weeks)0

      Other Metrics

    PDF Format

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader