Paper Info
Title
Entity Integrity, Referential Integrity, and Query Optimization with Embedded Uniqueness Constraints
Abstract
Embedded uniqueness constraints represent unique column combinations embedded in complete fragments of incomplete data. In contrast to SQL UNIQUE constraints, they offer a principled separation of completeness and uniqueness requirements and are capable of exploiting more resource-conscious index structures. The latter help relational database systems to be more efficient in enforcing entity and referential integrity, and in evaluating common types of queries.
Year
DOI
Venue
2019
10.1109/ICDE.2019.00175
2019 IEEE 35th International Conference on Data Engineering (ICDE)
Keywords
Field
DocType
Indexes,Servers,Query processing,Runtime,Computer science,Registers
Query optimization,SQL,Uniqueness,Data mining,Information retrieval,Computer science,Entity integrity,Server,Relational database management system,Completeness (statistics),Referential integrity
Conference
ISSN
ISBN
Citations 
1084-4627
978-1-5386-7474-1
0
PageRank 
References 
Authors
0.34
0
3
Name
Order
Citations
PageRank
Ziheng Wei186.92
Uwe Leck211215.38
Sebastian Link346239.59