Patents by Inventor Sujatha Muthulingam

Sujatha Muthulingam 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).

  • Publication number: 20200257663
    Abstract: A method, apparatus, and system for tracking row and object database activity into block level heatmaps is provided. Database activity including reads, writes, and creates can be tracked by a database management system at the finest possible level of granularity, or the row and object level. To efficiently record the tracked database activity, a two-part structure is described for writing the activity into heatmaps. A hierarchical in-memory component may use a dynamically allocated sparse pool of bitmap blocks. Periodically, the in-memory component is persisted to a stored representation component, sharable with multiple database instances, which may include consolidated last access times and/or a history of heatmap snapshots to reflect access over time. The heatmaps may then be externalized to database users and applications to provide and support a variety of features.
    Type: Application
    Filed: April 28, 2020
    Publication date: August 13, 2020
    Inventors: Vineet Marwah, Sujatha Muthulingam, Amit Ganesh
  • Patent number: 10678760
    Abstract: A method, apparatus, and system for tracking row and object database activity into block level heatmaps is provided. Database activity including reads, writes, and creates can be tracked by a database management system at the finest possible level of granularity, or the row and object level. To efficiently record the tracked database activity, a two-part structure is described for writing the activity into heatmaps. A hierarchical in-memory component may use a dynamically allocated sparse pool of bitmap blocks. Periodically, the in-memory component is persisted to a stored representation component, sharable with multiple database instances, which may include consolidated last access times and/or a history of heatmap snapshots to reflect access over time. The heatmaps may then be externalized to database users and applications to provide and support a variety of features.
    Type: Grant
    Filed: March 14, 2013
    Date of Patent: June 9, 2020
    Assignee: Oracle International Corporation
    Inventors: Vineet Marwah, Sujatha Muthulingam, Amit Ganesh
  • Patent number: 10007691
    Abstract: To prioritize repopulation of in-memory compression units (IMCU), a database server compresses, into an IMCU, a plurality of data units from a database table. In response to changes to any of the plurality of data units within the database table, the database server performs the steps of: (a) invalidating corresponding data units in the IMCU; (b) incrementing an invalidity counter of the IMCU that reflects how many data units within the IMCU have been invalidated; (c) receiving a data request that targets one or more of the plurality of data units of the database table; (d) in response to receiving the data request, incrementing an access counter of the IMCU; and (e) determining a priority for repopulating the IMCU based, at least in part, on the invalidity counter and the access counter.
    Type: Grant
    Filed: August 11, 2015
    Date of Patent: June 26, 2018
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Michael J. Gleeson, Jesse Kamp, Vineet Marwah, Tirthankar Lahiri, Juan R. Loaiza, Sanket Hase, Niloy Mukherjee, Sujatha Muthulingam, Atrayee Mullick, Allison L. Holloway
  • Patent number: 9767131
    Abstract: A method, non-transitory computer readable media, and system for hierarchical organization of tablespace free space metadata in a database are provided. The hierarchy is divided into at least two levels: level 1 or L1 blocks are stored as a shared data structure and map free space in a tablespace, whereas level 2 or L2 blocks are stored as separate local copies at each database instance and map to the L1 bitmap blocks. The L2 blocks each indicate, for each L1 block of a respective subset of a plurality of L1 blocks, a maximum size of a largest extent that can be allocated.
    Type: Grant
    Filed: August 29, 2016
    Date of Patent: September 19, 2017
    Assignee: Oracle International Corporation
    Inventors: Wei Zhang, Sujatha Muthulingam, Amit Ganesh
  • Patent number: 9715414
    Abstract: A method, apparatus, and system for a multi-instance database scan server is provided to process data scan operations for segments within in-memory stores, such as in-memory columnar (IMC) stores. The scan server uses a client/server based model, wherein each database instance in the database management system (“DBMS”) is associated with a client-side scan server and a server-side scan server. The client-side scan server can reside in the data and/or index layer of the DBMS, receiving requests for scan operations on in-memory segments. After receiving a data scan request from an IMC client, the client-side scan server can create several independently executable scanning tasks to process the request. The scanning tasks are each assigned to a particular server-side scan server for processing based on one or more factors, which may include a load balancing component. Additional factors to be considered may include instance affinity and/or NUMA (Non-Uniform Memory Access) affinity.
    Type: Grant
    Filed: October 23, 2015
    Date of Patent: July 25, 2017
    Assignee: Oracle International Corporation
    Inventors: Sujatha Muthulingam, Amit Ganesh, Vineet Marwah
  • Publication number: 20170116043
    Abstract: A method, apparatus, and system for a multi-instance database scan server is provided to process data scan operations for segments within in-memory stores, such as in-memory columnar (IMC) stores. The scan server uses a client/server based model, wherein each database instance in the DBMS is associated with a client-side scan server and a server-side scan server. The client-side scan server can reside in the data and/or index layer of the DBMS, receiving requests for scan operations on in-memory segments. After receiving a data scan request from an IMC client, the client-side scan server can create several independently executable scanning tasks to process the request. The scanning tasks are each assigned to a particular server-side scan server for processing based on one or more factors, which may include a load balancing component. Additional factors to be considered may include instance affinity and/or NUMA (Non-Uniform Memory Access) affinity.
    Type: Application
    Filed: October 23, 2015
    Publication date: April 27, 2017
    Inventors: Sujatha Muthulingam, Amit Ganesh, Vineet Marwah
  • Patent number: 9576012
    Abstract: A method, apparatus, and system for hierarchical organization of tablespace free space metadata in a database are provided. The hierarchy is divided into at least two levels: level 1 or L1 bitmap blocks are stored as a shared data structure and map free space in a tablespace, whereas level 2 or L2 bitmap blocks are stored as separate local copies at each database instance and map to the L1 bitmap blocks. This hierarchical organization provides a mechanism for finer grained concurrency control, enabling highly parallel tablespace metadata processing to accommodate the performance requirements of large tablespaces with big data sets. By integrating the hierarchical organization as part of the tablespace stack layer in a database management system (DBMS), implementations can be provided transparently to database end users without demanding any additional administrative, maintenance, or development burdens.
    Type: Grant
    Filed: March 14, 2013
    Date of Patent: February 21, 2017
    Assignee: Oracle International Corporation
    Inventors: Wei Zhang, Sujatha Muthulingam, Amit Ganesh
  • Publication number: 20160371314
    Abstract: A method, non-transitory computer readable media, and system for hierarchical organization of tablespace free space metadata in a database are provided. The hierarchy is divided into at least two levels: level 1 or L1 blocks are stored as a shared data structure and map free space in a tablespace, whereas level 2 or L2 blocks are stored as separate local copies at each database instance and map to the L1 bitmap blocks. The L2 blocks each indicate, for each L1 block of a respective subset of a plurality of L1 blocks, a maximum size of a largest extent that can be allocated.
    Type: Application
    Filed: August 29, 2016
    Publication date: December 22, 2016
    Inventors: Wei Zhang, Sujatha Muthulingam, Amit Ganesh
  • Patent number: 9465823
    Abstract: Disclosed are methods, systems, and computer program products for processing a file which include using a computer system that is programmed for performing a process of receiving the file in response to a request for storing the file, determining whether a database already contains the file, and storing the file in the database if the database does not already contain the file. The process may alternatively include receiving the file in response to a request for storing the file, determining whether a database already contains the file, and storing the file without storing the received file if the database already contains the file. The process may also alternatively include receiving the file in response to a request for storing the file in a database, separating the file into a plurality of portions, and storing the plurality of portions so each of the plurality of portions can be individually accessed.
    Type: Grant
    Filed: October 19, 2006
    Date of Patent: October 11, 2016
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Kam Shergill, Bharath Aleti, Dheerai Pandey, Sujatha Muthulingam, Amit Ganesh
  • Publication number: 20160085834
    Abstract: To prioritize repopulation of in-memory compression units (IMCU), a database server compresses, into an IMCU, a plurality of data units from a database table. In response to changes to any of the plurality of data units within the database table, the database server performs the steps of: (a) invalidating corresponding data units in the IMCU; (b) incrementing an invalidity counter of the IMCU that reflects how many data units within the IMCU have been invalidated; (c) receiving a data request that targets one or more of the plurality of data units of the database table; (d) in response to receiving the data request, incrementing an access counter of the IMCU; and (e) determining a priority for repopulating the IMCU based, at least in part, on the invalidity counter and the access counter.
    Type: Application
    Filed: August 11, 2015
    Publication date: March 24, 2016
    Inventors: Michael J. Gleeson, Jesse Kamp, Vineet Marwah, Tirthankar Lahiri, Juan R. Loaiza, Sanket Hase, Niloy Mukherjee, Sujatha Muthulingam, Atrayee Mullick, Allison L. Holloway
  • Publication number: 20140279849
    Abstract: A method, apparatus, and system for hierarchical organization of tablespace free space metadata in a database are provided. The hierarchy is divided into at least two levels: level 1 or L1 bitmap blocks are stored as a shared data structure and map free space in a tablespace, whereas level 2 or L2 bitmap blocks are stored as separate local copies at each database instance and map to the L1 bitmap blocks. This hierarchical organization provides a mechanism for finer grained concurrency control, enabling highly parallel tablespace metadata processing to accommodate the performance requirements of large tablespaces with big data sets. By integrating the hierarchical organization as part of the tablespace stack layer in a database management system (DBMS), implementations can be provided transparently to database end users without demanding any additional administrative, maintenance, or development burdens.
    Type: Application
    Filed: March 14, 2013
    Publication date: September 18, 2014
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: Wei Zhang, Sujatha Muthulingam, Amit Ganesh
  • Patent number: 8775479
    Abstract: A method, system and computer program product are described for state maintenance of a large object. In one approach, the method, system and computer program product perform by associating one or more buffers with a transaction involving a large object, the large object data may be accessed using the one or more buffers during the transaction, and storing data for the large object from the one or more buffers in one or more sets of contiguous blocks. In one approach, a system performs state maintenance of a large object with a cache that associates one or more buffers with a transaction involving a large object, the large object data may be accessed using the one or more buffers during the transaction, and the cache stores large object data from the one or more buffers in one or more sets of contiguous blocks in storage.
    Type: Grant
    Filed: July 30, 2007
    Date of Patent: July 8, 2014
    Assignee: Oracle International Corporation
    Inventors: Nirman Kumar, Kaan Baloglu, Dheeraj Pandey, Krishna Kunchithapadam, Sujatha Muthulingam, Vipin Gokhale, Bharat Baddepudi
  • Publication number: 20140095438
    Abstract: A method, apparatus, and system for tracking row and object database activity into block level heatmaps is provided. Database activity including reads, writes, and creates can be tracked by a database management system at the finest possible level of granularity, or the row and object level. To efficiently record the tracked database activity, a two-part structure is described for writing the activity into heatmaps. A hierarchical in-memory component may use a dynamically allocated sparse pool of bitmap blocks. Periodically, the in-memory component is persisted to a stored representation component, sharable with multiple database instances, which may include consolidated last access times and/or a history of heatmap snapshots to reflect access over time. The heatmaps may then be externalized to database users and applications to provide and support a variety of features.
    Type: Application
    Filed: March 14, 2013
    Publication date: April 3, 2014
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: Vineet Marwah, Sujatha Muthulingam, Amit Ganesh
  • Patent number: 7886124
    Abstract: Disclosed is a system and method for implementing space management for large objects stored in the computing system. According to some approaches, storage of large objects are managed by dynamically creating contiguous chunks of storage space of varying lengths. The length of each chunk may vary depending upon object size being stored, fragmentation of the storage space, available free space, and/or expected length of the object.
    Type: Grant
    Filed: July 30, 2007
    Date of Patent: February 8, 2011
    Assignee: Oracle International Corporation
    Inventors: Sujatha Muthulingam, Amit Ganesh, Dheeraj Pandey, Niloy Mukherjee, Wei Zhang, Krishna Kunchithapadam
  • Patent number: 7716177
    Abstract: A method and apparatus for proactively allocating space to a logical layer of a database is provided. Allocation of space to a logical layer of a database is an expensive operation that should be minimized. The allocation of space includes discovering free space in all the higher layers in the logical storage hierarchy. It also includes cross-domain system calls and cleansing disk-write operations. In prior approaches, the allocation processes were triggered on-demand, only a certain logical layer was discovered to be at full capacity when an insert-row operation was attempted. In one embodiment of the invention, space needs are statistically predicted based on prior rates of space consumption. The database server pre-allocates space as needed, based on the statistical predictions. Rates of consumption are examined periodically.
    Type: Grant
    Filed: July 24, 2007
    Date of Patent: May 11, 2010
    Assignee: Oracle International Corporation
    Inventors: Wei Zhang, Amit Ganesh, Sujatha Muthulingam, Niloy Mukherjee
  • Patent number: 7664799
    Abstract: A framework for in-memory space management for content management database systems is provided. A per-instance in-memory dispenser is partitioned. An incoming transaction takes a latch on a partition and obtains sufficient block usage to perform and complete the transaction. Generating redo information is decoupled from transaction level processing and, instead, is performed when block requests are loaded into the in-memory dispenser or synced therefrom to a per-instance on-disk structure.
    Type: Grant
    Filed: July 30, 2007
    Date of Patent: February 16, 2010
    Assignee: Oracle International Corporation
    Inventors: Niloy Mukherjee, Amit Ganesh, Sujatha Muthulingam, Wei Zhang
  • Patent number: 7587568
    Abstract: A method and system of reclaiming storage space in data storage systems is disclosed. In one embodiment, a high water mark of a data container is adjusted after data in the data container is compacted. As a result, unused space in the data container can be reclaimed.
    Type: Grant
    Filed: June 24, 2004
    Date of Patent: September 8, 2009
    Assignee: Oracel International Corporation
    Inventors: Sujatha Muthulingam, Alex Tsukerman, Vishwanath Karra, Nicholas Whyte
  • Patent number: 7526508
    Abstract: An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.
    Type: Grant
    Filed: September 3, 2004
    Date of Patent: April 28, 2009
    Assignee: Oracle International Corporation
    Inventors: Leng Leng Tan, Gianfranco Putzolu, Richard Sarwal, Alex Tsukerman, Gary C. Ngai, Graham Stephen Wood, Karl Dias, Mark Ramacher, Benoit Dageville, Mohamed Ziauddin, Tirthankar Lahiri, Sujatha Muthulingam, Vishwanath Karra, Francisco Sanchez, Hsiao-Te Su, Wanli Yang, Vasudha Krishnaswamy, Sushil Kumar
  • Publication number: 20090037499
    Abstract: Disclosed is a system and method for implementing space management for large objects stored in the computing system. According to some approaches, storage of large objects are managed by dynamically creating contiguous chunks of storage space of varying lengths. The length of each chunk may vary depending upon object size being stored, fragmentation of the storage space, available free space, and/or expected length of the object.
    Type: Application
    Filed: July 30, 2007
    Publication date: February 5, 2009
    Applicant: Oracle International Corporation
    Inventors: Sujatha Muthulingam, Amit Ganesh, Dheeraj Pandey, Niloy Mukherjee, Wei Zhang, Krishna Kunchithapadam
  • Publication number: 20090037498
    Abstract: A framework for in-memory space management for content management database systems is provided. A per-instance in-memory dispenser is partitioned. An incoming transaction takes a latch on a partition and obtains sufficient block usage to perform and complete the transaction. Generating redo information is decoupled from transaction level processing and, instead, is performed when block requests are loaded into the in-memory dispenser or synced therefrom to a per-instance on-disk structure.
    Type: Application
    Filed: July 30, 2007
    Publication date: February 5, 2009
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: Niloy Mukherjee, Amit Ganesh, Sujatha Muthulingam, Wei Zhang