Conflicts between encapsulation and query optimization through UML for airline reservation system

This paper deals with conflicts between the encapsulation used in the object oriented Technology and Query optimization that used in Relational Database Management. These conflicts are described on Airline Reservation System developed by the use of UML modeling. In relational database management system for the connectivity of database through programming language, small change in the query also affect the complete code of application. These aspects are described in this paper on Airline Reservation System. On the other hand, database management system (DBMS) optimizers take a logical request and generate an execution plan. If queries are broadly stated, the optimizer has greater freedom for devising an efficient plan. Thus encapsulation boosts resilience but limits optimization potential. On the other hand, broadly stating queries is conducive to optimization, but a small change to an application can affect many queries.