Method and system for database query
First Claim
1. A method of searching financial transactions against a server-resident file of sanctioned entities using a network, the network including a plurality of servers accessible by a plurality of user terminals, comprising:
- inputting at one of the plurality of user terminals a search request text pattern for searching a server-resident database of sanctioned entities, the search request text pattern including a text string, the text string further including one or more regular expression operators, including letters, digits or punctuation marks to further define the search request text pattern and to further identify the server being invoked;
storing the search request text pattern as an entry in a search request instruction file, the search request instruction file being accessible by a server processor;
transmitting the search request instruction file to the server processor invoked via the network;
the server processor checking the search request text pattern, the checking including matching text patterns of the search request text pattern against a file of sanctioned entities stored as a matchable text pattern file in the server; and
upon execution of the search, transmitting search results to the user terminal via the network.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system is disclosed for searching a database resident list or set of lists for user-defined text patterns, identifying a match, reporting information related to the search result, and maintaining the lists to be searched in a mutually updating distributed database with automatic failover. One embodiment of the present invention provides a method of using a computer utility program to maintain a database of sanctioned entities in a plurality of sanction lists where such sanction lists arise, for example, from OFAC, foreign governments, or internally. The computer utility program allows an authorized user to search user-selected text patterns against the sanction lists to identify a sanctioned entity. Further, the computer utility program is network based so that sanction lists may be searched using different hardware configurations worldwide. In addition, because the database is distributed and mutually updating, sanction lists may be dynamically updated globally and are completely redundant.
-
Citations
30 Claims
-
1. A method of searching financial transactions against a server-resident file of sanctioned entities using a network, the network including a plurality of servers accessible by a plurality of user terminals, comprising:
-
inputting at one of the plurality of user terminals a search request text pattern for searching a server-resident database of sanctioned entities, the search request text pattern including a text string, the text string further including one or more regular expression operators, including letters, digits or punctuation marks to further define the search request text pattern and to further identify the server being invoked;
storing the search request text pattern as an entry in a search request instruction file, the search request instruction file being accessible by a server processor;
transmitting the search request instruction file to the server processor invoked via the network;
the server processor checking the search request text pattern, the checking including matching text patterns of the search request text pattern against a file of sanctioned entities stored as a matchable text pattern file in the server; and
upon execution of the search, transmitting search results to the user terminal via the network. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)
-
-
16. A transaction screening system including a text phrase defining the parties to the transaction and a network, the network including a plurality of servers and user terminals, comprising:
-
means for inputting at one from the plurality of user terminals a selection of text patterns for searching a server-resident database of sanctioned entities, wherein text pattern selections include a text string including one or more regular expression operators, including letters, digits or punctuation marks to further define the text pattern selection and identify the server being invoked;
means for storing the text pattern selection as an entry in a search request instruction file, the search request instruction file being accessible by a server processor;
means for transmitting the search request instruction file to the server processor invoked via the network;
means for the server processor checking the search request text pattern, the means for checking including matching text patterns of the search request instruction file against a list of sanctioned entities stored as a matchable text pattern file in the server; and
means for transmitting search results to the user terminal via the network upon execution of the search.
-
Specification