Lifecycle reference partitioning for database objects

摘要

In one general aspect, a computer-implemented system for reference partitioning database objects by lifecycle state 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 lifecycle metadata framework. The lifecycle metadata framework identifies classes in a ragged hierarchy of database objects, identifies at least one class as a root of the hierarchy, identifies, for each non-root class, a lifecycle 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 lifecycle states for non-root database objects.

主权项

1. A computer-implemented method in a database partitioned based on a lifecycle state for database objects, each database object being a row in a table and the database objects being organized in a hierarchy, the method comprising:
receiving, from an application program, a new lifecycle state for a root database object in the hierarchy; updating the lifecycle state 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 lifecycle state for the first database object; when the determined lifecycle state differs from a current lifecycle state for the first database object, changing the current lifecycle state to the determined lifecycle state and moving a table row for the first database object to a partition associated with the determined lifecycle state; and repeating the locating, applying, and changing for all children of the root object.