- "In teaching others, we teach ourselves" - Proverb
- “Sometimes one man with courage is a majority.” ~ Andrew Jackson
- “Time is a great teacher, but unfortunately it kills all its pupils.” ~ Louis Hector Berlioz
----------------------------------------------------------------------------------------------------------------------------------------------------------
Courses (Teaching/Taught)
-
-
Teaching/Learning (Recommended Blogs and Websites)
-
Recommended Readings
-
Recommended Journals, etc.
-
-
-
Videos (Ptrpared by students)
- Videos (Running Lab Class)
-
Lab (Database Management Systems) Aug 2020 and onward
-
Lab (UML)
-
Study Resources ( NPTEL Gate Portal , NPTEL Portal, and Others)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Data Warehousing and Data Mining
NPTEL Link (Data Mining by Prof. Pabita Mitra)
|
SN |
Topic |
Sub-topic (if any) |
Slides/ Class Notes |
Link |
Upload date |
Detail (source etc.) |
|
1 |
Introduction |
|
class notes (skj) |
|
Chapter 1, Kamber's book (3rd edition) |
|
|
2 |
Data |
|
Slides |
|
Chapter 2, Kamber's book (2nd edition) |
|
|
|
class notes (skj) |
|
Chapter 2, Kamber's book (2nd edition) and other sources |
|||
|
About Quantile |
Web link |
|
|
|||
|
Data Preprocessing
|
|
Slides |
Feb 25, 2019 |
Chapter 3, Kamber's book (2nd edition) |
||
|
Potter's Wheel |
Web link |
|
|
|||
|
Wolfram Demonstrations Project |
Web link |
|
|
|||
|
3 |
Data Warehousing
|
|
Slides |
March 11, 2019 |
Chapter 4, Kamber's book (2nd edition) |
|
|
Dimensional modeling |
Web link |
|
|
|||
|
Dimension |
Web link |
|
|
|||
|
4 |
Association Rules Mining |
|
Slides |
March 30, 2019 |
Ch 6, Kamber's book (2nd edition) |
|
|
FP growth algorithm |
Class notes (skj) |
|
|
|||
|
5 |
Classification
|
Basic Classification |
Slides |
May 1, 2019 |
|
|
|
Model Overfitting |
Slides |
|||||
|
Rule Based Classification |
Slides |
|||||
|
Classification |
Class notes (skj) |
|
Chapter 6, Kamber's book 2nd ed |
|||
|
6 |
Clustering
|
Cluster Analysis |
|
May 1, 2019 |
|
|
|
k-mean clustering ( an example) |
Class notes (skj) |
|
||||
|
7 |
WEKA
|
Features of WEKA |
Slides |
|
Slides prepared by the students Rajesh Swami (11710232,) Rajesh Tanwar(11710231,) Avneesh Singhal(11710219))
|
|
|
How to install WEKA |
Slides |
|
||||
|
How to use WEKA |
Slides |
|
||||
|
8 |
Recommended Websites |
sct-kit Machine learning in Python |
web site |
|
|
|
|
DOMINO (a company)
|
web site is useful for knowing in general what companies are developing and offering products and services. | Link | Click on ABOUT and go to on appropriate page/channel like DATA SCIENCE, CODE, MACHINE LEARNING, PRACTICAL TECHNIQUES, etc. for useful learning |
-----------------------------------------------------------------------------------------------------------------------------------------------------
Big Data Analytics
Teaching/Learning (Recommended Blogs and Websites)
|
Name of Topic, etc. |
Brief explanation |
Links |
Source/prepared by/etc. |
|
Tutorials |
For tutorials on Big data technology, see the websites: Tutorial point, Data Flair Training, and Guru99. |
- |
Initially, students can study from these websites; however, students should consult official websites for authentic and up-to-date information. |
|
Hadoop |
How to install Hadoop How to use Hadoop |
Slides prepared by the students B Lalmalsawma,(31903106), Aman Juyal (31903121), Anshul Kumar (31903127) |
|
| Recommended studies on Web for Hadoop |
Installing Hadoop 3.2.1 Single node cluster on Windows 10 | by Hadi Fadlallah | Towards Data Science Blog of Divya Singh (acknowledgement) Link Tutorial Point and JavaTPoint (See websites) |
||
|
|
|
||
|
Map Reduce |
|||
|
|
|
|
|
|
Writing and executing Hadoop program (an example) |
Prof. Eric Lo website link (acknowledgement) |
||
|
|
|
||
|
SPARK |
Features & components of Spark How to install Spark |
Slides prepared by the students Divya Rathore (31903204), Neha Verma (31903116), Prachi Sharma (31903113), Parul Kukrety (31903114) |
|
|
SPARK official website Suggested clicks on Downloads, Libraries, Document, Examples |
https://spark.apache.org/ |
||
|
Spark (Introduction, writing Spark program, and good explanation) |
Useful links to the webpage of Prof. Eric Lo, Computer Science and Engineering, Chinese University of Hong Kong (CUHK)). (acknowledgement) |
||
|
SparkSQL (Good explanation) |
LINK |
Prof. Eric Lo website link (acknoeledgement) |
|
|
Spark Streaming (an example using Twitter data) |
Prof. Eric Lo website link (acknoeledgement) |
||
| Spark Streaming Programming Guide | LINK |
Official Website |
|
|
NOSQL Databases/ Data Stores |
Key-Value Data Store |
Redis Voldemort (Project Voldemort) |
|
| Document Data Store | MongoDB | ||
|
Columar Data Store/ Column-Family Data Store |
Cassandra | ||
| Object Data Store |
MinIO https://min.io/ MinIO offers high-performance, S3 compatible object storage released under GNU Affero General Public License v3.0. It is API compatible with Amazon S3 cloud storage service. We can use MinIO to build high performance infrastructure for machine learning, analytics and application data workloads. |
||
| Graph Data Store | Neo4J | ||
| Multi Model | |||
|
HIVE |
HIVE official website Tutorial Getting Started Guide |
https://hive.apache.org/ https://cwiki.apache.org/confluence/display/Hive/Tutorial
|
|
|
Eureka Hive Tutorial <1 / 4 Blog from Apache Hive> see all foue Blogs |
https://www.edureka.co/blog/hive-tutorial/ |
||
|
HUE (Hue is an open source SQL Assistant for Databases & Data Warehouses) |
https://gethue.com// https://demo.gethue.com/hue/accounts/login?next=/
|
||
| How to use HIVE with Spark | Blog link | ||
|
VMware |
VMware, Inc. is an American cloud computing and virtualization technology company. VMware was the first successful company to virtualize the x86 architecture. VMware ESXi is an VMware's enterprise software hypervisor for servers. It is a bare-metal hypervisor that runs directly on server hardware without requiring an additional underlying operating system. |
Students can make a machine which may appears to have multiple operating systems installed on it virtually. Based on the virtualization technology, company offers several free software that may be useful to the students who want to have multiple OSs on their single machine. website https://www.vmware.com/ VMware Glossary Link Click on Software manage link or go to the following link https://my.vmware.com/en/web/vmware/downloads/#all_products |
|
|
ODBMS.org |
A Resource Portal for AI, Big Data, New Data Management Technologies and Data Science. |
http://www.odbms.org/ A very useful site |
|
| scikit-learn | Machine learning in Python |
https://scikit-learn.org/stable/ |
|
|
|
|
|
|
|
|
|||
|
|
|||
|
|
|
|
Recommended Readings
Bigtable: A Distributed Storage System for Structured Data by Fay Chang, Jeffrey Dean, Sanjay Ghemawat, Wilson C. Hsieh, Deborah A. Wallach Mike Burrows, Tushar Chandra, Andrew Fikes, Robert E. Gruber OSDI '06: Proceedings of the 7th USENIX Symposium on Operating Systems Design and Implementation - Volume 7November 2006
NoSQL Databases: Christof Strauch (cs134@hdm-stuttgart.de), Lecture Selected Topics on Software-Technology Ultra-Large Scale Sites, Lecturer Prof. Walter Kriha, Course of Studies Computer Science and Media (CSM), University Hochschule der Medien, Stuttgart (Stuttgart Media University)
Resilient Distributed Datasets: A Fault-Tolerant Abstraction for In-Memory Cluster Computing Matei Zaharia, Mosharaf Chowdhury, Tathagata Das, Ankur Dave, Justin Ma, Murphy McCauley, Michael J. Franklin, Scott Shenker, Ion Stoica University of California, Berkeley NSDI'12: Proceedings of the 9th USENIX conference on Networked Systems Design and Implementation April 2012
Recommend Journals, etc.
IEEE Big Data https://bigdata.ieee.org/
IEEE Transactions on Big Data Link
BIg Data Research (Elsevier Journal) Link
Journal of Big Data (Springer) Link
Big Data Analytics (BMC Series Part of Springer Nature) Link
Encyclopedia of Big Data Technologies (Springer, 32 Web Pages) Link
Encyclopedia of Big Data Technologies (Springer) 3rd Web pag and onward (Here, Big Data is shown in different Applications) Link
|
|
Datasets page |
|
| Agile Lab (Spark) | Link | |
| Agile Lab https://www.agilelab.it/ | Link |
Lab (Big data Analyrics)
|
SN |
Software Framework/Tool |
Slides |
Slides Prepared By |
|
1 |
Massive Online Analysis (MOA)
|
MOA Use Case PDF Features of MOA PDF Installation of MOA PDF
|
Anugrah Chimanekar (31903209) Ninmoy Debnath (31903105) Vaibhav Vardhan Jain (31903120) Vishal Gaba (31903126) |
|
2 |
MongoDB A Document Oriented Database) System |
Features of MongoDB PPT How to Install MongoDB PPT How to Use MongoDB PPT
|
Ruchika Aggarwal (31903109) Nisha Duhan (31903128) Nikita Bhatt (31910119) Alisha (31903211) |
|
3 |
R A Scripting/Programming Language for Data Mining and Statistics |
Features of R PPT How to install R PPT How to use R PPT |
Vibhor Tripathi (31903223) Vibhanshu Rai (31903216) Chandradeep Kumar (31903130) |
|
4 |
TensorFlow An end-to-end open source machine learning platform |
Features of TensorFlow PDF How to install TensorFlow PDF How to use TensorFlow PDF
|
Devankit Mishra (31903102) P Shiva Prasad Reddy (31903014) Vipin Panwar (31903119) Vijay Jangid (31903134) |
|
5 |
VFML Very Fast Machine Learning Toolkit |
Features of VFML PPT How to install VFML PPT How to use VFML PPT |
Neeraj Kumar Bharti (31903133) Moirangthem Biken Singh, (31903110) Mahaiyo Ningshen, (31903131) |
Videos (Running Lab Class)
--------------------------------------------------------------------------------------------------------------------------------------------------------
Lab (Database Management System) Aug 2020 and onward
SQL (skj class notes) PDF Uploaded om Aug 17, 2021
Official Website of MySQL https://www.mysql.com/
MySQL for Windows
Go to MySQL Official Website --> Click on tab DOWNLOADS --> Scroll down window screen and click on MySQL Community (GPL) Downloads » --> Click on MySQL Installer for Windows ...
MySQL for Command Line
Go to MySQL Official Website --> Click on tab DOWNLOADS --> Scroll down window screen and click on MySQL Community (GPL) Downloads » --> Click on MySQL Shell ....
MySQL Reference Manual (Go to MySQL Official Website --> Click on tab DOCUMENTATION --> ...)
MySQL Error Manual (Go to MySQL Official Website --> Click on tab DOCUMENTATION --> ...)
Getting Started MySQL https://dev.mysql.com/doc/mysql-getting-started/en/
DBMS Lab (CSPE-25 and ITPC-25) Manual PDF WORD (Eedited on Dec 15,2020)
Recommended Website
Database Management System Notes | Gate Vidyalay
Gate Vidyalay | A temple of learning for GATE, NET, PSU's
Recommended Resources on MySQL
MySQL Tutorial Website (for fast learning) https://www.mysqltutorial.org/
MySQL Tutorial W3resource site https://www.w3resource.com/mysql/mysql-tutorials.php
Tutorial Point Link https://www.tutorialspoint.com/mysql/
Recommended Resources on SQL
javaTpoint https://www.javatpoint.com/
SQL Tutorial w3resource link https://www.w3resource.com/sql/tutorials.php
SQL Tutorial W3schools link https://www.w3schools.com/sql/
SQL Tutorial Point Link https://www.tutorialspoint.com/sql/
FAQ (Frequently Asked Questions) on MySQL
MySQL site https://www.mysql.com/about/faq/
CareerGuru site https://career.guru99.com/top-50-mysql-interview-questions-answers/
Virtual Labs (Computer Sc. & Engg.) NPTEL Link
Virtual Labs (MHRD, ICT) Home Page Link
Virtual Lab IIT Bombay http://vlabs.iitb.ac.in/vlab/
Virtual Lab (Database Lab) http://vlabs.iitb.ac.in/vlabs-dev/labs/dblab/labs/explist.php
SQL Tryit Editor v1.6 (w3schools.com)
W3Schools Online Web Tutorials
--------------------------------------------------------------------------------------------------------------------------------------------------------
Lab (UML)
The Unified Modeling Languahe Link
Srat UMLhttps://draw.i
|
SN |
Topics/subjects detail |
Slides |
Slides names in skj system |
Information/Acknowledgement (slides are based on, or original source or a person if any) |
|
1 |
Subject and object questions |
1 Teaching Slides (PDF File 2, PDF File 3) |
PDF File 2 and PDF File 3 are used in 1 Teaching Slides |
|
|
2 |
Types of research |
2 Teaching Slides |
|
|
|
3 |
How to read a research paper by Prof. Sahana Murthy
|
Video Local link |
March 14 2018 skj edited How to Read Research Paper (Prof. Sahana Murthy) |
Prof. Sahana Murthy, IIT Bombay |
|
4 |
Literature Review |
March 18, 2018 Literature review |
Luis M Camarinha-Matos and Prof. Sahana Murthy, IIT Bombay |
|
|
5 |
Tips on Literature Review by Prof. Sahana Murthy
|
Video Local link |
Prof. Sahana Murthy_IIT Bombay, Tips on Literature Review |
ISTE Workshop |
|
6 |
Research Resource Page (Interdisciplinary Programme in Educational Technology, Indian Institute of Technology, Bombay) |
|
Interdisciplinary Programme in Educational Technology, Indian Institute of Technology, Bombay |
Interdisciplinary Programme in Educational Technology, Indian Institute of Technology, Bombay |
|
7 |
Mind map and mind mapping |
March 21, 2018 Mind Map |
Luis M Camarinha-Matos and Internet |
|
|
8 |
Probability Distribution |
Probability_Distributions |
|
|
|
9 |
Sampling Distribution |
Sampling_Distribution |
|
|
|
10 |
What is problem |
slide What is Problem |
|
|
|
11 |
Scientific Research and Methodologies and Techniques : Introduction |
Slides SRMTunit1-2017 |
Luis M Camarinha-Matos |
|
|
12 |
Scientific Method |
Slides SRMTunit2-2017 |
Luis M Camarinha-Matos |
|
|
13 |
Statistics |
Statistics-1 |
|
|
|
14 |
Descriptive Statistics |
Statistics-2 Descriptive Statistics |
|
|
|
15 |
Inferential Statistics |
Statistics-3 Inferential Statistics |
Slides have been prepared from the YouTube vedeo. name of presentatoe is not known. https://www.youtube.com/watch?v=bXP-PWo1ptM Other source https://www.datasciencecentral.com/video/basic-concepts-of-inferential-statistics |
|
|
16 |
Conquering the Comma |
Comma |
Purdue University Writing Lab Slides |
|
|
16 |
Sentence Clarity and Combining |
|
Sentence and Combining |
Purdue University Writing Lab Slides |
| 17 | Sessional, Semester Exam Question Papers |
VERY USEFUL |
||
----------------------------------------------------------------------------------------------------------------------------------------------------------
Course: Advanced Database Systems (COE-505)
Syllabus (PDF file)
Text BooK: Principles of Distributed Database Systems by M Tamer Özsu and Patrick Valduriez.
Third Edition, Springer
(Springer's Link, downloadable through institute's server)
--------------------------------------------------------------------------------------------------------------------------------------------------------
CO/PO Computation Files for NBA Exercise
- Semantic Explanation of COs and POs (Ptrpared by S K Jain) PDF File WORD File
- COs and POs Defined for COE-505 WORD File
- COE-505 Blank COs Attainment EXCEL File
- COE-505 Computation of COs EXCEL File PDF File WORD File
- COE-505 Computation of POs EXCEL File
- Final COs and POs for COE-505 WORD File
- Steps in Computing POs attainment (S K jain Prepared) WORD File
- List of POs as given in NBA Manual (1POs for B Tech and 4 POs for B tech) WORD File
--------------------------------------------------------------------------------------------------------------------------------------------------------
- Activities to be carried to conducting DBMS Practical Exam WORD File
- Teachers engaging DBMS practical labs WORD File
- Teachers engaging DBMS tutorials WORD File
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Study Resources
NPTEL Gate Portal , NPTEL Portal
Bodhitree E-Learning Academy of IIT Bombay and IITB
Computing Systems and Education Research Lab IIT B
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Google Classroom
Support Google website Classroom Help (google.com)
edu.gcfglobal.org site Free Google Classroom Tutorial at GCFGlobal
edu.google.com site Teacher Center | Google Classroom Training
Custom Guide See Quick Reference Microsoft Office Training - Excel Courses | CustomGuide