MELVYL IAC DATABASES TELNET STATISTICS
Time period: 12/29/01 through 01/04/02
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 54 144 198
Davis 51 0 51
Irvine 41 0 41
Los Angeles 0 39 39
Riverside 9 7 16
San Diego 2 45 47
San Francisco 14 0 14
Santa Barbara 3 9 12
Santa Cruz 3 15 18
LBL 0 1 1
LLL 0 1 1
Los Alamos n/a 1 1
Other - UC 3 17 20
Stanford 1
Other-Network UC n/a 107 107
_______ ______ _____
180 386 567
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 20 42 1,624
2-4 a.m. 12 24 843
4-6 a.m. 8 27 181
6-8 a.m. 14 35 699
8-10 a.m. 48 105 4,719
10-12 a.m. 125 352 4,864
12-2 p.m. 100 267 2,495
2-4 p.m. 123 327 3,752
4-6 p.m. 47 120 3,181
6-8 p.m. 31 106 1,544
8-10 p.m. 18 74 804
10-12 p.m. 21 111 1,243
__________ __________ __________ _________________
Total: 567 1,590 25,949
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 116 376 492
Davis 110 0 110
Irvine 353 0 353
Los Angeles 0 76 76
Riverside 10 18 28
San Diego 3 85 88
San Francisco 27 0 27
Santa Barbara 5 20 25
Santa Cruz 8 34 42
LBL 0 1 1
LLL 0 4 4
Los Alamos n/a 1 1
Other - UC 2 59 61
Stanford 0
Other-Network UC n/a 282 282
_______ ______ _____
634 956 1,590
Number of FIND commands by database
MAGS database 1,434
NEWS database 60
COMP database 96
Total number of FIND commands 1,590
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 6,719 4,478 11,197
Davis 748 0 748
Irvine 1,101 0 1,101
Los Angeles 0 627 627
Riverside 48 106 154
San Diego 13 5,190 5,203
San Francisco 691 0 691
Santa Barbara 8 175 183
Santa Cruz 14 367 381
LBL 0 21 21
LLL 0 132 132
Los Alamos n/a 37 37
Other - UC 17 725 742
Stanford 0
Other-Network UC n/a 4,732 4,732
_______ ______ _____
9,359 16,590 25,949
Number of Records Displayed by database:
MAGS database 23,361
NEWS database 302
COMP database 2,286
Total number of Records Displayed 25,949
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 84.8%
Percent of NEWS sessions 8.1%
Percent of COMP sessions 7.1%
Percent of searches done in the MAGS database 90.2%
Percent of searches done in the NEWS database 3.8%
Percent of searches done in the COMP database 6.0%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.3
Standard deviation in seconds 1.0
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.1
Standard deviation in seconds 1.0
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 10:09
Average session length (minutes:seconds) 19:48
Longest session recorded (minutes:seconds) 712:03
Average number of searches completed per session 3.0
Retrievals per search - median 4.5
Retrievals per search - average 372.7
Retrievals per search - standard deviation 3964.1
Percent of searches completed with 0 results 23.0%
Percent of searches entered that are long 0.8%
Percent of long searches completed
(includes partial results) 81.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,299 27.6%
DISPLAY (excluding automatic displays) 2,070 43.9%
HELP 49 1.0%
EXPLAIN 22 0.5%
SET/RESET 223 4.7%
SHOW 8 0.2%
ADD ON (AND, OR, AND NOT) 135 2.9%
LOGON or LOGOFF 578 12.3%
COMMENT 0 0.0%
SAVE 111 2.4%
USE 1 0.0%
OTHER 218 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 524 37.9% 90 17.2% 7 27.6 79.2
TITLE WORD 294 21.3% 89 30.3% 10 105.2 328.7
EXACT TITLE 37 2.7% 17 45.9% 3 5.9 7.9
JOURNAL 56 4.1% 17 30.4% 774 6454.2 19728.8
EXACT JOURNAL 23 1.7% 7 30.4% 1,360 9694.0 17032.8
SUBJECT 140 10.1% 43 30.7% 24 90.8 250.1
EXACT SUBJECT 15 1.1% 5 33.3% 22 70.2 138.1
KEYWORD 204 14.8% 55 27.0% 29 501.5 1498.4
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 3 0.2% 1 33.3% 12 12.0 11.3
DATE 38 2.7% 5 13.2% 14 41.2 56.4
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 27 2.0% 3 11.1% 8 87.5 330.8
EXACT PE 11 0.8% 2 18.2% 11 46.1 57.7
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 10 0.7% 2 20.0% 93 2777.4 5377.5
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 83 6.4% 23 27.7% 16 396.6 2078.4
Single 1,215 93.6% 289 23.8% 11 543.5 4892.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.3%
SHORT 58.6%
LONG 5.4%
FIELDS 0.5%
PERIODICALS 2.0%
COMMENTS 0.0%
Other 30.3%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 14:19
Average session length (minutes:seconds) 20:42
Longest session recorded (minutes:seconds) 90:33
Average number of searches completed per session 2.4
Retrievals per search - median 12.5
Retrievals per search - average 156.5
Retrievals per search - standard deviation 704.7
Percent of searches completed with 0 results 19.8%
Percent of searches entered that are long 13.5%
Percent of long searches completed
(includes partial results) 100%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 80 18.2%
DISPLAY (excluding automatic displays) 243 55.4%
HELP 0 0.0%
EXPLAIN 7 1.6%
SET/RESET 31 7.1%
SHOW 3 0.7%
ADD ON (AND, OR, AND NOT) 16 3.6%
LOGON or LOGOFF 33 7.5%
COMMENT 0 0.0%
SAVE 11 2.5%
USE 0 0.0%
OTHER 15 3.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:
PERSONAL AUTHOR 5 5.1% 2 40.0% 6 6.0 5.0
TITLE WORD 30 30.3% 5 16.7% 72 366.8 1318.8
EXACT TITLE 2 2.0% 2 100% 0 0.0 0.0
JOURNAL 1 1.0% 1 100% 0 0.0 0.0
EXACT JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
SUBJECT 22 22.2% 1 4.5% 60 149.1 337.2
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 22 22.2% 3 13.6% 31 186.0 284.3
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 11 11.1% 1 9.1% 60 69.8 92.8
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 4 4.0% 0 0.0% 18 21.3 11.9
EXACT PE 2 2.0% 0 0.0% 12 11.5 9.2
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 0 0.0% 0 0.0% 0 0.0 0.0
By number of indexes:
Multiple 19 23.7% 1 5.3% 60 102.0 151.4
Single 61 76.2% 13 21.3% 35 270.6 983.1
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.0%
SHORT 65.5%
LONG 0.0%
FIELDS 1.2%
PERIODICALS 4.8%
COMMENTS 0.0%
Other 25.5%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 508
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 36
displays or when any of these paging options is set.
TEXT included with MAIL commands 56
SET DISPLAY TEXT commands 0
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 1:47
Average session length (minutes:seconds) 15:55
Longest session recorded (minutes:seconds) 288:51
Average number of searches completed per session 1.3
Retrievals per search - median 1.0
Retrievals per search - average 36.0
Retrievals per search - standard deviation 215.0
Percent of searches completed with 0 results 48.3%
Percent of searches entered that are long 1.7%
Percent of long searches completed
(includes partial results) 100%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 60 33.1%
DISPLAY (excluding automatic displays) 38 21.0%
HELP 4 2.2%
EXPLAIN 3 1.7%
SET/RESET 29 16.0%
SHOW 0 0.0%
ADD ON (AND, OR, AND NOT) 0 0.0%
LOGON or LOGOFF 40 22.1%
COMMENT 0 0.0%
SAVE 0 0.0%
USE 0 0.0%
OTHER 7 3.9%
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 3.1% 2 100% 0 0.0 0.0
TITLE WORD 18 27.7% 12 66.7% 16 32.5 47.9
EXACT TITLE 21 32.3% 10 47.6% 1 4.8 5.8
JOURNAL 1 1.5% 1 100% 0 0.0 0.0
EXACT JOURNAL 0 0.0% 0 0.0% 0 0.0 0.0
SUBJECT 15 23.1% 5 33.3% 23 198.9 517.3
EXACT SUBJECT 0 0.0% 0 0.0% 0 0.0 0.0
KEYWORD 3 4.6% 0 0.0% 8 14.3 11.0
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 0 0.0% 0 0.0% 0 0.0 0.0
DATE 3 4.6% 0 0.0% 15 10.7 8.4
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 2 3.1% 0 0.0% 5 5.0 2.8
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 0 0.0% 0 0.0% 0 0.0 0.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 5 8.3% 1 20.0% 16 40.5 60.1
Single 55 91.7% 28 50.9% 7 74.0 318.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.3%
SHORT 39.5%
LONG 5.8%
FIELDS 4.7%
PERIODICALS 7.0%
COMMENTS 0.0%
Other 40.7%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 7.7%
Ten most frequent errors:
1. First word of command is invalid 33.9%
2. NS command - no next screen 32.6%
3. FIND command with invalid index name 7.8%
4. DISPLAY command contains invalid word 4.2%
5. DISPLAY command - no FIND results 2.2%
6. NS of SHOW/EXP command-no next screen 2.2%
7. PS command - no previous screen 1.6%
8. Valid command at an inappropriate time 1.3%
9. Index invalid in current database 1.1%
10. 790 1.1%
11. All others 11.8%
Ten most frequent EXPLAIN requests:
1. MAGS DATABASE 15.6%
2. FIND 15.6%
3. COMMANDS 15.6%
4. GUIDE 12.5%
5. INDEXES 6.3%
6. A014 6.3%
7. DATABASES 6.3%
8. DATES 3.1%
9. MAIL 3.1%
10. LOCATE (ARTICLE DBS) 3.1%
11. All others 12.5%
Ten most frequent HELP situations:
1. Help requested from SET DB command 43.5%
2. First word of command is invalid 11.8%
3. FIND command with invalid index name 9.4%
4. DISPLAY command-complete in one screen 7.1%
5. DISPLAY command-first of >1 screen 4.7%
6. 278 3.5%
7. NS of SHOW/EXP command-no next screen 3.5%
8. DISPLAY command - middle of >1 screen 2.4%
9. SET DB command entered w/o modifier 1.2%
10. 15 1.2%
11. All others 11.8%
Ten most frequent SHOW requests:
1. IAC NEWS 40.0%
2. HISTORY 30.0%
3. SETTINGS (IAC DBS) 10.0%
4. GLOSSARY 10.0%
5. SEARCH 10.0%
11. All others 0.0%
IACmm/dd iac MELVYL IAC DATABASES TELNET STATISTICS (weekly)