| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Stop wasting time looking for files and revisions. Connect your Gmail, DriveDropbox, and Slack accounts and in less than 2 minutes, Dokkio will automatically organize all your file attachments. Learn more and claim your free account.

View
 

Primary Key - Scorecard

Page history last edited by naraphong 11 years, 3 months ago

PRODUCT FUNCTIONALITY

Analysis of top products chosen by Primary Key voting on http://www.SurveyMethods.com

 

Feature  Oracle Access TrackVia Grubba Zoho
Response Time .08 seconds per transaction   Quick response (200 rows in test) Quick response (200 rows in test) Quick response (200 rows in test)
Compatibility Imports and exports into Excel /PDF

Imports and export to Excel, Outlook, txt file, XML, ODBC, and HTML contenet

Import from spreadsheet

Export to Excel

Import from CSV and txt file

Export to Excel

Import from CSV,TSV,Excel and HTML content;

Export to CSV and PDF file

Access Controls

1. Priveleges

 

2. Store Procedures

 

3. Roles

 

4. Views

 

5. Virtual Private Databases

1. Priveleges

 

2. Roles

 

3. Views

Database permissions come in three types:

- record permissions (Add/View/Edit/Delete Data)

- field permissions

(show/hide a field)

- feature permissions

(Export, Open feature)

3 level of user management:

- Read only

- Read & write

- Administrator

Share DB by using username or Database Group;

2 priority option -View / Add & Edit

User Interface

 

SQL PLus

Similar to Microsoft Office product Web 2.0 with Ajax Web 2.0 with Ajax

Web 2.0 with Ajax, quiet impressive looking; similar to excel and spread sheet

Reporting Functionality Java Web Based Reporting Can create report in 3 layout styles: Columnar, Tabular or Justified Can create report in Tabular View,and Summary view Can create report in Tabular view Can create report in Tabular View, Chare view, Matrix view, and Summary view
Database Functionality Can use SQL to modify database Can use SQL to modify database   Cannot use SQL to modify database Cannot use SQL to modify database Can use SQL to modify database
Multi-Language Support multi-language Support multi-language Not support multi-language Support multi-language Support multi-language
Used via internet/ on desktop off network Both Internet and Desktop  Both Internet and Desktop Internet based database  Internet based database  Internet based database
Ease of use / learning curve Requires significant IT skills  Requires significant IT skills  Not require IT skill (training could help understand bettwer) Not require IT skill Not require IT skill
Reliability of the site/ software Yes Yes  Yes / Can enable SSL encrytion and restrict access by IP address Yes / Can enable SSL encrytion Yes
Storage space required

 

4.5GB

(version 2003/ minimum 180 MB) - - -
Secure from Viruses Yes Yes Not really Not really Not really
Cost Vendor Quote Vendor Quote Start rate $249 / 20 users/ month Free Free for first 3 and $12/user/month 
Ability for multiple users to access/edit at same time Yes Yes Not really Not really Not really

 

PRODUCT SCORECARD/ PRODUCT FUNTIONALITY FIT TO USE CASE

 

ERM Use Case

 

 

 

Features 

Requirement 
Rating

(for details please see detailed use case page) 

 

Pt Value

(1-3) 

 

Oracle

 

Access

 

 

Grubba

 

 

TrackVia

 

 

 

pts

(1-3) 

 

 total

 

 

pts

(1-3) 

 

 total

 

 

pts (1-3) 

 

 total

 

 

pts (1-3) 

 

 total

 

 

 

Response Time 

Must Have  

 

Compatibility 

Must have  5 6 2 5 2 5  
Access Controls  Must have  3 3 8 3 8  
User Interface  Basic  9 10 9 1 9  
Reporting Functionality  Must have  12 2 12 2 11 2 11  
Database Functionality  Intermediate  14 14 1 12 1 12  
Multi-language  Basic  15 15 13 1 13  
Use via internet and desktop Must have 3 2 16 2 17 3 16 3 16  
Ease of Use / Learning Curve  Intermediate  17 19 2 18 2 18  
Reliability Must have 3 3 20 3 22 3 21 3 21  
Storage Space Required Intermediate 2 1 21 1 23 2 23 2 23  
Secure from Viruses  Intermediate  23 25 1 24 1 24  
Free or low cost  Intermediate 2 1 24 1 26 2 26 1 25  
Ability for two or more staff to access and edit simultaneously  Must Have 3 3 27 3 29 2 28 2 27  
TOTAL SCORE       27   29   28   27  

 

The winning software for the ERM use case is MS Access.

However Grubba is online, free, requires less IT know-how, but has less functionality. Hence, given a different dimension scoring system and context, Grubba could in some more basic ERM situations be the preferable product. This is my runner-up.

 

CRM Use Case

 

 

 

Features 

Requirement 
Rating

(for details please see detailed use case page) 

 

Pt Value

(1-3) 

 

Oracle

 

Access

 

 

Grubba

 

 

TrackVia

 

 

 

pts

(1-3) 

 

 total

 

 

pts

(1-3) 

 

 total

 

 

pts (1-3) 

 

 total

 

 

