Towards the Composition of Web Services and the Role of the Query Optimization
Festim Halili, Agni Dika, Margita Kon Popovska
International Journal of Web Applications, Vol. 4, No. 2, 2012.
DOI: 
Link: http://dline.info/ijwa/fulltext/v4n2/1.pdf
Abstract:
Recently, the technology of Web Services emerge in the main focus as a new way to develop distributed serviceoriented or resource-oriented application. This paper studies the architecture of web services which is built on internet standards that simplify the exchange and integration of large amounts of data over the Internet, and as such they make it easier to conduct work across organizations regardless of the types of programming platform, operating systems, hardware/ software, and database management systems that are being used. To better understand the architecture of Web Services, we will provide analysis of the core protocols and the process of modeling the Orchestration of web services in a specific case study. Composition is the process of defining the communication actions and the internal actions in which a service engages. To integrate data exchanged by web services, the interconnection of web services with databases is needed, with intention to provide backup and better management of data. While we execute a query we need to analyze the performance and estimation of the SQL operations. One of the best methods is to view the query execution plan, which provides information on how a specific DBMS query optimizer runs a specific query. This information is very valuable when we want to find out why a specific query is running slow and determine the cost estimations. The section of the Query Optimizer will help readers to improve the performance of the databases and applications, meaning that they can write better queries, provide the Query Optimizer with the information it requires to produce high execution plans.