Abstract: Logical schemas are used to allow an end user the ability to access and manipulate relational database data without knowledge of the structure of the relational database. A logical schema is first created specifying which tables are available to an end user, and the relationships between columns of those tables. The logical schema defines a structure for the data fields having a master level and a plurality of detail levels. An end user may manipulate the logical schema using a graphical interface to build customized forms, reports, and queries. An end user is not required to be familiar with a database query language, such as SQL, or the structure of the relational database.
Type:
Grant
Filed:
July 1, 1993
Date of Patent:
December 23, 1997
Assignee:
Informix Software, Inc.
Inventors:
Christopher W. Maloney, Brian D. Jackson, Kevin B. Mayfield, Mark A. Mills, Kent A. Tracy