Abstract:
This paper proposes a new interface, visual database interface (VDI), for the novice end users to design, implement and query the database systems. The semantic data mode...Show MoreMetadata
Abstract:
This paper proposes a new interface, visual database interface (VDI), for the novice end users to design, implement and query the database systems. The semantic data model used by VDI is an enhanced ER model (EER) with the inclusion of generalization/specialization, aggregation and categorization abstractions. The tools available in VDI include a graphical EER diagrammer for conceptual design and a graphical knowledge query language (VKQL) for data manipulation. The data definition and normalization tasks, which are considered to be the most difficult for end users, have been completely automated by the VDI Normalizer and the DB Creator.<>
Date of Conference: 28-30 May 1992
Date Added to IEEE Xplore: 06 August 2002
Print ISBN:0-8186-2812-X
Citations are not available for this document.
Cites in Patents (1)Patent Links Provided by 1790 Analytics
1.
Bennett, John G.; Gee, Perry A.; Gayraud, Charles E., "SYSTEM AND METHODS INCLUDING AUTOMATIC LINKING OF TABLES FOR IMPROVED RELATIONAL DATABASE MODELING WITH INTERFACE"
Inventors:
Bennett, John G.; Gee, Perry A.; Gayraud, Charles E.
Abstract:
A system includes a relational database management system (RDBMS) having a data modeling component. A "data model" is a graphical representation of the relationship between tables one may use in a design document. "Design documents" allow a user to customize how his or her data are presented, including presenting information in formats which are not tabular and including formats which link together different tables (so that information stored in separate tables appears to the user to come from on place). Methods are described for automatically linking tables to be placed in a data model by comparing unique keys (e.g., primary key or other unique identifier) of one table with indexes (or indexable fields) of another table. Based upon the comparison, the system automatically suggests an appropriate link (if any) for the tables.
Assignee:
BORLAND INTERNATIONAL INC
Filing Date:
25 May 1993
Grant Date:
25 March 1997
Patent Classes:
Current U.S. Class:
707999102, 715700000
Current International Class:
G06F0173000000