Database
The core QPC MIG database is referred to as the Database Repository. Its schema has been developed over many years to provide all of the information that is essential for managing contacts and work optimally within a contact centre. Consequently, it forms the basis of any system deployment. One of the unique features of the Database Repository is that interrelated events, rather than summarised statistics, are stored. This allows accurate summarised data to be created to match the precise requirements of any reporting and system integration project.
When used with the QPC Office Management Solutions the Database Repository also features additional tables to store information about agent application use.
Additional tables, to accommodate additional data, required for performance management or workforce management for example, can also be easily added to the core schema to meet a business's specific needs. QPC's Professional Services team have extensive experience of contact centre systems and can help with any adjustment of the core schema tables, and creation of additional tables, to meet any additional requirements.
The database used for the QPC MIG can be either Oracle or Microsoft SQL. As the QPC MIG requires that a large amount of data be stored and retrieved, ensuring that its database has sufficient capacity, speed and resilience is crucial to optimal functioning. QPC's Professional Services team can help with decision making in regard to data management policies, such as the active data storage period that affect capacity, and assist with the software and hardware specification of the storage system needed to achieve the desired resilience, capacity and speed.