Method for modeling a physical system of elements using a relational database

Claim 3

A computer-implemented method for determining an allocation of elements in a power system by modeling in an object-oriented relational database historical and predicted performances of particular elements in the power system, comprising: identifying the physical elements in the power system; storing in the relational database an object table that associate an object with each element of the physical system; storing in the relational database multiple type tables, each type table including instances of one of the objects in the database; storing in the relational database a grouping table that defines the relationships existing among the elements at the physical system; capturing historical performance data associated with the elements; linking the historical performance data through a data port to the computer; searching the relational database for a particular element; determining the historical performance of the particular element; changing a performance criterion of the particular element to a predicted performance criterion; modeling the predicted performance of the particular element at different locations in the power system; allocating the particular element to a particular location in the power system to satisfy the modeled predicted performance criterion; and updating the object table to reflect the allocation of elements in the power system.

Claim 4

A computer-implemented method for determining an allocation of elements in a power system by modeling in an object-oriented relational database historical and predicted performances of particular elements in the power system, comprising: identifying the physical elements in the power system; storing in the relational database an object table that associate an object with each element of the physical system; storing in the relational database multiple type tables, each type table including instances of one of the objects in the database; storing in the relational database a grouping table that defines the relationships existing among the elements at the physical system; capturing historical performance data associated with the elements; linking the historical performance data through a data port to the computer; searching the relational database for a particular element; determining the historical performance of the particular element; changing a performance criterion of the particular element to a predicted performance criterion; modeling the predicted performance of the particular element at different locations in the power system; allocating the particular element to a particular location in the power system to satisfy the modeled predicted performance criterion; and updating the object table to reflect the allocation of elements in the power system.

Claim 5

A computer-implemented method for modeling a physical system using an object-oriented information model of the physical system, the information model being extendable by a user and implemented using a relational database using simple attributes that lack internal structure so that the relational database is accessible using standard relational database tools, the method comprising: storing in the relational database an object table that defines objects associated with elements of the physical system, the object table specifying attributes of each object including the object type, and the information model creating new objects of existing or new types in response to user input; storing in the relational database multiple type tables, each type table including entries representing instances of physical objects of the corresponding type, the information model creating type tables in response to the user creating new types of objects that are subclasses of objects defined in the object table and creating records in the type tables in response to users creating new objects of defined types; storing in the relational database a grouping table, the grouping table defining all the relationships among the elements of the physical system, the information model adding relationships to the grouping table in response to the user creating new objects and defining relationships in which new and existing objects participate, thereby allowing the user to query the database concerning relationships involving user-defined objects using without creating new query programs to handle those newly defined objects; and selectively accessing information stored in the relational database to perform operations involving objects in the physical system.

Claim 6

A computer-implemented method for modeling a physical system using an object-oriented information model of the physical system, the information model being extendable by a user and implemented using a relational database using simple attributes that lack internal structure so that the relational database is accessible using standard relational database tools, the method comprising: storing in the relational database an object table that defines objects associated with elements of the physical system, the object table specifying attributes of each object including the object type, and the information model creating new objects of existing or new types in response to user input; storing in the relational database multiple type tables, each type table including entries representing instances of physical objects of the corresponding type, the information model creating type tables in response to the user creating new types of objects that are subclasses of objects defined in the object table and creating records in the type tables in response to users creating new objects of defined types; storing in the relational database a grouping table, the grouping table defining all the relationships among the elements of the physical system, the information model adding relationships to the grouping table in response to the user creating new objects and defining relationships in which new and existing objects participate, thereby allowing the user to query the database concerning relationships involving user-defined objects using without creating new query programs to handle those newly defined objects; and selectively accessing information stored in the relational database to perform operations involving objects in the physical system.

Claim 7

The method of claim 3 in which a single object table includes all objects in the information model.

Claim 8

The method of claim 3 in which a single grouping table includes all relationships in the information model.

Claim 9

The method of claim 5 in which the grouping table includes one-to-one and many-to-one relationships.

Claim 10

The method of claim 3 in which each object in the object table corresponds to an entry in at most a single type table.

Claim 11

The method of claim 3 in which the object table contains objects that represent instances and objects that represent classes.

Claim 12

The method of claim 3 in which some objects in the object table have corresponding entries in type tables and some objects in the object table do not have corresponding entries in type tables.

Claim 13

The method of claim 3, in which each entry in a type table corresponds to an entry in the object table.

Claim 14

The method of claim 3 further comprising storing in the relational database a type-subtype table defining supertype-subtype hierarchies among the objects in the object table, the attributes of a supertype being inherited by its subtypes.

Claim 15

The method of claim 11 in which the information model automatically updates the type-subtype table when the user creates a new type or subtype.

Claim 16

The method of claim 11 in which subtypes includes attributes in addition to those inherited from the corresponding supertypes.

Claim 17

The method of claim 3, additionally comprising: assigning to each object in the object table a unique surrogate key by which the object is identified, the surrogate key being used as a foreign key in corresponding type tables and grouping tables; and searching the relational database for a particular surrogate key using a balanced binary tree index employing sequential keys.

Claim 18

The method of claim 3 in which the data model includes base types that are used to map objects for database procedures, including data input and editing procedures.

Claim 19

The method of claim 3 in which the grouping table includes organizational relationships and functional relationships.

Claim 20

The method of claim 3, further comprising accessing and modifying information stored in the relational database through a graphical user interface based on a window environment and in which the user inputs data into the system from a set of possible input data contained within the system to reduce error in data entry.

Claim 21

The method of claim 3 in which the information model includes system objects that are not modifiable by the users, user application objects that are used by user-written applications to define well known or reserved types, and users types that are defined and modified by the user to express the desired depth of classification.

Claim 22

The method of claim 3, further comprising: interconnecting the computer with a second computer using a data transfer pathway; and importing data from a database associated with the second computer, such that a single point of maintenance is provided at the computer.

Claim 23

The method of claim 3, further comprising: interconnecting the first computer with a second computer using a data transfer pathway; and exporting data from the computer to database the second computer, such that a single point of maintenance is provided at the computer.

Claim 24

The method of claim 3, further comprising capturing operating states of the physical system in a historic data storage system for later analysis.

Claim 26

The method of claim 3 further comprising storing in a table of the relational database permissible relationships among objects and verifying that user-defined relationships are permissible before adding the relationship to the grouping table.

Claim 27

The method of claim 3 further comprising storing in the relational database acceptable object attribute values and verifying that values provided by the user for object attributes corresponds to the acceptable values.

Claim 28

The method of claim 3 in which the physical system of elements is an electrical power system.

Claim 29

The method of claim 25 in which the grouping table includes the relationships of connectivity, grouping, and location.

Claim 30

The method of claim 3 in which the physical system comprises an electric power system and the information model includes information corresponding to network topology, operational constraints, telemetry, and communication details.