Olga Natkovich - Santa Clara CA, US Jonathan Cao - Sunnyvale CA, US Alan Gates - Danville CA, US
Assignee:
Yahoo! Inc. - Sunnyvale CA
International Classification:
G06F 7/00
US Classification:
707737, 707800
Abstract:
A device, system, and method are directed towards combining a plurality of queries to a database into a combined execution plan. The plurality of queries is received. The queries may be Structured Query Language (SQL) statements. The database may be a relational database. The plurality of queries is transformed into a plurality of parse trees. A determination is made whether the plurality of queries operates on at least the same portion of the same table. If so, then the plurality of query trees is query-optimized. The plurality of query trees are combined into a master query tree based on similar nodes in the plurality of query trees. A split node in the master query tree represents non-similarities between the plurality of query trees. The master query tree is transformed into an execution plan. The execution plan is applied to a database to return at least one result.
MARLEY ENGINEERED PRODUCTS Jan 2006 - Dec 2010
Lean Manufacturing / Business Engineer
SPX Process Equipment Feb 2006 - Jul 2009
Lean Engineer
2006 Jan 1995 - Jan 2006
Senior Process Engineer
Eaton Corporation Jan 1999 - Jan 2003
Senior Supervisor
Education:
UNC @ Pembroke 1999 - 2002
BS, Business Management
Skills:
Kaizen Six Sigma Lean Manufacturing Continuous Improvement 5S
Alan Gates (1944-1948), Tabitha Nelson (1993-1997), Casey Winter (1985-1989), Raymond Coggins (1972-1976), Denise Reed (1979-1983), Kathryn Franklin (1994-1998)