Guardado en:
| Autores principales: | , , , , , , , , , , , , , , , , , |
|---|---|
| Formato: | Preprint |
| Publicado: |
2024
|
| Materias: | |
| Acceso en línea: | https://arxiv.org/abs/2401.11162 |
| Etiquetas: |
Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
| _version_ | 1866929217980071936 |
|---|---|
| author | Aguilar-Saborit, Josep Ramakrishnan, Raghu Bocksrocker, Kevin Halverson, Alan Kosinsky, Konstantin O'Connor, Ryan Poliakova, Nadejda Shafiei, Moe Kim, Taewoo Kon-Kim, Phil Mahmud-Ansari, Haris Matuszyk, Blazej Miles, Matt Mohanan, Sumin Petculescu, Cristian Rahesh-Madan, Ishan Rose-Wirshing, Emma Yousefi, Elias |
| author_facet | Aguilar-Saborit, Josep Ramakrishnan, Raghu Bocksrocker, Kevin Halverson, Alan Kosinsky, Konstantin O'Connor, Ryan Poliakova, Nadejda Shafiei, Moe Kim, Taewoo Kon-Kim, Phil Mahmud-Ansari, Haris Matuszyk, Blazej Miles, Matt Mohanan, Sumin Petculescu, Cristian Rahesh-Madan, Ishan Rose-Wirshing, Emma Yousefi, Elias |
| contents | In Polaris, we introduced a cloud-native distributed query processor to perform analytics at scale. In this paper, we extend the underlying Polaris distributed computation framework, which can be thought of as a read-only transaction engine, to execute general transactions (including updates, deletes, inserts and bulk loads, in addition to queries) for Tier 1 warehousing workloads in a highly performant and predictable manner. We take advantage of the immutability of data files in log-structured data stores and build on SQL Server transaction management to deliver full transactional support with Snapshot Isolation semantics, including multi-table and multi-statement transactions. With the enhancements described in this paper, Polaris supports both query processing and transactions for T-SQL in Microsoft Fabric. |
| format | Preprint |
| id |
arxiv_https___arxiv_org_abs_2401_11162 |
| institution | arXiv |
| publishDate | 2024 |
| record_format | arxiv |
| spellingShingle | Extending Polaris to Support Transactions Aguilar-Saborit, Josep Ramakrishnan, Raghu Bocksrocker, Kevin Halverson, Alan Kosinsky, Konstantin O'Connor, Ryan Poliakova, Nadejda Shafiei, Moe Kim, Taewoo Kon-Kim, Phil Mahmud-Ansari, Haris Matuszyk, Blazej Miles, Matt Mohanan, Sumin Petculescu, Cristian Rahesh-Madan, Ishan Rose-Wirshing, Emma Yousefi, Elias Databases In Polaris, we introduced a cloud-native distributed query processor to perform analytics at scale. In this paper, we extend the underlying Polaris distributed computation framework, which can be thought of as a read-only transaction engine, to execute general transactions (including updates, deletes, inserts and bulk loads, in addition to queries) for Tier 1 warehousing workloads in a highly performant and predictable manner. We take advantage of the immutability of data files in log-structured data stores and build on SQL Server transaction management to deliver full transactional support with Snapshot Isolation semantics, including multi-table and multi-statement transactions. With the enhancements described in this paper, Polaris supports both query processing and transactions for T-SQL in Microsoft Fabric. |
| title | Extending Polaris to Support Transactions |
| topic | Databases |
| url | https://arxiv.org/abs/2401.11162 |