Patents by Inventor Florian Michael Waas

Florian Michael Waas 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: 10594779
    Abstract: A system for controlling access to a downstream database management system (DMS) is provided. The system comprises an interface to maintain client connections with a plurality of upstream clients; a pooling component to establish a dynamic pool, and to selectively route each client connection to a pool; within each pool maintaining a queue comprising client database requests associated with particular client connections; and selectively granting access to the client database requests within each queue to at least one downstream DMS.
    Type: Grant
    Filed: August 29, 2016
    Date of Patent: March 17, 2020
    Assignee: DATOMETRY, INC.
    Inventors: Florian Michael Waas, Mohamed Soliman, Zhongxian Gu, Lyublena Rosenova Antova, Tuan Anh Cao, Entong Shen, Michael Alexander Duller
  • Patent number: 10521428
    Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for dynamic partition selection. One of the methods includes receiving a representation of a query plan generated for a query, wherein the query plan includes a dynamic scan operator that represents a first computing node obtaining tuples of one or more partitions of a table from storage and transferring the tuples to a second computing node that executes a parent operator of the dynamic scan operator. A partition selector operator is generated corresponding to the dynamic scan operator. A location in the query plan is determined for the partition selector operator. A modified query plan is generated having the partition selector operator at the determined location.
    Type: Grant
    Filed: April 17, 2017
    Date of Patent: December 31, 2019
    Assignee: Pivotal Software, Inc.
    Inventors: Lyublena Rosenova Antova, Amr El-Helw, Mohamed F. Soliman, Zhongxian Gu, Michail Petropoulos, Florian Michael Waas
  • Patent number: 10509783
    Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for dynamic partition selection. One of the methods includes receiving a representation of a query plan generated for a query, wherein the query plan includes a dynamic scan operator that represents a first computing node obtaining tuples of one or more partitions of a table from storage and transferring the tuples to a second computing node that executes a parent operator of the dynamic scan operator. A partition selector operator is generated corresponding to the dynamic scan operator. A location in the query plan is determined for the partition selector operator. A modified query plan is generated having the partition selector operator at the determined location.
    Type: Grant
    Filed: April 17, 2017
    Date of Patent: December 17, 2019
    Assignee: Pivotal Software, Inc.
    Inventors: Lyublena Rosenova Antova, Amr El-Helw, Mohamed F. Soliman, Zhongxian Gu, Michail Petropoulos, Florian Michael Waas
  • Publication number: 20190303379
    Abstract: A method for providing database management system support to a source application configured to operate with a source database management system Is provided. The method comprises detecting database management system communications issued by the source application to the source database management system and responsive to said database management systems communications, impersonating the source database management system to the source application.
    Type: Application
    Filed: April 8, 2019
    Publication date: October 3, 2019
    Inventors: Florian Michael Waas, Mohamed Soliman, Zhongxian Gu, Lyublena Rosenova Antova, Tuan Anh Cao, Entong Shen, Michael Alexander Duller, John Eshleman
  • Patent number: 10331666
    Abstract: A computer readable storage medium comprises executable instructions to receive a query. A graph is built to represent jobs associated with the query. The jobs are assigned to parallel threads according to the graph.
    Type: Grant
    Filed: October 24, 2017
    Date of Patent: June 25, 2019
    Assignee: Pivotal Software, Inc.
    Inventor: Florian Michael Waas
  • Patent number: 10255336
    Abstract: A method for providing database management system support to a source application configured to operate with a source database management system Is provided. The method comprises detecting database management system communications issued by the source application to the source database management system; and responsive to said database management systems communications, impersonating the source database management system to the source application.
    Type: Grant
    Filed: May 9, 2016
    Date of Patent: April 9, 2019
    Assignee: DATOMETRY, INC.
    Inventors: Florian Michael Waas, Mohamed Soliman, Zhongxian Gu, Lyublena Rosenova Antova, Tuan Anh Cao, Entong Shen, Michael Alexander Duller, John Eshleman
  • Patent number: 10146837
    Abstract: SQL queries are optimized to operate directly on compressed data (and obtain the correct result) rather than requiring that the data be first decompressed prior to processing a query. Certain characteristic pattern trees are mapped against a logical input query plan that includes certain logical operators such as a DECOMPRESS that precedes a JOIN or a GROUPBY in association with a COUNT to identify instances in the plan that match a characteristic pattern. Upon locating a match, the input query plan is transformed into a logically equivalent plan that operates correctly on compressed data, by analyzing the interplay of the semantics of logical query operations with the compressed data and substituting less costly structures and operations. DECOMPRESS operations are moved to operate subsequent to a JOIN or eliminated altogether, and COUNT operations are replaced by a different operation, such as SUM, that is logically equivalent for compressed data.
    Type: Grant
    Filed: May 15, 2017
    Date of Patent: December 4, 2018
    Assignee: Pivotal Software, Inc.
    Inventors: Sivaramakrishnan Narayanan, Florian Michael Waas
  • Patent number: 10140336
    Abstract: Query optimizer accuracy is tested by measuring the actual execution times on a database of each of a plurality of alternative query plans for each of a plurality of queries, first ranking the plans by the actual execution times, then ranking the plans by estimated execution times, and correlating the two rankings by computing a rank correlation metric. The rank correlation metric is normalized so that different optimizers can be objectively compared.
    Type: Grant
    Filed: February 11, 2016
    Date of Patent: November 27, 2018
    Assignee: Pivotal Software, Inc.
    Inventors: Zhongxian Gu, Mohamed F. Soliman, Florian Michael Waas
  • Publication number: 20180329916
    Abstract: A method for providing interoperability between a plurality of database management system. The method comprises a server communicably connected to a plugin-application; receiving, from the source application, a connection request; intercepting communications issued by the source application to a source database management system; and responsive to said intercepted communications, impersonating the source database management system as a target database management system.
    Type: Application
    Filed: June 26, 2018
    Publication date: November 15, 2018
    Inventors: Florian Michael Waas, Mohamed Soliman, Zhongxian Gu, Lyublena Rosenova Antova, Tuan Anh Cao, Entong Shen, Michael Alexander Duller
  • Patent number: 10031944
    Abstract: A method, article of manufacture, and apparatus for processing information are disclosed. In some embodiments, this includes receiving a query plan, identifying a first work file based on the query plan, determining a first work file transaction ID associated with the first work file, determining a data transaction ID, comparing the first work file transaction ID and the data transaction ID, creating a second work file based on the query plan if the data transaction ID is greater than the first work file transaction ID, and storing the second work file in a storage device. In some embodiments, the second work file may be associated with a second work file transaction ID.
    Type: Grant
    Filed: June 30, 2011
    Date of Patent: July 24, 2018
    Assignee: EMC IP Holding Company LLC
    Inventors: Florian Michael Waas, Joy Jie Kent
  • Patent number: 9811558
    Abstract: A computer readable storage medium comprises executable instructions to receive a query. A graph is built to represent jobs associated with the query. The jobs are assigned to parallel threads according to the graph.
    Type: Grant
    Filed: December 17, 2015
    Date of Patent: November 7, 2017
    Assignee: Pivotal Software, Inc.
    Inventor: Florian Michael Waas
  • Patent number: 9652496
    Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for dynamic partition selection. One of the methods includes receiving a representation of a query plan generated for a query, wherein the query plan includes a dynamic scan operator that represents a first computing node obtaining tuples of one or more partitions of a table from storage and transferring the tuples to a second computing node that executes a parent operator of the dynamic scan operator. A partition selector operator is generated corresponding to the dynamic scan operator. A location in the query plan is determined for the partition selector operator. A modified query plan is generated having the partition selector operator at the determined location.
    Type: Grant
    Filed: June 25, 2014
    Date of Patent: May 16, 2017
    Assignee: Pivotal Software, Inc.
    Inventors: Lyublena Rosenova Antova, Amr El-Helw, Mohamed Y. Soliman, Zhongxian Gu, Michail Petropoulos, Florian Michael Waas
  • Patent number: 9652501
    Abstract: SQL queries are optimized to operate directly on compressed data (and obtain the correct result) rather than requiring that the data be first decompressed prior to processing a query. Certain characteristic pattern trees are mapped against a logical input query plan that includes certain logical operators such as a DECOMPRESS that precedes a JOIN or a GROUPBY in association with a COUNT to identify instances in the plan that match a characteristic pattern. Upon locating a match, the input query plan is transformed into a logically equivalent plan that operates correctly on compressed data, by analyzing the interplay of the semantics of logical query operations with the compressed data and substituting less costly structures and operations. DECOMPRESS operations are moved to operate subsequent to a JOIN or eliminated altogether, and COUNT operations are replaced by a different operation, such as SUM, that is logically equivalent for compressed data.
    Type: Grant
    Filed: August 29, 2016
    Date of Patent: May 16, 2017
    Assignee: Pivotal Software, Inc.
    Inventors: Sivaramakrishnan Narayanan, Florian Michael Waas
  • Publication number: 20170063936
    Abstract: A system for controlling access to a downstream database management system (DMS) is provided. The system comprises an interface to maintain client connections with a plurality of upstream clients; a pooling component to establish a dynamic pool, and to selectively route each client connection to a pool; within each pool maintaining a queue comprising client database requests associated with particular client connections; and selectively granting access to the client database requests within each queue to at least one downstream DMS.
    Type: Application
    Filed: August 29, 2016
    Publication date: March 2, 2017
    Inventors: Florian Michael Waas, Mohamed Soliman, Zhongxian Gu, Lyublena Rosenova Antova, Tuan Anh Cao, Entong Shen, Michael Alexander Duller
  • Publication number: 20160328442
    Abstract: A method for providing database management system support to a source application configured to operate with a source database management system Is provided. The method comprises detecting database management system communications issued by the source application to the source database management system and responsive to said database management systems communications, impersonating the source database management system to the source application.
    Type: Application
    Filed: May 9, 2016
    Publication date: November 10, 2016
    Inventors: Florian Michael Waas, Mohamed Soliman, Zhongxian Gu, Lyublena Rosenova Antova, Tuan Anh Cao, Entong Shen, Michael Alexander Duller, John Eshleman
  • Patent number: 9430524
    Abstract: SQL queries are optimized to operate directly on compressed data (and obtain the correct result) rather than requiring that the data be first decompressed prior to processing a query. Certain characteristic pattern trees are mapped against a logical input query plan that includes certain logical operators such as a DECOMPRESS that precedes a JOIN or a GROUPBY in association with a COUNT to identify instances in the plan that match a characteristic pattern. Upon locating a match, the input query plan is transformed into a logically equivalent plan that operates correctly on compressed data, by analyzing the interplay of the semantics of logical query operations with the compressed data and substituting less costly structures and operations. DECOMPRESS operations are moved to operate subsequent to a JOIN or eliminated altogether, and COUNT operations are replaced by a different operation, such as SUM, that is logically equivalent for compressed data.
    Type: Grant
    Filed: October 26, 2015
    Date of Patent: August 30, 2016
    Assignee: Pivotal Software, Inc.
    Inventors: Sivaramakrishnan Narayanan, Florian Michael Waas
  • Patent number: 9418109
    Abstract: A method, article of manufacture, and apparatus for processing queries, comprising analyzing a query tree, determining at least one operator based on the query tree analysis, assigning a memory allocation for each of the at least one operator, and storing the assignment in a storage device. In some embodiments, a memory classification for each of the at least one operator is determined. In some embodiments, assigning a memory allocation for each of the at least one operator includes assigning a memory allocation based on the memory classification.
    Type: Grant
    Filed: March 18, 2011
    Date of Patent: August 16, 2016
    Assignee: EMC Corporation
    Inventors: Sivaramakrishnan Narayanan, Florian Michael Waas, Joy Jie Kent
  • Patent number: 9418064
    Abstract: A method, article of manufacture, and apparatus for processing queries, comprising receiving a query, determining a query classification for the query, assigning the query to a resource queue based on the determined query classification, and placing the query in the assigned resource queue. In some embodiments, the resource queue is divided into a plurality of slots, and the query is placed in a slot. The resource queue may be associated with a resource queue memory allocation, and each of the plurality of slots is associated with a slot memory allocation.
    Type: Grant
    Filed: March 18, 2011
    Date of Patent: August 16, 2016
    Assignee: EMC Corporation
    Inventors: Sivaramakrishnan Narayanan, Florian Michael Waas, Joy Jie Kent
  • Patent number: 9323791
    Abstract: A computer readable storage medium includes executable instructions to evaluate an expanded shared-nothing data store configuration. A data redistribution schedule table with specified parameters is formed. Data is redistributed within the expanded shared-nothing data store in accordance with the data redistribution schedule table.
    Type: Grant
    Filed: June 5, 2014
    Date of Patent: April 26, 2016
    Assignee: Pivotal Software, Inc.
    Inventors: Brian Hagenbuch, Gavin Sherry, Jeffrey Ira Cohen, Chris Pedrotti, John Glenn Eshleman, Florian Michael Waas, Joy Kent
  • Patent number: 9275107
    Abstract: A method of analyzing the performance of a query optimizer includes identifying an event trigger. A reproduction object characterizing operational parameters of the customer computer at the time of the event trigger is populated. The reproduction object is transported from the customer computer to a test computer. The reproduction object is analyzed at the test computer to characterize the performance of a query optimizer.
    Type: Grant
    Filed: August 22, 2014
    Date of Patent: March 1, 2016
    Assignee: Pivotal Software, Inc.
    Inventors: Brian Hagenbuch, Sivaramakrishnan Narayanan, Chad William Whipkey, Florian Michael Waas