A Pipeline Case Tool for Database Design

Abstract

We have developed a tool for design of relational databases, including schemas, integrity constraints, reports, and data entry forms, using semantic binary schemas. The tool is based on a top-down methodology. In this methodology, a conceptual description of an enterprise is designed using a semantic binary model. Then, this description is converted into the relational database design. The tool automates virtually all the busy work of design. With respect to the intelligent design decisions, the tool accepts instructions from its user, who is a database designer, or, when the user defaults, makes decisions itself based on rule-of-thumb principles guided by the knowledge of the database's semantics. The tool creates a turn-key database application and its documentation with graphically-illustrated design reports, manuals, application glossaries, and data dictionaries, as well as an application-customized report generator. Changes in the semantic description or designer's instructions are propagated into the products. (AN)

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Dec 12, 1994
Accession Number
ADA292017

Entities

People

  • Naphtali Rishe
  • Wei Sun

Organizations

  • Florida International University

Tags

Communities of Interest

  • Human Systems

DTIC Thesaurus Topics

  • Abstracts
  • Computer Programming
  • Computer Science
  • Computers
  • Database Management Systems
  • Databases
  • Information Systems
  • Instructions
  • Language
  • Models
  • Operating Systems
  • Relational Database Management Systems
  • Relational Databases
  • Semantic Models
  • Systems Engineering

Fields of Study

  • Computer science
  • Engineering

Readers

  • Database Systems and Applications