A system for handling bills of exchange circulation

This was a contract development job for the Interregional Association "Siberian Treaty" and aims at deployment of the infrastructure for bills of exchange circulation over the territory of the Russian Federation.

Features:

• Implemented in client-server technology, remote access
• Operational system: UNIX
• Database: ORACLE
• Programming languages: C++, PL/SQL

Purpose:

• Generation and transfer of large packages of low-value bills of exchange in implementing wide-ranging Bill of Exchange programs made easier.
• All of the traders involved can track the progress and turnaround of Bills of Exchange and their geographical migration.
• Forgery of bills is impossible.

Capabilities:

• The system enables the running of all transactions to do with bills of exchange, such as (circulation launch, endorsement, leaving as a deposit, paying off as well as blocking bills of exchange on redemption, transferring them over to the auctions at the exchange sale, etc.), with all the documents confirming the transactions being generated automatically.
• Storage and processing data on hundreds of thousands of users and millions of bills (with their complete transaction histories), including:
  • Generation of miscellaneous statistical & analytical reports based on real information,
  • Running a unified legal & reference database accessible to all the users,
  • Keeping records of all funds received as a payment for registering ownership rights with reference to bills of exchange and personal client's accounts,
  • Issuing invoices and other documents needed by the bookkeeper of an enterprise

The unified database provides real-time functioning to all involved in the process no matter where they are located.

• The system guarantees a high level of security and reliability, including:
  • online monitoring support and control of the whole process at various levels
  • quick recovery of data stored on carriers, in case of equipment failure and the possibility of non-automatic operation if the equipment breaks down completely

In building the system, we used the most recent solutions based on licensed and certified software products.

Ideology of the system:

• All users are administered and maintained from the central node linked to remote users via telecommunication facilities.
• All the data is stored at the unified server, and users are equipped with monitors. Thus, they are accessing online to the unified database in real-time.
• Security is provided through telecommunication cryptographic protection hardware and plastic card technology, which prevents unauthorized access to a client's account and establishes identity in performing transactions.
• To avoid system failures, backup systems for telecommunications and data storage & processing are provided.

Technical details:

• Number of client workstations - up to 500
• Maximum number of clients serviced - up to 200,000 (However, this number can be expanded as the server power increases)
• It takes 15 seconds to perform a transaction (even if thousands of Bills of Exchange are transmitted).
• Time needed for generating reports is between 15 and 120 seconds.
• The archive storage is 1 to 5 years.
• Transactions between the Central Office and Affiliates are performed automatically.