Utilize este identificador para referenciar este registo:
https://hdl.handle.net/1822/89620
Registo completo
Campo DC | Valor | Idioma |
---|---|---|
dc.contributor.author | Faria, Nuno | por |
dc.contributor.author | Pereira, José | por |
dc.contributor.author | Alonso, Ana Nunes | por |
dc.contributor.author | Vilaça, Ricardo | por |
dc.contributor.author | Koning, Yunus | por |
dc.contributor.author | Nes, Niels | por |
dc.date.accessioned | 2024-03-17T13:28:36Z | - |
dc.date.issued | 2023 | - |
dc.identifier.citation | Nuno Faria, José Pereira, Ana Nunes Alonso, Ricardo Vilaça, Yunus Koning, and Niels Nes. 2023. TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads. Proc. VLDB Endow. 16, 9 (May 2023), 2274–2288. https://doi.org/10.14778/3598581.3598598 | por |
dc.identifier.issn | 2274–2288 | - |
dc.identifier.uri | https://hdl.handle.net/1822/89620 | - |
dc.description.abstract | Transactions have been a key issue in database management for a long time and there are a plethora of architectures and algorithms to support and implement them. The current state-of-the-art is focused on storage management and is tightly coupled with its design, leading, for instance, to the need for completely new engines to support new features such as Hybrid Transactional Analytical Processing (HTAP). We address this challenge with a proposal to implement transactional logic in a query language such as SQL. This means that our approach can be layered on existing analytical systems but that the retrieval of a transactional snapshot and the validation of update transactions runs in the server and can take advantage of advanced query execution capabilities of an optimizing query engine. We demonstrate our proposal, TiQuE, on MonetDB and obtain an average 500x improvement in transactional throughput while retaining good performance on analytical queries, making it competitive with the state-of-the-art HTAP systems. | por |
dc.description.sponsorship | Special thanks to the anonymous reviewers for their helpful feedback. This work is financed by National Funds through the Por tuguese funding agency, FCT – Fundação para a Ciência e a Tec nologia, within project LA/P/0063/202 | por |
dc.language.iso | eng | por |
dc.publisher | ACM | por |
dc.rights | restrictedAccess | por |
dc.title | TiQuE: improving the transactional performance of analytical systems for true hybrid workloads | por |
dc.type | article | por |
dc.peerreviewed | yes | por |
dc.relation.publisherversion | https://dl.acm.org/doi/10.14778/3598581.3598598 | por |
oaire.citationStartPage | 2274 | por |
oaire.citationEndPage | 2288 | por |
oaire.citationIssue | 9 | por |
oaire.citationVolume | 16 | por |
dc.identifier.doi | 10.14778/3598581.3598598 | por |
dc.date.embargo | 10000-01-01 | - |
sdum.journal | Proceedings of the VLDB Endowment | por |
Aparece nas coleções: | HASLab - Artigos em revistas internacionais |
Ficheiros deste registo:
Ficheiro | Descrição | Tamanho | Formato | |
---|---|---|---|---|
p2274-faria.pdf Acesso restrito! | 3,29 MB | Adobe PDF | Ver/Abrir |