Object reference structure generation for data purging
Systems and methods described herein relate to the automated generation of object reference structures for data purging processes. A primary query is executed in a database to identify first data objects with reference relationships to a root data object. Secondary queries are executed in the database to identify additional data objects with reference relationships to the first data objects or to other additional data objects identified in a previous one of the secondary queries. An object reference structure is generated based on the reference relationships among the root data object, the first data objects, and the additional data objects. The graphical representation is presented via a user interface. A purge instruction can be received with respect to at least part of the object reference structure. Execution of a data purge is triggered to purge data from the database according to the purge instruction.
1. A system comprising:
at least one memory that stores instructions; and
one or more processors configured by the instructions to perform operations comprising:
receiving, via a user interface, first user input identifying a root data object;
in response to receiving the first user input:
executing a primary query to identify, in a database, first data objects with reference relationships to the root data object, and
recursively executing secondary queries to identify, in the database, additional data objects with reference relationships to one or more of the first data objects or to any other additional data object identified in a previous one of the secondary queries until a predetermined condition is met;
generating an object reference structure based on the reference relationships among the root data object, the first data objects, and the additional data objects;
causing presentation, via the user interface, of a graphical representation of the object reference structure;
receiving, via the user interface, second user input comprising a purge instruction associated with at least part of the object reference structure; and
in response to receiving the second user input, triggering execution of a data purge to purge data from the database according to the purge instruction.
2. The system of claim 1 , wherein the database comprises a relational database, and each data object from among the root data object, the first data objects, and the additional data objects is mapped to a table in the database.
3. The system of claim 1 , wherein the graphical representation represents the object reference structure as a diagram that comprises a plurality of interconnected nodes, each of the plurality of interconnected nodes represents a respective one of the root data object, the first data objects, or the additional data objects, and the root data object is represented by a root node of the plurality of interconnected nodes in the diagram.
4. The system of claim 3 , the operations further comprising:
identifying, for a data object represented in the object reference structure, one or more attributes comprising at least one of a nullability, a variant data object, an object path, a data type, or a functional component; and
causing presentation, via the user interface, of the one or more attributes in association with a corresponding node of the plurality of interconnected nodes that represents the data object in the diagram.
5. The system of claim 1 , wherein the object reference structure identifies child data objects and parent data objects, and wherein the predetermined condition comprises performing one or more of the secondary queries for each child data object from among the child data objects that has a corresponding parent data object, from among the parent data objects, that is not nullable within a context of the child data object.
6. The system of claim 1 , the operations further comprising:
identifying a data object from among the first data objects and the additional data objects as a child data object of a parent data object from among the root data object, the first data objects, or the additional data objects;
determining a nullability of the parent data object of the child data object within a context of the child data object; and
causing presentation, via the user interface, of the nullability together with the graphical representation of the object reference structure.
7. The system of claim 1 , the operations further comprising:
identifying an object path of a data object from among the root data object, the first data objects, and the additional data objects; and
causing presentation, via the user interface, of the object path of the data object together with the graphical representation of the object reference structure.
8. The system of claim 1 , the operations further comprising:
determining a data type of a data object from among root data object, the first data objects, and the additional data objects; and
causing presentation, via the user interface, of the data type together with the graphical representation of the object reference structure.
9. The system of claim 1 , wherein the first user input or the second user input further comprises a value for the root data object, the operations further comprising:
using the value in addition to at least a subset of data objects from among the root data object, the first data objects, and the additional data objects to establish a purge scope associated with the purge instruction; and
executing the data purge based on the purge scope.
10. The system of claim 9 , wherein the root data object, the first data objects, and the additional data objects are identified in object data of a first data format, the operations further comprising:
converting at least some of the object data from the first data format to a second data format to obtain converted object data; and
transmitting the converted object data in the second data format to a purging service prior to execution of the data purge.
11. The system of claim 1 , the operations further comprising:
receiving, via the user interface, third user input to adjust at least one of the object reference structure or the graphical representation of the object reference structure; and
adjusting a purge scope associated with the purge instruction based on the third user input.
12. The system of claim 1 , wherein the purge instruction is associated with one or more temporal constraints that are used to establish a purge scope associated with the purge instruction.
13. The system of claim 1 , wherein the reference relationships among the root data object, the first data objects, and the additional data objects include one or more data object dependencies and one or more nested object relationships.
14. The system of claim 1 , the operations further comprising:
generating, from a database schema of the database, a list of selectable root data objects, wherein the first user input comprises a selection of the root data object from the list of selectable root data objects.
15. A method comprising:
receiving, via a user interface, first user input identifying a root data object;
in response to receiving the first user input:
receiving, via a user interface, first user input identifying a root data object;
in response to receiving the first user input:
executing a primary query to identify, in a database, first data objects with reference relationships to the root data object, and
recursively executing secondary queries to identify, in the database, additional data objects with reference relationships to one or more of the first data objects or to any other additional data object identified in a previous one of the secondary queries until a predetermined condition is met;
generating an object reference structure based on the reference relationships among the root data object, the first data objects, and the additional data objects;
causing presentation, via the user interface, of a graphical representation of the object reference structure;
receiving, via the user interface, second user input comprising a purge instruction associated with at least part of the object reference structure; and
in response to receiving the second user input, triggering execution of a data purge to purge data from the database according to the purge instruction.
16. The method of claim 15 , wherein the database comprises a relational database, and each data object from among the root data object, the first data objects, and the additional data objects is mapped to a table in the database.
17. The method of claim 15 , wherein the graphical representation represents the object reference structure as a diagram that comprises a plurality of interconnected nodes, each of the plurality of interconnected nodes represents a respective one of the root data object, the first data objects, or the additional data objects, and the root data object is represented by a root node of the plurality of interconnected nodes.
18. One or more non-transitory computer-readable media storing computer-executable instructions that, when executed by a computing system, cause the computing system to perform operations comprising:
receiving, via a user interface, first user input identifying a root data object;
in response to receiving the first user input:
executing a primary query to identify, in a database, first data objects with reference relationships to the root data object, and
recursively executing secondary queries to identify, in the database, additional data objects with reference relationships to one or more of the first data objects or to any other additional data object identified in a previous one of the secondary queries until a predetermined condition is met;
generating an object reference structure based on the reference relationships among the root data object, the first data objects, and the additional data objects;
causing presentation, via the user interface, of a graphical representation of the object reference structure;
receiving, via the user interface, second user input comprising a purge instruction associated with at least part of the object reference structure; and
in response to receiving the second user input, triggering execution of a data purge to purge data from the database according to the purge instruction.
19. The one or more non-transitory computer-readable media of claim 18 , wherein the database comprises a relational database, and each data object from among the root data object, the first data objects, and the additional data objects is mapped to a table in the database.
20. The one or more non-transitory computer-readable media of claim 18 , wherein the graphical representation represents the object reference structure as a diagram that comprises a plurality of interconnected nodes, each of the plurality of interconnected nodes represents a respective one of the root data object, the first data objects, or the additional data objects, and the root data object is represented by a root node of the plurality of interconnected nodes.