Graphically representing related record families using a phantom parent node
Embodiments use a phantom apex node to graphically illustrate a plurality of hierarchical records. Each record includes a parent field, and an entry in the parent field identifies a parent record of a given record. The parent record is higher in hierarchy than the given record. Embodiments identify record(s) that have no entry in the parent field. A phantom apex record is added to the database. A reference to the phantom apex record is inserted for each record that did not have an entry in the parent field. An x-y coordinate position is determined for all hierarchical records based on the parent field in each record. Once the positions are determined, all references to the phantom apex record are removed from all of the parent fields, and the phantom apex record itself is removed from the database. The plurality of records are then graphically rendered on a target output medium.
1. A method for graphically illustrating a plurality of hierarchical records, the method comprising:
receiving, by a computer device, a user request for a record stored at a database;
identifying, by the computer device, a first group of hierarchical records associated with the record among the plurality of hierarchical records stored at the database in response to the user request, wherein each current record in the plurality of hierarchical records is associated with a parent record of the current record, wherein the parent record is higher in a hierarchy than the current record, wherein the first group of hierarchical records consists of a first family of records that includes a first apex record at a highest point in the hierarchy, wherein the first group of hierarchical records includes the record;
identifying a second group of hierarchical records among the plurality of hierarchical records as being related to the first group of hierarchical records including a second apex record at the highest point in the hierarchy, wherein the second group of hierarchical records includes at least a second family of records;
adding, by the computer device, a phantom apex record to the plurality of hierarchical records stored at the database, wherein the phantom apex record has zero parent records and zero children records;
inserting, by the computer device, a reference to the phantom apex record in each of the first apex record and the second apex record;
determining, by the computer device, a position for each of the plurality of hierarchical records based on the parent record associated with each record;
after determining the position for the each of the plurality of hierarchical records, deleting, by the computer device, the references to the phantom apex record in the first apex record and the second apex record while storing a second position determined for the phantom apex record; and
graphically representing, by the computer device, the plurality of hierarchical records excluding the phantom apex record based on the position for the each of the plurality of hierarchical records, wherein the first group of hierarchical records is rendered adjacent to and disconnected from the second group of hierarchical records, the first apex record being aligned with the second apex record based on the second position.
2. The method of claim 1 , wherein the phantom apex record is excluded to prevent the phantom apex record from being rendered at the second position determined for the phantom apex record.
3. The method of claim 1 , wherein identifying the first group of hierarchical records or the second group of hierarchical records includes:
identifying, by the computer device, a list of records and a hierarchical relationship among the plurality of hierarchical records.
4. The method of claim 1 , wherein determining the position for each of the plurality of hierarchical records includes:
determining, by the computer device, an x-y coordinate on a target output medium for rendering a shape at each determined position for each of the plurality of hierarchical records on the target output medium.
5. The method of claim 1 , wherein the position for a given record among the plurality of hierarchical records on a first target output medium having a first set of dimensions is different than the position for the given record on a second target output medium having a second set of dimensions, wherein the first target output medium has a different size than the second target output medium.
6. The method of claim 1 , wherein no shape is rendered at the second position.
7. The method of claim 1 , further comprising:
adding or subtracting, by the computer device, a fixed distance from the position of the each of the plurality of hierarchical records in order to move a graphical representation of the plurality of hierarchical records over where the phantom apex record would have been rendered.
8. The method of claim 1 , wherein the plurality of hierarchical records are graphically illustrated utilizing a graphical tree.
9. A system comprising:
a processor and a non-transitory computer-readable medium coupled to the processor, the non-transitory computer-readable medium comprising instructions that, when executed by the processor, cause the processor to:
receive a user request for a record stored at a database;
identifying a first group of hierarchical records associated with the record among a plurality of hierarchical records stored at the database in response to the user request, wherein each current record in the plurality of hierarchical records is associated with a parent record of the current record, wherein the parent record is higher in a hierarchy than the current record, wherein the first group of hierarchical records consists of a first family of records that includes a first apex record at a highest point in the hierarchy, wherein the first group of hierarchical records includes the record;
identify a second group of hierarchical records among the plurality of hierarchical records as being related to the first group of hierarchical records including a second apex record at the highest point in the hierarchy, wherein the second group of hierarchical records includes at least a second family of records;
adding a phantom apex record to the plurality of hierarchical records stored at the database, wherein the phantom apex record has zero parent records and zero children records;
insert a reference to the phantom apex record for each of the first apex record and the second apex record;
determine a position for each of the plurality of hierarchical records based on the parent record associated with each record;
after determining the position for the each of the plurality of hierarchical records, delete the references to the phantom apex record in the first apex record and the second apex record while storing a second position determined for the phantom apex record; and
graphically representing the plurality of hierarchical records excluding the phantom apex record based on the position for the each of the plurality of hierarchical records, wherein the first group of hierarchical records is rendered adjacent to and disconnected from the second group of hierarchical records, the first apex record being aligned with the second apex record based on the second position.
10. The system of claim 9 , wherein the phantom apex record is excluded to prevent the phantom apex record from being rendered at the second position determined for the phantom apex record.
11. The system of claim 9 , wherein identifying the first group or the second group of hierarchical records includes:
identifying a list of records and a hierarchical relationship among the plurality of hierarchical records.
12. The system of claim 9 , wherein determining the position for each of the plurality of hierarchical records includes:
determining an x-y coordinate on a target output medium for rendering a shape at each determined position for each of the plurality of hierarchical records on the target output medium.
13. The system of claim 9 , wherein the position for a given record among the plurality of hierarchical records on a first target output medium having a first set of dimensions is different than the position for the given record on a second target output medium having a second set of dimensions, wherein the first target output medium has a different size than the second target output medium.
14. The system of claim 9 , wherein determining the position for each of the plurality of hierarchical records comprises:
adding or subtracting a fixed distance from the position of the each of the plurality of hierarchical records in order to move graphical representation of the plurality of hierarchical records over where the phantom apex record would have been rendered.
15. A non-transitory computer-readable medium storing instructions that, when executed by a processor, cause the processor to:
receive a user request for a record stored at a database;
identify a first group of hierarchical records associated with the record among a plurality of hierarchical records stored at the database in response to the user request, wherein each current record in the plurality of hierarchical records is associated with a parent record of the current record, wherein the parent record is higher in a hierarchy than the current record, wherein the first group of hierarchical records consists of a first family of records that includes a first apex record at a highest point in the hierarchy, wherein the first group of hierarchical records include the record;
identify a second group of hierarchical records among the plurality of hierarchical records as being related to the first group of hierarchical records including a second apex record at the highest point in the hierarchy wherein the second group of hierarchical records includes at least a second family of records;
adding a phantom apex record to a plurality of hierarchical records stored at the database, wherein the phantom apex record has zero parent records and zero child records;
insert a reference to the phantom apex record in each of the first apex record and the second apex record;
determine a position for each of the plurality of hierarchical records based on the parent record associated with each record;
after determining the position for the each of the plurality of hierarchical records, delete the references to the phantom apex record in the first apex record and the second apex record while storing a second position determined for the phantom apex record; and
graphically representing the plurality of hierarchical records excluding the phantom apex record based on the position for the each of the plurality of hierarchical records, wherein the first group of hierarchical records is rendered adjacent to and disconnected from the second group of hierarchical records, the first apex record being aligned with the second apex record based on the second position.
16. The non-transitory computer-readable medium of claim 15 , wherein the phantom apex record is excluded to prevent the phantom apex record from being rendered at the second position determined for the phantom apex record.
17. The non-transitory computer-readable medium of claim 15 , wherein identifying the first group or the second group of hierarchical records includes:
receiving a list of records and a hierarchical relationship among the plurality of hierarchical records.
18. The non-transitory computer-readable medium of claim 15 , wherein determining the position for each of the plurality of hierarchical records includes:
determining an x-y coordinate on a target output medium for rendering a shape at each determined position for each of the plurality of hierarchical records on the target output medium.
19. The non-transitory computer-readable medium of claim 15 , wherein the position for a given record among the plurality of hierarchical records on a first target output medium having a first set of dimensions is different than the position for the given record on a second target output medium having a second set of dimensions, wherein the first target output medium has a different size than the second target output medium.
20. The non-transitory computer-readable medium of claim 15 , wherein determining the position for each of the plurality of hierarchical records comprises:
adding or subtracting a fixed distance from the position of the each of the plurality of hierarchical records in order to move graphical representation of the plurality of hierarchical records over where the phantom apex record would have been rendered.