Serializability

What is Serializability?

Is a concept of creating a serial schedule. Serial schedule means no transaction overlap overlapping.

This idea works because: consider two transaction, one working on table A and second on table B. Since both are transactions work on different DB objects, operations within these transactions can overlap. Hence all the schedules produced will be serial schedules.

Is Serializability has anything to do with Serializable ISOLATION Level?

Yes & No. Serializable Isolation level is derived from serializabilty, that means the Isolation Level should generate Schedules in such a way that they are serializable. But database implemenations for this ISOLATION Level may tweak this actual schedule and may want to produce a schedule without locking the db object (table/rows/etc) and use say MVCC.