Skip to main content

When Entities Are Types: Effectively Modeling Type-Instantiation Relationships

  • Conference paper
Advances in Conceptual Modeling – Applications and Challenges (ER 2010)

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

Included in the following conference series:

Abstract

Type-instantiation relationships (TIRs) appear in many application domains including RFID-based inventory tracking, securities markets, health care, incident-response management, travel, advertising, and academia. For example an emergency response (type) is instantiated in the actual incident, or an advertisement (type) serves impressions on a website. This kind of relationship has received little attention in literature notwithstanding its ubiquity. Conventional modeling does not properly capture its underlying semantics. This can lead to data redundancy, denormalized relations and loss of knowledge about constraints during implementation. Our work formally defines and discusses the semantics of the type-instantiation relationship. We also present an analysis of how TIRs affect other relationships in a conceptual database schema, and the relational implications of our approach.

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 39.99
Price excludes VAT (USA)
  • Available as 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

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Currim, F., Ram, S.: RFID Data: A case of and for types and instances. In: Conference RFID Data: A case of and for types and instances (2009)

    Google Scholar 

  2. Goldstein, R., Storey, V.: Materialization. IEEE Transactions on Knowledge and Data Engineering 6, 835–842 (1994)

    Article  Google Scholar 

  3. Batini, C., Ceri, S., Navathe, S.B.: Conceptual Database Design: An Entity-Relationship Approach. Benjamin/Cummings Publishing Company (1992)

    Google Scholar 

  4. Dahchour, M., Pirotte, A., Zimányi, E.: Materialization and Its Metaclass Implementation. IEEE Transactions on Knowledge and Data Engineering 14, 1078–1094 (2002)

    Article  Google Scholar 

  5. Dobing, B., Parsons, J.: How UML is used. Communications of the ACM 49, 109–113 (2006)

    Article  Google Scholar 

  6. Pirotte, A., Zimányi, E., Massart, D., Yakusheva, T.: Materialization: A Powerful and Ubiquitous Abstraction Pattern. In: Conference Materialization: A Powerful and Ubiquitous Abstraction Pattern, pp. 630–641 (1994)

    Google Scholar 

  7. Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Addison Wesley, Reading (2003)

    MATH  Google Scholar 

  8. Chen, P.P.: The Entity-Relationship Model - Toward a Unified View of Data. ACM Transactions on Database Systems 1, 9–36 (1976)

    Article  Google Scholar 

  9. Thalheim, B.: Entity-Relationship Modeling: Foundations of Database Technology. Springer, Heidelberg (2000)

    Book  MATH  Google Scholar 

  10. Parsons, J., Wand, Y.: Guidelines for Evaluating Classes in Data Modeling. In: Conference Guidelines for Evaluating Classes in Data Modeling, pp. 1–8 (1992)

    Google Scholar 

  11. Ram, S.: Intelligent Database Design using the Unifying Semantic Model. Information and Management 29, 191–206 (1995)

    Article  Google Scholar 

  12. Batra, D.: Conceptual Data Modeling Patterns: Representation and Validation. Journal of Database Management 16, 84–106 (2005)

    Article  Google Scholar 

  13. Hay, D.C.: Data Model Patterns: Conventions of Thought. Dorset House Publishing Company, New York (1995)

    Google Scholar 

  14. Fagin, R.: A normal form for relational databases that is based on domains and keys. ACM Transactions on Database Systems 6, 387–415 (1981)

    Article  MATH  Google Scholar 

  15. Niederman, F., Mathieu, R., Morley, R., Kwon, I.-W.: Examining RFID Applications in Supply Chain Management. Communications of the ACM 50, 93–101 (2007)

    Article  Google Scholar 

  16. Hevner, A.R., March, S.T., Park, J., Ram, S.: Design Science in Information Systems Research. MIS Quarterly 28, 75–105 (2004)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Currim, F., Ram, S. (2010). When Entities Are Types: Effectively Modeling Type-Instantiation Relationships. In: Trujillo, J., et al. Advances in Conceptual Modeling – Applications and Challenges. ER 2010. Lecture Notes in Computer Science, vol 6413. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-16385-2_18

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-16385-2_18

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-16384-5

  • Online ISBN: 978-3-642-16385-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics