Database Reference
In-Depth Information
location to improve the efficiency, sophistication, and impact of their re-
search, and to reduce the time required to conduct this analysis from
27 hours to 11 minutes!
NYSE Euronext: Reducing Data Latency
and Enabling Rapid Ad-Hoc Searches
NYSE Euronex is a Euro-American corporation that operates multiple securi-
ties exchanges, most notably the New York Stock Exchange (NYSE) and Eu-
ronext. NYSE ingests about 8 billion transactions per day. On certain days, for
example when we had the financial market “flash crash,” they process over
15 billion transactions. This is 2TB to 4TB of data that needs to be ingested into
their data warehouse each day. Their analysts track the value of a listed com-
pany, perform trend analysis, and search for evidence of fraudulent activity.
NYSE and Euronext perform market surveillance and analyze each and every
transaction from a trading day, which translates into full table scans on mas-
sive volumes of data. As is the case with many enterprises, NYSE and Euron-
ext's traditional data warehouse was moving data back and forth between the
storage systems and their analytic engine, and took over 26 hours to complete
certain types of processing. They also have global customers and need 24/7
access without any downtime. How did they address these challenges? They
chose Netezza. Netezza's core tenet of running compute close to data mini-
mized network traffic and reduced the time needed to access business critical
data from 26 hours to 2 minutes. It facilitated rapid ad-hoc searches over a
petabyte of data and opened up new analytical capabilities.
 
Search WWH ::




Custom Search