Abstract: In one embodiment, techniques are provided for generating a change cache database utilized to inspect changes made to a repository. Specifically, each of a plurality of client devices may maintain and make changes to a local briefcase representing an infrastructure and obtained from the repository. Information associated with each of the changes may be maintained and stored in a changeset at the client device and then transmitted and stored at a modeling hub services software. A change cache database may be generated at a client device based on locally generated changesets and/or received changesets. The change cache database includes a plurality of tables that store summary information from the changesets. The client device that generated and stores the change cache database may search the change cache database to determine what changes have been made to the repository.

Abstract: Techniques are provided for maintaining a class hierarchy of an object-oriented data model in tables of a relational database that minimize performance impact (e.g., in terms of both processing resources and storage footprint). In one embodiment, an object-relational mapping system accesses a class hierarchy of an object-oriented data model. A plurality of tables of a relational database are generated, including a primary table, a joined table and an overflow table. The object-relational mapping system maps classes of the class hierarchy to the primary table, joined table and overflow table, wherein the mapping maps properties of classes to columns of the primary table and joined table until a column threshold is reached and then maps excess properties to columns of the overflow table, and the mapping shares at least one column of the primary table, joined table or overflow table among classes such that multiple different properties are mapped to the shared column.

Abstract: In one embodiment, techniques are provided for generating a change cache database utilized to inspect changes made to a repository. Specifically, each of a plurality of client devices may maintain and make changes to a local briefcase representing an infrastructure and obtained from the repository. Information associated with each of the changes may be maintained and stored in a changeset at the client device and then transmitted and stored at a modeling hub services software. A change cache database may be generated at a client device based on locally generated changesets and/or received changesets. The change cache database includes a plurality of tables that store summary information from the changesets. The client device that generated and stores the change cache database may search the change cache database to determine what changes have been made to the repository.