Overview of Database System Implementation
What happens when you use a database system:
- You write some SQL commands.
- The database system reads some data, from disk (or a disk
cache). and it may write data to disk.
What is the database system doing to translate SQL commands to disk
operations?
Example
begin;
update employee
set salary = salary * 1.1
where ssn in ('123456789',
'987564321');
commit;
|