Patents by Inventor Theresa Hsing Lai
Theresa Hsing Lai 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).
-
Patent number: 6931389Abstract: An apparatus for filtering a plurality of groups of query statements according to identification data associated therewith includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include at least one filtering module configured to receive one or more user-specified filtering criteria directed to a subset of the identification data and apply the filtering criteria to selectively exclude those of the plurality of groups not satisfying the filtering criteria. The modules also include a group listing module configured to display to a user those of the plurality of groups not excluded by the at least one filtering module.Type: GrantFiled: January 13, 2000Date of Patent: August 16, 2005Assignee: International Business Machines CorporationInventors: Terry Michael Bleizeffer, Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Jr., Theresa Hsing Lai, Joseph Davis Lea, III, David Harold Oberstadt
-
Patent number: 6768987Abstract: An apparatus for filtering an explain table according to at least one user-defined filter includes a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include a filter generation module configured to receive user-specified filtering criteria directed to data within a selected column of the explain table and generate in response a user-defined filter. The modules also include a table filtering module configured to apply the user-defined filter to the explain table to selectively exclude rows of the explain table not satisfying the filtering criteria of the user-defined filter.Type: GrantFiled: January 13, 2000Date of Patent: July 27, 2004Assignee: International Business Machines CorporationInventors: Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Jr., Theresa Hsing Lai, Joseph Davis Lea, III, David Harold Oberstadt
-
Patent number: 6631381Abstract: An apparatus for integrally referencing a user-generated copy of a catalog in a database system includes a memory device having thereon modules of code for execution by a processor. The modules include a database system component module configured to refer to a catalog generated by the database system; and a catalog qualifier designation module communicating with the database system component module and configured to receive a user designation of a user-specified name for a user-generated copy of the catalog generated by the database system to be referenced in place of the catalog generated by the database system.Type: GrantFiled: January 13, 2000Date of Patent: October 7, 2003Assignee: International Business Machines CorporationInventors: Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Jr., Theresa Hsing Lai, Joseph Davis Lea, III, David Harold Oberstadt
-
Patent number: 6604096Abstract: An apparatus for dynamically generating query explain data includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include a query explain program operating on a workstation. The query explain program communicates over a network with a server hosting a database system and is configured to temporarily store the query explain data received across the network from the database system in a data cache. The query explain program may be configured to automatically clear a selected portion of the data cache when the data cache reaches a user-selectable size. The user is thus allowed to determine when to clear the data cache and how much of the data cache to clear.Type: GrantFiled: January 13, 2000Date of Patent: August 5, 2003Assignee: International Business Machines CorporationInventors: Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Jr., Theresa Hsing Lai, Joseph Davis Lea, III, David Harold Oberstadt
-
Patent number: 6539371Abstract: An apparatus for filtering a set of query statements according to query explain data associated therewith includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution by the processor. The modules include a filter generation module configured to receive user-specified filtering criteria directed to a subset of the query explain data for at least one query statement and generate in response at least one user-defined filter. The modules also include a statement filtering module configured to apply the user-defined filter to the set of query statements to selectively exclude query statements not satisfying the filtering criteria of the at least one filter.Type: GrantFiled: January 13, 2000Date of Patent: March 25, 2003Assignee: International Business Machines CorporationInventors: Terry Michael Bleizeffer, Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Jr., Theresa Hsing Lai, Joseph Davis Lea, III, David Harold Oberstadt
-
Patent number: 6493700Abstract: A system and method for specifying custom qualifiers for explain tables allows a user to designate selected explain tables for which the user wishes to view statements. A query explain program is provided and configured with an explain table qualifier designation module for receiving a user designation of a query explain table to reference. The user selects a function of the query explain program to perform and then designates the qualifier of the query explain table to be referenced. The function is then performed in conjunction with the contents of the selected query explain table.Type: GrantFiled: March 31, 2000Date of Patent: December 10, 2002Assignee: International Business Machines CorporationInventors: Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Jr., Theresa Hsing Lai, Joseph Davis Lea, III, David Harold Oberstadt
-
Patent number: 6397207Abstract: A method for selectively preparing customized reports of query explain data comprises selectively retrieving from the database subsets of the query explain data for the at least one query statement; formatting the subsets for display to a user; displaying within a report customization window one or more controls for selectively designating subsets of the query explain data for the at least one query statement to be included in the report; and in response to selection of the one or more controls, generating a report that includes the designated subsets of the query explain data for the at least one query statement.Type: GrantFiled: November 2, 2000Date of Patent: May 28, 2002Assignee: International Business Machines Corp.Inventors: Terry Michael Bleizeffer, Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Jr., Theresa Hsing Lai, Joseph Davis Lea, III, David Harold Oberstadt
-
Publication number: 20020049700Abstract: A system and method for specifying custom qualifiers for explain tables allows a user to designate selected explain tables for which the user wishes to view statements. A query explain program is provided and configured with an explain table qualifier designation module for receiving a user designation of a query explain table to reference. The user selects a function of the query explain program to perform and then designates the qualifier of the query explain table to be referenced. The function is then performed in conjunction with the contents of the selected query explain table.Type: ApplicationFiled: March 31, 2000Publication date: April 25, 2002Inventors: Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Theresa Hsing Lai, Joseph Davis Lea III, David Harold Oberstadt
-
Patent number: 6195653Abstract: A method for selectively preparing customized reports of query explain data comprises selectively retrieving from the database subsets of the query explain data for the at least one query statement; formatting the subsets for display to a user; displaying within a report customization window one or more controls for selectively designating subsets of the query explain data for the at least one query statement to be included in the report; and in response to selection of the one or more controls, generating a report that includes the designated subsets of the query explain data for the at least one query statement.Type: GrantFiled: January 13, 2000Date of Patent: February 27, 2001Assignee: International Business Machines CorporationInventors: Terry Michael Bleizeffer, Tanya Couch, Catherine Elizabeth Wuebker Drummond, Virginia Walbridge Hughes, Jr., Theresa Hsing Lai, Joseph Davis Lea, III, David Harold Oberstadt
-
Patent number: 6128622Abstract: A method, apparatus, and article of manufacture for generating program specifications for a computer program that accesses datastore persistent objects materialized from a datastore. A "wizard" or "task guide" is displayed on a monitor attached to a computer, wherein the wizard comprises a step-by-step procedure for creating the program specifications. Operator input is accepted into the computer in response to the step-by-step procedure and the program specifications are created using the operator input.Type: GrantFiled: March 13, 1998Date of Patent: October 3, 2000Assignee: International Business Machines CorporationInventors: Mark Alan Bach, In Ha Chung, John Kevin Flanigan, Candace Antonina Garcia, Judith Eleanor Hill, Steve T. Kuo, Theresa Hsing Lai, Kevin Michael McBride, H. Moncrief Rowe-Anderson