In many domains, structured data and unstructured text are both important natural resources to fuel data analysis. Statistical text analysis needs to be performed over text data to extract structured information for further query processing. Typically, developers will need to connect multiple tools to build off-line batch processes to perform text analytic tasks. MADden is an integrated system developed for relational database systems such as PostgreSQL and Greenplum for real-time ad hoc query processing over structured and unstructured data. MADden implements four important text analytic functions that we have contributed to the MADlib open source library for textual analytics. In this demonstration, we will show the capability of the MADden text analytic library using computational journalism as the driving application. We show real-time declarative query processing over multiple data sources with both structured and text information.
Authors:
Christan Grant, Jordan Gumbs, Kun Li, Daisy Zhe Wang, George Chitouras
Bibtex:
@inproceedings{Grant:2012:MQS:2396761.2398746,
author = {Grant, Christan Earl and Gumbs, Joir-dan and Li, Kun and Wang, Daisy Zhe and Chitouras, George},
title = {MADden: query-driven statistical text analytics},
booktitle = {Proceedings of the 21st ACM international conference on Information and knowledge management},
series = {CIKM '12},
year = {2012},
isbn = {978-1-4503-1156-4},
location = {Maui, Hawaii, USA},
pages = {2740--2742},
numpages = {3},
url = {http://doi.acm.org/10.1145/2396761.2398746},
doi = {10.1145/2396761.2398746},
acmid = {2398746},
publisher = {ACM},
address = {New York, NY, USA},
keywords = {databases, query-driven, text analytics},
}
Download:
[pdf]