Patents by Inventor Bhujanga Panchapagesan

Bhujanga Panchapagesan 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).

  • Materialized view maintenance and change tracking
    Patent number: 7930297
    Abstract: 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: Grant
    Filed: December 3, 2004
    Date of Patent: April 19, 2011
    Assignee: Oracle International Corporation
    Inventors: Tsae-Feng Yu, John Raitto, Bhujanga Panchapagesan, Shilpa Lawande, Randall G. Bello
  • Rewriting a query to use a set of materialized views and database objects
    Patent number: 7440963
    Abstract: An approach for processing a query in a database system is disclosed. An original query is determined to be partially satisfied by a materialized view. The original query is transformed using a set operation (i.e., union and intersection) on the materialized view and either another materialized view or a base table.
    Type: Grant
    Filed: January 7, 2003
    Date of Patent: October 21, 2008
    Assignee: Oracle International Corporation
    Inventors: Randall G. Bello, Bhujanga Panchapagesan, Tsae-Feng Yu, John D. Raitto
  • Materialized view maintenance and change tracking
    Publication number: 20060122964
    Abstract: 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: Application
    Filed: December 3, 2004
    Publication date: June 8, 2006
    Inventors: Tsae-Feng Yu, John Raitto, Bhujanga Panchapagesan, Shilpa Lawande, Randall Bello