{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:22:22Z","timestamp":1781108542046,"version":"3.54.1"},"reference-count":29,"publisher":"IGI Global Scientific Publishing","issue":"3","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2013,7,1]]},"abstract":"<p>Call Level Interfaces (CLI) provide a set of functionalities to ease the connection between client applications and relational databases. Among them, the management of data retrieved from databases is emphasized. The retrieved data is kept in local memory structures (LMS) that allow client applications to read it and modify it through protocols. They are row (tuple) oriented and, while being executed, they cannot be preempted to start another protocol. This restriction leads to several difficulties when applications need to deal with several tuples at a time, namely in concurrent environments where several threads need to access to the same LMS instance, each one pointing to a different tuple and executing its particular protocol. To overcome this drawback, a Concurrent Tuple Set Architecture (CTSA) is proposed for LMS. A performance assessment is also carried out. The outcome is the evidence that in concurrent environments, the CTSA significantly improve the overall performance.<\/p>","DOI":"10.4018\/ijsi.2013070102","type":"journal-article","created":{"date-parts":[[2014,3,13]],"date-time":"2014-03-13T08:23:31Z","timestamp":1394699011000},"page":"12-33","source":"Crossref","is-referenced-by-count":1,"title":["CTSA"],"prefix":"10.4018","volume":"1","author":[{"given":"\u00d3scar Mort\u00e1gua","family":"Pereira","sequence":"first","affiliation":[{"name":"Instituto de Telecomunica\u00e7\u00f5es, DETI \u2013 University of Aveiro, Aveiro, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Rui L.","family":"Aguiar","sequence":"additional","affiliation":[{"name":"Instituto de Telecomunica\u00e7\u00f5es, DETI \u2013 University of Aveiro, Aveiro, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Maribel Yasmina","family":"Santos","sequence":"additional","affiliation":[{"name":"Centro Algoritmi, DSI \u2013 University of Minho, Guimar\u00e3es, Portugal"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"ijsi.2013070102-0","author":"B.Christian","year":"2004","journal-title":"Hibernate in action"},{"key":"ijsi.2013070102-1","unstructured":"Cook, W., & Ibrahim, A. (2005). Integrating programming languages and databases: What is the problem? Retrieved from http:\/\/www.odbms.org\/experts.aspx#article10"},{"key":"ijsi.2013070102-2","first-page":"377","article-title":"Representing database programs as objects","author":"M.David","year":"1990","journal-title":"Advances in database programming languages"},{"key":"ijsi.2013070102-3","unstructured":"Dinkelaker, T. (2011). AO4SQL: Towards an aspect-oriented extension for SQL. In Proceedings of the 8th Workshop on Reflection, AOP and Meta-Data for Software Evolution (RAM-SE'11), Zurich, Switzerland. Retrieved from http:\/\/tubiblio.ulb.tu-darmstadt.de\/52488\/"},{"key":"ijsi.2013070102-4","unstructured":"Erik, M., Brian, B., & Gavin, B. (2006). LINQ: Reconciling object, relations and XML in the. NET FRAMEWORK. In Proceedings of the ACM SIGMOD Intl Conf on Management of Data, Chicago, IL. Retrieved from http:\/\/doi.acm.org\/10.1145\/1142473.1142552"},{"key":"ijsi.2013070102-5","doi-asserted-by":"crossref","unstructured":"Fabry, J., & D'Hondt, T. (2006). KALA: Kernel aspect language for advanced transactions. In Proceedings of the 2006 ACM Symposium on Applied Computing, Dijon, France.","DOI":"10.1145\/1141277.1141655"},{"key":"ijsi.2013070102-6","unstructured":"Gomes, D., Pereira, \u00d3. M., & Santos, W. (2011). JDBC (Java DB connectivity) concorrente. MSc Dissertation, University of Aveiro, ria - institutional repository. Retrieved from http:\/\/hdl.handle.net\/10773\/7359"},{"key":"ijsi.2013070102-7","doi-asserted-by":"crossref","unstructured":"Gregor Kiczales, J. L., Mendhekar, A., Maeda, C., Lopes Videira, C., Loingtier, J.-M., & Joh, I. (1997). Aspect-oriented programming. In Proceedings of the ECOOP, Jyvaskyla,Finland.","DOI":"10.1007\/BFb0053381"},{"key":"ijsi.2013070102-8","unstructured":"IBM. (2011). Introduction to service data objects. Retrieved from http:\/\/www.ibm.com\/developerworks\/java\/library\/j-sdo\/"},{"key":"ijsi.2013070102-9","unstructured":"ISO. (2003). ISO\/IEC 9075-3:2003. Retrieved from http:\/\/www.iso.org\/iso\/catalogue_detail.htm?csnumber=34134"},{"key":"ijsi.2013070102-10","unstructured":"Kulkarni, D., Bolognese, L., Warren, M., Hejlsberg, A., & George, K. (Producer). (2008). LINQ to SQL. NET language-integrated query for relational data. Retrieved from http:\/\/msdn.microsoft.com\/en-gb\/library\/bb425822.aspx"},{"key":"ijsi.2013070102-11","author":"R.Laddad","year":"2003","journal-title":"AspectJ in action: Practical aspect-oriented programming"},{"key":"ijsi.2013070102-12","author":"G.Mead","year":"2011","journal-title":"ADO.NET 4 database programming with C# 2010"},{"key":"ijsi.2013070102-13","unstructured":"Microsoft. (1992). Microsoft open database connectivity. Retrieved from http:\/\/msdn.microsoft.com\/en-us\/library\/ms710252(VS.85).aspx"},{"key":"ijsi.2013070102-14","unstructured":"Microsoft. (2012). [MS-TDS]: Tabular data stream protocol specification. Retrieved from http:\/\/msdn.microsoft.com\/en-us\/library\/dd304523(v=prot.13).aspx"},{"key":"ijsi.2013070102-15","unstructured":"Microsoft. (2013). RecordSet (ODBC). Retrieved Jun, 2012, from http:\/\/msdn.microsoft.com\/en-us\/library\/5sbfs6f1.aspx"},{"key":"ijsi.2013070102-16","unstructured":"Oracle. (2013a). Call reentrantlock. Retrieved from http:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/util\/concurrent\/locks\/ReentrantLock.html"},{"key":"ijsi.2013070102-17","unstructured":"Oracle. (2013b). Oracle database. Retrieved from http:\/\/www.oracle.com\/us\/products\/database\/index.html"},{"key":"ijsi.2013070102-18","unstructured":"Oracle. (2013c). ResultSet. Retrieved from http:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/sql\/ResultSet.html"},{"key":"ijsi.2013070102-19","unstructured":"Oracle. Java data objects (JDO). (n.d.). Retrieved Nov, 2011, from http:\/\/www.oracle.com\/technetwork\/java\/index-jsp-135919.html"},{"key":"ijsi.2013070102-20","unstructured":"Oracle. Oracle toplink. (n.d.). Retrieved from http:\/\/www.oracle.com\/technetwork\/middleware\/toplink\/overview\/index.html"},{"key":"ijsi.2013070102-21","author":"M.Parsian","year":"2005","journal-title":"JDBC recipes: A problem-solution approach"},{"key":"ijsi.2013070102-22","unstructured":"Part 1: SQL routines using the Java (TM) programming language. (1999)."},{"key":"ijsi.2013070102-23","doi-asserted-by":"crossref","unstructured":"Pereira, O. M., Aguiar, R. L., & Santos, M. Y. (2010). Assessment of a enhanced resultset component for accessing relational databases. In Proceedings of the ICSTE-Int. Conf. on Software Technology and Engineering, Puerto Rico.","DOI":"10.1109\/ICSTE.2010.5608885"},{"key":"ijsi.2013070102-24","doi-asserted-by":"crossref","unstructured":"Pereira, \u00d3. M., Aguiar, R. L., & Santos, M. Y. (2013). A concurrent tuple set architecture for call level interfaces. In Proceedings of the ICIS - 12th IEEE\/ACIS International Conference on Computer and Information Science, Niigata,Japan.","DOI":"10.1007\/978-3-319-00804-2_11"},{"key":"ijsi.2013070102-25","unstructured":"Russell, A. M., & Ingolf, H. K. (2005). SQL DOM: Compile time checking of dynamic SQL statements. In Proceedings of the 27th Int. Conf. on Software Engineering, St. Louis, MO."},{"key":"ijsi.2013070102-26","unstructured":"Spring. (n.d.). Retrieved from http:\/\/www.springsource.org\/"},{"key":"ijsi.2013070102-27","unstructured":"William, R. C., & Siddhartha, R. (2005). Safe query objects: Statically typed objects as remotely executable queries. In Proceedings of the 27th Int. Conf. on Software Engineering, St. Louis, MO."},{"key":"ijsi.2013070102-28","author":"D.Yang","year":"2010","journal-title":"Java persistence with JPA"}],"container-title":["International Journal of Software Innovation"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=103279","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,2]],"date-time":"2022-06-02T01:36:54Z","timestamp":1654133814000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/ijsi.2013070102"}},"subtitle":["Concurrent Tuple Set Architecture Extending Concurrency to Call Level Interfaces"],"short-title":[],"issued":{"date-parts":[[2013,7,1]]},"references-count":29,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2013,7]]}},"URL":"https:\/\/doi.org\/10.4018\/ijsi.2013070102","relation":{},"ISSN":["2166-7160","2166-7179"],"issn-type":[{"value":"2166-7160","type":"print"},{"value":"2166-7179","type":"electronic"}],"subject":[],"published":{"date-parts":[[2013,7,1]]}}}