Database Reference
In-Depth Information
5. What is a STAR schema? How is it applicable as a data model for data
warehouses?
6. Explain the need for OLAP. What are the two common OLAP models?
Describe briefly any one of the models.
7. How is data mining different from OLAP?
8. What types of parallelism do parallel databases provide?
9. What are multimedia databases? Why are they essential in the modern
environment?
10. What are geographic databases? List any six types of applications these data-
bases support.
EXERCISES
1. Indicate whether true or false:
A. In object orientation, abstract data types provide encapsulation.
B. Methods and messages are the same in object-oriented systems.
C. The E-R modeling technique is highly suitable for data warehouses.
D. Parallel databases work on the event-condition-action paradigm.
E. Deductive databases combine logic programming and an inference engine.
F. In a mobile computing environment, fixed hosts are connected to support
or base stations.
G. In geographic databases, raster data are created from geometric objects
such as points, lines, and so on.
H. In an object-relational database environment, users can define their own
data types and functions.
I. Horizontal parallelism works best if data are partitioned across multiple
disks.
J. In a STAR schema, the fact table contains metrics for analysis.
2. Compare and contrast the functions and features of RDBMS, OODBMS, and
ORDBMS.
3. Describe the basic components of a data warehouse.
4. Write a short description of data mining. List any four application areas and
explain how data mining is useful in these areas.
5. You are a manager of special projects for a large distributor of canned food
items. Your company distributes these products to all leading supermarket
chains and other convenience stores in the northeast region of the U.S. The
region is divided into many districts, each district having a team of sales-
persons. Plan a mobile computing system to cater to the needs of the travel-
ing sale force. They would need customer, order, product, and inventory
information from the proposed mobile database. Prepare a plan outline,
considering the overall architecture, data distribution, data access require-
ments, and other major aspects.
Search WWH ::
Custom Search