利用触发器和元数据分析封闭模块的数据结构

Analysis of closed module's data structure using trigger and meta-data

商业封闭模块的数据结构不对外公布,造成信息系统集成困难。针对这种情况,提出一种分析封闭模块的数据结构的技术。利用数据库中的元数据确定封闭模块中用户建立的数据表,在数据表上建立触发器,最后利用触发器的事务处理能力,在模块的应用程序运行时动态跟踪发生在数据表上的插入、删除及更新操作。结果表明,该技术可以精确地跟踪封闭模块中程序对数据表上的插入、删除及更新这3种操作,而且对于每种操作,都能精确到对哪个表以及发生的记录的行数,从而部分确定封闭模块的数据结构。

The data structure of closed module purchased is not published, which make difficult to integrate information system. Aimed at this problem, a kind of technology is introduced to analyse data structure in closed module. Firstly the tables created by closed module are made clear by using the meta-data in database, then triggers are created on these tables, finally by using trigger＇s transaction, manipulations such as inserting, deleting and updating on these tables are tracked dynamically during the running of an application of closed module. Results proves that this technology can accurately track manipulations such as inserting, deleting and updating on tables, what＇s more, it even can accurately track which table is manipulated and also the number of records manipulated, so that closed module＇s data structure can be partly made clear.