DBMS
importsys
zjuer
展开
-
CMU Advanced DB 课程笔记#2:数据库工作负载和数据库事务模型
CMU Advanced DB 课程笔记#2:数据库工作负载和数据库事务模型CMU Advanced DB 课程笔记#2:数据库工作负载和数据库事务模型数据库工作负载:数据库事务(Transaction简称为Txn):Transaction Model:Flat Txns:Flat Txns+ Savepoints:Nested TxnsChained Txns:Compensating Txns...原创 2019-06-06 20:23:36 · 2373 阅读 · 2 评论 -
CMU Advanced DB 课程笔记#1:传统DBMS读取操作原理和内存模型以及In-memory DBMS的改进
CMU Advanced DB 课程笔记#1:Disk-oriented DBMS和In-memory DBMS对比Disk-oriented DBMS和In-memory DBMS对比Disk-oriented DBMS介绍读数据操作日志和恢复机制:STEAL + NO-FORCE policy.In-memory DBMS介绍数据组织形式索引查询日志和恢复Disk-oriented DBMS...原创 2019-06-03 17:56:25 · 971 阅读 · 0 评论 -
几个常用的查询employee工资的sql语句
几个常用的查询employee工资的sql语句return employee record with max salaryselect * from employeewhere salary = (select Max(salary) from employee)select highest salary in employee tableselect Max(salary)...原创 2019-06-30 19:46:16 · 2587 阅读 · 0 评论