https://arxiv.org/abs/2312.00638

Skip to main content
Cornell University
We gratefully acknowledge support from the Simons Foundation, member
institutions, and all contributors. Donate
 
arxiv logo > cs > arXiv:2312.00638
[                    ]

Help | Advanced Search

[All fields        ]
Search
arXiv logo
Cornell University Logo
[                    ] GO
quick links

  * Login
  * Help Pages
  * About

Computer Science > Databases

arXiv:2312.00638 (cs)
[Submitted on 1 Dec 2023]

Title:What if an SQL Statement Returned a Database?

Authors:Joris Nix, Jens Dittrich
Download a PDF of the paper titled What if an SQL Statement Returned
a Database?, by Joris Nix and 1 other authors
Download PDF

    Abstract:Every SQL statement is limited to return a single,
    possibly denormalized, table. This design decision has far
    reaching consequences. (1.) for databases users in terms of slow
    query performance, long query result transfer times,
    usability-issues of SQL in web applications and object-relational
    mappers. In addition, (2.) for database architects it has
    consequences when designing query optimizers leading to logical
    (algebraic) join enumeration effort, memory consumption for
    intermediate result materialization, and physical operator
    selection effort. So basically, the entire query optimization
    stack is shaped by that design decision. In this paper, we argue
    that the single-table limitation should be dropped. We extend the
    SELECT-clause of SQL by a keyword 'RESULTDB' to support returning
    a result database. Our approach has clear semantics, i.e. our
    extended SQL returns subsets of all tables with only those tuples
    that would be part of the traditional (single-table) query result
    set, however without performing any denormalization through
    joins. Our SQL-extension is downward compatible. Moreover, we
    discuss the surprisingly long list of benefits of our approach.
    First, for database users: far simpler and more readable
    application code, better query performance, smaller query
    results, better query result transfer times. Second, for database
    architects, we present how to leverage existing closed source
    systems as well as change open source database systems to support
    our feature. We propose a couple of algorithms to integrate our
    feature into both closed-source as well as open source database
    systems. We present an initial experimental study with promising
    results.

Subjects:    Databases (cs.DB)
ACM classes: H.2
Cite as:     arXiv:2312.00638 [cs.DB]
             (or arXiv:2312.00638v1 [cs.DB] for this version)
             https://doi.org/10.48550/arXiv.2312.00638
             Focus to learn more
             arXiv-issued DOI via DataCite

Submission history

From: Joris Nix [view email]
[v1] Fri, 1 Dec 2023 14:59:29 UTC (84 KB)
Full-text links:

Access Paper:

    Download a PDF of the paper titled What if an SQL Statement
    Returned a Database?, by Joris Nix and 1 other authors
  * Download PDF
  * PostScript
  * Other Formats

[by-nc-sa-4]
Current browse context:
cs.DB
< prev   |   next >
new | recent | 2312
Change to browse by:
cs

References & Citations

  * NASA ADS
  * Google Scholar
  * Semantic Scholar

a export BibTeX citation Loading...

BibTeX formatted citation

x
[loading...          ]
Data provided by:

Bookmark

BibSonomy logo Reddit logo
(*) Bibliographic Tools

Bibliographic and Citation Tools

[ ] Bibliographic Explorer Toggle
Bibliographic Explorer (What is the Explorer?)
[ ] Litmaps Toggle
Litmaps (What is Litmaps?)
[ ] scite.ai Toggle
scite Smart Citations (What are Smart Citations?)
( ) Code, Data, Media

Code, Data and Media Associated with this Article

[ ] Links to Code Toggle
CatalyzeX Code Finder for Papers (What is CatalyzeX?)
[ ] DagsHub Toggle
DagsHub (What is DagsHub?)
[ ] Links to Code Toggle
Papers with Code (What is Papers with Code?)
[ ] ScienceCast Toggle
ScienceCast (What is ScienceCast?)
( ) Demos

Demos

[ ] Replicate Toggle
Replicate (What is Replicate?)
[ ] Spaces Toggle
Hugging Face Spaces (What is Spaces?)
( ) Related Papers

Recommenders and Search Tools

[ ] Link to Influence Flower
Influence Flower (What are Influence Flowers?)
[ ] Connected Papers Toggle
Connected Papers (What is Connected Papers?)
[ ] Core recommender toggle
CORE Recommender (What is CORE?)

  * Author
  * Venue
  * Institution
  * Topic

( ) About arXivLabs

arXivLabs: experimental projects with community collaborators

arXivLabs is a framework that allows collaborators to develop and
share new arXiv features directly on our website.

Both individuals and organizations that work with arXivLabs have
embraced and accepted our values of openness, community, excellence,
and user data privacy. arXiv is committed to these values and only
works with partners that adhere to them.

Have an idea for a project that will add value for arXiv's community?
Learn more about arXivLabs.

Which authors of this paper are endorsers? | Disable MathJax (What is
MathJax?)

  * About
  * Help

  * Click here to contact arXiv Contact
  * Click here to subscribe Subscribe

  * Copyright
  * Privacy Policy

  * Web Accessibility Assistance
  * arXiv Operational Status
    Get status notifications via email or slack