The Reference Data Center is part of Eagle's Data Management solution, a data-centric processing model designed to build and maintain enhanced data in the Eagle data warehouse using various applications and centers, some of which include the following:
| Fancy Bullets |
|---|
|
- Data Mart. A data repository within the Eagle data warehouse and other databases that allows you to organize information for a specific business purpose and distribute it to support specific business needs.
- Eagle Analytics. A specialized component that provides built-in functionality for the valuation and calculation of analytics for fixed income and derivative securities, under a licensing agreement for the FINCAD® Analytics Suite.
- Pricing Center. An application that allows you to manage the daily pricing process for best-of-breed security prices and foreign exchange (FX) rates.
- Metadata Center. A data governance tool that assists you with organizing, managing, and monitoring metadata, data about data.
- Eagle Enrichment. A specialized component that uses an original source of accounting data as a baseline to create a modified set of data warehouse data for an entity under a unique source.
|
| Anchor |
|---|
| _Toc422746868 |
|---|
| _Toc422746868 |
|---|
|
About the Security Database
The Eagle data warehouse is designed to consolidate information from multiple sources, reconcile discrepancies among vendors, and enrich the data available to clients. It consists of various databases. The security master data is stored in the SECURITY database in various tables and fields. The SECURITY database contains a variety of tables:
| Fancy Bullets |
|---|
|
- Composite Tables
- History Tables
- Time Series Tables
|
| Anchor |
|---|
| _Toc422746869 |
|---|
| _Toc422746869 |
|---|
|
Composite Tables
...
After the vendor security data is loaded into the Eagle data warehouse, the Reference Data Center processes the security history records via the data strategy, which identifies the following:
| Fancy Bullets |
|---|
- Securities managed by the data strategy
- Field groups and release levels in the data strategy
- Source hierarchy rules for each field
- Validation rules for each field
- Enrichment rules for each field
- Input values, such as the default and override values
|
For example, the following diagram shows security reference data received from three different sources: Reuters, Interactive Data, and Bloomberg.
The Reference Data Center interprets the user-defined source hierarchy rules via the data strategy, utilizing the data stored in the History tables. The following table shows an aggregation of the sources defined for each field in the previous diagram.
...