| dbo:abstract |
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 principles of database design, which seek to prevent databases from being too complicated or redundant, the first principle being the. 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. The principle is a restatement of the requirement that a database is a minimum cover set of the relational algebra. The relational algebra allows data duplication in the relations that are the elements of the algebra. One of the efficiency requirements of a database is that there be no data duplication. This requirement is met by the minimum cover set of the relational algebra. (en) |
| dbo:wikiPageExternalLink |
https://web.archive.org/web/20080517003842/http:/www.dbdebunk.com/page/page/622312.htm https://web.archive.org/web/20080807163857/http:/www.dbdebunk.com/page/page/622331.htm |
| dbo:wikiPageID |
18533792 (xsd:integer) |
| dbo:wikiPageLength |
1834 (xsd:nonNegativeInteger) |
| dbo:wikiPageRevisionID |
833527117 (xsd:integer) |
| dbo:wikiPageWikiLink |
dbr:View_(database) dbr:David_McGoveran dbc:Database_theory dbr:Christopher_J._Date dbr:Database_design dbr:Database_normalization dbr:Relational_database dbr:POFN dbr:Principle_of_full_normalization |
| dbp:wikiPageUsesTemplate |
dbt:Primary_sources |
| dct:subject |
dbc:Database_theory |
| rdfs:comment |
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 principles of database design, which seek to prevent databases from being too complicated or redundant, the first principle being the. (en) |
| rdfs:label |
Principle of orthogonal design (en) |
| owl:sameAs |
freebase:Principle of orthogonal design wikidata:Principle of orthogonal design https://global.dbpedia.org/id/4ti2Y |
| prov:wasDerivedFrom |
wikipedia-en:Principle_of_orthogonal_design?oldid=833527117&ns=0 |
| foaf:isPrimaryTopicOf |
wikipedia-en:Principle_of_orthogonal_design |
| is dbo:wikiPageRedirects of |
dbr:Principle_of_Orthogonal_Design dbr:POOD |
| is dbo:wikiPageWikiLink of |
dbr:Database_design dbr:Fabian_Pascal dbr:Principle_of_Orthogonal_Design dbr:POOD |
| is foaf:primaryTopic of |
wikipedia-en:Principle_of_orthogonal_design |