Processing business data using user-configured keys

• US 7,356,541 B1
• Filed: 10/27/2000
• Issued: 04/08/2008
• Est. Priority Date: 10/29/1999
• Status: Expired due to Fees

• Current Assignee: Computer Sciences Corporation (DXC Technology Company)
• Original Assignee: Computer Sciences Corporation (DXC Technology Company)
• Inventors: Doughty, Steven G.
• Primary Examiner(s): Colbert; Ella
• Application Number:
  US09/699,056
• Time in Patent Office: 2,720 Days
• Field of Search: 707/103.R, 707/102, 707/100, 707/1, 707/3, 707/4, 707/6, 707/10, 707/104.1, 707/200, 705 1- 45
• US Class Current: 707/703
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/03 Credit; Loans; Processing thereof

Abstract

A system, method and carrier medium for locating processing parameter values in a Financial Service Organization (FSO) computer system using pre-configured key definitions, key values, and key value search masks. The key definitions, key values, processing parameter values and key value search masks may be identified by a user during a configuration of the FSO computer system. The FSO computer system may include one or more processing parameters. Each processing parameter may have one key definition, one or more key values with one processing parameter value assigned to each key value, and one or more key value search masks. The FSO computer system may include a database for storing the key definitions, key values and their associated processing parameter values, and key value search masks. The key definitions, key values and their associated parameter values, and key value search masks may be stored in tables in the database. The FSO computer system may be configured to construct processing key values from one or more data element values in the FSO computer system. A key definition may include one or more key elements. A key element may be used to locate a data element value in the FSO computer system, and to format the data element value into a key element value in the processing key value. A key value search mask may be used to specify the substitution of a wildcard value for a data element value in a key element value. The FSO computer system may be configured to search the database for a key value that matches the processing key value. A key value may include one or more key element values corresponding to the key elements in the key definition for the key value. One or more of the key element values may be set to a wildcard key element value. The FSO computer system may be configured to read the processing parameter value associated with the key value from the database in response to finding a matching key value for the processing key value. The FSO computer system may use the located processing parameter value in the processing of FSO transaction data.

Claims

1. A method performed in a Financial Service Organization (FSO) computer system, the method comprising:

configuring one or more processing parameter values for use in processing transaction-related data in the FSO computer system;

reading a key definition from a database in response to receiving a request for a processing parameter from a first program, the key definition comprising the identity of one or more data element values in a set of transaction-related data;

selecting a search mask table that corresponds to the key definition, the selected search mask table comprising one or more search masks;

reading a first search mask from the selected search mask table, the first search mask comprising one or more search mask fields, each of the one or more search mask fields corresponding to one of the one or more data element values identified in the key definition, and each of the one or more search mask fields comprising a search mask field value;

transferring one of the one or more data element values read from the transaction-related data to a first processing key value in response to the search mask field value indicating that the data element value from the transaction-related data is to be written to the processing key value;

setting the first processing key value to a wildcard value if the search mask field value comprises a wildcard search mask field value;

comparing the first processing key value to one or more key values in the database;

if a match is found between the first processing key value and one of the one or more key values stored in the database, reading from the database a processing parameter value associated with the matching key value;

if a match is not found between the first processing key value and one of the one or more key values stored in the database;

creating one or more additional processing key values, the one or more additional processing key values being formed using one or more additional search masks obtained from the selected search mask table;

comparing the one or more additional processing key values to one or more key values in the database until a match is found between at least one of the one or more additional processing key values; and

reading from the database a processing parameter value associated with the matching key value;

sending the processing parameter value associated with the matching key value in the database to the first program.

2. The method of claim 1, wherein the one or more key values in the database are defined by the user of the FSO computer system during the configuration of the FSO computer system, wherein the configuration of the FSO computer system occurs when a software program on the FSO computer system is initially set up for processing FSO transactions.

3. The method of claim 1, wherein the database further comprises a plurality of processing parameter tables, wherein each processing parameter table comprises one or more rows, wherein each row in the processing parameter table comprises one processing parameter value and one key value.

4. The method of claim 3, wherein the key definition is one of a plurality of key definitions in the database, wherein each of the plurality of key definitions in the database is associated with one of the plurality of processing parameter tables in the database.

5. The method of claim 4, wherein the plurality of key definitions are stored in one or more key definition tables, each key definition table being associated with one or more of the plurality of processing parameter tables, wherein reading the key definition from the database comprises reading the key definition from one of the key definition tables.

6. A computer system for processing Financial Service Organization

(FSO) transactions, the system comprising:

a computer program;

a Financial Service Organization (FSO) computer system;

wherein the computer program is executable on the computer system to execute;

configuring one or more processing parameter values for use in processing transaction-related data in the FSO computer system;

