MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 12/01/00 through 12/31/00
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 283 2,414 2,697
Davis 1,188 93 1,281
Irvine 860 0 860
Los Angeles 189 975 1,164
Riverside 120 201 321
San Diego 174 875 1,049
San Francisco 631 0 631
Santa Barbara 104 520 624
Santa Cruz 79 248 327
LBL 0 418 418
LLL 0 261 261
Los Alamos n/a 0 0
Other - UC 7 123 130
U.S. Forestry 0
Other-Network UC n/a 1,382 1,382
_______ ______ _____
3,635 7,510 11,145
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 177 628 8,831
2-4 a.m. 162 545 15,067
4-6 a.m. 143 440 4,175
6-8 a.m. 300 1,836 22,441
8-10 a.m. 1,151 3,853 36,237
10-12 a.m. 2,105 5,651 53,461
12-2 p.m. 1,897 5,363 64,175
2-4 p.m. 2,202 6,087 59,582
4-6 p.m. 1,617 4,411 49,714
6-8 p.m. 658 1,841 18,637
8-10 p.m. 442 1,218 11,359
10-12 p.m. 291 951 8,620
__________ __________ __________ _________________
Total: 11,145 32,824 352,299
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 758 6,663 7,421
Davis 3,548 289 3,837
Irvine 2,766 0 2,766
Los Angeles 466 2,720 3,186
Riverside 293 469 762
San Diego 410 2,182 2,592
San Francisco 1,709 0 1,709
Santa Barbara 282 1,798 2,080
Santa Cruz 188 793 981
LBL 0 1,225 1,225
LLL 0 2,580 2,580
Los Alamos n/a 0 0
Other - UC 18 322 340
U.S. Forestry 0
Other-Network UC n/a 3,345 3,345
_______ ______ _____
10,438 22,386 32,824
Number of FIND commands by database
CC database 32,246
CCT database 578
Total number of FIND commands 32,824
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 11,099 73,299 84,398
Davis 46,266 1,913 48,179
Irvine 28,676 0 28,676
Los Angeles 2,660 28,506 31,166
Riverside 1,894 5,113 7,007
San Diego 3,544 18,084 21,628
San Francisco 14,474 0 14,474
Santa Barbara 3,249 22,426 25,675
Santa Cruz 3,047 9,292 12,339
LBL 0 16,736 16,736
LLL 0 29,798 29,798
Los Alamos n/a 0 0
Other - UC 27 6,216 6,243
U.S. Forestry 0
Other-Network UC n/a 25,980 25,980
_______ ______ _____
114,936 237,363 352,299
Number of Records Displayed by database:
CC database 330,468
CCT database 21,831
Total number of Records Displayed 352,299
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 95.6%
Percent of CCT sessions 4.4%
Percent of searches done in the CC database 98.2%
Percent of searches done in the CCT database 1.8%
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 3.7
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 3.7
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 781:20
Average number of searches completed per session 3.0
Retrievals per search - median 10.0
Retrievals per search - average 555.7
Retrievals per search - standard deviation 7456.2
Percent of searches completed with 0 results 24.3%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 63.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 30,110 37.5%
DISPLAY (excluding automatic displays) 23,557 29.3%
HELP 706 0.9%
EXPLAIN 795 1.0%
SET/RESET 4,202 5.2%
SHOW 122 0.2%
ADD ON (AND, OR, AND NOT) 2,136 2.7%
LOGON or LOGOFF 13,693 17.1%
COMMENT 0 0.0%
SAVE 1,296 1.6%
USE 31 0.0%
OTHER 3,656 4.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:
PERSONAL AUTHOR 14,749 42.7% 2,080 14.1% 30 204.5 1419.9
TITLE WORD 10,269 29.8% 2,836 27.6% 14 794.5 5261.8
EXACT TITLE 248 0.7% 132 53.2% 2 92.4 533.1
JOURNAL 1,685 4.9% 736 43.7% 341 5327.3 29217.9
EXACT JOURNAL 2,004 5.8% 1,254 62.6% 45 1239.9 4835.0
SUBJECT CAT 141 0.4% 32 22.7% 16 16729.2 76437.4
SUBFILE 64 0.2% 8 12.5% 26 562.5 1599.7
PUBLICATION TYPE 166 0.5% 34 20.5% 8 77.7 289.5
LANGUAGE 22 0.1% 1 4.5% 20 81.8 157.8
DATE 568 1.6% 76 13.4% 15 221.6 910.3
ADDED 2,021 5.9% 1,414 70.0% 24 37.9 40.2
PERIODICAL 855 2.5% 169 19.8% 7 148.3 1147.8
EXACT PE 161 0.5% 25 15.5% 3 18.7 105.1
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,557 4.5% 499 32.0% 18 907.6 4608.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 4,435 14.8% 2,114 47.7% 11 91.7 557.3
Single 25,561 85.2% 5,041 19.7% 30 834.7 9266.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.9%
SHORT 81.4%
LONG 5.7%
FIELDS 1.7%
PERIODICALS 5.5%
COMMENTS 0.0%
Other 1.8%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 243:17
Average number of searches completed per session 1.2
Retrievals per search - median 47.0
Retrievals per search - average 410.2
Retrievals per search - standard deviation 1795.5
Percent of searches completed with 0 results 26.2%
Percent of searches entered that are long 0.2%
Percent of long searches completed
(includes partial results) 0.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 578 20.2%
DISPLAY (excluding automatic displays) 1,015 35.5%
HELP 205 7.2%
EXPLAIN 137 4.8%
SET/RESET 317 11.1%
SHOW 24 0.8%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 455 15.9%
COMMENT 0 0.0%
SAVE 1 0.0%
USE 1 0.0%
OTHER 127 4.4%
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 351 60.2% 113 32.2% 100 363.9 1173.9
EXACT JOURNAL 168 28.8% 32 19.0% 138 220.5 267.9
SUBJECT CAT 9 1.5% 0 0.0% 15,573 11883.8 4374.9
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 6 1.0% 2 33.3% 25 35.3 21.9
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 49 8.4% 6 12.2% 3 305.5 1899.3
By number of indexes:
Multiple 6 1.0% 2 33.3% 25 35.3 21.9
Single 571 99.0% 149 26.1% 95 560.5 2080.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.5%
ISSUES 47.3%
SHORT 18.3%
LONG 22.8%
PERIODICALS 7.0%
COMMENTS 0.0%
Other 1.1%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 8.2%
Ten most frequent errors:
1. NS command - no next screen 33.4%
2. First word of command is invalid 28.7%
3. FIND command with invalid index name 9.9%
4. Index invalid in current database 4.6%
5. DISPLAY command contains invalid word 2.2%
6. PS command - no previous screen 2.1%
7. D ABS command in database w/o abstracts 2.0%
8. Search term missing from search command 1.8%
9. Valid command at an inappropriate time 1.4%
10. DISPLAY command - no FIND results 1.2%
11. All others 12.9%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 13.5%
2. FIND (CC DB) 12.4%
3. CC INDEXES 9.4%
4. LOCATE (ARTICLE DBS) 9.1%
5. COMMANDS 6.2%
6. Unrecognized term 4.8%
7. CC DATABASE 3.4%
8. CCT DATABASE 3.4%
9. DATABASES 2.9%
10. CURRENT DATES 2.3%
11. All others 32.4%
Ten most frequent HELP situations:
1. Help requested from START CC command 14.5%
2. First word of command is invalid 13.8%
3. FIND command with invalid index name 8.8%
4. F/BR with index invalid in current DB 8.7%
5. Help requested from SET DB command 7.0%
6. DISPLAY command - middle of >1 screen 6.6%
7. FIND command with zero results 5.8%
8. DISPLAY command-first of >1 screen 4.5%
9. DISPLAY command-complete in one screen 3.6%
10. FIND command retrieves >1 book 3.5%
11. All others 23.1%
Ten most frequent SHOW requests:
1. HISTORY 51.1%
2. SEARCH 13.1%
3. CC GLOSSARY 4.4%
4. SC LIST (CC DBS) 4.4%
5. GLOSSARY 3.6%
6. SYSTEM NEWS 3.6%
7. CC SETTINGS 3.6%
8. CC NEWS 3.6%
9. UPDATE 2.2%
10. MAIL STATUS 1.5%
11. All others 8.8%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)