Patents by Inventor Shilpa Lawande
Shilpa Lawande 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: 10474658Abstract: As part of managing the loading of data from a source onto a database, according to an example, an interface through which a user is to define logic related to the loading of the data onto the database is provided. The user-defined logic pertains to at least one of a user-defined location identification of the source, a user-defined filter to be applied on the data, and a user-defined parsing operation to be performed on the data to convert the data into an appropriate format for the database. In addition, the user-defined logic is received and the user-defined logic is implemented to load the data onto the database.Type: GrantFiled: June 4, 2012Date of Patent: November 12, 2019Assignee: MICRO FOCUS LLCInventors: Adam Seering, Rajat Venkatesh, Charles Edward Bear, Shilpa Lawande, Andrew Allinson Lamb
-
Patent number: 10007686Abstract: An automatic physical-layout designer for a database-management system determines the database's physical layout from a set of training queries, the database's logical design, and a parameter k that indicates how many storage nodes can be lost without losing access to any of the data. The designer lays the database out as a column store such that the stored columns constitute redundant projections on the system's different storage nodes. It repeatedly identifies a projection, whose addition to the design will result in the greatest performance improvement for the training queries. In doing so, it takes into account the different compression formats to which the different projections lend themselves. When a projection has been identified as one to be added, it is added on one node, and k projections having the same columns are added to other nodes. The designer continues thus adding projections until a space budget has been reached.Type: GrantFiled: August 2, 2006Date of Patent: June 26, 2018Assignee: ENTIT SOFTWARE LLCInventors: Shilpa Lawande, Alexander Rasin, Omer Trajman, Stanley B. Zdonik
-
Patent number: 8825629Abstract: An access structure analysis method is interspersed with the query optimization process. The method can determine the ideal combination of access structures, including both materialized views and indexes, for a given database workload. The interspersed structure analysis method can include advanced transformations like view merging, star transformation, bitmap access plans, query rewrite using materialized views, for example. The method may be performed using the query optimizer's rules as heuristics to guide the index candidate generation process.Type: GrantFiled: September 7, 2004Date of Patent: September 2, 2014Assignee: Oracle International CorporationInventors: Shilpa Lawande, Mohamed Ziauddin, Gregory Scott Smith
-
Patent number: 8700674Abstract: Methods, systems and program products for database storage. In one implementation, data of a projection of a database is stored at least partly in grouped ROS format and partly in column format based on patterns of updating the projection data. The projection data is updated so that the updated projection is stored partly in grouped ROS format and partly in column format.Type: GrantFiled: July 14, 2009Date of Patent: April 15, 2014Assignee: Hewlett-Packard Development Company, L.P.Inventors: Chuck Bear, Rajat Venkatesh, Benjamin Vandiver, Sreenath Bodagala, Shilpa Lawande
-
Patent number: 8671091Abstract: For a database query that defines a plurality of separate snowflake schemas, a query optimizer computes separately for each of the snowflake schemas a logical access plan for obtaining from that schema's tables a respective record set that includes the data requested from those tables by that query. The query optimizer also computes a logical access plan for obtaining the query's results from the record sets in which execution of the logical access plans thus computed will result.Type: GrantFiled: August 2, 2006Date of Patent: March 11, 2014Assignee: Hewlett-Packard Development Company, L.P.Inventors: Mitch Cherniack, Shilpa Lawande, Nga Tran
-
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
-
Patent number: 8290931Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for a database designer and a database storage designer. In one aspect, a method includes creating a set of candidate projections and progressively narrowing the set of candidate projections and a set of queries by eliminating candidate projections that do not satisfy a performance improvement criterion for remaining queries based on the properties associated with the candidate projections.Type: GrantFiled: June 16, 2010Date of Patent: October 16, 2012Assignee: Hewlett-Packard Development Company, L.P.Inventors: Mingsheng Hong, Priya Arun, Chang-Jian Sun, Shilpa Lawande
-
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: 20110218978Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for operating on time sequences of data. In one aspect, a method includes a database management system storing and updating information in records in a table of a database, the records being associated with respective times that are spaced apart by time intervals, the database management system responding to a query that is phrased to imply a putative record with respect to a time interval that is not among the time intervals with which the records of the table are associated, and the response of the database management system to the query including a computation of a value of an attribute of the putative record from at least one non-null value of the attribute for one of the records of the table, the computation being based on an interpolation policy.Type: ApplicationFiled: June 16, 2010Publication date: September 8, 2011Applicant: Vertica Systems, Inc.Inventors: Mingsheng Hong, Matthew Fuller, Hongmin Fan, Shilpa Lawande
-
Publication number: 20110213766Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for a database designer and a database storage designer. In one aspect, a method includes creating a set of candidate projections and progressively narrowing the set of candidate projections and a set of queries by eliminating candidate projections that do not satisfy a performance improvement criterion for remaining queries based on the properties associated with the candidate projections.Type: ApplicationFiled: June 16, 2010Publication date: September 1, 2011Applicant: Vertica Systems, Inc.Inventors: Mingsheng Hong, Priya Arun, Chang-Jian Sun, Shilpa Lawande
-
Patent number: 7930297Abstract: A technique for refreshing materialized views in a database is disclosed. The detail table is partitioned, and changes made to the detail table are tracked with information stored, for example. Only sections in the materialized view which correspond to the partitions which include modifications made to the detail table are refreshed, thus avoiding the need of a complete refresh to overcome staleness.Type: GrantFiled: December 3, 2004Date of Patent: April 19, 2011Assignee: Oracle International CorporationInventors: Tsae-Feng Yu, John Raitto, Bhujanga Panchapagesan, Shilpa Lawande, Randall G. Bello
-
Publication number: 20110016157Abstract: Methods, systems and program products for database storage. In one implementation, data of a projection of a database is stored at least partly in grouped ROS format and partly in column format based on patterns of updating the projection data. The projection data is updated so that the updated projection is stored partly in grouped ROS format and partly in column format.Type: ApplicationFiled: July 14, 2009Publication date: January 20, 2011Inventors: Chuck Bear, Rajat Venkatesh, Benjamin Vandiver, Sreenath Bodagala, Shilpa Lawande
-
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
-
Publication number: 20080040348Abstract: An automatic physical-layout designer for a database-management system determines the database's physical layout from a set of training queries, the database's logical design, and a parameter k that indicates how many storage nodes can be lost without losing access to any of the data. The designer lays the database out as a column store such that the stored columns constitute redundant projections on the system's different storage nodes. It repeatedly identifies a projection, whose addition to the design will result in the greatest performance improvement for the training queries. In doing so, it takes into account the different compression formats to which the different projections lend themselves. When a projection has been identified as one to be added, it is added on one node, and k projections having the same columns are added to other nodes. The designer continues thus adding projections until a space budget has been reached.Type: ApplicationFiled: August 2, 2006Publication date: February 14, 2008Inventors: Shilpa Lawande, Alexander Rasin, Omer Trajman, Stanley B. Zdonik
-
Publication number: 20080033914Abstract: For a database query that defines a plurality of separate snowflake schemas, a query optimizer computes separately for each of the snowflake schemas a logical access plan for obtaining from that schema's tables a respective record set that includes the data requested from those tables by that query. The query optimizer also computes a logical access plan for obtaining the query's results from the record sets in which execution of the logical access plans thus computed will result.Type: ApplicationFiled: August 2, 2006Publication date: February 7, 2008Inventors: Mitch Cherniack, Shilpa Lawande, Nga Tran
-
Publication number: 20070083483Abstract: Systems, methods, and media associated with function-based index tuning for queries with expressions are described. One exemplary method includes receiving a query for which an index is to be recommended. The query may include an expression, thus the method may include identifying an expression in the query and generating a set of column statistics related to the expression. The method may also include identifying candidate function-based indexes associated with the query, generating a set of function-based index statistics related to the candidate function-based indexes, and recommending a candidate function-based index.Type: ApplicationFiled: November 28, 2005Publication date: April 12, 2007Applicant: ORACLE INTERNATIONAL CORPORATIONInventor: Shilpa Lawande
-
Publication number: 20070083489Abstract: Systems, methods, computer-readable media and other embodiments are provided that relate to processing database queries. In one embodiment, a query analysis logic can be configured to analyze a query to identify multiple instances of the same table. Instance numbering for the multiple table instances can then be performed using the query structure such that equivalent queries will likely get the same instance number assignments to improve materialized view recommendations for queries.Type: ApplicationFiled: March 2, 2006Publication date: April 12, 2007Applicant: Oracle International CorporationInventor: Shilpa Lawande
-
Publication number: 20060122964Abstract: A technique for refreshing materialized views in a database is disclosed. The detail table is partitioned, and changes made to the detail table are tracked with information stored, for example. Only sections in the materialized view which correspond to the partitions which include modifications made to the detail table are refreshed, thus avoiding the need of a complete refresh to overcome staleness.Type: ApplicationFiled: December 3, 2004Publication date: June 8, 2006Inventors: Tsae-Feng Yu, John Raitto, Bhujanga Panchapagesan, Shilpa Lawande, Randall Bello