Browse Prior Art Database

THE DATABASE DESIGNER'S WORKBENCH

IP.com Disclosure Number: IPCOM000128479D
Original Publication Date: 1984-Mar-01
Included in the Prior Art Database: 2005-Sep-16
Document File: 11 page(s) / 44K

Publishing Venue

Software Patent Institute

Related People

Richard E. Cobb: AUTHOR [+5]

Abstract

The Database Designer's Workbench is a graphics-oriented decision support system for database design, providing designers with a convenient environment for specifying database structures and experimenting with different design strategies. A prototype version has been implemented on the Honeywell MULTICS system using the IBM Personal Computer as the interface. Tools for conceptual design and distributed data allocation are provided. This paper describes the Workbench design objectives, system architecture, and current status.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 10% of the total text.

Page 1 of 11

THIS DOCUMENT IS AN APPROXIMATE REPRESENTATION OF THE ORIGINAL.

THE UNIVERSITY OF MICHIGAN COMPUTING RESEARCH LABORATORY

THE DATABASE DESIGNER'S WORKBENCH1

Richard E. Cobb, James P. Fry and Toby J. Teorey

CRL-TR-18-84

MARCH 1984

Room 1079, East Engineering Building Ann Arbor, Michigan 48109 USA Tel: (313) 763-8000

THE DATABASE DESIGNER'S WORKBENCH

Technical Report 83 DE 21 Revision 1 Richard J. Cobb James P. Fry Toby J. Teorey September, 1983

Information Systems Research Group Graduate School of Business Administration University of Michigan Ann Arbor, Michigan 48109

TABLE OF CONTENTS

Abstract.....i
Chapter 1. Introduction.....1

1.1 Related Research.....3
1.2 Workbench Approach.....4
1.3 Database Design as a Problem-solving Activity.....5
Chapter 2. System Architecture.....11

1 Ensued September, 1983, Technical Report 83 DE 21, Revision 1 by Information Systems Research Group, Graduate School of Business Administration, University of Michigan, Ann Arbor, Michigan, 48109

University of Michigan Computing Research Laboratory Page 1 Mar 01, 1984

Page 2 of 11

THE DATABASE DESIGNER'S WORKBENCH

Chapter 3. Workbench Implementation.....18

3.1 Prototype Workbench.....18
3.2 Tool Implementations.....18
3.3 Future Tools.....19
Chapter 4. Summary and Conclusions.....20
References.....24

ABSTRACT

The Database Designer's Workbench is a graphics-oriented decision support system for database design, providing designers with a convenient environment for specifying database structures and experimenting with different design strategies. A prototype version has been implemented on the Honeywell MULTICS system using the IBM Personal Computer as the interface. Tools for conceptual design and distributed data allocation are provided. This paper describes the Workbench design objectives, system architecture, and current status.

1. Introduction

The Database Designer's Workbench (or "Workbench") is a graphics-oriented decision-support system to assist with the design of all aspects of a computerized database, from the initial specification of the system's requirements through its final physical structure. It provides a wide variety of design aids, or "tools", for designers to explore many design alternatives and to evaluate them precisely. These tools are presented in a homogeneous, graphically-oriented environment that allows a designer to use familiar representations, store incomplete designs, progress smoothly from one design phase to the next, and iterate over previous design stages. The Workbench is therefore a real asset to the database design practitioner, seeking to improve productivity and the quality of design. The Workbench is also of value to researchers interested in improving the database design process because it monitors and records individual designer use.

The Workbench supports a stepwise and iterative database structure refinement methodology described by Teorey and Fry 2, 3. The methodology is based on well-established system design princ...