A Proposal of Standardised Data Model for Cloud Manufacturing Collaborative Networks

[EN] The growing amount of data to be handled by collaborative networks raises the need of introducing innovative solutions to fulfil the lack of affordable tools, especially for Small and Medium-Sized Enterprises, to manage and exchange data. The European H2020 Project Cloud Collaborative Manufacturing Networks develops and offers a structured data model, called Standardised Tables, as an organised framework to jointly work with existing databases to manage big data collected from different industries belonging to the CNs. The information of the Standardised Tables will be mainly used with optimisation and collaboration purposes. The paper describes an application of the Standardised Tables in one of the pilots of the aforementioned project, the automotive industry pilot, for solving the collaborative problem of a Materials Requirement Plan.The research leading to these results is in the frame of the “Cloud Collaborative Manufacturing Networks” (C2NET) project, which has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No. 636909.Andres, B.; Sanchis, R.; Poler, R.; Saari, L. (2017). A Proposal of Standardised Data Model for Cloud Manufacturing Collaborative Networks. IFIP Advances in Information and Communication Technology. 560:77-85. https://doi.org/10.1007/978-3-319-65151-4_7S7785560Andres, B., Poler, R.: Models, guidelines and tools for the integration of collaborative processes in non-hierarchical manufacturing networks: a review. Int. J. Comput. Integr. Manuf. 2(29), 166–201 (2016)Zikopoulos, P., Eaton, C.: Understanding Big Data: Analytics for Enterprise Class Hadoop and Streaming Data. McGraw-Hill Osborne Media, New York (2011)Zhou, B., Wang, S., Xi, L.: Data model design for manufacturing execution system. J. Manuf. Technol. Manag. 16(8), 909–935 (2005)Steven, W.: Getting the MES model – methods for system analysis. ISA Trans. 35(2), 95–103 (1996)Reda, A.: Extracting the extended entity-relationship model from a legacy relational database. Inf. Syst. 28(6), 597–618 (2003)Teorey, T.J., Yang, D., Fry, J.P.: A logical design methodology for relational database using the extended entity-relationship model. ACM Comput. Surv. 18(2), 197–222 (1986)Victor, M., Arie, S.: Representing extended entity-relationship structures in relational databases: a modular approach. ACM Trans. Database Syst. 17(3), 423–464 (1992)CORDIS Europa, Factories of the Future, H2020-EU.2.1.5.1. - Technologies for Factories of the Future (2014)H2020 Project C2NET (2015). http://cordis.europa.eu/project/rcn/193440_en.htmlAndres, B., Sanchis, R., Poler, R.: A cloud platform to support collaboration in supply networks. Int. J. Prod. Manag. Eng. 4(1), 5–13 (2016)APICS, “SCOR Framework,” Supply Chain Operations Reference model (SCOR) (2017)Orbegozo, A., Andres, B., Mula, J., Lauras, M., Monteiro, C., Malheiro, M.: An overview of optimization models for integrated replenishment and producction planning decisions. In: Building Bridges Between Researchers and Practitioners. Book of Abstracts of the International Joint Conference CIO-ICIEOM-IISE-AIM (IJC2016), p. 68 (2016)Andres, B., Poler, R., Saari, L., Arana, J., Benaches, J.V., Salazar, J.: Optimization models to support decision-making in collaborative networks: a review. In: Building Bridges Between Researchers and Practitioners. Book of Abstracts of the International Joint Conference CIO-ICIEOM-IISE-AIM (IJC2016), p. 70 (2016)Andres, B., Sanchis, R., Lamothe, J., Saari, L., Hauser, F.: Combined models for production and distribution planning in a supply chain. In: Building Bridges Between Researchers and Practitioners. Book of Abstracts of the International Joint Conference CIO-ICIEOM-IISE-AIM (IJC2016), p. 71 (2016

Formalization of the classification pattern: Survey of classification modeling in information systems engineering

