Modeling the Order Management Process at Dubliner Irish Pub Using SQL and Object-Process Methodology

Hazal Mentes, BSc

Diplomová práce

Abstract:

This diploma thesis examines the deficiency of formal process documentation in restaurant order management by utilizing ISO 19450:2024 Object-Process Methodology (OPM) and SQL-based data prototyping at the Dubliner Irish Pub in Prague. The pub has 40 tables and eight staff members on each shift, and it uses the R-Keeper POS system. It has problems with its operations that happen again and again, such as mixing up orders, long wait times, and gaps in communication during busy times. The OpCloud platform was used to make a seven-diagram OPM model that breaks down the Order Management process into five main sub-processes (Table Seating, Order Placing, Order Preparing, Order Serving, Payment Processing) and fifteen lower-level sub-processes. The model has three stateful objects: Customer (9 states), Order (5 states), and Table (4 states). It also has six informational objects and four different agent roles: Host, Waiter, Chef, and POS System. Using DB Fiddle, we tested an eleven-table SQL prototype that was based on the OPM model in a MySQL environment. Eight verification queries confirmed that the OPM model and the SQL schema were fully in sync. All 17 state transitions were correctly recorded, the order routing between the kitchen and the bar was checked, and all agent assignments matched the model specifications. The results show how complicated everyday restaurant work can be, with multiple agent handoffs as possible points of failure and the Waiter as the role with the most work. Four suggestions were made: using mobile POS systems, keeping track of order status in real time, optimizing staffing during busy times, and using analytics based on processes. The study is the first known use of OPM in the hospitality industry and introduces the process_log table as a new way to connect conceptual process modeling and relational database design.

Keywords

Service System, Process Visualization, OpCloud, Order Handling Process

Jazyk práce: angličtina

Datum vytvoření / odevzdání či podání práce: 3. 4. 2026

Obhajoba závěrečné práce

• Vedoucí: doc. Ing. Vojtěch Merunka, Ph.D.
• Oponent: Josef Pospíšil, externi

Česká zemědělská univerzita v Praze

Provozně ekonomická fakulta

Magisterský studijní program:
Informatics