Filtered remote journal

A computer-implemented method for sending database journal information from a first computer system to a second computer system by an operating system in the first computer system, the operating system performing the steps of:

• (A) generating a target map in the first computer system of a second database journal on the second computer system to define locations of a plurality of entries in the second database journal;
• (B) generating from at least one selection criteria a vector array that identifies a subset of information in a first database journal in the first computer system that is less than all information in the first database journal;
• (C) writing the vector array and location information from the target map to a communication manager in the operating system that manages communication between the first computer system and a second computer system coupled via a network to the first computer system;
• and
• (D) the communication manager transmitting the subset of information specified in the vector array from the first database journal to the second computer system.

A computer-implemented method for an operating system to send database journal information from a first computer system to a second computer system, the method comprising the steps of:

• (A) generating a target map in the first computer system of a second database journal on the second computer system to define locations of a plurality of entries in the second database journal;
• (B) displaying a graphical representation of a first database journal on the first computer system to a user;
• (C) the user entering at least one selection criteria for filtering information in the first database journal, the at least one selection criteria being selected from the group consisting of:
• (C1) manually selecting information in the first database journal;
• (C2) changing the at least one selection criteria;
• and
• (C3) adding additional selection criteria;
• (D) indicating in the displayed graphical representation data in the first database journal that satisfies the at least one selection criteria;
• (E) generating a vector array that identifies a subset of the information in the first database journal that is less than all information in the first database journal based on the at least one selection criteria, wherein the vector array comprises a plurality of pointer-length pairs, each pointer pointing to one of the plurality of journal entries in the first database journal, and each length specifying how much data to send to the second computer system;
• (C) writing the vector array and location information from the target map to a communication manager in the operating system that manages communication between the first computer system and a second computer system coupled via a network to the first computer system;
• and
• (D) the communication manager transmitting information from the first database journal specified in the vector array to the second computer system.

An article of manufacture comprising an operating system stored on recordable media, the operating system comprising:

• a first database journal that includes a plurality of journal entries that each represent a change made to a database;
• a filtered remote journal mechanism that generates a target map of a second database journal to define locations of a plurality of entries in the second database journal, the filtered remote journal mechanism generating from at least one selection criteria a vector array that identifies a subset of the information that is less than all information in the first database journal;
• and
• a communication manager that manages communication between a first computer system and a second computer system coupled via a network to the first computer system, wherein the communication manager receives from the filtered remote journal mechanism the vector array and location information from the target map, and in response, transmits the subset of information specified in the vector array from the first database journal to the second computer system.