private bank, for example, call it Bank Podo, has many branches spread across several cities in America. Bank Podo's approach prioritizes customers in remote areas, where of course in these areas there are difficulties in terms of infrastructure such as the Internet. But because Bank Podo's mission is to serve the archipelago, infrastructure constraints are not used as an obstacle in providing services. The IT Division made the decision to build a distributed database, where each branch has its own database that specifically manages data in that area, which means that each branch has its own database. However, even though the databases are separate, each branch can read each other (share) the data of other branches, so that the user feels that all the databases are one or this condition is called distribution transparency
A private bank, for example, call it Bank Podo, has many branches spread across several cities in America. Bank Podo's approach prioritizes customers in remote areas, where of course in these areas there are difficulties in terms of infrastructure such as the Internet. But because Bank Podo's mission is to serve the archipelago, infrastructure constraints are not used as an obstacle in providing services. The IT Division made the decision to build a distributed
1. In distributed databases we are familiar with issues such as fragmentation, allocation and replication. What types of issues are included in Podo Bank?
2. If a customer table is divided by tuples and distributed over several branches, what type of fragmentation is used? Describe in tabular form how the customer table is fragmented, and prove whether it has complied with the 3 rules (completeness, reconstruction, and disjointness).
Step by step
Solved in 2 steps