Business Objects Software Limited

Francoise Fabret

Eric Simon

Adrian Dragusanu

Francois Llirbat

Nicolas Dieu

Francoise Llirbat

Apparatus, systems, and methods may operate to receive an original query plan, to transform the original query plan into an equivalent executable compact query plan, and to store the compact query plan on a machine readable device. Further activities may include computing maximal source sub-queries associated with the compact query plan, and computing semi-join reductions of the maximal source sub-queries to provide an executable derivative query plan, which may also be stored on a machine readable device. Additional apparatus, systems, and methods are disclosed.

Query plan reformulation

A method for determining access to a data table store includes determining static properties of data sources during query design, loading the static properties into an unavailability table, at query execution evaluating dynamic properties of the data sources and updating the unavailability table, evaluating a preference expression by a table dispatcher component using session context information from the availability table, determining if a preferred table is available at query execution, and if available indicating to access the preferred table, else applying unavailability rules to obtain repair actions. The preference expression including a user-defined preference between an original table and its replica and user-defined repair actions, where a selection is made at query execution between an original data table and a replicated data table based on the unavailability rules. A non-transitory computer readable medium and a system for implementing the method are also disclosed.

Systems and methods for robust data source access

Apparatus, systems, and methods may operate to receive an original query plan, to transform the original query plan into an equivalent executable compact query plan, and to store the compact query plan on a machine readable device. Further activities may include computing maximal source sub-queries associated with the compact query plan, and computing semi-join reductions of the maximal source sub-queries to provide an executable derivative query plan, which may also be stored on a machine readable device. Additional apparatus, systems, and methods are described.

A computer readable medium includes executable instructions to define an individual publication schema for each heterogeneous source of a set of heterogeneous sources. Each individual publication schema specifies mapping rules between data from a heterogeneous source and a non-permanent structured instance of data. A non-permanent structured instance of data as defined by an individual publication schema is generated. An integration schema defining a set of integration rules for combining data from each non-permanent structured instance of data as defined by individual publication schema is established. A target non-permanent structured instance of data to include data from the plurality of heterogeneous sources based on at least one integration schema is formed.

Growing community of inventors

Versailles, France

Francoise Fabret