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.

As you may have heard, Attivio is growing. We've added some really good people to our team in the last few months - so many in fact that we had to put rows of desks in where we use to have common 'hang out' areas. It's sad to see some of the big round lunch tables go away, but in today's economy, these are really good problems to have. We're moving to new headquarters in the Fall, so common area will be making a comeback soon.

I thought I'd lay out some of the reasons why we're having such success and why Attivio is such an awesome place to work.