Full Citation
Title: Optimizing Database Queries with Materialized Views and Data Mining Models
Citation Type: Journal Article
Publication Year: 2011
ISBN:
ISSN:
DOI:
NSFID:
PMCID:
PMID:
Abstract: The process of intelligent query answering consists of analyzing the intent of a query, rewriting the query based on the intention and other kinds of knowledge, and providing answers in an intelligent way. Producing answers effectively depends largely on users knowledge about the query language and the database schemas. Knowledge, either intentional or extensional, is the key ingredient of intelligence. In order to improve effectiveness and convenience of querying databases, we design a systematic way to analyze users request and revise the query with data mining models and materialized views. Data mining models are constrained association rules discovered from the database contents. Materialized views are pre-computed data. This paper presents the knowledge acquisition method, its implementation with the Erlang programming language, and a systematic method of rewriting query with data mining models and materialized views. We perform efficiency tests of the proposed system on a platform of deductive database using the DES system. The experimental results demonstrate the effectiveness of our system in answering queries sharing the same pattern as the available knowledge.
User Submitted?: No
Authors: Kerdprasop, Kittisak; Kerdprasop, Nittaya
Periodical (Full): Database Theory and Application, Bio-Science and Bio-Technology
Issue: 1
Volume: 258
Pages: 11-20
Data Collections: IPUMS USA
Topics: Methodology and Data Collection, Other
Countries: