Enterprise Java Development@TOPIC@

Chapter 77. Example Domain Model: Movies

77.1. Class Model
77.2. Database Schema
77.3. Database Size
77.4. Prepare DB Between Tests

77.1. Class Model

Figure 77.1. Class Model

Class Model

77.2. Database Schema

Figure 77.2. Database Schema

Database Schema

77.3. Database Size

Figure 77.3. Row Counts

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

77.4. Prepare DB Between Tests

Clear system cache of previous results

Figure 77.4. Clear DB Cache Commands

alter system flush shared_pool
alter system flush buffer_cache

Note

Requires "ALTER SYSTEM" role granted