Enhancing Call-Level Interfaces with Thread-Safe Local Memory Structures.

Gespeichert in:
Bibliographische Detailangaben
Titel: Enhancing Call-Level Interfaces with Thread-Safe Local Memory Structures.
Autoren: Pereira, Óscar Mortágua, Aguiar, Rui L.
Quelle: International Journal of Software Engineering & Knowledge Engineering; Dec2017, Vol. 27 Issue 9/10, p1549-1565, 17p
Schlagwörter: APPLICATION software, DATABASES, COMPUTER storage devices, NONRELATIONAL databases, CLIENT/SERVER computing
Abstract: Database applications are being increasingly under pressure to respond effectively to ever more demanding performance requirements. Software architects can resort to several well-known architectural tactics to minimize the possibility of coming across with any performance bottleneck. The usage of call-level interfaces (CLIs) is a strategy aimed at reducing the overhead of business components. CLIs are low-level APIs that provide a high-performance environment to execute standard SQL statements on relational and also on some NoSQL database (DB) servers. In spite of these valuable features, CLIs are not thread-safe when distinct threads need to share datasets retrieved through Select statements from databases. Thus, even in situations where two or more threads could share a dataset, there is no other possibility than providing each thread with its own dataset, this way leading to an increased need of computational resources. To overcome this drawback, in this paper we propose a new natively thread-safe architecture. The implementation herein presented is based on a thread-safe updatable local memory structure (LMS) where the data retrieved from databases is kept. A proof of concept based on Java Database Connectivity type 4 (JDBC) for SQL Server 2008 is presented and also a performance assessment. [ABSTRACT FROM AUTHOR]
Copyright of International Journal of Software Engineering & Knowledge Engineering is the property of World Scientific Publishing Company and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Datenbank: Complementary Index
FullText Text:
  Availability: 0
CustomLinks:
  – Url: https://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=EBSCO&SrcAuth=EBSCO&DestApp=WOS&ServiceName=TransferToWoS&DestLinkType=GeneralSearchSummary&Func=Links&author=Pereira%20%C3%93M
    Name: ISI
    Category: fullText
    Text: Nájsť tento článok vo Web of Science
    Icon: https://imagesrvr.epnet.com/ls/20docs.gif
    MouseOverText: Nájsť tento článok vo Web of Science
Header DbId: edb
DbLabel: Complementary Index
An: 127586264
RelevancyScore: 861
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 861.368896484375
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Enhancing Call-Level Interfaces with Thread-Safe Local Memory Structures.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Pereira%2C+Óscar+Mortágua%22">Pereira, Óscar Mortágua</searchLink><br /><searchLink fieldCode="AR" term="%22Aguiar%2C+Rui+L%2E%22">Aguiar, Rui L.</searchLink>
– Name: TitleSource
  Label: Source
  Group: Src
  Data: International Journal of Software Engineering & Knowledge Engineering; Dec2017, Vol. 27 Issue 9/10, p1549-1565, 17p
– Name: Subject
  Label: Subject Terms
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22APPLICATION+software%22">APPLICATION software</searchLink><br /><searchLink fieldCode="DE" term="%22DATABASES%22">DATABASES</searchLink><br /><searchLink fieldCode="DE" term="%22COMPUTER+storage+devices%22">COMPUTER storage devices</searchLink><br /><searchLink fieldCode="DE" term="%22NONRELATIONAL+databases%22">NONRELATIONAL databases</searchLink><br /><searchLink fieldCode="DE" term="%22CLIENT%2FSERVER+computing%22">CLIENT/SERVER computing</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: Database applications are being increasingly under pressure to respond effectively to ever more demanding performance requirements. Software architects can resort to several well-known architectural tactics to minimize the possibility of coming across with any performance bottleneck. The usage of call-level interfaces (CLIs) is a strategy aimed at reducing the overhead of business components. CLIs are low-level APIs that provide a high-performance environment to execute standard SQL statements on relational and also on some NoSQL database (DB) servers. In spite of these valuable features, CLIs are not thread-safe when distinct threads need to share datasets retrieved through Select statements from databases. Thus, even in situations where two or more threads could share a dataset, there is no other possibility than providing each thread with its own dataset, this way leading to an increased need of computational resources. To overcome this drawback, in this paper we propose a new natively thread-safe architecture. The implementation herein presented is based on a thread-safe updatable local memory structure (LMS) where the data retrieved from databases is kept. A proof of concept based on Java Database Connectivity type 4 (JDBC) for SQL Server 2008 is presented and also a performance assessment. [ABSTRACT FROM AUTHOR]
– Name: Abstract
  Label:
  Group: Ab
  Data: <i>Copyright of International Journal of Software Engineering & Knowledge Engineering is the property of World Scientific Publishing Company and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract.</i> (Copyright applies to all Abstracts.)
PLink https://erproxy.cvtisr.sk/sfx/access?url=https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edb&AN=127586264
RecordInfo BibRecord:
  BibEntity:
    Identifiers:
      – Type: doi
        Value: 10.1142/S0218194017400101
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 17
        StartPage: 1549
    Subjects:
      – SubjectFull: APPLICATION software
        Type: general
      – SubjectFull: DATABASES
        Type: general
      – SubjectFull: COMPUTER storage devices
        Type: general
      – SubjectFull: NONRELATIONAL databases
        Type: general
      – SubjectFull: CLIENT/SERVER computing
        Type: general
    Titles:
      – TitleFull: Enhancing Call-Level Interfaces with Thread-Safe Local Memory Structures.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Pereira, Óscar Mortágua
      – PersonEntity:
          Name:
            NameFull: Aguiar, Rui L.
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 12
              Text: Dec2017
              Type: published
              Y: 2017
          Identifiers:
            – Type: issn-print
              Value: 02181940
          Numbering:
            – Type: volume
              Value: 27
            – Type: issue
              Value: 9/10
          Titles:
            – TitleFull: International Journal of Software Engineering & Knowledge Engineering
              Type: main
ResultId 1