Relational database information management system for facilitating normalization of a relational database

• US 5,566,333 A
• Filed: 11/05/1992
• Issued: 10/15/1996
• Est. Priority Date: 11/05/1992
• Status: Expired due to Fees

• Current Assignee: Trace Technologies LLC
• Original Assignee: Trace Technologies LLC
• Inventors: Olson, Michael J., Reibert, David, Slow, Stanley A.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): WANG, PETER
• Application Number:
  US07/972,230
• Time in Patent Office: 1,440 Days
• Field of Search: 395/600
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A computer system that incorporates an SQL type relational database is adapted to enterprises in which human performance is to be managed. There is a single table that contains linking information for multiple entity relationships among a plurality of information entities. Programs that cooperate with the database kernel include an entity relation manager for modifying the linker table to dynamically define entity relationships among the information entities; a hierarchal structure manager for dynamically defining hierarchal relationships among objects in the information entities; a load/unload utility, for changing information between a human-readable format and another format having a syntax acceptable to the database kernel; and an editor which provides an environment that enables a human operator to conveniently interact with the relational database.

Claims

1. An information management system, comprising:

at least one computer;

a relational database stored in a memory that is accessible to said computer, said relational database comprising a relational database kernel, a plurality of information entities, each said information entity being comprised by a respective one of a plurality of entity tables, and a linker table for holding a plurality of many-to-many relationships among said information entities;

computer-implemented entity relation management program means, for manipulating data in said linker table to dynamically define many-to-many relationships among said information entities, such that many-to-many relationships in the relational database can be created and modified by a user to manage the relational database without structurally changing the relational database by one of creating and deleting tables thereof; and

computer-implemented report generating program means, cooperating with said relational database kernel, for producing a coherent report that is informative of said relational database.

2. The system according to claim 1, further comprising computer-implemented hierarchal structure management program means, for dynamically defining hierarchal relationships among said information entities;

said hierarchal relationships being compatible with operation of said relational database kernel.

3. The system according to claim 1, further comprising computer-implemented editor program means, for introducing and modifying data in said relational database and for instructing said relational database kernel.

4. The system according to claim 1, further comprising computer-implemented load/unload program means, for changing information between a first state that is intelligible to a human operator of said editor program means, and a second state having a format compatible with operation of said relational database kernel, an output of said load/unload program means being stored in said memory, such that a human operator can conveniently interact with said relational database.

5. The system according to claim 1, wherein said entity relation management program means associates parametric data with said information entities.

6. The system according to claim 1, further comprising a table having information that is generically descriptive of relational databases that can be managed by said system.

7. An information management system to ensure that humans perform to required standards while undertaking critical tasks in a complex environment, comprising:

at least one computer;

a relational database stored in a memory that is accessible to said computer, said relational database comprising a relational database kernel, a table having information that is generically descriptive of an enterprise that can be managed by said system, a plurality of information entities, each said information entity being comprised by a respective one of a plurality of entity tables, and a linker table for holding a plurality of many-to-many relationships among said information entities;

computer-implemented entity relation management program means, for manipulating data in said linker table to dynamically define many-to-many relationships among said information entities;

computer-implemented associated with said entity relation management program means, for associating parametric data with said information entities;

computer-implemented hierarchal structure management program means, for dynamically defining hierarchal relationships among said information entities;

said hierarchal relationships being compatible with operation of said relational database kernel;

computer-implemented editor program means, for introducing and modifying data in said relational database and for instructing said relational database kernel;

computer-implemented load/unload program means, for changing information between a first state that is intelligible to a human operator of said editor program means, and a second state having a format compatible with said operation of said relational database kernel, an output of said load/unload program means being stored in said memory; and

computer-implemented report generating program means, cooperating with said relational database kernel, for producing a coherent report that is informative of said enterprise;

such that many-to-many relationships in the relational database can be created and modified by a user to manage the enterprise without structurally changing the relational database by one of creating and deleting tables of the relational database.