Browse Prior Art Database

A Database Management System for Office Systems and Advanced Workstations Disclosure Number: IPCOM000148495D
Original Publication Date: 1984-Jun-04
Included in the Prior Art Database: 2007-Mar-30
Document File: 24 page(s) / 1M

Publishing Venue

Software Patent Institute

Related People

Choy, David M.: AUTHOR [+4]


David M. Choy

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 10% of the total text.

Page 1 of 24

RJ 4318 (47146) 6/4/84

r". Computer Science

\ ..--

A Database Management System for Office Systems and Advanced Workstations

David M. Choy

IBM Office Systems Laboratory, San Jose Research

Roger J. Bamford *

Frank C. Tung
IBM Palo Alto Scientific Center




  Over the past few years the amount of computing power and storage available to the office worker has greatly increased, resulting in the introduction of increasingly sophisticated and varied office systems applications. Many of these applications operate on structured data


that could be managed by a general-purpose database system, but are instead stored in flat files in an application-specific format. On the other hand, applications that operate on relatively unstructured data, such as far word processing, need the transparency and efficiency of a conventional file interface.

  To this end, we have developed the "Office at abase" (ODB) , an
integrated database and file system based on the Entity-Relationship model. The ODB database interface supports structured data, while the file system interface supports unstructured data. ODB databases also serve as directories for files (and databases), allowing arbitrary organization and identification of user files and databases.


  This paper first describes the office application environment and the
requirements for an office database. Next, the data model and
programming interface for ODB are described. Following this is a description of a full-screen interactive interface to ODB. An overview of the implementation of OD0 is given, as well as some details on the current status, and conclusions about the significance of the work.

* Curreatly with Oracle Corp.

[This page contains 1 picture or other non-text object]

Page 2 of 24

[This page contains 1 picture or other non-text object]

Page 3 of 24


  Application software for office systems and workstations has been growing quickly over the last several years. Early software consisted primarily of text-oriented applications such as editors and formatters, which operated on unstructured and very specialized text data streams. Rudimentary "record management" packages manipulated structured data generally stored in flat files . As applications have become more and more sophisticated, and the requirement to access the same data from different applications has emerged, it has become clear that there is a need for a

more general purpose database management system (DBMS) (Ref. [Date77)) to

nus on office systems. This need applies to all intelligent machines in

the office, including shared-logic systems, stand-alone workstations, and
of servers andworkstations. Regardless of whether the system is connected to a host computer and has access to a full-scale database management system, a local database is still attractive for performance, availability, data...