Netside where knowledge is shared, ideas are spread.

[Notes] CSCI 567 lec6 Support Vector Machines (SVM)

Credit to: Prof. Yan Liu, CSCI567, Spring 2020

outline

  • Support vector machines (primal formulation)
  • A detour of Lagrangian duality
  • Support vector machines (dual formulation)

[Notes] CSCI 585 Database Business Intelligence and Data Warehouses

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

Chapter 13

outline

  • How business intelligence provides a comprehensive business decision support framework
  • About business intelligence architecture, its evolution, and reporting styles
  • About the relationship and differences between operational data and decision support data
  • What a data warehouse is and how to prepare data for one
  • What star schemas are and how they are constructed
  • About data analytics, data mining, and predictive analytics
  • About online analytical processing (OLAP)
  • How SQL extensions are used to support OLAP-type data manipulations

[Notes] CSCI 585 Database Performance Tuning and Query Optimization

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

Chapter 11

Outline

  • Basic database performance-tuning concepts
  • How a DBMS processes SQL queries
  • About the importance of indexes in query processing
  • About the types of decisions the query optimizer has to make
  • Some common practices used to write efficient SQL code
  • How to formulate queries and tune the DBMS for optimal performance

[Notes] CSCI 567 lec5 Kernel Methods

Credit to: Prof. Yan Liu, CSCI567, Spring 2020

outline

  • Motivation
  • Dual formulation of linear regression
  • Kernel Trick

[Notes] CSCI 585 DB Transaction Management and Concurrency Control

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

outline

  • database transactions and their properties
  • What concurrency control is and what role it plays in maintaining the database’s integrity
  • What locking methods are and how they work
  • How stamping methods are used for concurrency control
  • How optimistic methods are used for concurrency control
  • How database recovery management is used to maintain database integrity