Abstract: A computing system may include an upgrade access engine configured to access a database upgrade to perform for a production database. The computing system may also include a database upgrade engine configured to generate multiple clones of the production database, including a production clone and a delta clone with instance data removed. The database upgrade engine may perform the database upgrade on the production clone, track changes to the production database, and push the tracked changes to the delta clone. After the database upgrade on the production clone completes, the database upgrade engine may perform the database upgrade on the delta clone, push upgraded data of the delta clone to the upgraded production clone, and set the upgraded production clone as an upgraded version of the production database.

Abstract: A system is provided that carries out object traversal in a product lifecycle management system. The system may process a received set of traversal rules in a determined precedence order for a received list of input objects to recursively acquire from a data store a list of child objects related to the input objects based on the traversal rules. The traversal rules may be processed in the precedence order determined based at least in part on a number of parent types in a hierarchical arrangement that specifies relationships between object types for a source type of object specified by each respective traversal rule. For each respective traversal rule, a set based query may be carried out on the data store to determine child objects for the input objects having one of a type or a parent type corresponding to the source type associated with the respective traversal rule.

Abstract: A fast branch-based hybrid Bill of Materials (BOM) system and method is provided that generates a BOM having a plurality of BOM lines that specify component revisions of components stored in a data store that are usable to build a structure. The BOM lines may be configured via at least one baseline branch and at least one live branch that instantiate component revisions for the structure. The system retrieves at high speed BOM lines for the BOM for components having revisions that are not associated with the at least one live branch from at least one index (i.e., cache) of BOM lines generated based on the baseline branch. The system also configures BOM lines for the BOM for components having revisions associated with the at least one live branch via at least one configuration rule. The system also causes a display device to output a list of component revisions based at least in part on the generated BOM.

Abstract: A PDM system, method, and computer program product for data transfer. A method includes determining a plurality of bill of material (BOM) components for a BOMLine by the PDM data processing system. The method includes determining a last export date for the BOMLine and determining a last saved date for at least one of the plurality of BOM components. The method includes creating an updated BOMLine corresponding to the components, without traversing a BOM structure, when the last saved date is more recent than the last export date, and publishing the updated BOMLine.

Abstract: A fast branch-based hybrid Bill of Materials (BOM) system and method is provided that generates a BOM having a plurality of BOM lines that specify component revisions of components stored in a data store that are usable to build a structure. The BOM lines may be configured via at least one baseline branch and at least one live branch that instantiate component revisions for the structure. The system retrieves at high speed BOM lines for the BOM for components having revisions that are not associated with the at least one live branch from at least one index (i.e., cache) of BOM lines generated based on the baseline branch. The system also configures BOM lines for the BOM for components having revisions associated with the at least one live branch via at least one configuration rule. The system also causes a display device to output a list of component revisions based at least in part on the generated BOM.

Abstract: A system is provided that carries out object traversal in a product lifecycle management system. The system may process a received set of traversal rules in a determined precedence order for a received list of input objects to recursively acquire from a data store a list of child objects related to the input objects based on the traversal rules. The traversal rules may be processed in the precedence order determined based at least in part on a number of parent types in a hierarchical arrangement that specifies relationships between object types for a source type of object specified by each respective traversal rule. For each respective traversal rule, a set based query may be carried out on the data store to determine child objects for the input objects having one of a type or a parent type corresponding to the source type associated with the respective traversal rule.

Abstract: Methods for product data management and corresponding systems and computer-readable mediums. A method includes receiving a hierarchical data structure that includes a plurality of structure lines referencing persistent data objects and receiving metadata corresponding to persistent data objects referenced by the hierarchical data structure. The method includes computing an access control expression corresponding to each persistent object according to the metadata, wherein the access control expressions are string-representation Boolean expressions, and storing the access control expressions.

Abstract: Methods for data import and corresponding systems and computer-readable mediums. A method includes initiating an import of an import data object from a source data processing system by the target data processing system. The target data processing system maintains import records that include a last import time stamp (“LID”) for a plurality of other systems and data objects. The method includes determining whether to import the import data object based on the LID for that source data processing system for the import data object, the last saved timestamp (“LSD”) of source for that data object, and the LSD of target for a corresponding existing data object in the target data processing system. The method includes selectively importing the import data object by the target data processing system based on the determination.

Abstract: Methods for product data management and corresponding systems and computer-readable mediums. A method includes receiving a hierarchical data structure that includes a plurality of structure lines referencing persistent data objects and receiving metadata corresponding to persistent data objects referenced by the hierarchical data structure. The method includes computing an access control expression corresponding to each persistent object according to the metadata, wherein the access control expressions are string-representation Boolean expressions, and storing the access control expressions.

