Hewlett-Packard Development Company, L.p.

Sap Ag

Eliezer Levy

Nitzan Peleg

Yuval Sherman

Aharon Avitzur

Alla Volkov

David Rachamim

Elad Heart

Boaz Ben-Zvi

Eran Simha

Robert Krien

Among other disclosure, a computer-implemented method for obtaining information from an object includes receiving a query configured to extract information from a non-XML object. The non-XML object is created using an object model that provides for: (1) organizing attributes under nodes in a hierarchy; and (2) creating, within the non-XML object, associations between the nodes, also to nodes in another non-XML object. The method includes identifying in the received query any portion thereof that is non-standard with regard to XQuery language. The method includes creating an XML document from the non-XML object using at least the non-standard portion identified in the query. The method includes performing a revised query on the created XML document, the revised query corresponding to the query and being formulated using the XQuery language. The method includes recording, as a response to the query, a result of the revised query.

Obtaining information from an object

A method for executing before-triggers in an active database. A tree of actions is constructed for each activated before-trigger and a tree of operators is constructed for the statement that activates the trigger. A table affecting operator that is included in the activating statement is removed from the statement tree and a temporary execution operator is formed from any remaining actions of the activating statement. The temporary execution operator and the activated before-triggers are then included in an insertion operator that is configured to send updated rows into a temporary table. The table affecting operator is then interconnected to execute subsequent to the insertion operator. Any activated row-after and statement-after triggers are interconnected to execute subsequent to the execution of the table-affecting operator.

Method of executing before-triggers in an active database

A method for executing after-triggers in an active database. A tree is constructed for each after-trigger and an operator tree is constructed for the statement that activates the trigger. The method joins each of the trees for the activated row-after triggers to the operator tree for pipelined execution with the operator tree. The trees for the activated row-after triggers form a group and each of the trees within the group execute in parallel with each other. The method joins trees for activated statement-after triggers to the operator tree for execution subsequent to the execution of the operator tree, the statement after trigger trees receiving rows from a temporary table that accumulates affected rows from the operator tree. Trees for activated statement after triggers form a group and each of the trees within the group execute in parallel with each other.

Method of parallel trigger execution in an active database

A method for executing triggers in an active database. An operator tree is formed for the activating trigger and the activated triggers are identified. Each trigger has a creation time stamp. Conflicting triggers are determined based on the tables accessed by the activated triggers. Two or more parallel groups are formed such that conflicting triggers are placed into a different parallel groups and non-conflicting triggers are contained within a parallel group. The parallel groups are interconnected for sequential execution, the order of execution of the parallel groups being based on the creation time stamps of conflicting triggers. The parallel groups are then connected to the operator tree and, if possible, a parallel group containing row triggers is connected to execute in a pipelined fashion with the operator tree of the activating statement.

Method of executing conflicting triggers in an active database

Growing community of inventors

Haifa, Israel

Eliezer Levy