데이터베이스정리
-
1. What is database? Motivation Database Organized collection of inter-related data that models some aspect of the real-world. Databases are one of the core components of most computer applications Database Examples Universities: Registration, grades Financial market credit card transactions Sales and purchases information of stocks and bonds Real-time market data Enterprise information Sales: c..
Database Systems1. What is database? Motivation Database Organized collection of inter-related data that models some aspect of the real-world. Databases are one of the core components of most computer applications Database Examples Universities: Registration, grades Financial market credit card transactions Sales and purchases information of stocks and bonds Real-time market data Enterprise information Sales: c..
2023.10.26 -
당시에는 정말 나의 피땀을 갈아넣어 만든 정리 노트... 데이터베이스 정말 열심히 했었더랬다. ㅎ 데이터 베이스를 사용하는 방법 (how to work?) Data model Relational Data model → R - DBMS Relational algebra SQL: Structured Query Language SQL DML: SELECT, INSERT, UPDATE, DELETE, JOIN, WITH SQL DDL: CREATE. ALTER, DROP ER Diagram, NORMALIZATION Transaction Key, Constraints, Views Procedures, Functions, Trigger 데이터 베이스 내부 동작(how it works?) Transactions D..
Database Theory당시에는 정말 나의 피땀을 갈아넣어 만든 정리 노트... 데이터베이스 정말 열심히 했었더랬다. ㅎ 데이터 베이스를 사용하는 방법 (how to work?) Data model Relational Data model → R - DBMS Relational algebra SQL: Structured Query Language SQL DML: SELECT, INSERT, UPDATE, DELETE, JOIN, WITH SQL DDL: CREATE. ALTER, DROP ER Diagram, NORMALIZATION Transaction Key, Constraints, Views Procedures, Functions, Trigger 데이터 베이스 내부 동작(how it works?) Transactions D..
2022.08.04