IT6702 DWM 2marks-16marks
Anna University Regulation 2013 Computer Science & Engineering (CSE) IT6702 DWM 2marks & 16marks for all 5 units are provided below. Download link for CSE 6th SEM IT6702 Data warehousing and Data Mining Short answers, Question Bank are listed down for students to make perfect utilization and score maximum marks with our study materials.
IT6702 DATA WAREHOUSING AND DATA MINING QUESTION BANK UNIT-I 2-marks
1. What are the uses of multifeature cubes? (Nov/Dec 2007)
multifeature cubes, which compute complex queries involving multiple dependent aggregates at multiple granularity. These cubes are very useful in practice. Many complex data mining queries can be answered by multifeature cubes without any significant increase in computational cost, in comparison to cube computation for simple queries with standard data cubes.
2. Compare OLTP and OLAP Systems. (Apr/May 2008), (May/June 2010)
If an on-line operational database systems is used for efficient retrieval, efficient storage and management of large amounts of data, then the system is said to be on-line transaction processing.Data warehouse systems serves users (or) knowledge workers in the role of data analysis and decision-making. Such systems can organize and present data in various formats. These systems are known as on-line analytical processing systems.
3. What is data warehouse metadata? (Apr/May 2008)
Metadata are data about data. When used in a data warehouse, metadata are the data that define warehouse objects. Metadata are created for the data names and definitions of the given warehouse. Additional metadata are created and captured for time stamping any extracted data, the source of the extracted data, and missing fields that have been added by data cleaning or integration processes.
4. Explain the differences between star and snowflake schema. (Nov/Dec 2008)
The dimension table of the snowflake schema model may be kept in normalized form to reduce redundancies. Such a table is easy to maintain and saves storage space.
5. In the context of data warehousing what is data transformation? (May/June 2009)
`In data transformation, the data are transformed or consolidated into forms appropriate for mining. Data transformation can involve the following: Smoothing, Aggregation, Generalization, Normalization, Attribute construction
6. Define Slice and Dice operation. (May/ June 2009)
The slice operation performs a selection on one dimension of the cube resulting in a sub cube.The dice operation defines a sub cube by performing a selection on two (or) more dimensions.
7. List the characteristics of a data ware house. (Nov/Dec 2009)
There are four key characteristics which separate the data warehouse from other major operational systems: 1. Subject Orientation: Data organized by subject 2. Integration: Consistency of defining parameters 3. Non-volatility: Stable data storage medium 4. Time-variance: Timeliness of data and access terms
8. What are the various sources for data warehouse? (Nov/Dec 2009)
Handling of relational and complex types of data: Because relational databases and data warehouses are widely used, the development of efficient and effective data mining systems for such data is important. Mining information from heterogeneous databases and global information systems:
Local- and wide-area computer networks (such as the Internet) connect many sources of data, forming huge, distributed, and heterogeneous databases.
9. What is bitmap indexing? (Nov/Dec 2009)
The bitmap indexing method is popular in OLAP products because it allows quick searching in data cubes. The bitmap index is an alternative representation of the record ID (RID) list.
10. What is data warehouse? (May/June 2010)
A data warehouse is a repository of multiple heterogeneous data sources organized under a unified schema at a single site to facilitate management decision making . (or)A data warehouse is a subjectoriented, time-variant and nonvolatile collection of data in support of management’s decision-making process
IT6702 DWM Unit 1 2marks & 16marks – Download Here
If you require any other notes/study materials, you can comment in the below section.
For IT6702 DWM Previous Year Question Papers – Click here
For IT6702 DWM Important Questions/Answer Key – Click here
For IT6702 DWM Lecture Notes – Click here
Anna University 6th SEM CSE DWM 2marks 16 marks
IT6702 Data warehousing and Data Mining question bank free download
Anna University CSE DWM short answers Regulation 2013
IT6702 2marks, DWM Unit wise short answers – CSE 6th Semester