Abstract: A PDM system, method, and computer program product for traversing a large data structure including corresponding runtime objects. A method includes receiving traversal parameters including a plurality of unique object identifiers (UIDs) corresponding to objects in a data structure. The method includes receiving input objects, including input runtime objects, and closure rule clauses. The method includes configuring runtime objects, from the objects in the data structure, according to the traversal parameters, and storing the runtime objects in a temporary table. The method includes traversing the data structure and temporary table using the closure rules to produce traversed objects, and serializing and storing the traversed objects.

Abstract: A PDM system, method, and computer program product for data transfer. A method includes determining a plurality of persistent objects in a data structure to be replicated to a plurality of replication sites. The plurality of persistent objects is identified based on a transaction table entry identifying a specific scoped transaction. The method includes determining specific persistent objects of the plurality of persistent objects to be replicated to each of the plurality of replication sites based on which of the plurality of persistent objects have been updated since last being replicated to each respective replication site, without traversing the full data structure. The method includes initiating a synchronization transaction according to the specific persistent objects and replicating the specific persistent objects to at least one of the plurality of replication sites, without traversing the full data structure.

Abstract: A PDM system, method, and computer program product for data transfer. A method includes determining a plurality of bill of material (BOM) components for a BOMLine by the PDM data processing system. The method includes determining a last export date for the BOMLine and determining a last saved date for at least one of the plurality of BOM components. The method includes creating an updated BOMLine corresponding to the components, without traversing a BOM structure, when the last saved date is more recent than the last export date, and publishing the updated BOMLine.

Abstract: A PDM system, method, and computer program product for traversing a large data structure including corresponding runtime objects. A method includes receiving traversal parameters including a plurality of unique object identifiers (UIDs) corresponding to objects in a data structure. The method includes receiving input objects, including input runtime objects, and closure rule clauses. The method includes configuring runtime objects, from the objects in the data structure, according to the traversal parameters, and storing the runtime objects in a temporary table. The method includes traversing the data structure and temporary table using the closure rules to produce traversed objects, and serializing and storing the traversed objects.

Abstract: A system, method, and computer program product for efficient synchronization of data structures. A method includes maintaining a source data structure and a corresponding accountability table in the source data processing system, where at least a portion of the data structure is to be synchronized with a target data structure in a target data processing system. The method includes receiving a synchronization command, and in response to receiving the synchronization command, identifying a first plurality of synchronization objects in the source data structure, using the accountability table, that also exist in the target data structure and have been modified in the target data structure. The method includes identifying a second plurality of synchronization objects in the source data structure that have been newly-created or deleted and that either reference or are referenced by an object in the accountability table.

Abstract: A system, method, and computer program product for efficient bulk database queries. A method includes receiving a closure rule and at least one input object, where the closure rule having at least one closure rule clause. The method also includes identifying a first closure rule clause to be evaluated for the input object, and constructing a recursive database query corresponding to the first closure rule clause. The method includes querying a database using the recursive database query, and receiving and storing results from the recursive database query in the data processing system.

Abstract: A system, method, and computer program product for data transfer. The method includes receiving a request to transfer a principal object from a source location to a target location. The method also includes receiving at least one closure rule corresponding to the principal object, and transferring the principal object from the source location to be stored in the target location. The method also includes identifying at least one secondary object to be transferred with the principal object, according to the at least one closure rule. The method also includes selectively transferring the secondary object from the source location to be stored in the target location.

Abstract: A system, method, and computer program product for efficient bulk database queries. A method includes receiving a closure rule and at least one input object, where the closure rule having at least one closure rule clause. The method also includes identifying a first closure rule clause to be evaluated for the input object, and constructing a recursive database query corresponding to the first closure rule clause. The method includes querying a database using the recursive database query, and receiving and storing results from the recursive database query in the data processing system.

Abstract: A system, method, and computer program product for data transfer. The method includes receiving a request to transfer a principal object from a source location to a target location. The method also includes receiving at least one closure rule corresponding to the principal object, and transferring the principal object from the source location to be stored in the target location. The method also includes identifying at least one secondary object to be transferred with the principal object, according to the at least one closure rule. The method also includes selectively transferring the secondary object from the source location to be stored in the target location.

Abstract: A system, method, and computer program product for efficient synchronization of data structures. A method includes maintaining a source data structure and a corresponding accountability table in the source data processing system, where at least a portion of the data structure is to be synchronized with a target data structure in a target data processing system. The method includes receiving a synchronization command, and in response to receiving the synchronization command, identifying a first plurality of synchronization objects in the source data structure, using the accountability table, that also exist in the target data structure and have been modified in the target data structure. The method includes identifying a second plurality of synchronization objects in the source data structure that have been newly-created or deleted and that either reference or are referenced by an object in the accountability table.