首页 | 官方网站   微博 | 高级检索  
     

基于符号语义的不完整数据聚集查询处理算法
引用本文:张安珍,李建中,高宏.基于符号语义的不完整数据聚集查询处理算法[J].软件学报,2020,31(2):406-420.
作者姓名:张安珍  李建中  高宏
作者单位:哈尔滨工业大学计算机科学与技术学院,黑龙江哈尔滨 150001;沈阳航空航天大学计算机学院,辽宁沈阳 110136;哈尔滨工业大学计算机科学与技术学院,黑龙江哈尔滨 150001
基金项目:国家自然科学基金青年科学基金(61702344);
摘    要:本文研究了基于符号语义的不完整数据聚集查询处理问题.不完整数据又称为缺失数据,缺失值包括可填充的和不可填充的两种类型.现有的缺失值填充算法不能保证填充后查询结果的准确度,为此,本文给出不完整数据聚集查询结果的区间估计.本文在符号语义中扩展传统关系数据库模型,提出一种通用不完整数据库模型,该模型可以处理可填充的和不可填充的两种类型缺失值.在该模型下,提出一种新的不完整数据聚集查询结果语义:可靠结果.可靠结果是真实查询结果的区间估计,可以保证真实查询结果很大概率在该估计区间范围内.本文给出线性时间求解SUM、COUNT和AVG查询可靠结果的方法.真实数据集和合成数据集上的扩展实验验证了本文所提方法的有效性.

关 键 词:不完整数据  近似查询处理  数据修复  结果估计  数据可用性
收稿时间:2018/12/11 0:00:00
修稿时间:2019/4/25 0:00:00

Aggregate Query Processing Algorithm on Incomplete Data Based on Denotational Semantics
ZHANG An-Zhen,LI Jian-Zhong and GAO Hong.Aggregate Query Processing Algorithm on Incomplete Data Based on Denotational Semantics[J].Journal of Software,2020,31(2):406-420.
Authors:ZHANG An-Zhen  LI Jian-Zhong and GAO Hong
Affiliation:School of Computer Science and Technology, Harbin Institute of Technology, Harbin 150001, China,School of Computer Science and Technology, Harbin Institute of Technology, Harbin 150001, China and School of Computer Science and Technology, Harbin Institute of Technology, Harbin 150001, China
Abstract:This paper studies the problem of aggregate query processing over incomplete data based on denotational semantics. Incomplete data is also known as missing values and can be classified into two categories:applicable nulls and inapplicable nulls. Existing imputation algorithms cannot guarantee the accuracy of the query result after imputation. We give the interval estimation of the aggregate query result. This paper extends the relational model under the denotational semantic, which can cover all types of incomplete data. We define a new semantic of aggregate query answers over incomplete data, reliable answers. Reliable answers are interval estimations of the ground-truth query results, which can cover the ground-truth results with high probability. For SUM, COUNT and AVG queries, we propose linear approximate evaluation algorithms to compute reliable answers. The extended experiments on the real datasets and synthetic datasets verify the effectiveness of the method proposed in this paper.
Keywords:incomplete data  approximate query processing  data reparation  result estimation  data usability
本文献已被 万方数据 等数据库收录!
点击此处可从《软件学报》浏览原始摘要信息
点击此处可从《软件学报》下载全文
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司    京ICP备09084417号-23

京公网安备 11010802026262号