Netside where knowledge is shared, ideas are spread.

[Notes] CSCI 585 Database Connectivity and Web Technologies

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

Outline

  • About various database connectivity technologies
  • How Web-to-database middleware is used to integrate databases with the Internet
  • About Web browser plug-ins and extensions
  • What services are provided by Web application servers
  • What Extensible Markup Language (XML) is and why it is important for Web database development
  • About cloud computing and how it enables the database-as-a-service model

[Notes] CSCI 585 Distributed Database Management Systems

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

outline

  • About distributed database management systems (DDBMSs) and their components
  • How database implementation is affected by different levels of data and process distribution
  • How transactions are managed in a distributed database environment
  • How distributed database design draws on data partitioning and replication to balance performance, scalability, and availability
  • About the trade-offs of implementing a distributed data system

美国学生保险理赔流程 Student Medicover (United Healthcare StudentResources)

本文记述一下自己理赔美国学生保险(United Healthcare StudentResources)的经历供大家参考。

[Notes] CSCI 567 lec4 Multiclass Classification and Neural Nets

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

outline

  • Multiclass Classification
  • Neural Nets

[Notes] CSCI 585 DB Advanced Structured Query Language (SQL)

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

outline

  • How to use the advanced SQL JOIN operator syntax
  • About the different types of subqueries and correlated queries
  • How to use SQL functions to manipulate dates, strings, and other data
  • About the relational set operators UNION, UNION ALL, INTERSECT, and MINUS
  • How to create and use views and updatable views
  • How to create and use triggers and stored procedures
  • How to create embedded SQL