Patents by Inventor Josep Aguilar-Saborit

Josep Aguilar-Saborit has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • System and program for joining source table rows with target table rows
    Patent number: 10120901
    Abstract: A data processing system, and an article of manufacturing, join rows associated with a source table column with rows associated with a target table column. A source node and a target node contain the source and target tables, respectively. A reduced representation of selected rows associated with the source table column is generated, as is a representation of the target table column. A filtering module filters the generated reduced representation of selected rows associated with the source table column through the generated representation of the target table column, the filtered generated reduced representation of selected rows identifying source table rows that do not have to be joined with the target table. The rows associated with the source table column minus the filtered generated reduced representation of selected rows are joined to the rows associated with the target table column.
    Type: Grant
    Filed: March 18, 2013
    Date of Patent: November 6, 2018
    Assignee: International Business Machines Corporation
    Inventors: Josep L. Larriba-Pey, Victor Muntes-Mulero, Hebert W. Pereyra, Josep Aguilar Saborit, Calisto P. Zuzarte
  • System and program for joining source table rows with target table rows
    Patent number: 8655877
    Abstract: Disclosed is a data processing system, and an article of manufacturing for use with the data processing system. The data processing system joins rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table.
    Type: Grant
    Filed: September 17, 2008
    Date of Patent: February 18, 2014
    Assignee: International Business Machines Corporation
    Inventors: Josep L. Lariba-Pey, Victor Muntes-Mulero, Herbert W. Pereyra, Josep Aguilar-Saborit, Calisto P. Zuzarte
  • System and method for multiple distinct aggregate queries
    Patent number: 8005868
    Abstract: There is disclosed a system and method for executing multiple distinct aggregate queries. In an embodiment, the method comprises: providing at least one Counting Bloom Filter for each distinct column of an input data stream; reviewing count values in the at least one Counting Bloom Filter for the existence of duplicates in each distinct column; and if necessary, using a distinct hash operator to remove duplicates from each distinct column of the input data stream, thereby removing the need for replicating the input data stream and minimizing distinct hash operator processing. Also, the use of Counting Bloom Filters for monitoring data streams allow an early duplicate removal of the input stream of data, resulting in savings in computation time and memory resources.
    Type: Grant
    Filed: March 7, 2008
    Date of Patent: August 23, 2011
    Assignee: International Business Machines Corporation
    Inventors: Josep Aguilar Saborit, Miroslaw Adam Flasza, Mokhtar Kandil, Serge Philippe Rielau, David C. Sharpe, Calisto Paul Zuzarte
  • SYSTEM AND METHOD FOR MULTIPLE DISTINCT AGGREGATE QUERIES
    Publication number: 20090228433
    Abstract: There is disclosed a system and method for executing multiple distinct aggregate queries. In an embodiment, the method comprises: providing at least one Counting Bloom Filter for each distinct column of an input data stream; reviewing count values in the at least one Counting Bloom Filter for the existence of duplicates in each distinct column; and if necessary, using a distinct hash operator to remove duplicates from each distinct column of the input data stream, thereby removing the need for replicating the input data stream and minimizing distinct hash operator processing. Also, the use of Counting Bloom Filters for monitoring data streams allow an early duplicate removal of the input stream of data, resulting in savings in computation time and memory resources.
    Type: Application
    Filed: March 7, 2008
    Publication date: September 10, 2009
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Josep AGUILAR SABORIT, Miroslaw Adam Flasza, Mokhtar Kandil, Serge Philippe Rielau, David C. Sharpe, Calisto Paul Zuzarte
  • Method, system and program for joining source table rows with target table rows
    Patent number: 7512625
    Abstract: Disclosed is a data processing system implemented method, a data processing system, and an article of manufacturing for use with the data processing system. The data processing system implemented method is used for directing the data processing system to join rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table.
    Type: Grant
    Filed: April 1, 2005
    Date of Patent: March 31, 2009
    Assignee: International Business Machines Corporation
    Inventors: Josep L. Lariba-Pey, Victor Muntés-Mulero, Hebert W. Pereyra, Josep Aguilar-Saborit, Calisto P. Zuzarte
  • SYSTEM AND PROGRAM FOR JOINING SOURCE TABLE ROWS WITH TARGET TABLE ROWS
    Publication number: 20090012990
    Abstract: Disclosed is a data processing system, and an article of manufacturing for use with the data processing system. The data processing system joins rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table.
    Type: Application
    Filed: September 17, 2008
    Publication date: January 8, 2009
    Applicant: International Business Machines Corporation
    Inventors: Josep L. Lariba-Pey, Victor Muntes-Mulero, Herbert W. Pereyra, Josep Aguilar-Saborit, Calisto P. Zuzarte
  • Method, system and program for joining source table rows with target table rows
    Publication number: 20060224551
    Abstract: Disclosed is a data processing system implemented method, a data processing system, and an article of manufacturing for use with the data processing system. The data processing system implemented method is used for directing the data processing system to join rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table.
    Type: Application
    Filed: April 1, 2005
    Publication date: October 5, 2006
    Inventors: Josep Lariba-Pey, Victor Muntes-Mulero, Hebert Pereyra, Josep Aguilar-Saborit, Calisto Zuzarte