Article

Design and Implementation of Relational Database System for Road Construction Companies

July 2002

July 2002
6(2):90-108

Authors:

Khamis A. Zidan

Al-Iraqia University

The aim of this paper is to build a relational database system for companies working in the field of road construction projects. The study and analysis of the paper-based database system used by these companies was investigated and divided into wen defined parts .The main demand of proposed system could he summarized by making documentation to all projects data. Project data consist of forming the road main design, calculating pill quantities, recording the accidental changes in the projects plan work, producing reports about any project, and finally helping to answer any inquiry needed by higher management units. The proposed computerized system was implemented using Visual Basic TM (VB) programming language. Most of language tools, controls, and methods have been used to give a high user interface capabilities and flexibility for the system.

ResearchGate has not been able to resolve any citations for this publication.

ResearchGate has not been able to resolve any references for this publication.

Conference Paper

Rationale for the Design of Persistence and Query Processing Facilities in the Database Programming...

January 1989

ODE is a database system and environment based on the object paradigm. It offers one integrated data model for both database and general purpose manipulation. The database is defined, queried, and manipulated in the database programming language O++, an extension of C++. O++ uses the C++ object definition facility, called the class, to provide data encapsulation and multiple inheritance. O++ ... [Show full abstract] extends C++ by providing facilities for creating persistent and versioned objects, defining and manipulating sets, organizing persistent objects into clusters, iterating clusters of persistent objects, and associating constraints and triggers with objects. In this paper, we present the O++ facilities for persistence and query processing, the alternatives considered, and the rationale behind the design choices. ODE is a database system and environment based on the object paradigm (2). The database is defined, queried, and manipulated using the database programming language O++. O++ is an upward compatible extension of the object-oriented programming language C++ ( Stroustrup 1986 ) that offers one integrated data model for both database and general purpose manipulation. The C++ object definition facility is called the class, which supports data encapsulation and multiple inheritance. O++ extends C++ by providing facilities for creating persistent and versioned objects, defining and manipulating sets, organizing persistent objects into clusters, iterating over clusters of persistent objects, and associating constraints and triggers with objects. In this paper, we present the O++ facilities for persistence and query processing, the alternatives that we considered, and the rationale behind our design choices. We assume that the reader is familiar with the basic issues in the design of database programming languages (see, for example, (6, 10, 11, 26, 33, 38) for introduction) and concentrate on our design. Our discussion is oriented around O++, but we think that lessons we learned have wider applicability. The organization of the rest of the paper is as follows. In Section 2, we give a brief overview of the C++ object definition facility. In Section 3, we consider the persistence model of O++, which was inspired by our desire to provide facilities so that persistence becomes a property of object instances and not object types, and persistent objects are accessed and manipulated like volatile heap objects, without imposing run-time penalty for code that does not deal with persistent objects. We present design goals, alternatives considered, and the rationale for the choices made. In Section 4, we consider the query processing constructs provided in O++. These constructs were motivated by our desire to provide facilities in an object-oriented framework for set-oriented query processing and optimizations similar to those found in relational database systems. We again present design goals, alternatives considered, and the rationale for the choices made. We discuss related work in Section 5 2. OBJECT DEFINITION: A BRIEF OVERVIEW The C++ object facility is called the class. Class declarations consist of two parts: a specification (type) and a body. The class specification can have a private part holding information that can only be used by its implementer, and a public part which is the type's user interface. The body consists of the bodies of functions declared in the class specification but whose bodies were not given there. For example, here is a specification of the classitem:

Article

ROSE and CHIDE: user interface management system implementation as object-oriented database system a...

October 1990 · Computer-Aided Design

