Middleware Design - A Nobel Approach to Publish Relational Database to XML without Exposing the Schema of RDBMS

Today the world wants XML. Extended Markup Language (XML) is a universal markup language for exchanging and publishing data in web applications. There are other Markup Languages such as MathML, CML, and MusicML etc which are specifically designed for particular purpose. Data containing system does not wish to expose its schema for simple security and privacy reasons. So writing query against is not advisable or possible. Hence, an intermediate data exchange protocol using XML is essential. In this Project we have designed a Middleware Layer component where clients request are through XML which are in there own grammar not the database schema grammar. When the Server receives such request it maps the client grammar with database schema and then translates the said mapped XML Language to SQL query language which will fetch data from relational database schema. Once the data is fetched it is then translated to XML format, which is the request of the customer or a client for a specific set of data and again this XML format data is mapped with the client grammar and transmitted. Hence we can provide service to a client without exposing the schema of a database.