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 and rs 375/semester only.
if urgent then call us
on 08791490301, 08273413412
PROGRAM:
BCA (REVISED 2007)
SEMESTER:
6TH SEM
SUBJECT
CODE & NAME: BC0058 – DATA WAREHOUSING
CREDIT:
4
BK
ID: B1011
MAX.
MARKS: 60
Q.1: Differentiate between OLTP and
Data Warehouse.
ANS:
o
Application
databases are OLTP (On-Line Transaction Processing) systems where every transaction
has to be recorded as and when it occurs. Consider the scenario where a bank
ATM has disbursed cash toa customer but was unable to record this event in the
bank records. If this happens
Q.2:
What are the key issues in Planning a Data Warehouse.
ANS:
There are various issues related
to the proper planning of a Data Warehouse.
Key Issues during Datawarehouse
Construction:
Planning for your Data Warehouse
begins with a thorough consideration ofthe key issues. Answers to the key
Q.3:
Explain Source Data Component and Data Staging Components of Data Warehouse
Architecture.
ANS:
Source
Data Component: Three
major functions need to be performed in source data component.
Production Data:
This category of data comes from
the various operational systems of the enterprise. Based on the information
requirements in the Data Warehouse, you choose segments of data from the
different operational systems. While dealing with this data, you come across many
variations in the data formats. You also notice that the
Q.4:
Discuss the Extraction Methods in Data Warehouses.
ANS:
The extraction method you choose
is highly dependent on the source system and also from the business needs in
the targeted Data Warehouse environment. Very often, there's no possibility to
add additional logic to the source systems to enhance an incremental extraction
of data due to the performance or the increased
Q.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.
Q.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 infrastructure
as well as analysis of the data of time. Metadata widely considered as a
promising driver for improving effectiveness and efficiency of data warehouse
usage, development, maintenance and
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 and rs 375/semester only.
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment