Automated Mapping of Conceptual Schemas to Relational Schemas

International Journal of Information System Modeling and Design, 2010

Object-Role Modeling (ORM) is an approach for modeling and querying information at the conceptual level, and for transforming ORM models and queries to or from other representations. Unlike attribute-based approaches such as Entity-Relationship (ER) modeling and class modeling within the Unified Modeling Language (UML), ORM is fact-oriented, where all facts and rules are modeled in terms of natural sentences easily understood and validated by nontechnical business users. ORM’s modeling procedure facilitates validation by verbalization and population with concrete examples. ORM’s graphical notation is far more expressive than that of ER diagrams or UML class diagrams, and its attribute-free nature makes it more stable and adaptable to changing business requirements. This article explains the fundamentals of ORM, illustrates some of its advantages as a data modeling approach, and outlines some recent research to extend ORM, with special attention to mappings to deductive databases.

This article discusses the role of database design within the context of the database lifecycle. Design is categorised into conceptual, logical and physical. The importance of conceptual modelling is stressed. An introduction to Object Role Modelling (ORM) is presented.

Lecture Notes in Computer Science, 2000

XML is increasingly becoming the preferred method of encoding structured data for exchange over the Internet. XML-Schema, which is an emerging text-based schema definition language, promises to become the most popular method for describing these XML-documents. While text-based languages, such as XML-Schema, offer great advantages for data interchange on the Internet, graphical modelling languages are widely accepted as a more visually effective means of specifying and communicating data requirements for a human audience. With this in mind, this paper investigates the use of Object Role Modelling (ORM), a graphical, conceptual modelling technique, as a means for designing XML-Schemas. The primary benefit of using ORM is that it is much easier to get the model 'correct' by designing it in ORM first, rather than in XML. To facilitate this process we describe an algorithm that enables an XML-Schema file to be automatically generated from an ORM conceptual data model. Our approach aims to reduce data redundancy and increase the connectivity of the resulting XML instances.

Object Role Modeling (ORM) is a graphical documentation for information models. It is a useful mate to the ORM lingo for indicating component and sort definitions, associations, cardinality and connections. One of the inclinations of using ORM over other demonstrating dialect is that the structure of a data model can be displayed in a more sensible manner. In programming building the graphical representation of the product structure is exceptionally essential since comprehension of coding is extremely troublesome. Semantic Business Vocabulary Rules (SBVR) particulars numerous creators have done model to model change. SBVR2ORM is likewise conceivable. In this study we propose an ORM information model utilizing Natural dialect. That model physically actualized on two contextual analyses and produce the ORM charts utilizing SBVR rules. That graph full fills all the product necessity of the Software engineers. Model representation is extremely useful to grow extensive size of frameworks like, Aerospace, medicinal science and different commercial ventures where the representation of framework working is essential. This work is extremely useful to the Data trough and IT administrators to speak to their association structure. In this study we propose mechanized era of Object Role Model (ORM).

Journal of Database Management, 2000

We begin with a number of applications and environments in which conceptual-relational mappings are used extensively and a solution to the mapping maintenance problem will greatly benefit the applications.

Lecture Notes in Computer Science, 2008

This paper contains a brief description of the R 2 M (Role and Request Modeling) method and its supporting visual modeling CASE (Computer Assisted Software Engineering) tool. R 2 M is a modeling method for creating Conceptual Models of work systems using a combination of ontological and object-oriented concepts. Ontological principles serve to define the meaning of modeling constructs in terms of domain semantics, and to derive rules guiding the modeling process. The CASE tool is a graphical software tool that supports the creation of models according to the R 2 M method. Guided by the principles of R 2 M, the tool helps assure the semantic integrity of models, and enables management of complex models via decomposition (i.e. more details at decreasing abstraction levels). The tool can help ensure consistency between different modelers and completeness of models.

On the Move to …, 2006

2016

Abstract. This paper presents an approach to the automated design of the initial conceptual database model. The UML activity diagram, as a fre-quently used business process modeling notation, is used as the starting point for the automated generation of the UML class diagram representing the conceptual database model. Formal rules for automated generation cover the automatic extraction of business objects and business process participants, as well as the automatic generation of corresponding classes and their associations. Based on these rules we have implemented an au-tomatic generator and evaluated it on a real business model.

International Journal of Modeling and Optimization, 2011

Ontology engineering is gaining a lot of focus due to the rapid technological development including the emergence of semantic web technology. The idea behind semantic Web is to create a web of data that can easily be shared, accessed and even transformed over a global scale independently of any application or domain. In order to integrate data into the Semantic Web, the associated database schemas should be translated into equivalent ontologism. Since Descriptions logics provide a logical formalism for developing ontologism, thus it is considered the basis for our mapping framework between OWL2 and ORM2.

Computer Science and Information Systems

This paper presents an approach to the automated design of the initial conceptual database model. The UML activity diagram, as a frequently used business process modeling notation, is used as the starting point for the automated generation of the UML class diagram representing the conceptual database model. Formal rules for automated generation cover the automatic extraction of business objects and business process participants, as well as the automatic generation of corresponding classes and their associations. Based on these rules we have implemented an automatic generator and evaluated it on a real business model.