[ROOT] / doc / tocInheritance / PRich / PCollection

DimAccountCollection , DimCustomerCollection , DimDepartmentCollection , DimEmployeeCollection , DimOrganizationCollection , DimProductCollection , DimProductSubcategoryCollection , DimResellerCollection , FactCurrencyRateCollection , FactFinanceCollection , FactInternetSaleCollection , FactInternetSaleReasonCollection , FactProductDescriptionCollection , FactProductInventoryCollection , FactResellerSaleCollection , FactSalesQuotaCollection , FactSurveyResponseCollection , TranslationsCollection

A class useful for storing a collection of entities (a table in RDBMS-terms) because it implements Indexing.

Uses Indexing for all keys ending with 'Id' (keys assumed to be foreign keys).

Example, for an entity type 'Order', you can create an inheriting class like this:
public class OrderCollection : PCollection {
}
in order to utilize indexing when searching for foreign keys in the 'Order'-collection, like 'Order/WHERE CustomerId = 42'
Note how TryParse choses a collection class with help from AllIPDerivedEntityCollectionClassesDict, but it does not necessarily have to inherit PCollection.

TODO: Consider introducing a generic type-parameter for the class for which we are a collection for.
TODO: See -PCollectionES- in ARCEvent for examples.

DimAccountCollectionThe existence of this class ensures that Indexing will be used for foreign key ParentDimAccountId.
DimCustomerCollectionThe existence of this class ensures that Indexing will be used for foreign key DimGeographyId.
DimDepartmentCollectionThe existence of this class ensures that Indexing will be used for foreign key ParentDimDepartmentId.
DimEmployeeCollectionThe existence of this class ensures that Indexing will be used for foreign keys ParentEmployeeId and DimSalesTerritoryId.
DimOrganizationCollectionThe existence of this class ensures that Indexing will be used for foreign keys like ParentDimOrganizationId and DimCurrencyId,
DimProductCollectionThe existence of this class ensures that Indexing will be used for foreign key DimProductSubcategoryId.
DimProductSubcategoryCollectionThe existence of this class ensures that Indexing will be used for foreign key DimProductCategoryId.
DimResellerCollectionThe existence of this class ensures that Indexing will be used for foreign key DimGeographyId.
FactCurrencyRateCollectionThe existence of this class ensures that Indexing will be used for foreign key DimCurrencyId.
FactFinanceCollectionThe existence of this class ensures that Indexing will be used for foreign keys like DimOrganizationId, DimDepartmentGroupId and DimAccountId.
FactInternetSaleCollectionThe existence of this class ensures that Indexing will be used for foreign keys like DimCustomerId, DimPromotionId, DimProductId and DimCurrencyId.
FactInternetSaleReasonCollectionThe existence of this class ensures that Indexing will be used for foreign key DimSalesReasonId.
FactProductDescriptionCollectionThe existence of this class ensures that Indexing will be used for foreign key DimProductId.
FactProductInventoryCollectionThe existence of this class ensures that Indexing will be used for foreign key DimProductId.
FactResellerSaleCollectionThe existence of this class ensures that Indexing will be used for foreign keys like DimProductId, DimResellerId, DimPromotionId, DimEmployeeId and DimSalesTerritoryId.
FactSalesQuotaCollectionThe existence of this class ensures that Indexing will be used for foreign key DimEmployeeId.
FactSurveyResponseCollectionThe existence of this class ensures that Indexing will be used for foreign keys DimCustomerId, DimProductCategoryId and DimProductSubcategoryId.
TranslationsCollectionThis would consist of one key per language, with keys like "de_DE", "fr_FR", "nb_NO".
Details

Generated 2024-05-18 09:20:19.736 UTC