|
 |
|
|
|
|
The Gnosis Business Rule Manager is a Windows application that has been developed to manage the database schema for a Gnosis Database, which includes the definitions of a Gnosis Auditable and Gnosis Transaction databases. All business rule objects are stored in the Microsoft SQL Server™ database.
The Business Rule Manager displays details of the following kinds of objects; Databases, Types, Tables, Views, External Objects, Key Constraints, Check Constraints and Business Entities.
|
 |
The Gnosis Business Rule Manager showing a Table and its Columns. |
| The Gnosis Business Rule Manager supports a powerf ul object known as a Business Entity. A Business Entity is a grouping of Gnosis-Objects (Tables or Views) as one. In the example shown below, the Transformer Business Entity is composed of the Gnosis Objects Transformer, Equipment and Installation, and references the objects Manufacturer and Transformer Type. |
 |
The Gnosis Business Rule Manager showing a Business Entity. |
| The Business Rule Manager also controls the process of checking the validity of the database model and generating the physical database in SQL Server. Checks performed on a Database Model, include validating Table Key definitions, Index definitions, Foreign Key definitions and Check contraint definitions. Once the data model is successfully checked then it can be generated. The generation process creates all SQL Server objects that are used in the database, which are such as SQL-Tables, SQL-Views, SQL-Stored Procedures and SQL-Triggers. |
 |
The Gnosis Business Rule Manager showing the Check and Generate form. |
|
|
|
