소개글
미국대학원_과제_지하철 시스템을 위한 데이터베이스 구축의 기술적 요구사항 발표자료_Columbia Univ_Technical Requirement of Database Architecture for Metro System_Presentation에 대한 자료입니다.
본문내용
Unifying the Metros under a Single Ticket System
Executive Summary
A QR based system is proposed to unify the NYC tri-state metro systems.
MySQL (SQL-based) and MongoDB (NoSQL-based) systems are proposed for backend storage operations.
We recommend MySQL as its more stable, easier to hire for, and established solutions exist for common problems
Use of prediction systems for adequate analysis is also recommended, keeping in line with the business requirements
Proper data governance to ensure sensitive data is properly kept is also discussed.
34 billion records
The estimated storage requirements of a ridership system(!)
Source: Eugene Wei (2005)
Source: Huffington Post (2016)
Above & to the Left: Personal photos