Databases Reference
In-Depth Information
telecommunications costs between those three cities
and Halifax and Vancouver are relatively high.
A query is issued from Montreal that requires a
join of tables A, B, and C. The query involves a
single record from table A, 20 records from table B,
and an undetermined number of records from table
C. Develop and justify a plan for solving this query.
MINICASES
1.
Consider the Happy Cruise Lines relational database in
Minicase 5.1.The company has decided to reconfigure
this database as a distributed database among its major
locations: New York, which is its headquarters, and
its other major U.S. ports, Miami, Los Angeles, and
Houston. Distributed and replicated among these four
locations, the tables have the following characteristics:
SHIP consists of 20 records and is used in all four
cities.
CRUISE consists of 4,000 records. CRUISE records
are used most heavily in the cities from which the
cruise described in the record began.
PORT consists of 42 records. The records that
describe Atlantic Ocean ports are used most
heavily in New York and Miami. The records
that describe Caribbean Sea ports are used most
heavily in Houston and Miami. The records that
describe Pacific Ocean ports are used most heavily
in Los Angeles.
VISIT consists of 15,000 records and is primarily
used in New York and Los Angeles.
PASSENGER consists of 230,000 records and is
primarily used in New York and Los Angeles.
VOYAGE consists of 720,000 records and is used in
all four cities.
Design a distributed relational database for Happy
Cruise Lines. Justify your placement, replication, and
partitioning of the tables.
2.
Consider the Super Baseball League relational database
in Minicase 5.2. The league has decided to organize
its database as a distributed database with replicated
tables. The nodes on the distributed database will
be Chicago (the league's headquarters), Atlanta, San
Francisco (where the league personnel office is located),
and Dallas. The tables have the following
charac-
teristics:
TEAM consists of 20 records and is located in
Chicago and Atlanta.
COACH consists of 85 records and is located in
San Francisco and Dallas.
WORKEXP consists of 20,000 records and is located
in San Francisco and Dallas.
BATS consists of 800,000 records and is located in
Chicago and Atlanta.
PLAYER consists of 100,000 records and is located
in San Francisco and Atlanta.
AFFILIATION consists of 20,000 records and is
located in Chicago and San Francisco.
STADIUM consists of 20 records and is located only
in Chicago.
Assume that telecommunications costs among the cities
are all about the same.
Develop and justify a plan for solving the following
queries:
a. A query is issued from Chicago to get a list of all the
work experience of all the coaches on the Dodgers.
b. A query is issued from Atlanta to get a list of the
names of the coaches who work for the team based
at Smith Memorial Stadium.
c. A query is issued from Dallas to find the names of all
the players who have compiled a batting average of
at least. 300 while playing on the Dodgers.
Search WWH ::
Custom Search