Create Object-centric Model from Relational Schema - Revision history

Ollvihe: /* Create object-centric model datatables */

2026-02-10T13:28:19Z

Create object-centric model datatables

← Older revision		Revision as of 13:28, 10 February 2026
Line 210:		Line 210:
	.SqlDataFrame		.SqlDataFrame
	.Where(Column(sourceColumn) != null)		.Where(Column(sourceColumn) != null)
	.~~WithColumn~~(COLUMN_EVENTS_EVENT_ID~~, Concat(Column(~~COLUMN_EVENT_TYPES_EVENT_ID~~), "_", Column(sourceColumn))~~)		.RenameColumns([COLUMN_EVENTS_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID])
	.WithColumn(COLUMN_EVENTS_TYPE, #expr{ eventTypeNameExpression })		.WithColumn(COLUMN_EVENTS_TYPE, #expr{ eventTypeNameExpression })
	.WithColumn(COLUMN_EVENTS_TIME, Column(dateColumns[0]))		.WithColumn(COLUMN_EVENTS_TIME, Column(dateColumns[0]))
Line 348:		Line 348:
	.SqlDataFrame		.SqlDataFrame
	.Where(Column(objectIdColumn) != null)		.Where(Column(objectIdColumn) != null)
	.~~WithColumn~~(COLUMN_EVENT_OBJECT_EVENT_ID~~, Concat(Column(~~COLUMN_EVENT_TYPES_EVENT_ID~~), "_", Column(objectIdColumn))~~)		.RenameColumns([COLUMN_EVENT_OBJECT_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID])
	.WithColumn(COLUMN_EVENT_OBJECT_OBJECT_ID, Column(objectIdColumn))		.WithColumn(COLUMN_EVENT_OBJECT_OBJECT_ID, Column(objectIdColumn))
	.WithColumn(COLUMN_EVENT_OBJECT_QUALIFIER, "")		.WithColumn(COLUMN_EVENT_OBJECT_QUALIFIER, "")

Ollvihe: /* Create object-centric model datatables */

2026-02-08T18:46:41Z

Create object-centric model datatables

← Older revision		Revision as of 18:46, 8 February 2026
Line 209:		Line 209:
	let eventsDataFrame = eventsDatatable		let eventsDataFrame = eventsDatatable
	.SqlDataFrame		.SqlDataFrame
			.Where(Column(sourceColumn) != null)
	.WithColumn(COLUMN_EVENTS_EVENT_ID, Concat(Column(COLUMN_EVENT_TYPES_EVENT_ID), "_", Column(sourceColumn)))		.WithColumn(COLUMN_EVENTS_EVENT_ID, Concat(Column(COLUMN_EVENT_TYPES_EVENT_ID), "_", Column(sourceColumn)))
	.WithColumn(COLUMN_EVENTS_TYPE, #expr{ eventTypeNameExpression })		.WithColumn(COLUMN_EVENTS_TYPE, #expr{ eventTypeNameExpression })
Line 346:		Line 347:
	let eventToObjectDataFrame = eventsDatatable		let eventToObjectDataFrame = eventsDatatable
	.SqlDataFrame		.SqlDataFrame
			.Where(Column(objectIdColumn) != null)
	.WithColumn(COLUMN_EVENT_OBJECT_EVENT_ID, Concat(Column(COLUMN_EVENT_TYPES_EVENT_ID), "_", Column(objectIdColumn)))		.WithColumn(COLUMN_EVENT_OBJECT_EVENT_ID, Concat(Column(COLUMN_EVENT_TYPES_EVENT_ID), "_", Column(objectIdColumn)))
	.WithColumn(COLUMN_EVENT_OBJECT_OBJECT_ID, Column(objectIdColumn))		.WithColumn(COLUMN_EVENT_OBJECT_OBJECT_ID, Column(objectIdColumn))

Ollvihe: /* Create object-centric model datatables */

2026-02-08T18:12:35Z

Create object-centric model datatables

← Older revision		Revision as of 18:12, 8 February 2026
Line 209:		Line 209:
	let eventsDataFrame = eventsDatatable		let eventsDataFrame = eventsDatatable
	.SqlDataFrame		.SqlDataFrame
	.~~RenameColumns~~([COLUMN_EVENTS_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID])		.WithColumn(COLUMN_EVENTS_EVENT_ID, Concat(Column(COLUMN_EVENT_TYPES_EVENT_ID), "_", Column(sourceColumn)))
	.WithColumn(COLUMN_EVENTS_TYPE, #expr{ eventTypeNameExpression })		.WithColumn(COLUMN_EVENTS_TYPE, #expr{ eventTypeNameExpression })
	.WithColumn(COLUMN_EVENTS_TIME, Column(dateColumns[0]))		.WithColumn(COLUMN_EVENTS_TIME, Column(dateColumns[0]))
Line 346:		Line 346:
	let eventToObjectDataFrame = eventsDatatable		let eventToObjectDataFrame = eventsDatatable
	.SqlDataFrame		.SqlDataFrame
	.~~RenameColumns~~([COLUMN_EVENT_OBJECT_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID])		.WithColumn(COLUMN_EVENT_OBJECT_EVENT_ID, Concat(Column(COLUMN_EVENT_TYPES_EVENT_ID), "_", Column(objectIdColumn)))
	.WithColumn(COLUMN_EVENT_OBJECT_OBJECT_ID, Column(objectIdColumn))		.WithColumn(COLUMN_EVENT_OBJECT_OBJECT_ID, Column(objectIdColumn))
	.WithColumn(COLUMN_EVENT_OBJECT_QUALIFIER, "")		.WithColumn(COLUMN_EVENT_OBJECT_QUALIFIER, "")

Ollvihe: /* Create object-centric model datatables */

2026-01-27T13:05:40Z

Create object-centric model datatables

← Older revision		Revision as of 13:05, 27 January 2026
Line 205:		Line 205:
	break;		break;
	}		}
	~~i++;~~
	}		}

