BC0058 – DATA WAREHOUSING

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

help.mbaassignments@gmail.com

or

call us at : 08263069601

WINTER 2015, ASSIGNMENT

PROGRAM	BCA(REVISED 2007)
SEMESTER	6TH SEM
SUBJECT CODE & NAME	BC0058 – DATA WAREHOUSING
CREDITS	4
BK ID	B1011
MAX. MARKS	60

ANSWER ALL THE QUESTIONS

Question.1. Write the advantages and applications of DataWarehouse.

Answer:Data warehouses are the traditional solution for data integration, and for good reason, but this is becoming increasingly difficult to scale and copy data from multiple data sources in multiple organizations in multiple locations

Question.2. Write short notes on:

(i) Metadata Component

Answer:Metadata for language resources and tools exists in a multitude of formats. Often these descriptions contain specialized information for a specific research community (e.g. TEI headers for text, IMDI for multimedia collections).

To overcome this dispersion CLARIN has initiated the

(ii) data Marts

Answer:A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse that is usually oriented to a specific business line or team. Data marts are small slices of the data warehouse. Whereas data warehouses have an enterprise-wide depth, the information in data marts pertains to a single department. In some deployments, each department or business unit is considered the owner of its data mart including all the hardware,

Question.3. Write the Characteristics of Dimensional Table.

Answer:In data warehousing, a dimension table is one of the set of companion tables to a fact table.

The fact table contains business facts (or measures), and foreign keys which refer to candidate keys (normally primary keys) in the dimension tables.

Contrary to fact tables, dimension tables contain descriptive attributes (or fields) that are typically textual fields (or discrete numbers that behave like text). These attributes are designed to serve two critical purposes: query constraining and/or filtering, and query result set labeling.

Question.4. Discuss the Extraction Methods in Data Warehouses.

Answer:Extraction is the operation of extracting data from a source system for further use in a data warehouse environment. This is the first step of the ETL process. After the extraction, this data can be transformed and loaded into the data warehouse.

The source systems for a data warehouse are typically transaction processing applications. For example, one of the source systems for a sales analysis data warehouse might be an order entry system that records all of the current order

Question.5. Write short notes on :

(i) RAID 0

Answer:    RAID 0 consists of striping, without mirroring or parity. The capacity of a RAID 0 volume is the sum of the capacities of the disks in the set, the same as with a spanned volume. There is no added redundancy for handling disk failures, just as with a spanned volume. Thus, failure of one disk causes the loss of the entire RAID 0 volume, with reduced possibilities of data recovery when compared to a broken spanned volume. Striping

(ii) RAID 1

Answer:RAID 1 consists of data mirroring, without parity or striping. Data is written identically to two (or more) drives, thereby producing a "mirrored set" of drives. Thus, any read request can be serviced by any drive in the set. If a request is broadcast to every drive in the set, it can be serviced by the drive that accesses the data first (depending on its seek time and rotational latency), improving performance. Sustained read

Question.6. What is Metadata Management? Explain IntegratedMetadata Management with a block diagram.

Answer:Meta-data management (also known as metadata management, without the hyphen) involves managing data about other data, whereby this "other data" is generally referred to as content data. The term is used most often in relation to Digital media, but older forms of metadata are catalogs, dictionaries, and taxonomies. For example, the Dewey Decimal Classification is a metadata management system for books developed in 1876 for libraries.

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

help.mbaassignments@gmail.com

or

call us at : 08263069601