Enterprise Java Development@TOPIC@

Chapter 2. Example Domain Model: Movies

2.1. Class Model
2.2. Database Schema
2.3. Database Size
2.4. Prepare DB Between Tests

2.1. Class Model

Figure 2.1. Class Model

Class Model

2.2. Database Schema

Figure 2.2. Database Schema

Database Schema

2.3. Database Size

Figure 2.3. Row Counts

    MOVIES  DIRECTORS     GENRES MOVIEROLES     ACTORS    PERSONS
---------- ---------- ---------- ---------- ---------- ----------
    911972     271409    1435326    5115827    1445027    1637666

2.4. Prepare DB Between Tests

Clear system cache of previous results

Figure 2.4. Clear DB Cache Commands

alter system flush shared_pool
alter system flush buffer_cache

Note

Requires "ALTER SYSTEM" role granted