Get fully
solved assignment. Buy online from website
online store
or
plz drop a mail
with your sub code
we will revert
you within 2-3 hour or immediate
Charges rs 125/subject only.
if urgent then call us
on 08791490301, 08273413412
Winter
2015
BC0058
Qus:1
Write the advantages and applications of Data Warehouse.
Ans:
The
advantages and applications of Data Warehouse:
The
advantages of Data Warehouse:
A Data Warehouse
provides a common data model for data, regardless of the data source. This
makes it easier to report and analyze
Qus:2
Write short notes on:
(i) Metadata Component
(ii) data Marts
Ans:
(i)
Metadata Component:
Metadata in a Data
Warehouse is similar to the data dictionary or the data catalog in a Database
Management System. In the data dictionary, you keep the information about the
logical data structures, the information about the files and addresses, the
information about the indexes, and so on. The Data Dictionary contains data
about the data in the database. Similarly, the Metadata component is the data
Qus:3
Write the Characteristics of Dimensional Table.
Ans:
The
Characteristics of Dimensional Table:
1.
Dimension
Table key. Primary key of the dimension table uniquely
identifies each row in the of rows.
Qus:
4 Discuss the Extraction Methods in Data Warehouses.
Ans:
Extraction
Methods in Data Warehouses:
The extraction
method you choose is highly dependent on the source system and also from the
business needs in the targeted Data Warehouse environment. The estimated amount of the data to be
extracted and
Qus:
5 Write short notes on:
(I) RAID 0
(ii) RAID 1
Ans:
(i)
RAID 0:
RAID 0 provides data
stripping. It takes data that needs to be stored and distributes it evenly
between two or more hard drives. Because the system considers the two hard
drives as one logical hard drive, the data is stored only once. In a two-drive
setup, for example, RAID 0 saves and accesses data quickly and efficiently.
Rather than one bit at a time, RAID 0 stores and retrieves two bits of data simultaneously.
Theoretically, the time it takes to save and access information is
Qus:
6 what is Metadata Management? Explain Integrated Metadata Management with a
block diagram.
Ans:
Metadata
Management:
The purpose of Metadata
management is to support the development and administration of data warehouse
Get fully
solved assignment. Buy online from website
online store
or
plz drop a mail
with your sub code
we will revert
you within 2-3 hour or immediate
Charges rs 125/subject only.
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment