Patterns Joins

Using the joined tables feature of TIBCO Patterns to do a joined search eliminates the issues with de-normalization and merging of separate query results. With Patterns Joins, you can search data spread across multiple tables in a way that the fields of each table appear to be merged into a single table.

For implementation of Patterns Joins, the normalized attribute has been added to Index entity: 
<IndexEntity joinTable="true" normalized=“true">

Patterns Joins allows one query for an accurate result. Patterns Joins provides separate tables for each repository. Each repository is named by the entity name and the partition number, for example CustomerAddress_ p0.

The parent repository can have multiple relationships. Relationships between tables and records are established when the tables and records are first created.

Only star schemas are supported:

  • A parent table may have any number of child tables.
  • A child table has only one parent.
  • A child table cannot be a parent.

Left join is supported out-of-the-box.