International Business Machines Corporation

Sanjay Nagchowdhury

John A Owen

Daniel L Cheung

Philip Randall Coxhead

Nicholas David Butler

David G Martin

Rachel Edwina Jackson

Nigel Lewis Jones

There is disclosed a system for migrating records in a database from a source database schema to a target database schema. A request is received to delete a state from the source schema. The state is marked as the redundant state. A resultant state is identified to which to migrate database records in the redundant state and a valid migration path is calculated between the redundant state and the resultant state.

Method, apparatus and computer program for migrating records in a database from a source database schema to a target database schema

There is disclosed a method, apparatus and computer program for migrating records in a database from a source database schema to a target database schema. A request is received to delete a state from the source schema. The state is marked as the redundant state. A resultant state is identified to which to migrate database records in the redundant state and a valid migration path is calculated between the redundant state and the resultant state.

An interactive voice response (IVR) system comprises many different application objects which combine to deliver a voice application. These objects typically include IVR programs or scripts, prompts or voice segments and server scripts or programs for communicating with external systems or databases. Large voice applications can contain hundreds of application objects and potentially thousands of voice segments. The grouping of the application objects becomes more important in the later stages of the process. There is described a method of grouping data objects having different data categories, such as IVR programs or scripts, prompts or voice segments, in an application processing system. The method comprises associating a collection of such data objects with a group (a group such as the data objects within a voice application) and arranging the data objects into a sub-groups within the group where each sub-group corresponds to category of the data object (scripts, prompts, voice segments etc) and creating a graphical representation of the sub-groups using a graphical user interface.

Data object management system

A system of controlling performance in an interactive voice response system includes a voice device driver, a voice segment stored in a file in a directory in a standard operating system format; a buffer for storing the voice segment prior to sending to the voice device driver and a plurality of voice channels for output of the voice segment. A sequence of voice blocks is requested to be sent to a buffer, the sequence being one of a plurality of sequences making up a voice segment. The number of voice blocks sent from the file to the buffer is determined. The play period of the sequence and the next underrun time when the sequence will finish playing based on the initiate request time and the play period are calculated. Also calculated is the margin period between the calculated next underrun time and the actual time after a further sequence of voice data blocks is sent to the buffer in response to a device driver request for a further sequence of voice data blocks. A telephony channel is shut down when the margin period exceeds a defined threshold.

Growing community of inventors

Southampton, United Kingdom

Sanjay Nagchowdhury