ORM 2011

P11 Value Grouping Transformations in ORM

Ken Evans — Sun, 30 Oct 2011 11:20:36 GMT

Abstract. This paper proposes an extension to the Value Concatenation / Value Separation schema transformation defined for Object-Role Modeling.

The basic transformation can be applied to convert a many-to-many fact type to a functional fact type. When applied, the transformation generates a new multi-valued object type where values are derived from an existing single-valued object type.

Motivated by techniques applied in dimensional modeling applications, Value Grouping considers the various options available in the grouping process and is seen as an extension to the basic Value Concatenation / Value Separation schema transformation.

Presented by:

Ron McFadyen, University of Winnipeg (Canada)

P10 Enriched Support for Ring Constraints

Ken Evans — Sun, 30 Oct 2011 11:17:00 GMT

Abstract: Fact-oriented modeling approaches such as Object-Role Modeling (ORM) have long supported several varieties of ring constraints, such as irreflexivity, asymmetry, intransitivity, and acyclicity, on pairs of compatible roles. The latest version of the Web Ontology Language (OWL 2) supports five kinds of ring constraint on binary predicates. Recently, three more ring constraint types (local reflexivity, strong intransitivity, and transitivity) were added to ORM.

This paper discusses these new additions to ORM, as implemented in the Natural ORM Architect (NORMA) tool, and identifies important ways in which ORM and OWL differ in their support for ring constraints, while noting different mapping alternatives.

We determine which combinations of elements from this expanded set of ring constraints are permitted, and provide verbalization patterns for the new additions. Graphical shapes for the new constraints and constraint combinations are introduced and motivated, and NORMA's new user interface for entry of ring constraints is illustrated.

Presented by:

Terry Halpin, LogicBlox (USA) and INTI International University (Malaysia)
Matthew Curland, LogicBlox (USA)

P00 Welcome and Introduction of Participants

Ken Evans — Sun, 30 Oct 2011 11:12:27 GMT

These are the slides used for opening the workshop.

Presented by : Terry Halpin

P03 Roles in ORM: A Suggested Semantics

Ken Evans — Thu, 27 Oct 2011 13:39:33 GMT

Abstract: Evidence grows that ORM has some problems to overcome in order to escape the charge that it cannot reliably lead, as claimed, to ONF (optimal normal form) relational schemas. Some of that evidence we present here. We also indicate that there is more than one way to address the issue effectively, thus saving ORM's reputation as a generator of fully normalized relational schemas. But of two ways mentioned, the more satisfactory one involves, essentially, ascribing a certain semantics to the idea of "role-playing" in ORM. We show how it would address these issues, and why it is the better approach.

Presented by:

Andy Carver, INTI International University (Malaysia)

P00 ORM 2011 Workshop Programme

Ken Evans — Wed, 26 Oct 2011 14:53:09 GMT

This is the agenda that was used at ORM 2011

P15: Directly Applied ORM Constraints for Validating and Verifying Semantic Decision Tables

Ken Evans — Wed, 26 Oct 2011 14:51:11 GMT

Abstract: A semantic decision table (SDT) is a decision table properly annotated with domain ontologies. In this paper, we focus on validation and verification issues (V&V) for SDT. We use Semantic Decision Rule Language (SDRule-L), which is an extension to the Object-Role Modeling language (ORM/ORM2) for modeling SDT commitments. With these commitments, business rule modelers can discover invalid decision rules. In this paper, we focus on how to use six SDRule-L constraints, which are directly brought from ORM/ORM2. Our approach focuses on detecting invalid rules within one table.

Presented by:

Yan Tang, Vrije Universiteit Brussel (Belgium)

P14 A Dialogue Game Prototype for FCO-IM

Ken Evans — Wed, 26 Oct 2011 14:48:22 GMT

