Method and product for performing data transfer in a computer system

• US 6,421,683 B1
• Filed: 03/31/1999
• Issued: 07/16/2002
• Est. Priority Date: 03/31/1999
• Status: Expired due to Term

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Verizon Laboratories Incorporated (Verizon Communications Inc.)
• Inventors: Lamburt, Leonid
• Primary Examiner(s): Vu, Kim
• Assistant Examiner(s): Kindred, Alford W.
• Application Number:
  US09/283,816
• Time in Patent Office: 1,203 Days
• Field of Search: 707/1-2, 707/7, 707/102-104, 707/500, 710/113-130, 710/31-35, 705/1, 705/26, 709/213, 709/231, 709/232, 709/245, 709/248
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

Disclosed is a system for performing online data queries. The system for performing online data queries is a distributed computer system with a plurality of server nodes each fully redundant and capable of processing a user query request. Each server node includes a data query cache and other caches that may be used in performing data queries. The data query, as well as request allocation, is performed in accordance with an adaptive partitioning technique with a bias towards an initial partitioning scheme. Generic objects are created and used to represent business listings upon which the user may perform queries. Various data processing and integration techniques are included which enhance data queries. An update technique is used for synchronizing data updates as needed in updating the plurality of server nodes. A multi-media data transfer technique is used to transfer non-text or multi-media data between various components of the online query tool. Optimizations for searching, such as the common term optimization, are included for those commonly performed data queries. Also disclosed is a system for targeting advertisements that are displayed to a user of the system.

Claims

1. A method executed in a computer system for performing a data transfer comprising:

selecting data to be transferred from a first location to a second location in which the data includes a text portion and a non-text portion;

transferring the text portion using a first data channel from the first location to the second location storing the text portion in a temporary location; and

transferring the non-text portion using a second data channel from the first location to the second location, and

wherein said transferring of the text portion and said transferring of said non-text portion are performed asynchronously, and initially the text and non-text portions are copied to a temporary location, and then merged with other data from another data transfer.

2. A method of performing a data transfer comprising:

selecting an advertising page to be transferred from a first location to a second location, advertising data of said advertising page being represented by a relational mapping table describing the relationship between data entities associated with said advertising data, and a data table including the advertising data represented by said relational mapping table, said relational mapping table including only text data and said data table including text and multi-media data;

transferring the text data of said relational mapping table using a first communication channel to a temporary relational mapping table located at the second location;

transferring the text data of said data table to a temporary table located at the second location;

transferring the multimedia data to a repository at the second location;

said repository being at a location which includes other multimedia data from other data transfer operations associated with other advertising pages;

merging said temporary data table into another data table by copying the text data from said temporary data table to the other table at said second location;

for each entry of said temporary data table, identifying a matching entry in said repository in which a global identifier of said temporary data table matches a corresponding global identifier of said repository; and

copying a repository identifier of said matching entry from said repository to said entry in said other data table;

said repository identifier being a pointer to the multimedia data located in said repository and being a link between an associated entry in said other data table describing said matching entry in said repository.

3. The method of claim 2, wherein said transferring of the text data and said transferring of the multimedia data are performed asynchronously.

4. The method of claim 3, wherein the advertising data transferred from the first to the second location is merged after all portions of the advertising data are at the second location.

5. The method of claim 4, wherein, merging data at said second location includes:

transferring text data from said temporary relational mapping table to a second relational mapping table at said second location, said second relational mapping table including other text data associated with a previous data transfer.

6. The method of claim 2, wherein said merging said temporary data table into another data table, said identifying a matching entry in said repository, and said copying a repository identifier are performed as part of a data merging process after the data transfer has been successfully completed.

7. A computer program product for publishing advertisement data comprising:

a sending component that divides the advertisement data into one or more portions, each of said portions having a corresponding data type, said one or more portions have a relationship that is indicated in a relational mapping table describing the relationship between one or more data entities included in an advertisement page;

first communication means for transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a first data type;

second communication means for transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a second data type; and

a receiving component that includes machine executable code to integrate and assemble said one or more portions of data in accordance with said relational mapping table;

wherein said first communication means is used to transfer text data and said second communication means is used to transfer non-text data.

8. The computer program product of claim 7, wherein said non-text data includes at least one of:

a machine executable program, image data, byte code, graphics data, audio data.

9. A computer program product for publishing advertisement data comprising:

a sending component that divides the advertisement data into one or more portions, each of said portions having a corresponding data type, said one or more portions have a relationship that is indicated in a relational mapping table describing the relationship between one or more data entities included in an advertisement page;

first communication means for transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a first data type;

second communication means for transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a second data type; and

a receiving component that includes machine executable code to integrate and assemble said one or more portions of data in accordance with said relational mapping table;

