Extending Hybrid SQL/NoSQL Database by Introducing Statement Rewriting Component.
Saved in:
| Title: | Extending Hybrid SQL/NoSQL Database by Introducing Statement Rewriting Component. |
|---|---|
| Authors: | Bjeladinović, Srđa1 srdja.bjeladinovic@fon.bg.ac.rs |
| Source: | Computer Science & Information Systems. Jun2025, Vol. 22 Issue 3, p1011-1046. 36p. |
| Subjects: | Nonrelational databases, Databases, Possibility |
| Abstract: | Contemporary organisations often include different business subdomains, for which it is neither easy nor optimal to decide on using an exclusive database type. The hybrid SQL/NoSQL databases encompass various types of databases unified into a unique logical database. At the same time, they provide the usage benefits of working with the SQL and the NoSQL databases simultaneously. Recently, there has been an increase in research that deals with the challenges of hybrid databases’ query optimisation, especially query rewriting. This trend opened up possibilities for analysing the influence of applying different statement rewriting techniques to other data manipulation statements besides queries (i.e. INSERT, UPDATE and DELETE) and its impact on the average execution times. In this paper, a process model for applying automatic hybrid statements’ rewriting was designed, and the architecture for the hybrid database was extended with the newly developed Statement Rewriting Component (SRC). The tested use cases were conducted on the example of Oracle/MongoDB/Cassandra hybrid before and after introducing SRC. The tests have shown particular decreases in the average execution times of the system with the SRC. [ABSTRACT FROM AUTHOR] |
| Copyright of Computer Science & Information Systems is the property of ComSIS Consortium 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.) | |
| Database: | Engineering Source |
| FullText | Links: – Type: pdflink Text: Availability: 0 |
|---|---|
| Header | DbId: egs DbLabel: Engineering Source An: 186513830 AccessLevel: 6 PubType: Academic Journal PubTypeId: academicJournal PreciseRelevancyScore: 0 |
| IllustrationInfo | |
| Items | – Name: Title Label: Title Group: Ti Data: Extending Hybrid SQL/NoSQL Database by Introducing Statement Rewriting Component. – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Bjeladinović%2C+Srđa%22">Bjeladinović, Srđa</searchLink><relatesTo>1</relatesTo><i> srdja.bjeladinovic@fon.bg.ac.rs</i> – Name: TitleSource Label: Source Group: Src Data: <searchLink fieldCode="JN" term="%22Computer+Science+%26+Information+Systems%22">Computer Science & Information Systems</searchLink>. Jun2025, Vol. 22 Issue 3, p1011-1046. 36p. – Name: Subject Label: Subjects Group: Su Data: <searchLink fieldCode="DE" term="%22Nonrelational+databases%22">Nonrelational databases</searchLink><br /><searchLink fieldCode="DE" term="%22Databases%22">Databases</searchLink><br /><searchLink fieldCode="DE" term="%22Possibility%22">Possibility</searchLink> – Name: Abstract Label: Abstract Group: Ab Data: Contemporary organisations often include different business subdomains, for which it is neither easy nor optimal to decide on using an exclusive database type. The hybrid SQL/NoSQL databases encompass various types of databases unified into a unique logical database. At the same time, they provide the usage benefits of working with the SQL and the NoSQL databases simultaneously. Recently, there has been an increase in research that deals with the challenges of hybrid databases’ query optimisation, especially query rewriting. This trend opened up possibilities for analysing the influence of applying different statement rewriting techniques to other data manipulation statements besides queries (i.e. INSERT, UPDATE and DELETE) and its impact on the average execution times. In this paper, a process model for applying automatic hybrid statements’ rewriting was designed, and the architecture for the hybrid database was extended with the newly developed Statement Rewriting Component (SRC). The tested use cases were conducted on the example of Oracle/MongoDB/Cassandra hybrid before and after introducing SRC. The tests have shown particular decreases in the average execution times of the system with the SRC. [ABSTRACT FROM AUTHOR] – Name: AbstractSuppliedCopyright Label: Group: Ab Data: <i>Copyright of Computer Science & Information Systems is the property of ComSIS Consortium 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://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=egs&AN=186513830 |
| RecordInfo | BibRecord: BibEntity: Identifiers: – Type: doi Value: 10.2298/CSIS241024034B Languages: – Code: eng Text: English PhysicalDescription: Pagination: PageCount: 36 StartPage: 1011 Subjects: – SubjectFull: Nonrelational databases Type: general – SubjectFull: Databases Type: general – SubjectFull: Possibility Type: general Titles: – TitleFull: Extending Hybrid SQL/NoSQL Database by Introducing Statement Rewriting Component. Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Bjeladinović, Srđa IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 06 Text: Jun2025 Type: published Y: 2025 Identifiers: – Type: issn-print Value: 18200214 Numbering: – Type: volume Value: 22 – Type: issue Value: 3 Titles: – TitleFull: Computer Science & Information Systems Type: main |
| ResultId | 1 |
