Please use this identifier to cite or link to this item: http://hdl.handle.net/1822/11396

TitleAssessment of a enhanced ResultSet component for accessing relational databases
Author(s)Pereira, Óscar M.
Aguiar, Rui L.
Santos, Maribel Yasmina
KeywordsPerformance
Call level interfaces
ResultSet
Concurrency
Issue date2010
CitationKETTANI, Housain ; LI, Yang, eds. – “Proceedings of the 2nd International Conference on Software Technology and Engineering (ICSTE 2010), Sain Juan, Puerto Rico, USA, 2010.“ Chengdu : IEEE Computer Society, 2010. ISBN 978-1-4244-8665-6. Vol. 1, p. 194-201.
Abstract(s)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%.
TypeconferencePaper
URIhttp://hdl.handle.net/1822/11396
ISBN978-1-4244-8665-6
DOI10.1109/ICSTE.2010.5608885
Peer-Reviewedyes
AccessopenAccess
Appears in Collections:DSI - Engenharia da Programação e dos Sistemas Informáticos

Files in This Item:
File Description SizeFormat 
ISCTE2010_OP_RA_MYS.pdfPaper publicado nos proceedings1,07 MBAdobe PDFView/Open

Partilhe no FacebookPartilhe no TwitterPartilhe no DeliciousPartilhe no LinkedInPartilhe no DiggAdicionar ao Google BookmarksPartilhe no MySpacePartilhe no Orkut
Exporte no formato BibTex mendeley Exporte no formato Endnote Adicione ao seu Currículo DeGóis