Resources
Videos
Active Intelligence Engine
Overview of Query-Time JOIN
In this whiteboard video, Attivio Architect Martin Serrano provides an overview of query-time JOIN in AIE.
Attivio AIE allows you to ingest both unstructured content and database content into the AIE inverted index. Martin discusses Attivio's patent-pending Query-time JOIN operator, which assembles relevant indexed information of all types when the query is issued. This query-time capability does not rely on a data schema set in advance; in fact, AIE is schema-neutral and allows you to add a table at any time without having to change the data model or re-ingest information. Martin also discusses the limitations in the way most enterprise search systems handle database tables - flattening the records and not providing a way to reconstruct relationships. The AIE JOIN operator not only links data, it also links relevant textual information in response to a query.