| 10262025 |
Managing a temporal key property in a database management system |
Balakrishna Raghavendra Iyer, Robert W. Lyle |
2019-04-16 |
| 9910869 |
Dropping columns from a table with minimized unavailability |
Craig A. Friske, Charles H. Lin, Regina J. Liu, Kalpana Shyam, Cherri M. Vidmar +3 more |
2018-03-06 |
| 9317543 |
Dropping columns from a table with minimized unavailability |
Craig A. Friske, Charles H. Lin, Regina J. Liu, Kalpana Shyam, Cherri M. Vidmar +3 more |
2016-04-19 |
| 9104713 |
Managing a temporal key property in a database management system |
Balakrishna Raghavendra Iyer, Robert W. Lyle |
2015-08-11 |
| 8572125 |
Scalable storage schemes for native XML column data of relational tables |
Yao-Ching Chen, Fen-Ling Lin, Kalpana Shyam, James Zu-Chia Teng, Guogen Zhang |
2013-10-29 |
| 7840552 |
Cost-based subquery correlation and decorrelation |
Thomas A. Beavin, Mengchu Cai, Yao-Ching Chen, Hsiuying Cheng, Fen-Ling Lin +5 more |
2010-11-23 |
| 7376646 |
Cost-based subquery correlation and decorrelation |
Thomas A. Beavin, Mengchu Cai, Yao-Ching Chen, Hsiuying Cheng, Fen-Ling Lin +5 more |
2008-05-20 |
| 7181446 |
Query transformation for queries involving correlated subqueries having correlation join predicates with local filtering predicates involving predicate transitive closure and predicate pull-out |
Patrick D. Bossman, Lee-Chin Hsu Liu, Yumi Tsuji |
2007-02-20 |
| 6571233 |
Optimization of SQL queries using filtering predicates |
Thomas A. Beavin, Patrick M. Malone, Randy Mitchell Nakagawa |
2003-05-27 |
| 6421663 |
Optimization of joined table expressions by extended access path selection |
Yao-Ching Chen, Fen-Ling Lin, Hong Sang Tie, Yun Wang |
2002-07-16 |
| 6385603 |
Joined table expression optimization by query transformation |
Yao-Ching Chen, Fen-Ling Lin, Hong Sang Tie, Yun Wang |
2002-05-07 |
| 6374235 |
Method, system, and program for a join operation on a multi-column table and satellite tables including duplicate values |
Stephen Yao Ching Chen, Patrick M. Malone, Jeffrey Ralph Ruggles, Desai Paramesh Sampatrai, Yun Wang +1 more |
2002-04-16 |
| 6219660 |
Access path selection for SQL with variables in a RDBMS |
Donald J. Haderle, Randy Mitchell Nakagawa, Hong Sang Tie |
2001-04-17 |
| 6006220 |
Determining the optimal access path for a query at execution time using an actual value for each variable in a query for estimating a filter factor |
Donald J. Haderle, Randy Mitchell Nakagawa, Hong Sang Tie |
1999-12-21 |
| 5978792 |
Method and apparatus for generating dynamic and hybrid sparse indices for workfiles used in SQL queries |
Gautam Bhargava, Paramesh S. Desai, Piyush Goel, Peter Hoa, Fen-Ling Lin +3 more |
1999-11-02 |
| 5758145 |
Method and apparatus for generating dynamic and hybrid sparse indices for workfiles used in SQL queries |
Gautam Bhargava, Paramesh S. Desai, Piyush Goel, Peter Hoa, Fen-Ling Lin +3 more |
1998-05-26 |