pts (1-3) 

 

 total

 

 

 

Response Time 

Must Have

 3

 3

 3

 1

 1

 2

 2

 2

 2

 

Compatibility 

Must Have 3 3 6 2 3 1 3 2 4  
Access Controls  Must Have 3 3 9 2 5 2 5 2 6  
User Interface  Intermediate 2 2 11 1 6 1 6 1 7  
Reporting Functionality  Must Have 3 3 14 3 9 2 8 3 10  
Database Functionality  Must Have 3 3 17 2  11 2 10 2 12  
Multi-language  Must Have 3 3 20 1  12 1 11 1 13  
Use via internet and desktop Must Have 3 3 23 3 15 2 13 2 15  
Ease of Use / Learning Curve  Must Have 3 3 26 2 17 2 15 1 16  
Reliability Must Have 3 3 29 1 18 1 16 2 18  
Storage Space Required Intermediate 2 3 32 1 19 1 17 1 19  
Secure from Viruses  Must Have  3 3 35 2 21 2 19 2 21  
Free or low cost  Basic 1 2 37 3 24 3 22 2 23  
Ability for two or more staff to access and edit simultaneously  Intermediate 2 3 40 2 26 2 24 2 25  
TOTAL SCORE       40   26   24   25  

 

 

Online Encyclopedia Use Case

 

 

 

Features 

Requirement 
Rating

(for details please see detailed use case page) 

 

Pt Value

(1-3) 

 


Oracle


Grubba

 


MS Access

 


MS SQL Server

 

 

pts

(1-3) 

 

 total

 

 

pts

(1-3) 

 

 total

 

 

pts (1-3) 

 

 total

 

 

pts (1-3) 

 

 total

 

 

 

Response Time 

Must have

 

Compatibility 

Basic 1 1 4 1 3 1 3 1 4  
Access Controls  Intermediate  2 2 6 2 5 2 5 2 6  
User Interface  Must have 3 2 8 3 7 3 8 3 9  
Reporting Functionality  Basic 1 1 9 1 8 1 9 1 10  
Database Functionality  Basic 1 1 10 1 9 1 10 1 11  
Multi-language  Must have 2 2 12 2 11 2 12 2 13  
Use via internet and desktop Must have 3 2 14 3 14 2 14 2 15  
Ease of Use / Learning Curve  Intermediate  2 1 15 2 16 1 15 1 16  
Reliability Must have 3 3 18 2 18 2 17 3 19  
Storage Space Required Basic  1 1 19 1 19 1 18 1 20  
Secure from Viruses  Intermediate  2 2 21 1 20 2 20 2 22  
Free or low cost  Intermediate  2 1 22 2 22 2 22 1 23  
Ability for two or more staff to access and edit simultaneously  Must have 3 3 25 1 23 1 23 3 26  
TOTAL SCORE       25   23   23   26  

 

The winning software for the Online Encyclopedia use case is MS SQL Server.

However Oracle is quite similar to MS SQL Server in performance and functionality.  Then the score is little different.  MS Access is also good in functionality, but its performance cannot match with MS SQL Server and Oracle.  Last, Grubba is online, free, requires less IT know-how, but has less functionality and performance.

 

Financial Use Case

 

 

 

Features 

Requirement 
Rating

(for details please see detailed use case page) 

 

Pt Value

(1-3) 

 


Cebase


Intuit Quickbase

 


Oracle

 


MS SQL Server

 

 

pts

(1-3) 

 

 total

 

 

pts

(1-3) 

 

 total

 

 

pts (1-3) 

 

 total

 

 

pts (1-3) 

 

 total

 

 

 

Response Time 

Must Have

 3 

 2

 2

 2

 2 

 3 

 3 

 3

 3

 

Compatibility 

Must Have 3 2 4 2 4 3 6       3      6  
Access Controls  Must Have 3 2 6 2 6 3 9 3 9  
User Interface  Must Have 3 2 8 2 8 3 12 2 11  
Reporting Functionality  Intermediate 2 2 10 2 10 2 14      2 13  
Database Functionality  Must Have 3 3  13 3  13 3 17      3 16  
Multi-language  Basic 1 1  14 1 14 1 18 1 17  
Use via internet and desktop Must Have 3 3  17 3  17 3 21      3 20  
Ease of Use / Learning Curve  Intermediate 2 2  19 2  19 2 23      2 22  
Reliability Must Have  3 2 21 3 22 3 26      2 24  
Storage Space Required Intermediate 2 2  23 2  24 2 28      2 26  
Secure from Viruses  Must Have  3 2 25 3  27 3 31       2 28  
Free or low cost  Basic 1 1  26 1  28 1 32 1  29  
Ability for two or more staff to access and edit simultaneously  Intermediate 2 2 28 2  30 2 34 2  31  
TOTAL SCORE       28   30   34   31  

 

Back to Group Page 

 

 

 

 

 

 

 

 

 

Comments (1)

Oli Shields said

at 11:35 pm on May 28, 2009

We can fill in this scorecard on the wiki as discussed. Thanks.

You don't have permission to comment on this page.