Oracle International Corporation

Subash Chadalavada

Kenton E Noble

Richard J Lotero

Joseph Epstein

Sujith Sreedharan

Dawn Austin

Joseph H Kent

William Greene

Jayaprakash Vijayan

Suvasish Sharma

Keith Swartz

Online conversion procedures avoid the need to generate a copy of an entire table in order to convert the data type of a column in the table. To convert a table's column to a new data type, a replacement column is created in the table, the replacement column having the new data type. A background process dedicated to converting the column translates values in the column of the old data type to the new data type and stores the converted values in the replacement column. In addition, as transactions of users are applied to rows in the table, the value in the column of the old data type in the rows is converted and stored in the replacement column. Once the background process completes, the replacement column is used in lieu of the converted column.

Minimizing computer resource usage when converting data types of a table column

A system and method for providing a code release infrastructure with granular code patching is described. Code patches, each including at least one resource unit are provided. Each resource unit includes metadata and file components. Code libraries, each including at least one resource unit, are patched. The metadata for each resource unit in the code patches is compared to the metadata for each such corresponding resource unit in the code libraries. Each resource unit in the code patches is merged into the code libraries for each such corresponding resource unit that is out-of-date as defined by merge rules. Archive files, as defined by archive file definitions, are created or updated using the resource units from the code libraries, or, optionally, are deleted. The archive files are digitally signed also as required. The system and method enables source and derived code and third party code to be patched granularly.

System and method for providing a java code release infrastructure with granular code patching

The present invention is directed to a method and mechanism for consolidating data. According to an embodiment of the invention, consolidation is performed based upon transformation rules established for data to be consolidated. An aspect of an embodiment of the invention relates to performing data transformations to resolve potential consolidation conflict issues. Another aspect of an embodiment of the invention relates to validation procedures performed after transformation.

Method and mechanism for data consolidation

Growing community of inventors

Fremont, CA, United States of America

Subash Chadalavada