Abstract. We report on the development of a prototype dialogue game for FCO-IM. Dialogue games are systems for executing controlled conversations. As part of an ongoing effort to analyze and support collaborative modeling processes by means of dialogue games, we created a dialogue game prototype for essential parts of the FCO-IM modeling process. The project was exploratory in nature, but results suggest that eventually it should be possible to develop dialogue games that could effectively support fact-based conceptual modeling efforts. In addition, work on such games enhances our insights in the FCO-IM modeling process, and leads to improvements and extensions of its operational guidelines.

Presented by:

Stijn Hoppenbrouwers, Radboud University Nijmegen, (The Netherlands)
Jan Pieter Zwart, HAN University of Applied Sciences (The Netherlands)
Albert Pratama Jemmi Oscar, HAN University of Applied Sciences (The Netherlands)
Dimas Listianto Adisuryo, HAN University of Applied Sciences (The Netherlands)

P13 A Derivation Procedure for Set-comparison Constraints in Fact-based Modeling

Ken Evans — Wed, 26 Oct 2011 14:45:46 GMT

Abstract. In this paper we will address the conceptual schema design procedure (CSDP) in fact-based modeling. We will focus on the modeling procedure of ‘cook-book' for deriving set-comparison constraints. We will give an algorithm that can be applied by an analyst in an analyst-user dialogue in which all set-comparison constraints can be derived as a result of the acceptance or rejection of real-life user examples by the domain expert.

Presented by:

Peter Bollen, Maastricht University (The Netherlands)

P12 Modeling Ontologies with Collibra

Ken Evans — Wed, 26 Oct 2011 14:42:51 GMT

This is a presentation of the Collibra ontology modeling tool.

Presenter:

Christophe DeBruyne, Vrije Universiteit Brussel (Belgium)

Note: The original file is a 9MB PDF file. This has been compressed using the .rar format.

P09 Enterprise Data Architecture: Development Scenarios Using ORM

Ken Evans — Wed, 26 Oct 2011 14:28:18 GMT

Abstract: This paper describes the enterprise wide use of ORM to drive individual project development through requirements, design, construction, and implementation process using SDLC practices within Boston Scientific. Components used to construct, track, administer, and manage data models using nORMa for conceptual data models and interfaces to an industry standard tool for the logical and physical data models are laid out in one of the three following scenarios: 1) New customized application development, 2) OTSS configuration and customization (Off the Shelf System), and 3) Reverse Engineering Existing Applications. This paper illustrates how the second scenario "OTSS configuration and customization" leverages Object Role Modeling to provide the data architect with a fact based conceptual model that is integrated with a business glossary. The ultimate goal is to provide a common understanding of the business at a conceptual level and at the same time provide a comprehensive and deep ‘where used' capability that supports a variety of common functions for Data Architects at the Enterprise level and Data Architects at the Project level.

Presented by:

Necito dela Cruz, Boston Scientific Corporation (USA)
Mary Tobin, Boston Scientific Corporation (USA)
Gabe Schenz, Boston Scientific Corporation (USA)
*** Barden, Boston Scientific Corporation (USA)

P08 A Metamodel for Orchestrating Service Requirements in an SQL-environment

Ken Evans — Wed, 26 Oct 2011 14:25:20 GMT

Abstract. Orchestration and Choreography often form the fundamental backbone for delivery of services in a Service Oriented Architecture (SOA). In a service based application environment, services need to be able to manipulate persistent data---usually in a stable structured SQL-environment. These service requests to data access services should not be one-of or tailor-made. They need to be reusable. The realization of the dynamic service orchestration requirements often necessitates a corresponding requirement for dynamic on-demand assembly of SQL-modules consisting of re-usable stored procedure modules, User Defined Functions, and including dynamic SQL stored procedures. An ORM/NIAM metamodel is shown that can support the realization of a "provider" model that is able to dynamically assemble the SQL-implementation components to form an SQL-implementation orchestration model to satisfy the dynamic requirements of the service based orchestrations. The implementation of this model is parameter driven, thus allowing provider component-sets to replace individually tailored modules for SQL data manipulation.

Presented by:

Baba Piprani, MetaGlobal Systems (Canada)
Suneil Dham, Office of the Superintendent of Financial Systems (Canada)

