Up

Dynamic Query Mechanism for Rapid Data Extraction using ETL Process

File Size:
1.12 MB
Volume:
Volume 3, Issue 10 (October, 2017)
Publication No:
IJTC201710008
Author:
Rachna Gautam, Ramanjot Kaur
Downloads:
2 x

Abstract:
The proposed model has been designed to fetch ontology using the ontology extraction process. The proposed model has been designed to work on the basis of knowledge-based extraction mixed with position-based extraction. The proposed model has been designed to extract the operator, table names and field names from the query string. The query string extraction process is a multilevel process. At first step, the knowledge based extraction process is initiated to extract the type of operator from the SQL query string. Afterwards, the table names and field names are extracted from the query string using the position based attributes in accordance with the position of the operator in the SQL query string. The experimental results have shown the effectiveness of the proposed model in terms of elapsed time.

Keywords:
Dynamic Query, Query Synthesis, Query Processing, Query Segmentation