Skip to main content

Component Construction of Database Schemes

  • Conference paper
  • First Online:
Conceptual Modeling — ER 2002 (ER 2002)

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

Included in the following conference series:

Abstract

Principles of database modeling have been intensively investigated in the late 70ies or early 80ies. The principles have been based on constructs such as subtypes, supertypes, restructuring through normalization, types construction by constructors, generic models and associations with pre-specified semantical meaning such as relationship types. Whenever a schema is becoming too large schema developers get lost in the web of types. The classical approach is a repair approach, i.e., whenever a schema becomes too large then use techniques for surveying. This paper aims in developing general principles for pragmatistic development of large database schemata: many-dimensionality, star and snowflake sub-schemata, bridges, nesting, lifespan, logs, meta-characterizations, variants and occurrences, quality, temporality and abstraction layers. Therefore, this approach allows to treat the ‘lost on the schema’ problem in parallel to development.

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. J. Akoka and I. Comyn-Wattiau, A framework for automatic clustering of semantic models. Proc. ER’93, LNCS 823, Springer, 1994, 438–450.

    Google Scholar 

  2. D. Ancona and E. Zucca, A theory of mixin modules: Basic and derived operators. Mathematical Structures in Computer Science, 1998, 8(4), 401–446.

    Article  MATH  MathSciNet  Google Scholar 

  3. J. Biskup and T. Polle, Decomposition of database classes under path functional dependencies and onto contraints. Proc. FoIKS’2000, LNCS 1762, Springer, 2000, 31–49.

    Google Scholar 

  4. M. Broy, Compositional refinement of interactive systems. Journal of the ACM, 44, 6, 1997, 850–891.

    Article  MATH  MathSciNet  Google Scholar 

  5. H. Ehrig, G. Engels, H.-J. Kreowski, and G. Rozenberg (eds.), Handbook of graph grammars and computing by graph transformations. Vol. 2: Applications, languages and tools. World Scientific, Singapore, 1999.

    Google Scholar 

  6. ISOTEC, Methoden des Fachkonzepts. Plönzke Informatik GmbH, Wiesbaden 1991.

    Google Scholar 

  7. J. Lewerenz, K.-D. Schewe, and B. Thalheim, Modeling data warehouses and OLAP applications by means of dialogue objects. Proc. ER’99, Springer, Berlin, LNCS 1728, 1999, 354–368.

    Google Scholar 

  8. D. L. Moody, Dealing with complexity: A practical method for representing large entity-relationship models. PhD., Dept. of Information Systems, University of Melbourne, 2001.

    Google Scholar 

  9. O. Nierstrasz and T.D. Meijler, Research directions in software composition. ACM Computing Surveys, 27, 2, 1995, 262–264.

    Article  Google Scholar 

  10. O. Rauh and E. Stickel, Konzeptuelle Datenmodellierung. Teubner, Stuttgart, 1997.

    Google Scholar 

  11. L. Silverston, W. H. Inmon, and K. Graziano, The data model resource book. Jon Wiley & Sons, New York, 1997.

    Google Scholar 

  12. B. Thalheim, Entity-relationship modeling-Foundations of database technology. Springer, Berlin, 2000. See also http://www.informatik.tu-cottbus.de/~thalheim/HERM.htm

    MATH  Google Scholar 

  13. B. Thalheim, The person, organization, product, production, ordering, delivery, invoice, accounting, budgeting and human resources pattern in database design. Preprint I-07-2000, Computer Science Institute, Brandenburg University of Technology at Cottbus, 2000.

    Google Scholar 

  14. T. J. Teorey, G. Wei, D. L. Bolten, and J. A. Koenig, ER model clustering as an aid for user communication and documentation in database design. CACM, 32, 8, 1989, 975–987.

    Google Scholar 

  15. P. Wisse, Metapattern-Context and time in information models. Addison-Wesley, Boston, 2001.

    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

Thalheim, B. (2002). Component Construction of Database Schemes. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds) Conceptual Modeling — ER 2002. ER 2002. Lecture Notes in Computer Science, vol 2503. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45816-6_12

Download citation

  • DOI: https://doi.org/10.1007/3-540-45816-6_12

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-44277-6

  • Online ISBN: 978-3-540-45816-6

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics