Architecturally PRTS is a two-tier client-server system with Oracle RDBMS as a back-end
and an arbitrary number of GUI clients implemented as Windows applications connected to
the server via ODBC and Oracle Net8. The server side provides data services and implements
business logic; the client side provides user interface and some business rules.
A PRTS user manages PRTS data via the PRTS Client software. A user can start interfaces
with external databases, run internal data processing routines, such as Data Diagnostic
and Royalty Calculator. These interfaces and routines are implemented as stored procedures
and packages on the Server part. On completion of an interface or internal routine a user
can examine the results, including error messages, warnings, and data exceptions. Besides,
he / she can explore and modify PRTS data directly within a Client application.