Skip to main content

A Model and a Toolkit for Supporting Incremental Data Warehouse Construction

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 2002)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2453))

Included in the following conference series:

Abstract

The design of data warehouse is a very relevant issue in supporting the management decisional processes and data analysis. While the design and maintenance of data warehouses are dificult tasks, enterprise managements are increasingly asking for tools capable to support designers in all the activities involving data warehouse construction. In this context it is mandatory to provide designers with the capability to incrementally define data warehouse components. In this paper we propose a conceptual model, called Multidimensional Fact Network (MFN), allowing to incrementally define data marts and a toolkit, called AURORA, based on MFN and providing a comprehensive set of data warehouse design tools.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Extended metadata component-Specifiche, Document project number 1704-STEC-01-00-10 in IMI-MURST project “Aurora: un ambiente unitario di realizzazione de sistemi informativi direzionali”.

    Google Scholar 

  2. ATS Aurora Toolset-ATS progetto, Document project number 1704-STECH-01-04-02 in IMI-MURST project “Aurora: un ambiente unitario di realizzazione de sistemi informativi direzionali”.

    Google Scholar 

  3. L. Cabibbo, R. Torlone. ALogical Approach to Multidimensional Databases. in Proceedings of International Conference on Extending Data Base Technology (EDBT’98), Springer-Verlag, 1998. ACM SIGMOD Record 26(1): 65–74, 1997.

    Google Scholar 

  4. S. Chaudhuri, U. Dayal. An Overview of DataWarehousing and OLAP Technology. ACM SIGMOD Record 26(1): 65–74, 1997.

    Article  Google Scholar 

  5. E. Franconi, U. Sattler. AData Warehouse Conceptual Data Model for Multidimensional Aggregation. In Proc. Int. Workshop on Design and Management of Data Warehouses, 1999.

    Google Scholar 

  6. M. Golfarelli, D. Maio, S. Rizzi, Conceptual Design of Data Warehouses from E/R Schemes, Proceedings of the Hawaii International Conference on System Sciences, Kona (Hawaii), USA, 1998.

    Google Scholar 

  7. S. Greco, E. Masciari, L. Pontieri, “Combining inductive and deductive tools for data analysis”, in AI Communications, 14(2), pp. 69–82, 2001.

    MATH  Google Scholar 

  8. W. Lehner. Modeling Large Scale OLAP Scenarios. In Proc. of Int. Conf. on Extending Database Technology (EDBT), Valencia, Spain, 1998: 153–167.

    Google Scholar 

  9. L. Palopoli, G. Terracina and D. Ursino, The System DIKE: Towards the Semi-Automatic Synthesis of Cooperative Information Systems and Data Warehouses, Proc. of Challenges of Symposium on Advances in Databases and Information Systems (ADBIS-DASFAA 2000), Prague, Czech Republic, pp. 108–117, 2000, Matfyzpress

    Google Scholar 

  10. L. Palopoli, L. Pontieri, G. Terracina and D. Ursino, Intensional and extensional integration and abstraction of heterogeneous databases, Data & Knowledge Engineering, 35(3), pp. 201–237, 2000

    MATH  Google Scholar 

  11. C. Sapia, M. Blaschka, G. Höfling, B. Dinter. Extending the E/R Model for the Multidimensional Paradigm. In Proc. of ER Workshops, Singapore, 1998: 105–116.

    Google Scholar 

  12. J. C. Trujillo, M. Palomar, J. Gómez. Applying Object-Oriented Conceptual Modeling Techniques to the Design of Multidimensional Databases and OLAP Applications. In Proc. First Int. Conf. Web-Age Information Management (2000): 83–94.

    Google Scholar 

  13. P. Vassiliadis. Modeling multidimensional databases, cubes and cube operations. In Proc. of 10th Int. Conf. on Scientific and Statistical Database Management (SSDB), Capri, 1998.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Naggar, P., Pontieri, L., Pupo, M., Terracina, G., Virardi, E. (2002). A Model and a Toolkit for Supporting Incremental Data Warehouse Construction. In: Hameurlain, A., Cicchetti, R., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2002. Lecture Notes in Computer Science, vol 2453. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46146-9_13

Download citation

  • DOI: https://doi.org/10.1007/3-540-46146-9_13

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-44126-7

  • Online ISBN: 978-3-540-46146-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics