Matches in SemOpenAlex for { <https://semopenalex.org/work/W582667619> ?p ?o ?g. }
Showing items 1 to 77 of
77
with 100 items per page.
- W582667619 abstract "This research presents a complete analysis of structural validity and relationships in the entity-relationship (ER) model. Direct treatment of structural validity and relationships is rare in the literature. In practice there is no complete set of heuristics to holistically evaluate the structural validity or conclusively identify a relationship in ER diagrams. Some validity rules are partly discussed in publications, but they do not exhaustively cover all the combinations of maximum and minimum cardinality and address only the most commonly used structures.Current approaches for identifying relationships depend on the use of functional dependencies and do not consider minimum cardinality constraints. This omission disallows the inference of true transitive connectivity even with the presence of a related connection constraint. Existing approaches can only conclude that the relationship is suspiciously redundant. In practice, this leaves the decision of removing a suspiciously redundant relationship to the subjective judgement of the designer.Our approach differs from previous works in that it: (1) Addresses both maximum and minimum cardinality constraints. (2) Considers the impact of ternary relationships on redundancy. (3) Presents a holistic analysis of unary, binary, and ternary relationships as they coexist in a complex overall diagram. (4) Treats structural validity and redundancy together.The study provides a thorough pattern analysis of relationships and shows they are sufficiently determined by the cardinality constraints coupled with a semantic connection constraint. The analysis yields a comprehensive set of thirty decision rules to determine the structural validity and the redundancy of any unary, binary, and ternary relationship in a complex multi-path environment. These rules can easily be incorporated into the modeling process or extended into case tools implementations. This study extends previous works on ternary relationship validity to the areas of minimum cardinality constraints and the structural validity of a complete diagram where a ternary relationship coexists. This study lays a foundation in the analysis of structural validity and relationship redundancy in object modeling. We have shown that the analysis rules identified for data modeling are readily adaptable for the analysis of redundancy in object modeling with association, aggregation, and inheritance constructs." @default.
- W582667619 created "2016-06-24" @default.
- W582667619 creator A5067437365 @default.
- W582667619 creator A5076804314 @default.
- W582667619 date "1998-01-01" @default.
- W582667619 modified "2023-09-25" @default.
- W582667619 title "An analysis of redundant relationships in data and object modeling" @default.
- W582667619 hasPublicationYear "1998" @default.
- W582667619 type Work @default.
- W582667619 sameAs 582667619 @default.
- W582667619 citedByCount "0" @default.
- W582667619 crossrefType "journal-article" @default.
- W582667619 hasAuthorship W582667619A5067437365 @default.
- W582667619 hasAuthorship W582667619A5076804314 @default.
- W582667619 hasConcept C111919701 @default.
- W582667619 hasConcept C11413529 @default.
- W582667619 hasConcept C114614502 @default.
- W582667619 hasConcept C118615104 @default.
- W582667619 hasConcept C124101348 @default.
- W582667619 hasConcept C126255220 @default.
- W582667619 hasConcept C127705205 @default.
- W582667619 hasConcept C152124472 @default.
- W582667619 hasConcept C177264268 @default.
- W582667619 hasConcept C191399111 @default.
- W582667619 hasConcept C199360897 @default.
- W582667619 hasConcept C2524010 @default.
- W582667619 hasConcept C2776036281 @default.
- W582667619 hasConcept C33923547 @default.
- W582667619 hasConcept C41008148 @default.
- W582667619 hasConcept C78023250 @default.
- W582667619 hasConcept C80444323 @default.
- W582667619 hasConcept C87117476 @default.
- W582667619 hasConceptScore W582667619C111919701 @default.
- W582667619 hasConceptScore W582667619C11413529 @default.
- W582667619 hasConceptScore W582667619C114614502 @default.
- W582667619 hasConceptScore W582667619C118615104 @default.
- W582667619 hasConceptScore W582667619C124101348 @default.
- W582667619 hasConceptScore W582667619C126255220 @default.
- W582667619 hasConceptScore W582667619C127705205 @default.
- W582667619 hasConceptScore W582667619C152124472 @default.
- W582667619 hasConceptScore W582667619C177264268 @default.
- W582667619 hasConceptScore W582667619C191399111 @default.
- W582667619 hasConceptScore W582667619C199360897 @default.
- W582667619 hasConceptScore W582667619C2524010 @default.
- W582667619 hasConceptScore W582667619C2776036281 @default.
- W582667619 hasConceptScore W582667619C33923547 @default.
- W582667619 hasConceptScore W582667619C41008148 @default.
- W582667619 hasConceptScore W582667619C78023250 @default.
- W582667619 hasConceptScore W582667619C80444323 @default.
- W582667619 hasConceptScore W582667619C87117476 @default.
- W582667619 hasLocation W5826676191 @default.
- W582667619 hasOpenAccess W582667619 @default.
- W582667619 hasPrimaryLocation W5826676191 @default.
- W582667619 hasRelatedWork W1588360768 @default.
- W582667619 hasRelatedWork W1984709282 @default.
- W582667619 hasRelatedWork W2005654931 @default.
- W582667619 hasRelatedWork W2024426984 @default.
- W582667619 hasRelatedWork W2048841336 @default.
- W582667619 hasRelatedWork W2063391368 @default.
- W582667619 hasRelatedWork W2074053575 @default.
- W582667619 hasRelatedWork W2120839785 @default.
- W582667619 hasRelatedWork W2120996593 @default.
- W582667619 hasRelatedWork W2131060875 @default.
- W582667619 hasRelatedWork W2134835128 @default.
- W582667619 hasRelatedWork W2166131714 @default.
- W582667619 hasRelatedWork W2488169390 @default.
- W582667619 hasRelatedWork W2489468360 @default.
- W582667619 hasRelatedWork W2535582266 @default.
- W582667619 hasRelatedWork W2554780797 @default.
- W582667619 hasRelatedWork W2747609880 @default.
- W582667619 hasRelatedWork W2791510784 @default.
- W582667619 hasRelatedWork W611109557 @default.
- W582667619 hasRelatedWork W189714346 @default.
- W582667619 isParatext "false" @default.
- W582667619 isRetracted "false" @default.
- W582667619 magId "582667619" @default.
- W582667619 workType "article" @default.