Problem
1. Like database systems, workflow systems also require concurrency and recovery management. List three reasons why we cannot simply apply a relational database system using 2PL, physical undo logging, and C.
2. If the entire database fits in main memory, do we still need a database system to manage the data? Explain your answer.
3. Consider a main-memory database system recovering from a system crash. Explain the relative merits of
• Loading the entire database back into main memory before resuming transaction processing
• Loading data as it is requested by transactions.