Please use this identifier to cite or link to this item:
http://hdl.handle.net/10773/9447
Title: | Assessment of a Enhanced ResultSet Component for accessing relational databases |
Author: | Pereira, Óscar Narciso Mortágua Aguiar, Rui L. Santos, Maribel Yasmina |
Keywords: | Performance Call Level Interfaces ResultSet Business logic Concurrency |
Issue Date: | 3-Oct-2010 |
Publisher: | IEEE Conference Publications |
Abstract: | Call Level Interfaces (CLI) provide services aimed at easing the integration of database components and components from client applications. CLI support native SQL statements keeping this way expressiveness and performance of SQL. Thus, they cannot be discarded as a valid option whenever SQL expressiveness and SQL performance are considered key requirements. Despite the aforementioned performance advantage, CLI do not comprise other important performance features, as concurrency over the in-memory data. In this paper we present and assess a component that is a concurrent version of the ResultSet interface from the JDBC API. Several threads may interact simultaneously in the same instance of the ResultSet in a concurrent fashion and can be simultaneously connected to the underlying database. The main contributions of this paper are twofold: i) the design of an Enhanced ResultSet Component to provide a concurrent access to relational databases; ii) the evaluation of its performance. The Enhaced ResultSet performance will be assessed in a real scenario. The outcome shows that the gain in performance may increase until 80%. |
Peer review: | yes |
URI: | http://hdl.handle.net/10773/9447 |
DOI: | 10.1109/ICSTE.2010.5608885 |
ISBN: | 978-1-4244-8665-6 978-1-4244-8667-0 |
Appears in Collections: | DETI - Comunicações |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
2010-10-03 (ICSTE - San Juan - Puerto Rico) Assessment of an Enhanced ResultSet Component for Accessing Relational Databases.pdf | Documento principal | 1.07 MB | Adobe PDF |
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.