Journal article
Wilkinson's Tests and SQL Packages
SIGMOD record, v 48(3), pp 17-22
20 Dec 2019
Featured in Collection : UN Sustainable Development Goals @ Drexel
Abstract
Wilkinson's Tests are used to benchmark the accuracy of some statistical functions in six SQL packages: Apache Hive, Microsoft Access, Microsoft SQL Server, MySQL, Oracle 11g SQL, and SAP Hana. Using the best choice of data type, we find that different packages use different rounding schemes, two packages use unreliable algorithms to compute the sample variance, one package returns the population standard deviation when the sample standard deviation is called, and one package has an unstable algorithm for computing the correlation coefficient. Using the wrong data type all but guarantees inaccurate results.
Metrics
9 Record Views
Details
- Title
- Wilkinson's Tests and SQL Packages
- Creators
- B. D. McCullough - Drexel UniversityTaha Mokfi - ArcherMahsa Almaeenjad - Archer
- Publication Details
- SIGMOD record, v 48(3), pp 17-22
- Publisher
- Association for Computing Machinery
- Resource Type
- Journal article
- Language
- English
- Academic Unit
- Decision Sciences (and Management Information Systems)
- Web of Science ID
- WOS:000504426000002
- Scopus ID
- 2-s2.0-85077384711
- Other Identifier
- 991019168828804721
UN Sustainable Development Goals (SDGs)
This publication has contributed to the advancement of the following goals:
InCites Highlights
Data related to this publication, from InCites Benchmarking & Analytics tool:
- Web of Science research areas
- Computer Science, Information Systems
- Computer Science, Software Engineering