Bentley Systems, Inc.

Affan Khan

Krischan Eberle

Casey Mullen

Ramanujam Raman

Techniques are provided for accessing derivative properties from a database utilizing a logical schema instruction that includes a base object identifier. A logical schema instruction may be received and analyzed to identify a predefined keyword. A portion of the logical schema instruction, that is located in relation to the predefined keyword, may be identified. The portion may include a base object identifier and a property identifier, e.g., a derivative property identifier. In an embodiment, the identified portion of the logical instruction is not translated to a database schema instruction at prepare time. Instead, an extract function is executed at runtime access and analyze a database table that corresponds to a base object associated with the base class identifier. A property in the database table that corresponds to the property identifier may be identified. Advantageously, a base object identifier may be utilized to access a derivative property.

Systems, methods, and media for accessing derivative properties from a post relational database utilizing a logical schema instruction that includes a base object identifier

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.

Technique for generating a change cache database utilized to inspect changes made to a repository

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. The properties of the classes are stored to the plurality of tables according to the mapping.

Growing community of inventors

Exton, PA, United States of America

Affan Khan