Introduction to Database Resources

The Data Store for the Data Exchange includes specialized resources designed to accelerate your ability to prepare and configure your data.

Resources in All Schemas

Resource Name	Resource Type	Description
DE_LOG	Table	Provides logging output from Data Exchange database processes. Learn more about database logging

Resources for Collection Mapping Schemas

You are in control of the views that are placed in the Collection mapping schema. These views must be named to match the target relational table in the Collection model schema.

Resources for Collection Model Schemas

Resource Name	Resource Type	Description
DE_COLLECTION (details)	Package	Provides the primary data synchronization routines and quality checking routines to get data into your targeted Industry Model.
DE_AI (details)	Package	Provides data prep routines for Generative AI.
DE_CHANGE_EVENT	Table	Stores the generated change events for records standardized in the model schema.
DE_CHANGE_EVENT_BATCH	Table	Stores the higher level batches of change events that make it easier to retrieve chunks of data.
DE_COLLECTION_OVERVIEW	Table	Provides an overview of the status of the Collection, which includes records for each table and error counts.
DE_MAPPING_ERRORS	Table	Stores the individual error records for any data synchronization issues.
DE_MAPPING_ERRORS_DETAIL	View	Error table that lists row level information.
DE_MAPPING_ERRORS_SUMMARY	View	Error summary table that lists the tables that are mapped improperly.
DYNAMIC_RELATED_ENTITIES	View	Dynamically connects data relationships with graph triples. Data is available after performing actions for refining your data.

Database Packages

DE_COLLECTION Package

Provides the primary data synchronization routines and quality checking routines to get data into your targeted Industry Model.

Routines for DE_COLLECTION

| Routine Name | Routine Type | Description | Input Parameters | | :———– | :————– | :————– | :————– | | SYNC_COLLECTION | Procedure | Synchronize the entire Collection from the mapping views to the standardized model tables. | None | | SYNC_COLLECTION_TABLE | Procedure | Synchronize a single entity from the mapping view to the standardized model table. | collection_table_name VARCHAR2 | | TRUNCATE_ENTIRE_COLLECTION | Procedure | Truncate all standardized tables for the entire Collection. | None | | TRUNCATE_COLLECTION_TABLE | Procedure | Truncate a single standardized table in a Collection. | collection_table_name VARCHAR2 | | SYNC_TRIPLE_STORE | Procedure | Synchronize the triple store for a Collection. | execution_mode VARCHAR2 (optional) allowed values: relationships_only (default), all | | TRUNCATE_TRIPLE_STORE | Procedure | Truncate the triple store for a Collection. | None |

DE_AI Package

Provides data prep routines for Generative AI.

Routines for DE_AI

| Routine Name | Routine Type | Description | Input Parameters | | :———– | :————– | :————– | :————– | | REFRESH_LANGUAGE_VIEWS | Procedure | Creates or re-creates the #LANGUAGE views for every standardized table with data in your Collection. | None |