International Business Machines Corporation

Vaibhav S Dantale

Kiran Challapalli

Sameep Mehta

Srikanth Govindaraj Tamilselvam

Amith Singhee

Himanshu Gupta

Akshar Kaul

Samar T Desai

Ravi Vishnu Israni

A computer implemented method creates microservices for an application. A number of processor units clusters programs and data structures for the application using runtime metadata to form groups of the programs and data structures. The runtime metadata is obtained from running the application. The number of processor units creates a design for the microservices for the application using the groups of the programs and the data structures.

Microservice creation using runtime metadata

One or more processors receive operational data. The operational data includes two or more fields that contain an identical type of data as two or more fields within a master table. One or more processors generate a plurality of first unique identifiers from the two or more fields within the operational data and the master table. One or more processors determine a match between a pair of the plurality of first unique identifiers. The match is between a first unique identifier included in a operational data record and a first unique identifier included in a master table record. One or more processors determine a second unique identifier from the master table record. One or more processors generate an operational table record that includes the second unique identifier and at least a portion of the operational data.

Automatic updating of operational tables

In an approach for manipulating columns in a projection list in a database result set, a processor receives a database request having a projection operation for a plurality of columns in one or more tables, wherein the projection operation comprises a SELECT statement having a column list that includes having (a) a shorthand that specifies the plurality of columns and (b) a column sequence clause that specifies a column name from the plurality of columns and a resulting column position. A processor retrieves data records having the plurality of columns including the specified column name and the resulting column position. A processor generates a result set comprised of the data records having the plurality of columns, such that for the result set, values within the specified column name are inserted into the result set at the resulting column position.

Customize column sequence in projection list of select queries

Techniques are disclosed for retrieving database data records using a request having a substitute clause. The substitute clause replaces a value stored in a predefined column with a new value while selecting the values of the plurality of columns in a projection list. In one embodiment, the database request may utilize a pre-defined syntax for a SELECT statement that supports a substitute clause having a form of: substitute(&#x3c;col name&#x3e;, &#x3c;expression&#x3e;).

Growing community of inventors

Pune, India

Vaibhav S Dantale