P07 ORM and Retirement of Outdated Business System

Ken Evans — Wed, 26 Oct 2011 14:23:01 GMT

Abstract: The use of Access 97 and Excel 2003 workbooks led to a high risk environment for the Global Supply functional pillar within Boston Scientific. Without making a change to the current system, Boston Scientific would not be able to implement a 3.6 million dollar savings per year cost reduction program in 2009. A retirement of complete collection of 55 Excel workbooks along with a 256 tiered Access 97 database system, incorporating dependent primary queries with many sub-queries, was required. To achieve the project goals, ORM was used to capture data requirements and all the related business rules. The ORM process showed the data gaps that were present in the current supply chain processes which allowed for a 20% mapping failure in the reporting. ORM also provided a more robust schema for product mapping in the reporting structure saving the company $300, 000.00 per year of the next five years.

Presented by:

Chad Sevre, Boston Scientific Corporation (USA)
Necito dela Cruz, Boston Scientific Corporation (USA)
Tor Westgard, Boston Scientific Corporation (USA)

P04 Formal Specification of a Meta Hierarchical Logical Data Model using Object Role Modeling

Ken Evans — Wed, 26 Oct 2011 14:19:44 GMT

Abstract. In the past, numerous ways have been presented of mapping Object Role Modeling (ORM) conceptual schemas to relational logical schemas. However, mapping to hierarchical logical schemas has received little attention. This is unfortunate, since hierarchical logical schemas can be used to acquire physical schemas, like hierarchical DDL or XSD documents, along the lines of a three-level data modeling architecture. Given that hierarchical databases still exist abundantly in industrial practice, mapping ORM conceptual schemas to hierarchical logical schemas can be very relevant. A meta model description of a hierarchical logical data model offers a formal basis for defining such a mapping. We note that a hierarchical logical data model, as well as a meta model to which it should conform, is often described only informally in literature, particularly lacking a formal meta model specification. In this paper, we present a formal specification of a meta hierarchical logical data model using ORM.

Presented by:

Robert Schmaal, European Space Research and Technology Centre (The Netherlands)

Herman Balsters, University of Groningen (The Netherlands)Serge Valera, European Space Research and Technology Centre (The Netherlands)

P02 Modeling Slowly Changing Dimensions in ORM

Ken Evans — Wed, 26 Oct 2011 14:17:43 GMT

Abstract. A data warehouse is a subject oriented, integrated, non-volatile, and time variant collection of data in support of management's decisions. Dimensional modeling is a design technique used extensively in the design and construction of data warehouses. To account for different requirements there are several standard variations designers may utilize in their dimensional designs such as outriggers, bridge tables, mini-dimensions, slowly changing dimension techniques, etc. Our focus in this paper is on the representation of the dimensional schema as an ORM schema where slowly changing dimension techniques Types 1 and 2 are used. We examine the nature of the ORM schema - its objects, roles, constraints, rules and transactions.

Presented by:

Ron McFadyen, University of Winnipeg (Canada)

P01 An Advanced Generation Model for a Security Data Warehouse

Ken Evans — Wed, 26 Oct 2011 14:15:16 GMT

Abstract. With all the modernistic web based tools available today, it is ironic that managing a security program in an organization is often relegated to a paper-pencil exercise using outdated information, with an on-going guessing game as to the status and inventory of installed controls, equipment configurations etc. Tracking the incessant onslaught of security breach attempts occurring at an ever increasing pace often is a nightmare. A Fact Based model along with a process model is presented here as a candidate for security information to be contained in a BI-style security Data Warehouse, detailing the primary facts and artifacts of an organization’s security program framework and security strategy. The model enables one to draw intelligence from security events, current state of security management and training, risk communication, security architecture and administration controls in place, standards being followed etc., and essentially promotes the concept of availability of security intelligence---data warehouse style.

Presented by:

Baba Piprani, MetaGlobal Systems (Canada)

Denise Ernst, Canadian Payments Association (Canada