Formalization is becoming more common in all stages of the development of information systems, as a better understanding of its benefits emerges. Classification systems are ubiquitous, no more so than in domain modeling. The classification pattern that underlies these systems provides a good case study of the move towards formalization in part because it illustrates some of the barriers to formalization; including the formal complexity of the pattern and the ontological issues surrounding the ‘one and the many’. Powersets are a way of characterizing the (complex) formal structure of the classification pattern and their formalization has been extensively studied in mathematics since Cantor’s work in the late 19th century. One can use this formalization to develop a useful benchmark. There are various communities within Information Systems Engineering (ISE) that are gradually working towards a formalization of the classification pattern. However, for most of these communities this work is incomplete, in that they have not yet arrived at a solution with the expressiveness of the powerset benchmark. This contrasts with the early smooth adoption of powerset by other Information Systems communities to, for example, formalize relations. One way of understanding the varying rates of adoption is recognizing that the different communities have different historical baggage. Many conceptual modeling communities emerged from work done on database design and this creates hurdles to the adoption of the high level of expressiveness of powersets. Another relevant factor is that these communities also often feel, particularly in the case of domain modeling, a responsibility to explain the semantics of whatever formal structures they adopt. This paper aims to make sense of the formalization of the classification pattern in ISE and surveys its history through the literature; starting from the relevant theoretical works of the mathematical literature and gradually shifting focus to the ISE literature. The literature survey follows the evolution of ISE’s understanding of how to formalize the classification pattern. The various proposals are assessed using the classical example of classification; the Linnaean taxonomy formalized using powersets as a benchmark for formal expressiveness. The broad conclusion of the survey is that (1) the ISE community is currently in the early stages of the process of understanding how to formalize the classification pattern, particularly in the requirements for expressiveness exemplified by powersets and (2) that there is an opportunity to intervene and speed up the process of adoption by clarifying this expressiveness. Given the central place that the classification pattern has in domain modeling, this intervention has the potential to lead to significant improvements.The UK Engineering and Physical Sciences Research Council (grant EP/K009923/1)

Relationship Abstractions for an Effective Hypertext Design: Augmentation and Globalization

ions for an Effective Hypertext Design: Augmentation and Globalization Yoshinori Hara Arthur M. Keller y Gio Wiederhold z NEC Corporation Advanced Decision Systems and and Stanford University x Stanford University x Stanford University x Abstract Data abstractions, i.e., aggregation and generalization, are useful for representing complex objects effectively. They provide high level semantic constraints as well as extend the capabilities of entity description in the E-R model. However, corresponding concepts of relationship abstraction are not directly available, particularly in hypertext systems. We propose two types of relationship abstractions, augmentation and globalization, aiming at the improvement of relationship design phases. The former is an abstraction which turns information held in relationships into that of attributes for existing entities. The latter is an abstraction which generates global-to-local relationship hierarchies. We show the advantages of these a..

Quantifying the impact of EER modeling on relational database success : an experimental investigation

Despite the widespread idea in literature that the inclusion of EER modeling in the design process of a relational database is beneficial for the success of that database, almost no quantitative cost-benefit analyses of EER modeling exist today to support this statement. In order to fill this need, an empirical study is performed in which the success of a relational database of which the design process contains an EER modeling phase is compared to the success of a relational database in which only the minimally needed design effort was put. Hereby, database success is treated as originally proposed by the DeLone and McLean Information Systems Success Model, by specifically focusing on the information quality and system quality of both databases. To this end, respectively, the total amount of time that is needed by an end user to complete a set of tasks by using the database, and the total execution cost that is needed by the database system before a correct solution to each task is submitted, is analyzed. Moreover, the work accounts for the possible moderation of the technical competence of an end user in the relationship between EER modeling and the success of the eventual relational database. Preliminary results indicate that the inclusion of EER modeling in relational database design significantly highers the perceived information quality and system quality of that database. Moreover, there is statistical evidence that this result is independent of the competence profile of that user

INCOME/WF - A Petri Net Based Approach to Workflow Management

Flexibility of process support is a key requirement for current and future business applications. A technology which is designed to flexibly support various kinds of processes are workflow management systems. In this paper we present INCOME/WF - a prototype of a workflow management system based on high-level Petri nets as workflow modelling and execution language. Important requirements for INCOME/WF are easily adjustable workflow schemes and support for unstructured or weakly structured activities. Both requirements are not yet sufficiently fulfilled by existing WFMS. 1 Introduction For almost thirty years database supported information systems have been used to implement numerous business application systems. Traditional database supported application systems in industry, business or public administration aim at the support of repetitive, non-creative activities. Recently, there is an increasing demand for systems which support unstructured or weakly structured creative "human-orie..