REFERENCE PARTITIONING FOR DATABASE OBJECTS

摘要

In one general aspect, a computer-implemented system for reference partitioning database objects by a reference field includes at least one hardware processor, at least one database environment, the database environment supporting triggers and partitioning, at least one application program, and memory storing a reference field metadata framework. The reference field metadata framework identifies classes in a hierarchy of database objects, identifies at least one class as a root of the hierarchy, identifies, for each non-root class, a reference inheritance function for the class, and identifies, for each parent class-child class pair in the hierarchy, a relation-join query, the relation-join query being a join between tables in the database environment onto which the parent class and child class are persisted. The memory also stores triggers that use the framework to maintain values for the reference field for non-root database objects.

主权项

1. A computer-implemented method comprising:
receiving, from an application program, a new value for a field of a root database object, the root database object being an object in a database partitioned based on values of the field, each database object being a row in a table and the database objects being organized in a hierarchy, wherein the database supports triggers but lacks support for reference partitioning; updating the value of the field for the root object, thereby causing a table row associated with the root object to change partitions in the database; locating a first database object that is a child of the root object in the hierarchy; applying an inheritance function associated with a class of the child object to determine a value of the field for the first database object; when the determined value differs from a current value of the field for the first database object, changing the current value to the determined value and moving a table row for the first database object to a partition associated with the determined value; and repeating the locating, applying, and changing for all children of the root object.