Data Warehousing & Mining for GTU University

by Manmohan Singh

Data Warehousing and Data Mining contains Data Warehousing : OLAP and OLTP, Data warehouse and Data mart, OLAM architecture, Extraction, Transform and Loading (ETL) concept for generic, two-tier, three - tier architecture, Data warehousing schema - Star, Snowflake, Fact Constellation (Galaxy) - Data Cube , Operations on Data cube (slicing, roll up, roll down, drill up etc). Introduction to data mining (DM): Motivation for Data Mining - Data Mining-Definition and Functionalities – Classification of DM Systems - DM task primitives - Integration of a Data Mining system with a Database or a Data Warehouse - Issues in DM – KDD Process. Data Pre-processing : Data summarization, data cleaning, data integration and transformation, data reduction, data discretization and concept hierarchy generation, feature extraction , feature transformation, feature selection, introduction to Dimensionality Reduction, CUR decomposition. Mining Frequent Patterns, Associations and Correlations : Efficient and scalable frequent item-set mining methods, mining various kind of association rules, from association mining to correlation analysis, Advanced Association Rule Techniques, Measuring the Quality of Rules. Classification and Prediction : Classification vs. prediction, Issues regarding classification and prediction, Statistical-Based Algorithms, Distance-Based Algorithms, Decision Tree-Based Algorithms, Neural Network-Based Algorithms, Rule-Based Algorithms, Combining Techniques, accuracy and error measures, evaluation of the accuracy of a classifier or predictor. Neural Network Prediction methods : Linear and nonlinear regression, Logistic Regression Introduction of tools such as DB Miner / WEKA / DTREG DM Tools. Cluster Analysis : Problem Definition, Clustering Overview, Evaluation of Clustering Algorithms, Partitioning Clustering -K-Means Algorithm, K-Means Additional issues, PAM Algorithm; Hierarchical Clustering – Agglomerative Methods and divisive methods, Basic Agglomerative Hierarchical Clustering, Strengths and Weakness; Outlier Detection, Clustering high dimensional data, clustering Graph and Network data. Advance Introduction to Web Mining, Spatial Data Mining, Temporal Mining, Text Mining and Multimedia Mining.

Kindle Edition

Published April 1, 2021

About the author

Manmohan Singh was an Indian politician, economist, academic, and bureaucrat, who served as the 13th prime minister of India from 2004 to 2014. He was the fourth longest-serving prime minister after Jawaharlal Nehru, Narendra Modi, and Indira Gandhi. A member of the Indian National Congress, Singh was the first Sikh prime minister of India. He was also the first prime minister since Nehru to be re-elected after completing a full five-year term.
Born in Gah in what is today Pakistan, Singh's family migrated to India during its partition in 1947. After obtaining his doctorate in economics from the University of Oxford, Singh worked for the United Nations during 1966–1969. He subsequently began his bureaucratic career when Lalit Narayan Mishra hired him as an advisor in the Ministry of Commerce and Industry. During the 1970s and 1980s, Singh held several key posts in the Government of India, such as Chief Economic Advisor (1972–1976), governor of the Reserve Bank (1982–1985) and head of the Planning Commission (1985–1987).
In 1991, as India faced a severe economic crisis, the newly elected prime minister, P.V. Narasimha Rao, inducted the apolitical Singh into his cabinet as finance minister. Over the next few years, despite strong opposition, he carried out several structural reforms that liberalised India's economy. Although these measures proved successful in averting the crisis, and enhanced Singh's reputation globally as a leading reform-minded economist, the incumbent Congress Party fared poorly in the 1996 general election. Subsequently, Singh was leader of the opposition in the Rajya Sabha (the upper house of the Parliament of India) during the Atal Bihari Vajpayee government of 1998–2004.
In 2004, when the Congress-led United Progressive Alliance came to power, its chairperson Sonia Gandhi unexpectedly relinquished the prime ministership to Singh. His first ministry executed several key legislations and projects, including the National Rural Health Mission, Unique Identification Authority, Rural Employment Guarantee scheme and Right to Information Act. In 2008, opposition to a historic civil nuclear agreement with the United States nearly caused Singh's government to fall after Left Front parties withdrew their support. In 2009, he co-founded BRICS. India's economy grew rapidly during his term.
The 2009 general election saw the UPA return with an increased mandate, with Singh retaining the office of prime minister. After his term ended, he opted out from the race for the office of prime minister during the 2014 Indian general election. Singh was never a member of the Lok Sabha but served as a member of the Rajya Sabha, representing the state of Assam from 1991 to 2019 and Rajasthan from 2019 to 2024.