Data management system and method

• US 6,782,003 B1
• Filed: 07/20/2000
• Issued: 08/24/2004
• Est. Priority Date: 04/12/2000
• Status: Expired due to Term

• Current Assignee: MEC Management, LLC (Three Affiliated Tribes of the Fort Berthold Reservation, North Dakota)
• Original Assignee: ServiceSwitch.com Inc.
• Inventors: Walsh, Sandy, Giroux, Philippe
• Primary Examiner(s): Sam, Phirin
• Application Number:
  US09/620,576
• Time in Patent Office: 1,496 Days
• Field of Search: 370/352, 370/353, 370/354, 370/462, 370/463, 370/466, 370/395.52, 709/200, 709/206, 709/202, 709/213, 709/218, 709/223, 709/227, 709/203, 709/208, 709/219
• US Class Current: 370/466
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: H04L 51/066 Format adaptation, e.g. format conversion or compression
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: H04L 69/08 Protocols for interworking; Protocol conversion
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04L 9/40 Network security protocols

Abstract

A method of replicating data on a source to a destination comprising the steps of: extracting data from a source via a user interface in a source format; converting the extracted data from the source'"'"'s format into a destination format; and uploading the converted data to said destination.

Claims

1. A method of replicating data on a source to a destination comprising the steps of:

extracting data from said source via a user interface in a source format by;

requesting logon information from an end user;

logging on to said source by transmitting said logon information to said source;

transmitting requests to said user interface of said source web site; and

receiving web page data in said source'"'"'s format;

converting said extracted data from said source'"'"'s format into a destination format by;

parsing pertinent data from said HTML web page data and storing said pertinent data in an intermediate format; and

compiling said stored pertinent data into said destination format; and

uploading said converted data to said destination.

2. The method of claim 1 wherein step of parsing comprises the step of:

deriving the relevant source data by use of a delta technique.

3. The method of claim 1 wherein step of parsing comprises the step of:

subtracting template information from the data and recognising the various types of data by positional information, tags or sequence.

4. The method of claim 1 wherein step of parsing comprises the step of:

comparing a data file to a data template to extract non-template data.

5. The method of claim 1 wherein step of parsing comprises the step of:

extracting formatting code from a markup language data file to obtain data.

6. The method of claim 1 further comprising the step of:

creating an account with said destination, prior to the transmission of any data to the destination.

7. The method of claim 6 wherein step of creating comprises the step of:

logging on to said destination web site via an internet connection.

8. The method of claim 7 wherein step of uploading comprises the step of:

transmitting said destination format, stored pertinent data, to said destination web site.

9. The method of claim 8 further comprising the step of:

recording details of the transaction for billing purposes, to provide an audit trail, and to provide feedback to the end-user.

10. A computer readable memory medium for storing software code executable to replicate data on a source to a destination, said software code being executable to perform the steps of:

extracting data from said source via a user interface in a source format by;

requesting logon information from an end user;

logging on to said source by transmitting said logon information to said source;

transmitting requests to said user interface of said source web site; and

receiving web page data in said source'"'"'s format;

converting said extracted data from said source'"'"'s format into a destination format by;

parsing pertinent data from said HTML web page data and storing said pertinent data in an intermediate format; and

compiling said stored pertinent data into said destination format; and

uploading said converted data to said destination.

11. A carrier signal incorporating software code executable to replicate data on a source to a destination, said software code being executable to perform the steps of:

extracting data from said source via a user interface in a source format by;

requesting logon information from an end user;

logging on to said source by transmitting said logon information to said source;

transmitting requests to said user interface of said source web site; and

receiving web page data in said source'"'"'s format;

converting said extracted data from said source'"'"'s format into a destination format by;

parsing pertinent data from said HTML web page data and storing said pertinent data in an intermediate format; and

compiling said stored pertinent data into said destination format; and

upload said converted data to said destination.