MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 07/01/01 through 07/31/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 240 2,536 2,776
Davis 1,162 96 1,258
Irvine 852 0 852
Los Angeles 10 962 972
Riverside 130 266 396
San Diego 140 874 1,014
San Francisco 672 0 672
Santa Barbara 14 426 440
Santa Cruz 68 341 409
LBL 0 376 376
LLL 0 223 223
Los Alamos n/a 0 0
Other - UC 7 152 159
U.S. Forestry 0
Other-Network UC n/a 2,421 2,421
_______ ______ _____
3,295 8,673 11,968
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 211 1,392 10,033
2-4 a.m. 154 597 16,394
4-6 a.m. 156 524 4,181
6-8 a.m. 463 2,790 30,651
8-10 a.m. 1,306 4,741 80,749
10-12 a.m. 2,367 6,585 73,380
12-2 p.m. 1,994 5,615 46,551
2-4 p.m. 2,311 6,369 58,118
4-6 p.m. 1,572 4,274 50,858
6-8 p.m. 648 1,998 13,997
8-10 p.m. 405 1,397 12,946
10-12 p.m. 381 1,517 9,699
__________ __________ __________ _________________
Total: 11,968 37,799 407,557
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 545 7,019 7,564
Davis 4,103 229 4,332
Irvine 2,896 0 2,896
Los Angeles 35 2,515 2,550
Riverside 285 717 1,002
San Diego 504 2,186 2,690
San Francisco 1,816 0 1,816
Santa Barbara 48 1,586 1,634
Santa Cruz 131 918 1,049
LBL 0 1,037 1,037
LLL 0 3,633 3,633
Los Alamos n/a 0 0
Other - UC 16 502 518
U.S. Forestry 0
Other-Network UC n/a 7,078 7,078
_______ ______ _____
10,379 27,420 37,799
Number of FIND commands by database
CC database 37,177
CCT database 622
Total number of FIND commands 37,799
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 4,304 78,334 82,638
Davis 89,459 1,324 90,783
Irvine 18,155 0 18,155
Los Angeles 441 23,858 24,299
Riverside 2,022 9,354 11,376
San Diego 2,646 15,771 18,417
San Francisco 27,471 0 27,471
Santa Barbara 236 18,585 18,821
Santa Cruz 1,738 9,518 11,256
LBL 0 8,764 8,764
LLL 0 43,336 43,336
Los Alamos n/a 0 0
Other - UC 458 4,746 5,204
U.S. Forestry 0
Other-Network UC n/a 47,037 47,037
_______ ______ _____
146,930 260,627 407,557
Number of Records Displayed by database:
CC database 384,809
CCT database 22,748
Total number of Records Displayed 407,557
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.3%
Percent of CCT sessions 3.7%
Percent of searches done in the CC database 98.4%
Percent of searches done in the CCT database 1.6%
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.5
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.5
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 1159
Average number of searches completed per session 3.2
Retrievals per search - median 8.0
Retrievals per search - average 514.6
Retrievals per search - standard deviation 4930.8
Percent of searches completed with 0 results 26.8%
Percent of searches entered that are long 0.5%
Percent of long searches completed
(includes partial results) 65.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 33,613 38.5%
DISPLAY (excluding automatic displays) 25,106 28.7%
HELP 461 0.5%
EXPLAIN 595 0.7%
SET/RESET 5,092 5.8%
SHOW 87 0.1%
ADD ON (AND, OR, AND NOT) 3,564 4.1%
LOGON or LOGOFF 13,839 15.8%
COMMENT 0 0.0%
SAVE 1,358 1.6%
USE 38 0.0%
OTHER 3,645 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 15,833 39.9% 2,612 16.5% 30 268.3 1789.9
TITLE WORD 10,427 26.3% 3,334 32.0% 15 1137.6 7527.0
EXACT TITLE 541 1.4% 251 46.4% 3 160.9 714.2
JOURNAL 1,901 4.8% 817 43.0% 333 3501.6 17593.1
EXACT JOURNAL 2,613 6.6% 1,550 59.3% 50 1618.8 6110.8
SUBJECT CAT 202 0.5% 26 12.9% 9 48.9 115.1
SUBFILE 81 0.2% 3 3.7% 23 934.4 4619.8
PUBLICATION TYPE 181 0.5% 35 19.3% 23 2120.5 10229.5
LANGUAGE 55 0.1% 3 5.5% 9 219.7 701.8
DATE 734 1.9% 108 14.7% 10 143.4 641.5
ADDED 3,271 8.2% 2,184 66.8% 22 38.1 58.2
PERIODICAL 2,010 5.1% 387 19.3% 4 77.5 951.3
EXACT PE 384 1.0% 37 9.6% 4 20.4 96.5
RPE 1 0.0% 0 0.0% 2 2.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,439 3.6% 454 31.5% 18 1158.1 6278.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 6,017 18.0% 2,974 49.4% 12 98.1 921.1
Single 27,486 82.0% 5,816 21.2% 29 848.2 6387.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.1%
SHORT 76.1%
LONG 5.7%
FIELDS 1.6%
PERIODICALS 10.2%
COMMENTS 0.0%
Other 1.2%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 252:56
Average number of searches completed per session 1.4
Retrievals per search - median 64.5
Retrievals per search - average 268.1
Retrievals per search - standard deviation 1270.4
Percent of searches completed with 0 results 27.5%
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 622 24.0%
DISPLAY (excluding automatic displays) 1,009 38.9%
HELP 107 4.1%
EXPLAIN 79 3.0%
SET/RESET 295 11.4%
SHOW 24 0.9%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 377 14.5%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 82 3.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:
JOURNAL 384 61.7% 118 30.7% 118 390.5 1797.1
EXACT JOURNAL 208 33.4% 49 23.6% 160 327.3 434.1
SUBJECT CAT 1 0.2% 0 0.0% 10,185 10185.0 0.0
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 0 0.0% 0 0.0% 0 0.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 29 4.7% 4 13.8% 12 25.1 37.2
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 622 100% 171 27.5% 131 369.7 1479.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 7.3%
ISSUES 48.0%
SHORT 25.4%
LONG 13.5%
PERIODICALS 4.9%
COMMENTS 0.0%
Other 0.8%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.3%
Ten most frequent errors:
1. NS command - no next screen 32.6%
2. First word of command is invalid 27.3%
3. FIND command with invalid index name 9.2%
4. Index invalid in current database 3.5%
5. Max. # of ports to a Z39 db are in use 3.4%
6. DISPLAY command contains invalid word 2.5%
7. DISPLAY command - no FIND results 2.4%
8. D ABS command in database w/o abstracts 1.8%
9. Search term missing from search command 1.7%
10. PS command - no previous screen 1.6%
11. All others 13.9%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 16.5%
2. FIND (CC DB) 12.0%
3. CC INDEXES 9.3%
4. COMMANDS 7.0%
5. LOCATE (ARTICLE DBS) 5.9%
6. CC DATABASE 4.9%
7. DATABASES 4.3%
8. MAIL 3.4%
9. Unrecognized term 3.4%
10. FIND (CCT DB) 2.5%
11. All others 30.7%
Ten most frequent HELP situations:
1. Help requested from START CC command 17.7%
2. First word of command is invalid 12.2%
3. F/BR with index invalid in current DB 7.8%
4. Help requested from SET DB command 7.6%
5. FIND command with invalid index name 6.6%
6. DISPLAY command - middle of >1 screen 6.2%
7. FIND command with zero results 4.4%
8. DISPLAY command-first of >1 screen 4.4%
9. Help requested from FIND PA command 3.5%
10. FIND command retrieves >1 book 2.7%
11. All others 26.7%
Ten most frequent SHOW requests:
1. HISTORY 47.0%
2. SYSTEM NEWS 10.0%
3. SEARCH 9.0%
4. CC GLOSSARY 8.0%
5. CC NEWS 4.0%
6. SC LIST (CC DBS) 3.0%
7. SYSTEM1 NEWS 2.0%
8. LIBRARY NEWS 2.0%
9. CC SETTINGS 2.0%
10. CCT SETTINGS 2.0%
11. All others 11.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)