Create Object-centric Model from Relational Schema - Revision history

Ollvihe: /* Create Objects, Events, ObjectToObject, and EventToObject datatables */

2026-06-25T17:28:30Z

Create Objects, Events, ObjectToObject, and EventToObject datatables

Ollvihe: /* Create ObjectsTypes and EventTypes datatables */

2026-06-25T17:27:22Z

Create ObjectsTypes and EventTypes datatables

← Older revision		Revision as of 17:27, 25 June 2026
Line 65:		Line 65:

	function createDatatableWithIdColumn(datatableName, idColumnName) {		function createDatatableWithIdColumn(datatableName, idColumnName) {
			WriteLog("Creating datatable: " + datatableName);
	let sourceDatatable = sourceProject.DatatableByName(datatableName);		let sourceDatatable = sourceProject.DatatableByName(datatableName);
	let sourceDatatableName = sourceDatatable.Name;		let sourceDatatableName = sourceDatatable.Name;
	let sourcePrimaryKey = sourceDatatable.PrimaryKey;		let sourcePrimaryKey = sourceDatatable.PrimaryKey;
	let sourceDataframe = sourceDatatable.SqlDataFrame;
	~~if (Count(sourcePrimaryKey) == 1) {~~		let sourceDataframe = sourceDatatable.SqlDataFrame
	~~sourceDataframe = sourceDataframe~~		.WithColumn(idColumnName, #expr{ ToSqlExpression("Concat(" + StringJoin(", \"-\", ", Concat(ToJson(sourceDatatableName), sourcePrimaryKey.("Column(" + ToJson(_) + ")"))) + ")") })
	.WithColumn(idColumnName, ~~Concat(~~#expr{~~sourceDatatableName}~~, "-", ~~Column~~(~~sourcePrimaryKey[0]~~)~~));~~		.Where(Column(#expr{idColumnName}) != null);
	~~} else if (Count(~~sourcePrimaryKey~~) == 2) {~~
	~~sourceDataframe = sourceDataframe~~
	.~~WithColumn~~(~~idColumnName, Concat~~(~~#expr{sourceDatatableName},~~ "~~-", Column~~(~~sourcePrimaryKey[0]~~), "-"~~, Column(sourcePrimaryKey[1]~~)));
	} ~~else if (Count(sourcePrimaryKey) == 3~~) {
	~~sourceDataframe = sourceDataframe~~
	.~~WithColumn~~(~~idColumnName, Concat~~(#expr{~~sourceDatatableName~~}~~, "-", Column(sourcePrimaryKey[0]), "-", Column(sourcePrimaryKey[1]), "-", Column(sourcePrimaryKey[2])~~));
	}
	let newDatatable = importToDatatable(sourceDatatableName, sourceDataframe);		let newDatatable = importToDatatable(sourceDatatableName, sourceDataframe);
	newDatatable.SetPrimaryKey(sourcePrimaryKey);		newDatatable.SetPrimaryKey(sourcePrimaryKey);

Ollvihe: /* Create Objects, Events, ObjectToObject, and EventToObject datatables */

2026-06-22T22:40:14Z

Create Objects, Events, ObjectToObject, and EventToObject datatables

← Older revision		Revision as of 22:40, 22 June 2026
Line 242:		Line 242:
	.RenameColumns(foreignKeys[j].Columns.{ let col = _;[(TARGET_COLUMN_PREFIX + col.Target): col.Target] }[0]);		.RenameColumns(foreignKeys[j].Columns.{ let col = _;[(TARGET_COLUMN_PREFIX + col.Target): col.Target] }[0]);

	let eventsDataFrame = eventsDatatable.SqlDataFrame;		let eventsDataFrame = eventsDatatable.SqlDataFrame
	~~for (let i = 0; i < Count(foreignKeys[j].Columns); i++) {~~		.Where(#expr{ ToSqlExpression(StringJoin(" && ", Concat(foreignKeys[j].Columns.Source, [COLUMN_EVENT_TYPES_EVENT_ID]).("Column(" + ToJson(_) + ") != null")))})
	~~eventsDataFrame = eventsDataFrame~~.Where~~(Column~~(#expr{foreignKeys[j].Columns[i]~~.Source}) != null~~);
	}

	~~eventsDataFrame = eventsDataFrame~~
	.~~Where~~(Column(~~COLUMN_EVENT_TYPES_EVENT_ID~~) != null)
	.Join(objectsDataframe, foreignKeys[j].Columns.{ let col = _;[col.Source: (TARGET_COLUMN_PREFIX + col.Target)] }[0], "inner")		.Join(objectsDataframe, foreignKeys[j].Columns.{ let col = _;[col.Source: (TARGET_COLUMN_PREFIX + col.Target)] }[0], "inner")
	.RenameColumns([COLUMN_EVENTS_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID])		.RenameColumns([COLUMN_EVENTS_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID])
Line 388:		Line 383:
	.RenameColumns(foreignKeys[j].Columns.{ let col = _;[(TARGET_COLUMN_PREFIX + col.Target): col.Target] }[0]);		.RenameColumns(foreignKeys[j].Columns.{ let col = _;[(TARGET_COLUMN_PREFIX + col.Target): col.Target] }[0]);

	let eventToObjectDataFrame = eventsDatatable.SqlDataFrame;		let eventToObjectDataFrame = eventsDatatable.SqlDataFrame
	~~for (let i = 0; i < Count(foreignKeys[j].Columns); i++) {~~		.Where(#expr{ ToSqlExpression(StringJoin(" && ", Concat(foreignKeys[j].Columns.Source, [COLUMN_EVENT_TYPES_EVENT_ID]).("Column(" + ToJson(_) + ") != null")))})
	~~eventToObjectDataFrame = eventToObjectDataFrame~~.Where~~(Column~~(#expr{foreignKeys[j].Columns[i]~~.Source}) != null~~);
	}
	~~eventToObjectDataFrame = eventToObjectDataFrame~~
	.~~Where~~(Column(~~COLUMN_EVENT_TYPES_EVENT_ID~~) != null)
	.RenameColumns([COLUMN_EVENT_OBJECT_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID])		.RenameColumns([COLUMN_EVENT_OBJECT_EVENT_ID: COLUMN_EVENT_TYPES_EVENT_ID])
	.Join(objectsDataframe, foreignKeys[j].Columns.{ let col = _;[col.Source: (TARGET_COLUMN_PREFIX + col.Target)] }[0], "inner")		.Join(objectsDataframe, foreignKeys[j].Columns.{ let col = _;[col.Source: (TARGET_COLUMN_PREFIX + col.Target)] }[0], "inner")

Ollvihe: /* Create Objects, Events, ObjectToObject, and EventToObject datatables */

2026-06-22T20:18:25Z

Create Objects, Events, ObjectToObject, and EventToObject datatables

Show changes

Ollvihe: /* Model creation steps */

2026-06-22T15:39:19Z

Model creation steps

← Older revision		Revision as of 15:39, 22 June 2026
Line 20:		Line 20:
	## Define relations between the object type and event type tables using the [[Data Schema Dialog]].		## Define relations between the object type and event type tables using the [[Data Schema Dialog]].
	## Also define primary keys for each table.		## Also define primary keys for each table.
	## Validate the relational data model.		## [[#Validate_schema\|Validate]] the relational data model.
	# Add another project for the object-centric model.		# Add another project for the object-centric model.
	## Add an [[Object-centric_Process_Mining_Model#Create_object-centric_model\|object-centric model]] to the project.		## Add an [[Object-centric_Process_Mining_Model#Create_object-centric_model\|object-centric model]] to the project.

Ollvihe: /* Model creation steps */

2026-06-22T15:38:47Z

Model creation steps

← Older revision		Revision as of 15:38, 22 June 2026
Line 20:		Line 20:
	## Define relations between the object type and event type tables using the [[Data Schema Dialog]].		## Define relations between the object type and event type tables using the [[Data Schema Dialog]].
	## Also define primary keys for each table.		## Also define primary keys for each table.
			## Validate the relational data model.
	# Add another project for the object-centric model.		# Add another project for the object-centric model.
	## Add an [[Object-centric_Process_Mining_Model#Create_object-centric_model\|object-centric model]] to the project.		## Add an [[Object-centric_Process_Mining_Model#Create_object-centric_model\|object-centric model]] to the project.
	## Define the previously created tables as the ''Object types'' and ''Event types'' tables to the [[Object-centric_Process_Mining_Model#Configure_object-centric_model\|object-centric model settings]] .		## Define the previously created tables as the ''Object types'' and ''Event types'' tables to the [[Object-centric_Process_Mining_Model#Configure_object-centric_model\|object-centric model settings]].
	## Define names for the ''Objects'', ''Events'', ''ObjectToObject'', and ''EventToObject'' datatables.		## Define names for the ''Objects'', ''Events'', ''ObjectToObject'', and ''EventToObject'' datatables.
	## Add and run script to [[#Create_ObjectsTypes_and_EventTypes_datatables\|create ObjectsTypes and EventTypes datatables]] from the source datatables .		## Add and run script to [[#Create_ObjectsTypes_and_EventTypes_datatables\|create ObjectsTypes and EventTypes datatables]] from the source datatables .

Ollvihe: /* Model creation steps */

2026-06-22T15:37:44Z

Model creation steps

← Older revision		Revision as of 15:37, 22 June 2026
Line 15:		Line 15:

	== Model creation steps ==		== Model creation steps ==
	To create an object-centric model, ~~proceed as follows~~:		To create an object-centric model, follow these steps:
	# Add a project ~~to QPR ProcessAnalyzer~~ for the source datatables.		# Add a project for the source datatables.
	## Add the source data as datatables.		## Add the source data as datatables.
	## Define relations between the object type and event type tables using the [[Data Schema Dialog]].		## Define relations between the object type and event type tables using the [[Data Schema Dialog]].

Ollvihe: /* Create ObjectsTypes and EventTypes datatables */

2026-06-21T01:15:51Z

Create ObjectsTypes and EventTypes datatables

← Older revision		Revision as of 01:15, 21 June 2026
Line 34:		Line 34:

	<syntaxhighlight lang="typescript" line>		<syntaxhighlight lang="typescript" line>
	let sourceProject = ProjectByName("~~Source~~ data ~~project~~");		let sourceProject = ProjectByName("SAP data - dates converted");
	~~let targetProject = Project~~;

	let modelObject = Project.Models.Where(IsOcelModel);		let modelObject = Project.Models.Where(IsOcelModel);
Line 48:		Line 47:

	function getDatatableAndCreateIfNeeded(datatableName) {		function getDatatableAndCreateIfNeeded(datatableName) {
	let dt = ~~targetProject~~.DatatableByName(datatableName);		let dt = Project.DatatableByName(datatableName);
	if (dt == null) {		if (dt == null) {
	dt = ~~targetProject~~.CreateDatatable(#{		dt = Project.CreateDatatable(#{
	"Name": datatableName,		"Name": datatableName,
	"Type": "Snowflake"		"Type": "Snowflake"
Line 98:		Line 97:
	let datatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;		let datatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;
	let sourceDatatable = sourceProject.DatatableByName(datatableName);		let sourceDatatable = sourceProject.DatatableByName(datatableName);
	~~targetProject~~.DatatableByName(datatableName).SetForeignKeys(sourceDatatable.ForeignKeys);		Project.DatatableByName(datatableName).SetForeignKeys(sourceDatatable.ForeignKeys);
	}		}
	for (let i = 0; i < Count(eventTypeNames); i++) {		for (let i = 0; i < Count(eventTypeNames); i++) {
	let datatableName = modelObject.Configuration.OcelDataSource.EventTypes[eventTypeNames[i]];		let datatableName = modelObject.Configuration.OcelDataSource.EventTypes[eventTypeNames[i]];
	let sourceDatatable = sourceProject.DatatableByName(datatableName);		let sourceDatatable = sourceProject.DatatableByName(datatableName);
	~~targetProject~~.DatatableByName(datatableName).SetForeignKeys(sourceDatatable.ForeignKeys);		Project.DatatableByName(datatableName).SetForeignKeys(sourceDatatable.ForeignKeys);
	}		}
	</syntaxhighlight>		</syntaxhighlight>

Ollvihe: /* Create ObjectsTypes and EventTypes datatables */

2026-06-21T01:14:46Z

Create ObjectsTypes and EventTypes datatables

← Older revision		Revision as of 01:14, 21 June 2026
Line 31:		Line 31:

	== Create ObjectsTypes and EventTypes datatables ==		== Create ObjectsTypes and EventTypes datatables ==
			This script will create the ObjectsTypes and EventTypes tables to the project containing the object-centric model from the configured source project (in the first line of the script).

	<syntaxhighlight lang="typescript" line>		<syntaxhighlight lang="typescript" line>

Ollvihe: /* Model creation steps */

2026-06-21T01:13:48Z

Model creation steps

← Older revision		Revision as of 01:13, 21 June 2026
Line 25:		Line 25:
	## Define names for the ''Objects'', ''Events'', ''ObjectToObject'', and ''EventToObject'' datatables.		## Define names for the ''Objects'', ''Events'', ''ObjectToObject'', and ''EventToObject'' datatables.
	## Add and run script to [[#Create_ObjectsTypes_and_EventTypes_datatables\|create ObjectsTypes and EventTypes datatables]] from the source datatables .		## Add and run script to [[#Create_ObjectsTypes_and_EventTypes_datatables\|create ObjectsTypes and EventTypes datatables]] from the source datatables .
	## Add and run script to [[#Create_Objects,_Events,_ObjectToObject,_and_EventToObject_datatables\|create Objects, Events, ObjectToObject, and EventToObject datatables]].		## Add and run another script to [[#Create_Objects,_Events,_ObjectToObject,_and_EventToObject_datatables\|create Objects, Events, ObjectToObject, and EventToObject datatables]].

	== Validate schema ==		== Validate schema ==

← Older revision		Revision as of 17:28, 25 June 2026
Line 153:		Line 153:
	createOrGetDatatable(modelObject.Configuration.OcelDataSource.ObjectToObject).Truncate();		createOrGetDatatable(modelObject.Configuration.OcelDataSource.ObjectToObject).Truncate();

	WriteLog("Add to Objects table from ObjectTypes tables");		WriteLog("1. Add to Objects table from ObjectTypes tables");
	let objectTypeNames = modelObject.Configuration.OcelDataSource.ObjectTypes.Keys;		let objectTypeNames = modelObject.Configuration.OcelDataSource.ObjectTypes.Keys;
	let objectsDatatableNames = objectTypeNames.{		let objectsDatatableNames = objectTypeNames.{
Line 175:		Line 175:
	}		}

	WriteLog("Add to Events table from ObjectTypes tables");		WriteLog("2. Add to Events table from ObjectTypes tables");
	for (let i = 0; i < Count(objectTypeNames); i++) {		for (let i = 0; i < Count(objectTypeNames); i++) {
	let objectTypeName = objectTypeNames[i];		let objectTypeName = objectTypeNames[i];
Line 188:		Line 188:
	.Select([COLUMN_OBJECT_TYPES_OBJECT_ID, #expr{ dateColumn }])		.Select([COLUMN_OBJECT_TYPES_OBJECT_ID, #expr{ dateColumn }])
	.WithColumn(COLUMN_EVENTS_EVENT_ID, Concat(Column(COLUMN_OBJECT_TYPES_OBJECT_ID), "_", #expr{ dateColumn }))		.WithColumn(COLUMN_EVENTS_EVENT_ID, Concat(Column(COLUMN_OBJECT_TYPES_OBJECT_ID), "_", #expr{ dateColumn }))
	.WithColumn(COLUMN_EVENTS_TYPE, #expr{ dateColumn })		.WithColumn(COLUMN_EVENTS_TYPE, #expr{ objectTypeNames[i] + " - " + dateColumn })
	.RenameColumns([COLUMN_EVENTS_TIME: #expr{ dateColumn }])		.RenameColumns([COLUMN_EVENTS_TIME: #expr{ dateColumn }])
	.WithColumn(COLUMN_OBJECT_TYPE, #expr{ objectTypeName })		.WithColumn(COLUMN_OBJECT_TYPE, #expr{ objectTypeName })
Line 198:		Line 198:
	}		}

	WriteLog("Add to Events table from EventTypes tables");		WriteLog("3. Add to Events table from EventTypes tables");
	let eventTypeNames = modelObject.Configuration.OcelDataSource.TryGetValue("EventTypes").Keys;		let eventTypeNames = modelObject.Configuration.OcelDataSource.TryGetValue("EventTypes").Keys;
	for (let i = 0; i < Count(eventTypeNames); i++) {		for (let i = 0; i < Count(eventTypeNames); i++) {
Line 251:		Line 251:
	}		}

	WriteLog("Add event type tables columns as common event attributes");		WriteLog("4. Add event type tables columns as common event attributes");
	let commonEventColumns = Project.DatatableByName(modelObject.Configuration.OcelDataSource.Events).Columns.Name;		let commonEventColumns = Project.DatatableByName(modelObject.Configuration.OcelDataSource.Events).Columns.Name;
	for (let i = 0; i < Count(eventTypeNames); i++) {		for (let i = 0; i < Count(eventTypeNames); i++) {
Line 302:		Line 302:
	}		}

	WriteLog("Add object attributes as common event attributes");		WriteLog("5. 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.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;		let objectsDatatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;
Line 348:		Line 348:
	}		}

	WriteLog("Add to Event-to-Object table from ObjectTypes tables");		WriteLog("6. Add 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.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;		let objectsDatatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;
Line 368:		Line 368:
	}		}

	WriteLog("Add to Event-to-Object table from EventTypes tables");		WriteLog("7. Add to Event-to-Object table from EventTypes tables");
	for (let i = 0; i < Count(eventTypeNames); i++) {		for (let i = 0; i < Count(eventTypeNames); i++) {
	let eventsDatatableName = modelObject.Configuration.OcelDataSource.EventTypes[eventTypeNames[i]];		let eventsDatatableName = modelObject.Configuration.OcelDataSource.EventTypes[eventTypeNames[i]];
Line 390:		Line 390:
	}		}

	WriteLog("Add to Object-to-object table from ObjectTypes tables");		WriteLog("8. Add to Object-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.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;		let objectsDatatableName = modelObject.OcelObjectTypeConfiguration(objectTypeNames[i]).Datatable;
Line 412:		Line 412:
	}		}

	WriteLog("Add to Object-to-object table from datatables that are not defined as ObjectTypes tables but contains N-N relation between objects");		WriteLog("9. Add to Object-to-object table from datatables that are not defined as ObjectTypes tables but contains N-N relation between objects");
	let eventsDatatableNames = modelObject.Configuration.OcelDataSource.EventTypes.Values;		let eventsDatatableNames = modelObject.Configuration.OcelDataSource.EventTypes.Values;
	let relationDatatableNames = Except(Except(Project.Datatables.Name, objectsDatatableNames), eventsDatatableNames);		let relationDatatableNames = Except(Except(Project.Datatables.Name, objectsDatatableNames), eventsDatatableNames);