Cargando…
BDMCA: a big data management system for Chinese auditing
The advent of big data technologies makes a profound impact on various facets of our lives, which also presents an opportunity for Chinese audits. However, the heterogeneity of multi-source audit data, the intricacy of converting Chinese into SQL, and the inefficiency of data processing methods pres...
Autores principales: | , , , , |
---|---|
Formato: | Online Artículo Texto |
Lenguaje: | English |
Publicado: |
PeerJ Inc.
2023
|
Materias: | |
Acceso en línea: | https://www.ncbi.nlm.nih.gov/pmc/articles/PMC10280443/ https://www.ncbi.nlm.nih.gov/pubmed/37346735 http://dx.doi.org/10.7717/peerj-cs.1317 |
_version_ | 1785060795404517376 |
---|---|
author | Zhou, Xiaoping Ge, Bin Xia, Zeyu Xiao, Weidong Chen, Zhiya |
author_facet | Zhou, Xiaoping Ge, Bin Xia, Zeyu Xiao, Weidong Chen, Zhiya |
author_sort | Zhou, Xiaoping |
collection | PubMed |
description | The advent of big data technologies makes a profound impact on various facets of our lives, which also presents an opportunity for Chinese audits. However, the heterogeneity of multi-source audit data, the intricacy of converting Chinese into SQL, and the inefficiency of data processing methods present significant obstacles to the growth of Chinese audits. In this article, we proposed BDMCA, a big data management system designed for Chinese audits. We developed a hybrid management architecture for handling Chinese audit big data, that can alleviate the heterogeneity of multi-mode data. Moreover, we defined an R-HBase spatio-temporal meta-structure for auditing purposes, which exhibits almost linear response time and excellent scalability. Compared to MD-HBase, R-HBase performs 4.5× and 3× better in range query and kNN query, respectively. In addition, we leveraged the slot value filling method to generate templates and build a multi-topic presentation learning model MRo-SQL. MRo-SQL outperforms the state-of-the-art X-SQL parsing model with improvements in logical-form accuracy of up to 5.2%, and execution accuracy of up to 5.9%. |
format | Online Article Text |
id | pubmed-10280443 |
institution | National Center for Biotechnology Information |
language | English |
publishDate | 2023 |
publisher | PeerJ Inc. |
record_format | MEDLINE/PubMed |
spelling | pubmed-102804432023-06-21 BDMCA: a big data management system for Chinese auditing Zhou, Xiaoping Ge, Bin Xia, Zeyu Xiao, Weidong Chen, Zhiya PeerJ Comput Sci Data Science The advent of big data technologies makes a profound impact on various facets of our lives, which also presents an opportunity for Chinese audits. However, the heterogeneity of multi-source audit data, the intricacy of converting Chinese into SQL, and the inefficiency of data processing methods present significant obstacles to the growth of Chinese audits. In this article, we proposed BDMCA, a big data management system designed for Chinese audits. We developed a hybrid management architecture for handling Chinese audit big data, that can alleviate the heterogeneity of multi-mode data. Moreover, we defined an R-HBase spatio-temporal meta-structure for auditing purposes, which exhibits almost linear response time and excellent scalability. Compared to MD-HBase, R-HBase performs 4.5× and 3× better in range query and kNN query, respectively. In addition, we leveraged the slot value filling method to generate templates and build a multi-topic presentation learning model MRo-SQL. MRo-SQL outperforms the state-of-the-art X-SQL parsing model with improvements in logical-form accuracy of up to 5.2%, and execution accuracy of up to 5.9%. PeerJ Inc. 2023-04-13 /pmc/articles/PMC10280443/ /pubmed/37346735 http://dx.doi.org/10.7717/peerj-cs.1317 Text en © 2023 Zhou et al. https://creativecommons.org/licenses/by/4.0/This is an open access article distributed under the terms of the Creative Commons Attribution License (https://creativecommons.org/licenses/by/4.0/) , which permits unrestricted use, distribution, reproduction and adaptation in any medium and for any purpose provided that it is properly attributed. For attribution, the original author(s), title, publication source (PeerJ Computer Science) and either DOI or URL of the article must be cited. |
spellingShingle | Data Science Zhou, Xiaoping Ge, Bin Xia, Zeyu Xiao, Weidong Chen, Zhiya BDMCA: a big data management system for Chinese auditing |
title | BDMCA: a big data management system for Chinese auditing |
title_full | BDMCA: a big data management system for Chinese auditing |
title_fullStr | BDMCA: a big data management system for Chinese auditing |
title_full_unstemmed | BDMCA: a big data management system for Chinese auditing |
title_short | BDMCA: a big data management system for Chinese auditing |
title_sort | bdmca: a big data management system for chinese auditing |
topic | Data Science |
url | https://www.ncbi.nlm.nih.gov/pmc/articles/PMC10280443/ https://www.ncbi.nlm.nih.gov/pubmed/37346735 http://dx.doi.org/10.7717/peerj-cs.1317 |
work_keys_str_mv | AT zhouxiaoping bdmcaabigdatamanagementsystemforchineseauditing AT gebin bdmcaabigdatamanagementsystemforchineseauditing AT xiazeyu bdmcaabigdatamanagementsystemforchineseauditing AT xiaoweidong bdmcaabigdatamanagementsystemforchineseauditing AT chenzhiya bdmcaabigdatamanagementsystemforchineseauditing |