Toshiba Global Commerce Solutions Holdings Corporation

Peter Sramka

Zachary McCain Darden

Luis Felipe Lopez

Bradley Thomas Marchesseault

A computing device obtains information associated with creating a plurality of database triggers. The computing device processes this information to determine a list of foreign keys that directly link a plurality of database tables. At least two of these database tables, however, are not directly linked. Therefore, the computing device uses the list of foreign keys to generate an indirect table path that indirectly links these two database tables through one or more intermediary tables. So linked, the computing device can automatically generate the source code for creating the plurality of database triggers to verify the integrity of the data stored in all of the plurality of database tables.

Generating source code for creating database triggers

According to one aspect of the present disclosure, a method is implemented by a server in a server cluster. A request received from a client includes a session identifier (ID) identifying a session between the client and the server, and a correlation ID that is linked to the request. If the correlation ID is not included in an individual server-specific session microcache for the session, the request is processed to determine a response, the response is added to the session microcache, and the response and an indication of the correlation ID are sent to the client. If the correlation ID and a response to the request are stored in the session microcache, the response and an indication of the correlation ID are re-sent to the client. The session ID and session microcache are transferred to another of the plurality of servers in the server cluster to continue the session.

Growing community of inventors

Raleigh, NC, United States of America

Peter Sramka