conference paper · ACM SIGPLAN International Conference on Generative Programming: Concepts and Experiences (GPCE) · 2020
Reorganizing queries with grouping
Cited by 4Abstract and details only
Abstract
Language-integrated query has attracted much attention from researchers and engineers. It enables one to write a database query with high-level abstractions, which makes it possible to compose, iterate, and reuse queries. An important issue in language-integrated query is the N+1 query problem, and Cheney et al. proposed a program-transformation approach to solve it for a core language of Microsoft’s LINQ. In our previous work, we extended their language to grouping (GROUP BY in SQL) and aggregate functions, and showed that any term can be transformed to a single SQL query. It still has a problem in that the resulting queries may be unnecessarily large and inefficient.
Cite this paper
Okura, R., & Kameyama, Y. (2020). Reorganizing queries with grouping. ACM SIGPLAN International Conference on Generative Programming: Concepts and Experiences (GPCE), 50–62. https://doi.org/10.1145/3425898.3426960
Okura, Rui, and Yukiyoshi Kameyama. “Reorganizing queries with grouping.” ACM SIGPLAN International Conference on Generative Programming: Concepts and Experiences (GPCE), 2020, pp. 50–62, https://doi.org/10.1145/3425898.3426960.
Okura, Rui, and Yukiyoshi Kameyama. 2020. “Reorganizing queries with grouping.” ACM SIGPLAN International Conference on Generative Programming: Concepts and Experiences (GPCE): 50–62. https://doi.org/10.1145/3425898.3426960.
Okura, R. and Kameyama, Y. (2020) ‘Reorganizing queries with grouping’, ACM SIGPLAN International Conference on Generative Programming: Concepts and Experiences (GPCE), pp. 50–62. Available at: https://doi.org/10.1145/3425898.3426960.
@article{okura2020reorganizing,
title = {{Reorganizing queries with grouping}},
author = {Okura, Rui and Kameyama, Yukiyoshi},
journal = {ACM SIGPLAN International Conference on Generative Programming: Concepts and Experiences (GPCE)},
pages = {50--62},
year = {2020},
doi = {10.1145/3425898.3426960}
}Made from the index record. Check names, capitalisation and page numbers against the paper. Need another style? AI for Research has over 10,000.
Related papers
Language-Integrated Query with Nested Data Structures and Grouping
Rui Okura, Yukiyoshi Kameyama · Lecture notes in computer science · 2020
Cited by 7
A practical theory of language-integrated query
James Cheney, Sam Lindley, Philip L. Wadler · ACM SIGPLAN Notices · 2013
Cited by 21
Language-integrated query with ordering, grouping and outer joins (poster paper)
Tatsuya Katsushima, Oleg Kiselyov · ACM SIGPLAN Workshop on Partial Evaluation and Program Manipulation (PEPM) · 2016
Cited by 2
The essence of language-integrated query
James Cheney, Sam Lindley, Philip L. Wadler · 2013
Cited by 1
Finally, safely-extensible and efficient language-integrated query
Kenichi Suzuki, Oleg Kiselyov, Yukiyoshi Kameyama · ACM SIGPLAN Workshop on Partial Evaluation and Program Manipulation (PEPM) · 2016
Cited by 20
Querying Multiple Features of Groups in Relational Databases
Damianos Chatziantoniou, Kenneth Andrew Ross · 1996
Cited by 90
Groupwise Processing of Relational Queries
Damianos Chatziantoniou, Kenneth Andrew Ross · 1997
Cited by 34
Translating Aggregate Queries into Iterative Programs
Johann Christoph Freytag, Nathan Goodman · 1986
Cited by 21