Since its launch, AIE has provided a patent-pending SQL JOIN operator. The 2.1 release adds support for many more SQL commands, which offers profound capabilities:
-
Developers can use standard SQL queries to deliver information from the index to a user interface or to another application
-
SQL queries allow precision and complexity far beyond the capabilities of search engine queries and use standard operators to apply AIE's analytical capabilities across disparate sources
-
Unlike search queries, SQL retains cardinality between related data tables: one-to-one, one-to-many and many-to-many relationships can be used and combined with full text search; this expands the options for querying dramatically
-
Attivio's AI-SQL extensions go beyond standard SQL - combining the capabilities of relational and search queries and creating tables on the fly without first defining a schema
To support the inclusion of SQL, AIE 2.1 also includes a JDBC driver, which allows standards-based integration of AIE with many of off-the-shelf BI, reporting and analytical tools and enables database applications to query information directly from the AIE index.