Matches in DBpedia 2014 for { <http://dbpedia.org/resource/Referential_integrity> ?p ?o. }
Showing items 1 to 42 of
42
with 100 items per page.
- Referential_integrity abstract "Referential integrity is a property of data which, when satisfied, requires every value of one attribute (column) of a relation (table) to exist as a value of another attribute in a different (or the same) relation (table).For referential integrity to hold in a relational database, any field in a table that is declared a foreign key can contain either a null value, or only values from a parent table's primary key or a candidate key. In other words, when a foreign key value is used it must reference a valid, existing primary key in the parent table. For instance, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity. Some relational database management systems (RDBMS) can enforce referential integrity, normally either by deleting the foreign key rows as well to maintain integrity, or by returning an error and not performing the delete. Which method is used may be determined by a referential integrity constraint defined in a data dictionary."Referential" the adjective describes the action that a foreign key performs, 'referring' to a link field in another table. In simple terms, 'referential integrity' is a guarantee that the target it 'refers' to will be found. A lack of referential integrity in a database can lead relational databases to return incomplete data, usually with no indication of an error. A common problem occurs with relational database tables linked with an 'inner join' which requires non-NULL values in both tables, a requirement that can only be met through careful design and referential integrity.".
- Referential_integrity thumbnail Referential_integrity_broken.png?width=300.
- Referential_integrity wikiPageID "445718".
- Referential_integrity wikiPageRevisionID "590028145".
- Referential_integrity hasPhotoCollection Referential_integrity.
- Referential_integrity subject Category:Data_quality.
- Referential_integrity subject Category:Database_management_systems.
- Referential_integrity type Abstraction100002137.
- Referential_integrity type Code106355894.
- Referential_integrity type CodingSystem106353757.
- Referential_integrity type Communication100033020.
- Referential_integrity type DatabaseManagementSystem106588785.
- Referential_integrity type DatabaseManagementSystems.
- Referential_integrity type Software106566077.
- Referential_integrity type Writing106359877.
- Referential_integrity type WrittenCommunication106349220.
- Referential_integrity comment "Referential integrity is a property of data which, when satisfied, requires every value of one attribute (column) of a relation (table) to exist as a value of another attribute in a different (or the same) relation (table).For referential integrity to hold in a relational database, any field in a table that is declared a foreign key can contain either a null value, or only values from a parent table's primary key or a candidate key.".
- Referential_integrity label "Integridad referencial".
- Referential_integrity label "Integridade referencial".
- Referential_integrity label "Intégrité référentielle".
- Referential_integrity label "Referential integrity".
- Referential_integrity label "Referentielle Integrität".
- Referential_integrity label "Referentiële integriteit".
- Referential_integrity label "Vincolo di integrità referenziale".
- Referential_integrity label "Ссылочная целостность".
- Referential_integrity label "参照整合性".
- Referential_integrity sameAs Referenční_integrita.
- Referential_integrity sameAs Referentielle_Integrität.
- Referential_integrity sameAs Integridad_referencial.
- Referential_integrity sameAs Intégrité_référentielle.
- Referential_integrity sameAs Vincolo_di_integrità_referenziale.
- Referential_integrity sameAs 参照整合性.
- Referential_integrity sameAs 참조무결성.
- Referential_integrity sameAs Referentiële_integriteit.
- Referential_integrity sameAs Integridade_referencial.
- Referential_integrity sameAs m.029clf.
- Referential_integrity sameAs Q1508721.
- Referential_integrity sameAs Q1508721.
- Referential_integrity sameAs Referential_integrity.
- Referential_integrity wasDerivedFrom Referential_integrity?oldid=590028145.
- Referential_integrity depiction Referential_integrity_broken.png.
- Referential_integrity isPrimaryTopicOf Referential_integrity.
