Method and system for big data integrated management applied to auditing field

A comprehensive management and big data technology, applied in the field of auditing, can solve problems such as the lack of correlation analysis and graphical analysis, not meeting the needs of audit work, and lack of professionalism, etc., to achieve fast deployment, simple deployment and maintenance of web applications Convenience, favorable effects of promotion and application

Inactive Publication Date: 2018-04-20
成都市审计局
View PDF2 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

There are not many software developed for audit business in the market, and they are not professional enough to meet the actual needs of audit work.
It is not compatible with most of the financial software on the market, and can only provide simple data query and SQL language analysis, with small data capacity, low query efficiency, slow response speed, lack of correlation analysis and graphical analysis functions

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for big data integrated management applied to auditing field

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0037] Such as figure 1 As shown, the present invention includes a big data comprehensive management method for the field of auditing, including the following steps:

[0038] Step A) Auditors obtain the original data of the audit object through database backup and recovery or other methods;

[0039] Step B) According to the guidance of the corresponding practice announcement issued by the Audit Office, use the acquisition tools compatible with more than 90% of the financial account software on the market to perform structural analysis, data cleaning, data conversion and data localization operations on the original data, and convert the original data Become a dedicated standard data table for big data platforms;

[0040] Step C) Import the special standard data table of the big data platform into the distributed database of the system through the ETL tool, and then create a reverse data search index for these data;

[0041] Step D) After the above steps are completed, auditors ...

Embodiment 2

[0044] This embodiment is preferably as follows on the basis of Embodiment 1: In step B), the collection tool collects data through three ways of account set, database or database backup.

[0045] In step B), the collection tool has at least 100 built-in collection templates, and completes the process of data collection, structure matching, table header Sinicization and data cleaning through the collection templates, so as to convert the original data into a special standard data table for the big data platform.

[0046] The standard data table can be converted to and from the epkg format of the AO operating system. This method is compatible with more than 200 sets and more than 400 different versions of financial software on the market, and realizes online collection of financial, business, report and other types of data of the audited unit; its financial data package can be compared with the "AO Audit Site Management System" of the Audit Office Mutual conversion; Baidu-style...

Embodiment 3

[0055] The present embodiment is preferably as follows on the basis of the foregoing embodiments: a big data comprehensive management system for the field of auditing, including

[0056] Business application layer: capable of comprehensive audit data management, financial data analysis, industry data analysis, data analysis through data analysis algorithms, audit thinking management, system announcements, setting up message centers, requesting approval and file sharing units;

[0057] Basic platform layer: Ruby on Rails system development framework for developing, deploying and maintaining web applications;

[0058] Data storage layer: including CitusDB / PostgreSQL cluster distributed database for business application layer calls, ElasticSearch cluster distributed search engine, Hadoop / HDFS cluster distributed file system, customer acquisition and financial data collection conversion unit, and LibreOffice data format conversion unit ;

[0059] Infrastructure layer: including P...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The present invention discloses a method and a system for big data integrated management applied to the auditing field. The method comprises the following steps of: the step A) obtaining original dataof an audit object by audit personnel in a database backup recovery mode; the step B) employing a collection tool being compatible with more than 90% finance and account set software in the market toperform structure analysis, data cleaning, data conversion and data Chinesization operation of the original data according to the guidance of the corresponding practice statement issued by the auditoffice, and converting the original data to a special standard data sheet for a big data platform; the step C) inputting the special standard data sheet for the big data platform into a distributed database of the system by employing an ETL tool, and employing the data to create a reverse data search index; and the step D) after the steps are completed, allowing audio personnel to perform daily data analysis operation. Through adoption of the principle, the method and the system for big data integrated management applied to the auditing field are high in automation degree, simple to operate, fast in reaction speed, good in association analysis and low in requirement for audit personnel's computer levels.

Description

technical field [0001] The invention relates to database technology in the field of computers, in particular to a method and system for comprehensive management of big data in the field of auditing. Background technique [0002] Auditing is a full-time organization and personnel authorized or entrusted by the state to use special methods to verify the authenticity of the audited unit's finances, financial revenue and expenditure, business management activities and related materials in accordance with national regulations, auditing standards and accounting theories. , Correctness, compliance, legitimacy, and effectiveness are reviewed and supervised, economic responsibilities are evaluated, and economic business is authenticated, which is an independent economic supervision activity to maintain financial laws and regulations, improve business management, and increase economic benefits. There are not many software developed for audit business in the market, and they are not pr...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06Q50/26G06F17/30
CPCG06F16/215G06F16/258G06Q50/26
Inventor 曾军程世斌孙勇滨
Owner 成都市审计局
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap