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

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”