Welcome to the InfoSci Platform
Reference Hub2
Atomicity and Semantic Normalization

Atomicity and Semantic Normalization

Andy Carver, Terry Halpin
Copyright: © 2010 |Volume: 1 |Issue: 2 |Pages: 17
ISSN: 1947-8186|EISSN: 1947-8194|EISBN13: 9781609604431|DOI: 10.4018/jismd.2010040102
Cite Article Cite Article

MLA

Carver, Andy, and Terry Halpin. "Atomicity and Semantic Normalization." IJISMD vol.1, no.2 2010: pp.23-39. http://doi.org/10.4018/jismd.2010040102

APA

Carver, A. & Halpin, T. (2010). Atomicity and Semantic Normalization. International Journal of Information System Modeling and Design (IJISMD), 1(2), 23-39. http://doi.org/10.4018/jismd.2010040102

Chicago

Carver, Andy, and Terry Halpin. "Atomicity and Semantic Normalization," International Journal of Information System Modeling and Design (IJISMD) 1, no.2: 23-39. http://doi.org/10.4018/jismd.2010040102

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

This paper contrasts two different approaches to designing relational databases that are free of redundancy. The Object-Role Modeling (ORM) approach captures semantics in terms of atomic (elementary or existential) fact types, before grouping the fact types into relation schemes. Normalization by decomposition instead focuses on “non0loss decomposition” to various, and progressively more refined, “normal forms”. Traditionally, non0loss decomposition of a relation requires decomposition into smaller relations that, upon natural join, yield the exact original population. Non-loss decomposition of a table scheme (or relation variable) requires that the decomposition of all possible populations of the relation scheme is reversible in this way. This paper shows that the dependency requirement for “all possible populations” is too restrictive for definitions of multi-valued and join dependencies over relation schemes. By exploiting ORM modeling heuristics, the authors offer new definitions of these data dependencies and non-loss decomposition, to enable these concepts to be addressed at a truly semantic level.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.