Abstract:
The main purpose of this project is to develop a component for .NET and ASP.NET applications to improve the usability. With the development of software industry, several DBMS came to the market which is build-up with different technologies. Main communication method of DBMS is Structured Query Language (SQL). But SQL syntaxes have contrasts according to vendor. This project solution will allow developers to use SQL query translation / conversion from one database dialect to another in real time development environment. Due to SQL syntax incompatibility in different DBMS's will affect the software quality and performance.
Software developers are the main users of this product. Mainly it's defining the connected DBMS and SQL query as input. Solution will facilitate functionalities to conversion of SQL syntaxes for the connected DBMS. Provide synchronous communication with the software while real time SQL conversions. As well as take heed to return optimized result to the software. Queries optimized according to syntax ordering mechanism and syntax mapping will contain in a XML file.
It is implemented by using Ontology concept in artificial intelligence for mapping categorized the related objects and their relationships between the different SQL syntaxes. This product consists with "DLL" libraries and XML files. DLL library files fully fill with functionalities of SQL conversions.
This solution will provide quick and reliable SQL query conversion utility to improve the productivity. "The Ontology for Extracting knowledge from different data sources" (OnexDB) is doing as the final year project of M.Sc. in Information Technology Moratuwa university.
