Patents by Inventor Andrew Lamb
Andrew Lamb 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: 11269111Abstract: The disclosure relates to a gravity gradiometer including a pair of magneto-optical traps for measuring a gravity gradient. A cold atom gravity gradiometer system includes comprising: first and second magneto-optical traps, each having a plurality of mirrored surfaces arranged to reflect an incident laser beam to trap respective first and second cold atom clouds separated from each other by a separation distance; an optical subsystem arranged to transmit a first laser beam in a first direction along a first longitudinal axis towards the first magneto-optical trap and a second laser beam in an opposite second direction along a second longitudinal axis towards the second magneto-optical trap, the second longitudinal axis being parallel to the first longitudinal axis.Type: GrantFiled: December 14, 2018Date of Patent: March 8, 2022Assignee: THE UNIVERSITY OF BIRMINGHAMInventors: Andrew Lamb, Geoff De Villiers, Michael Holynski, Kai Bongs
-
Publication number: 20200386906Abstract: The disclosure relates to a gravity gradiometer including a pair of magneto-optical traps for measuring a gravity gradient. A cold atom gravity gradiometer system includes comprising: first and second magneto-optical traps, each having a plurality of mirrored surfaces arranged to reflect an incident laser beam to trap respective first and second cold atom clouds separated from each other by a separation distance; an optical subsystem arranged to transmit a first laser beam in a first direction along a first longitudinal axis towards the first magneto-optical trap and a second laser beam in an opposite second direction along a second longitudinal axis towards the second magneto-optical trap, the second longitudinal axis being parallel to the first longitudinal axis.Type: ApplicationFiled: December 14, 2018Publication date: December 10, 2020Inventors: Andrew Lamb, Geoff De Villiers, Michael Holynski, Kai Bongs
-
Patent number: 10380269Abstract: Methods, systems and program products for query optimization using sideways information passing. In one implementation, a join clause in a query is identified that specifies an outer table of tuples to be joined with an inner table, the outer table having one or more attributes, and each of the attributes of the outer table having values stored in an attribute file that is distinct from attribute files in which the values of other attributes are stored. A plan for the query is created which, when executed, causes selection of a subset of tuples of the outer table to serve as input to the join clause in place of the outer table based on one or more predicates applied to the inner table.Type: GrantFiled: June 7, 2011Date of Patent: August 13, 2019Assignee: ENTIT SOFTWARE LLCInventors: Chuck Bear, Lakshmikant Shrinivas, Andrew Lamb
-
Publication number: 20120317094Abstract: Methods, systems and program products for query optimization using sideways information passing. In one implementation, a join clause in a query is identified that specifies an outer table of tuples to be joined with an inner table, the outer table having one or more attributes, and each of the attributes of the outer table having values stored in an attribute file that is distinct from attribute files in which the values of other attributes are stored. A plan for the query is created which, when executed, causes selection of a subset of tuples of the outer table to serve as input to the join clause in place of the outer table based on one or more predicates applied to the inner table.Type: ApplicationFiled: June 7, 2011Publication date: December 13, 2012Applicant: VERTICA SYSTEMS, INC.Inventors: Chuck Bear, Lakshmikant Shrinivas, Andrew Lamb
-
Patent number: 8312027Abstract: Computer programs encoded on a computer storage medium provide for a modular query optimizer. In one aspect, a computer program product includes selecting one or more projections from a set of projections for each table in a database query wherein each of the selected projections for the table has leads to an estimated lower execution cost for the query as compared to non-selected projections; generating join orders for the query based on data distribution of one or more of the selected projections among sites in a computer network wherein the join orders reflect different combinations of data distribution operations applied to the output of one or more of the query's joins; and selecting a join order from the join orders based on evaluation of the join orders using a cost model.Type: GrantFiled: June 5, 2012Date of Patent: November 13, 2012Assignee: Hewlett-Packard Development Company, L.P.Inventors: Andrew Lamb, Lakshmikant Shrinivas, Shilpa Lawande, Mitch Cherniack, Nga Tran
-
Publication number: 20120246147Abstract: Computer programs encoded on a computer storage medium provide for a modular query optimizer. In one aspect, a computer program product includes selecting one or more projections from a set of projections for each table in a database query wherein each of the selected projections for the table has leads to an estimated lower execution cost for the query as compared to non-selected projections; generating join orders for the query based on data distribution of one or more of the selected projections among sites in a computer network wherein the join orders reflect different combinations of data distribution operations applied to the output of one or more of the query's joins; and selecting a join order from the join orders based on evaluation of the join orders using a cost model.Type: ApplicationFiled: June 5, 2012Publication date: September 27, 2012Inventors: Andrew Lamb, Lakshmikant Shrinivas, Shilpa Lawande, Mitch Cherniack, Nga Tran
-
Patent number: 8214352Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for modular query optimizer. In one aspect, a method includes selecting one or more projections from a set of projections for each table in a database query wherein each of the selected projections for the table has leads to an estimated lower execution cost for the query as compared to non-selected projections; generating join orders for the query based on data distribution of one or more of the selected projections among sites in a computer network wherein the join orders reflect different combinations of data distribution operations applied to the output of one or more of the query's joins; and selecting a join order from the join orders based on evaluation of the join orders using a cost model.Type: GrantFiled: November 24, 2009Date of Patent: July 3, 2012Assignee: Hewlett-Packard Development CompanyInventors: Andrew Lamb, Lakshmikant Shrinivas, Shilpa Lawande, Mitch Cherniack, Nga Tran
-
Patent number: 8086598Abstract: Methods, program products and systems for determining, for a database query that does not represent a snowflake schema, a graph comprising vertices each representing a table joined in the query, a directed edge between each pair of vertices of which a first vertex represents a first table and a second vertex represents a second table that is joined in the query with the first table, each of the edges representing one of an outer join and an inner join. Further determining, for the graph, a directed spanning tree that represents an ordering of joins in the query and includes all outer join edges in the graph.Type: GrantFiled: February 6, 2009Date of Patent: December 27, 2011Assignee: Hewlett-Packard Development Company, L.P.Inventors: Andrew Lamb, Mitch Cherniack, Shilpa Lawande, Nga Tran
-
Publication number: 20100131490Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for modular query optimizer. In one aspect, a method includes selecting one or more projections from a set of projections for each table in a database query wherein each of the selected projections for the table has leads to an estimated lower execution cost for the query as compared to non-selected projections; generating join orders for the query based on data distribution of one or more of the selected projections among sites in a computer network wherein the join orders reflect different combinations of data distribution operations applied to the output of one or more of the query's joins; and selecting a join order from the join orders based on evaluation of the join orders using a cost model.Type: ApplicationFiled: November 24, 2009Publication date: May 27, 2010Inventors: Andrew Lamb, Lakshmikant Shrinivas, Shilpa Lawande, Mitch Cherniack, Nga Tran