MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 02/01/01 through 02/28/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 340 3,274 3,614
Davis 1,648 91 1,739
Irvine 1,116 0 1,116
Los Angeles 172 1,229 1,401
Riverside 181 300 481
San Diego 220 1,095 1,315
San Francisco 819 0 819
Santa Barbara 192 598 790
Santa Cruz 155 411 566
LBL 0 491 491
LLL 0 293 293
Los Alamos n/a 0 0
Other - UC 2 162 164
U.S. Forestry 0
Other-Network UC n/a 2,536 2,536
_______ ______ _____
4,845 10,480 15,325
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 267 853 7,945
2-4 a.m. 220 847 15,305
4-6 a.m. 223 859 6,468
6-8 a.m. 471 2,297 28,344
8-10 a.m. 1,677 5,338 62,122
10-12 a.m. 2,692 7,631 94,155
12-2 p.m. 2,551 6,996 62,473
2-4 p.m. 3,039 8,012 78,472
4-6 p.m. 2,225 6,038 59,353
6-8 p.m. 986 2,848 29,030
8-10 p.m. 612 2,037 19,145
10-12 p.m. 362 1,167 13,895
__________ __________ __________ _________________
Total: 15,325 44,923 476,707
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 759 9,383 10,142
Davis 4,922 277 5,199
Irvine 3,354 0 3,354
Los Angeles 605 3,986 4,591
Riverside 368 936 1,304
San Diego 630 2,828 3,458
San Francisco 2,195 0 2,195
Santa Barbara 413 1,760 2,173
Santa Cruz 268 1,330 1,598
LBL 0 1,327 1,327
LLL 0 3,478 3,478
Los Alamos n/a 0 0
Other - UC 7 458 465
U.S. Forestry 0
Other-Network UC n/a 5,639 5,639
_______ ______ _____
13,521 31,402 44,923
Number of FIND commands by database
CC database 43,922
CCT database 1,001
Total number of FIND commands 44,923
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 7,837 137,030 144,867
Davis 47,967 2,174 50,141
Irvine 20,262 0 20,262
Los Angeles 4,578 39,316 43,894
Riverside 5,397 12,368 17,765
San Diego 5,061 26,272 31,333
San Francisco 22,066 0 22,066
Santa Barbara 4,229 18,461 22,690
Santa Cruz 3,475 14,029 17,504
LBL 0 20,602 20,602
LLL 0 34,171 34,171
Los Alamos n/a 0 0
Other - UC 583 5,672 6,255
U.S. Forestry 0
Other-Network UC n/a 45,157 45,157
_______ ______ _____
121,455 355,252 476,707
Number of Records Displayed by database:
CC database 395,690
CCT database 81,017
Total number of Records Displayed 476,707
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 97.8%
Percent of searches done in the CCT database 2.2%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 1.0
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) 318:53
Average number of searches completed per session 3.0
Retrievals per search - median 9.0
Retrievals per search - average 388.8
Retrievals per search - standard deviation 3121.0
Percent of searches completed with 0 results 24.7%
Percent of searches entered that are long 0.4%
Percent of long searches completed
(includes partial results) 56.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 40,762 37.2%
DISPLAY (excluding automatic displays) 32,743 29.9%
HELP 1,073 1.0%
EXPLAIN 1,075 1.0%
SET/RESET 5,888 5.4%
SHOW 172 0.2%
ADD ON (AND, OR, AND NOT) 3,160 2.9%
LOGON or LOGOFF 18,326 16.7%
COMMENT 1 0.0%
SAVE 1,773 1.6%
USE 35 0.0%
OTHER 4,665 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 19,893 42.5% 3,071 15.4% 29 233.7 1441.1
TITLE WORD 14,056 30.0% 4,187 29.8% 14 648.3 3886.0
EXACT TITLE 556 1.2% 266 47.8% 3 160.0 777.9
JOURNAL 2,037 4.3% 930 45.7% 223 3103.1 8482.6
EXACT JOURNAL 2,147 4.6% 1,263 58.8% 38 1195.0 4572.8
SUBJECT CAT 275 0.6% 45 16.4% 15 98.6 590.6
SUBFILE 78 0.2% 4 5.1% 43 746.5 2748.9
PUBLICATION TYPE 201 0.4% 41 20.4% 11 3513.9 20360.9
LANGUAGE 29 0.1% 5 17.2% 4 150.6 672.8
DATE 688 1.5% 125 18.2% 15 144.1 624.3
ADDED 2,479 5.3% 1,652 66.6% 19 31.2 39.8
PERIODICAL 1,619 3.5% 248 15.3% 4 57.1 503.9
EXACT PE 475 1.0% 41 8.6% 3 10.5 25.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,324 5.0% 670 28.8% 17 673.4 3581.4
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,157 15.2% 2,729 44.3% 8 74.6 559.6
Single 34,451 84.8% 7,064 20.5% 28 595.1 3717.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.3%
SHORT 77.2%
LONG 6.6%
FIELDS 2.2%
PERIODICALS 8.2%
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) 251:38
Average number of searches completed per session 1.5
Retrievals per search - median 69.0
Retrievals per search - average 921.6
Retrievals per search - standard deviation 4449.9
Percent of searches completed with 0 results 23.4%
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 982 22.5%
DISPLAY (excluding automatic displays) 1,481 34.0%
HELP 356 8.2%
EXPLAIN 199 4.6%
SET/RESET 423 9.7%
SHOW 60 1.4%
ADD ON (AND, OR, AND NOT) 19 0.4%
LOGON or LOGOFF 663 15.2%
COMMENT 0 0.0%
SAVE 6 0.1%
USE 2 0.0%
OTHER 165 3.8%
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 597 56.4% 168 28.1% 124 451.7 1310.6
EXACT JOURNAL 212 20.0% 56 26.4% 131 252.2 355.6
SUBJECT CAT 102 9.6% 2 2.0% 1,461 6477.5 12496.0
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 73 6.9% 2 2.7% 383 669.2 723.5
ADDED 3 0.3% 0 0.0% 1 1.3 0.6
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 71 6.7% 6 8.5% 3 13.8 55.9
By number of indexes:
Multiple 76 7.7% 2 2.6% 377 642.1 720.8
Single 906 92.3% 230 25.4% 124 1234.1 5362.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.5%
ISSUES 47.3%
SHORT 17.1%
LONG 22.2%
PERIODICALS 6.5%
COMMENTS 0.0%
Other 1.4%
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 31.9%
2. First word of command is invalid 28.8%
3. FIND command with invalid index name 9.0%
4. Index invalid in current database 4.4%
5. DISPLAY command contains invalid word 2.3%
6. Max. # of ports to a Z39 db are in use 2.1%
7. Search term missing from search command 1.9%
8. DISPLAY command - no FIND results 1.9%
9. PS command - no previous screen 1.8%
10. D ABS command in database w/o abstracts 1.6%
11. All others 14.2%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 15.0%
2. FIND (CC DB) 13.0%
3. CC INDEXES 11.1%
4. LOCATE (ARTICLE DBS) 7.7%
5. COMMANDS 5.8%
6. Unrecognized term 4.4%
7. CC DATABASE 3.6%
8. DATABASES 3.1%
9. SUBJECT CATEGORY 2.8%
10. CCT DATABASE 2.7%
11. All others 30.8%
Ten most frequent HELP situations:
1. First word of command is invalid 14.4%
2. Help requested from START CC command 13.8%
3. F/BR with index invalid in current DB 8.9%
4. FIND command with invalid index name 7.8%
5. Help requested from SET DB command 7.7%
6. DISPLAY command-first of >1 screen 5.2%
7. DISPLAY command - middle of >1 screen 5.1%
8. FIND command with zero results 4.2%
9. FIND command retrieves >1 book 3.3%
10. DISPLAY command-complete in one screen 3.2%
11. All others 26.4%
Ten most frequent SHOW requests:
1. HISTORY 41.6%
2. SYSTEM NEWS 10.6%
3. SC LIST (CC DBS) 7.5%
4. SEARCH 6.6%
5. MAIL STATUS 5.8%
6. CC GLOSSARY 4.4%
7. CC NEWS 3.1%
8. MAIL SETTINGS 2.2%
9. GLOSSARY 1.8%
10. CCT SETTINGS 1.8%
11. All others 14.6%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)