MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 03/01/01 through 03/31/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 398 3,539 3,937
Davis 1,591 132 1,723
Irvine 1,236 0 1,236
Los Angeles 199 1,212 1,411
Riverside 179 331 510
San Diego 212 1,081 1,293
San Francisco 868 0 868
Santa Barbara 85 570 655
Santa Cruz 131 412 543
LBL 0 524 524
LLL 0 248 248
Los Alamos n/a 0 0
Other - UC 11 208 219
U.S. Forestry 0
Other-Network UC n/a 2,471 2,471
_______ ______ _____
4,910 10,728 15,638
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 260 853 8,160
2-4 a.m. 214 825 7,186
4-6 a.m. 219 856 5,396
6-8 a.m. 447 2,112 20,662
8-10 a.m. 1,788 5,604 49,888
10-12 a.m. 2,831 7,734 85,778
12-2 p.m. 2,629 6,999 70,617
2-4 p.m. 3,040 7,940 71,785
4-6 p.m. 2,172 6,209 58,552
6-8 p.m. 1,024 3,183 28,399
8-10 p.m. 605 2,006 24,911
10-12 p.m. 409 1,359 13,489
__________ __________ __________ _________________
Total: 15,638 45,680 444,823
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 927 9,522 10,449
Davis 4,664 419 5,083
Irvine 3,778 0 3,778
Los Angeles 535 3,410 3,945
Riverside 458 1,055 1,513
San Diego 591 3,639 4,230
San Francisco 2,339 0 2,339
Santa Barbara 253 1,876 2,129
Santa Cruz 259 1,446 1,705
LBL 0 1,589 1,589
LLL 0 2,641 2,641
Los Alamos n/a 0 0
Other - UC 13 566 579
U.S. Forestry 0
Other-Network UC n/a 5,700 5,700
_______ ______ _____
13,817 31,863 45,680
Number of FIND commands by database
CC database 44,808
CCT database 872
Total number of FIND commands 45,680
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 10,604 94,694 105,298
Davis 41,239 3,397 44,636
Irvine 25,151 0 25,151
Los Angeles 3,806 36,804 40,610
Riverside 6,209 10,681 16,890
San Diego 4,335 29,975 34,310
San Francisco 39,436 0 39,436
Santa Barbara 2,018 22,119 24,137
Santa Cruz 2,522 13,973 16,495
LBL 0 17,528 17,528
LLL 0 26,400 26,400
Los Alamos n/a 0 0
Other - UC 88 6,176 6,264
U.S. Forestry 0
Other-Network UC n/a 47,668 47,668
_______ ______ _____
135,408 309,415 444,823
Number of Records Displayed by database:
CC database 399,635
CCT database 45,188
Total number of Records Displayed 444,823
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.7%
Percent of CCT sessions 4.3%
Percent of searches done in the CC database 98.1%
Percent of searches done in the CCT database 1.9%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.9
Standard deviation in seconds 4.3
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 4.3
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 854:43
Average number of searches completed per session 3.0
Retrievals per search - median 9.0
Retrievals per search - average 500.3
Retrievals per search - standard deviation 6104.1
Percent of searches completed with 0 results 24.1%
Percent of searches entered that are long 0.3%
Percent of long searches completed
(includes partial results) 64.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 41,588 38.0%
DISPLAY (excluding automatic displays) 31,675 28.9%
HELP 937 0.9%
EXPLAIN 948 0.9%
SET/RESET 6,135 5.6%
SHOW 181 0.2%
ADD ON (AND, OR, AND NOT) 3,220 2.9%
LOGON or LOGOFF 18,627 17.0%
COMMENT 0 0.0%
SAVE 1,458 1.3%
USE 46 0.0%
OTHER 4,666 4.3%
FINDs completed: RETRIEVALS PER NON-
TOTAL ZERO RESULTS ZERO RESULT SEARCHES
_____________ ______________ ______________________
% of % of
all all for Std.
No. FINDs No. Index Median Avg. Dev.
______ ______ ______ _______ ______ _______ _______
By index:
PERSONAL AUTHOR 20,014 42.3% 3,013 15.1% 31 217.4 1474.3
TITLE WORD 14,887 31.5% 4,368 29.3% 14 866.8 7033.1
EXACT TITLE 559 1.2% 268 47.9% 3 82.6 464.9
JOURNAL 1,960 4.1% 853 43.5% 162 4569.2 26989.8
EXACT JOURNAL 1,995 4.2% 1,170 58.6% 49 2146.2 7565.1
SUBJECT CAT 199 0.4% 18 9.0% 16 91.7 359.2
SUBFILE 137 0.3% 9 6.6% 44 539.7 1658.1
PUBLICATION TYPE 224 0.5% 48 21.4% 16 5003.4 30378.8
LANGUAGE 11 0.0% 1 9.1% 56 872.7 2076.2
DATE 670 1.4% 107 16.0% 9 95.7 396.5
ADDED 2,246 4.8% 1,499 66.7% 16 29.2 35.9
PERIODICAL 1,551 3.3% 254 16.4% 4 59.4 543.5
EXACT PE 426 0.9% 41 9.6% 3 18.6 92.9
RPE 0 0.0% 0 0.0% 0 0.0 0.0
XRP 0 0.0% 0 0.0% 0 0.0 0.0
COMMENTS 0 0.0% 0 0.0% 0 0.0 0.0
Other indexes 2,396 5.1% 707 29.5% 20 844.6 5745.0
RETRIEVALS PER NON-
TOTAL ZERO RESULTS ZERO RESULT SEARCHES
_____________ ______________ ______________________
% of % of
all all for Std.
No. FINDs No. Index Median Avg. Dev.
______ ______ ______ _______ ______ _______ _______
By number of indexes:
Multiple 5,718 13.8% 2,533 44.3% 8 68.0 433.4
Single 35,742 86.2% 7,261 20.3% 29 765.2 7615.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.4%
SHORT 79.6%
LONG 4.7%
FIELDS 2.0%
PERIODICALS 8.0%
COMMENTS 0.0%
Other 1.3%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 261:27
Average number of searches completed per session 1.3
Retrievals per search - median 36.0
Retrievals per search - average 391.8
Retrievals per search - standard deviation 2016.0
Percent of searches completed with 0 results 32.7%
Percent of searches entered that are long 0.0%
Percent of long searches completed
(includes partial results) 0.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 869 21.1%
DISPLAY (excluding automatic displays) 1,358 32.9%
HELP 304 7.4%
EXPLAIN 143 3.5%
SET/RESET 458 11.1%
SHOW 53 1.3%
ADD ON (AND, OR, AND NOT) 3 0.1%
LOGON or LOGOFF 600 14.5%
COMMENT 0 0.0%
SAVE 186 4.5%
USE 2 0.0%
OTHER 150 3.6%
FINDs completed: RETRIEVALS PER NON-
TOTAL ZERO RESULTS ZERO RESULT SEARCHES
_____________ ______________ ______________________
% of % of
all all for Std.
No. FINDs No. Index Median Avg. Dev.
______ ______ ______ _______ ______ _______ _______
By index:
JOURNAL 602 69.0% 225 37.4% 116 603.0 2752.2
EXACT JOURNAL 176 20.2% 49 27.8% 139 255.7 398.4
SUBJECT CAT 13 1.5% 1 7.7% 5,038 6713.3 3291.9
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 3 0.3% 2 66.7% 115 115.0 0.0
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 0 0.0% 0 0.0% 0 0.0 0.0
EXACT PE 0 0.0% 0 0.0% 0 0.0 0.0
RPE 0 0.0% 0 0.0% 0 0.0 0.0
XRP 0 0.0% 0 0.0% 0 0.0 0.0
COMMENTS 0 0.0% 0 0.0% 0 0.0 0.0
Other indexes 79 9.0% 9 11.4% 4 16.7 49.7
By number of indexes:
Multiple 4 0.5% 3 75.0% 115 115.0 0.0
Single 865 99.5% 280 32.4% 107 583.6 2439.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.0%
ISSUES 53.8%
SHORT 11.6%
LONG 22.1%
PERIODICALS 7.8%
COMMENTS 0.0%
Other 0.6%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.7%
Ten most frequent errors:
1. NS command - no next screen 31.4%
2. First word of command is invalid 29.1%
3. FIND command with invalid index name 9.7%
4. Index invalid in current database 4.1%
5. Max. # of ports to a Z39 db are in use 2.3%
6. DISPLAY command - no FIND results 2.3%
7. Search term missing from search command 2.2%
8. PS command - no previous screen 2.0%
9. DISPLAY command contains invalid word 1.8%
10. D ABS command in database w/o abstracts 1.5%
11. All others 13.7%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.6%
2. FIND (CC DB) 13.1%
3. CC INDEXES 9.4%
4. LOCATE (ARTICLE DBS) 8.8%
5. COMMANDS 6.0%
6. Unrecognized term 5.8%
7. CC DATABASE 3.3%
8. DATABASES 2.5%
9. DISPLAY 2.5%
10. CCT DATABASE 2.4%
11. All others 28.6%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.9%
2. First word of command is invalid 13.5%
3. FIND command with invalid index name 8.8%
4. F/BR with index invalid in current DB 8.1%
5. Help requested from SET DB command 7.4%
6. DISPLAY command-first of >1 screen 4.9%
7. FIND command with zero results 4.6%
8. DISPLAY command - middle of >1 screen 3.6%
9. FIND command retrieves >1 book 3.4%
10. DISPLAY command-complete in one screen 3.4%
11. All others 26.4%
Ten most frequent SHOW requests:
1. HISTORY 46.5%
2. SYSTEM NEWS 11.7%
3. SEARCH 8.0%
4. CC NEWS 5.6%
5. SC LIST (CC DBS) 5.2%
6. CC GLOSSARY 4.2%
7. LIBRARY NEWS 3.3%
8. MAIL STATUS 2.8%
9. UPDATE 2.8%
10. CCT SETTINGS 2.3%
11. All others 7.5%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)