Conceptual Modeling Solutions for the Data Warehouse [chapter]

Stefano Rizzi
Selected Readings on Database Technologies and Applications  
Library of Congress Cataloging-in-Publication Data Data warehousing and mining : concepts, methodologies, tools and applications / John Wang, editor. p. cm. Summary: "This collection offers tools, designs, and outcomes of the utilization of data mining and warehousing technologies, such as algorithms, concept lattices, multidimensional data, and online analytical processing. With more than 300 chapters contributed by over 575 experts from around the globe, this authoritative collection will
more » ... ide libraries with the essential reference on data mining and warehousing"--Provided by publisher. Includes bibliographical references and index. ISBN 978-1-59904-951-9 (hbk.) --ISBN 978-1-59904-952-6 (e-book) 1. Data mining. 2. Data warehousing. I. Wang, John, 1955-QA76.9.D343D398 2008 005.74--dc22 2008001934 ABSTRACT In the context of data warehouse design, a basic role is played by conceptual modeling, that provides a higher level of abstraction in describing the warehousing process and architecture in all its aspects, aimed at achieving independence of implementation issues. This chapter focuses on a conceptual model called the DFM that suits the variety of modeling situations that may be encountered in real projects of small to large complexity. The aim of the chapter is to propose a comprehensive set of solutions for conceptual modeling according to the DFM and to give the designer a practical guide for applying them in the context of a design methodology. Besides the basic concepts of multidimensional modeling, the other issues discussed are descriptive and cross-dimension attributes; convergences; shared, incomplete, recursive, and dynamic hierarchies; multiple and optional arcs; and additivity.
doi:10.4018/9781605660981.ch001 fatcat:n2e54zcpsjfejgyp4kgnoyizxu