MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS
Time period: 02/02/02 through 02/08/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 68 540 608
Davis 275 17 292
Irvine 113 0 113
Los Angeles 1 185 186
Riverside 19 57 76
San Diego 36 214 250
San Francisco 136 0 136
Santa Barbara 6 71 77
Santa Cruz 4 48 52
LBL 0 148 148
LLL 0 45 45
Los Alamos n/a 0 0
Other - UC 1 27 28
U.S. Forestry 0
Other-Network UC n/a 515 515
_______ ______ _____
659 1,867 2,526
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 67 184 1,105
2-4 a.m. 35 98 8,402
4-6 a.m. 42 176 1,201
6-8 a.m. 70 215 1,580
8-10 a.m. 311 779 5,843
10-12 a.m. 482 1,581 10,900
12-2 p.m. 400 1,139 9,807
2-4 p.m. 465 1,353 13,824
4-6 p.m. 301 885 8,404
6-8 p.m. 174 565 4,984
8-10 p.m. 108 278 2,287
10-12 p.m. 71 224 2,073
__________ __________ __________ _________________
Total: 2,526 7,477 70,410
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 123 1,839 1,962
Davis 731 47 778
Irvine 350 0 350
Los Angeles 2 560 562
Riverside 34 167 201
San Diego 62 533 595
San Francisco 682 0 682
Santa Barbara 12 197 209
Santa Cruz 17 138 155
LBL 0 282 282
LLL 0 141 141
Los Alamos n/a 0 0
Other - UC 4 98 102
U.S. Forestry 0
Other-Network UC n/a 1,458 1,458
_______ ______ _____
2,017 5,460 7,477
Number of FIND commands by database
CC database 7,305
CCT database 172
Total number of FIND commands 7,477
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 700 15,596 16,296
Davis 6,208 181 6,389
Irvine 11,050 0 11,050
Los Angeles 0 4,846 4,846
Riverside 809 2,591 3,400
San Diego 821 4,490 5,311
San Francisco 2,593 0 2,593
Santa Barbara 69 2,911 2,980
Santa Cruz 201 1,658 1,859
LBL 0 3,027 3,027
LLL 0 2,351 2,351
Los Alamos n/a 0 0
Other - UC 6 753 759
U.S. Forestry 0
Other-Network UC n/a 9,549 9,549
_______ ______ _____
22,457 47,953 70,410
Number of Records Displayed by database:
CC database 65,520
CCT database 4,890
Total number of Records Displayed 70,410
1.4 Relative Use of Databases
______________________________
Relative use of CC vs. CCT databases:
Percent of CC sessions 96.8%
Percent of CCT sessions 3.2%
Percent of searches done in the CC database 97.7%
Percent of searches done in the CCT database 2.3%
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.3
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.3
2.0 CC Database Statistics
___________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 331:40
Average number of searches completed per session 3.0
Retrievals per search - median 9.0
Retrievals per search - average 517.4
Retrievals per search - standard deviation 4075.0
Percent of searches completed with 0 results 22.0%
Percent of searches entered that are long 0.5%
Percent of long searches completed
(includes partial results) 72.7%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 6,599 36.3%
DISPLAY (excluding automatic displays) 5,524 30.4%
HELP 122 0.7%
EXPLAIN 128 0.7%
SET/RESET 977 5.4%
SHOW 18 0.1%
ADD ON (AND, OR, AND NOT) 706 3.9%
LOGON or LOGOFF 3,082 16.9%
COMMENT 0 0.0%
SAVE 257 1.4%
USE 2 0.0%
OTHER 773 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 2,977 41.2% 446 15.0% 32 195.7 949.8
TITLE WORD 2,304 31.9% 714 31.0% 12 679.5 6274.2
EXACT TITLE 81 1.1% 36 44.4% 5 454.6 2812.7
JOURNAL 456 6.3% 133 29.2% 1,161 4933.7 10678.8
EXACT JOURNAL 113 1.6% 33 29.2% 962 4107.0 8772.0
SUBJECT CAT 21 0.3% 4 19.0% 17 19.5 17.5
SUBFILE 10 0.1% 1 10.0% 45 39.1 23.4
PUBLICATION TYPE 29 0.4% 15 51.7% 2 64.9 215.1
LANGUAGE 1 0.0% 0 0.0% 60 60.0 0.0
DATE 150 2.1% 26 17.3% 5 102.4 340.0
ADDED 24 0.3% 3 12.5% 8 10.8 11.3
PERIODICAL 587 8.1% 63 10.7% 5 63.1 835.0
EXACT PE 97 1.3% 3 3.1% 2 10.3 25.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 370 5.1% 125 33.8% 18 659.5 4100.1
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 623 9.5% 189 30.3% 4 40.3 190.5
Single 5,948 90.5% 1,213 20.4% 27 780.0 5028.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.8%
SHORT 70.8%
LONG 4.7%
FIELDS 1.2%
PERIODICALS 17.4%
COMMENTS 0.0%
Other 1.0%
2.1 CCT Database Statistics
____________________________
Median session length (minutes:seconds) 0:00
Average session length (minutes:seconds) 0:00
Longest session recorded (minutes:seconds) 91:36
Average number of searches completed per session 2.1
Retrievals per search - median 77.0
Retrievals per search - average 246.7
Retrievals per search - standard deviation 742.4
Percent of searches completed with 0 results 24.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 172 26.7%
DISPLAY (excluding automatic displays) 257 39.8%
HELP 37 5.7%
EXPLAIN 18 2.8%
SET/RESET 56 8.7%
SHOW 7 1.1%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 77 11.9%
COMMENT 0 0.0%
SAVE 1 0.2%
USE 0 0.0%
OTHER 20 3.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 115 66.9% 35 30.4% 136 300.4 625.2
EXACT JOURNAL 54 31.4% 7 13.0% 112 230.9 414.1
SUBJECT CAT 1 0.6% 0 0.0% 7,497 7497.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 2 1.2% 0 0.0% 26 25.5 29.0
By number of indexes:
Multiple 0 0.0% 0 0.0% 0 0.0 0.0
Single 172 100% 42 24.4% 130 326.4 839.2
DISPLAY commands, by type, excluding automatic displays:
REVIEW 14.9%
ISSUES 41.3%
SHORT 22.1%
LONG 19.2%
PERIODICALS 1.8%
COMMENTS 0.0%
Other 0.7%
2.3 Error, EXPLAIN and HELP statistics (CC & CCT)
__________________________________________________
Percent of commands that contained errors 7.2%
Ten most frequent errors:
1. NS command - no next screen 33.9%
2. First word of command is invalid 27.4%
3. FIND command with invalid index name 9.3%
4. Index invalid in current database 4.3%
5. DISPLAY command contains invalid word 2.9%
6. Search term missing from search command 2.2%
7. DISPLAY command - no FIND results 1.5%
8. PS command - no previous screen 1.5%
9. Valid command at an inappropriate time 1.4%
10. Add-on search, no index name after verb 1.3%
11. All others 14.1%
Ten most frequent EXPLAIN requests:
1. CC GUIDE 17.8%
2. FIND (CC DB) 13.7%
3. LOCATE (ARTICLE DBS) 9.6%
4. CC INDEXES 8.2%
5. COMMANDS 7.5%
6. DATABASES 6.8%
7. Unrecognized term 4.8%
8. CCT INDEXES 3.4%
9. DISPLAY 2.7%
10. SUBJECT CATEGORY 2.7%
11. All others 22.6%
Ten most frequent HELP situations:
1. Help requested from START CC command 16.1%
2. First word of command is invalid 13.4%
3. F/BR with index invalid in current DB 10.8%
4. Help requested from SET DB command 7.2%
5. FIND command with invalid index name 5.9%
6. FIND command with zero results 4.3%
7. DISPLAY command-first of >1 screen 4.3%
8. 15 3.6%
9. FIND command retrieves >1 book 3.6%
10. DISPLAY command-complete in one screen 2.6%
11. All others 28.2%
Ten most frequent SHOW requests:
1. SEARCH 20.0%
2. HISTORY 20.0%
3. TIME 16.0%
4. MAIL STATUS 16.0%
5. SYSTEM NEWS 12.0%
6. CC NEWS 8.0%
7. SYSTEM1 NEWS 4.0%
8. SC LIST (CC DBS) 4.0%
11. All others 0.0%
Cmm/yy cc MELVYL CURRENT CONTENTS DATABASE TELNET STATISTICS (monthly)