Database partial replica generation system

Claim 3

A method according to claim 1 wherein said selecting step includes: selecting a first record from said first original record source wherein said first record contains a value in a field of said first record satisfying said filter wherein said filter is a boolean filter and said first record contains said foreign key; and selecting a second record from said second original record source wherein said second record contains said primary key, said primary key is linked by one of said predetermined relationships to said foreign key of said first record.

Claim 4

A method according to claim 2 wherein said populating step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 5

A method according to claim 2 wherein said step of selecting said second record includes: determining whether said primary key of said first record is specified by a relationship filter, wherein said relationship filter identifies a predetermined relationship between said primary key of said first original record source and said foreign key of said second original record source; and selecting said second record from said second original record source wherein said second record contains a foreign key corresponding to said primary key of said first record.

Claim 6

A method according to claim 4 wherein said populating step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 7

A method according to claim 1 wherein said selecting step includes: selecting a first record from said first original record source wherein said first record is within said first original record source, said first original record source is specified by said filter and said filter is an all-rows filter; selecting a second record from said second original record source wherein said second record contains said primary key, said primary key is linked by one of said predetermined relationships to said foreign key of said first record.

Claim 8

A method according to claim 6 wherein said populating step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 9

A method according to claim 6 wherein said step of selecting said second record includes: determining whether said primary key of said first record is specified by a relationship filter, wherein said relationship filter identifies a predetermined relationship between said primary key of said first original record source and said foreign key of said second original record source; and selecting said second record from said second original record source wherein said second record contains a foreign key corresponding to said primary key of said first record.

Claim 10

A method according to claim 8 wherein said populating step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 11

A method according to claim 1 wherein said retrieving step includes: retrieving said filter from said memory wherein said filter specifies records in said original database that have been changed since a most recent synchronization between said partial database and said original database.

Claim 14

A method according to claim 11 wherein said filter is selected from the group consisting of: boolean filters, and all-rows filters.

Claim 15

A method according to claim 12 wherein said selecting step includes: selecting a first record from a first original record source wherein said first record contains a value in said field satisfying said condition specified by said filter; and selecting a second record from a second original record source wherein said second record is related to said first record.

Claim 16

A method according to claim 13 wherein said copying step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 17

A method according to claim 13 wherein said step of selecting said second record includes; selecting said second record wherein said first record contains a foreign key corresponding to a primary key of said second record.

Claim 18

A method according to claim 13 wherein said step of selecting said second record includes: determining whether a primary key of said first record is specified by a relationship filter, wherein said relationship filter identifies a predetermined relationship between said primary key of said first original record source and a foreign key of said second original record source; and selecting a second record from said second original record source wherein said second record contains a foreign key corresponding to said primary key of said first record.

Claim 19

A computer-readable medium having computer-executable instructions for populating a partial replica database from an original database having multiple original record sources each of said original record sources having records wherein certain predetermined relationships apply to said original record sources said predetermined relationships linking a foreign key of a first of said original record sources to a primary key of a second of said original record sources, said method steps comprising: retrieving a filter associated with said replica database from a memory wherein said filter specifies certain conditions to be applied to said original database for the selection of records for the population of said replica database; selecting records from said original database wherein said selected records satisfy said conditions specified by said filter; and populating said replica database with said selected records to create a populated replica database, wherein said predetermined relationships of said original database are enforced in said populated replica database.

Claim 20

A computer-readable medium having computer-executable instructions for populating a partial replica database from an original database having multiple original record sources each of said original record sources having records wherein certain predetermined relationships apply to said original record sources said predetermined relationships linking a foreign key of a first of said original record sources to a primary key of a second of said original record sources, said method steps comprising: retrieving a filter associated with said replica database from a memory wherein said filter specifies certain conditions to be applied to said original database for the selection of records for the population of said replica database; selecting records from said original database wherein said selected records satisfy said conditions specified by said filter; and populating said replica database with said selected records to create a populated replica database, wherein said predetermined relationships of said original database are enforced in said populated replica database.

Claim 21

The computer-readable medium of claim 17 wherein said selecting step includes: selecting a first record from said first original record source wherein said first record contains a value in a field of said first record satisfying said filter wherein said filter is a boolean filter and said first record contains a foreign key; and selecting a second record from said second original record source wherein said second record contains said primary key, said primary key is linked by one of said predetermined relationships to said foreign key of said first record.

Claim 22

The computer-readable medium of claim 18 wherein said populating step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 23

The computer-readable medium of claim 18 wherein said step of selecting said second record includes: determining whether said primary key of said first record is specified by a relationship filter, wherein said relationship filter identifies a predetermined relationship between said primary key of said first original record source and said foreign key of said second original record source; and selecting said second record from said second original record source wherein said second record contains a foreign key corresponding to said primary key of said first record.

Claim 24

The computer-readable medium of claim 20 wherein said populating step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 25

The computer-readable medium of claim 17 wherein said selecting step includes: selecting a first record from said first original record source wherein said first record is within said first original record source, said first original record source is specified by said filter and said filter is an all-rows filter; selecting a second record from said second original record source wherein said second record contains said primary key, said primary key is linked by one of said predetermined relationships to said foreign key of said first record.

Claim 26

The computer-readable medium of claim 22 wherein said populating step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 27

The computer-readable medium of claim 20 wherein said step of selecting said second record includes: determining whether said primary key of said first record is specified by a relationship filter, wherein said relationship filter identifies a predetermined relationship between said primary key of said first original record source and said foreign key of said second original record source; and selecting said second record from said second original record source wherein said second record contains a foreign key corresponding to said primary key of said first record.

Claim 28

The computer-readable medium of claim 24 wherein said populating step includes: copying said first record from said first original record source to a first replica record source wherein said first replica record source corresponds to said first original record source and is part of said replica database; and copying said second record from said second original record source to a second replica record source wherein said second replica record source corresponds to said second original record source and is part of said replica database.

Claim 29

The computer-readable medium of claim 17 wherein said retrieving step includes: retrieving said filter from said memory wherein said filter specifies records in said original database that have been changed since a most recent synchronization between said partial database and said original database.