An automated database design tool using the ELKA conceptual model

Ontologies are spreading more and more in the field of information technologies as a privileged solution allowing the formalization of knowledge. The theoretical model of ontologies is most promising. They are increasingly ubiquitous given the benefits they present. Despite the proliferation of research proposing approaches dedicated to the design of a database from an ontology, the tools to design a database from an ontology are rare or inaccessible. Thus, in this contribution, we present our approach for the development of an Eclipse Plug-in, in order to automatically generate a conceptual model of a relational database from an ontology. To evaluate the usefulness of our approach, we used our resulting Eclipse Plug-in to automatically generate a conceptual model of a relational database from an ontology, customize it, and automatically generate the corresponding SQL script for Data Definition. The results of this experiment showed that our Plug-in constitutes a concretization of our approach and a means of automatic translation from the ontological model to the relational model.

Download Full-text

A semantic data model as the basis for an automated database design tool

Information Systems ◽

10.1016/0306-4379(86)90004-9 ◽

1986 ◽

Vol 11 (2) ◽

pp. 149-165 ◽

Cited By ~ 7

Author(s):

Sonia Berman

Keyword(s):

Data Model ◽

Database Design ◽

Design Tool ◽

Semantic Data ◽

Semantic Data Model ◽

Automated Database

Download Full-text

Performance in Fire of Fibre Reinforced Polymer Strengthened Concrete Beams and Columns: Recent Research and Implications for Design

Journal of Structural Fire Engineering ◽

10.1260/2040-2317.5.4.353 ◽

2014 ◽

Vol 5 (4) ◽

pp. 353-366 ◽

Cited By ~ 2

Author(s):

Mark Green ◽

Kevin Hollingshead ◽

Noureddine Bénichou

Keyword(s):

Conceptual Model ◽

Concrete Beams ◽

Design Tool ◽

Fire Performance ◽

Reinforced Polymers ◽

Reinforced Polymer ◽

Practical Design ◽

Fibre Reinforced Polymer ◽

Full Scale Tests ◽

In Fire

This paper considers the fire performance of concrete beams and columns that have been strengthened with fibre reinforced polymers (FRPs). Results from four recent full-scale tests are presented. A newly developed type of insulation was employed and the thickness of the insulation (15 to 20 mm) was approximately half that provided in earlier tests. All of the members survived four hours of the fire exposure. A conceptual model for design to determine when insulation is required is also presented. Further research needed to fully develop the conceptual model to a more practical design tool is outlined.

Download Full-text

From Databases to Ontologies

Database Technologies ◽

10.4018/978-1-60566-058-5.ch145 ◽

2009 ◽

pp. 2360-2383

Author(s):

Guntis Barzdins ◽

Janis Barzdins ◽

Karlis Cerans

Keyword(s):

Conceptual Model ◽

Relational Database ◽

Relational Databases ◽

Database Design ◽

Database Schema ◽

Design Problems ◽

Uml Profile ◽

Domain Experts ◽

Owl Ontology ◽

Rdf Database

This chapter introduces the UML profile for OWL as an essential instrument for bridging the gap between the legacy relational databases and OWL ontologies. We address one of the long-standing relational database design problems where initial conceptual model (a semantically clear domain conceptualization ontology) gets “lost” during conversion into the normalized database schema. The problem is that such “loss” makes database inaccessible for direct query by domain experts familiar with the conceptual model only. This problem can be avoided by exporting the database into RDF according to the original conceptual model (OWL ontology) and formulating semantically clear queries in SPARQL over the RDF database. Through a detailed example we show how UML/OWL profile is facilitating this new and promising approach.

Download Full-text

Outline of a Design Tool for Analysis and Visual Quality Control of Urban Environments

Modern Organizations in Virtual Communities ◽

10.4018/978-1-931777-16-2.ch021 ◽

2002 ◽

pp. 249-260

Author(s):

Predrag Sidjanin ◽

Waltraud Gerhardt

Keyword(s):

Computer Science ◽

Cognitive Science ◽

Conceptual Model ◽

Urban Environment ◽

Design Theory ◽

Cognitive Mapping ◽

Visual Quality ◽

Database System ◽

Urban Environments ◽

Design Tool

In this chapter, the main idea about a design tool and its object database system will be described. The design tool should improve design practice with respect to analysis and improving existing and planned urban environments. Preconditions for defining the design tool’s purpose are the determination of the “well-situated” urban elements, their impact on cognitive mapping, and the exploitation of the knowledge on cognitive mapping for the improvement of urban environments. This leads to the conclusion that an urban environment design, which takes of the process of cognitive mapping into consideration, will be experienced by most of the people in the same way. Investigations of this process result in a conceptual model of the tool by using elements of urban environments, their relationships and their dependencies. The theoretical background of the tool is based on design theory, cognitive science and computer science. Design theory and cognitive science will be used to develop the conceptual model. This conceptual model together with computer science will be the basis platform for tool development. The tool uses a schematic representation of urban environment, based on Lynch’s theory of “urban forms.” Lynch’s theory is crucial for the tool development because it explains elements of urban environments. Systematic investigation of urban environments and their characteristics are also important for the object schema of the tool. The tool will use an object database system, which help to represent and to handle the urban elements with their properties and relationships, with their natural semantics. The information represented in the database will be used to analyze urban environment with the aim to improve and control their visual quality.

Download Full-text

Maintaining Mappings between Conceptual Models and Relational Schemas

Journal of Database Management ◽

10.4018/jdm.2010070102 ◽

2010 ◽

Vol 21 (3) ◽

pp. 36-68 ◽

Cited By ~ 8

Author(s):

Yuan An ◽

Xiaohua Hu ◽

Il-Yeol Song

Keyword(s):

Conceptual Model ◽

Design Process ◽

Information Needs ◽

Conceptual Models ◽

Database Design ◽

Round Trip ◽

Relational Schemas ◽

Engineering Approach ◽

New Information ◽

Relational Mapping

This paper describes a round-trip engineering approach for incrementally maintaining mappings between conceptual models and relational schemas. When either schema or conceptual model evolves to accommodate new information needs, the existing mapping must be maintained accordingly to continuously provide valid services. In this paper, the authors examine the mappings specifying “consistent” relationships between models. First, they define the consistency of a conceptual-relational mapping through “semantically compatible” instances. Next, the authors analyze the knowledge encoded in the standard database design process and develop round-trip algorithms for incrementally maintaining the consistency of conceptual-relational mappings under evolution. Finally, they conduct a set of comprehensive experiments. The results show that the proposed solution is efficient and provides significant benefits in comparison to the mapping reconstructing approach.

Download Full-text