QUERY PROCESSING BY USING VIRTUAL QUERY ENGINE TOOL

• 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

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.