SQL-based Aggregation for Text Mining

Text mining is a technology that makes it possible to discover patterns and trends semi-automatically from huge collections of unstructured text. We developed MedTAKMI to facilitate knowledge discovery from the very large text databases characteristic of life science and healthcare applications. MedTAKMI can interactively mine a huge document collection and provide fast computations for each function. However, since MedTAKMI uses a proprietary index as a modified DTM and an proprietary aggregate engine, and is implemented in C++, it is not easy to expand it to develop other functions and to integrate it with other systems. In this paper, we propose an SQL-based method for storing annotated words in a relational database and computing each function of MedTAKMI by SQL. Although the original MedTAKMI was implemented in a few thousands of lines of C++ code, the proposed method is implemented in a few lines of SQL and is comparable with the original MedTAKMI.

By: Akihiro Inokuchi and Kohichi Takeda

Published in: RT0634 in 2007


This Research Report is available. This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has been issued as a Research Report for early dissemination of its contents. In view of the transfer of copyright to the outside publisher, its distribution outside of IBM prior to publication should be limited to peer communications and specific requests. After outside publication, requests should be filled only by reprints or legally obtained copies of the article (e.g., payment of royalties). I have read and understand this notice and am a member of the scientific community outside or inside of IBM seeking a single copy only.


Questions about this service can be mailed to reports@us.ibm.com .