VALIDATING RELATIONSHIPS BETWEEN ENTITIES IN A DATA MODEL
Various embodiments of systems and methods to validate relationships between entities are described herein. In one aspect, upon receiving a selection of an object associated with a source entity, a list of associations corresponding to the source entity is provided, where each association defining a related target entity. Further, upon receiving a selection of at least one association from the list of associations entity relationship data corresponding to the selected object is retrieved from destination entities defined by the at least one selected association. And, the retrieved entity relationship data is rendered on a computer generated user interface.
1 . A non-transitory computer-readable medium storing instructions, which when executed by a computer cause the computer to perform operations comprising:
receive a selection of an object associated with a source entity;
provide a list of associations corresponding to the source entity, each association defining a related target entity;
receive a selection of at least one association from the list of associations;
retrieve entity relationship data between the selected object of the source entity and the related target entity defined by the at least one selected association; and
render the retrieved entity relationship data on a computer generated user interface.
2 . The non-transitory computer-readable medium of claim 1 , wherein the source entity comprises a data table to store entity data, where rows of the data table represent objects and columns of the data table represent attributes of the object.
3 . The non-transitory computer-readable medium of claim 1 , wherein the source entity and the target entity are associated with a data model.
4 . The non-transitory computer-readable medium of claim 1 , wherein the associations of the source entity with the target entity are predefined during data modeling of a data model.
5 . The non-transitory computer-readable medium of claim 1 , wherein retrieving the entity relationship data comprises identifying one or more objects of the target entity related with the selected object associated with the source entity based on the selected at least one association.
6 . The non-transitory computer-readable medium of claim 5 , wherein the one or more objects of the target entity are identified by executing a JOIN operation on the source entity and the target entity corresponding to the selected object.
7 . The non-transitory computer-readable medium of claim 1 , further comprising instructions, which when executed cause the computer system to perform operations comprising:
provide an option to input one or more filter criteria to refine the entity relationship data; and
provide a breadcrumb to navigate from entity relationship data corresponding to one filter criteria to entity relationship data corresponding to other filter criteria by storing entity relationship data of each filter criteria.
8 . A computer implemented method to validate relationships between entities in a data model, the method comprising:
receiving a selection of an object associated with a source entity;
providing a list of associations corresponding to the source entity, each association defining a related target entity;
receiving a selection of at least one association from the list of associations;
retrieving entity relationship data between the selected object of the source entity and the related target entity defined by the at least one selected association; and
rendering the retrieved entity relationship data on a computer generated user interface.
9 . The computer implemented method of claim 8 , wherein the source entity comprises a data table to store entity data, where rows of the data table represent objects and columns of the data table represent attributes of the object.
10 . The computer implemented method of claim 8 , wherein the source entity and the target entity are associated with the data model.
11 . The computer implemented method of claim 8 , wherein the associations of the source entity with the target entity are predefined during data modeling of the data model.
12 . The computer implemented method of claim 8 , wherein retrieving the entity relationship data comprises identifying one or more objects of the target entity related with the selected object associated with the source entity based on the selected at least one association.
13 . The computer implemented method of claim 8 , wherein the one or more objects of the target entity are identified by executing a JOIN operation on the source entity and the target entity corresponding to the selected object.
14 . The computer implemented method of claim 8 , further comprising:
providing an option to input one or more filter criteria to refine the entity relationship data; and
providing a breadcrumb to navigate from entity relationship data corresponding to one filter criteria to entity relationship data corresponding to other filter criteria by storing entity relationship data of each filter criteria.
15 . A system comprising:
a back-end computing system comprising a library that contains objects for use with a computer programming language; and
a front-end computing system that executes a development environment, the development environment comprising a plug-in that supports the computer programming language, the plug-in enabling access to the library; wherein the plug-in comprises a entity relationship parser to:
receive a selection of an object associated with a source entity;
provide a list of associations corresponding to the source entity, each association defining a related target entity;
receive a selection of at least one association from the list of associations;
retrieve entity relationship data corresponding to the selected object from destination entities defined by the at least one selected association; and
render the retrieved entity relationship data on a computer generated user interface.
16 . The computer system of claim 15 , wherein the source entity comprises a data table to store entity data, where rows of the data table represent objects and columns of the data table represent attributes of the object.
17 . The computer system of claim 15 , wherein the source entity and the target entity are associated with a data model.
18 . The computer system of claim 15 , wherein the associations of the source entity with the target entity are predefined during data modeling of a data model.
19 . The computer system of claim 15 , wherein retrieving the entity relationship data comprises identifying one or more objects of the target entity related with the selected object associated with the source entity based on the selected at least one association.
20 . The computer system of claim 15 , further comprising:
providing an option to input one or more filter criteria to refine the entity relationship data; and
providing a breadcrumb to navigate from entity relationship data corresponding to one filter criteria to entity relationship data corresponding to other filter criteria by storing entity relationship data of each filter criteria.