Results 131 to 140 of about 337,613 (156)
A critique of Claude Rubinson's paper nulls, three - valued logic, and ambiguity in SQL
ACM SIGMOD Record, 2008 I’d like to thank Claude Rubinson for his thoughtful critique [3] of my remarks in reference [1] on nulls and three-valued logic (3VL). Clearly we’re in agreement on the major issues; as Rubinson says, “I agree with Date that three-valued logic is incompatible with database management systems.” We also agree that null isn’t a value; as Rubinson says ...
C. J. Date
openaire +3 more sources
Some of the next articles are maybe not open access.
Related searches:
Related searches:
TenSQL: An SQL Database Built on GraphBLAS
IEEE Conference on High Performance Extreme Computing, 2023Relational Database Management Systems (RDBMS) have been the most prominent form of database in the world for several decades. While relational databases are often applied within high-frequency/low-volume transactional applications such as website ...
Jon Roose +3 more
semanticscholar +1 more source
SQL Schema Design: Foundations, Normal Forms, and Normalization
SIGMOD Conference, 2016Normalization helps us find a database schema at design time that can process the most frequent updates efficiently at run time. Unfortunately, relational normalization only works for idealized database instances in which duplicates and null markers are ...
Henning Köhler, S. Link
semanticscholar +1 more source
Optimizing SQL Learning: Identifying Prime Study Times Using Time-Data Analysis
Frontiers in Education ConferenceThis research full paper explores the optimal times for studying and learning Structured Query Language (SQL), a critical skill in managing relational databases across various domains, to improve learning, problem-solving, and academic performance.
Sophia Yang +2 more
semanticscholar +1 more source
QATCH: Automatic Evaluation of SQL-centric Tasks on Proprietary Data
ACM Transactions on Intelligent Systems and TechnologyTabular Representation Learning (TRL) and Large Language Models (LLMs) have become established for tackling Question Answering (QA) and Semantic Parsing (SP) tasks on tabular data.
Simone Papicchio +2 more
semanticscholar +1 more source
On assisting domain and not null constraint management with DBDetective 2.0 for Oracle
International Conference on System Theory, Control and Computing, 2015DBDetective for Oracle is a metadata mining tool for detecting and correcting possible violations of some crucial database (db) design, implementation, usage, and optimization best practice rules (bprs); its 1.0 version considers two bprs related to ...
Christian Mancas, A. Dicu
semanticscholar +1 more source
TODS, 2012
We investigate the implication problem for classes of data dependencies over SQL table definitions. Under Zaniolo's “no information” interpretation of null markers we establish an axiomatization and algorithms to decide the implication problem for the ...
Sven Hartmann, S. Link
semanticscholar +1 more source
We investigate the implication problem for classes of data dependencies over SQL table definitions. Under Zaniolo's “no information” interpretation of null markers we establish an axiomatization and algorithms to decide the implication problem for the ...
Sven Hartmann, S. Link
semanticscholar +1 more source
Extending XData to kill SQL query mutants in the wild
International Workshop on Testing Database Systems, 2013SQL queries are usually tested for correctness by executing them on one or more datasets, to see if they give the desired results on each dataset. Erroneous queries are often the result of small changes, or mutations, of the correct query.
B. Chandra +4 more
semanticscholar +1 more source
The Usage of Declarative Integrity Constraints in the SQL Databases of Some Existing Software
Software Engineering and Algorithms, 2021Erki Eessaar
semanticscholar +1 more source