DCUBE: CUBE on dirty databases

Guohua Jiang; Hongzhi Wang; Shouxu Jiang; Jianzhong Li; Hong Gao

doi:10.1007/978-3-642-14246-8_49

DCUBE: CUBE on dirty databases

Guohua Jiang^*
, Hongzhi Wang
, Shouxu Jiang
, Jianzhong Li
, Hong Gao

^*Corresponding author for this work

School of Computer Science and Technology, Harbin Institute of Technology

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

Abstract

In the real world databases, dirty data such as inconsistent data, duplicate data affect the effectiveness of applications with database. It brings new challenges to efficiently process OLAP on the database with dirty data. CUBE is an important operator for OLAP. This paper proposes the CUBE operation based on overlapping clustering, and an effective and efficient storing and computing method for CUBE on the database with dirty data. Based on CUBE, this paper proposes efficient algorithms for answering aggregation queries, and the processing methods of other major operators for OLAP on the database with dirty data. Experimental results show the efficiency of the algorithms presented in this paper.

Original language	English
Title of host publication	Web-Age Information Management - 11th International Conference, WAIM 2010, Proceedings
Pages	507-512
Number of pages	6
DOIs	https://doi.org/10.1007/978-3-642-14246-8_49
State	Published - 2010
Externally published	Yes
Event	11th International Conference on Web-Age Information Management, WAIM 2010 - Jiuzhaigou, China Duration: 15 Jul 2010 → 17 Jul 2010

Publication series

Name	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume	6184 LNCS
ISSN (Print)	0302-9743
ISSN (Electronic)	1611-3349

Conference

Conference	11th International Conference on Web-Age Information Management, WAIM 2010
Country/Territory	China
City	Jiuzhaigou
Period	15/07/10 → 17/07/10

Keywords

CUBE
OLAP
dirty data

Access to Document

10.1007/978-3-642-14246-8_49

Cite this

Jiang, G., Wang, H., Jiang, S., Li, J., & Gao, H. (2010). DCUBE: CUBE on dirty databases. In Web-Age Information Management - 11th International Conference, WAIM 2010, Proceedings (pp. 507-512). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 6184 LNCS). https://doi.org/10.1007/978-3-642-14246-8_49

@inproceedings{e1ede8d986964f9c9198ef597813433e,

title = "DCUBE: CUBE on dirty databases",

abstract = "In the real world databases, dirty data such as inconsistent data, duplicate data affect the effectiveness of applications with database. It brings new challenges to efficiently process OLAP on the database with dirty data. CUBE is an important operator for OLAP. This paper proposes the CUBE operation based on overlapping clustering, and an effective and efficient storing and computing method for CUBE on the database with dirty data. Based on CUBE, this paper proposes efficient algorithms for answering aggregation queries, and the processing methods of other major operators for OLAP on the database with dirty data. Experimental results show the efficiency of the algorithms presented in this paper.",

keywords = "CUBE, OLAP, dirty data",

author = "Guohua Jiang and Hongzhi Wang and Shouxu Jiang and Jianzhong Li and Hong Gao",

year = "2010",

doi = "10.1007/978-3-642-14246-8\_49",

language = "英语",

isbn = "3642142451",

series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

pages = "507--512",

booktitle = "Web-Age Information Management - 11th International Conference, WAIM 2010, Proceedings",

note = "11th International Conference on Web-Age Information Management, WAIM 2010 ; Conference date: 15-07-2010 Through 17-07-2010",

}

Jiang, G, Wang, H , Jiang, S, Li, J & Gao, H 2010, DCUBE: CUBE on dirty databases. in Web-Age Information Management - 11th International Conference, WAIM 2010, Proceedings. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 6184 LNCS, pp. 507-512, 11th International Conference on Web-Age Information Management, WAIM 2010, Jiuzhaigou, China, 15/07/10. https://doi.org/10.1007/978-3-642-14246-8_49

DCUBE: CUBE on dirty databases. / Jiang, Guohua; Wang, Hongzhi ; Jiang, Shouxu et al.
Web-Age Information Management - 11th International Conference, WAIM 2010, Proceedings. 2010. p. 507-512 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 6184 LNCS).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - DCUBE

T2 - 11th International Conference on Web-Age Information Management, WAIM 2010

AU - Jiang, Guohua

AU - Wang, Hongzhi

AU - Jiang, Shouxu

AU - Li, Jianzhong

AU - Gao, Hong

PY - 2010

Y1 - 2010

N2 - In the real world databases, dirty data such as inconsistent data, duplicate data affect the effectiveness of applications with database. It brings new challenges to efficiently process OLAP on the database with dirty data. CUBE is an important operator for OLAP. This paper proposes the CUBE operation based on overlapping clustering, and an effective and efficient storing and computing method for CUBE on the database with dirty data. Based on CUBE, this paper proposes efficient algorithms for answering aggregation queries, and the processing methods of other major operators for OLAP on the database with dirty data. Experimental results show the efficiency of the algorithms presented in this paper.

AB - In the real world databases, dirty data such as inconsistent data, duplicate data affect the effectiveness of applications with database. It brings new challenges to efficiently process OLAP on the database with dirty data. CUBE is an important operator for OLAP. This paper proposes the CUBE operation based on overlapping clustering, and an effective and efficient storing and computing method for CUBE on the database with dirty data. Based on CUBE, this paper proposes efficient algorithms for answering aggregation queries, and the processing methods of other major operators for OLAP on the database with dirty data. Experimental results show the efficiency of the algorithms presented in this paper.

KW - CUBE

KW - OLAP

KW - dirty data

UR - https://www.scopus.com/pages/publications/77955032209

U2 - 10.1007/978-3-642-14246-8_49

DO - 10.1007/978-3-642-14246-8_49

M3 - 会议稿件

AN - SCOPUS:77955032209

SN - 3642142451

SN - 9783642142451

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 507

EP - 512

BT - Web-Age Information Management - 11th International Conference, WAIM 2010, Proceedings

Y2 - 15 July 2010 through 17 July 2010

ER -

DCUBE: CUBE on dirty databases

Abstract

Publication series

Conference

Keywords

Access to Document

Other files and links

Fingerprint

Cite this