Ollvihe: /* Create object-centric model datatables */

2026-01-27T10:44:45Z

Create object-centric model datatables

← Older revision		Revision as of 10:44, 27 January 2026
Line 198:		Line 198:
	// Concat( Column("OtherColumn"), ": ", #expr{eventTypeName} )		// Concat( Column("OtherColumn"), ": ", #expr{eventTypeName} )
	let eventTypeNameExpression = ToSqlExpression(#sql{ #expr{ eventTypeName } });		let eventTypeNameExpression = ToSqlExpression(#sql{ #expr{ eventTypeName } });

			let objectTypeName;
			for (let i = 0; i < Count(objectTypeNames); i++) {
			if (modelObject.Configuration.OcelDataSource.ObjectTypes.Get(objectTypeNames[i]) == objectsTable) {
			objectTypeName = objectTypeNames[i];
			break;
			}
			i++;
			}

	let eventsDataFrame = eventsDatatable		let eventsDataFrame = eventsDatatable
Line 204:		Line 213:
	.WithColumn(COLUMN_EVENTS_TYPE, #expr{ eventTypeNameExpression })		.WithColumn(COLUMN_EVENTS_TYPE, #expr{ eventTypeNameExpression })
	.WithColumn(COLUMN_EVENTS_TIME, Column(dateColumns[0]))		.WithColumn(COLUMN_EVENTS_TIME, Column(dateColumns[0]))
	.WithColumn(COLUMN_OBJECT_TYPE, #expr{ ~~objectsTable~~ })		.WithColumn(COLUMN_OBJECT_TYPE, #expr{ objectTypeName })
	.WithColumn(COLUMN_OBJECT_ID, Column(sourceColumn))		.WithColumn(COLUMN_OBJECT_ID, Column(sourceColumn))
	.Select([COLUMN_EVENTS_EVENT_ID, COLUMN_EVENTS_TYPE, COLUMN_EVENTS_TIME, COLUMN_OBJECT_TYPE, COLUMN_OBJECT_ID]);		.Select([COLUMN_EVENTS_EVENT_ID, COLUMN_EVENTS_TYPE, COLUMN_EVENTS_TIME, COLUMN_OBJECT_TYPE, COLUMN_OBJECT_ID]);

Ollvihe: /* Define foreign keys */

2026-01-27T08:29:50Z

Define foreign keys

← Older revision		Revision as of 08:29, 27 January 2026
Line 64:		Line 64:
	]);		]);
	</syntaxhighlight>		</syntaxhighlight>

			== Validate schema ==
			The relational schema should be [[Validate_Relational_Datamodel\|validated]] which checks that foreign keys are consistent and there are no duplicates for the primary keys. When the object-centric model has been created from a valid relational schema, the created object-centric model is also valid. QPR ProcessAnalyzer has the [[QPR_ProcessAnalyzer_Project_Workspace#Validating_Model\|model validation]] for object-centric models, but it only checks the model configuration and not the actual data in the Snowflake tables.

	== Create object-centric model datatables ==		== Create object-centric model datatables ==

Ollvihe: /* Create object-centric model datatables */

2025-12-17T19:48:29Z

Create object-centric model datatables

Show changes

Ollvihe: /* Create object-centric model datatables */

2025-11-04T09:59:14Z

Create object-centric model datatables

← Older revision		Revision as of 09:59, 4 November 2025
Line 227:		Line 227:
	}		}
	eventAttributeColumns = Except(eventAttributeColumns, [(eventsDatatable.Columns.Where(DataType == "DateTime").Name)[0]]);		eventAttributeColumns = Except(eventAttributeColumns, [(eventsDatatable.Columns.Where(DataType == "DateTime").Name)[0]]);
			eventAttributeColumns = Except(eventAttributeColumns, [COLUMN_EVENT_TYPES_EVENT_ID]);

	if (Count(eventAttributeColumns) > 0) {		if (Count(eventAttributeColumns) > 0) {
			let mergedColumns = [];
			let columnRenames = #{ };
			eventAttributeColumns.{
			let eventAttribute = _;
			if (eventAttribute.In(commonEventColumns)) {
			mergedColumns = Concat(mergedColumns, [eventAttribute]);
			columnRenames.Add("_" + eventAttribute, eventAttribute);
			} else {
			commonEventColumns = Concat(commonEventColumns, [eventAttribute]);
			columnRenames.Add(eventAttribute, eventAttribute);
			}
			};
			columnRenames.Add(COLUMN_EVENT_TYPES_EVENT_ID, COLUMN_EVENT_TYPES_EVENT_ID);
	let eventTypeDataFrame = eventsDatatable.SqlDataFrame		let eventTypeDataFrame = eventsDatatable.SqlDataFrame
	.Select(~~eventAttributeColumns~~);		.Select(columnRenames);
	allEventsDataFrame = allEventsDataFrame		allEventsDataFrame = allEventsDataFrame
	.Join(eventTypeDataFrame, [COLUMN_EVENTS_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID], "leftouter")		.Join(eventTypeDataFrame, [COLUMN_EVENTS_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID], "leftouter")
	.RemoveColumns([COLUMN_EVENT_TYPES_EVENT_ID]);		.RemoveColumns([COLUMN_EVENT_TYPES_EVENT_ID]);
	~~commonEventColumns~~ = ~~Concat~~(~~commonEventColumns~~, ~~eventAttributeColumns~~);
			mergedColumns.{
			let mergedColumn = _;
			allEventsDataFrame = allEventsDataFrame
			.WithColumn(mergedColumn, Coalesce(Column(mergedColumn), Column("_" + mergedColumn)));
			};
			if (Count(mergedColumns) > 0) {
			allEventsDataFrame = allEventsDataFrame.RemoveColumns(mergedColumns.("_" + _));
			}
	}		}
	}		}

