当前位置: X-MOL 学术ACM SIGMOD Rec. › 论文详情
Our official English website, www.x-mol.net, welcomes your feedback! (Note: you will need to create a separate account there.)
Wilkinson's Tests and SQL Packages
ACM SIGMOD Record ( IF 1.1 ) Pub Date : 2019-12-23 , DOI: 10.1145/3377391.3377395
B. D. McCullough 1 , Taha Mokfi 2 , Mahsa Almaeenjad 2
Affiliation  

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.

中文翻译:

Wilkinson 的测试和 SQL 包

Wilkinson 的测试用于对六个 SQL 包中某些统计函数的准确性进行基准测试:Apache Hive、Microsoft Access、Microsoft SQL Server、MySQL、Oracle 11g SQL 和 SAP Hana。使用数据类型的最佳选择,我们发现不同的包使用不同的舍入方案,两个包使用不可靠的算法计算样本方差,一个包在调用样本标准差时返回总体标准差,一个包有一个不稳定的计算相关系数的算法。使用错误的数据类型只会保证不准确的结果。
更新日期:2019-12-23
down
wechat
bug