Audit Schedule Determination

A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

• creating a plurality of audit event data objects from master data stored in a database, the master data comprising audit objects, system parameters, and resources;
• creating audit groups by determining unit types of the master data shared between the audit event data objects, wherein the unit type comprises a product, a service, or an organization;
• establishing a priority of the audit groups;
• randomly selecting an audit event data object from one of the plurality of audit groups according to the priority and a duration;
• determining availability of a resource during a time slot selected based upon a distribution;
• where availability is present, assigning the audit event to the time slot;
• shuffling through remaining audit event data objects according to the priority, to assign time slots and resources to the remaining audit event data objects;
• and
• storing an audit schedule comprising the plurality of audit event data objects including respective time slot and resource assigned.

A computer system comprising:

• one or more processors;
• a software program, executable on said computer system, the software program configured to cause an in-memory database engine to:
• create a plurality of audit event data objects from master data stored in an in-memory database, the master data comprising audit objects, system parameters, and resources;
• create audit groups by determining unit types of the master data shared between the audit event data objects;
• establish a priority of the audit groups;
• randomly select an audit event data object from one of the plurality of audit groups according to the priority and a duration;
• determine availability of a resource during a time slot selected based upon a distribution;
• where availability is present, assign the audit event to the time slot;
• shuffle through remaining audit event data objects according to the priority, to assign time slots and resources to the remaining audit event data objects;
• and
• store in the in-memory database, an audit schedule comprising the plurality of audit event data objects including respective time slot and resource assigned.