Create Object-centric Model from Relational Schema - Revision history

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

2026-04-17T11:40:11Z

Create object-centric model datatables

← Older revision		Revision as of 11:40, 17 April 2026
Line 186:		Line 186:
	let objectsDatatableNames = objectTypeNames.{		let objectsDatatableNames = objectTypeNames.{
	let objectTypeName = _;		let objectTypeName = _;
	~~return~~ modelObject.OcelObjectTypeConfiguration(objectTypeName).Datatable;		modelObject.OcelObjectTypeConfiguration(objectTypeName).Datatable;
	};		};
	if (!objectsTable.In(objectsDatatableNames)) {		if (!objectsTable.In(objectsDatatableNames)) {

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

2026-04-17T09:26:10Z

Create object-centric model datatables

← Older revision		Revision as of 09:26, 17 April 2026
Line 121:		Line 121:
	let objectTypeNames = modelObject.Configuration.OcelDataSource.ObjectTypes.Keys;		let objectTypeNames = modelObject.Configuration.OcelDataSource.ObjectTypes.Keys;
	for (let i = 0; i < Count(objectTypeNames); i++) {		for (let i = 0; i < Count(objectTypeNames); i++) {
	let objectsDatatableName = modelObject.~~Configuration.OcelDataSource.ObjectTypes[~~objectTypeNames[i]];		let objectsDatatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;
	let objectsDatatable = Project.DatatableByName(objectsDatatableName);		let objectsDatatable = Project.DatatableByName(objectsDatatableName);
	if (Count(objectsDatatable.Columns.Where(Name == COLUMN_OBJECT_TYPES_OBJECT_ID)) == 0) {		if (Count(objectsDatatable.Columns.Where(Name == COLUMN_OBJECT_TYPES_OBJECT_ID)) == 0) {
Line 139:		Line 139:
	for (let i = 0; i < Count(objectTypeNames); i++) {		for (let i = 0; i < Count(objectTypeNames); i++) {
	let objectTypeName = objectTypeNames[i];		let objectTypeName = objectTypeNames[i];
	let objectsDatatableName = modelObject.~~Configuration~~.~~OcelDataSource.ObjectTypes[objectTypeName]~~;		let objectsDatatableName = modelObject.OcelObjectTypeConfiguration(objectTypeName).Datatable;
	let objectsDatatable = Project.DatatableByName(objectsDatatableName);		let objectsDatatable = Project.DatatableByName(objectsDatatableName);
	let dateColumns = objectsDatatable.Columns.Where(DataType == "DateTime").Name;		let dateColumns = objectsDatatable.Columns.Where(DataType == "DateTime").Name;
Line 184:		Line 184:
	let sourceColumn = foreignKeys[j].Columns[0].Source;		let sourceColumn = foreignKeys[j].Columns[0].Source;
	let targetColumn = foreignKeys[j].Columns[0].Target;		let targetColumn = foreignKeys[j].Columns[0].Target;
	let objectsDatatableNames = modelObject.~~Configuration.OcelDataSource.ObjectTypes~~.~~Values~~;		let objectsDatatableNames = objectTypeNames.{
			let objectTypeName = _;
			return modelObject.OcelObjectTypeConfiguration(objectTypeName).Datatable;
			};
	if (!objectsTable.In(objectsDatatableNames)) {		if (!objectsTable.In(objectsDatatableNames)) {
	throw "Foreign key in the EventTypes datatable \"" + eventsDatatableName + "\" is not referring to an object type table.";		throw "Foreign key in the EventTypes datatable \"" + eventsDatatableName + "\" is not referring to an object type table.";
Line 201:		Line 204:
	let objectTypeName;		let objectTypeName;
	for (let i = 0; i < Count(objectTypeNames); i++) {		for (let i = 0; i < Count(objectTypeNames); i++) {
	if (modelObject.~~Configuration.OcelDataSource.ObjectTypes.Get~~(objectTypeNames[i]) == objectsTable) {		if (modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable == objectsTable) {
	objectTypeName = objectTypeNames[i];		objectTypeName = objectTypeNames[i];
	break;		break;
Line 274:		Line 277:
	WriteLog("Add object attributes as common event attributes");		WriteLog("Add object attributes as common event attributes");
	for (let i = 0; i < Count(objectTypeNames); i++) {		for (let i = 0; i < Count(objectTypeNames); i++) {
	let objectsDatatableName = modelObject.~~Configuration.OcelDataSource.ObjectTypes[~~objectTypeNames[i]];		let objectsDatatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;
	let objectsDatatable = Project.DatatableByName(objectsDatatableName);		let objectsDatatable = Project.DatatableByName(objectsDatatableName);
	let dateColumns = objectsDatatable.Columns.Where(DataType == "DateTime").Name;		let dateColumns = objectsDatatable.Columns.Where(DataType == "DateTime").Name;
Line 320:		Line 323:
	WriteLog("Add data to Event-to-Object table from ObjectTypes tables");		WriteLog("Add data to Event-to-Object table from ObjectTypes tables");
	for (let i = 0; i < Count(objectTypeNames); i++) {		for (let i = 0; i < Count(objectTypeNames); i++) {
	let objectsDatatableName = modelObject.~~Configuration.OcelDataSource.ObjectTypes[~~objectTypeNames[i]];		let objectsDatatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;
	let objectsDatatable = Project.DatatableByName(objectsDatatableName);		let objectsDatatable = Project.DatatableByName(objectsDatatableName);
	let dateColumns = objectsDatatable.Columns.Where(DataType == "DateTime").Name;		let dateColumns = objectsDatatable.Columns.Where(DataType == "DateTime").Name;
Line 360:		Line 363:
	let TARGET_COLUMN_PREFIX = "Target";		let TARGET_COLUMN_PREFIX = "Target";
	for (let i = 0; i < Count(objectTypeNames); i++) {		for (let i = 0; i < Count(objectTypeNames); i++) {
	let objectsDatatableName = modelObject.~~Configuration.OcelDataSource.ObjectTypes[~~objectTypeNames[i]];		let objectsDatatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;
	let objectsDatatable = Project.DatatableByName(objectsDatatableName);		let objectsDatatable = Project.DatatableByName(objectsDatatableName);
	let foreignKeys = objectsDatatable.ForeignKeys;		let foreignKeys = objectsDatatable.ForeignKeys;

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.("_" + _));
			}
	}		}
	}		}