Method for incrementally extracting database view data in real time

The invention discloses a method for extracting database view data in a real-time incremental manner. The method comprises the following steps: step 1, constructing a mapping relationship between a view and an entity table and configuration information of associated fields; step 2, capturing database entity table change by a database change data acquisition program, and constructing a view change record according to the configuration information in the step 1; and step 3, judging whether the entity table change is increased or deleted, and respectively adding a record to the local and deleting the local record according to the two situations of the increase, the change and the deletion. 一种实时增量抽取数据库视图数据的方法，包括如下步骤：步骤1，构建视图与实体表映射关系及关联字段的配置信息；步骤2，数据库变更数据获取程序捕获数据库实体表变更，根据步骤1的所述配置信息构建视图变更记录；步骤3，判断所述实体表变更是增改还是删除，并且根据所述增改和删除两种情形分别添加记录到本地和删除本地记录。