Join My official Whatsapp group by following link
L2: Data Warehousing and Data Mining |Enterprise data Warehousing|Data mart|Warehousing Terminology
In the Today's lecture i will cover Introduction to Data Warehousing and Data Mining of subject Data Warehousing and Data Mining which is one of the important subject of computer science and engineering
Data Warehousing: Overview, Definition, Data Warehousing Components, Building a Data Warehouse, Warehouse Database, Mapping the Data Warehouse to a Multiprocessor Architecture, Difference between Database System and Data Warehouse, Multi Dimensional Data Model, Data Cubes, Stars, Snow Flakes, Fact Constellations, Concept.
Data Warehouse Process and Technology: Warehousing Strategy, Warehouse /management and Support Processes, Warehouse Planning and Implementation, Hardware and Operating Systems for Data Warehousing, Client/Server Computing Model & Data Warehousing. Parallel Processors & Cluster Systems, Distributed DBMS implementations, Warehousing Software, Warehouse Schema Design.
Data Mining: Overview, Motivation, Definition & Functionalities, Data Processing, Form of Data Pre-processing, Data Cleaning: Missing Values, Noisy Data, (Binning, Clustering, Regression, Computer and Human inspection), Inconsistent Data, Data Integration and Transformation. Data Reduction:-Data Cube Aggregation, Dimensionality reduction, Data Compression, Numerosity Reduction, Discretization and Concept hierarchy generation, Decision Tree.
Classification: Definition, Data Generalization, Analytical Characterization, Analysis of attribute relevance, Mining Class comparisons, Statistical measures in large Databases, Statistical-Based Algorithms, Distance-Based Algorithms, Decision Tree-Based Algorithms. Clustering: Introduction, Similarity and Distance Measures, Hierarchical and Partitional Algorithms. Hierarchical Clustering- CURE and Chameleon. Density Based Methods-DBSCAN, OPTICS. Grid Based Methods- STING, CLIQUE. Model Based Method –Statistical Approach, Association rules: Introduction, Large Item sets, Basic Algorithms, Parallel and Distributed Algorithms, Neural Network approach.
Data Visualization and Overall Perspective: Aggregation, Historical information, Query Facility, OLAP function and Tools. OLAP Servers, ROLAP, MOLAP, HOLAP, Data Mining interface, Security, Backup and Recovery, Tuning Data Warehouse, Testing Data Warehouse. Warehousing applications and Recent Trends: Types of Warehousing Applications, Web Mining, Spatial Mining and Temporal Mining
I am Sandeep Vishwakarma (www.universityacademy.in)
from Raj Kumar Goel Institute of Technology Ghaziabad. I have started a YouTube Channel Namely “University Academy” Teaching Training and Informative. On This channel am providing following services.
1 . Teaching: Video Lecture of B.Tech./ M.Tech. Technical Subject who provide you deep knowledge of particular subject.
Principle of Programming Language:
Theory of Automata and Formal Language:
2. Training: Video Playlist of Some software course like Android, Hadoop, Big Data, IoT, R programming, Python, C programming, Java etc.
Android App Development:
3. Informative: On this Section we provide video on deep knowledge of upcoming technology, Innovation, tech news and other informative.
You Can Download All Video Lecture, Lecture Notes, Lab Manuals and Many More from my Website: http://www.universityacademy.in/