Flattening of hierarchical data into a relational schema in a computing system

A non-transitory computer readable medium having instructions stored thereon that when executed by a processor cause the processor to perform a method of generating telemetry data from application programming interface (API) data in a computing system, comprising:

• obtaining the API data from a plurality of software components executing in a plurality of client computers;
• and
• serializing the API data for transmission from the client computers to a server computer, the serialized data including at least one data structure that includes a parent object having an array of child objects comprising a child object and an additional child object, wherein:
• the server computer, after receiving the serialized data, generates the telemetry data having a relational schema from the serialized data by generating a table for the parent object and storing attributes of the child object and the additional child object in the table generated for the parent object, wherein:
• the child object has a first type;
• the additional child object has a second type different than the first type;
• generating the telemetry data further comprises generating a separate table for each of the child object and the additional child object;
• if the child object or the additional child object does not include an explicit identifier defined by an identifier key, a default identifier is generated for the child object or the additional child object for inclusion in the table for the parent object;
• and
• at least one of the parent object or the child object includes a primitive array, and the table generated for the parent object or the separate table generated for the child object includes a cell having serialized values of the primitive array.

A computing system, comprising:

• a hardware platform including a processor and memory;
• and
• a software platform executing on the hardware platform, the software platform including a data transformer executable by the processor to:
• obtain application programming interface (API) data from a plurality of software components executing in a plurality of client computers;
• and
• serialize the API data for transmission from the client computers to a server computer, the serialized data including at least one data structure that includes a parent object having an array of child objects comprising a child object and an additional child object, wherein:
• the server computer, after receiving the serialized data, generates telemetry data having a relational schema from the serialized data by generating a table for the parent object and storing attributes of the child object and the additional child object in the table generated for the parent object, wherein:
• the child object has a first type;
• the additional child object has a second type different than the first type;
• generating the telemetry data further comprises generating a separate table for each of the child object and the additional child object;
• if the child object or the additional child object does not include an explicit identifier defined by an identifier key, a default identifier is generated for the child object or the additional child object for inclusion in the table for the parent object;
• and
• at least one of the parent object or the child object includes a primitive array, and the table generated for the parent object or the separate table generated for the child object includes a cell having serialized values of the primitive array.