Patents by Inventor Harmeek Singh Bedi
Harmeek Singh Bedi 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: 9946779Abstract: A method for performing multiple merge operations with a source data structure and a plurality of destination data structures, in which the source data structure is scanned one time in order to obtain source data that is then used for multiple merge operations. The source data is then used consecutively in order to merge the source data into the one or more destination data structures. Each merge is performed using the same scan of the source data structure and within the same execution of a database command.Type: GrantFiled: May 28, 2003Date of Patent: April 17, 2018Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Richard Yu Gu, Harmeek Singh Bedi, Ashish Thusoo
-
Patent number: 8620888Abstract: Techniques are described herein for partitioning a database table using a virtual column as the partitioning key. A virtual column is defined by the database to contain results of a defining expression. Partitioning can be performed using a variety of partitioning schemes, such as range partitioning and hash partitioning. The partitions are automatically updated to reflect changes to the values in the base columns upon which the virtual column depends. Partition pruning and parallel-wise partition joins can be performed on database tables which have been partitioned on virtual columns.Type: GrantFiled: December 6, 2007Date of Patent: December 31, 2013Assignee: Oracle International CorporationInventors: Subhransu Basu, Harmeek Singh Bedi, Ananth Raghavan
-
Publication number: 20120036111Abstract: Techniques are described herein for performing column functions on virtual columns in database tables. A virtual column is defined by the database to contain results of a defining expression. Statistics are collected and maintained for virtual columns. Indexing is performed on virtual columns. Referential integrity is maintained between two tables using virtual columns as keys. Join predicate push-down operations are also performed using virtual columns.Type: ApplicationFiled: October 20, 2011Publication date: February 9, 2012Inventors: Subhransu Basu, Harmeek Singh Bedi
-
Patent number: 8078652Abstract: Techniques are described herein for performing column functions on virtual columns in database tables. A virtual column is defined by the database to contain results of a defining expression. Statistics are collected and maintained for virtual columns. Indexing is performed on virtual columns. Referential integrity is maintained between two tables using virtual columns as keys. Join predicate push-down operations are also performed using virtual columns.Type: GrantFiled: December 6, 2007Date of Patent: December 13, 2011Assignee: Oracle International CorporationInventors: Subhransu Basu, Harmeek Singh Bedi
-
Patent number: 8046352Abstract: Techniques are described herein for replacing a part of an expression in a query to a database with a virtual column. A virtual column is defined by the database to contain results of a defining expression. A part of an expression in a query is replaced with a virtual column whose defining expression is equal to the part of the expression in the query. The part of an expression in a query can be the entire expression. When an expression in a query can be replaced with more than one replacement expression involving virtual columns, the replacement expression with the least cost of query processing is selected.Type: GrantFiled: December 6, 2007Date of Patent: October 25, 2011Assignee: Oracle International CorporationInventors: Subhransu Basu, Harmeek Singh Bedi
-
Patent number: 7991794Abstract: Techniques are described herein for supporting pipelining operations involving DML (Data manipulation Language) and query. In an embodiment, a DML operation is performed for the purpose of changing data in a database system from a first state to a second state. Before the data in the database system is changed by the DML operation, the DML operation has an in-memory representation of such data. In an embodiment, a subsequent query operation that logically depends on the data in the database system in the second state is granted access to the in-memory representation of such data in the second state before the data in the database system is changed by the DML operation to the second state. As a result, operations may be executed in a pipelined fashion with minimum blocking.Type: GrantFiled: August 12, 2008Date of Patent: August 2, 2011Assignee: Oracle International CorporationInventors: Harmeek Singh Bedi, Richard Yu Gu
-
Patent number: 7899784Abstract: A method for performing multiple merge operations with a source data structure and a plurality of destination data structures, in which the source data structure is scanned one time in order to obtain source data that is then used for multiple merge operations. The source data is then used consecutively in order to merge the source data into the one or more destination data structures. Each merge is performed using the same scan of the source data structure and within the same execution of a database command.Type: GrantFiled: May 28, 2003Date of Patent: March 1, 2011Assignee: Oracle International CorporationInventors: Richard Yu Gu, Harmeek Singh Bedi, Ashish Thusoo
-
Publication number: 20100030866Abstract: A system for providing real-time cloud computing. The system includes a plurality of computing nodes, each node including a CPU, a memory, and a hard disk. The system includes a central intelligence manager for real-time assigning of tasks to the plurality of computing nodes. The central intelligence manager is configured to provide CPU scaling in parallel. The central intelligence manager is configured to provide a concurrent index. The central intelligence manager is configured to provide a multi-level cache. The central intelligence manager is configured to provide direct disk reads to the hard disks. The central intelligence manager is configured to utilize UDP for peer-to-peer communication between the computing nodes.Type: ApplicationFiled: July 23, 2009Publication date: February 4, 2010Applicant: Ameya Computing, Inc.Inventor: Harmeek Singh Bedi
-
Patent number: 7634512Abstract: A technique for migrating (e.g., “copying” or “moving”) temporary data from one session to another session is provided. While executing a workload associated with a particular session, session state is created. A subset of the session state comprises large objects that are referred to as “temporary data.” Thus, temporary data is stored in a database (instead of in the database server) and is normally deleted when the particular session is deleted. To avoid this deletion when the session state is migrated to a different session, the temporary data, in one embodiment, is saved in an external storage that is separate from the database. An external table is created in the external storage and stores the temporary data. Location information to access the external table is provided to the other session.Type: GrantFiled: April 4, 2007Date of Patent: December 15, 2009Assignee: Oracle International CorporationInventors: Yujie Cao, Tugrul Bingol, Geeta Arora, Harmeek Singh Bedi, Susan M. Kotsovolos
-
Publication number: 20090157623Abstract: Techniques are described herein for supporting pipelining operations involving DML (Data manipulation Language) and query. In an embodiment, a DML operation is performed for the purpose of changing data in a database system from a first state to a second state. Before the data in the database system is changed by the DML operation, the DML operation has an in-memory representation of such data. In an embodiment, a subsequent query operation that logically depends on the data in the database system in the second state is granted access to the in-memory representation of such data in the second state before the data in the database system is changed by the DML operation to the second state. As a result, operations may be executed in a pipelined fashion with minimum blocking.Type: ApplicationFiled: August 12, 2008Publication date: June 18, 2009Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Harmeek Singh Bedi, Richard Yu Gu
-
Publication number: 20090150336Abstract: Techniques are described herein for partitioning a database table using a virtual column as the partitioning key. A virtual column is defined by the database to contain results of a defining expression. Partitioning can be performed using a variety of partitioning schemes, such as range partitioning and hash partitioning. The partitions are automatically updated to reflect changes to the values in the base columns upon which the virtual column depends. Partition pruning and parallel-wise partition joins can be performed on database tables which have been partitioned on virtual columns.Type: ApplicationFiled: December 6, 2007Publication date: June 11, 2009Applicant: ORACLE INTERNATIONAL CARPORATIONInventors: Subhransu Basu, Harmeek Singh Bedi, Ananth Raghavan
-
Publication number: 20090150413Abstract: Techniques are described herein for performing column functions on virtual columns in database tables. A virtual column is defined by the database to contain results of a defining expression. Statistics are collected and maintained for virtual columns. Indexing is performed on virtual columns. Referential integrity is maintained between two tables using virtual columns as keys. Join predicate push-down operations are also performed using virtual columns.Type: ApplicationFiled: December 6, 2007Publication date: June 11, 2009Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Subhransu Basu, Harmeek Singh Bedi
-
Publication number: 20090150366Abstract: Techniques are described herein for replacing a part of an expression in a query to a database with a virtual column. A virtual column is defined by the database to contain results of a defining expression. A part of an expression in a query is replaced with a virtual column whose defining expression is equal to the part of the expression in the query. The part of an expression in a query can be the entire expression. When an expression in a query can be replaced with more than one replacement expression involving virtual columns, the replacement expression with the least cost of query processing is selected.Type: ApplicationFiled: December 6, 2007Publication date: June 11, 2009Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Subhransu Basu, Harmeek Singh Bedi
-
Publication number: 20080098048Abstract: A technique for migrating (e.g., “copying” or “moving”) temporary data from one session to another session is provided. While executing a workload associated with a particular session, session state is created. A subset of the session state comprises large objects that are referred to as “temporary data.” Thus, temporary data is stored in a database (instead of in the database server) and is normally deleted when the particular session is deleted. To avoid this deletion when the session state is migrated to a different session, the temporary data, in one embodiment, is saved in an external storage that is separate from the database. An external table is created in the external storage and stores the temporary data. Location information to access the external table is provided to the other session.Type: ApplicationFiled: April 4, 2007Publication date: April 24, 2008Inventors: Yujie Cao, Tugrul Bingol, Geeta Arora, Harmeek Singh Bedi, Susan M. Kotsovolos
-
Patent number: 7222123Abstract: A method for performing multiple merge operations with a source data structure and a plurality of destination data structures, in which the source data structure is scanned one time in order to obtain source data that is then used for multiple merge operations. The source data is then used consecutively in order to merge the source data into the one or more destination data structures. Each merge is performed using the same scan of the source data structure and within the same execution of a database command.Type: GrantFiled: May 28, 2003Date of Patent: May 22, 2007Assignee: Oracle International CorporationInventors: Richard Yu Gu, Harmeek Singh Bedi, Ashish Thusoo
-
Patent number: 7206784Abstract: A method for performing multiple merge operations with a source data structure and a plurality of destination data structures, in which the source data structure is scanned one time in order to obtain source data that is then used for multiple merge operations. The source data is then used consecutively in order to merge the source data into the one or more destination data structures. Each merge is performed using the same scan of the source data structure and within the same execution of a database command.Type: GrantFiled: May 28, 2003Date of Patent: April 17, 2007Assignee: Oracle International CorporationInventors: Richard Yu Gu, Harmeek Singh Bedi, Ashish Thusoo
-
Publication number: 20040243590Abstract: A source data structure may be scanned one time in order to obtain source data that is then used for multiple merge operations in order to merge source data into one or more destination data structures. Each merge operation is then performed using the same scan of the source data structure and a scan of the destination data structure.Type: ApplicationFiled: May 28, 2003Publication date: December 2, 2004Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Richard Yu Gu, Harmeek Singh Bedi, Ashish Thusoo
-
Publication number: 20040243591Abstract: A source data structure may be scanned one time in order to obtain source data that is then used for multiple merge operations in order to merge source data into one or more destination data structures. Each merge operation is then performed using the same scan of the source data structure and a scan of the destination data structure.Type: ApplicationFiled: May 28, 2003Publication date: December 2, 2004Applicant: ORACLE INTERNATIONAL CORPORATION, REDWOOD SHORES, CAInventors: Richard Yu Gu, Harmeek Singh Bedi, Ashish Thusoo
-
Publication number: 20040243589Abstract: A source data structure may be scanned one time in order to obtain source data that is then used for multiple merge operations in order to merge source data into one or more destination data structures. Each merge operation is then performed using the same scan of the source data structure and a scan of the destination data structure.Type: ApplicationFiled: May 28, 2003Publication date: December 2, 2004Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Richard Yu Gu, Harmeek Singh Bedi, Ashish Thusoo
-
Publication number: 20040243550Abstract: A source data structure may be scanned one time in order to obtain source data that is then used for multiple merge operations in order to merge source data into one or more destination data structures. Each merge operation is then performed using the same scan of the source data structure and a scan of the destination data structure.Type: ApplicationFiled: May 28, 2003Publication date: December 2, 2004Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Richard Yu Gu, Harmeek Singh Bedi, Ashish Thusoo