hrcak mascot   Srce   HID

Original scientific paper
https://doi.org/10.17559/TV-20191123110408

Query with Assumptions for Probabilistic Relational Databases

Caicai Zhang ; School of Information Science and Technology, Jiujiang University, No. 551, Qianjin East Road, Jiujiang, Jiangxi 332005, China
Zhuolin Mei ; School of Information Science and Technology, Jiujiang University, No. 551, Qianjin East Road, Jiujiang, Jiangxi 332005, China
Bin Wu ; School of Information Science and Technology, Jiujiang University, No. 551, Qianjin East Road, Jiujiang, Jiangxi 332005, China
Zhiqiang Zhao ; School of Information Science and Technology, Jiujiang University, No. 551, Qianjin East Road, Jiujiang, Jiangxi 332005, China
Jing Yu ; School of Information Science and Technology, Jiujiang University, No. 551, Qianjin East Road, Jiujiang, Jiangxi 332005, China
Qingqing Wang ; School of Information Science and Technology, Jiujiang University, No. 551, Qianjin East Road, Jiujiang, Jiangxi 332005, China

Fulltext: english, pdf (700 KB) pages 923-932 downloads: 52* cite
APA 6th Edition
Zhang, C., Mei, Z., Wu, B., Zhao, Z., Yu, J. & Wang, Q. (2020). Query with Assumptions for Probabilistic Relational Databases. Tehnički vjesnik, 27 (3), 923-932. https://doi.org/10.17559/TV-20191123110408
MLA 8th Edition
Zhang, Caicai, et al. "Query with Assumptions for Probabilistic Relational Databases." Tehnički vjesnik, vol. 27, no. 3, 2020, pp. 923-932. https://doi.org/10.17559/TV-20191123110408. Accessed 6 Aug. 2020.
Chicago 17th Edition
Zhang, Caicai, Zhuolin Mei, Bin Wu, Zhiqiang Zhao, Jing Yu and Qingqing Wang. "Query with Assumptions for Probabilistic Relational Databases." Tehnički vjesnik 27, no. 3 (2020): 923-932. https://doi.org/10.17559/TV-20191123110408
Harvard
Zhang, C., et al. (2020). 'Query with Assumptions for Probabilistic Relational Databases', Tehnički vjesnik, 27(3), pp. 923-932. https://doi.org/10.17559/TV-20191123110408
Vancouver
Zhang C, Mei Z, Wu B, Zhao Z, Yu J, Wang Q. Query with Assumptions for Probabilistic Relational Databases. Tehnički vjesnik [Internet]. 2020 [cited 2020 August 06];27(3):923-932. https://doi.org/10.17559/TV-20191123110408
IEEE
C. Zhang, Z. Mei, B. Wu, Z. Zhao, J. Yu and Q. Wang, "Query with Assumptions for Probabilistic Relational Databases", Tehnički vjesnik, vol.27, no. 3, pp. 923-932, 2020. [Online]. https://doi.org/10.17559/TV-20191123110408

Abstracts
Users may have prior knowledge about a probabilistic database. They prefer to query over a probabilistic database on their prior knowledge which cannot be written as component clauses of conventional SQL queries. A naive approach is to query over a new database version, which is generated by transforming the original probabilistic database to satisfy users' prior knowledge; however, it is impractical to generate a different probabilistic database version for each prior knowledge. In this paper, we propose the concept of the query with assumptions which allow users to describe their prior knowledge with a newly introduced ASSUMPTION clause of SQL. We also propose an approach to obtain the result of a query based on assumption clauses. The experimental studies show our approach has better performance compared to the naive approach.

Keywords
probabilistic database; prior knowledge; query with assumptions

Hrčak ID: 239103

URI
https://hrcak.srce.hr/239103

Visits: 89 *