Virtual rule partitioning method for maintaining database integrity

Abstract EN

The variant execution time of the update operation repair rules in a parallel and distributed environment is highly affected by the way the rules and tables settled in a database in according to whether they were partitioned or not.

The wellknown partitioning methods in the database were succeeded to reduce the response time of update operations since they expeditiously execute the update operation affecting different sites of partitions.

These methods are mortgaged by the determination of the type of partitioning during the design state of the system fixing all sites of the partitioned tables and distributed rules to different nodes.

Although distribution and partitioning have these merits, it still face some restrictions since it may be time consuming for the distributed system to locate the proper rule and the partition of data, which fulfill the requirement of repair update operation.

This paper proposes virtual rule partition method.

This method has more advantages over the classical methods because it allows us to reduce the total cost or the total response time consumed by repair update operations using horizontal partitioned tables.