skip to main content
10.1145/1499310.1499382acmotherconferencesArticle/Chapter ViewAbstractPublication PagesafipsConference Proceedingsconference-collections
research-article
Free access

Functions of the database workbench

Published: 09 July 1984 Publication History

Abstract

A powerful database system can be developed by a combination of a central relational database system and intelligent terminals. In such an organization a typical function of a terminal is to offer high-level user interfaces. In this paper the concept of the database workbench is introduced and shown to be suitable for development by such terminals. As design problems usually require a large amount of interaction, typical functions of the workbench are (1) the design of database schemas, (2) the design of conversion procedures between real-world data and data in the system, and (3) the design of queries. For the first function we focus on the relational database design under the assumption that set values are permitted. Problems of set values, especially conversion problems of dependencies, are discussed. Various facilities for design conversion procedures and the design of queries are also discussed.

References

[1]
Dolotta, T. A., and J. R. Moshey. "An Introduction to the Programmers Workbench." Proceedings of the 2nd International Conference on Software Engineering. October 1976, pp. 164--168.
[2]
Makinouchi, A. "A Consideration on Normalized Form of Not-Necessarily-Normalized Relation in the Relational Data Model." Proceedings of the 3rd International Conference on Very Large Data Bases. October 1977, pp. 447--453.
[3]
Silva, A. M., and M. A. Melkanoff. "A Method for Helping Discover the Dependencies." In Advances in Database Theory (Vol. 1), 1981, pp. 115--133.
[4]
Kambayashi, Y., C. Le Viet, S. Tokuda, and S. Yajima. "A Database Preparation System." IEEE Computer Society, 5th International Computer Software and Applications Conference. November 1981, pp. 335--350.
[5]
Goldstein, B. S. "Constraints on Null Values in Relational Databases." Proceedings of the 6th International Conference on Very Large Data Bases. September 1981, pp. 101--110.
[6]
Maier, D., A. O. Mendelzon, and U. Sagiv. "Testing Implications of Data Dependencies." ACM TODS, 4 (1979), pp. 455--469.
[7]
Sadri, F., and J. D. Ullman. "The Interaction between Functional Dependencies and Template Dependencies." ACM SIGMOD, May (1980), pp. 45--51.
[8]
Fagin, R. "Multivalued Dependencies and a New Normal Form for Relational Databases." ACM TODS 2, September (1977), pp. 262--278.
[9]
Kambayashi, Y., K. Tanaka, and S. Yajima. "A Relational Data Language with Simplified Binary Relation Handling Capacity." Proceedings 3rd International Conference on Very Large Data Bases, October 1977, pp. 338--350.
[10]
Kambayashi, Y., K. Tanaka, K. Takeda, and S. Yajima. "Representation of Relations for Database Output Utilizing Data Dependencies." Proceedings of the 15th Hawaii International Conference on System Science, January 1982, pp. 69--78.
[11]
Beeri, C., R. Fagin, D. Maier, A. Mendelzon, J. Ullman, and M. Yannakakis. "Properties of Acyclic Database Schemas." ACM SIGACT Symposium on Theory of Computing. May 1981, pp. 355--362.
[12]
Codd, E. F. "A Relational Model of Data for Large Shared Data Banks." Comm. ACM, 13 (1970), pp. 377--387.
[13]
Kambayashi, Y., K., Tanaka, and S. Yajima. "Semantic Aspects of Data Dependencies and Their Application to Relational Database Design." COMPSAC, November 1979, pp. 398--403.
[14]
Yajima, S., Y. Kambayashi, O. Konishi, K. Tanaka, C. Le Viet, and T. Kato. "Bibliographic Information Processing Facilities for Relational Database System ARIS." Proceeding of the 13th Hawaii International Conference on System Science. (Vol. 2), January 1980, pp. 198--207.

Cited By

View all
  • (1990)The architecture and implementation of ENLI: example-based natural language-assisted interfaceProceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications10.1109/PARBSE.1990.77170(430-432)Online publication date: 1990

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
AFIPS '84: Proceedings of the July 9-12, 1984, national computer conference and exposition
July 1984
746 pages
ISBN:0882830430
DOI:10.1145/1499310
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

  • AFIPS: American Federation of Information Processing Societies

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 09 July 1984

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)20
  • Downloads (Last 6 weeks)4
Reflects downloads up to 18 Jan 2025

Other Metrics

Citations

Cited By

View all
  • (1990)The architecture and implementation of ENLI: example-based natural language-assisted interfaceProceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications10.1109/PARBSE.1990.77170(430-432)Online publication date: 1990

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media