arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 0809.3016cs.SEcs.HC
收藏

自动化电子表格发现和风险评估

Automating Spreadsheet Discovery & Risk Assessment

Eric Perry

摘要:

已经有许多文章和事故发布了关于不受控制的电子表格在当今商业环境中的风险,包括不合规,运营风险,错误和欺诈,所有这些都导致重大损失事件。电子表格属于最终用户开发的应用程序领域,并且通常缺乏IT组织将为企业应用程序实施的适当保护和控制。在如何开发电子表格方面,也总体上缺乏软件编程纪律。但是,在组织可以对关键电子表格应用适当的控制和纪律之前,必须在整个企业中创建一个准确和动态的电子表格清单,并且必须识别所有关键电子表格。因此,本文提出了一个自动化的方法,电子表格管理生命周期的初始阶段-发现,库存和风险评估。如果不使用技术,这些阶段往往被视为一次性项目。通过利用技术,他们成为一个可持续的业务流程。

英文摘要:

There have been many articles and mishaps published about the risks of uncontrolled spreadsheets in today's business environment, including non-compliance, operational risk, errors, and fraud all leading to significant loss events. Spreadsheets fall into the realm of end user developed applications and are often absent the proper safeguards and controls an IT organization would enforce for enterprise applications. There is also an overall lack of software programming discipline enforced in how spreadsheets are developed. However, before an organization can apply proper controls and discipline to critical spreadsheets, an accurate and living inventory of spreadsheets across the enterprise must be created, and all critical spreadsheets must be identified. As such, this paper proposes an automated approach to the initial stages of the spreadsheet management lifecycle - discovery, inventory and risk assessment. Without the use of technology, these phases are often treated as a one-off project. By leveraging technology, they become a sustainable business process.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