Shao Y Wu

20100082417, Apr 1, 2010

Sep 24, 2008

12/236915

Shao Ai Wu - Brooklyn NY, US

Morgan Stanley (a Delaware corporation) - New York NY

G06F 17/30
G06Q 30/00

705 1418

A multi-session write-once computer tick database operable to store financial market data or “tick data.” The tick database stores market information regarding discrete market transactions in individual ticks. For example, information related to stock trades, and quotes may be stored in the database. The individual ticks vary in length dependent on the information available regarding the particular transaction. Null values are not stored in the database. Various field identifiers may be stored in the tick to identify the various metrics or parameters relevant to the transaction that are also stored in the tick. In various embodiments, one metric or parameter is associated with each field identifier. Different transactions may have different number of field identifiers stored within the tick, accordingly, different ticks may differ in length. The information stored within the ticks may be subsequently retrieved. When market data is retrieved using the embedded three-part hierarchal key structure, it may be stored in a cache associated with the tick database. The stored market data may be retrieved from the cache during subsequent requests.