Search

Joaquim Anthony Zuzarte

from San Jose, CA
Age ~59

Joaquim Zuzarte Phones & Addresses

  • 4955 Sandy Ln, San Jose, CA 95124 (408) 540-7322
  • 510 Walker Dr, Mountain View, CA 94043 (650) 940-1265
  • 34424 Torrey Pine Ln, Union City, CA 94587 (510) 324-4758
  • Auburn, NY
  • 38725 Lexington St, Fremont, CA 94536 (510) 713-1740
  • Sunnyvale, CA
  • Alameda, CA
  • Los Gatos, CA
  • 4955 Sandy Ln, San Jose, CA 95124

Work

Company: Ibm Jan 2002 Position: Software engineer

Education

Degree: High school graduate or higher

Skills

Unix • Solaris • Databases • Informix • Unix Shell Scripting • Shell Scripting • Db2 • Postgresql • Database Design • Software Development • Aix • Java Enterprise Edition • Perl • Operating Systems • Informatica • Nosql • High Availability • Soa • Data Analysis • Linux • Query Analyzer • Query Writing • Query Optimization • C++ Language • Ibm Aix

Languages

English

Industries

Information Technology And Services

Resumes

Resumes

Joaquim Zuzarte Photo 1

System Software Developer

View page
Location:
4955 Sandy Ln, San Jose, CA 95124
Industry:
Information Technology And Services
Work:
IBM since Jan 2002
Software Engineer
Skills:
Unix
Solaris
Databases
Informix
Unix Shell Scripting
Shell Scripting
Db2
Postgresql
Database Design
Software Development
Aix
Java Enterprise Edition
Perl
Operating Systems
Informatica
Nosql
High Availability
Soa
Data Analysis
Linux
Query Analyzer
Query Writing
Query Optimization
C++ Language
Ibm Aix
Languages:
English

Publications

Us Patents

Efficient Query Processing On Ordered Views

View page
US Patent:
20130238637, Sep 12, 2013
Filed:
Mar 6, 2012
Appl. No.:
13/413535
Inventors:
Ajaykumar B. Gupte - San Jose CA, US
Raghupathi K. Murthy - Union City CA, US
Joaquim A. Zuzarte - Mountain View CA, US
Assignee:
INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY
International Classification:
G06F 17/30
US Classification:
707752, 707E17033
Abstract:
The efficient query processing on ordered views includes: obtaining a view definition for a view for database data; obtaining a query to be executed on the database data; identifying any columns in the view that are unnecessary for the query; after processing any predicates of the query, identifying any sorts in the view definition that are unnecessary or redundant in the query; rewriting the query to eliminate the unnecessary columns and unnecessary and redundant sorts; and executing the rewritten query without materializing the view. Thus, the query is rewritten in a way that avoids materializing the view and eliminates duplicate or unnecessary sorts. This reduces the number of rows to be sorted and eliminates unnecessary columns from materialization. These reductions lead to resource savings, including memory, temporary table space required for sorting, and CPU resources.

Off-Loading I/O And Computationally Intensive Operations To Secondary Systems

View page
US Patent:
20070185912, Aug 9, 2007
Filed:
Feb 8, 2006
Appl. No.:
11/350522
Inventors:
Ajay Gupta - Fremont CA, US
Raghupathi Murthy - Union City CA, US
Joaquim Zuzarte - Mountain View CA, US
Assignee:
International Business Machines Corporation - Armonk NY
International Classification:
G06F 17/30
US Classification:
707200000
Abstract:
Various embodiments of a computer-implemented method, database environment and computer program product are provided which off-load the processing of a database operation. A first database is accessible to a first database server, and a second database is accessible to a second database server. Data is replicated from the first database to the second database, wherein the second database is substantially a copy of the first database. The first database server determines whether to off-load a database operation which would access the first database to the second database server. In response to determining to off-load the database operation, a command is sent to the second database server to perform the database operation. In response to receiving the command, the second database server accesses the second database to perform the database operation. A result of the database operation is received from the second database server.
Joaquim Anthony Zuzarte from San Jose, CA, age ~59 Get Report