Skip to main content
SpringerLink
Log in

Direct Conversion of Early Information to Multi-dimensional Model

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

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 11030))

Included in the following conference series:

Abstract

There are two design methodologies to maintain the single version of the truth in Data Warehouses. Inmon’s approach builds a consolidated enterprise DW represented as an ER diagram. Data marts are derived from this and represented as facts and dimensions. Kimball’s approach builds a bus of data marts represented as multi-dimensional model that rely on conforming facts and dimensions. However, recent proposals integrate the requirements using the notion of early information. We explore this option by first building a model of early information. The concepts of this model are used in developing an automated conflict resolution mechanism for integration of early information. Finally, we propose an algorithm for the conversion of integrated early requirements into its multi-dimensional form.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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

References

  1. Inmon, B.: Building the Data Warehouse, 4th edn. Wiley, New York (2005)

    Google Scholar 

  2. Adamson, C.: The Complete Reference Star Schema. McGraw-Hill, New York (2010)

    Google Scholar 

  3. Golfarelli, M., Maio, D., Rizzi, S.: Conceptual design of data warehouses from E/R schemes. In: Proceedings of the Thirty-First Hawaii International Conference on System Sciences, vol. 7, pp. 334–343. IEEE, January 1998

    Google Scholar 

  4. Moody, L.D., Kortink, M.A.R.: From enterprise models to dimensional models: a methodology for data warehouses and data mart design. In: Proceedings of the International Workshop on Design and Management of Data Warehouses, Stockholm, Sweden, pp. 5.1–5.12 (2000)

    Google Scholar 

  5. Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley, Hoboken (2002)

    Google Scholar 

  6. Cabibbo, L., Panella, I., Torlone, R., Tre, U.R.: DaWaII: a tool for the integration of autonomous data marts. In: ICDE, p. 158, April 2006

    Google Scholar 

  7. Riazati, D., Thom, J.A., Zhang, X.: Inferring aggregation hierarchies for integration of data marts. In: Bringas, P.G., Hameurlain, A., Quirchmayr, G. (eds.) DEXA 2010. LNCS, vol. 6262, pp. 96–110. Springer, Heidelberg (2010). https://doi.org/10.1007/978-3-642-15251-1_7

    Chapter  Google Scholar 

  8. Golfarelli, M., Rizzi, S., Turricchia, E.: Modern software engineering methodologies meet data warehouse design: 4WD. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2011. LNCS, vol. 6862, pp. 66–79. Springer, Heidelberg (2011). https://doi.org/10.1007/978-3-642-23544-3_6

    Chapter  Google Scholar 

  9. Jovanovic, P., Romero, O., Simitsis, A., Abelló, A., Mayorova, D.: A requirement-driven approach to the design and evolution of data warehouses. Inf. Syst. 44, 94–119 (2014)

    Article  Google Scholar 

  10. Prakash, D., Prakash, N.: A requirements driven approach to data warehouse consolidation. In: 11th IEEE International Conference on Research Challenges in Information Science (RCIS), pp. 449–450 (2017)

    Google Scholar 

  11. Prakash, D., Gupta, D.: Eliciting data warehouse contents for policy enforcement rules. Int. J. Inf. Syst. Model. Des. (IJISMD) 5(2), 41–69 (2014)

    Article  Google Scholar 

  12. Prakash, D., Prakash, N.: Towards DW support for formulating policies. In: Ralyté, J., España, S., Pastor, Ó. (eds.) PoEM 2015. LNBIP, vol. 235, pp. 374–388. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-25897-3_24

    Chapter  Google Scholar 

  13. Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Comput. Surv. (CSUR) 18(4), 323–364 (1986)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Engineering, NIIT University, Neemrana, 301705, Rajasthan, India

    Deepika Prakash

Authors
  1. Deepika Prakash
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Deepika Prakash .

Editor information

Editors and Affiliations

  1. Clausthal University of Technology, Clausthal-Zellerfeld, Germany

    Sven Hartmann

  2. Victoria University of Wellington, Wellington, New Zealand

    Hui Ma

  3. Paul Sabatier University, Toulouse, France

    Abdelkader Hameurlain

  4. University of Regensburg, Regensburg, Germany

    Günther Pernul

  5. Johannes Kepler University, Linz, Austria

    Roland R. Wagner

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Prakash, D. (2018). Direct Conversion of Early Information to Multi-dimensional Model. In: Hartmann, S., Ma, H., Hameurlain, A., Pernul, G., Wagner, R. (eds) Database and Expert Systems Applications. DEXA 2018. Lecture Notes in Computer Science(), vol 11030. Springer, Cham. https://doi.org/10.1007/978-3-319-98812-2_8

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-98812-2_8

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-98811-5

  • Online ISBN: 978-3-319-98812-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation