Quiz 2 Instructions
What client/server database and distributed database have in common is that in both cases the databases can be located other than “in the computer itself.”
In a two-tiered client/server arrangement, data can be found on each PC’s hard drive and data can be in a database at the server.
In the database server approach to client/server database, the actual database processing is done at the server.
One use of the term three-tier approach to client/server database is that data sought from one of the client PCs can be on any one of a succession of three other PCs on the LAN.
When data is distributed in a distributed database arrangement, the database is no longer considered to be a single, logical database.
A distributed database management system manages the distributed data as a single, logical database.
In a network environment, a centralized database provides local autonomy over the data.
Distributed data with no replication provides a high degree of availability.
The two-phase commit process is used for asynchronous updating of replicated data.
In the prepare phase of the two-phase commit process, the updated data is written to a log at each site but not to the database at each site.
Decision support systems are designed to make decisions for managers.
Data warehouse data is characterized as subject oriented.
Data warehouse data is less problematic if denormalized than operational data would be.
Due to the nature of DSS applications, data warehouse data must be up-to-the-moment current.
A data mart is a small-scale data warehouse that is designed to support a small part of an organization, say a department or a related group of departments.
Data warehouses are often referred to as multidimensional databases because each occurrence of the subject is referenced by an occurrence of each of several dimensions or characteristics of the subject.
The star schema approach to multidimensional data design is incompatible with relational database structures.
A star schema has a “fact table,” which represents the data warehouse “subject”.
Data enrichment is the process of copying the data from the transactional databases in preparation for loading it into the data warehouse.
Data cleaning or cleansing or scrubbing refers to fixing errors in data as it is being loaded into the operational database.
All of the following are true about a two-tiered client/server LAN, except ____.
a gateway computer can link the LAN to other LANs or to the Internet
data can reside on a client PC’s hard drive or at the server
searching for data is location transparent
a printer on the LAN is available to all of the client PCs
data transparency can extend to a mainframe external to the LAN
Compared to the file server approach, the database server approach to client/server database _____.
generates more network data traffic
requires more processing power at the server
requires a gateway connection to a mainframe computer
spreads security control through all of the client PCs
requires “fatter” client PCs with more processing power
Consider a distributed relational database in which there is no data replication. All of the following are true, except ____.
all of the table on the network is still available even if one site that has some tables goes down
every table can be placed at the site at which it is most heavily used
if one site goes down then the data at that site cannot be accessed there or anywhere else on the network
the integration of two tables that are not located at the same site will require a distributed join
if one site goes down at least some of the database’s tables will still be accessible
If a distributed database network with data replication has one node that has a copy of every table in the database ____.
the problem of data concurrency is eliminated
the issue of one site becoming a bottleneck is eliminated
the problem of data security is eliminated
at least one other copy of each table must also be stored elsewhere on the network
the problem of distributed joins is eliminated
If all went well during the prepare phase of the two-phase commit, then during the commit phase ____.
only the site issuing the update request writes the update to its database
all of the involved sites write the update to their logs
all of the involved sites write the update to their databases
all of the sites except the site issuing the update request write the update to their logs
all of the sites except the site issuing the update request write the update to their databases
Of the following applications or application systems, the one that would be considered a decision support system is ____.
a system that links companies in a supply chain
a hospital application that makes patient records available to all doctors and other health care professionals who are treating patients
a university course and grade record keeping system
a system that provides the management of a retail chain with data helpful in choosing sites for new stores
a payroll system
Data in a typical data warehouse ____.
is frequently updated by changing existing attribute values as the values change in the operational database
grows as new data is appended to the end of the existing tables
does not require timestamps
is always fully detailed, not summarized data
is organized according to the company’s TPS applications
An enterprise data warehouse (EDW) ____.
must be the sum of all of a company’s data marts
is designed to support a department or a related group of departments
cannot exist without data marts being present
must be fully normalized
supports an entire company or a major part of one
There is a(n) _____ relationship between each dimension table entity and the fact table entity in a star schema data warehouse structure.
____ is a decision support methodology based on viewing data in multiple dimensions.
Market basket analysis
Online analytic processing
Australian Boomerang, Ltd., wants to design a distributed relational database. The company is headquartered in Perth and has major operations in Sydney, Melbourne, and Darwin. The database involved consists of five tables, labeled A, B, C, D, and E, with the following characteristics:
Table A consists of 500,000 records and is heavily used in Perth and Sydney.
Table B consists of 100,000 records and is frequently required in all four cities.
Table C consists of 800 records and is frequently required in all four cities.
Table D consists of 75,000 records. Records 1-30,000 are most frequently used in Sydney. Records 30,001-75,000 are most frequently used in Melbourne.
Table E consists of 20,000 records and is used almost exclusively in Perth.
Design a distributed relational database for Australian Boomerang. Justify your placement, replication, and partitioning of the tables. (Please answer in complete sentences; do not submit any diagrams. This is a question about the architecture of how the distributed database is set up, balancing costs versus reliability, not how to design the schema.)
This question is from Chapter 13, question 2(a), page 364. Refer to the database schema on pages 363-364 to use in answering this question.
Design a multidimensional database using a star schema for a data warehouse for the Best Airlines, Inc., airplane maintenance environment described by the database schema. The main subject will be maintenance event, starting with the fact table EVENT. Complete the rest of the design, including snowflake tables as appropriate. Use the Dropbox for Quiz 2: Q32 to submit a diagram or a text-based schema representation is also acceptable. Using the ERD design tool in MySQL Workbench, if you have it, is an appropriate tool for this assignment. (Hint: see Fig 13.9, p 350 for an example of a star schema design)
PLACE THIS ORDER OR A SIMILAR ORDER WITH AMAZON PAPERS TODAY AND GET AN AMAZING DISCOUNT