The Database Design Process in HERM

2000 ◽  
pp. 425-502 ◽  
Author(s):  
Bernhard Thalheim
Keyword(s):  
Design Process ◽  
Database Design

Methodical Spatial Database Design with Topological Polygon Structures

2012 ◽  
Vol 3 (1) ◽  
pp. 21-30
Author(s):  
Jean Damascène Mazimpaka
Keyword(s):  
Design Process ◽  
Spatial Data ◽  
Spatial Databases ◽  
Early Stage ◽  
Spatial Database ◽  
Database Design ◽  
Integrity Constraints ◽  
Data Types ◽  
Data Infrastructure ◽  
Database Development

Spatial databases form the foundation for a Spatial Data Infrastructure (SDI). For this, a spatial database should be methodically developed to accommodate its role in SDI. It is desirable to have an approach to spatial database development that considers maintenance from the early stage of database design and in a flexible way. Moreover, there is a lack of a mechanism to capture topological relations of spatial objects during the design process. This paper presents an approach that integrates maintenance of topological integrity constraints into the whole spatial database development cycle. The approach is based on the concept of Abstract Data Types. A number of topological classes have been identified and modelling primitives developed for them. Topological integrity constraints are embedded into maintenance functions associated with the topological classes. A semi-automatic transformation process has been developed following the principles of Model Driven Architecture to simplify the design process.

Maintaining Mappings between Conceptual Models and Relational Schemas

2010 ◽  
Vol 21 (3) ◽  
pp. 36-68 ◽  
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.

Methodical Spatial Database Design with Topological Polygon Structures

2013 ◽  
pp. 295-304 ◽  
Author(s):  
Jean Damascène Mazimpaka
Keyword(s):  
Design Process ◽  
Spatial Data ◽  
Spatial Databases ◽  
Early Stage ◽  
Spatial Database ◽  
Database Design ◽  
Integrity Constraints ◽  
Data Infrastructure ◽  
Database Development ◽  
Model Driven

Spatial databases form the foundation for a Spatial Data Infrastructure (SDI). For this, a spatial database should be methodically developed to accommodate its role in SDI. It is desirable to have an approach to spatial database development that considers maintenance from the early stage of database design and in a flexible way. Moreover, there is a lack of a mechanism to capture topological relations of spatial objects during the design process. This paper presents an approach that integrates maintenance of topological integrity constraints into the whole spatial database development cycle. The approach is based on the concept of Abstract Data Types. A number of topological classes have been identified and modelling primitives developed for them. Topological integrity constraints are embedded into maintenance functions associated with the topological classes. A semi-automatic transformation process has been developed following the principles of Model Driven Architecture to simplify the design process.

The Implementation of STEP Schemas

1993 ◽  
Author(s):  
William C. Burkett
Keyword(s):  
Design Process ◽  
Development Process ◽  
Product Information ◽  
Database Design ◽  
Model Data ◽  
Product Model ◽  
Current Step ◽  
International Standard ◽  
Conflicting Objectives ◽  
Technical Architecture

Abstract The Standard for the Exchange of Product model data (STEP - ISO 10303) is an international standard for the communication of product information between heterogenous systems. In this presentation, the question of how STEP should be implemented is examined. The objectives of the STEP Development process are presented and the resulting effect that these objectives had on the structure of the standard is explained. However, conflicting objectives resulted in a structure that lacked appropriate mechanisms for dealing efficiently with implementation considerations. The STEP Development Process is compared/contrasted with a database design process to discern where implementation considerations (i.e., tuning, optimization) should take place within the process. A technical architecture for the standard is presented and a missing component of the standard is identified and explained: the Implementation Schema. Current STEP efforts with respect to Implementation Schemas are then presented.

Maintaining Mappings between Conceptual Models and Relational Schemas

2012 ◽  
pp. 245-276
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.

Database Design of Failure Diagnosis Expert System for Combustion Engine

2012 ◽  
Vol 220-223 ◽  
pp. 1783-1786
Author(s):  
Yong Liu ◽  
Sai Fei Zhang
Keyword(s):  
Expert System ◽  
Knowledge Base ◽  
Design Process ◽  
Combustion Engine ◽  
Database Design ◽  
Failure Diagnosis ◽  
Program Code ◽  
Implementation Method ◽  
Design Ideas ◽  
Code Book

The database design process for failure diagnosis expert system is divided into two parts. One part is, in the knowledge base, we mainly introduce design ideas of each maintaining module of in knowledge base, including the implementation method for entry, retrieval, modification and inquiring function interface of knowledge. Another part is dynamic database. We mainly introduce the modules of specific design process for data transmission. The entire system realize by C++Builder language. And the detailed codes of database are written into the program code book.

Sign in / Sign up

Export Citation Format

Share Document