MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 12/01/01 through 12/31/01
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 146 1,639 1,785
Davis 959 69 1,028
Irvine 526 0 526
Los Angeles 6 529 535
Riverside 64 171 235
San Diego 122 600 722
San Francisco 494 0 494
Santa Barbara 8 300 308
Santa Cruz 21 152 173
LBL 0 349 349
LLL 0 121 121
Los Alamos n/a 0 0
Other - UC 2 156 158
U.S. Forestry 0
Other-Network UC n/a 1,652 1,652
_______ ______ _____
2,348 5,738 8,086
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 119 387 2,846
2-4 a.m. 96 259 31,126
4-6 a.m. 99 314 2,261
6-8 a.m. 280 680 5,149
8-10 a.m. 976 2,318 16,822
10-12 a.m. 1,604 3,952 31,173
12-2 p.m. 1,343 3,642 33,490
2-4 p.m. 1,485 3,736 32,810
4-6 p.m. 1,002 2,724 28,905
6-8 p.m. 452 1,320 13,006
8-10 p.m. 356 869 6,296
10-12 p.m. 274 776 6,763
__________ __________ __________ _________________
Total: 8,086 20,977 210,647
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 388 4,306 4,694
Davis 2,631 163 2,794
Irvine 1,628 0 1,628
Los Angeles 20 1,419 1,439
Riverside 133 531 664
San Diego 401 1,581 1,982
San Francisco 1,216 0 1,216
Santa Barbara 14 762 776
Santa Cruz 41 397 438
LBL 0 655 655
LLL 0 386 386
Los Alamos n/a 0 0
Other - UC 7 386 393
U.S. Forestry 0
Other-Network UC n/a 3,912 3,912
_______ ______ _____
6,479 14,498 20,977
Number of FIND commands by database
CC database 20,640
CCT database 337
Total number of FIND commands 20,977
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 3,431 42,087 45,518
Davis 21,956 868 22,824
Irvine 40,175 0 40,175
Los Angeles 51 13,831 13,882
Riverside 2,751 4,611 7,362
San Diego 2,627 14,698 17,325
San Francisco 12,429 0 12,429
Santa Barbara 115 9,628 9,743
Santa Cruz 596 4,928 5,524
LBL 0 8,693 8,693
LLL 0 3,436 3,436
Los Alamos n/a 0 0
Other - UC 59 3,567 3,626
U.S. Forestry 0
Other-Network UC n/a 20,110 20,110
_______ ______ _____
84,190 126,457 210,647
Number of Records Displayed by database:
CC database 197,478
CCT database 13,169
Total number of Records Displayed 210,647
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 97.1%
Percent of CCT sessions 2.9%
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.2
Standard deviation in seconds 4.4
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 4.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) 1189
Average number of searches completed per session 2.6
Retrievals per search - median 9.0
Retrievals per search - average 588.8
Retrievals per search - standard deviation 7127.2
Percent of searches completed with 0 results 22.2%
Percent of searches entered that are long 0.6%
Percent of long searches completed
(includes partial results) 72.2%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 18,559 35.3%
DISPLAY (excluding automatic displays) 14,945 28.4%
HELP 352 0.7%
EXPLAIN 376 0.7%
SET/RESET 3,461 6.6%
SHOW 91 0.2%
ADD ON (AND, OR, AND NOT) 2,081 4.0%
LOGON or LOGOFF 9,321 17.7%
COMMENT 0 0.0%
SAVE 932 1.8%
USE 13 0.0%
OTHER 2,421 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 9,654 47.1% 1,508 15.6% 29 228.8 1653.5
TITLE WORD 6,481 31.6% 1,928 29.7% 13 963.9 8317.5
EXACT TITLE 286 1.4% 110 38.5% 2 80.7 405.8
JOURNAL 955 4.7% 358 37.5% 320 5942.7 25929.7
EXACT JOURNAL 329 1.6% 130 39.5% 604 3498.1 9200.4
SUBJECT CAT 73 0.4% 5 6.8% 20 5919.5 48432.8
SUBFILE 39 0.2% 3 7.7% 74 158.9 271.6
PUBLICATION TYPE 65 0.3% 8 12.3% 7 4562.2 33364.5
LANGUAGE 21 0.1% 1 4.8% 18 1685.4 6338.7
DATE 468 2.3% 67 14.3% 12 149.9 615.5
ADDED 45 0.2% 7 15.6% 6 12.6 17.8
PERIODICAL 990 4.8% 120 12.1% 4 38.7 258.2
EXACT PE 279 1.4% 33 11.8% 3 36.3 165.4
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 814 4.0% 245 30.1% 18 1366.2 8637.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 1,950 10.6% 548 28.1% 5 157.3 2394.8
Single 16,514 89.4% 3,405 20.6% 28 888.4 8838.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.9%
SHORT 77.0%
LONG 4.6%
FIELDS 2.0%
PERIODICALS 10.1%
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) 85:07
Average number of searches completed per session 1.4
Retrievals per search - median 69.0
Retrievals per search - average 259.3
Retrievals per search - standard deviation 990.3
Percent of searches completed with 0 results 24.3%
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 336 23.5%
DISPLAY (excluding automatic displays) 572 40.1%
HELP 46 3.2%
EXPLAIN 27 1.9%
SET/RESET 155 10.9%
SHOW 20 1.4%
ADD ON (AND, OR, AND NOT) 1 0.1%
LOGON or LOGOFF 206 14.4%
COMMENT 0 0.0%
SAVE 5 0.4%
USE 2 0.1%
OTHER 58 4.1%
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 211 61.7% 54 25.6% 134 309.7 791.6
EXACT JOURNAL 88 25.7% 22 25.0% 124 290.4 507.8
SUBJECT CAT 5 1.5% 0 0.0% 350 3710.4 6079.7
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 3 0.9% 1 33.3% 1 1.0 0.0
ADDED 3 0.9% 0 0.0% 183 207.3 132.2
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 32 9.4% 6 18.8% 5 37.1 116.1
By number of indexes:
Multiple 6 1.8% 1 16.7% 89 124.8 146.7
Single 330 98.2% 81 24.5% 104 348.1 1139.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 13.4%
ISSUES 36.4%
SHORT 25.4%
LONG 16.8%
PERIODICALS 6.7%
COMMENTS 0.0%
Other 1.3%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.3%
Ten most frequent errors:
1. First word of command is invalid 30.2%
2. NS command - no next screen 29.8%
3. FIND command with invalid index name 9.5%
4. Index invalid in current database 3.9%
5. DISPLAY command contains invalid word 2.6%
6. Search term missing from search command 2.3%
7. D ABS command in database w/o abstracts 2.1%
8. PS command - no previous screen 1.9%
9. Max. # of ports to a Z39 db are in use 1.8%
10. Valid command at an inappropriate time 1.7%
11. All others 14.3%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.9%
2. FIND (CC DB) 13.2%
3. CC INDEXES 9.9%
4. LOCATE (ARTICLE DBS) 8.9%
5. CC DATABASE 5.5%
6. COMMANDS 5.2%
7. DATABASES 3.5%
8. ADD-ON SEARCH 3.5%
9. Unrecognized term 3.2%
10. MAIL 2.0%
11. All others 27.3%
Ten most frequent HELP situations:
1. Help requested from START CC command 17.4%
2. First word of command is invalid 11.1%
3. FIND command with invalid index name 7.6%
4. Help requested from SET DB command 7.0%
5. F/BR with index invalid in current DB 6.4%
6. FIND command with zero results 5.4%
7. DISPLAY command-first of >1 screen 4.6%
8. FIND command retrieves >1 book 4.5%
9. DISPLAY command-complete in one screen 3.7%
10. DISPLAY command - middle of >1 screen 3.6%
11. All others 28.7%
Ten most frequent SHOW requests:
1. HISTORY 40.9%
2. SC LIST (CC DBS) 9.1%
3. TIME 8.2%
4. SEARCH 7.3%
5. UPDATE 6.4%
6. MAIL STATUS 4.5%
7. SYSTEM NEWS 2.7%
8. CC SETTINGS 2.7%
9. CC LOADING STATISTICS 2.7%
10. CC NEWS 2.7%
11. All others 12.7%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)