Updates management in enterprises databases

Managing concurrent updates in large-scale (distributed) enterprise databases is still an unsolved problem. A new paradigm using the usage correctness criterion and the Metadatabase model to allow for flexible and adaptive control is proposed. The new approach employs an architecture of concurrent rule-based control shells to effect a differential control mechanism supporting a range of integrity requirements for database updates management. The range supported includes both the traditional full control design and the various relaxation designs utilizing user-specified prioritization control knowledge. A new global synchronizer is developed for the new approach, along with a control rule derivation and modification algorithm. The laboratory testing (LAN) shows that the new method, when implemented on the basis of the existing Metadatabase system, performs correctly as designed. An industrial-testing (WAN) is also being conducted at Samsung Electronic Corporation for its product data management system. The preliminary results reveal some highly promising improvement over the present technology used there