Research On The Application Of Graph Database Technology In Audit

The development of information technology empowers the various walks of life,and it is no exception for audits.Since the 1990 s,data-based audits based on SQL queries have shown a strong power in the audit business.With the popularization of information systems,the information system control mechanism has also continued to improve,and the advancement of Audit Full Coverage,it has become increasingly rare in the past that directly violate relevant laws and regulations.Instead,the behavior of affiliated transactions,decomposition transactions,and benefits of interests are commonly reported.The development of the situation puts novel topics to audit,that is,how to find intricate related relationships in massive data.The graph database is a popular database technology in the era of big data and cloud computing.It shows a huge advantage better than traditional databases when analyzing a large number of node data with a large relationship.The most typical application of the database is to portray the relationship between people,people and enterprises,enterprises and enterprises in the social network.This portrayal is extremely in line with the actual needs of the audit for the relationship between the association between objects.This study determines the theme of research through literature research,combing,sorting,organizing,and interviews with the practitioner.The mainstream Neo4 j database and Cypher query language are selected as audit analysis tools.The research work is completed through programming practice,simulation case design and case analysis.In order to avoid reference to the audit sensitive data,this study designed the simulation data set with reference to real cases,applied rich mode query on the simulation data,and compared the computing performance of Noe4 j and traditional relational data to verify its superiority.The study also introduced the feasible solution for Noe4 j graph databaseassisted audit through typical applications such as mining a business district,querying the doubts according to the specific mode,and auditing public official running business enterprises.Further,this study borrows the concept of point centrality in social network analysis,and proposes the indicator of the importance of the network node “Hot Value”.Based on this,a scheme is designed to help auditors lock the popular nodes in the relationship map,that is,the key minority which the audit is concerned.Secondly,this study uses the Python language and third-party package to encapsulate“the queries of Neo4 j,uses the py2 neo package to connect the Neo4 j database and upload the query string to obtain the returned structured data;analyze the structured data,use the networkx package to create a graph and output visualized graphics,use the tkinter package to achieve the GUI,and realize that the user can complete the comprehensive effect of audit query only through filling simple forms,that is,zero code audit.In summary,this study shows the powerful performance of Neo4j’s application to audit through the analysis of the simulation cases and audit cases,looking forward to the broad prospects of combining information technology and auditing practice;It puts forward the technical solution of obtaining important-influence nodes;A package of zero code audit relationships is also provided.