Ollvihe: /* Create object-centric model datatables */

2025-11-04T08:24:54Z

Create object-centric model datatables

← Older revision		Revision as of 08:24, 4 November 2025
Line 95:		Line 95:
	let dt = Project.DatatableByName(datatableName);		let dt = Project.DatatableByName(datatableName);
	if (dt == null) {		if (dt == null) {
			WriteLog("Start creating datatable: " + datatableName);
	dt = Project.CreateDatatable(#{		dt = Project.CreateDatatable(#{
	"Name": datatableName,		"Name": datatableName,
Line 349:		Line 350:
	}		}

			WriteLog("Start importing Objects table");
	importDataframeToDatatable(modelObject.Configuration.OcelDataSource.Objects, allObjectsDataFrame);		importDataframeToDatatable(modelObject.Configuration.OcelDataSource.Objects, allObjectsDataFrame);

			WriteLog("Start importing Events table");
	importDataframeToDatatable(modelObject.Configuration.OcelDataSource.Events, allEventsDataFrame);		importDataframeToDatatable(modelObject.Configuration.OcelDataSource.Events, allEventsDataFrame);

			WriteLog("Start importing EventToObject table");
	importDataframeToDatatable(modelObject.Configuration.OcelDataSource.EventToObject, allEventToObjectDataFrame);		importDataframeToDatatable(modelObject.Configuration.OcelDataSource.EventToObject, allEventToObjectDataFrame);

			WriteLog("Start importing ObjectToObject table");
	importDataframeToDatatable(modelObject.Configuration.OcelDataSource.ObjectToObject, allObjectToObjectDataFrame);		importDataframeToDatatable(modelObject.Configuration.OcelDataSource.ObjectToObject, allObjectToObjectDataFrame);
	</syntaxhighlight>		</syntaxhighlight>

Ollvihe: /* Create object-centric model datatables */

2025-10-31T17:35:39Z

Create object-centric model datatables

@@ Line 196: / Line 196: @@
      // Column("OtherColumn")
      // Concat( Column("OtherColumn"), ": ", #expr{eventTypeName} )
-     let eventTypeNameExpression = ToSqlExpression(#sql{ #expr{eventTypeName} });
+     let eventTypeNameExpression = ToSqlExpression(#sql{ #expr{ eventTypeName } });
      let eventsDataFrame = eventsDatatable
@@ Line 215: / Line 215: @@
 // Add event type tables columns as common event attributes.
 for (let i = 0; i < Count(eventTypeNames); i++) {
    let eventsDatatableName = modelObject.Configuration.OcelDataSource.EventTypes[eventTypeNames[i]];
@@ Line 232: / Line 233: @@
        .Join(eventTypeDataFrame, [COLUMN_EVENTS_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID], "leftouter")
        .RemoveColumns([COLUMN_EVENT_TYPES_EVENT_ID]);
+   }
+}