摘要:Oracle在企业中应用,尤其是在金融,电力,银行,交通等支柱产业的应用是非常广泛的,这些领域需要大量的数据存储,一般是以数据仓库的方式和数据库集群的方式来进行数据库服务器的分布式处理,对于数据库的分布式处理是一种多级数据处理过程,每一层次在运行的过程中会产生大量的日志积累,如何有效地利用这些遗留下来的日志数据以发现有效的利润增值模式,或者从历史日志中发现数据库的异常操作。本系统旨在研究如何通过oracle的日志文件重现历史操作。按照审计的方式分析日志格式,在历史还原的基础上,能对有毁坏性的数据进行数据恢复,对于不正常的数据操作,能很快地查明是什么人在什么时间进行了什么操作?
关键字:ORACLE{LOG MINIER,TKPROF, PRO*C/C++},.Net FRAMEWORK{C#,ASP.Net,VC.NET,IIS6.0},软件工程
Abstract:
The Oracle is applied in the business enterprise, especially in the finance, electric power, bank particularly, transportation etc. pay the main industry applied is very extensive。These realms need a great deal of data storage, gather the way of the cluster with database by the data warehouse generally to carry on the distribute type processing of the database server。Is a kind of many series for the distribute type processing of the database according to the processing process, each layer will produce a great deal of daily record backlog in the process of circulate, how make use of these daily records datas that leave behind down availably to discover that the valid profits increases in value the mode, or discover excrescent operations of the database from the history daily record.This system aim is studying how to re-appear the history operation through an oracle daily record documentAccording to the analytical daily record format of way that audit, foundation restore in the history up, the ability carry on the data instauration towards having the data of the deformation, operating for the abnormality data, can find out very soon is what person is carrying on when what operation?
Keywords:ORACLE{LOG MINIER,TKPROF, PRO*C/C++},.Net FRAMEWORK{C#,ASP.Net,VC.NET,IIS6.0},SE