This paper presents a real-life economic demand for and a preliminary solution of a compact registry system for securities. While such registries do exist, they are usually part of a larger suite of software, which are not affordable (or economical) for smaller voluntary pension fund companies.
During my studies I got the most practice with the Java programming language (Standard Edition in particular), therefore I decided to implement a solution that requires Java Virtual Machine to run. To make some connection with my earlier projects, I have chosen the recently released JavaFX 2.0 platform for developing the user interface and JDBC (Java Database Connectivity) technology to access the database. My choice of database management system is Microsoft SQL Server 2008 R2 Express as it has been satisfactory at handling previous data driven projects of mine.
JavaFX technology changed substantially since its original release. It started out as an experiment to provide a common development environment for desktop, mobile phones and HDTV devices. Its current purpose is to support the development of lightweight Java user interfaces for enterprise business applications.
The registry system presented in my thesis work handles security-based investments, which are identified by their International Securities Identification Number (abbreviated as ISIN), the portfolio they belong to, the supervising trustee company and the operation identifier of its purchase transaction. While processing a transaction, any investments of the same kind (i.e. they differ only in their purchase ids) have to be considered as part of a FIFO queue, ordered by their purchase date. A transaction – more often than not – may affect multiple bundles of securities and it is imperative that the older ones are processed first.
The development consists of three areas: database design – master data and transactional data alike; business logic design – the methods are regulated by legislations and the handling of a given operation is considerably affected by the form of security it is performed on; user interface design – the introduction of the JavaFX 2.0 platform is an essential part of this thesis.