METHODS AND SYSTEMS FOR RETRIEVING DATA STORED IN A DATABASE

• US 20100030759A1
• Filed: 06/29/2009
• Published: 02/04/2010
• Est. Priority Date: 11/21/1994
• Status: Active Grant

• Current Assignee: BGC Partners LP (BGC Group, Inc.)
• Original Assignee: BGC Partners Incorporated (BGC Group, Inc.)
• Inventors: LAWRENCE, DAVID
• Granted Patent: US 8,588,729 B2
• Time in Patent Office: Days
• US Class Current: N/A
• CPC Class Codes: G06Q 30/08 Auctions
• CPC Class Codes: G06Q 40/04 Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange

Abstract

The invention provides a computer-implemented municipal bond trading system having a capability to conduct a private electronic auction of bid wanteds between a central brokers'"'"' broker and multiple prospective remote bidders and to maintain a reference database of accurate bond lot descriptions and identifications, notably, CUSIP (trademark) numbers.

Claims

1. A method comprising:

receiving a query for data stored in at least one of a plurality of databases;

in response to receiving the query, searching at least a first database and a second database of the plurality of databases in succession for the data, wherein searching the first database and the second database comprises;

determining that the data is not present in the first database; and

based at least in part on determining that the data is not present in the first database, retrieving the date from the second database, the first and second databases comprising a plurality of substantially matched data fields;

updating data fields of the first database with the data retrieved from matched data fields of the second database, the data retrieved from the second database absent in the first database; and

outputting the data retrieved from the second database,

wherein the data retrieved the second database comprises at least one of;

a bond rating, and

an indication of whether a bond has been called.

2. The method of claim 1, wherein the first database comprises a subset of the data of the second database.

3. The method of claim 1, the first and the second databases having at least one common data field there between, the method comprising synchronizing data associated with the at least one common data field periodically.

4. The method of claim 1, comprising purging inactive data from the first database periodically.

5. The method of claim 1, comprising priming the first database with a subset of data from the second database.

6. The method of claim 1, wherein the first database comprises substantially no additional fields to the fields of the second database.

7. The method of claim 1, comprising updating the first database with data from the second database periodically.

8. The method of claim 1, comprising updating the first database with data from the second database nightly.

9. The method of claim 1, wherein the first database is smaller in size than the second database.

12. The method of claim 1, further comprising incorporating the data retrieved the second database into a bid wanted.

10. A method for retrieving data from a database comprising:

receiving a query for data stored in at least one of a plurality of databases;

in response to receiving the query, searching at least a first database and a second database of the plurality of databases in succession for the data, wherein searching the first database and the second database comprises;

determining that the data is not present in the first database; and

based at least in part on determining that the data is not present in the first database, retrieving date from the second database, wherein the first and second databases comprise a plurality of substantially matched data fields, and wherein the first database comprises a subset of the data of the second database;

updating data fields of the first database with the data retrieved from matched data fields of the second database, the data retrieved from the second database absent in the first database; and

outputting the data retrieved from the second database,

wherein the data retrieved the second database comprises at least one of;

a bond rating, and

an indication of whether a bond has been called.

13. The method of claim 10, further comprising incorporating the data retrieved the second database into a bid wanted.

11. A method for retrieving data from a database comprising:

receiving a query for data stored in at least one of a plurality of databases;

in response to receiving the query, searching at least a first database and a second database of the plurality of databases in succession for the data, wherein searching the first database and the second database comprises;

determining that the data is not present in the first database; and

based at least in part on determining that the data is not present in the first database, retrieving the data from the second database, the first and second database comprising a plurality of substantially matched data fields and having at least one common data field there between;

updating data fields of the first database with the data retrieved from matched data fields of the second database, the data retrieved from the second database absent in the first database;

providing as output the data retrieved from the second database,

wherein the data retrieved the second database comprises at least one of;

a bond rating, and

an indication of whether a bond has been called;

synchronizing data associated with the at least one common data field periodically; and

purging inactive data from the first database periodically.

14. The method of claim 11, further comprising incorporating the data retrieved the second database into a bid wanted.