Relational database model optimized for the use and maintenance of watchlist data in a high demand environment

A data structure embodied on a computer-readable medium in conformance with a database schema for accessing and managing data related to a plurality of watchlists in a relational database system in a high demand environment, the database schema comprising:

• a watchlist table for containing top-level metadata about each watchlist stored within the system wherein the top-level metadata comprises source information about each watchlist, and temporal information related to the enforceability of each watchlist;
• the watchlist table further associated with a plurality of agency tables wherein the plurality of agency tables comprise information about the agency associated with each watchlist;
• a watchlist entry table for containing a minimal set of watchlist attributes comprising high-level demographic information about an individual to be watched wherein the high-level demographic information comprises a name, an ethnic code, a gender, a date of birth, a place of birth, height, hair color, eye color, and family information;
• and
• a plurality of detail tables wherein each detail table is associated with the watchlist entry table and contains detailed data comprising detailed information about each watchlist attribute contained in the watchlist entry table.