Search

Glenn M Yuki

from Los Gatos, CA
Age ~81
Get Report
Also known as:
Glenn N Yuki
Phone and address:
16521 La Croix Ct, Los Gatos, CA 95032
(408) 358-1270
Related to:
John W Hoekman, 58Kyu Lee, 57Tami Weinberger, 47Jack Oler
Connected to:
Erisa A Yuki, 59Joyce M Yuki, 89Michael J Yukich, 37Satoru Yukie, 69Felix Yukilevich, 41Karin L Yukish, 75Louis A Yuknavich, 49Linda A Yuknevich, 74Davin L Yuknis, 56Michael E Yuknis, 39

Glenn Yuki Phones & Addresses

  • 16521 La Croix Ct, Los Gatos, CA 95032 (408) 358-1270 (408) 358-9106
  • Yorba Linda, CA
  • Altadena, CA
  • Pacific Palisades, CA
  • Berkeley, CA

Work

Company: Ibm 1975 to 2010 Position: Software engineer

Education

Degree: Bachelors, Bachelor of Science School / High School: Harvey Mudd College Specialities: Mathematics

Skills

Unix • Enterprise Architecture • Software Development • Java • Requirements Analysis

Industries

Information Technology And Services

Resumes

Resumes

Glenn Yuki Photo 1

Glenn Yuki

View page
Location:
16521 La Croix Ct, Los Gatos, CA 95032
Industry:
Information Technology And Services
Work:
Ibm 1975 - 2010
Software Engineer
Education:
Harvey Mudd College
Bachelors, Bachelor of Science, Mathematics
Skills:
Unix
Enterprise Architecture
Software Development
Java
Requirements Analysis

Publications

Us Patents

Dynamic Selection Of Optimal Grouping Sequence At Runtime For Grouping Sets, Rollup And Cube Operations In Sql Query Processing

View page
US Patent:
20120226693, Sep 6, 2012
Filed:
Apr 11, 2012
Appl. No.:
13/443997
Inventors:
Guogen Zhang - San Jose CA, US
Fen-Ling Lin - San Jose CA, US
Jung-Hsin Hu - Saratoga CA, US
Yao-Ching S. Chen - Saratoga CA, US
Yun Wang - Saratoga CA, US
Glenn M. Yuki - Los Gatos CA, US
Assignee:
INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY
International Classification:
G06F 17/30
US Classification:
707737, 707E17089, 707E17069
Abstract:
A method, apparatus, and article of manufacture for optimizing a query in a computer system. During compilation of the query, a GROUP BY clause with one or more GROUPING SETS, ROLLUP or CUBE operations is maintained in its original form until after query rewrite. The GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations is then translated into a plurality of levels having one or more grouping sets. After compilation of the query, a grouping sets sequence is dynamically determined for the GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations based on intermediate grouping sets, in order to optimize the grouping sets sequence. The execution of the grouping sets sequence is optimized by selecting a smallest grouping set from a previous one of the levels as an input to a grouping set on a next one of the levels. Finally, a UNION ALL operation is performed on the grouping sets.

Dynamic Selection Of Optimal Grouping Sequence At Runtime For Grouping Sets, Rollup And Cube Operations In Sql Query Processing

View page
US Patent:
20050027690, Feb 3, 2005
Filed:
Jul 29, 2003
Appl. No.:
10/629459
Inventors:
Guogen Zhang - San Jose CA, US
Fen-Ling Lin - San Jose CA, US
Jung-Hsin Hu - Saratoga CA, US
Yao-Ching Chen - Saratoga CA, US
Yun Wang - Saratoga CA, US
Glenn Yuki - Los Gatos CA, US
International Classification:
G06F007/00
US Classification:
707003000
Abstract:
A method, apparatus, and article of manufacture for optimizing a query in a computer system. During compilation of the query, a GROUP BY clause with one or more GROUPING SETS, ROLLUP or CUBE operations is maintained in its original form until after query rewrite. The GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations is then translated into a plurality of levels having one or more grouping sets. After compilation of the query, a grouping sets sequence is dynamically determined for the GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations based on intermediate grouping sets, in order to optimize the grouping sets sequence. The execution of the grouping sets sequence is optimized by selecting a smallest grouping set from a previous one of the levels as an input to a grouping set on a next one of the levels. Finally, a UNION ALL operation is performed on the grouping sets.
Control profile
Glenn M Yuki from Los Gatos, CA, age ~81 Get Report