A massive data storage and management strategy for online computer-assisted audit system | |
Wu Hai-Ping ; Yu Hong-Liang ; Zheng Wei-Min ; Zhou De-Ming | |
2010-05-06 ; 2010-05-06 | |
关键词 | Practical/ auditing financial data processing parallel databases query processing SQL storage management transaction processing/ massive data storage data management strategy online computer-assisted audit system information technology share-nothing cluster SQL statement parallel transaction process parallel database parallel query algorithm/ C7120 Financial computing C6120 File organisation C6150N Distributed systems software C6160B Distributed databases D2050B IT in accounting D2080 Information services and database systems in IT |
中文摘要 | With the development of information technology, an online computer-assisted audit system needs to be established. The audit system would store massive data which was retrieved from variable databases and has different structures. This paper presents a massive data storage and management tactic for online computer-assisted audit system, including system's structure, physical and logical storage design. In the system, a share-nothing cluster is adopted and data is distributed to different nodes of cluster according to table's size. Then, this paper analyzed the executive time of a SQL statement, from user committing to server returning executive results. Based on it, the actual performance of different partition method is compared. The theoretical analysis and actual testing results demonstrate that the small size data is suitable to store single node, while the massive size data is more suitable to store several nodes of share-nothing clusters. For providing better performance, some optimal storage methods of massive audit data are provided, including data cluster and join index technology. At last, this paper gives three methods which support parallel transaction process on online computer-assisted audit system using parallel database, including no-limited standard parallel query algorithm, limited parallel query algorithm and rebuilding of parallel tables and indexes. |
语种 | 中文 ; 中文 |
出版者 | Science Press ; China |
内容类型 | 期刊论文 |
源URL | [http://hdl.handle.net/123456789/10044] ![]() |
专题 | 清华大学 |
推荐引用方式 GB/T 7714 | Wu Hai-Ping,Yu Hong-Liang,Zheng Wei-Min,et al. A massive data storage and management strategy for online computer-assisted audit system[J],2010, 2010. |
APA | Wu Hai-Ping,Yu Hong-Liang,Zheng Wei-Min,&Zhou De-Ming.(2010).A massive data storage and management strategy for online computer-assisted audit system.. |
MLA | Wu Hai-Ping,et al."A massive data storage and management strategy for online computer-assisted audit system".(2010). |
个性服务 |
查看访问统计 |
相关权益政策 |
暂无数据 |
收藏/分享 |
除非特别说明,本系统中所有内容都受版权保护,并保留所有权利。
修改评论