Verity Restructure and Upgrade Project

About The RCMP
The Royal Canadian Mounted Police (RCMP) is the Canadian national police service and an agency of the Ministry of Public Safety and Emergency Preparedness Canada. The RCMP is unique in the world since it is a national, federal, provincial and municipal policing body. The RCMP provides a total federal policing service to all Canadians and policing services under contract to the three territories, eight provinces (except Ontario and Quebec), approximately 198 municipalities and 192 First Nation communities

Project Requirements and Solutions
The RCMP has identified key architectural and operational issues with their Enterprise Computing Infrastructure Services Branch (ECS) that required resolution. BAU was tasked to provide expert help to the RCMP in the migration of Verity Portal 1.3 to Verity K2, the designing and implementing of a production Oracle database architecture, and planning for the rollout of these applications throughout the RCMP environment into production.

As a solution to the above requirements, BAU provided a full analysis of the current system and provided a plan to: establish a development environment that would reflect the current and future needs of the RCMP clients, provide a migration strategy to rollout a new system across their full enterprise; develop a well organized and future directed Oracle database architecture, tune Verity K2 components to ensure optimized performance; provide load balancing and stress testing for all major system components; and provide knowledge transfer mechanisms to RCMP staff.

Specific deliverables for this project included:

• Deliver project work plans and regular customer status reports
• Assess the requirements to deploy a new architecture and enhance the search capability
• Design and build an Oracle data architecture to support over 1 million documents and a user base of 10,000
• Migrate the Royal Canadian Mounted Police search engine from Verity Portal to Verity K2
• Enhance 16 collections with Verity K2, and deploy parametric index and topic sets
• Implement new search techniques to increase knowledge and deploy user-friendly search interfaces
• Integrate LDAP with Verity and provide collection level security to the data
• Deploy application patches and system enhancements where required
• Create code scripts for error checking and system patches

BAU provided resources within the following roles:

• Senior Project Manager
• Technical Architect
• Data/Taxonomy Analyst
• Programmer Analyst
• Database Specialist

The major technologies employed by the BAU team include:

• Oracle 9i
• Verity K2
• J2EE
• JSP
• XML
• ERWIN
• LDAP
• JDBC
• MS Project
• MS Visio