QUERY PROCESSING BY USING VIRTUAL QUERY ENGINE TOOL

This tool can be used to browse any query of any database such as Oracle,MSSql Server, Mysql &Access etc.So user does not have to use different tools for different databases.If we want to perform different operation such as insert, update, delete data & create new table for such operation we...

Full description

Bibliographic Details
Main Authors: Priti Kishor Doad, Satish Jaykrishna Alaspurkar
Other Authors: The Pennsylvania State University CiteSeerX Archives
Format: Text
Language:English
Subjects:
Data Source Names
Inextricable
Referential Integrity
Enterprise Managers
Driver name
VQE
DML
Online Access:http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.384.6482
http://www.e-ijaet.org/media/25N13-IJAET0313541-revised.pdf
Description
Summary:This tool can be used to browse any query of any database such as Oracle,MSSql Server, Mysql &Access etc.So user does not have to use different tools for different databases.If we want to perform different operation such as insert, update, delete data & create new table for such operation we have to use editor of that particular database. But we don’t have option to access all types of databases through single editor. And Virtual Query Engine is such type of editor by which we can get connected with different types of databases & perform various DML operation on it. This tool will internally use JDBC to perform low level DBMS operations on db. We have to use same connectivity code for all types db & give different DSN for different dbs. This tool will initially ask for connection information such as DriverName, DSN, USERID, PASSWORD.Once it’s connected we can interactively perform dbms operations.

Similar Items