MELVYL IAC DATABASES TELNET STATISTICS
Time period: 07/01/99 through 07/31/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 1,041 2,026 3,067
Davis 1,396 134 1,530
Irvine 1,546 0 1,546
Los Angeles 302 1,335 1,637
Riverside 445 146 591
San Diego 245 264 509
San Francisco 497 5 502
Santa Barbara 1,118 421 1,539
Santa Cruz 872 565 1,437
LBL 0 122 122
LLL 0 39 39
Los Alamos n/a 3 3
Other - UC 57 223 280
Stanford 547
Other-Network UC n/a 1,257 1,257
_______ ______ _____
7,519 6,540 14,606
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 184 926 13,114
2-4 a.m. 72 402 5,010
4-6 a.m. 62 237 2,496
6-8 a.m. 255 672 7,595
8-10 a.m. 1,318 3,943 45,870
10-12 a.m. 2,577 7,970 140,071
12-2 p.m. 2,729 8,426 157,156
2-4 p.m. 3,334 10,346 151,740
4-6 p.m. 2,344 7,354 85,121
6-8 p.m. 885 3,030 39,731
8-10 p.m. 487 1,722 25,681
10-12 p.m. 359 1,470 20,403
__________ __________ __________ _________________
Total: 14,606 46,498 693,988
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 3,229 5,442 8,671
Davis 4,099 328 4,427
Irvine 5,150 0 5,150
Los Angeles 886 4,484 5,370
Riverside 1,431 479 1,910
San Diego 793 840 1,633
San Francisco 1,285 9 1,294
Santa Barbara 3,737 1,335 5,072
Santa Cruz 3,322 1,647 4,969
LBL 0 268 268
LLL 0 92 92
Los Alamos n/a 3 3
Other - UC 198 730 928
Stanford 2,390
Other-Network UC n/a 4,321 4,321
_______ ______ _____
24,130 19,978 46,498
Number of FIND commands by database
MAGS database 40,681
NEWS database 4,111
COMP database 1,706
Total number of FIND commands 46,498
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 41,912 69,481 111,393
Davis 33,751 4,260 38,011
Irvine 48,948 0 48,948
Los Angeles 10,137 61,990 72,127
Riverside 12,319 5,320 17,639
San Diego 6,802 8,751 15,553
San Francisco 17,682 63 17,745
Santa Barbara 45,374 16,398 61,772
Santa Cruz 27,968 15,901 43,869
LBL 0 2,638 2,638
LLL 0 1,014 1,014
Los Alamos n/a 6 6
Other - UC 3,834 7,418 11,252
Stanford 4,089
Other-Network UC n/a 227,707 227,707
_______ ______ _____
248,727 420,947 673,763
Number of Records Displayed by database:
MAGS database 582,604
NEWS database 95,012
COMP database 16,372
Total number of Records Displayed 673,763
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 84.3%
Percent of NEWS sessions 11.7%
Percent of COMP sessions 4.0%
Percent of searches done in the MAGS database 87.5%
Percent of searches done in the NEWS database 8.8%
Percent of searches done in the COMP database 3.7%
1.5 Response time
__________________
Search response time from receipt of command at
DLA until transmission of response:
Average in seconds 0.6
Standard deviation in seconds 3.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 3.5
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 7:33
Average session length (minutes:seconds) 13:29
Longest session recorded (minutes:seconds) 896:59
Average number of searches completed per session 3.3
Retrievals per search - median 5.0
Retrievals per search - average 579.7
Retrievals per search - standard deviation 7982.0
Percent of searches completed with 0 results 31.0%
Percent of searches entered that are long 1.5%
Percent of long searches completed
(includes partial results) 54.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 38,001 27.4%
DISPLAY (excluding automatic displays) 58,091 41.8%
HELP 3,681 2.7%
EXPLAIN 2,662 1.9%
SET/RESET 4,269 3.1%
SHOW 579 0.4%
ADD ON (AND, OR, AND NOT) 2,680 1.9%
LOGON or LOGOFF 16,893 12.2%
COMMENT 0 0.0%
SAVE 2,849 2.1%
USE 90 0.1%
OTHER 9,062 6.5%
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 6,857 17.3% 2,112 30.8% 9 61.9 370.7
TITLE WORD 8,054 20.4% 2,567 31.9% 13 333.3 2298.8
EXACT TITLE 1,380 3.5% 574 41.6% 2 71.5 461.7
JOURNAL 2,048 5.2% 1,084 52.9% 1,032 5326.2 10815.5
EXACT JOURNAL 1,208 3.1% 520 43.0% 814 4314.2 15353.6
SUBJECT 7,549 19.1% 2,860 37.9% 44 516.3 11764.0
EXACT SUBJECT 340 0.9% 119 35.0% 23 293.8 743.6
KEYWORD 10,186 25.8% 2,132 20.9% 33 1165.3 13810.9
SUBFILE 6 0.0% 0 0.0% 89 152.3 219.9
PUBLICATION TYPE 76 0.2% 8 10.5% 15 153.3 504.7
DATE 430 1.1% 107 24.9% 22 287.7 861.6
ADDED 8 0.0% 1 12.5% 40,155 29060.7 16459.4
PERIODICAL 723 1.8% 133 18.4% 8 207.4 1216.4
EXACT PE 339 0.9% 32 9.4% 3 55.5 260.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 325 0.8% 58 17.8% 146 2895.5 7142.8
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,773 4.7% 574 32.4% 13 573.8 2785.8
Single 35,921 95.3% 11,131 31.0% 21 886.6 10098.3
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.2%
SHORT 64.8%
LONG 2.0%
FIELDS 0.7%
PERIODICALS 1.6%
COMMENTS 0.0%
Other 28.7%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 5:57
Average session length (minutes:seconds) 11:34
Longest session recorded (minutes:seconds) 144:25
Average number of searches completed per session 2.9
Retrievals per search - median 6.0
Retrievals per search - average 600.9
Retrievals per search - standard deviation 3968.5
Percent of searches completed with 0 results 31.4%
Percent of searches entered that are long 2.5%
Percent of long searches completed
(includes partial results) 60.5%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,446 24.5%
DISPLAY (excluding automatic displays) 2,454 41.6%
HELP 120 2.0%
EXPLAIN 107 1.8%
SET/RESET 232 3.9%
SHOW 25 0.4%
ADD ON (AND, OR, AND NOT) 260 4.4%
LOGON or LOGOFF 784 13.3%
COMMENT 0 0.0%
SAVE 113 1.9%
USE 8 0.1%
OTHER 344 5.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:
PERSONAL AUTHOR 147 9.6% 79 53.7% 5 179.0 730.2
TITLE WORD 430 28.2% 138 32.1% 28 372.2 1222.1
EXACT TITLE 14 0.9% 13 92.9% 1 1.0 0.0
JOURNAL 34 2.2% 16 47.1% 1,144 11462.6 16686.3
EXACT JOURNAL 18 1.2% 7 38.9% 3,150 2783.1 1593.6
SUBJECT 224 14.7% 73 32.6% 38 722.0 3464.3
EXACT SUBJECT 12 0.8% 3 25.0% 22 1196.7 1655.8
KEYWORD 572 37.5% 132 23.1% 53 1128.1 6189.0
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 11 0.7% 0 0.0% 163 374.1 665.4
DATE 41 2.7% 13 31.7% 14 114.8 245.3
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 5 0.3% 4 80.0% 9 9.0 0.0
EXACT PE 7 0.5% 2 28.6% 4 4.2 3.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 11 0.7% 6 54.5% 83 1102.4 1466.0
By number of indexes:
Multiple 90 6.3% 25 27.8% 25 243.5 577.9
Single 1,342 93.7% 436 32.5% 41 1054.3 5357.5
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
SHORT 66.0%
LONG 1.1%
FIELDS 1.8%
PERIODICALS 0.4%
COMMENTS 0.0%
Other 27.2%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 12,763
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 576
displays or when any of these paging options is set.
TEXT included with MAIL commands 3,433
SET DISPLAY TEXT commands 2
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 4:26
Average session length (minutes:seconds) 11:56
Longest session recorded (minutes:seconds) 799:28
Average number of searches completed per session 2.4
Retrievals per search - median 3.0
Retrievals per search - average 3551.4
Retrievals per search - standard deviation 49376
Percent of searches completed with 0 results 36.3%
Percent of searches entered that are long 1.2%
Percent of long searches completed
(includes partial results) 63.3%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 3,821 34.0%
DISPLAY (excluding automatic displays) 2,942 26.1%
HELP 334 3.0%
EXPLAIN 222 2.0%
SET/RESET 879 7.8%
SHOW 48 0.4%
ADD ON (AND, OR, AND NOT) 290 2.6%
LOGON or LOGOFF 1,941 17.3%
COMMENT 0 0.0%
SAVE 270 2.4%
USE 7 0.1%
OTHER 498 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:
PERSONAL AUTHOR 257 6.3% 106 41.2% 20 146.9 357.7
TITLE WORD 885 21.8% 329 37.2% 9 288.2 1494.5
EXACT TITLE 100 2.5% 53 53.0% 3 121.6 434.2
JOURNAL 86 2.1% 44 51.2% 1,222 313077 378030
EXACT JOURNAL 34 0.8% 13 38.2% 47 1182.7 2932.0
SUBJECT 1,038 25.5% 400 38.5% 19 418.2 1488.8
EXACT SUBJECT 46 1.1% 22 47.8% 24 100.5 150.4
KEYWORD 1,448 35.6% 432 29.8% 16 855.2 4612.5
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 15 0.4% 1 6.7% 7 55.0 127.7
DATE 132 3.2% 37 28.0% 12 133.2 293.3
ADDED 2 0.0% 0 0.0% 15 15.0 4.2
PERIODICAL 15 0.4% 2 13.3% 6 11.3 12.0
EXACT PE 3 0.1% 0 0.0% 3 20.0 31.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 6 0.1% 5 83.3% 559 559.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 263 6.9% 79 30.0% 13 321.4 1424.9
Single 3,532 93.1% 1,281 36.3% 15 6395.5 66360.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 4.2%
SHORT 48.5%
LONG 3.3%
FIELDS 1.0%
PERIODICALS 0.7%
COMMENTS 0.0%
Other 42.4%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 12.6%
Ten most frequent errors:
1. First word of command is invalid 34.1%
2. NS command - no next screen 25.9%
3. FIND command with invalid index name 10.9%
4. PS command - no previous screen 4.3%
5. DISPLAY command contains invalid word 4.2%
6. Valid command at an inappropriate time 2.3%
7. Search term missing from search command 1.9%
8. MAIL command issued w/o email address 1.8%
9. DISPLAY command - no FIND results 1.0%
10. DISPLAY command-record numbers too large 1.0%
11. All others 12.5%
Ten most frequent EXPLAIN requests:
1. GUIDE 23.8%
2. LOCATE (ARTICLE DBS) 14.4%
3. FIND 9.6%
4. COMMANDS 7.9%
5. INDEXES 6.6%
6. MAGS DATABASE 4.7%
7. Unrecognized term 4.3%
8. MAIL 3.2%
9. DISPLAYS (IAC DBS) 3.1%
10. DATABASES 2.2%
11. All others 20.1%
Ten most frequent HELP situations:
1. Help requested from SET DB command 24.1%
2. First word of command is invalid 17.9%
3. FIND command with invalid index name 10.1%
4. FIND command with zero results 7.1%
5. DISPLAY command-first of >1 screen 5.0%
6. DISPLAY command-complete in one screen 4.9%
7. DISPLAY command - middle of >1 screen 4.3%
8. FIND command retrieves >1 book 3.1%
9. NS command - no next screen 2.9%
10. PS command - no previous screen 2.1%
11. All others 18.4%
Ten most frequent SHOW requests:
1. SEARCH 36.8%
2. HISTORY 34.3%
3. MAIL STATUS 7.7%
4. SYSTEM NEWS 4.2%
5. IAC NEWS 3.3%
6. GLOSSARY 3.0%
7. MAIL SETTINGS 3.0%
8. SETTINGS (IAC DBS) 2.4%
9. LIBRARY NEWS 0.9%
10. DISPLAY 0.8%
11. All others 3.6%