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...

Descripción completa

Detalles Bibliográficos
Autores principales: Zhou, Xiaoping, Ge, Bin, Xia, Zeyu, Xiao, Weidong, Chen, Zhiya
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