Test strategy system and method for accounts held direct at-fund
First Claim
1. A method to facilitate the transfer of data from a client database to a host database comprising the steps of;
- identifying at least one data field from said client database desired for said host database;
incorporating said data field in a spreadsheet;
populating at least a portion of said data field in said spreadsheet with assumed data values;
developing an algorithm configured to reformat data associated with said data field from said client database and desired for said host database;
receiving a test file from said client database;
creating a reformatted test file with said test file using said algorithm;
comparing said reformatted test file to said spreadsheet;
identifying at least one change, wherein said change would substantially conform said reformatted test file to said spreadsheet;
creating an updated algorithm from said algorithm which incorporates said at least one change;
receiving an input file from said client database;
creating a reformatted input file by applying said updated algorithm to said input file; and
, uploading said reformatted input file to said host database.
3 Assignments
0 Petitions
Accused Products
Abstract
The present invention provides a system and method for a user to test and transfer data from a client'"'"'s database or network to a host'"'"'s database or network. In accordance with an exemplary embodiment of the present invention, a user acquires data information from a client. The user uses this information to generate a spreadsheet, and to populate the spreadsheet with assumed values based on the information received from the client. The spreadsheet is configured in a fashion such that it is consistent with the host'"'"'s database or network. The user requests and receives a test file from the client and uses a developed algorithm, generally in the form of a computer program, to reformat the file so that it is consistent with the host'"'"'s database configuration. The user determines the consistency between the reformatted file and the host'"'"'s database by comparing the reformatted file to the previously generated spreadsheet. Any inconsistencies identified alert the user that the file reformatting algorithm needs updating. When all the updates are complete and the reformatting algorithm has been deemed appropriate to carry out the data transformation function, the entire client database log is sent to the user in the form of an input file. The input file is duplicated to protect the original information and then reformatted using the updated algorithm. The reformatted file may then be uploaded to the host'"'"'s network or database so that the information contained may be used by others who access the database or network for information.
-
Citations
12 Claims
-
1. A method to facilitate the transfer of data from a client database to a host database comprising the steps of;
-
identifying at least one data field from said client database desired for said host database;
incorporating said data field in a spreadsheet;
populating at least a portion of said data field in said spreadsheet with assumed data values;
developing an algorithm configured to reformat data associated with said data field from said client database and desired for said host database;
receiving a test file from said client database;
creating a reformatted test file with said test file using said algorithm;
comparing said reformatted test file to said spreadsheet;
identifying at least one change, wherein said change would substantially conform said reformatted test file to said spreadsheet;
creating an updated algorithm from said algorithm which incorporates said at least one change;
receiving an input file from said client database;
creating a reformatted input file by applying said updated algorithm to said input file; and
,uploading said reformatted input file to said host database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A system to facilitate the transfer of data from a client database to a host database comprising;
-
a user to carry out the method steps on behalf of a host for a client;
a computer interface accessed by said user to facilitate the performance of said method steps;
a host database to accept the data information, transformed from said client database, wherein said client database further comprises a database clearinghouse containing data information from at least one Fund Family; and
,a network to facilitate the transfer of data between said client and said host.
-
Specification