Relational Expressions for Data Transformation and Computation (2309.11178v1)
Abstract: Separate programming models for data transformation (declarative) and computation (procedural) impact programmer ergonomics, code reusability and database efficiency. To eliminate the necessity for two models or paradigms, we propose a small but high-leverage innovation: the introduction of complete relations into the relational database. Complete relations and the discipline of constraint programming, which concerns them, are founded on the same algebra as relational databases. We claim that by synthesising the relational database of Codd and Date, with the results of the constraint programming community, the relational model holistically offers programmers a single declarative paradigm for both data transformation and computation, reusable code with computations that are indifferent to what is input and what is output, and efficient applications with the query engine optimising and parallelising all levels of data transformation and computation.
- Agence Nationale de la Cohésion des Territoires: OpenFisca - Write rules as code. World Wide Web (2022), https://openfisca.org/en/
- Codd, E.F.: A Relational Model of Data for Large Shared Data Banks. Communications of the ACM 13(6) (1970). https://doi.org/10.1145/362384.362685
- Date, C.J.: Database Design and Relational Theory: Normal Forms and All That Jazz (2019). https://doi.org/10.1007/978-1-4842-5540-7
- Gai, M.: Integrating Constraint and Relational Database Systems. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) 3074 (2004). https://doi.org/10.1007/978-3-540-25954-1_11
- Libkin, L.: SQL’s three-valued logic and certain answers. ACM Transactions on Database Systems 41(1) (2016). https://doi.org/10.1145/2877206
- Observatory of Public Sector Innovation: Delivering a personalized citizen experience using Rules as Code as a shared utility, https://oecd-opsi.org/innovations/rac-as-shared-utility/
- Revesz, P.: Introduction to Databases - From Biological to Spatio-Temporal (2010)
- Salsa Digital: Coronavirus (COVID-19) pandemic Australia - Rules as Code - Proof of Concept, https://nginx.main.openfisca-drupal.lagoon.salsa.hosting/about-proof-concept
- Salsa Digital: What is OpenFisca?, https://salsa.digital/insights/what-is-openfisca
Sponsor
Paper Prompts
Sign up for free to create and run prompts on this paper using GPT-5.
Top Community Prompts
Collections
Sign up for free to add this paper to one or more collections.