Object-relational database applications implemented in conventional procedural programming languages such as C, C++, and Java along with the embedded statements expressed in the non-procedural programming languages such as OQL, SQL and XQuery. Therefore, using transformation rules to optimise these applications by balancing the data processing load between the client and the server sides is required. Refactoring object-oriented applications, is one way to preserve output of the application but apply changes on design level. Implementation of object-relational applications with a large amount of procedural code, remains the majority of the dataprocessing to the client side. This often has catastrophic consequences for the performance of the application. Transformation rules need to be applied in an efficient way to come up with optimised applications.This research evaluates whether using transformation rules can be consider as a refactoring technology which can transfer the nonoptimise object-relational application to the optimise ones. A systematic experimental study was conducted by incorporating transformation rules to monitor the number of Blocks-Read operations before and after applying the rules. It was concluded that as rules applied in an efficient way, the performance of applications increased. Also the efficient way of applying the rules is proposed.
Majority of the global information systems are constructed from a number of heterogeneous distributed database systems that provide a global object-oriented view of the data stored at the remote systems. Such global information systems have two sides: the source side which consists of heterogeneous distributed databases and the global side which provides an integrated view of the database systems from the source side. User applications access data through the iterations over the classes of objects included in a global object-oriented view. The iterations over the classes of objects are implemented as iterations over the data items such as the rows in the relational tables on the source side of the system creating serious performance problems. This paper addresses the performance problem of object-oriented applications accessing data on the source side of global information system through an object-oriented view on a global side. We propose a number of transformation rules which allow for more efficient processing of object-oriented application on the source side. The rules can eliminate the iterations of classes of objects on the global schema side. We prove the correctness of the rules and show how to systematically apply the rule to object-oriented applications. The paper proposes a number of templates for programming of object-oriented applications that allow for easier and more efficient performance tuning transformations.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.
hi@scite.ai
10624 S. Eastern Ave., Ste. A-614
Henderson, NV 89052, USA
Copyright © 2024 scite LLC. All rights reserved.
Made with 💙 for researchers
Part of the Research Solutions Family.