Matisse SQL

Matisse SQL relies on the ANSI SQL syntax. Matisse SQL Object Extensions add navigational access through path expressions and text searching capabilities, with full support for class inheritance.

Matisse SQL automatically maps the object model into the relational table model. It can manage inheritance, inter-object relationships, or multi-valued attributes (among others) into either a relational result set or a set of objects. The data dictionary of the relational table model is always accessible through SQL.

From a performance standpoint, the Matisse SQL optimizer transforms SQL statements into the most efficient Matisse execution form. Matisse SQL also supports server-side query capabilities.