Until recently there has been no way or to manage and control subdivisions of an application – departmental control; or to duplicate the application/DBMS to support more than one instance of a database – multi-customer hosting.
In jBASE 5, the database grouping is achieved by the used of the JBASE_DATABASE environment variable; not specifying this will result in the user being assigned to the “default” database group. This allows the system administrator to control access to various populations of user/applications, without affecting the other users/applications.
Users may now be assigned a target grouping or “database” when they access applications. This “database” enables finer control over which groups of users may access the database. This grouping is likely to be on a departmental or functional basis, i.e. users may be assigned to the “Sales” or “Accounts” database or even the
“Administrators” database. This physical database may thus be physically or logically split by functional areas. Control of each of these areas is by the assigned “database” name. Thus it is possible to restrict access to the database to only, say, those users who are in the “Administrators” database group etc. The database could
be designed such that each functional area contains files pertinent to each area and that files which are shared between functional groups are stored in a central repository, with access available to all.
It should be stated that this “database” grouping is not intended to replace file ownership and access permissions which are normally in existence.
An application could be replicated such that a provision is made to support multiple
customers each running the same application but with each having their own copy of
database files. In this instance the “database” grouping could be by customer, thus
allowing control over each distinct customer database.
The default configuration of databases is as follows :
There will always be a “default” database file and a “databases_defined” file defined within the system. In order for the system to run, the environment variable JBCRELEASEDIR must exist in order to find where jBASE resides. This will be the default entry within the “databases_defined” file. Each defined database will
contain information about where to find Transaction Journaling configuration and administration files. This will be defaulted to JBCRELEASEDIR location if not specified.
Two environment command may be used to assign a user or application to a particular database and to use a particular set of Transaction Journal files:
will assign this user/application to the specified database.
set JBCLOGCONFDIR=”path of TJ configuration”
will assign Transaction Journal log files as defined in the configuration files found at this location. This command is not mandatory. If not used the default location will be used.
Database Control Commands