Morgan Stanley Assigned Patent for Database for Financial Market Data Storage and Retrieval

Strategic Insights -

Morgan Stanley has been granted a patent for a database that can efficiently store and retrieve financial market data, including stock trades and quotes. The patented database, developed by Shao Ai Wu, allows for the storage and retrieval of market information in a format that can be easily accessed and analyzed. This innovation is expected to enhance the way financial data is managed and utilized in the industry.

Key Takeaways:

  • The patented database is designed to store financial market data, including stock trades and quotes, in a multi-session write-once computer tick database.
  • The database stores market information in individual "ticks," which vary in length depending on the information available regarding the particular transaction.
  • Null values are not stored in the database, and various field identifiers are used to identify the metrics or parameters relevant to the transaction.
  • The database allows for the retrieval of stored market data using an embedded three-part hierarchical key structure, which can be stored in a cache associated with the tick database.
  • The patent application was filed on September 24, 2008, and the patent was granted on March 8, 2011.

Statistics:

  • Patent number: 7,904,363
  • Date granted: March 8, 2011
  • Date of patent application filing: September 24, 2008
  • Number of field identifiers stored in the tick: varies
  • Length of individual ticks: varies dependent on the information available regarding the particular transaction

Sources:

  • U.S. Patent and Trademark Office
  • Patent title: "Database for financial market data storage and retrieval"
  • Patent abstract: "A multi-session write-once computer tick database operable to store financial market data or 'tick data.'"