ROSE, an experimental object-oriented database system for interactive engineering applications, and CHIDE, a user interface development environment are both described. ROSE is a database system that combines features of relational database systems with those of object-oriented programming languages. CHIDE is a user interface management system that allows its user to create and edit user ... [Show full abstract] interfaces without writing code in a programming language. Instead, the CHIDE user creates user interfaces by editing representations of those interfaces displayed on a graphics display. CHIDE is implemented as an application of ROSE. It uses a ROSE database to store objects describing user interfaces, and it uses the ROSE data manipulation language to manipulate those objects. The advantages are described of implementing a user interface development environment as an application of a database system; why that database system should be object-oriented, and how ROSE has been implemented so that it is fast enough to support this type of application.

Article

Development of Database System for T-50 Flutter/Vibroacoustic Flight Test Data

February 2006 · Journal of the Korean Society for Aeronautical & Space Sciences

The flutter/vibroacoustic characteristics can be acquired by conducting flight tests with various conditions for a long period of test. Accordingly it is indispensable to build a specially designed database system to efficiently accumulate the enormous data obtained from flight tests. Hence, T-50 Flight Test Database System(FTDS) based on MS-Access is developed to handle the flutter/vibroacoustic ... [Show full abstract] environment data obtained from flight tests. The developed system is structured with the items related to aircraft flight test, the tables composed of the relevant items and a relational database logically connecting the tables. The T-50 FTDS is implemented with data searching GUI(Graphic User Interface) programed with Visual Basic and Structured Query Language to make intuitive searches over the stored data. The developed system has been used for accumulating the flutter/vibroacoustic data and verifying vibroacoustic Specifications.

Article

Integration of object-oriented programming languages and database systems in KOPERNIK

January 1991 · Data & Knowledge Engineering

KOPERNIK is an object-oriented database system, that allows uniform specification of database requests and application programs. The user interface is based on Smalltalk, and the object-oriented data model is represented in terms of classes and messages. Techniques are discussed for implementing such a model on top of an underlying relational database system. Those parts of application programs ... [Show full abstract] that cannot be translated into a relational language are handled by a Smalltalk processor. The semantics of the database requests is defined in terms of a meta-model and meta-messages, using an object-oriented approach. Hence we derive rules for translation of database requests into SQL queries over a binary relational view, introduced as an intermediate level between the underlying database and our conceptual view.

Conference Paper

Multi-resolution of Image Retrieval in Image Databases System

November 2010

Li Wu

Image Databases System(IDBS) are a special kind of Spatial Databases System where a large number of images are stored and queried. IDBS find a plethora of applications in modern life, e.g. in Medical, Multimedia, Educational Applications, etc. Data in an IDB may be stored in raster or vector format. The development of our system is based on non-specialized tools: a relational database, Visual ... [Show full abstract] Basic and the computer's file system. The user interface of the system aims at increased ease of use. It permits the management of the collection of images and the effective querying of the images by all the above query types and their combinations.

Article

Summary of Publications Submitted in

March 2004

Torsten Grust

This document provides an overview of the publications I have submitted in partial fulfillment of the requirements for the Habilitation degree. The first four articles [1--4], summarized in Part A below, report on my research on the representation and querying of tree-shaped data in relational database systems. Foremost, the developed techniques enable these systems to act as highly e#cient XML ... [Show full abstract] and XPath processors. Part B summarizes articles [5, 6], a thread of research which focuses on the adaption of techniques that were originally conceived by the functional programming language community. I developed this into a unique generic framework for the study of database query optimization problems.

Conference Paper

Full-text available

Visualizing multidimensional raster data with rView

February 2000

rView is a visual front end to the RasDaMan DBMS, providing raster data visualization functionality and a graphical user interface to the database system. RasDaMan, a commercial array DBMS whose prototype has been developed by FORWISS, is designed for raster data of arbitrary dimensionality and base type, which makes it a powerful storage system for all types of rastered data. This generality ... [Show full abstract] calls for a similarity flexible visualization tool for data stored in the database. rView has been designed as a generic visualization tool with very few restrictions regarding dimensionality and base (i.e., array cell) type; among other things, it provides several visualization techniques like texture mapping, voxel- and height field rendering, which may be combined with user-configurable mappings to the RGB colour space

