Exam Details
| Subject | Data Warehousing And Mining | |
| Paper | ||
| Exam / Course | B.Tech In Computer Science And Engineering (BTCSVI) | |
| Department | School of Engineering & Technology (SOET) | |
| Organization | indira gandhi national open university | |
| Position | ||
| Exam Date | December, 2016 | |
| City, State | new delhi, |
Question Paper
No. of Printed Pages: 3 IBICS-020 I
B.Tech. -'VIEP-COMPUTER SCIENCE AND
ENGINEERING (BTCSVI)
Term-End Examination
December, 2016
BICS-020 DATA WAREHOUSING AND MINING
Time hours Maximum Marks: 70
Note: Attempt any Seven· questions. Assume suitable missing data, if any. All. questions carry equal marks.
1. What do you mean by subject oriented, integrated, time-variant and non-volatile collection of data in a data warehouse? 5
Explain the architecture of a data warehouse with a neat diagram. 5
2. What are the different primitives by which a data mining query can be defined? 5
What are multilevel association rules Write down the different approaches to mining multilevel association rules. 5
3. Differentiate between loose coupling and semi-tight coupling. 5
Differentiate between an operational database and a data mart. 5
4. Describe the backup and archive process of a data warehouse. 5
Define data cube with examples. 5
5. Define the terms Smoothing, Aggregation, Generalization, Normalization and Feature construction with respect to data transformation concept. 5
Define data scrubbing tools and data auditing tools with examples. 5
6. How can generalization be performed on complex structure-valued data? Explain. 5
What kind of methods can be applied to mining data in text databases? Explain with suitable examples. 5
7. Explain Market Basket Analysis. 5
What do you mean by relational database, traditional database and advanced database? 5
8. List and describe any four primitives for specifying a data mining task. 5
Briefly explain about data cleaning. 5
9. Differentiate between OLTP and OLAP. 5
What is dimension modelling ?Explain. 5
10. Write short notes on any two of the following: 5+5=10
Metadata
Hypercubes
ETL Process of Data Warehouse
B.Tech. -'VIEP-COMPUTER SCIENCE AND
ENGINEERING (BTCSVI)
Term-End Examination
December, 2016
BICS-020 DATA WAREHOUSING AND MINING
Time hours Maximum Marks: 70
Note: Attempt any Seven· questions. Assume suitable missing data, if any. All. questions carry equal marks.
1. What do you mean by subject oriented, integrated, time-variant and non-volatile collection of data in a data warehouse? 5
Explain the architecture of a data warehouse with a neat diagram. 5
2. What are the different primitives by which a data mining query can be defined? 5
What are multilevel association rules Write down the different approaches to mining multilevel association rules. 5
3. Differentiate between loose coupling and semi-tight coupling. 5
Differentiate between an operational database and a data mart. 5
4. Describe the backup and archive process of a data warehouse. 5
Define data cube with examples. 5
5. Define the terms Smoothing, Aggregation, Generalization, Normalization and Feature construction with respect to data transformation concept. 5
Define data scrubbing tools and data auditing tools with examples. 5
6. How can generalization be performed on complex structure-valued data? Explain. 5
What kind of methods can be applied to mining data in text databases? Explain with suitable examples. 5
7. Explain Market Basket Analysis. 5
What do you mean by relational database, traditional database and advanced database? 5
8. List and describe any four primitives for specifying a data mining task. 5
Briefly explain about data cleaning. 5
9. Differentiate between OLTP and OLAP. 5
What is dimension modelling ?Explain. 5
10. Write short notes on any two of the following: 5+5=10
Metadata
Hypercubes
ETL Process of Data Warehouse
Other Question Papers
Departments
- Centre for Corporate Education, Training & Consultancy (CCETC)
- Centre for Corporate Education, Training & Consultancy (CCETC)
- National Centre for Disability Studies (NCDS)
- School of Agriculture (SOA)
- School of Computer and Information Sciences (SOCIS)
- School of Continuing Education (SOCE)
- School of Education (SOE)
- School of Engineering & Technology (SOET)
- School of Extension and Development Studies (SOEDS)
- School of Foreign Languages (SOFL)
- School of Gender Development Studies(SOGDS)
- School of Health Science (SOHS)
- School of Humanities (SOH)
- School of Interdisciplinary and Trans-Disciplinary Studies (SOITDS)
- School of Journalism and New Media Studies (SOJNMS)
- School of Law (SOL)
- School of Management Studies (SOMS)
- School of Performing Arts and Visual Arts (SOPVA)
- School of Performing Arts and Visual Arts(SOPVA)
- School of Sciences (SOS)
- School of Social Sciences (SOSS)
- School of Social Work (SOSW)
- School of Tourism & Hospitality Service Sectoral SOMS (SOTHSM)
- School of Tourism &Hospitality Service Sectoral SOMS (SOTHSSM)
- School of Translation Studies and Training (SOTST)
- School of Vocational Education and Training (SOVET)
- Staff Training & Research in Distance Education (STRIDE)
Subjects
- Advanced Computer Architecture
- Artificial Intelligence
- Computer Architecture
- Computer Networks
- Computer Organisations
- Cryptography And Network Security
- Data Structure
- Data Warehousing And Mining
- Database Management System
- Design and Analysis of Algorithm
- Digital Image Processing
- Discrete Maths Structure
- E-Business
- Formal Language And Automata
- Logic Design
- Microprocessor
- Mobile Computing
- Object Oriented Programming
- Operating Systems
- Parallel Algorithms
- Pattern Recognition
- Principles of Programming Lang.
- Real Time Systems
- Software Engineering
- Software Quality Engineering
- Software Reusability
- System Programming And Compiler Design
- Theory Of Computation
- Unix Internals And Shell Programming
- Web Technology