reading a key definition from a database in response to receiving a request for a processing parameter from a first program, the key definition comprising the identity of one or more data element values in a set of transaction-related data;

selecting a search mask table that corresponds to the key definition, the selected search mask table comprising one or more search masks;

reading a first search mask from the selected search mask table, the first search mask comprising one or more search mask fields, each of the one or more search mask fields corresponding to one of the one or more data element values identified in the key definition, and each of the one or more search mask fields comprising a search mask field value;

transferring one of the one or more data element values read from the transaction-related data to a first processing key value in response to the search mask field value indicating that the data element value from the transaction-related data is to be written to the processing key value;

setting the first processing key value to a wild card value if the search mask field value comprises a wildcard search mask field value;

comparing the first processing key value to one or more key values in the database;

if a match is found between the first processing key value and one of the one or more key values stored in the database, reading a processing parameter value from the database in response to finding a match between the first processing key value and one of the one or more key values stored in the database;

if a match is not found between the first processing key value and one of the one or more key values stored in the database;

creating one or more additional processing key values, the one or more additional processing key values being formed using one or more additional search masks obtained from the selected search mask table;

comparing the one or more additional processing key values to one or more key values in the database until a match is found between at least one of the one or more additional processing key values; and

reading from the database a processing parameter value associated with the matching key value;

sending the processing parameter value associated with the matching key value in the database to the first program.

7. The system of claim 6, wherein the one or more key values in the database are defined by the user of the FSO computer system during the configuration of the FSO computer system, wherein the configuration of the FSO computer system occurs when a software program on the FSO computer system is initially set up for processing FSO transactions.

8. The system of claim 6, wherein the database further comprises a plurality of processing parameter tables, wherein each processing parameter table comprises one or more rows, wherein each row in the processing parameter table comprises one processing parameter value and one key value.

9. The system of claim 8, wherein the key definition is one of a plurality of key definitions in the database, wherein each of the plurality of key definitions in the database is associated with one of the plurality of processing parameter tables in the database.

10. The system of claim 9, wherein the plurality of key definitions are stored in one or more key definition tables, each key definition table being associated with one or more of the plurality of processing parameter tables, wherein reading the key definition from the database comprises reading the key definition from one of the key definition tables.

11. A computer readable medium comprising program instructions, wherein the program instructions are executable by a Financial Service Organization (FSO) computer system to implement:

configuring one or more processing parameter values for use in processing transaction-related data in the FSO computer system

reading a key definition from a database in response to receiving a request for a processing parameter from a first program, the key definition comprising the identity of one or more data element values in a set of transaction-related data;

selecting a search mask table that corresponds to the key definition, the selected search mask table comprising one or more search masks;

reading a first search mask from the selected search mask table, the first search mask comprising one or more search mask fields, each of the one or more search mask fields corresponding to one of the one or more data element values identified in the key definition, and each of the one or more search mask fields comprising a search mask field value;

transferring one of the one or more data element values read from the transaction-related data to a first processing key value in response to the search mask field value indicating that the data element value from the transaction-related data is to be written to the processing key value;

setting the first processing key value to a wildcard value if the search mask field value comprises a wildcard search mask field value;

comparing the first processing key value to one or more key values in the database;

if a match is found between the first processing key value and one of the one or more key values stored in the database, reading from the database a processing parameter value associated with the matching key value;

if a match is not found between the first processing key value and one of the one or more key values stored in the database;

creating one or more additional processing key values, the one or more additional processing key values being formed using one or more additional search masks obtained from the selected search mask table;

comparing the one or more additional processing key values to one or more key values in the database until a match is found between at least one of the one or more additional processing key values; and

reading from the database a processing parameter value associated with the matching key value;

sending the processing parameter value associated with the matching key value in the database to the first program.

12. The computer readable medium of claim 11, wherein the one or more key values in the database are defined by the user of the FSO computer system during the configuration of the FSO computer system, wherein the configuration of the FSO computer system occurs when a software program on the FSO computer system is initially set up for processing FSO transactions.

13. The computer readable medium of claim 11, wherein the database further comprises a plurality of processing parameter tables, wherein each processing parameter table comprises one or more rows, wherein each row in the processing parameter table comprises one processing parameter value and one key value.

14. The computer readable medium of claim 13, wherein the key definition is one of a plurality of key definitions in the database, wherein each of the plurality of key definitions in the database is associated with one of the plurality of processing parameter tables in the database.

15. The computer readable medium of claim 14, wherein the plurality of key definitions are stored in one or more key definition tables, each key definition table being associated with one or more of the plurality of processing parameter tables, wherein reading the key definition from the database comprises reading the key definition from one of the key definition tables.