Page 260 - DCAP603_DATAWARE_HOUSING_AND_DATAMINING

Data Warehousing and Data Mining

notes 2. ASP stands for:
(a) Active Server Page

(b) Active Service Page
(c) Active Server Paging
(d) Action Server Page
3. DTS stands for:
(a) Data Transformation Server

(b) Database Transformation Service
(c) Dialogue Transformation Service
(d) Data Transformation Service
Fill in the blanks:

4. ................... is a logical collection of data members.
5. There is no need for you to directly modify the ................... for the Data Warehouse.
6. The physical store contains all the data that you have imported from ...................
7. The ................... uses classes, data members, relations, and other data structures to map data
in the physical store.
8. ................... includes custom Data Transformation Service (DTS) tasks that simplify the
importing of data into the Data Warehouse.

9. A ................... is mainly required in a Data Warehousing Architecture for timing reasons.
10. Data in the Data Warehouse can be either persistent or ...................

13.6 review Questions

1. What are the pros and cons of data staging?
2. Describe data preparation for analysis with OLAP server.
3. How will you analyze the data? Discuss.
4. Describe data staging process in detail.

5. What do you mean by data transmission service?
6. Explain a connection between two classes in a parent-child relationship.
7. “Commerce Server automatically builds the physical store for the Data Warehouse in both
the SQL Server database and in the OLAP database.” Discuss.
8. What do you mean by logical schemas?
9. “A staging area is mainly required in a Data Warehousing Architecture for timing reasons.”
Explain.

10. What is the need of the representation of data warehouse?

254 LoveLy professionaL university