Database System ConceptsThis popular text in database systems is used in departments of computer science, computer engineering, and electrical engineering. The revision includes more material on SQL, relational models, logical databases, "QB" and "Datalog." |
From inside the book
Results 1-3 of 41
Page 178
... decomposition of Borrow - scheme into Amt - scheme and Loan - scheme a lossy decomposition , or a lossy - join decomposition . A decomposition that is not a lossy - join decomposition is referred to as a lossless - join decomposition ...
... decomposition of Borrow - scheme into Amt - scheme and Loan - scheme a lossy decomposition , or a lossy - join decomposition . A decomposition that is not a lossy - join decomposition is referred to as a lossless - join decomposition ...
Page 181
... decomposition has several desirable properties , which we discuss below . Lossless - Join Decomposition In Section 6.1.2 , we have argued that it is crucial when decomposing a relation into a number of smaller relations that the ...
... decomposition has several desirable properties , which we discuss below . Lossless - Join Decomposition In Section 6.1.2 , we have argued that it is crucial when decomposing a relation into a number of smaller relations that the ...
Page 198
... decomposition of R. This decomposition is a lossless - join decomposition of R if and only if at least one of the following multivalued dependencies is in D * : R1OR2 → R1 1 R2 R1OR2 → R2 R1 R2 R2 , then Recall that we stated earlier ...
... decomposition of R. This decomposition is a lossless - join decomposition of R if and only if at least one of the following multivalued dependencies is in D * : R1OR2 → R1 1 R2 R1OR2 → R2 R1 R2 R2 , then Recall that we stated earlier ...
Contents
Introduction | 1 |
EntityRelationship Model | 23 |
Relational Model | 53 |
Copyright | |
40 other sections not shown
Common terms and phrases
abort account-number algorithm allows attributes B-tree bank BCNF block borrow branch-city branch-name bucket buffer candidate key cascading rollback Chapter commit compute concurrency control conflict serializable consider constraints contains coordinator corresponding CustAcct customer-city customer-name data item data model database system DBTG deadlock decomposition defined delete discussed disk domain domain relational calculus Downtown E-R diagram employees ensure entity set example execution expression functional dependencies hash function implementation insert Johnson join loan loan-number log records main memory manager Mianus multivalued dependencies node object-oriented Perryridge branch pointer primary key query language r₁ R₂ read(A record type recovery relation scheme relational algebra relational database relationship set require result rule schedule search-key value Section serializability set occurrence shown in Figure stable storage Stonebraker stored strategy structure superkey T₁ T₂ techniques timestamp transaction tree-structure diagram tuple relational calculus update wait-for graph weak entity write write(Q