Home success through knowledge & experience
Site Map

Case Studies
>> Services > Case Studies > System Architecture



more...  Calculating Royalties

more...  Tracking Payments

more...  System Architecture

more...  Client Overview

more...  Data Input

more...  Process

System Architecture

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.

Copyright 2002-2007 SITech