Sitaram R Vemulapalli

US Patent:

20130006950, Jan 3, 2013

Filed:

Jul 1, 2011

Appl. No.:

13/174823

Inventors:

Naresh K. Chainani - Portland OR, US
Raghupathi K. Murthy - Union City CA, US
Sitaram Vemulapalli - San Jose CA, US
Liping Zhang - Portland OR, US

Assignee:

INTERNATIONAL BUSINESS MACHINES CORPORATION - Armonk NY

International Classification:

G06F 17/30

US Classification:

707704, 707E17007

Abstract:

Method for attaching one or more tables online to a range partitioned table, includes: starting a child transaction; obtaining an exclusive lock on a source table; obtaining an intent exclusive lock on a target table; soft invalidating queries on the target table where compiled form of queries are cached for reuse; attaching the source table(s) to the target table as a new partition(s) of the target table; modifying indices and table structure of the target table to reflect the attaching of the new partition; committing the child transaction; and releasing the exclusive lock and the intent exclusive lock, where concurrently running queries over the target table continue to run without considering the partition until the intent exclusive lock and the exclusive lock are released. Queries on the target table only consider existing partitions when the attaching is in progress. The new partition is available once the attach operation is complete.

US Patent:

20150106375, Apr 16, 2015

Filed:

Jun 13, 2014

Appl. No.:

14/304698

Inventors:

- Armonk NY, US
Marco GRECO - Staines, GB
Raghupathi K. MURTHY - Union City CA, US
Sitaram VEMULAPALLI - San Jose CA, US

International Classification:

G06F 17/30

US Classification:

707737

Abstract:

Provided are techniques for cyclic based data partitioning policy with automatic physical schema management. A data partitioning policy for data is received, wherein the data partitioning policy identifies a condition for automatically implementing the data partitioning policy and criteria for modifying a set of partitions. In response to the condition occurring, the data partitioning policy is automatically applied to select at least one partition from the set of partitions based on the criteria. An operation is performed on the at least one partition to modify the set of partitions.

US Patent:

20150106407, Apr 16, 2015

Filed:

Oct 10, 2013

Appl. No.:

14/051260

Inventors:

- Armonk NY, US
Marco GRECO - Staines, GB
Raghupathi K. MURTHY - Union City CA, US
Sitaram VEMULAPALLI - San Jose CA, US

Assignee:

International Business Machines Corporation - Armonk NY

International Classification:

G06F 17/30

US Classification:

707804

Abstract:

Provided are techniques for cyclic based data partitioning policy with automatic physical schema management. A data partitioning policy for data is received, wherein the data partitioning policy identifies a condition for automatically implementing the data partitioning policy and criteria for modifying a set of partitions. In response to the condition occurring, the data partitioning policy is automatically applied to select at least one partition from the set of partitions based on the criteria. An operation is performed on the at least one partition to modify the set of partitions.