Fact-based data analysis and design
Journal of Systems and Software - Special double issue on the entity-relationship approach to databases and related software
Translation of entity-relationship diagrams into relational structures
Journal of Systems and Software - Special double issue on the entity-relationship approach to databases and related software
Entity-relationship approach to logical database design.
Proc. of the third international conference on Entity-relationship approach to software engineering
The category concept: an extension to the entity-relationship model
Data & Knowledge Engineering
Database design: composing fully normalized tables from a rigorous dependency diagram
Communications of the ACM
An introduction to database systems: vol. I (4th ed.)
An introduction to database systems: vol. I (4th ed.)
Database analysis and design
On the design of relational database schemata
ACM Transactions on Database Systems (TODS)
Hierarchical schemata for relational databases
ACM Transactions on Database Systems (TODS)
Consequences of assuming a universal relation
ACM Transactions on Database Systems (TODS)
Formal semantics for time in databases
ACM Transactions on Database Systems (TODS)
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Synthesizing third normal form relations from functional dependencies
ACM Transactions on Database Systems (TODS)
Database abstractions: aggregation and generalization
ACM Transactions on Database Systems (TODS)
Multivalued dependencies and a new normal form for relational databases
ACM Transactions on Database Systems (TODS)
A relational model of data for large shared data banks
Communications of the ACM
Data Analysis for Data Base Design
Data Analysis for Data Base Design
Principles of Database Design: Logical Organizations
Principles of Database Design: Logical Organizations
A Guide to DB2
Managing the Data Base Environment
Managing the Data Base Environment
Principles of Database Systems
Principles of Database Systems
Strategic Data Planning Method
Strategic Data Planning Method
Design of Database Structures
Data model integration using the structural model
SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
Relationship Merging in Schema Integration
VLDB '84 Proceedings of the 10th International Conference on Very Large Data Bases
A Methodology for View Inegration in Logical Database Design
VLDB '82 Proceedings of the 8th International Conference on Very Large Data Bases
Logical Design and Schema Conversion for Relational and DBTG Databases
Proceedings of the 1st International Conference on the Entity-Relationship Approach to Systems Analysis and Design
Applying a Semantic Data Model
Proceedings of the 1st International Conference on the Entity-Relationship Approach to Systems Analysis and Design
Abstraction Capabilities and Invariant Properties Modelling within the Entity-Relationship Approach
Proceedings of the 1st International Conference on the Entity-Relationship Approach to Systems Analysis and Design
A Decomposition of Relations Using the Entity-Relationship Approach
ER '81 Proceedings of the Second International Conference on the Entity-Relationship Approach to Information Modeling and Analysis
INCOD: A System for Conceptual Design of Data and Transactions in the Entity-Relationship Model
ER '81 Proceedings of the Second International Conference on the Entity-Relationship Approach to Information Modeling and Analysis
An Extended Entity-Relationship Model and Its Use on a Defense Project
ER '81 Proceedings of the Second International Conference on the Entity-Relationship Approach to Information Modeling and Analysis
Integrity Constraints in the Conceptual Schema Language SYSDOC
Proceedings of the Fourth International Conference on Entity-Relationship Approach
Expert System for Translating an E-R Diagram into Databases
Proceedings of the Fourth International Conference on Entity-Relationship Approach
Modelling the Time Dimension in an Entity-Relationship Diagram
Proceedings of the Fourth International Conference on Entity-Relationship Approach
A Normal Form For Entity-Relationship Diagrams
Proceedings of the Fourth International Conference on Entity-Relationship Approach
Theory of Relational Databases
Theory of Relational Databases
Relations as semantic constructs in an object-oriented language
OOPSLA '87 Conference proceedings on Object-oriented programming systems, languages and applications
Relational database design using an object-oriented methodology
Communications of the ACM
Semantic database modeling: survey, applications, and research issues
ACM Computing Surveys (CSUR)
A first year course in software design and use
ACM SIGCSE Bulletin
An improved Algorithm Based on Subset Closures for Synthesizing a Relational Database Scheme
IEEE Transactions on Software Engineering
ACM Computing Surveys (CSUR)
Controlling propagation of operations using attributes on relations
OOPSLA '88 Conference proceedings on Object-oriented programming systems, languages and applications
ER model clustering as an aid for user communication and documentation in database design
Communications of the ACM
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
On the correctness of representing extended entity-relationship structures in the relational model
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
DSM: an object-relationship modeling language
OOPSLA '89 Conference proceedings on Object-oriented programming systems, languages and applications
Comparing representations with relational and EER models
Communications of the ACM
Object subclass hierarchy in SQL: a simple approach
Communications of the ACM
A deductive method for entity-relationship modeling
VLDB '89 Proceedings of the 15th international conference on Very large data bases
Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
Identifying Extended Entity-Relationship Object Structures in Relational Schemas
IEEE Transactions on Software Engineering
Towards a semantic view of an extended entity-relationship model
ACM Transactions on Database Systems (TODS)
Object-preserving class transformations
OOPSLA '91 Conference proceedings on Object-oriented programming systems, languages, and applications
Reuse and productivity in integrated computer-aided software engineering: an empirical study
MIS Quarterly - Special issue on the strategic use of information systems
Representing extended entity-relationship structures in relational databases: a modular approach
ACM Transactions on Database Systems (TODS)
The design and implementation of hierarchical software systems with reusable components
ACM Transactions on Software Engineering and Methodology (TOSEM)
Suitability of datamodels as canonical models for federated databases
ACM SIGMOD Record
Information resource management: integrating the pieces
ACM SIGMIS Database
Query evaluation techniques for large databases
ACM Computing Surveys (CSUR)
A class library management system for object-oriented programming
SAC '93 Proceedings of the 1993 ACM/SIGAPP symposium on Applied computing: states of the art and practice
Binary relationship imposition rules on ternary relationships in ER modeling
CIKM '93 Proceedings of the second international conference on Information and knowledge management
Tools and transformations—rigorous and otherwise—for practical database design
ACM Transactions on Database Systems (TODS)
Database schema evolution using EVER diagrams
AVI '94 Proceedings of the workshop on Advanced visual interfaces
A close look at the IFO data model
ACM SIGMOD Record
Comparing data modeling formalisms
Communications of the ACM
Deriving functional dependencies from the entity-relationship model
Communications of the ACM
A Collaborative Schema Integration System
Computer Supported Cooperative Work
Automated Query Formulation Using an Entity–Relationship Conceptual Schema
Journal of Intelligent Information Systems
An analysis of cardinality constraints in redundant relationships
CIKM '97 Proceedings of the sixth international conference on Information and knowledge management
A virtual learning environment for entity relationship modelling
SIGCSE '98 Proceedings of the twenty-ninth SIGCSE technical symposium on Computer science education
Collaborative conceptual schema design: a process model and prototype system
ACM Transactions on Information Systems (TOIS)
Communications of the ACM
WSC '87 Proceedings of the 19th conference on Winter simulation
Semantics of update operations for an extended entity-relationship model
CSC '88 Proceedings of the 1988 ACM sixteenth annual conference on Computer science
The executive office of environmental affairs systems modernization project
CSC '91 Proceedings of the 19th annual conference on Computer Science
Improving database design through the analysis of relationships
ACM Transactions on Database Systems (TODS)
An ontological analysis of the relationship construct in conceptual modeling
ACM Transactions on Database Systems (TODS)
Emancipating instances from the tyranny of classes in information modeling
ACM Transactions on Database Systems (TODS)
CODASYS: a consulting tool for novice database designers
ACM SIGMIS Database
A Generic Content-Management Tool for Web Databases
IEEE Internet Computing
Experiences in Engineering Flexible Web Services
IEEE MultiMedia
Understanding semantic relationships
The VLDB Journal — The International Journal on Very Large Data Bases
On the Data Model and Access Method of Summary Data Management
IEEE Transactions on Knowledge and Data Engineering
One-to-One Dependencies in Database Design
IEEE Transactions on Knowledge and Data Engineering
IEEE Transactions on Knowledge and Data Engineering
IEEE Transactions on Knowledge and Data Engineering
A Theory of Translation From Relational Queries to Hierarchical Queries
IEEE Transactions on Knowledge and Data Engineering
A Framework for Analysis of Data Quality Research
IEEE Transactions on Knowledge and Data Engineering
Intelligent Query Answering by Knowledge Discovery Techniques
IEEE Transactions on Knowledge and Data Engineering
Part-Whole Relationship Categories and Their Application in Object-Oriented Analysis
IEEE Transactions on Knowledge and Data Engineering
A Methodology for Learning Across Application Domains for Database Design Systems
IEEE Transactions on Knowledge and Data Engineering
SEAM: A State-Entity-Activity-Model for a Well-Defined Workflow Development Methodology
IEEE Transactions on Knowledge and Data Engineering
Deductive Entity Relationship Modeling
IEEE Transactions on Knowledge and Data Engineering
Formal Foundations for Object-Oriented Data Modeling
IEEE Transactions on Knowledge and Data Engineering
Design and development of data-intensive web sites: The Araneus approach
ACM Transactions on Internet Technology (TOIT)
Understanding and Representing Relationship Semantics in Database Design
NLDB '00 Proceedings of the 5th International Conference on Applications of Natural Language to Information Systems-Revised Papers
Referential Integrity Revisited: An Object-Oriented Perspective
VLDB '90 Proceedings of the 16th International Conference on Very Large Data Bases
Mappings and Interoperability: A Meta-modelling Approach
ADVIS '00 Proceedings of the First International Conference on Advances in Information Systems
The Natural Language Modeling Procedure
NGITS '02 Proceedings of the 5th International Workshop on Next Generation Information Technologies and Systems
XGuide - A Practical Guide to XML-Based Web Engineering
Revised Papers from the NETWORKING 2002 Workshops on Web Engineering and Peer-to-Peer Computing
An Ontology-Based Framework for Generating and Improving Database Design
NLDB '02 Proceedings of the 6th International Conference on Applications of Natural Language to Information Systems-Revised Papers
A Polygen Model for Heterogeneous Database Systems: The Source Tagging Perspective
VLDB '90 Proceedings of the 16th International Conference on Very Large Data Bases
Object models as heap invariants
Programming methodology
Preserving relationship cardinality constraints in relational schemata
Database integrity
Prescription or Description: Some observations on the conceptual modelling process
SEEP '96 Proceedings of the 1996 International Conference on Software Engineering: Education and Practice (SE:EP '96)
Dealing with relationship cardinality constraints in relational database design
Effective databases for text & document management
A knowledge management scheme for meta-data: an information structure graph
Decision Support Systems - Special issue: Knowledge management technique
Improving quality in conceptual modeling
OOPSLA '04 Companion to the 19th annual ACM SIGPLAN conference on Object-oriented programming systems, languages, and applications
International Journal of Human-Computer Studies
Comparing Relationships in Conceptual Modeling: Mapping to Semantic Classifications
IEEE Transactions on Knowledge and Data Engineering
The use of a knowledge-based system in conceptual data modeling
Decision Support Systems
A design methodology for databases with uncertain data
SSDBM'1994 Proceedings of the 7th international conference on Scientific and Statistical Database Management
Design of the user-interface for an object-oriented statistical data-base
SSDBM'1988 Proceedings of the 4th international conference on Statistical and Scientific Database Management
A model of summary data and its applications in statistical databases
SSDBM'1988 Proceedings of the 4th international conference on Statistical and Scientific Database Management
Estimating LOC for information systems from their conceptual data models
Proceedings of the 28th international conference on Software engineering
Conceptual process configurations in enterprise knowledge management systems
Proceedings of the 2006 ACM symposium on Applied computing
Generating Compact Redundancy-Free XML Documents from Conceptual-Model Hypergraphs
IEEE Transactions on Knowledge and Data Engineering
REERM: reenhancing the entity-relationship model
Data & Knowledge Engineering - Special issue: ER 2004
ACM Transactions on Database Systems (TODS)
Project memory: information management for project teams
Journal of Management Information Systems - Special section: Managing virtual workplaces and teleworking with information technology
A method for easing normalization of user views
Journal of Management Information Systems - Special section: The impacts of business process change on organizational performance
Journal of Management Information Systems - Special section: Navigation in information-intensive environments
Enriching the ER model based on discovered association rules
Information Sciences: an International Journal
Using UML to model relational database operations
Computer Standards & Interfaces
Data modeling with imprecise and linguistic information
Journal of Intelligent & Fuzzy Systems: Applications in Engineering and Technology - Dedicated to the 60th birthday of Etienne E. Kerre
Journal of Management Information Systems
A methodology for metadata modelling: depth for a flat world
DCMI '04 Proceedings of the 2004 international conference on Dublin Core and metadata applications: metadata across languages and cultures
Resource space model, OWL and database: Mapping and integration
ACM Transactions on Internet Technology (TOIT)
Conceptual data model-based software size estimation for information systems
ACM Transactions on Software Engineering and Methodology (TOSEM)
Content based similarity of geographic classes organized as partition hierarchies
Knowledge and Information Systems
Theoretical foundations for conceptual modelling in information systems development
Decision Support Systems
The use of a knowledge-based system in conceptual data modeling
Decision Support Systems
Developing a unified design methodology based on extended entity-relationship model for XML
ICCS'03 Proceedings of the 2003 international conference on Computational science
Reflections on computer science and information systems research
ER'00 Proceedings of the 19th international conference on Conceptual modeling
Ontological analysis of taxonomic relationships
ER'00 Proceedings of the 19th international conference on Conceptual modeling
A conceptual modeling methodology based on niches and granularity
ER'07 Proceedings of the 26th international conference on Conceptual modeling
Augmenting traditional conceptual models to accommodate XML structural constructs
ER'07 Proceedings of the 26th international conference on Conceptual modeling
Ontology methodology based context awareness using system entity structure for network analysis
KES-AMSTA'08 Proceedings of the 2nd KES International conference on Agent and multi-agent systems: technologies and applications
MaDe4IC: an abstract method for managing model dependencies in inter-organizational cooperations
Service Oriented Computing and Applications
Fuzzy information modeling in UML class diagram and relational database models
Applied Soft Computing
Knowledge-based approaches to database design
MIS Quarterly
Tailoring database training for end users
MIS Quarterly
A derivation procedure for set-comparison constraints in fact-based modeling
OTM'11 Proceedings of the 2011th Confederated international conference on On the move to meaningful internet systems
Transformation from OWL description to resource space model
ASWC'06 Proceedings of the First Asian conference on The Semantic Web
On the Semantics of a Semantic Network
Fundamenta Informaticae
Extending conceptual data model for dynamic environment
ER'12 Proceedings of the 31st international conference on Conceptual Modeling
The hole in the whole: a response to Allen and March
MIS Quarterly
Reconciling theories with design choices in design science research
DESRIST'13 Proceedings of the 8th international conference on Design Science at the Intersection of Physical and Virtual Design
Information and Software Technology
Guidelines for representing complex cardinality constraints in binary and ternary relationships
Software and Systems Modeling (SoSyM)
Hi-index | 0.11 |
A database design methodology is defined for the design of large relational databases. First, the data requirements are conceptualized using an extended entity-relationship model, with the extensions being additional semantics such as ternary relationships, optional relationships, and the generalization abstraction. The extended entity-relationship model is then decomposed according to a set of basic entity-relationship constructs, and these are transformed into candidate relations. A set of basic transformations has been developed for the three types of relations: entity relations, extended entity relations, and relationship relations. Candidate relations are further analyzed and modified to attain the highest degree of normalization desired.The methodology produces database designs that are not only accurate representations of reality, but flexible enough to accommodate future processing requirements. It also reduces the number of data dependencies that must be analyzed, using the extended ER model conceptualization, and maintains data integrity through normalization. This approach can be implemented manually or in a simple software package as long as a "good" solution is acceptable and absolute optimality is not required.