| CPC G06F 16/288 (2019.01) [G06F 16/212 (2019.01); G06F 16/2264 (2019.01); G06F 16/24573 (2019.01)] | 16 Claims |
|
1. A computer-implemented method comprising:
receiving an entity-relationship data model representing a data schema in a graphical form, the entity-relationship model comprising entities and relationships between the entities, wherein an entity comprises a set of attributes;
annotating the entity-relationship data model, wherein the annotating comprises grouping a plurality of entities into a logical entity;
validating the logical entity;
responsive to finding the logical entity is valid, automatically generating a message structure corresponding to the logical entity, wherein the message structure is represented in a data exchange format expressed in property and value pairs, wherein the message structure comprises properties mapped to at least some of the attributes of entities contained in the logical entity, wherein the properties are defined in one or more database tables represented by the logical entity;
generating a message containing the message structure, wherein generating the message comprises extracting values from the one or more database tables, and pairing the extracted values with corresponding properties; and
generating a translation operator code,
wherein the translation operator code is configured to translate messages between the logical entity and the one or more database tables based on the message structure,
wherein automatically generating the message structure comprises creating an object array when a first database table and a second database table represented by the logical entity have a one-to-many cardinality relationship or many-to-many cardinality relationship, wherein the object array comprises an array of objects containing properties defined in the second database table, wherein the array of objects are nested within another object representing a property defined in the first database table.
|