A visual tool for managing relational databases

1986 IEEE Second International Conference on Data Engineering Pub Date : 1986-02-05 DOI:10.1109/ICDE.1986.7266275

A. Benjamin, Karl M. Lew

{"title":"A visual tool for managing relational databases","authors":"A. Benjamin, Karl M. Lew","doi":"10.1109/ICDE.1986.7266275","DOIUrl":null,"url":null,"abstract":"Although the relational approach to databases has been revolutionary in terms of the conceptual simplicity it affords when designing database Schemas and their attendant applications, the task of implementing and managing a relational database is still very much a burden for the database administrator. In particular: 1) communication with the database system is usually restricted to primitive, teletype interfaces, 2) abstractions used by the DBA (e.g. default joins, default constraints, column domains, etc.) are not inherently supported by existing database systems, and 3) there are no safeguards against inadvertent catastrophic data dictionary modification. The Metaphor DBA Tool addresses these issues by providing a visual interface to the database data dictionary. It is, in essence, a specialized editor for the abstractions familiar to the DBA. Categories (i.e. collections of tables). Tables and Columns have specific screen depictions; relationships between objects are established by lines drawn between them. The DBA can create, modify, and display the structure of the database by manipulating these graphical objects.","PeriodicalId":415748,"journal":{"name":"1986 IEEE Second International Conference on Data Engineering","volume":"102 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1986-02-05","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"2","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"1986 IEEE Second International Conference on Data Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICDE.1986.7266275","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 2

Abstract

Although the relational approach to databases has been revolutionary in terms of the conceptual simplicity it affords when designing database Schemas and their attendant applications, the task of implementing and managing a relational database is still very much a burden for the database administrator. In particular: 1) communication with the database system is usually restricted to primitive, teletype interfaces, 2) abstractions used by the DBA (e.g. default joins, default constraints, column domains, etc.) are not inherently supported by existing database systems, and 3) there are no safeguards against inadvertent catastrophic data dictionary modification. The Metaphor DBA Tool addresses these issues by providing a visual interface to the database data dictionary. It is, in essence, a specialized editor for the abstractions familiar to the DBA. Categories (i.e. collections of tables). Tables and Columns have specific screen depictions; relationships between objects are established by lines drawn between them. The DBA can create, modify, and display the structure of the database by manipulating these graphical objects.

查看原文本刊更多论文

用于管理关系数据库的可视化工具

尽管数据库的关系方法在设计数据库模式及其附带的应用程序时在概念上的简单性方面具有革命性意义，但是实现和管理关系数据库的任务对数据库管理员来说仍然是很大的负担。特别是:1)与数据库系统的通信通常限于原始的、电传类型接口;2)DBA使用的抽象(例如默认连接、默认约束、列域等)不受现有数据库系统的固有支持;3)没有防止无意的灾难性数据字典修改的保护措施。隐喻DBA工具通过提供数据库数据字典的可视化界面来解决这些问题。本质上，它是DBA所熟悉的抽象的专门编辑器。类别(即表的集合)。表和列有特定的屏幕描述;物体之间的关系是通过在它们之间画的线来建立的。DBA可以通过操作这些图形对象来创建、修改和显示数据库的结构。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

1986 IEEE Second International Conference on Data Engineering

自引率

0.00%

发文量