170 likes | 450 Views
Evaluation of Database Management Systems Summation and SharePoint. Colette Joubarne, Raghad Al-Awwad April 1, 2011. Outline. Problem setup Company Company's project Our task Candidate Solution Summation Microsoft's Sharepoint Requirements Evaluation Future.
E N D
Evaluation of Database Management SystemsSummation and SharePoint Colette Joubarne, Raghad Al-Awwad April 1, 2011
Outline • Problem setup • Company • Company's project • Our task • Candidate Solution • Summation • Microsoft's Sharepoint • Requirements Evaluation • Future
Largest applied and historical research company in Canada • With offices in Vancouver and Ottawa • Government (DND, INAC, DFO) and private sector clients (First Nations) • Litigation support, public safety, land use, tourism
Truth and Reconciliation Commission of Canada • digital archive of historical records related to the Indian Residential School system (IRS) • support 3 - 7 million multi-format, cultural-based materials (including maps, video, photographs, microfilm, sound files, documents)
Task: Current System • Summation is designed for litigation • over 3 million existing records held in Summation databases will need to be converted if another solution is chosen
Task: Other Systems CDCI options: • Microsoft SharePoint • OpenText
Who’s our Users? • Historical researchers • Data entery clerks • I.T. • Management
CT Summation iBlaze • AccessData • automated litigation support software used to organize discovery and evidence in a litigation case • Integrates transcripts, document databases, images, and access to on-line repositories • provides the ability to annotate case elements, track production, create links, and create presentations from images
Microsoft • Managing and provisioning of: • extranets and websites, • document management and file management • collaboration spaces, • social networking tools, • enterprise search, business intelligence tooling, process/information integration • third-party developed solutions • Highly scalable
Requirements Evaluation • Traceability matrix • GRL • Softgoal breakdown • Requirement testing • UI evaluation • Execute the scenarios
High Level GRL High Level GRL
Data Entry Metadata Y/N Rank UI Contribution 2 Shall allow the user to add metadata to a record X Record Conversion 32 Shall support import/export of records in Open Standard Format (ie XML or Unicode) X 51 Shall support importing of digital records from other formats X 52 Shall support exporting of records to other formats X Ease of Use 1 Intuitive user interface 21 Shall support look up tables 24 Shall validate data when entered 25 Shall mask sensitive data 26 Shall be able to duplicate records X 27 Shall allow users to search and replace records X 28 Shall have a help menu that includes online support, tutorials, content search and index search 29 Shall have single-click tagging of record X
To Do • Customer feedback on contribution of softgoals • Complete testing • User testing
Things to Consider • High cost per license of Summation may affect user access • Task specific software vs generic • Negative connotation of litigation software • Future direction of the CDCI • Robustness of software
...brings us to the end of the presentation ...Any Questions?