O'Reilly logo

Tapping into Unstructured Data: Integrating Unstructured Data and Textual Analytics into Business Intelligence by William H. Inmon, Anthony Nesavich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14. Using SQL to Analyze Text

For many people, the real payoff of textual analytics comes at the point of being able to formulate and execute queries. It is in writing queries that end users have full control of the ability to do textual analysis. In this way, they have full flexibility when writing the queries. Of course, the end users can execute prepackaged queries or generate reports. In addition, they can use technology that generates queries if that is what the end user wants to do.

In today’s world, most analytical queries boil down to text in SQL. In some cases, the SQL is written by the programmer. In other cases, the SQL is written automatically by a front-end technology such as Business Objects or Cognos. However it is accomplished, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required