Skip to Main Content
Distributed Database Systems, 1st Edition by Chhanda Ray
book

Distributed Database Systems, 1st Edition by Chhanda Ray

by Chhanda Ray
May 2024
Intermediate to advanced content levelIntermediate to advanced
325 pages
12h 2m
English
Pearson India
Content preview from Distributed Database Systems, 1st Edition by Chhanda Ray
PropNo, BranchNo, Street, City, PostCode
(σ
Type = ‘FLAT’ PROPFORRENT.BranchNo = BRANCH.BranchNo
(PROPFORRENT w v BRANCH))
The horizontal fragments of PROPFORRENT relation are listed below.
PROPFORRENT
1
= σ
BranchNo = ‘B003’ Type = ‘HOUSE’
(PROPFORRENT)
PROPFORRENT
2
= σ
BranchNo = ‘B003’ Type = ‘FLAT’
(PROPFORRENT)
PROPFORRENT
3
= σ
BranchNo ‘B003’
(PROPFORRENT)
Similarly, the horizontal fragments of BRANCH relation are as follows.
BRANCH
1
= σ
BranchNo = ‘B003’
(BRANCH)
BRANCH
2
= σ
BranchNo ‘B003’
(BRANCH)
The canonical tree for the above query is
The optimized query tree for the above query is as follows.
Appendix 295
Π
PropNo, BranchNo, Street, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Distributed Systems, 2nd Edition

Distributed Systems, 2nd Edition

Sukumar Ghosh
Algorithms and Data Structures for Massive Datasets

Algorithms and Data Structures for Massive Datasets

Dzejla Medjedovic, Emin Tahirovic, Ines Schweigert
Architecting Distributed Transactional Applications

Architecting Distributed Transactional Applications

Guy Harrison, Andrew Marshall, Charles Custer

Publisher Resources

ISBN: 9781282652521Publisher WebsitePurchase Link