Information management server, information processing system, communication method and program

An information processing system comprising an information management server that manages a database, and a client that connects with the information management server via a network,

• wherein the information management server comprises:
• a registration unit that registers a status change of the database and a notification action so that the status change and the notification action are associated with each other;
• a communication unit that receives an acquisition request for a status change notification via database connection established with respect to the client;
• a change detection unit that detects generation of the status change, sets a lock key field to an unlock state upon detection of the status change and invokes the notification action associated therewith;
• and
• a notification unit that monitors the lock key field in response to receiving the acquisition request, and upon detection of an unlock state of the lock key field causes the communication unit to send a notification including a result of the notification action for the acquisition request via the database connection as a response to the acquisition request, and returns control of the connection to the client,
• wherein the client includes a client application that issues an acquisition request for the status change notification and executes processing in accordance with the notification acquired as the response to the acquisition request.

A communication method that is executed by an information management server connected with a client via a network, the information management server executing the steps of:

• receiving an acquisition request for a status change notification of a database via database connection established with respect to the client;
• detecting generation of a status change that is registered in the database, setting a lock key field to an unlock state upon detection of the status change and referring to registration that associates the status change with a notification action to invoke the associated notification action;
• monitoring the lock key field in response to receiving the acquisition request;
• and
• sending a notification including a result of the notification action for the acquisition request via the database connection as a response to the acquisition request and detection of an unlock state of the lock key field, and returning control of the connection to the client.

A program that is recorded in a computer-readable recording medium and is executable by a computer, the program causing the computer to implement:

• a registration unit that registers a status change of a database and a notification action so that the status change and the notification action are associated with each other;
• a communication unit that receives an acquisition request for a status change notification via database connection established with respect to the client;
• a change detection unit that detects generation of the status change, sets a lock key field to an unlock state upon detection of the status change and invokes the notification action associated therewith;
• and
• a notification unit that monitors the lock key field in response to receiving the acquisition request, and upon detection of an unlock state of the lock key field causes the communication unit to send a notification including a result of the notification action for the acquisition request via the database connection as a response to the acquisition request, and returns control of the connection to the client.

An information management server connected with a client via a network, comprising:

• a registration unit that registers a status change of a database and a notification action so that the status change and the notification action are associated with each other;
• a communication unit that receives an acquisition request for a status change notification via database connection established with respect to the client;
• a change detection unit that detects generation of the status change, sets a lock key field to an unlock state upon detection of the status change and invokes the notification action associated therewith;
• a notification unit that monitors the lock key field in response to receiving the acquisition request, and upon detection of an unlock state of the lock key field causes the communication unit to send a notification including a result of the notification action for the acquisition request via the database connection as a response to the acquisition request, and returns control of the connection to the client;
• a timer unit that starts to operate in response to an acquisition request for the status change notification, and gives expiration of acquisition time-limit of the status change notification as the result in response to the expiration;
• an interruption unit that gives acquisition interruption of the status change notification as the result in response to an interruption instruction received via different database connection;
• a creation unit that defines a status change notification including a status change serving as a trigger and a notification action and causes the status change notification to be stored persistently;
• a start unit that reads out the definition, sets the status change serving as the trigger as a target of detection by the change detection unit, and starts an operation of processing the status change notification;
• and
• a deletion unit that erases the definition and deletes the status change notification,
• wherein the communication unit gives acquisition interruption of the status change notification as the result in response to disconnection of database connection having a dependence relationship designated with the status change notification.