Patents by Inventor Srinivasan Mottupalli
Srinivasan Mottupalli 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: 9977804Abstract: A method can include receiving a request to execute a database command identifying a target table; identifying a plurality of rows to insert into the target table based in part on the database command; writing rows, from the plurality of rows, into a data page until the data page is full; determining, by an index thread manager, a number of threads to use for updating indexes defined for the target table; and upon determining the data page is full, updating, in parallel, the indexes defined for the target table using the number of threads.Type: GrantFiled: June 1, 2017Date of Patent: May 22, 2018Assignee: SYBASE, INC.Inventors: Srinivasan Mottupalli, Xiaobin Ma, Peter Schneider
-
Publication number: 20170270145Abstract: A method can include receiving a request to execute a database command identifying a target table; identifying a plurality of rows to insert into the target table based in part on the database command; writing rows, from the plurality of rows, into a data page until the data page is full; determining, by an index thread manager, a number of threads to use for updating indexes defined for the target table; and upon determining the data page is full, updating, in parallel, the indexes defined for the target table using the number of threads.Type: ApplicationFiled: June 1, 2017Publication date: September 21, 2017Inventors: Srinivasan Mottupalli, Xiaobin Ma, Peter Schneider
-
Patent number: 9684684Abstract: A method can include receiving a request to execute a database command identifying a target table; identifying a plurality of rows to insert into the target table based in part on the database command; writing rows, from the plurality of rows, into a data page until the data page is full; determining, by an index thread manager, a number of threads to use for updating indexes defined for the target table; and upon determining the data page is full, updating, in parallel, the indexes defined for the target table using the number of threads.Type: GrantFiled: July 8, 2014Date of Patent: June 20, 2017Assignee: SYBASE, INC.Inventors: Srinivasan Mottupalli, Xiaobin Ma, Peter Schneider
-
Patent number: 9665612Abstract: A method can include initiating execution of a database command, the database command associated with a base table with at least one row to copy to a target table, the database command associated with a non-bulk insert mode; making a run-time decision on whether to automatically convert the insert mode from the non-bulk insert mode to a BULK insert mode based on the number of row buffers filled with rows from the base table during execution of the database command; and inserting at least one row into the target table using an insert mode based on the run-time decision.Type: GrantFiled: May 29, 2014Date of Patent: May 30, 2017Assignee: SYBASE, INC.Inventors: Xiaobin Ma, Srinivasan Mottupalli, Peter Schneider
-
Patent number: 9600517Abstract: A method for inserting rows into a target table can include receiving a database command, the database command associated with a base table with at least one row to copy to a target table; receiving an indication that use of a BULK insert mode is feasible for the database command; based on the indication, and determining that an insert mode for the database command has been converted from a non-bulk insert mode to the BULK insert mode: reading a row from the base table; building the row read from the base table into an allocated row buffer; inserting the row into the target table in the BULK insert mode; and if it is determined that the allocated row buffer is full, updating at least one index in parallel with the inserting.Type: GrantFiled: May 29, 2014Date of Patent: March 21, 2017Assignee: SYBASE, INC.Inventors: Xiaobin Ma, Srinivasan Mottupalli, Peter Schneider
-
Publication number: 20160012083Abstract: A method can include receiving a request to execute a database command identifying a target table; identifying a plurality of rows to insert into the target table based in part on the database command; writing rows, from the plurality of rows, into a data page until the data page is full; determining, by an index thread manager, a number of threads to use for updating indexes defined for the target table; and upon determining the data page is full, updating, in parallel, the indexes defined for the target table using the number of threads.Type: ApplicationFiled: July 8, 2014Publication date: January 14, 2016Inventors: Srinivasan Mottupalli, Xiaobin Ma, Peter Schneider
-
Publication number: 20150347470Abstract: A method can include initiating execution of a database command, the database command associated with a base table with at least one row to copy to a target table, the database command associated with a non-bulk insert mode; making a run-time decision on whether to automatically convert the insert mode from the non-bulk insert mode to a BULK insert mode based on the number of row buffers filled with rows from the base table during execution of the database command; and inserting at least one row into the target table using an insert mode based on the run-time decision.Type: ApplicationFiled: May 29, 2014Publication date: December 3, 2015Inventors: Xiaobin Ma, Srinivasan Mottupalli, Peter Schneider
-
Publication number: 20150347409Abstract: A method for inserting rows into a target table can include receiving a database command, the database command associated with a base table with at least one row to copy to a target table; receiving an indication that use of a BULK insert mode is feasible for the database command; based on the indication, and determining that an insert mode for the database command has been converted from a non-bulk insert mode to the BULK insert mode: reading a row from the base table; building the row read from the base table into an allocated row buffer; inserting the row into the target table in the BULK insert mode; and if it is determined that the allocated row buffer is full, updating at least one index in parallel with the inserting.Type: ApplicationFiled: May 29, 2014Publication date: December 3, 2015Inventors: Xiaobin Ma, Srinivasan Mottupalli, Peter Schneider
-
Publication number: 20080098053Abstract: A method and system for accurately estimating a result size of a Group-By operation in a relational database. The estimate utilizes the probability of union of the columns involved in the operation, as well as the relative cardinality of each column with respect to the other columns in the operation. In addition, the estimate incorporates the use of table filters when indicated such that table filters are applied prior to determining the size of the tables in the operation, as well as including equivalent columns into the list of columns that are a part of the Group-By operation. Accordingly, the estimate of the result size of the operation includes influencing factors that provide an accurate estimation of system memory requirements.Type: ApplicationFiled: December 14, 2007Publication date: April 24, 2008Applicant: International Business Machines CorporationInventors: Bingjie Miao, Srinivasan Mottupalli
-
Publication number: 20080016031Abstract: A method and system for accurately estimating a result size of a Group-By operation in a relational database. The estimate utilizes the probability of union of the columns involved in the operation, as well as the relative cardinality of each column with respect to the other columns in the operation. In addition, the estimate incorporates the use of table filters when indicated such that table filters are applied prior to determining the size of the tables in the operation, as well as including equivalent columns into the list of columns that are a part of the Group-By operation. Accordingly, the estimate of the result size of the operation includes influencing factors that provide an accurate estimation of system memory requirements.Type: ApplicationFiled: September 26, 2007Publication date: January 17, 2008Applicant: International Business Machines CorporationInventors: Bingjie Miao, Srinivasan Mottupalli
-
Publication number: 20050234841Abstract: A method and system for accurately estimating a result size of a Group-By operation in a relational database. The estimate utilizes the probability of union of the columns involved in the operation, as well as the relative cardinality of each column with respect to the other columns in the operation. In addition, the estimate incorporates the use of table filters when indicated such that table filters are applied prior to determining the size of the tables in the operation, as well as including equivalent columns into the list of columns that are a part of the Group-By operation. Accordingly, the estimate of the result size of the operation includes influencing factors that provide an accurate estimation of system memory requirements.Type: ApplicationFiled: March 30, 2004Publication date: October 20, 2005Inventors: Bingjie Miao, Srinivasan Mottupalli