wherein said sending component and said receiving component are used to transfer data between a first database and a second database.

10. A computer program product for publishing advertisement data comprising:

a sending component that divides the advertisement data into one or more portions, each of said portions having a corresponding data type, said one or more portions have a relationship that is indicated in a relational mapping table describing the relationship between one or more data entities included in an advertisement page;

first communication means for transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a text data type;

second communication means for transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a non-text data type; and

a receiving component that includes machine executable code to integrate and assemble said one or more portions of data in accordance with said relational mapping table;

wherein said first communication means is optimized for structured data transfers and said second communication means is optimized for multimedia data transfers.

11. A computer program product for publishing advertisement data comprising:

a sending component that divides the advertisement data into one or more portions, each of said portions having a corresponding data type, said one or more portions have a relationship that is indicated in a relational mapping table describing the relationship between one or more data entities included, in an advertisement page, said sending component further including machine executable code for assigning transient tags to non-text portions of said advertisement page;

first communication means for transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a first data type;

second communication means for transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a second data type; and

a receiving component that includes machine executable code to integrate and assemble said one or more portions of data in accordance with said relational mapping table and machine executable code for replacing said transient tags with persistent unique tags as part;

wherein said sending component and said receiving component are asynchronous transfer processes.

12. A computer program product for performing a data transfer comprising:

means for selecting data to be transferred from a first location to a second location in which the data includes a text portion and a non-text portion;

means for transferring the text portion using a first data channel from the first location to the second location storing the text portion in a temporary location; and

means for transferring the non-text portion using a second data channel from the first location to the second location, and

wherein said transferring of the text portion and said transferring of the non-text portion are performed asynchronously, and initially the text and non-text portions are copied to a temporary location and then merged with other data from another data transfer means for assembling the text portion and non-text portion at said second location in an advertising page in which said text portion and said non-text portion have a hierarchical relationship in said advertising page.

13. The computer program product of claim 12 wherein said data that is transferred is advertising data that is published.

14. A computer program product for performing a data transfer comprising:

machine executable code for selecting an advertising page to be transferred from a first location to a second location, advertising data of said advertising page being represented as a relational mapping table describing the relationship between data entities associated with said advertising data, and a data table including the advertising data represented by said relational mapping table, said relational mapping table including only text data and said data table including text and multimedia data;

machine executable code for transferring the text data of said relational mapping table using a first communication channel to a temporary relational mapping table located at the second location;

machine executable code for transferring the text data of said data table to a temporary data table located at the second location;

machine executable code for transferring the multimedia data to a repository at the second location, said repository being a location which includes other multimedia data from other data transfer operations associated with other advertising pages;

machine executable code for merging said temporary data table into another data table by copying the text data from said temporary data table to the other data table at said second location;

machine executable code for identifying a matching entry in said repository for each entry of said temporary data table, in which a global identifier of said temporary data table matches a corresponding global identifier of said repository; and

machine executable code for copying a repository identifier of said matching entry from said repository to said entry in said other data table, said repository identifier being a pointer to the multimedia data located in the repository and being a link between an associated entry in said other data table describing said matching entry in said repository.

15. The computer program product of claim 14, wherein the advertising data transferred from the first to the second location is merged after all portions of the advertising data are at the second location.

16. The computer program product of claim 15, further including:

machine executable code for transferring text data from said temporary relational mapping table to a second relational mapping table at said second location, said second relational mapping table including other text data associated with a previous data transfer.

17. A method for publishing advertisement data comprising:

dividing the advertisement data into one or more portions, each of said portions having a corresponding data type, said one or more portions have a relationship that is indicated in a relational mapping table describing the relationship between one or more data entities included in an advertisement page;

transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a first data type using a first communication means;

transferring portions of an advertisement page having corresponding data entities included in the advertisement data of a second data type using a second communication means; and

integrating and assembling said one or more portions of data in accordance with said relational mapping table.

18. The method of claim 17, wherein said first communication means is used to transfer text data and said second communication means is used to transfer non-text data.

19. The method of claim 17, wherein said non-text data includes at least one of:

a machine executable program, image data, byte code, graphics data, audio data.

20. A method for publishing advertisement data comprising:

dividing the advertisement data into one or more portions, each of said portions having a corresponding data type, said one or more portions have a relationship that is indicated in a relational mapping table describing the relationship between one or more data entries included in an advertisement page;

transferring portions of an advertisement page having corresponding data entries included in the advertisement data of a text data type using a first communications means;

transferring portions of an advertisement page having corresponding data entries included in the advertisement data of a non-text data type using a second communications means; and

integrating and assembling one or more portions of data in accordance with said relational mapping table;

wherein said first communication means is optimized for structured data transfers and said second communication means is optimized for multimedia data transfers.