Patents by Inventor Hansjorg Zeller
Hansjorg Zeller 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: 10430411Abstract: Incrementally updating statistics includes sampling rows from a database column in a database to generate a first sample, sampling a subset of modified rows from the database column after generating the first sample to generate a second sample, determining whether distribution changes occurred to the database column based on the first and second samples, and updating a database statistic about the database column in response to determining that a distribution change exists.Type: GrantFiled: April 30, 2013Date of Patent: October 1, 2019Assignee: MICRO FOCUS LLCInventors: Choudur Lakshminarayan, Ramakumar Kosuru, QiFan Chen, Hansjorg Zeller
-
Patent number: 9535953Abstract: One example discloses a database management system that can comprise a memory for storing computer executable instructions and a processing unit for accessing the memory and executing the computer executable instructions. The computer executable instructions can comprise a query data collector to access a query repository table to determine if a first query plan for a first configuration executed on a relational database has a lowest resource cost of execution between the first query plan and a second query plan for a second configuration. The query repository table can include a plurality of query records with annotated query plans, each annotated query plan comprising text sufficient to generate a query plan of a certain form.Type: GrantFiled: November 19, 2010Date of Patent: January 3, 2017Assignee: Hewlett Packard Enterprise Development LPInventors: Taoufik B. Abdellatif, Suresh Subbiah, Awny K. Al-Omari, Hansjorg Zeller
-
Patent number: 9465826Abstract: A method of estimating a number of unique entry counts of an attribute in a database comprises, with a processor: identifying a sample of entries from an attribute database, determining frequencies of a number of input observations of the sample of entries, determining a number of high frequency values of the sample of entries, and estimating a number of unique entry counts of an attribute within the attribute database using a counting Bloom filter and based on the frequencies of the input observations and the high frequency values.Type: GrantFiled: November 27, 2012Date of Patent: October 11, 2016Assignee: Hewlett Packard Enterprise Development LPInventors: Choudur Lakshminarayan, Hansjorg Zeller, QiFan Chen, Ramakumar Kosuru
-
Publication number: 20160267293Abstract: Validating a query execution includes determining whether a condition of a query has changed and recompiling the query if the condition has changed.Type: ApplicationFiled: October 29, 2013Publication date: September 15, 2016Applicant: Hewlett Packard Enterprise Development LPInventors: Suresh Subbiah, Roberta S. Marton, Hansjorg Zeller, Barry Lynn Fritchman, Gayle M. Schultz, James A. Capps, Michael J. Hanlon
-
Publication number: 20160110417Abstract: Incrementally updating statistics includes sampling rows from a database column in a database to generate a first sample, sampling a subset of modified rows from the database column after generating the first sample to generate a second sample, determining whether distribution changes occurred to the database column based on the first and second samples, and updating a database statistic about the database column in response to determining that a distribution change exists.Type: ApplicationFiled: April 30, 2013Publication date: April 21, 2016Inventors: Choudur Lakshminarayan, Ramakumar Kosuru, QiFan Chen, Hansjorg Zeller
-
Patent number: 9165032Abstract: An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed.Type: GrantFiled: November 21, 2007Date of Patent: October 20, 2015Assignee: Hewlett-Packard Development Company, L.P.Inventors: Robert M Wehrmeister, Awny K Al-Omari, Subbarao Kakarlamudi, Zbigniew Omanski, Kashif A Siddiqui, Hansjorg Zeller, Peter Friedenbach
-
Patent number: 8898142Abstract: Embodiments of the present invention are directed to query-optimization methods and systems that employ risk premiums assigned to database operations in order to increase the robustness and reliability of the evaluation and selection of query-execution plans for executing high-level database queries. Using risk-premium estimates, selection of query-execution plans that include potentially inefficient database operations and inefficient database-operation-execution sequences, often selected by currently available query-optimization methods and systems, are avoided.Type: GrantFiled: January 29, 2009Date of Patent: November 25, 2014Assignee: Hewlett-Packard Development Company, L.P.Inventors: Awny K. Al-Omari, Hansjorg Zeller, Tom C. Reyes
-
Publication number: 20140149433Abstract: A method of estimating a number of unique entry counts of an attribute in a database comprises, with a processor: identifying a sample of entries from an attribute database, determining frequencies of a number of input observations of the sample of entries, determining a number of high frequency values of the sample of entries, and estimating a number of unique entry counts of an attribute within the attribute database using a counting Bloom filter and based on the frequencies of the input observations and the high frequency values.Type: ApplicationFiled: November 27, 2012Publication date: May 29, 2014Applicant: HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P.Inventors: Choudur Lakshminarayan, Hansjorg Zeller, QiFan Chen, Ramakumar Kosuru
-
Patent number: 8666966Abstract: A system and method for providing parallel result streams for database queries is provided. The system includes a network including a client, a server, and a database. The client executes an application and sends a query to the server. In response, the server compiles the query to produce a query plan, executes statements in the query plan and sends parallel result streams to the client.Type: GrantFiled: January 30, 2009Date of Patent: March 4, 2014Assignee: Hewlett-Packard Development Company, L.P.Inventors: Venkatesan N. Ranganathan, Andrew D. Therber, Anoop Sharma, Hansjorg Zeller
-
Patent number: 8554760Abstract: There is provided a computer-implemented method of optimizing a query. An exemplary method comprises receiving a first query configured to generate a result set. The query may comprise an operation for an outer table, a first predicate, and a second predicate. The second predicate may comprise a subquery correlated to the operation. Additionally, the first predicate and the second predicate may be disjunctive. The exemplary method also comprises generating a first query tree representing the first query, and generating a second query tree representing a second query. The second query may be configured to generate the result set, and may not comprise the subquery. The exemplary method additionally comprises generating a query plan based on the second query tree.Type: GrantFiled: October 7, 2009Date of Patent: October 8, 2013Assignee: Hewlett-Packard Development Company, L.P.Inventors: Suresh Subbiah, Lars Fredriksen, Murali Mallela Krishna, Hansjorg Zeller
-
Patent number: 8380699Abstract: There is provided a computer-implemented method of optimizing a query. An exemplary method comprises determining a maximum cardinality for an operator. The query may comprise the operator. The exemplary method also comprises determining a plurality of potential implementations for the operator. The exemplary method additionally comprises generating a query plan for the query based on the maximum cardinality and the potential implementations.Type: GrantFiled: September 4, 2009Date of Patent: February 19, 2013Assignee: Hewlett-Packard Development Company, L.P.Inventors: Awny K. Al-Omari, Hansjorg Zeller, Tom C. Reyes
-
Publication number: 20120130986Abstract: One example discloses a database management system that can comprise a memory for storing computer executable instructions and a processing unit for accessing the memory and executing the computer executable instructions. The computer executable instructions can comprise a query data collector to access a query repository table to determine if a first query plan for a first configuration executed on a relational database has a lowest resource cost of execution between the first query plan and a second query plan for a second configuration. The query repository table can include a plurality of query records with annotated query plans, each annotated query plan comprising text sufficient to generate a query plan of a certain form.Type: ApplicationFiled: November 19, 2010Publication date: May 24, 2012Inventors: Taoufik B. Abdellatif, Suresh Subbiah, Awny K. Al-Omari, Hansjorg Zeller
-
Publication number: 20110082856Abstract: There is provided a computer-implemented method of optimizing a query. An exemplary method comprises receiving a first query configured to generate a result set. The query may comprise an operation for an outer table, a first predicate, and a second predicate. The second predicate may comprise a subquery correlated to the operation. Additionally, the first predicate and the second predicate may be disjunctive. The exemplary method also comprises generating a first query tree representing the first query, and generating a second query tree representing a second query. The second query may be configured to generate the result set, and may not comprise the subquery. The exemplary method additionally comprises generating a query plan based on the second query tree.Type: ApplicationFiled: October 7, 2009Publication date: April 7, 2011Inventors: Suresh Subbiah, Lars Fredriksen, Murali Mallela Krishna, Hansjorg Zeller
-
Publication number: 20110060731Abstract: There is provided a computer-implemented method of optimizing a query. An exemplary method comprises determining a maximum cardinality for an operator. The query may comprise the operator. The exemplary method also comprises determining a plurality of potential implementations for the operator. The exemplary method additionally comprises generating a query plan for the query based on the maximum cardinality and the potential implementations.Type: ApplicationFiled: September 4, 2009Publication date: March 10, 2011Inventors: Awny K. Al-Omari, Hansjorg Zeller, Tom C. Reyes
-
Patent number: 7818297Abstract: The disclosed embodiments relate to a system for refreshing a table to produce a refreshed table. The system may include a refresh log that may contain a plurality of entries that each comprise an epoch identifier. The system may also include a refresh manager that may be adapted to perform a refresh operation on the table using entries that have corresponding epoch identifiers.Type: GrantFiled: March 31, 2003Date of Patent: October 19, 2010Assignee: Hewlett-Packard Development Company, L.P.Inventors: Nitzan Peleg, Yuval Sherman, Hansjorg Zeller
-
Publication number: 20100198855Abstract: A system and method for providing parallel result streams for database queries is provided. The system includes a network including a client, a server, and a database. The client executes an application and sends a query to the server. In response, the server compiles the query to produce a query plan, executes statements in the query plan and sends parallel result streams to the client.Type: ApplicationFiled: January 30, 2009Publication date: August 5, 2010Inventors: VENKATESAN N. RANGANATHAN, Andrew D. Therber, Anoop Sharma, Hansjorg Zeller
-
Publication number: 20100191720Abstract: Embodiments of the present invention are directed to query-optimization methods and systems that employ risk premiums assigned to database operations in order to increase the robustness and reliability of the evaluation and selection of query-execution plans for executing high-level database queries. Using risk-premium estimates, selection of query-execution plans that include potentially inefficient database operations and inefficient database-operation-execution sequences, often selected by currently available query-optimization methods and systems, are avoided.Type: ApplicationFiled: January 29, 2009Publication date: July 29, 2010Inventors: Awny K. Al-Omari, Hansjorg Zeller, Tom C. Reyes
-
Patent number: 7765531Abstract: Systems and methods to indicate whether to store a database query language module in a local directory or a global directory are disclosed. An application program can be created once, tested once, and deployed in separate environments. The database query language modules can be shared among a group of application programs running in a common environment. Separate query language modules can be maintained for each environment.Type: GrantFiled: October 6, 2004Date of Patent: July 27, 2010Assignee: Hewlett-Packard Development Company, L.P.Inventors: Gary Martin Gilbert, Hansjorg Zeller, Robert Matthew Wehrmeister, Thomas Canivel Reyes, Anoop Sharma, David Wayne Birdsall, Michael James Hanlon
-
Patent number: 7680771Abstract: An apparatus, system, and method are disclosed for provisioning database resource within a grid database system. The apparatus comprises an analysis module and a provision module. The analysis module analyzes a data query stream from an application to a database instance and determines that the data query stream exhibits a predetermined performance attribute. The provision module provisions a database resource in response to a determination that the data query stream exhibits the predetermined performance attribute. The provisioned database resource may be a database instance, a database server, or a cache. The provisioning of the new database resource advantageously is substantially transparent to a client on the database system.Type: GrantFiled: December 20, 2004Date of Patent: March 16, 2010Assignee: International Business Machines CorporationInventors: Enzo Cialini, Laura Myers Haas, Balakrishna Raghavendra Iyer, Allen William Luniewski, Jayashree Subrahmonia, Noshir Cavas Wadia, Hansjorg Zeller
-
Publication number: 20090132488Abstract: An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed.Type: ApplicationFiled: November 21, 2007Publication date: May 21, 2009Inventors: Robert M. Wehrmeister, Awny K. Al-Omari, Subbarao Kakarlamudi, Zbigniew Omanski, Kashif A. Siddiqui, Hansjorg Zeller, Peter Friedenbach