Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-02-23
2003-06-03
Robinson, Greta (Department: 2771)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
06574637
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates generally to the field of software applications. More particularly, it concerns a software program for browsing the data structure of a plurality of arbitrary relational databases.
The microfiche appendix to this specification contains copyrighted computer program source code that is owned by the assignee of this application. Permission is granted to make a single facsimile copy of the microfiche appendix, in microfiche form, for each facsimile copy that is made of any patent issuing from this application or from any application claiming priority hereon. All other rights in the computer program source code, under copyright or otherwise, are reserved.
2. Description of Related Art
A database is a collection of files for storing related information. A relational database is a database in which a collection of tables contains database records where each record within a single table is comprised of a set of fields common to all records in that table.
In some relational databases, the data can be accessed along complex dimensions using the standard query language (SQL). Such databases make it convenient to look tip information based on specifications derived from a semantic frame.
Furthermore, each database has a data structure. A data structure is defined as a physical or logical relationship among data elements, designed to support specific data manipulation functions.
Relational databases have become the subject of significant recent interest, not only because of the increasing volume of data being stored and retrieved by these computerized databases but also by virtue of the data structures across these databases. Many types of relational databases exist today, e.g., MICROSOFT ACCESS®, manufactured by the Microsoft Corporation of Redmond, Wash., ORACLE®, manufactured by the Oracle Corporation of Redwood Shores, Calif., and SYBASE®, manufactured by Sybase, Inc. of Dublin, Calif., etc. As a result, a variety of types of databases and database structures exist. As the need to cross-reference one record from one database with another records in another database increases, the ability to view data structures across different relational databases all at one becomes important. Currently, it is believed that viewing data structures across a plurality of relational databases has been thought to be difficult, if not impossible, primarily due to the incompatibility of the various databases. The present invention provides a solution to this problem by giving a database user the ability to view the data structure of a plurality of arbitrary relational database structures all at once.
SUMMARY OF THE INVENTION
A machine-executed method and apparatus are provided to display the data structure of a plurality of relational databases of arbitrary structure in a browseable formnat. Each database comprises a plurality of tables. Each table contains one or more fields and one or more records. Each table and each field has a name. The method includes several steps.
The respective structure of the plurality of relational databases is determined, e.g.,. by a graphical-user-interface data entry technique or by manually editing one or more files. Each database may have its own arbitrary structure. The respective structures are integrated into a front-end integrated data structure. This entails (a) removing the conflicting names of tables and fields in the front-end integrated data structure, and/or (b) performing a join operation to establish a “link” between selected fields in at least two respective tables, where each table is in a separate respective database.
In removing the conflicting names, a name is selected, followed by displaying a cross-reference list of uses of the selected name in the plurality of relational databases. The selected name is then edited with another name more suitable to the user, referred to as an “alias.” Once the selected name is renamed with its “alias” name, the “alias” name is displayed in lieu of the selected name.
When portions of two or more database tables are joined to create a “virtual” table by definition, the database tables contain at least one related field. For purposes of the “virtual” table, the selected field in one database table is designated as a “primary key,” while the corresponding selected field in the other joined database table is designated as a “foreign key.”
Once the structures of the plurality of relational databases are integrated into the front-end integrated data structure, the front-end integrated data structure is displayed as a hierarchical containment tree of folders. That is, the structure is displayed along with a category of folders. Each folder contains a category of folders below it within the hierarchy.
In an alternative embodiment, once the respective structures are determined, a combined list of tables in the respective databases is displayed; a table in the list is selected; a list of fields for the selected table is displayed; a field in the list of fields is selected; and the selected field descriptor information for the selected field is displayed. Field descriptor information generally contains, among other pertinent information, a cross-reference list of uses of the selected field in the respective databases.
The present invention has a number of advantages, among them being the ability to view, edit, or reorganize the data structures of one or more relational databases in a browseable format. Another advantage of the present invention is the flexibility to rename the fields and tables of the various relational databases with other names more suitable to the user. This feature may help the user to organize the information he obtained from the integrated data structure.
REFERENCES:
patent: 5295261 (1994-03-01), Simonetti
patent: 5416917 (1995-05-01), Adair et al.
patent: 5437027 (1995-07-01), Bannon et al.
patent: 5444842 (1995-08-01), Bentson et al.
patent: 5721901 (1998-02-01), Banning et al.
patent: 5737592 (1998-04-01), Nguyen et al.
patent: 5740421 (1998-04-01), Palmon
patent: 5768578 (1998-06-01), Kirk et al.
patent: 5774692 (1998-06-01), Boyer et al.
patent: 5797136 (1998-08-01), Boyer et al.
patent: 5809248 (1998-09-01), Vidovic
patent: 5819264 (1998-10-01), Palmon et al.
patent: 5842212 (1998-11-01), Ballurio et al.
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5895454 (1999-04-01), Harrington
patent: 5909678 (1999-06-01), Bergman et al.
patent: 6058391 (2000-05-01), Gardner
patent: 6058393 (2000-05-01), Meier et al.
patent: 6108664 (2000-08-01), Nori et al.
Black Linh
Orillion International, Inc.
Robinson Greta
LandOfFree
Browser oriented method of viewing database structures does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Browser oriented method of viewing database structures, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Browser oriented method of viewing database structures will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3131319