Conference Paper

FADS - A Form Application Development System.

January 1982

This paper describes FADS --- a Form Application Development System which is an interactive system for the development of form-based database applications. FADS reduces the amount of work required to implement a forms application by suppressing much of the detail which would be required by conventional tools (e.g., a screen definition system, a database system, and a programming language). FADS ... [Show full abstract] provides direct access to a relational database, a standard model of the user interface, built-in form constructs, and an integrated development and debugging environment. Using FADS, form applications can be developed quickly and the resulting systems are easy to modify.A prototype implementation of the FADS kernel has been completed.

Conference Paper

Full-text available

A formal definition of the Users View (UV) of the Graphical Object Query Language (GOQL)

February 2002

We provide a brief formal definition of the Users View (UV) of the Graphical Object Query Language (GOQL). The UV provides a graphical representation for object-oriented database schemas and hides from end-users most of the perplexing details of the object-oriented database model, such as methods, hierarchies and relationships. In particular, the UV does not distinguish between methods, ... [Show full abstract] attributes and relationships, encapsulates the is-a hierarchy and utilises a number of desktop metaphors to present a graphical schema that is easy to be understood by end-users. Thus, the UV provides the environment, through which end-users, can pose ad-hoc queries through GOQL. We first give a brief formal definition of an object-oriented database schema in the GOQL model. This is given, by providing a formal definition of the basic element of such a schema, namely the class. The UV is then briefly formally defined as a mapping from a GOQL object-oriented database schema. Using this mapping, any object-oriented database schema can be translated into a graphical representation in the UV. The running example of the paper is used to demonstrate the mapping from the textual schema to the graphical schema of the UV. The formal definition of the UV will allow us, in the future, to formally define the graphical constructs of GOQL.

Article

New systematic data utilization for monitoring surveys in Lake Biwa

March 2006 · Water Science & Technology Water Supply

Lake monitoring surveys data are vital and have been being accumulated for every lake. However data itself, without effective data management and interpretation, cannot be used to tell the story or history of the lake. Therefore, this project aims to develop a new water quality database system for a lake with systematical functions to utilize such data effectively and to satisfy both general ... [Show full abstract] public users and specialists. Lake Biwa was chosen as the target lake, where long-term monitoring data were available for almost one hundred years. A relational database application, Access 2002, with the help of Macro functions and VBA (Visual Basic for Applications) was introduced to organize all of the data. With the systematical storing of data, valuable data could be easily accessed, filtered and powerfully utilized for researchers own interests. The filtered data can be written into basic documents (spreadsheet or text files), provided for outside requests, and again used for further basic and advanced analysis by a reading back process. The system supports multiple users, especially public users by providing user interface system and visualized result displays. The final outcomes from this systematic data utilization can be fruitfully used as the guideline for effective monitoring management program of lake water quality.

Article

Design of a database system for carbon dioxide corrosion

January 2006

By using the standard theory of the related database, a corrosion database in Chinese containing corrosion data of carbon dioxide, was designed and established Windows XP. was used as the operation platform. The database possessed the functions of inquiry, maintenance and printing. The database managing system and user's interface were programmed with Visual FoxPro6.0. The advantages of this ... [Show full abstract] database include simple software environment and convenient operation.

Conference Paper

Integrating an intelligent interface with a relational database for two way man-machine communicatio...

January 1991

The design of a system capable of handling ad hoc user responses to system-initiated questions is considered. An approach called the expectation-driven response understanding paradigm was developed. In this paradigm, it is assumed that each system-generated question is accompanied by an expectation of what the user should respond. The system attempts to link this expectation with the user's ... [Show full abstract] response in order to quantify its appropriateness in relation to the system's original question. A prototype system based on this paradigm has been implemented and integrated with the INGRES database system