Generating Join Queries for Large Databases and Web Services

Abstract

In this data-centric world, as Web services and service oriented architectures gain momentum and become a standard for data usage, there will be a need for tools to automate data retrieval. In this article the authors propose a tool that automates the generation of joins in a transparent and integrated fashion in heterogeneous large databases as well as Web services. This tool reads metadata information and automatically displays a join path and a SQL join query. This tool will be extremely useful for performing joins to help in the retrieval of information in large databases as well as Web services.