#data warehouse
- Show how we can classify new tuple (Homeowner=YES, Status=Employed, Income= Average) Using a decision tree (ID3), the new tuple (Homeowner = Yes, Status = Employed, Income = Average) is classified as Defaulted = Yes. The data... 1
- Suppose that the data mining task is to cluster the following items into two clusters. With initial means 2 and 4, K-Means gives K1 = 2, 3, 4, 10, 11, 12 (mean 7) and K2 = 20, 23, 25, 30, 56 (mean 30.8). K-Means algorithm Choos... 1
- What is clustering? Explain K-mean clustering algorithm.Suppose that the data mining With initial means 2 and 4, K-Means gives K1 = 2, 3, 4, 10, 11, 12 (mean 7) and K2 = 20, 25, 30 (mean 25). Clustering is unsupervised learni... 1
- Suppose that a data warehouse for Big_University consists of the four dimensions Student, Course, Semester a) A Snowflake Shema is shown in figure below: b) base cuboid [student, course, semester, instructor] The specific OLAP operations to be per... 2
- Explain with example confusion matrix, accuracy and precision . Confusion Matrix: Consider a binary classification problem where we aim to predict whether an email is spam or not spam. The confusion matri... 1
- Demonstrate with diagram the process of KDD. Answer: KDD (Knowledge Discovery in Databases) is the complete, iterative process of turning raw data into useful knowledge: Data → Selectio... 1
- Explain features of data warehouse. Integrated: Data warehouses integrate data from various sources across the organization, ensuring a unified and consistent view. Subject-Ori... 1
- Data Warehouse Important Questions – (AI-DS /ML /CSE(DS)) Important questions based on previous year papers pf aids and comps 1)Features of Dw 2) ETL 3) OLAP operations and OLAP vs OLTP 4) star and... 1
- Draw a STAR schema for Video Rental. A star schema for video rental has one central fact table, Rental_Fact, linked to dimension tables Customer, Video (Movie), Store, Time and... 1
- Suppose that a data warehouse consists of the four dimensions, date, spectator, location, and game Suppose that a data warehouse consists of the four dimensions, date, spectator, location, and game, and the two measures, count and charge,... 1
- Data Warehousing and Mining Viva Questions
- Explain Multidimensional and multilevel association mining with example. Association mining, a data mining technique, helps identify interesting relationships or associations between items in a dataset. Multidimen... 1
- What is Web Mining? Explain Web Structure mining and Web usage mining in detail? Web mining is the process of discovering useful patterns, information, and knowledge from the vast amount of data available on the World Wid... 1
- Differentiate between Apriori & FP-growth algorithm. Criteria Apriori Algorithm FP-growth Algorithm Purpose Used for frequent itemset mining and association rule generation in data mining. Also... 2
- Differentiate between Page Rank & HITS algorithm. Criteria PageRank HITS (Hyperlink-Induced Topic Search) Purpose Measures the importance of web pages based on link structure. Identifies aut... 2
- Consider the transaction database given below, TID Items Frequent itemsets: {1}, {2}, {3}, {5}, {1,3}, {1,5}, {2,3}, {2,5}, {3,5}, {1,3,5}, {2,3,5}. Strong rules (confidence ≥ 60%) are listed in St... 1
- Elucidate Market Basket Analysis with an example. Market Basket Analysis (MBA) is a data mining technique used in the field of retail and marketing to uncover associations between products t... 1
- Explain K-Means clustering algorithm. Discuss its advantages and limitations. Apply Means algorithm Taking the first three values (2, 3, 6) as initial centroids, K-Means converges to the clusters 2, 3, 6, 8, 9, 12 and 15, 18, 22, with centr... 1
- Explain Page Rank technique in detail. PageRank is an algorithm used by search engines like Google to rank web pages in search results based on their importance and relevance. It... 1
- Write a Code for data Clustring in Python and show outputs import pandas as pd import matplotlib.pyplot as plt import seaborn as sns from sklearn.cluster import KMeans df = pd.read_csv("Mall_Customer... 1
- Explain OLAP servers ROLAP and MOLAP with diagram OLAP servers support fast multidimensional analysis of warehouse data. ROLAP servers store data in relational tables and generate SQL; MOLAP... 1
- Difference between Data WareHouse and Data Mining Aspect Data Warehouse Data Mining Purpose Stores and manages structured data from various sources for reporting and analysis. Extracts hidde... 1
- Difference between Data WareHouse and Data Mart Aspect Data Warehouse Data Mart Definition Centralized repository for integrated, historical, and large-scale data from various sources. Sub... 1
- Explain and compare Star Schema and Snowflake Schema Star Schema and Snowflake Schema are two common data modeling techniques used in data warehousing and database design. They have their own a... 1