MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 06/01/00 through 06/30/00
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 470 3,374 3,844
Davis 1,532 107 1,639
Irvine 1,389 0 1,389
Los Angeles 534 1,471 2,005
Riverside 261 424 685
San Diego 310 1,164 1,474
San Francisco 1,350 0 1,350
Santa Barbara 204 929 1,133
Santa Cruz 185 371 556
LBL 0 660 660
LLL 0 328 328
Los Alamos n/a 0 0
Other - UC 6 126 132
U.S. Forestry 0
Other-Network UC n/a 2,152 2,152
_______ ______ _____
6,241 11,106 17,347
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 317 1,027 8,745
2-4 a.m. 209 973 7,954
4-6 a.m. 224 744 7,343
6-8 a.m. 516 2,740 28,498
8-10 a.m. 1,797 5,858 50,235
10-12 a.m. 3,250 8,825 82,859
12-2 p.m. 2,925 8,358 75,860
2-4 p.m. 3,561 10,299 92,062
4-6 p.m. 2,521 7,500 65,180
6-8 p.m. 924 2,821 29,900
8-10 p.m. 606 1,924 15,928
10-12 p.m. 497 1,581 13,832
__________ __________ __________ _________________
Total: 17,347 52,650 478,396
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,289 9,721 11,010
Davis 4,606 273 4,879
Irvine 4,161 0 4,161
Los Angeles 1,529 4,747 6,276
Riverside 711 1,200 1,911
San Diego 943 3,186 4,129
San Francisco 3,320 0 3,320
Santa Barbara 544 3,361 3,905
Santa Cruz 454 1,003 1,457
LBL 0 2,247 2,247
LLL 0 3,472 3,472
Los Alamos n/a 0 0
Other - UC 13 286 299
U.S. Forestry 0
Other-Network UC n/a 5,584 5,584
_______ ______ _____
17,570 35,080 52,650
Number of FIND commands by database
CC database 51,796
CCT database 854
Total number of FIND commands 52,650
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 12,320 96,831 109,151
Davis 37,093 1,576 38,669
Irvine 28,423 0 28,423
Los Angeles 11,263 48,108 59,371
Riverside 7,031 10,507 17,538
San Diego 6,714 23,168 29,882
San Francisco 28,076 0 28,076
Santa Barbara 6,995 36,373 43,368
Santa Cruz 2,476 9,943 12,419
LBL 0 23,719 23,719
LLL 0 39,452 39,452
Los Alamos n/a 0 0
Other - UC 51 2,931 2,982
U.S. Forestry 0
Other-Network UC n/a 45,346 45,346
_______ ______ _____
140,442 337,954 478,396
Number of Records Displayed by database:
CC database 447,553
CCT database 30,843
Total number of Records Displayed 478,396
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.8%
Percent of CCT sessions 4.2%
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 1.4
Standard deviation in seconds 6.4
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 6.4
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 699:17
Average number of searches completed per session 3.1
Retrievals per search - median 10.0
Retrievals per search - average 460.9
Retrievals per search - standard deviation 4442.8
Percent of searches completed with 0 results 23.9%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 50.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 47,939 37.8%
DISPLAY (excluding automatic displays) 36,176 28.5%
HELP 1,182 0.9%
EXPLAIN 1,252 1.0%
SET/RESET 6,205 4.9%
SHOW 257 0.2%
ADD ON (AND, OR, AND NOT) 3,857 3.0%
LOGON or LOGOFF 21,685 17.1%
COMMENT 0 0.0%
SAVE 2,322 1.8%
USE 30 0.0%
OTHER 6,024 4.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:
PERSONAL AUTHOR 23,523 43.5% 3,245 13.8% 32 202.8 1256.0
TITLE WORD 16,734 30.9% 4,894 29.2% 14 816.5 5672.9
EXACT TITLE 389 0.7% 220 56.6% 4 137.9 616.3
JOURNAL 2,352 4.3% 1,022 43.4% 355 4071.9 16522.6
EXACT JOURNAL 2,435 4.5% 1,455 59.8% 41 1665.7 6817.3
SUBJECT CAT 177 0.3% 24 13.6% 16 92.4 334.2
SUBFILE 144 0.3% 12 8.3% 27 308.7 1111.6
PUBLICATION TYPE 213 0.4% 43 20.2% 12 1300.7 15838.0
LANGUAGE 70 0.1% 5 7.1% 33 193.5 491.9
DATE 659 1.2% 93 14.1% 10 107.3 730.1
ADDED 2,676 4.9% 1,759 65.7% 21 34.9 41.7
PERIODICAL 1,487 2.7% 299 20.1% 5 135.2 990.0
EXACT PE 339 0.6% 43 12.7% 3 18.2 131.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 2,910 5.4% 918 31.5% 23 1099.8 7800.3
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,190 13.0% 2,798 45.2% 9 65.7 451.9
Single 41,580 87.0% 8,383 20.2% 31 697.1 5502.9
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.4%
SHORT 81.0%
LONG 4.7%
FIELDS 1.8%
PERIODICALS 6.0%
COMMENTS 0.0%
Other 2.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) 82:51
Average number of searches completed per session 1.2
Retrievals per search - median 42.0
Retrievals per search - average 253.6
Retrievals per search - standard deviation 1085.7
Percent of searches completed with 0 results 32.0%
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 849 21.4%
DISPLAY (excluding automatic displays) 1,284 32.4%
HELP 334 8.4%
EXPLAIN 156 3.9%
SET/RESET 500 12.6%
SHOW 54 1.4%
ADD ON (AND, OR, AND NOT) 5 0.1%
LOGON or LOGOFF 624 15.7%
COMMENT 0 0.0%
SAVE 9 0.2%
USE 5 0.1%
OTHER 147 3.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 559 65.3% 196 35.1% 115 430.0 1522.4
EXACT JOURNAL 215 25.1% 67 31.2% 129 252.8 509.5
SUBJECT CAT 4 0.5% 1 25.0% 4,697 5450.3 1748.3
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 6 0.7% 3 50.0% 6 16.3 22.4
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 72 8.4% 9 12.5% 10 105.4 417.8
By number of indexes:
Multiple 7 0.8% 4 57.1% 6 16.3 22.4
Single 842 99.2% 268 31.8% 104 377.1 1307.0
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.3%
ISSUES 52.2%
SHORT 14.5%
LONG 21.4%
PERIODICALS 7.7%
COMMENTS 0.0%
Other 0.8%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.3%
Ten most frequent errors:
1. NS command - no next screen 34.2%
2. First word of command is invalid 27.6%
3. FIND command with invalid index name 9.9%
4. Index invalid in current database 4.6%
5. DISPLAY command - no FIND results 2.1%
6. Search term missing from search command 2.1%
7. DISPLAY command contains invalid word 1.7%
8. PS command - no previous screen 1.6%
9. D ABS command in database w/o abstracts 1.6%
10. Valid command at an inappropriate time 1.4%
11. All others 13.2%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 14.4%
2. FIND (CC DB) 12.2%
3. CC INDEXES 11.7%
4. LOCATE (ARTICLE DBS) 7.4%
5. COMMANDS 7.0%
6. Unrecognized term 4.0%
7. CCT INDEXES 3.3%
8. CC DATABASE 3.1%
9. CCT DATABASE 2.6%
10. DATABASES 2.5%
11. All others 31.9%
Ten most frequent HELP situations:
1. Help requested from START CC command 15.1%
2. First word of command is invalid 12.9%
3. F/BR with index invalid in current DB 8.9%
4. Help requested from SET DB command 7.5%
5. FIND command with invalid index name 7.2%
6. DISPLAY command - middle of >1 screen 5.0%
7. FIND command with zero results 4.5%
8. DISPLAY command-first of >1 screen 4.4%
9. FIND command retrieves >1 book 4.0%
10. DISPLAY command-complete in one screen 2.9%
11. All others 27.6%
Ten most frequent SHOW requests:
1. HISTORY 53.7%
2. MAIL STATUS 10.7%
3. SEARCH 9.7%
4. SC LIST (CC DBS) 7.3%
5. SYSTEM NEWS 6.0%
6. CC NEWS 2.3%
7. CC GLOSSARY 2.0%
8. SC ARTS 1.3%
9. CCT SETTINGS 1.0%
10. GLOSSARY 0.7%
11. All others 5.3%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)