Skip to main content
OSTI.GOVU.S. Department of Energy Office of Scientific and Technical Information
U.S. Department of Energy
Office of Scientific and Technical Information
 

SDT: A database schema design and translation tool

Technical Report ·
DOI:https://doi.org/10.2172/5241462· OSTI ID:5241462
;
In this document we describe schema design and translation tool called SDT.SDT takes as input Extended Entity-Relationship (EER) schemas and generates relational database management (RDBMS) schemas. SDT consists of three main parts: (1) The first part maps EER schemas into abstract relational schemas, (2) the second part maps abstract relational schemas into schema definitions for RDBMSs; and (3) the third part generates the metadata regarding EER schemas, relational schemas, and their mappings. SDT 4.1 targets SYNBASE 4.0, INGRES 6.3, and INFORMIX 4.0. Compared with SDT 3.1, SDT 4.1 has the following additional features: (1) a graphical editor for specifying and modifying EER schemas, called ERDRAW; (2) SDT 4.1 generates procedures for verifying the consistency of an existing database with regard to a set of referential integrity constraints associated with that database; (3) attributes and object-sets (entity-sets or relationship-sets) can be described using new description fields; (4) SDT 4.1 allows the specification of hierarchically organized subject terms for object-sets, attributes, and the association of subject terms with object-sets and attributes; and, (5) SDT 4.1 generates metadata describing EER schemas, relational schemas and their mappings. SDT was implemented using C, LEX, and YACC on Sun 3 and Sun 4 workstations under Sun Unix OS 4.0.3. and Sun Unix OS 4.1. 9 refs., 8 figs.
Research Organization:
Lawrence Berkeley Lab., CA (United States)
Sponsoring Organization:
DOE; USDOE, Washington, DC (United States)
DOE Contract Number:
AC03-76SF00098
OSTI ID:
5241462
Report Number(s):
LBL-27843
Country of Publication:
United States
Language:
English

Similar Records

ERDRAW: A graphical schema specification tool
Technical Report · Wed May 01 00:00:00 EDT 1991 · OSTI ID:5603321
OPM Scheme Editor 2: A graphical editor for specifying object-protocol structures
Technical Report · Thu Jul 01 00:00:00 EDT 1993 · OSTI ID:10105610
Identifying extended entity-relationship object structures in relational schemas
Journal Article · Wed Aug 01 00:00:00 EDT 1990 · IEEE (Institute of Electrical and Electronics Engineers) Transactions on Software Engineering; (United States) · OSTI ID:6969350

Related Subjects

99 GENERAL AND MISCELLANEOUS
990200* -- Mathematics & Computers
COMPUTER CODES
COMPUTER PROGRAM DOCUMENTATION
DATA BASE MANAGEMENT
DIAGRAMS
DOCUMENT TYPES
FLOWSHEETS
INFORMATION SYSTEMS
MANAGEMENT
MANUALS
MATHEMATICAL LOGIC
S CODES