Principle of Orthogonal Design
- Principle of Orthogonal Design
The Principle of Orthogonal Design (abbreviated POOD) was developed by database researchers David McGoveran and Christopher J. Date in the early 1990s, and first published "A New Database Design Principle" in the July 1994 issue of Database Programming and Design and reprinted several times. It is the second of the two priciples of database design, which seek to prevent databases from being too complicated or redundant, the first principle being the Principle of Full Normalization (POFN).
Simply put, it says that no two relations in a relational database should be defined in such a way that they can represent the same facts. As with database normalization, POOD serves to eliminate uncontrolled storage redundancy and expressive ambiguity, especially useful for applying updates to virtual relations (e.g., view (database)). Although simple in concept, POOD is frequently misunderstood and the formal expression of POOD continues to be refined.
Sources
* Database Debunkings: The Principle of Orthogonal Design, Part I, by D. McGoveran and C. J. Date [http://www.dbdebunk.com/page/page/622331.htm]
* Database Debunkings: The Principle of Orthogonal Design, Part II, by D. McGoveran and C. J. Date [http://www.dbdebunk.com/page/page/622312.htm]
* David McGoveran (personal interview) [http://www.alternativetech.com]
Wikimedia Foundation.
2010.
Look at other dictionaries:
Database design — is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which… … Wikipedia
Orthogonal frequency-division multiplexing — Passband modulation v · d · e Analog modulation AM · … Wikipedia
David McGoveran — is a consultant, researcher, lecturer, and industry analyst to the software industry; author of numerous books and articles in the fields of relational databases, transaction processing, business intelligence, business process management,… … Wikipedia
Fabian Pascal — is a consultant to large software vendors such as IBM, Oracle Corporation, and Borland, but is better known as an author and seminar speaker. Born in Romania, Pascal lives in the San Francisco, California area of the U.S., and works in… … Wikipedia
Ant colony optimization algorithms — Ant behavior was the inspiration for the metaheuristic optimization technique. In computer science and operations research, the ant colony optimization algorithm (ACO) is a probabilistic technique for solving computational problems which can be… … Wikipedia
List of combinatorics topics — This is a list of combinatorics topics.A few decades ago it might have been said that combinatorics is little more than a way to classify poorly understood problems, and some standard remedies. Great progress has been made since 1960.This page is … Wikipedia
combinatorics — /keuhm buy neuh tawr iks, tor , kom beuh /, n. (used with singular v.) See combinatorial analysis. * * * Branch of mathematics concerned with the selection, arrangement, and combination of objects chosen from a finite set. The number of possible… … Universalium
Optics — For the book by Sir Isaac Newton, see Opticks. Optical redirects here. For the musical artist, see Optical (artist). Optics includes study of dispersion of light. Optics is the branch of … Wikipedia
mathematics — /math euh mat iks/, n. 1. (used with a sing. v.) the systematic treatment of magnitude, relationships between figures and forms, and relations between quantities expressed symbolically. 2. (used with a sing. or pl. v.) mathematical procedures,… … Universalium
solids, mechanics of — ▪ physics Introduction science concerned with the stressing (stress), deformation (deformation and flow), and failure of solid materials and structures. What, then, is a solid? Any material, fluid or solid, can support normal forces.… … Universalium
