You are required to design a DDBM system: Select a particular application (Manufacturing, Airlines, Hotels, etc.) for
Fantastic news! We've Found the answer you've been seeking!
Question:
You are required to design a DDBM system:
- Select a particular application (Manufacturing, Airlines, Hotels, etc.) for the design of a distributed database management system.
- Research and present attributes of two (2) tables from the selected application in (a) above.
- Populate about ten records each into the tables specified in (b) above.
- Show how you will partition one of the tables vertically into two (2) servers located at different sites.
- Partition the second table horizontally using any partitioning strategy. Justify the selection of that particular strategy.
- Select and sketch the distributed database architecture (consisting of at least 2 locations) for your application. Justify your selection of that particular architecture.
- Mention two different DDBMS software you will install on the two locations. Justify your choice.
- Mention one middleware you will employ to connect the two databases. Justify your choice.
- Write a materialized view query to select columns from the tables in (d) above, which were partitioned and placed on two different servers.
- Which replication scheme will you use to replicate data across the locations? Justify your choice.
- To help improve performance of your application, describe the parallelism technique you will employ.
Related Book For
Accounting Information Systems
ISBN: 9780132871938
11th Edition
Authors: George H. Bodnar, William S. Hopwood
Posted Date: