Skip header Section
Skip Bibliometrics Section
Entity-Relationship Modeling: Foundations of Database TechnologyJanuary 2000
- Author:
- Bernhard Thalheim
Skip Abstract Section
Abstract
From the Publisher:
Database technology and entity-relationship (ER) modeling have meanwhile reached the level of an established technology. This book presents the achievements of research in this field in a comprehensive survey. It deals with the ER model and its extensions with regard to an integrated development and modeling of database applications and, consequently, the specification of structures, behavior, and interaction." "Apart from research on the ER model and the syntax, semantics, and pragmatics of database modeling the book also presents techniques for the translation of the ER model into classical database models and languages such as relational, hierarchical, and network models and languages, and also into object-oriented models." "The book is of interest for all database theoreticians as well as practitioners who are provided with the relevant fundamentals of database modeling.
Cited By
- Thalheim B (2022). Models: the fourth dimension of computer science, Software and Systems Modeling (SoSyM), 21:1, (9-18), Online publication date: 1-Feb-2022.
- Link S Neo4j Keys Conceptual Modeling, (19-33)
- Thalheim B Schema Optimisation Instead of (Local) Normalisation Foundations of Information and Knowledge Systems, (281-300)
- Biskup J and Preuß M (2019). Checking inference-proofness of attribute-disjoint and duplicate-preserving fragmentations, Annals of Mathematics and Artificial Intelligence, 87:1-2, (43-82), Online publication date: 1-Oct-2019.
- Balaban M and Maraee A (2019). Removing redundant multiplicity constraints in UML class models, Software and Systems Modeling (SoSyM), 18:4, (2717-2751), Online publication date: 1-Aug-2019.
- Roblot T, Hannula M and Link S (2018). Probabilistic Cardinality Constraints, The VLDB Journal — The International Journal on Very Large Data Bases, 27:6, (771-795), Online publication date: 1-Dec-2018.
- Landolfi G, Bami A, Izzo G, Montini E, Bettoni A, Vujasinovic M, Gugliotta A, Soares A and Diogo Silva H An Ontology Based Semantic Data Model Supporting A Maas Digital Platform 2018 International Conference on Intelligent Systems (IS), (896-904)
Getta J Automated Evaluation of Correctness and Quality of Database Conceptual Schemas Proceedings of the 2018 International Conference on Big Data Engineering and Technology, (20-25)- Köhler H and Link S SQL Schema Design Proceedings of the 2016 International Conference on Management of Data, (267-279)
- Biskup J Selected Results and Related Issues of Confidentiality-Preserving Controlled Interaction Execution Proceedings of the 9th International Symposium on Foundations of Information and Knowledge Systems - Volume 9616, (211-234)
- Wang Q (2015). A conceptual modeling framework for network analytics, Data & Knowledge Engineering, 99:C, (59-71), Online publication date: 1-Sep-2015.
- Le V, Link S and Ferrarotti F Effective Recognition and Visualization of Semantic Requirements by Perfect SQL Samples Proceedings of the 32nd International Conference on Conceptual Modeling - Volume 8217, (227-240)
- Balaban M and Maraee A Simplification and Correctness of UML Class Diagrams --- Focusing on Multiplicity and Aggregation/Composition Constraints Proceedings of the 16th International Conference on Model-Driven Engineering Languages and Systems - Volume 8107, (454-470)
- Balaban M and Maraee A (2013). Finite satisfiability of UML class diagrams with constrained class hierarchy, ACM Transactions on Software Engineering and Methodology, 22:3, (1-42), Online publication date: 1-Jul-2013.
- Link S and Memari M Letting keys and functional dependencies out of the bag Proceedings of the Ninth Asia-Pacific Conference on Conceptual Modelling - Volume 143, (41-50)
- Britell S, Delcambre L, Cassel L, Fox E and Furuta R Enhancing digital libraries and portals with canonical structures for complex objects Proceedings of the Second international conference on Theory and Practice of Digital Libraries, (420-425)
- Thalheim B Syntax, semantics and pragmatics of conceptual modelling Proceedings of the 17th international conference on Applications of Natural Language Processing and Information Systems, (1-10)
- Hartmann S and Link S (2012). The implication problem of data dependencies over SQL table definitions, ACM Transactions on Database Systems, 37:2, (1-40), Online publication date: 1-May-2012.
- Hartmann S, Köhler H, Link S and Thalheim B Armstrong databases and reasoning for functional dependencies and cardinality constraints over partial bags Proceedings of the 7th international conference on Foundations of Information and Knowledge Systems, (164-183)
- Currim F and Ram S (2012). Modeling Spatial and Temporal Set-Based Constraints During Conceptual Database Design, Information Systems Research, 23:1, (109-128), Online publication date: 1-Mar-2012.
- Queralt A and Teniente E (2012). Verification and Validation of UML Conceptual Schemas with OCL Constraints, ACM Transactions on Software Engineering and Methodology, 21:2, (1-41), Online publication date: 1-Mar-2012.
- Sörensen O, Thalheim B and Wang Q A conceptual justification for model transformations Proceedings of the Eighth Asia-Pacific Conference on Conceptual Modelling - Volume 130, (43-50)
- Link S Armstrong databases Proceedings of the Eighth Asia-Pacific Conference on Conceptual Modelling - Volume 130, (3-22)
- Thalheim B The science and art of conceptual modelling Transactions on Large-Scale Data- and Knowledge-Centered Systems VI, (76-105)
- Kiyoki Y, Sasaki S, Trang N and Diep N Cross-Cultural multimedia computing with impression-based semantic spaces Conceptual Modelling and Its Theoretical Foundations, (316-328)
- Ma H Transforming geometrically enhanced conceptual model schemas to GML Conceptual Modelling and Its Theoretical Foundations, (251-267)
- Villegas A, Olivé A and Sancho M On computing the importance of associations in large conceptual schemas Conceptual Modelling and Its Theoretical Foundations, (216-230)
- Sølvberg A On models of concepts and data Conceptual Modelling and Its Theoretical Foundations, (190-196)
- Clyde S, Embley D, Liddle S and Woodfield S OSM-Logic Conceptual Modelling and Its Theoretical Foundations, (151-172)
- Ferrarotti F, Hartmann S, Köhler H, Link S and Vincent M Foundations for a fourth normal form over SQL-Like databases Conceptual Modelling and Its Theoretical Foundations, (85-100)
- Makowsky J and Ravve E BCNF via attribute splitting Conceptual Modelling and Its Theoretical Foundations, (73-84)
- Källberg D, Leonenko N and Seleznjev O Statistical inference for rényi entropy functionals Conceptual Modelling and Its Theoretical Foundations, (36-51)
- Biskup J Some remarks on relational database schemes having few minimal keys Conceptual Modelling and Its Theoretical Foundations, (19-28)
- Badia A and Lemire D (2011). A call to arms, ACM SIGMOD Record, 40:3, (61-69), Online publication date: 17-Nov-2011.
- Thalheim B and Wang Q Towards a theory of refinement for data migration Proceedings of the 30th international conference on Conceptual modeling, (318-331)
- Malý J, Mlýnková I and Nečaský M XML data transformations as schema evolves Proceedings of the 15th international conference on Advances in databases and information systems, (375-388)
- Ferrarotti F, Hartmann S, Le V and Link S Codd table representations under weak possible world semantics Proceedings of the 22nd international conference on Database and expert systems applications - Volume Part I, (125-139)
- Thalheim B The science of conceptual modelling Proceedings of the 22nd international conference on Database and expert systems applications - Volume Part I, (12-26)
- Amalfi M, Artale A, Calì A and Provetti A Generating preview Instances for the face validation of entity-relationship schemata Proceedings of the 16th international conference on Database systems for advanced applications: Part II, (225-234)
- Link S (2011). On Inferences of Full First-Order Hierarchical Decompositions, Fundamenta Informaticae, 106:2-4, (233-258), Online publication date: 1-Apr-2011.
- Sali A and Schewe K (2011). Weak functional dependencies on trees with restructuring, Acta Cybernetica, 20:2, (285-329), Online publication date: 1-Feb-2011.
- Currim F and Ram S When entities are types Proceedings of the 2010 international conference on Advances in conceptual modeling: applications and challenges, (138-147)
- Wang Q and Noack R Intelligent author identification Proceedings of the 2010 international conference on Advances in conceptual modeling: applications and challenges, (96-106)
- Aleksic S, Celikovic M, Link S, Lukovic I and Mogin P Faceoff Proceedings of the 14th east European conference on Advances in databases and information systems, (543-546)
- Cabot J and Gómez C (2010). Evaluating the Consistency between Navigation and Data Models for Web Applications, International Journal of Information System Modeling and Design, 1:3, (68-85), Online publication date: 1-Jul-2010.
- Langeveldt W and Link S (2010). Empirical evidence for the usefulness of Armstrong relations in the acquisition of meaningful functional dependencies, Information Systems, 35:3, (352-374), Online publication date: 1-May-2010.
- Seleznjev O and Thalheim B (2010). Random Databases with Approximate Record Matching, Methodology and Computing in Applied Probability, 12:1, (63-89), Online publication date: 1-Mar-2010.
- Hartmann S, Köhler H and Trinh T On the Existence of Armstrong Data Trees for XML Functional Dependencies Proceedings of the 6th International Symposium on Foundations of Information and Knowledge Systems - Volume 5956, (94-113)
- Ma H, Schewe K, Thalheim B and Wang Q A service-oriented approach to web warehousing Proceedings of the 11th International Conference on Information Integration and Web-based Applications & Services, (96-103)
- Hartmann S, Leck U and Link S On Matrix Representations of Participation Constraints Proceedings of the ER 2009 Workshops (CoMoL, ETheCoM, FP-UML, MOST-ONISW, QoIS, RIGiM, SeCoGIS) on Advances in Conceptual Modeling - Challenging Perspectives, (75-84)
- Thalheim B Towards a Theory of Conceptual Modelling Proceedings of the ER 2009 Workshops (CoMoL, ETheCoM, FP-UML, MOST-ONISW, QoIS, RIGiM, SeCoGIS) on Advances in Conceptual Modeling - Challenging Perspectives, (45-54)
- Ma H, Noack R and Schewe K Algebraic Meta-structure Handling of Huge Database Schemata Proceedings of the ER 2009 Workshops (CoMoL, ETheCoM, FP-UML, MOST-ONISW, QoIS, RIGiM, SeCoGIS) on Advances in Conceptual Modeling - Challenging Perspectives, (12-21)
- Makarenkov V, Jelnov P, Maraee A and Balaban M Finite satisfiability of class diagrams Proceedings of the 6th International Workshop on Model-Driven Engineering, Verification and Validation, (1-10)
- Hartmann S, Link S and Trinh T (2009). Constraint acquisition for Entity-Relationship models, Data & Knowledge Engineering, 68:10, (1128-1155), Online publication date: 1-Oct-2009.
- Schmidt P and Thalheim B Management of UML clusters Rigorous Methods for Software Construction and Analysis, (111-129)
- Neumayr B, Grün K and Schrefl M Multi-level domain modeling with m-objects and m-relationships Proceedings of the Sixth Asia-Pacific Conference on Conceptual Modeling - Volume 96, (107-116)
- Thalheim B, Schewe K and Ma H Conceptual application domain modelling Proceedings of the Sixth Asia-Pacific Conference on Conceptual Modeling - Volume 96, (49-58)
- Sali A and Schewe K (2008). Keys and Armstrong databases in trees with restructuring, Acta Cybernetica, 18:3, (529-556), Online publication date: 1-Jan-2008.
- Choppella V, Sengupta A, Robertson E and Johnson S Preliminary explorations in specifying and validating entity-relationship models in PVS Proceedings of the second workshop on Automated formal methods, (1-10)
- Hartmann S and Link S Collection type constructors in entity-relationship modeling Proceedings of the 26th international conference on Conceptual modeling, (307-322)
- Roddick J, Ceglar A and de Vries D Towards active conceptual modelling for sudden events Tutorials, posters, panels and industrial contributions at the 26th international conference on Conceptual modeling - Volume 83, (203-208)
- Hegner S and Schmidt P Update support for database views via cooperation Proceedings of the 11th East European conference on Advances in databases and information systems, (98-113)
- Schewe K and Thalheim B (2007). Personalisation of web information systems - A term rewriting approach, Data & Knowledge Engineering, 62:1, (101-117), Online publication date: 1-Jul-2007.
- Hartmann S, Köhler H and Link S (2007). Full hierarchical dependencies in fixed and undetermined universes, Annals of Mathematics and Artificial Intelligence, 50:1-2, (195-226), Online publication date: 1-Jun-2007.
- Ma H, Schewe K and Wang Q A heuristic approach to cost-efficient derived horizontal fragmentation of complex value databases Proceedings of the eighteenth conference on Australasian database - Volume 63, (103-111)
- Necasky M XSEM Proceedings of the fourth Asia-Pacific conference on Comceptual modelling - Volume 67, (37-48)
- Hartmann S and Link S English sentence structures and EER modeling Proceedings of the fourth Asia-Pacific conference on Comceptual modelling - Volume 67, (27-35)
- Hartmann S and Link S On inferences of full hierarchical dependencies Proceedings of the thirtieth Australasian conference on Computer science - Volume 62, (69-78)
- Thalheim B Engineering database component ware Proceedings of the 2nd international conference on Trends in enterprise application architecture, (1-15)
- Thalheim B Engineering Database Component Ware Trends in Enterprise Application Architecture, (1-15)
- Hartmann S and Link S (2006). Deciding implication for functional dependencies in complex-value databases, Theoretical Computer Science, 364:2, (212-240), Online publication date: 6-Nov-2006.
- Bienemann A, Schewe K and Thalheim B Towards a theory of genericity based on government and binding Proceedings of the 25th international conference on Conceptual Modeling, (311-324)
- Murthy S, Delcambre L and Maier D Explicitly representing superimposed information in a conceptual model Proceedings of the 25th international conference on Conceptual Modeling, (126-139)
- Demetrovics J, Molnár A and Thalheim B Relationship design using spreadsheet reasoning for sets of functional dependencies Proceedings of the 10th East European conference on Advances in Databases and Information Systems, (108-123)
- Balaban M and Maraee A Consistency of UML class diagrams with hierarchy constraints Proceedings of the 6th international conference on Next Generation Information Technologies and Systems, (71-82)
- Hartmann S, Link S and Schewe K (2006). Axiomatisations of functional dependencies in the presence of records, lists, sets and multisets, Theoretical Computer Science, 355:2, (167-196), Online publication date: 11-Apr-2006.
- Hartmann S and Link S The nested list normal form for functional and multivalued dependencies Proceedings of the 4th international conference on Foundations of Information and Knowledge Systems, (137-158)
- Hartmann S and Trinh T Axiomatising functional dependencies for XML with frequencies Proceedings of the 4th international conference on Foundations of Information and Knowledge Systems, (159-178)
- Patig S (2006). Evolution of entity-relationship modelling, Data & Knowledge Engineering, 56:2, (122-138), Online publication date: 1-Feb-2006.
- Cabot J and Raventós R Conceptual modelling patterns for roles Journal on Data Semantics V, (158-184)
- Schewe K and Thalheim B Component-driven engineering of database applications Proceedings of the 3rd Asia-Pacific conference on Conceptual modelling - Volume 53, (105-114)
- Ma H, Schewe K and Wang Q A heuristic approach to cost-efficient fragmentation and allocation of complex value databases Proceedings of the 17th Australasian Database Conference - Volume 49, (183-192)
- Hartmann S and Link S Horn clauses and functional dependencies in complex-value databases Proceedings of the 17th Australasian Database Conference - Volume 49, (21-30)
- Moody D (2005). Theoretical and practical issues in evaluating the quality of conceptual models, Data & Knowledge Engineering, 55:3, (243-276), Online publication date: 1-Dec-2005.
- Hussain T, Awais M and Shamail S A fuzzy based approach to measure completeness of an entity-relationship model Proceedings of the 24th international conference on Perspectives in Conceptual Modeling, (410-422)
- Tretiakov A and Hartmann S Higher-Order Entity Relationship Modelling with UML Proceedings of the Fifth International Conference on Quality Software, (205-214)
- Lenz H and Thalheim B OLAP schemata for correct applications Proceedings of the 31st VLDB conference on Trends in Enterprise Application Architecture, (99-113)
- Badia A and Kantardzic M Graph building as a mining activity Proceedings of the 3rd international workshop on Link discovery, (17-24)
- Hainaut J The transformational approach to database engineering Proceedings of the 2005 international conference on Generative and Transformational Techniques in Software Engineering, (95-143)
- Olivé A Conceptual schema-centric development Proceedings of the 17th international conference on Advanced Information Systems Engineering, (1-15)
- Hartmann S and Link S (2005). The Implication Problem of Functional Dependencies in Complex-value Databases, Electronic Notes in Theoretical Computer Science (ENTCS), 123:C, (125-137), Online publication date: 1-Mar-2005.
- Kirchberg M, Riaz-ud-Din F, Schewe K and Tretiakov A Towards algebraic query optimisation for XQuery Journal on Data Semantics VII, (165-195)
- Ma H, Schewe K, Thalheim B and Zhao J View integration and cooperation in databases, data warehouses and web information systems Journal on Data Semantics IV, (213-249)
- Boyd M and McBrien P Comparing and transforming between data models via an intermediate hypergraph data model Journal on Data Semantics IV, (69-109)
- Hartmann S, Link S and Schewe K (2005). Functional dependencies over XML documents with DTDs, Acta Cybernetica, 17:1, (153-171), Online publication date: 1-Jan-2005.
- Fiedler G, Raak T and Thalheim B Database collaboration instead of integration Proceedings of the 2nd Asia-Pacific conference on Conceptual modelling - Volume 43, (49-58)
- Jain S, Gore M and Singh G An extension to ER model for top-down semantic modeling of databases of applications Proceedings of the 7th international conference on Intelligent Information Technology, (253-262)
- Hussain T, Shamail S and Awais M Improving quality in conceptual modeling Companion to the 19th annual ACM SIGPLAN conference on Object-oriented programming systems, languages, and applications, (170-171)
- Hartmann S and Link S Multi-valued dependencies in the presence of lists Proceedings of the twenty-third ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, (330-341)
- Badia A (2004). Entity-Relationship modeling revisited, ACM SIGMOD Record, 33:1, (77-82), Online publication date: 1-Mar-2004.
- Düsterhöft A and Thalheim B (2004). Linguistic based search facilities in snowflake-like database schemes, Data & Knowledge Engineering, 48:2, (177-198), Online publication date: 1-Feb-2004.
- Binemann-Zdanowicz A, Kaschek R, Schewe K and Thalheim B Context-aware Web Information Systems Proceedings of the first Asian-Pacific conference on Conceptual modelling - Volume 31, (37-48)
- Thalheim B Co-design of structuring, functionality, distribution, and interactivity for information systems Proceedings of the first Asian-Pacific conference on Conceptual modelling - Volume 31, (3-12)
- Doberkat E and Omodeo E (2004). ER modelling from first relational principles, Theoretical Computer Science, 311:1-3, (285-323), Online publication date: 23-Jan-2004.
- Link S and Hartmann S Normalisation in the presence of lists Proceedings of the 15th Australasian database conference - Volume 27, (49-60)
- Hegner S (2004). An Order-Based Theory of Updates for Closed Database Views, Annals of Mathematics and Artificial Intelligence, 40:1-2, (63-125), Online publication date: 1-Jan-2004.
- Ghandeharizadeh S An educational perspective on database management systems and object-oriented methodology Companion of the 18th annual ACM SIGPLAN conference on Object-oriented programming, systems, languages, and applications, (137-139)
- Hartmann S, Hoffmann A, Link S and Schewe K (2003). Axiomatizing functional dependencies in the higher-order entity-relationship model, Information Processing Letters, 87:3, (133-137), Online publication date: 16-Aug-2003.
- Prinz A and Thalheim B ASM specification of database systems Proceedings of the abstract state machines 10th international conference on Advances in theory and practice, (418-420)
- Prinz A and Thalheim B Operational semantics of transactions Proceedings of the 14th Australasian database conference - Volume 17, (169-179)
- Kirchberg M and Link S On the implication problem for functional dependencies in the higher-order entity-relationship model Proceedings of the 14th Australasian database conference - Volume 17, (115-124)
- Hartmann S Reasoning about participation constraints and Chen's constraints Proceedings of the 14th Australasian database conference - Volume 17, (105-113)
- Thalheim B Database component ware Proceedings of the 14th Australasian database conference - Volume 17, (13-26)
- Hartmann S (2001). On the implication problem for cardinality constraints and functional dependencies, Annals of Mathematics and Artificial Intelligence, 33:2-4, (253-307), Online publication date: 26-Nov-2001.
- Schewe K Design theory for advanced datamodels Proceedings of the 12th Australasian database conference, (3-9)
- Schewe K On the unification of query algebras and their extension to rational tree structures Proceedings of the 12th Australasian database conference, (52-59)
- Hegner S Characterization of type hierarchies with open specification Proceedings of the 2nd international conference on Semantics in databases, (100-118)
Recommendations
Entity relationship stored procedure
ACS'06: Proceedings of the 6th WSEAS international conference on Applied computer scienceER-SP(Entity Relationship - Stored Procedures) model is proposed like an extension to ER (Entity Relationship) model for conceptual, syntactic and semantic modeling of RDBMS in idea to create a link between external to physical models. ER-SPL (Entity ...
Logical Design of Graph Databases from an Entity-Relationship Conceptual Model
iiWAS2018: Proceedings of the 20th International Conference on Information Integration and Web-based Applications & ServicesNoSQL database models and data store systems have emerged in response to the needs of new big data applications. A common feature of these logical models is the schemaless property that promotes flexibility in data organization. Because of that ...