This HTML5 document contains 35 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Namespace Prefixes

PrefixIRI
dctermshttp://purl.org/dc/terms/
yago-reshttp://yago-knowledge.org/resource/
dbohttp://dbpedia.org/ontology/
foafhttp://xmlns.com/foaf/0.1/
n14https://global.dbpedia.org/id/
yagohttp://dbpedia.org/class/yago/
rdfshttp://www.w3.org/2000/01/rdf-schema#
freebasehttp://rdf.freebase.com/ns/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
owlhttp://www.w3.org/2002/07/owl#
wikipedia-enhttp://en.wikipedia.org/wiki/
dbpedia-zhhttp://zh.dbpedia.org/resource/
dbchttp://dbpedia.org/resource/Category:
provhttp://www.w3.org/ns/prov#
xsdhhttp://www.w3.org/2001/XMLSchema#
wikidatahttp://www.wikidata.org/entity/
dbrhttp://dbpedia.org/resource/

Statements

Subject Item
dbr:Propagation_constraint
rdf:type
yago:Communication100033020 yago:RelationalDatabaseManagementSystem106588998 yago:WikicatRelationalDatabaseManagementSystems yago:Writing106359877 yago:DatabaseManagementSystem106588785 yago:Code106355894 yago:Abstraction100002137 yago:Software106566077 yago:WrittenCommunication106349220 yago:CodingSystem106353757
rdfs:label
Propagation constraint 传播约束
rdfs:comment
在数据库系统中，传播约束（propagation constraint）“详细说明了当我们更新目标表的一行或多行时相关表应该发生的情况”。表使用主键与外键关系实现链接。用户可能会更新其中的一个表导致这种关系不再保持一致，这称为破坏了参照完整性。例如，如果员工表包含“家庭用品部门”的部门编号，它是部门表的外键，并且用户从部门表中删除了该部门，则家庭用品部门员工记录将引用不再存在的部门编号。 关系数据库管理系统解决此问题的方法是传播约束，以确保表之间的关系保持无错。Beynon-Davies列出了关系数据库管理系统处理删除目标和关联元组的三种方式： * Restricted Delete - 在所有（通过外键）指向它的行都被删除之前，用户不能删除目标行。这意味着在从部门表中删除部门之前，需要删除所有家庭用品部门员工，或者更改他们的部门。 * Cascades Delete - 可以删除目标行且所有（通过外键）指向它的行也被删除。 * Nullifies Delete - 可以删除目标行并把所有（指向它的）外键都置为空。在这种情况下，删除家庭用品部门后，在该部门工作的员工的部门将具有NULL（未知）值。 In database systems, a propagation constraint "details what should happen to a related table when we update a row or rows of a target table" (Paul Beynon-Davies, 2004, p.108). Tables are linked using primary key to foreign key relationships. It is possible for users to update one table in a relationship in such a way that the relationship is no longer consistent and this is known as breaking referential integrity. An example of breaking referential integrity: if a table of employees includes a department number for 'Housewares' which is a foreign key to a table of departments and a user deletes that department from the department table then Housewares employees records would refer to a non-existent department number.
dcterms:subject
dbc:Relational_database_management_systems
dbo:wikiPageID
1943509
dbo:wikiPageRevisionID
844164032
dbo:wikiPageWikiLink
dbc:Relational_database_management_systems dbr:Relational_database_management_system dbr:Foreign_key dbr:Palgrave_Macmillan dbr:Primary_key dbr:Null_(SQL) dbr:Tuple dbr:Referential_integrity
owl:sameAs
wikidata:Q7250070 dbpedia-zh:传播约束 yago-res:Propagation_constraint n14:4tg9E freebase:m.067xbv
dbo:abstract
在数据库系统中，传播约束（propagation constraint）“详细说明了当我们更新目标表的一行或多行时相关表应该发生的情况”。表使用主键与外键关系实现链接。用户可能会更新其中的一个表导致这种关系不再保持一致，这称为破坏了参照完整性。例如，如果员工表包含“家庭用品部门”的部门编号，它是部门表的外键，并且用户从部门表中删除了该部门，则家庭用品部门员工记录将引用不再存在的部门编号。 关系数据库管理系统解决此问题的方法是传播约束，以确保表之间的关系保持无错。Beynon-Davies列出了关系数据库管理系统处理删除目标和关联元组的三种方式： * Restricted Delete - 在所有（通过外键）指向它的行都被删除之前，用户不能删除目标行。这意味着在从部门表中删除部门之前，需要删除所有家庭用品部门员工，或者更改他们的部门。 * Cascades Delete - 可以删除目标行且所有（通过外键）指向它的行也被删除。 * Nullifies Delete - 可以删除目标行并把所有（指向它的）外键都置为空。在这种情况下，删除家庭用品部门后，在该部门工作的员工的部门将具有NULL（未知）值。 In database systems, a propagation constraint "details what should happen to a related table when we update a row or rows of a target table" (Paul Beynon-Davies, 2004, p.108). Tables are linked using primary key to foreign key relationships. It is possible for users to update one table in a relationship in such a way that the relationship is no longer consistent and this is known as breaking referential integrity. An example of breaking referential integrity: if a table of employees includes a department number for 'Housewares' which is a foreign key to a table of departments and a user deletes that department from the department table then Housewares employees records would refer to a non-existent department number. Propagation constraints are methods used by relational database management systems (RDBMS) to solve this problem by ensuring that relationships between tables are preserved without error. In his database textbook, Beynon-Davies explains the three ways that RDBMS handle deletions of target and related tuples: * Restricted Delete - the user cannot delete the target row until all rows that point to it (via foreign keys) have been deleted. This means that all Housewares employees would need to be deleted, or their departments changed, before removing the department from the departmental table. * Cascades Delete - can delete the target row and all rows that point to it (via foreign keys) are also deleted. The process is the same as a restricted delete, except that the RDBMS would delete the Houseware employees automatically before removing the department. * Nullifies Delete - can delete the target row and all foreign keys (pointing to it) are set to null. In this case, after removing the housewares department, employees who worked in this department would have a NULL (unknown) value for their department.
prov:wasDerivedFrom
wikipedia-en:Propagation_constraint?oldid=844164032&ns=0
dbo:wikiPageLength
2081
foaf:isPrimaryTopicOf
wikipedia-en:Propagation_constraint