The Actian OpenROAD toolset supports an n-tier architecture; you can use an Ingres or MS SQL Server database.  It is also possible to use an Oracle database. The architecture ensures minimal network traffic.  The application logic is executed on an Application Server that ensures high performance levels are achieved.

The presentation layer is a thin client that handles the instructions regarding the interface e.g. to select an employee, to check that all mandatory details have been entered, or to display a message if an incorrect value has been entered. 

Independent Security for Functions and Data

Security is provided to limit both the functions that can be performed and the data that can be accessed by both personalised controls and the creation of profiles that users can be allocated to.  These controls have been written into the application and are independent of the operating system / network security.

MyWORKPLACE's Multi-tier Architecture

The Actian OpenROAD toolset supports an n-tier architecture where the client may use an Ingres or MS SQL Server database.   

Developing the system to the n-tier structure enables it to be deployed across a company’s wide area network (WAN) while requiring a single centralised database. 

Remote Access to the Application Server

The presentation layer is a thin client that handles the instructions regarding the interface e.g. to select an employee, to check if all mandatory details have been entered, or to display a message if an incorrect value has been entered. 

The processing of the business logic is performed on an application server.  This processing retrieves, updates, inserts and deletes data, applies business rules and calculations that require interaction with the database, or may be used from more than one screen.

High Performance Levels Executed by Application & Database Servers

The processing is typically centralised and located near the database server or on the physical database server.  The database optionally contains processing and referential integrity rules.  However, the database always contains the data for the application. 

The SQL queries that manipulate the data are executed on the database server.  This architecture ensures minimal network traffic and that the application logic is executed on servers that ensure high performance levels are achieved.

MyWORKPLACE's Development Tools 

The Actian OpenROAD programming language can connect to Ingres and MS SQL Server databases using ANSI standard SQL.  The language supports writing to and reading from ‘external’ files.  This ensures the application can interface to or integrate with other databases.

The OpenROAD technology has a high level of platform independence.  The application operates on Windows without having to alter the code.

Relational Database Management System

The database can be any standard RDBMS (Relational Database Management System) database, such as MS SQL Server, and Ingres.  The application can run on the various versions of Windows clients.