🖥️ Introduction to MySQL
- MySQL is an SQL-based R-DBMS
- Free and open-source R-DBMS (under GPL)
- Owned by Oracle
- Commercial version of MySQL is also provided ( cf. community version ) - Compatible(호환) with standard SQL(대부분 지원)
- 상대적으로 적은 규모의 많은 회사들이 MySQL을 사용중이다 (약 1/5)
- Free and open-source R-DBMS (under GPL)
- Why MySQL?
- Popular ➡️ 정보 찾기가 쉬움 (사람들이 겪었던 문제가 다수)
- Versatile(다목적): runs on Linux, Windows, Mac OS X, Solaris, FreeBSD, ...
- Cost starts from zero
- High performance (fast and reliable)
- Massive : Can handle terabytes of data
- Convenient : Supports high-level query language(SQL)
- Multi-user : Supports concurrent data access
- Safe : Supports transactions
- Efficient : Can handle thousands of queries/second (TPS: transactions per second)
- Reliable : 99.99% up-time in many real-world products
- Other DB
- MongoDB : No SQL
- Redis : In-mem DB
- Elasticsearch : Search engine
- SQLite : File based
HGU 전산전자공학부 홍참길 교수님의 23-1 Database System 수업을 듣고 작성한 포스트이며, 첨부한 모든 사진은 교수님 수업 PPT의 사진 원본에 필기를 한 수정본입니다.
HGU - 개인 공부 기록용 블로그