Method for modeling a physical system of elements using a relational database
First Claim
1. A method for creating a computer implemented single source information model based on physical elements in a system, comprising the steps of:
- creating a type hierarchy, the hierarchy being downwardly extendable by a database user, the objects lower in the hierarchy being a type of the object higher on the hierarchy and inheriting attributes from the higher level objects;
identifying as objects said physical elements;
collapsing said objects into relational database tables, where attributes specific to all objects below base types are collapsed into type tables, and all objects above base types are collapsed into object tables, using a common object table with surrogate keys; and
externalizing and collapsing object relationships into tables, using typing to identify the type and relationship.
1 Assignment
0 Petitions
Accused Products
Abstract
An information model based on a physical system, such as the physical equipment in a power system. An object-oriented information model provides a generic power system model that may be applied to any of several specific applications. In the invention, physical pieces of equipment are represented as objects with attributes that can be verified (primary data) and relations including connectivity, grouping, and location. The model handles all known configurations of power systems and is extensible to new configurations. Attribute input is supported from primary sources and is used to calculate data required by applications programs. A window-based graphical user interface uniquely simplifies operation of the database. Thus, the present invention provides a single, easy to use, source for all proprietary application databases at a utility.
314 Citations
27 Claims
-
1. A method for creating a computer implemented single source information model based on physical elements in a system, comprising the steps of:
-
creating a type hierarchy, the hierarchy being downwardly extendable by a database user, the objects lower in the hierarchy being a type of the object higher on the hierarchy and inheriting attributes from the higher level objects; identifying as objects said physical elements; collapsing said objects into relational database tables, where attributes specific to all objects below base types are collapsed into type tables, and all objects above base types are collapsed into object tables, using a common object table with surrogate keys; and externalizing and collapsing object relationships into tables, using typing to identify the type and relationship.
-
-
2. 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.
-
-
3. 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. - View Dependent Claims (4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27)
-
Specification