Unified Information Access Blog

Welcome to Attivio's Unified Information Access Blog. Join us for discussions on topics ranging from enterprise search solutions, information access insights, Agile software development methodology to programming with Java. We hope you'll find the articles informative and participate in the discussions by leaving a comment.

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.

The following is an excerpt from a new whitepaper “Beyond the Data Warehouse: A Unified Store for Data and Content” by Dr. Barry Devlin, one of the foremost authorities on business insight and data warehousing.

Content, or soft information, has always been of interest to the business in a wide range of processes, from marketing to executive decision-making. The explosion in volume and variety of soft information driven, in particular, by the Internet has sharpened that interest. However, with years of experience in business intelligence and data warehousing behind them, many users are clear that what they really need is an integrated view of soft information with the harder data already available in the warehouse. While soft information on its own does have value, the real business advantage will come from exploring the entire set of hard and soft information free from the limitations of the pervasive, predefined data structures of hard information.

Content and data are closely related. Data is what IT has made of content in order to control and process it in the structured world of computers. Content as simple as “I’ll buy that red car” is transformed into a purchase transaction, with defined fields, allowed value ranges and keys normalized in a database. The use of two distinct words, “data” and “content” is unfortunate, since both are the same concept — information. Content is softer information, while data is harder; two terms at opposite ends of a continuum. At the softer end, information exists as commonly used and interpreted by humans — documents, images, etc. Hard information is the structured records and fields suitable for logical and numerical computer processing, for example, in operational systems.

I had a terrific time at the Enterprise Search Summit 2010 in New York City last week. Much like last year it was filled with interesting people and ideas - but there was a hint of change in the air as well.

The change started with David White of Aberdeen group, who presented results from a recent survey of Enterprise Search implementations. Using the reported benefits, Dave was able to identify the characteristics of the "best in class" efforts which on average yielded ~6 hours of additional employee productivity. (Less effective implementations gained only 1 hour.) The main drivers of success were a total focus on employee productivity, proper staffing, and providing access to as many critical sources of information as possible. Less effective efforts were driven by desires to control costs, or single-source implementations.

More Articles...

Page 2 of 26

2

SUBSCRIBE

blue-rss-icon.png

Enter your email address:

 

Connect with Attivio

ico_attivio_spiral.jpg facebook-Icon.png twitter-icon.png

Contact Us:
+1.857.226.5040

Recent Posts

UIA: Boosting Customer Loyalty (Or How NOT to Annoy Your Customers)

I am in Tel Aviv enjoying a beautiful summer afternoon with a new customer when my mood is altered by a credit card snafu. Back in the states, a wary...
Read More...

Clash of the Titans: Price and Performance for Data Warehousing and Analytics

Why are all the mega technology vendors suddenly so focused on next generation data warehousing and analytics? Primarily, it's because Oracle wants to...
Read More...

Enriching Unified Information Stores with Text Analytics

Too often getting access to all the relevant business information we need has forced us to undertake a journey across multiple sources, using different...
Read More...
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8