Relationships allow you to link your entities together, and subsequently build signals that traverse your graph of entities to retrieve and aggregate time series data.
Every relationship has a relationship type, such as
OWNED_BY. The full resource name for a relationship type is
The relationship types provided by Exabel are the following:
|Relationship type||Resource name||Typical connected entities|
|listing||relationshipTypes/HAS_LISTING||regional → listing|
|primary regional||relationshipTypes/HAS_PRIMARY_REGIONAL||security → regional|
|regional||relationshipTypes/HAS_REGIONAL||security → regional|
|security||relationshipTypes/HAS_SECURITY||company → security|
|location||relationshipTypes/LOCATED_IN||company → country|
|web domain||relationshipTypes/WEB_DOMAIN_OWNED_BY||company → web domain|
|rbic||relationshipTypes/HAS_PRIMARY_RBICS||company → rbics|
|rbics focus||relationshipTypes/HAS_PRIMARY_RBICS_FOCUS||company → rbics|
The relationship types provided by Exabel are read-only, meaning that customers cannot add new relationships with those relationship types. Customers are free to create new relationship types in their own namespace, using the API.
Some relationship types are marked as being an ownership. Relations of those types are aggregation paths in a data set, and they go from the owner to the sub-entity.
A relationship is a directed connection between two entities with a relationship type, that is, it is a connection from one entity to another entity. There can only be a single relationship of the same type and in the same direction between any two entities.
Typically a relationship only makes sense for specific entity types: For example, the relationship
HAS_LISTING requires the from entity to be a company and the to entity to be a listing. However, this restriction is not enforced.
Relationships are directional
All relationships created in the Exabel platform are directional, specifying the "from" and "to" entities.
This allows for extremely flexible and powerful queries to be written with the signal DSL, where you may traverse the graph from a starting entity (eg a company) in a specified direction, aggregating and transforming time series data along the way.
Exabel maintains a large number relationships between entities in the global namespace. These relationships all have one of the relationship types in the global namespace.
Customers can create new relationships between any entities they have access to.
Ownership relationships are aggregation paths in a data set, and go from owner entities to child entities.
In order for entities within a data set to show up in the Data Explorer, there must be ownership relationships connecting all such entities to the "leaf" entities on which raw data signals are defined.
All relationships, regardless if they are ownership relationships or not, can be used in DSL expressions for aggregation purposes.
Updated over 1 year ago