MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 11/01/01 through 11/30/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 320 2,224 2,544
Davis 1,354 83 1,437
Irvine 659 0 659
Los Angeles 1 689 690
Riverside 79 201 280
San Diego 122 743 865
San Francisco 575 0 575
Santa Barbara 38 398 436
Santa Cruz 32 191 223
LBL 0 401 401
LLL 0 161 161
Los Alamos n/a 0 0
Other - UC 3 213 216
U.S. Forestry 0
Other-Network UC n/a 2,004 2,004
_______ ______ _____
3,183 7,308 10,491
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 153 525 4,552
2-4 a.m. 109 384 40,769
4-6 a.m. 132 391 3,105
6-8 a.m. 318 1,097 9,723
8-10 a.m. 1,341 3,398 24,856
10-12 a.m. 2,132 5,684 54,023
12-2 p.m. 1,743 4,620 43,303
2-4 p.m. 1,946 5,275 64,027
4-6 p.m. 1,313 3,485 37,368
6-8 p.m. 619 1,798 21,289
8-10 p.m. 384 1,093 9,427
10-12 p.m. 301 972 9,475
__________ __________ __________ _________________
Total: 10,491 28,722 321,917
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 937 6,378 7,315
Davis 3,793 191 3,984
Irvine 1,754 0 1,754
Los Angeles 1 1,692 1,693
Riverside 189 605 794
San Diego 373 2,185 2,558
San Francisco 1,510 0 1,510
Santa Barbara 57 1,204 1,261
Santa Cruz 37 570 607
LBL 0 896 896
LLL 0 513 513
Los Alamos n/a 0 0
Other - UC 7 489 496
U.S. Forestry 0
Other-Network UC n/a 5,341 5,341
_______ ______ _____
8,658 20,064 28,722
Number of FIND commands by database
CC database 28,058
CCT database 664
Total number of FIND commands 28,722
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 10,243 69,779 80,022
Davis 51,105 1,157 52,262
Irvine 48,957 0 48,957
Los Angeles 7 14,649 14,656
Riverside 1,460 5,026 6,486
San Diego 1,751 20,467 22,218
San Francisco 14,089 0 14,089
Santa Barbara 193 14,318 14,511
Santa Cruz 654 5,457 6,111
LBL 0 13,317 13,317
LLL 0 3,625 3,625
Los Alamos n/a 0 0
Other - UC 11 7,724 7,735
U.S. Forestry 0
Other-Network UC n/a 37,928 37,928
_______ ______ _____
128,470 193,447 321,917
Number of Records Displayed by database:
CC database 296,428
CCT database 25,489
Total number of Records Displayed 321,917
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.0%
Percent of CCT sessions 4.0%
Percent of searches done in the CC database 97.7%
Percent of searches done in the CCT database 2.3%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.2
Standard deviation in seconds 5.2
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 5.2
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 710:27
Average number of searches completed per session 2.8
Retrievals per search - median 8.0
Retrievals per search - average 493.4
Retrievals per search - standard deviation 4483.4
Percent of searches completed with 0 results 23.0%
Percent of searches entered that are long 0.6%
Percent of long searches completed
(includes partial results) 77.6%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 25,555 36.6%
DISPLAY (excluding automatic displays) 20,598 29.5%
HELP 551 0.8%
EXPLAIN 625 0.9%
SET/RESET 4,507 6.4%
SHOW 142 0.2%
ADD ON (AND, OR, AND NOT) 2,503 3.6%
LOGON or LOGOFF 11,681 16.7%
COMMENT 0 0.0%
SAVE 779 1.1%
USE 9 0.0%
OTHER 2,950 4.2%
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 12,207 43.5% 1,896 15.5% 30 211.9 1348.1
TITLE WORD 8,798 31.4% 2,745 31.2% 12 815.7 5535.4
EXACT TITLE 512 1.8% 214 41.8% 4 95.4 500.8
JOURNAL 1,362 4.9% 510 37.4% 442 4356.7 14180.3
EXACT JOURNAL 580 2.1% 228 39.3% 911 3948.3 8711.2
SUBJECT CAT 102 0.4% 16 15.7% 14 23.9 36.2
SUBFILE 90 0.3% 9 10.0% 38 156.0 383.5
PUBLICATION TYPE 63 0.2% 13 20.6% 31 10311.4 49039.8
LANGUAGE 19 0.1% 4 21.1% 42 1112.5 2436.8
DATE 625 2.2% 99 15.8% 11 163.9 1019.5
ADDED 57 0.2% 12 21.1% 6 10.8 14.9
PERIODICAL 1,918 6.8% 234 12.2% 4 57.0 879.9
EXACT PE 449 1.6% 52 11.6% 3 43.3 191.5
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 1,256 4.5% 406 32.3% 19 900.8 4083.6
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 2,517 9.9% 739 29.4% 6 89.4 641.7
Single 22,910 90.1% 4,936 21.5% 26 747.7 5564.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.4%
SHORT 73.3%
LONG 5.4%
FIELDS 1.1%
PERIODICALS 13.4%
COMMENTS 0.0%
Other 1.4%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 104:15
Average number of searches completed per session 1.6
Retrievals per search - median 50.0
Retrievals per search - average 258.2
Retrievals per search - standard deviation 1148.0
Percent of searches completed with 0 results 28.8%
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 655 24.0%
DISPLAY (excluding automatic displays) 1,075 39.4%
HELP 164 6.0%
EXPLAIN 64 2.3%
SET/RESET 304 11.1%
SHOW 32 1.2%
ADD ON (AND, OR, AND NOT) 9 0.3%
LOGON or LOGOFF 351 12.9%
COMMENT 0 0.0%
SAVE 2 0.1%
USE 0 0.0%
OTHER 75 2.7%
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 479 72.9% 165 34.4% 121 447.5 1624.7
EXACT JOURNAL 115 17.5% 22 19.1% 145 298.2 460.7
SUBJECT CAT 0 0.0% 0 0.0% 0 0.0 0.0
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 2 0.3% 0 0.0% 35 35.0 24.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 61 9.3% 4 6.6% 4 13.5 25.9
By number of indexes:
Multiple 2 0.3% 0 0.0% 35 35.0 24.0
Single 653 99.7% 191 29.2% 98 365.7 1362.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 8.9%
ISSUES 46.0%
SHORT 17.1%
LONG 19.3%
PERIODICALS 7.7%
COMMENTS 0.0%
Other 0.9%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.9%
Ten most frequent errors:
1. NS command - no next screen 30.2%
2. First word of command is invalid 28.8%
3. FIND command with invalid index name 10.2%
4. Index invalid in current database 4.7%
5. DISPLAY command contains invalid word 2.8%
6. Search term missing from search command 2.1%
7. Max. # of ports to a Z39 db are in use 2.1%
8. PS command - no previous screen 2.0%
9. Valid command at an inappropriate time 1.7%
10. D ABS command in database w/o abstracts 1.6%
11. All others 13.9%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 20.2%
2. LOCATE (ARTICLE DBS) 12.5%
3. FIND (CC DB) 11.5%
4. CC INDEXES 7.8%
5. Unrecognized term 4.1%
6. DATABASES 3.6%
7. CC DATABASE 3.3%
8. COMMANDS 3.0%
9. DISPLAY 2.3%
10. ADD-ON SEARCH 2.2%
11. All others 29.5%
Ten most frequent HELP situations:
1. First word of command is invalid 14.7%
2. Help requested from START CC command 14.7%
3. F/BR with index invalid in current DB 7.8%
4. FIND command with invalid index name 7.5%
5. Help requested from SET DB command 7.5%
6. DISPLAY command - middle of >1 screen 5.3%
7. DISPLAY command-first of >1 screen 4.8%
8. FIND command with zero results 4.5%
9. FIND command retrieves >1 book 4.5%
10. DISPLAY command-complete in one screen 3.6%
11. All others 25.1%
Ten most frequent SHOW requests:
1. HISTORY 57.2%
2. SYSTEM NEWS 11.6%
3. SEARCH 5.2%
4. TIME 4.0%
5. LIBRARY NEWS 3.5%
6. CC NEWS 3.5%
7. MAIL STATUS 3.5%
8. DATABASES 2.3%
9. CC SETTINGS 1.7%
10. CC GLOSSARY 1.7%
11. All others 5.8%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)