One problem area with DDBMSs is that of distributed database design. Discuss the issues that have to be addressed with distributed database design. Discuss how these issues apply to the global system catalog.
What will be an ideal response?
The question that is being addressed is how the database and the applications that run against it should
be placed across the sites. Two basic alternatives: partitioned or replicated. In partitioned scheme
database is divided into a number of disjoint partitions each of which is placed at a different site.
Replicated designs can be fully or partially replicated.
Two fundamental design issues are fragmentation and distribution. Mostly involves mathematical
programming to minimize combined cost of storing the database, processing transactions against it,
and communication. Problem is NP-hard; therefore proposed solutions are based on heuristics.
The global system catalog (GSC) is only relevant if we talk about a distributed DBMS or multi-
DBMS that uses a global conceptual schema. Problems are similar to above. Briefly, a GSC may be
either global to entire database or local; it may be maintained centrally at one site, or in a distributed
fashion over a number of sites; finally, replication - there may be a single copy of the directory or
multiple copies. These three dimensions are orthogonal to one another.
You might also like to view...
What sign used with the DOS FIND command is used to redirect the output of a program?
A. > B. <
C. + D. *The ______ provides a benchmark by which businesses can measure how well they are protecting the privacy of individuals.
Fill in the blank(s) with the appropriate word(s).
Theme fonts include both the Heading fonts and Body fonts
Indicate whether the statement is true or false
Case-Based Critical Thinking Questions ? Case 3-2 In PowerPoint 2016, Bella is learning how to merge shapes. She has merged one shape with the help of a co-worker, and is now ready to try it on her own. To merge shapes, Bella needs to use the commands on the Merge Shapes menu in the _____ Shapes group on the Drawing Tools Format tab.
A. Insert B. Edit C. Transform D. Merge