ClaroLogic Limited (UK) has chosen Daffodil DB as a reliable backend for its Java-based library management application - RarusLibri. Daffodil DB added value to the application by offering advance features, such as user-defined functions and PSM.
The Situation: Exploring New Markets
With the software products market expanding worldwide, ClaroLogic opted to exploit the growing opportunities in software development. The company identified a gap in the library management software market and wanted to design a comprehensive platform-independent application for managing all tasks of a library.
The Challenge
To develop the complete library management package, the team at ClaroLogic needed a viable backend option which, apart from being platform-independent, could also be successfully embedded with the application (RarusLibri) at an affordable cost.
The requirement was for small footprint database that could be embedded with their application with zero maintenance. RarusLibri specifically required the database to support the following key features:
- SQL stored procedures.
-
- PSM (Persistent Stored Modules) for implementing complex business logic at the database level.
-
- Extensive database Triggers through which the programmer could throw user-defined exceptions.
-
- Support for encryption algorithms to ensure data security.
Daffodil DB met all the key requirements of ClaroLogic, thereby facilitating uncomplicated bundling with RarusLibri. Being a Java RDBMS, Daffodil DB is platform independent and thus integrated well with the overall objective of ClaroLogic to develop systems that do not tie an individual or a business to a particular platform or paradigm.
Daffodil DB being a small footprint database delivers high performance with minimum resource usage and can be easily bundled with all kinds of enterprise applications at zero maintenance. It also supports following distinctive features, which added value to the Library Management application developed by ClaroLogic.
- SQL stored procedures: External methods of a Java class can be invoked via triggers in Daffodil DB. This facilitats ClaroLogic to write procedures in Java and executes the procedures along with the support for invoking methods written in PSM by default.
-
- PSM for implementing complex business logic at database level: Daffodil DB provides the flexibility of distributing and processing transactions across the network for client/server applications by supporting PSM. This allowed the developers at Clarologic to implement their complex programming logics at the database level with the help of stored procedures and triggers. This feature also lead to prompt application responses and a faster turnaround time.
-
- Database Triggers: Triggers supplement the standard capabilities of Daffodil DB to provide a highly customized database management system. Daffodil DB allows its users to define procedures that are implicitly executed when an INSERT, UPDATE, or DELETE statement is issued against the associated table. This feature enabled the developers to throw user-defined exceptions.
-
- Encryption Algorithms: To ensure data security, Daffodil DB supports various encryption algorithms. The user can choose any of the defined algorithms and can encrypt the data before storing them in a table.
The collaboration of Daffodil DB and ClaroLogic resulted in a user-friendly, low-cost, feature-rich, and platform-independent library management application (named as RarusLibri).
RarusLibri Business software allows antiquarian, second-hand book dealers, or small private/public libraries to organize catalogue and manage book stocks or collections on their PCs. RarusLibri Business is intuitive and easy-to-use for the beginner, while being feature-rich and powerful enough to satisfy the needs of the advanced user.
About ClaroLogic
ClaroLogic, a UK-based software firm, develops Java-based applications mostly used in Banking and Investment industry. Its mission is to develop systems that do not tie an individual or a business to a particular platform or paradigm. The company provides flexible, scalable, object-oriented and high-quality products at an affordable cost.