Abstract: A database system includes a trigger gateway for implementing trigger functionality. The trigger gateway is located at a communication point between a user and a database system. The trigger gateway receives database commands destined for the database and processes triggers associated with the database commands. Where appropriate, the trigger gateway forwards the database command to the database. A trigger action server, which is located remote from the trigger gateway, may execute trigger actions in response to trigger execution requests sent from the trigger gateway. Alternatively, trigger actions may be executed within the trigger gateway. Trigger processing includes the processing of triggers after failed database commands. Security features are implemented to prevent unauthorized database access through the use of triggers.

Abstract: A method of reducing the burden on database administrators when integrating information from a database system with a computer system over a computer network is disclosed. Rather than requiring the database administrator to express the meaning of database attribute names in a new language, the database administrators needs only to specify mappings between different database schemas by creating database example files. The database example files contain a common body of information values stored using the corresponding attribute names of the different database schemas. The database example files then become the basis for generation of a translation map between the computer system and the remote database system. Then, information queries from a user are translated with the translation map to the database schema of the remote database system.