Data Management Case Studies
Document Management System
Our client
This project was implemented for Kerala Legislative Assembly (KLA), Trivandrum
The challenge they brought to us
The KLA wanted a Web-based application to enable their application users to search, view and retrieve details of KLA proceedings over the Internet.
The requirement was for a portal using PhP and a MySQL server to deliver an efficient search for Meta data stored in their database. The KLA wanted searches to be enabled in both English and Malayalam languages with the option of browsing through the documents.
The development challenges we faced included
- Data migration: the existing database needed to be migrated to the new database without any transcription errors or loss of data.
- Integration: The resulting application should work seamlessly with the database system to provide consistent and reliable results
- Scaleability and future proofing: The system needed to be able to handle the growing list of documents without compromising system performance.
- Completeness: The search management features should be defined very widely to include all possible parameters including the option to search in Malayalam.
- Absence of clear specification document at the start of the project: we needed to define the system requirements to make sure we would meet the client’s expectations for the service
- Remote deployment at the customer location: we would need to implement the application remotely for the KLA.
The solution we delivered
This complex and multi-layered project was one of the first of its kind in Kerala. In spite of the development challenges, the experienced SBL team was able to design and deliver to the KLA a sophisticated, unique, customised document management system based on their specific requirements.
This portal application provides enterprise-wide access to digitised documents maintained as records. Version control of documentation was also available. Documents provided were available in Word, Excel and PDF formats.
In addition to the User module functionality available to the public, we created an Administration Module with comprehensive data management and organisation functionality based on CRUD (Create, Retrieve, Update, and Delete) operations.