Our database
administration (DBA) team is
experienced in managing real-time feeds and is
supported by a sophisticated workflow and
verification package.
They are responsible for
cleansing and adjusting our
real-time and time-series databases to account for:
IPOs, delists, symbol changes, dividends and splits.
Option expiration, new and deleted contracts,
leap rollbacks and corporate actions leading to
additional underlyings.
Data
corrections reported by voice or email by
the exchanges.
Etc.
In
addition, they source and maintain value-added
data such as:
Navigation data and chaining.
Reference data such as names and currencies,
where not carried on the source feed.
Root-level information such as contract
descriptions, trading hours, deliverable terms
for futures, options and future options.
Etc.
The DBA team uses a
combination of manual data
entry, automatic text readers and file download
processes to consolidate and clean the
information which
comes from a mixture of sources, including
newswires, regional exchanges and governing bodies such as
the OCC.
Automated
crosschecks and verification help to ensure
optimum data quality in both ACTIV and
client-sited systems.
