MELVYL IAC DATABASES TELNET STATISTICS
Time period: 09/01/99 through 09/30/99
1.0 SUMMARY STATISTICS
_______________________
1.1 Total sessions:
____________________
Location Library Remote Total
________ _______ ______ _____
Berkeley 2,205 3,300 5,505
Davis 1,245 213 1,458
Irvine 1,341 0 1,341
Los Angeles 244 1,083 1,327
Riverside 372 150 522
San Diego 325 253 578
San Francisco 397 38 435
Santa Barbara 423 398 821
Santa Cruz 536 695 1,231
LBL 0 87 87
LLL 0 46 46
Los Alamos n/a 3 3
Other - UC 38 513 551
Stanford 443
Other-Network UC n/a 1,074 1,074
_______ ______ _____
7,126 7,853 15,422
Per hour usage:
Time Sessions Finds Records Displayed
__________ __________ __________ _________________
12-2 a.m. 232 1,016 17,415
2-4 a.m. 91 434 9,233
4-6 a.m. 45 158 4,553
6-8 a.m. 178 526 9,160
8-10 a.m. 1,271 3,567 35,648
10-12 a.m. 2,574 7,556 87,790
12-2 p.m. 3,009 8,780 98,133
2-4 p.m. 3,615 10,987 119,684
4-6 p.m. 2,207 7,120 82,646
6-8 p.m. 905 3,060 36,735
8-10 p.m. 795 2,304 30,028
10-12 p.m. 500 1,718 25,791
__________ __________ __________ _________________
Total: 15,422 47,226 556,816
1.2 FIND commands
__________________
Number of FIND commands issued by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 6,989 10,024 17,013
Davis 3,507 1,087 4,594
Irvine 4,045 0 4,045
Los Angeles 763 3,310 4,073
Riverside 1,125 420 1,545
San Diego 946 802 1,748
San Francisco 914 83 997
Santa Barbara 1,221 1,111 2,332
Santa Cruz 1,791 1,402 3,193
LBL 0 216 216
LLL 0 130 130
Los Alamos n/a 34 34
Other - UC 77 1,870 1,947
Stanford 1,463
Other-Network UC n/a 3,896 3,896
_______ ______ _____
21,378 24,385 47,226
Number of FIND commands by database
MAGS database 41,578
NEWS database 4,165
COMP database 1,483
Total number of FIND commands 47,226
1.3 Records displayed
______________________
Number of Records Displayed by location:
Location Library Remote Total
________ _______ ______ _____
Berkeley 83,181 127,370 210,551
Davis 32,244 5,745 37,989
Irvine 34,780 0 34,780
Los Angeles 10,460 41,938 52,398
Riverside 9,497 4,292 13,789
San Diego 8,346 9,770 18,116
San Francisco 13,523 1,353 14,876
Santa Barbara 11,356 18,693 30,049
Santa Cruz 14,105 13,211 27,316
LBL 0 1,825 1,825
LLL 0 3,712 3,712
Los Alamos n/a 11 11
Other - UC 846 30,261 31,107
Stanford 2,858
Other-Network UC n/a 56,413 56,413
_______ ______ _____
218,338 314,594 535,790
Number of Records Displayed by database:
MAGS database 504,489
NEWS database 34,876
COMP database 17,451
Total number of Records Displayed 535,790
1.4 Relative Use of Databases
______________________________
Relative use of MAGS, NEWS, & COMP databases:
Percent of MAGS sessions 85.0%
Percent of NEWS sessions 11.0%
Percent of COMP sessions 4.0%
Percent of searches done in the MAGS database 88.0%
Percent of searches done in the NEWS database 8.8%
Percent of searches done in the COMP database 3.1%
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.8
Display response time from receipt of command at
DLA until transmission of a complete screen:
Average in seconds 0.2
Standard deviation in seconds 3.8
2.0 Magazines & Journals Database Statistics
_____________________________________________
Median session length (minutes:seconds) 6:23
Average session length (minutes:seconds) 12:08
Longest session recorded (minutes:seconds) 426:40
Average number of searches completed per session 3.1
Retrievals per search - median 5.0
Retrievals per search - average 510.8
Retrievals per search - standard deviation 5530.8
Percent of searches completed with 0 results 31.1%
Percent of searches entered that are long 1.4%
Percent of long searches completed
(includes partial results) 52.9%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 39,366 27.8%
DISPLAY (excluding automatic displays) 57,828 40.9%
HELP 4,159 2.9%
EXPLAIN 3,222 2.3%
SET/RESET 4,622 3.3%
SHOW 725 0.5%
ADD ON (AND, OR, AND NOT) 2,212 1.6%
LOGON or LOGOFF 17,722 12.5%
COMMENT 2 0.0%
SAVE 3,105 2.2%
USE 31 0.0%
OTHER 8,394 5.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 7,220 17.7% 2,113 29.3% 10 63.2 236.7
TITLE WORD 8,516 20.9% 2,646 31.1% 12 423.5 3308.2
EXACT TITLE 1,270 3.1% 728 57.3% 3 116.3 511.0
JOURNAL 1,892 4.6% 969 51.2% 1,015 5521.5 12455.1
EXACT JOURNAL 997 2.4% 471 47.2% 961 5429.1 11289.5
SUBJECT 8,949 22.0% 3,527 39.4% 35 415.4 2771.2
EXACT SUBJECT 304 0.7% 115 37.8% 33 4100.5 51995.7
KEYWORD 9,011 22.1% 1,774 19.7% 25 861.2 7335.8
SUBFILE 23 0.1% 13 56.5% 176 270.9 335.0
PUBLICATION TYPE 81 0.2% 27 33.3% 9 803.8 2439.6
DATE 383 0.9% 115 30.0% 17 225.1 791.0
ADDED 6 0.0% 0 0.0% 24,982 18872.7 15494.8
PERIODICAL 1,408 3.5% 210 14.9% 5 205.1 2171.1
EXACT PE 311 0.8% 48 15.4% 3 28.7 115.0
RPE 1 0.0% 1 100% 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 362 0.9% 66 18.2% 407 2589.4 5885.3
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,589 4.1% 570 35.9% 12 874.6 5083.2
Single 37,487 95.9% 11,655 31.1% 18 755.6 6874.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 2.2%
SHORT 63.3%
LONG 1.7%
FIELDS 0.7%
PERIODICALS 2.6%
COMMENTS 0.0%
Other 29.4%
2.1 Computer Articles Database Statistics
__________________________________________
Median session length (minutes:seconds) 5:57
Average session length (minutes:seconds) 10:04
Longest session recorded (minutes:seconds) 75:01
Average number of searches completed per session 2.4
Retrievals per search - median 5.0
Retrievals per search - average 1023.2
Retrievals per search - standard deviation 6298.3
Percent of searches completed with 0 results 34.2%
Percent of searches entered that are long 1.7%
Percent of long searches completed
(includes partial results) 68.0%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 1,332 25.0%
DISPLAY (excluding automatic displays) 2,075 38.9%
HELP 155 2.9%
EXPLAIN 140 2.6%
SET/RESET 253 4.7%
SHOW 29 0.5%
ADD ON (AND, OR, AND NOT) 151 2.8%
LOGON or LOGOFF 805 15.1%
COMMENT 0 0.0%
SAVE 83 1.6%
USE 0 0.0%
OTHER 307 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 180 12.6% 113 62.8% 5 52.1 163.5
TITLE WORD 337 23.6% 97 28.8% 19 765.9 4006.7
EXACT TITLE 26 1.8% 23 88.5% 296 199.7 166.9
JOURNAL 71 5.0% 47 66.2% 2,730 15688.0 35028.2
EXACT JOURNAL 69 4.8% 37 53.6% 1,334 8051.1 16068.6
SUBJECT 173 12.1% 67 38.7% 29 323.9 711.7
EXACT SUBJECT 9 0.6% 2 22.2% 1,732 7777.1 11360.8
KEYWORD 485 33.9% 120 24.7% 42 989.9 4233.1
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 9 0.6% 3 33.3% 13 15.5 11.9
DATE 48 3.4% 9 18.8% 26 176.2 375.7
ADDED 0 0.0% 0 0.0% 0 0.0 0.0
PERIODICAL 7 0.5% 1 14.3% 28 3045.2 7353.0
EXACT PE 5 0.3% 1 20.0% 2 3.5 4.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 11 0.8% 2 18.2% 59 790.2 1217.6
By number of indexes:
Multiple 102 7.7% 36 35.3% 26 225.1 566.2
Single 1,220 92.3% 449 36.8% 29 1653.3 8414.7
DISPLAY commands, by type, excluding automatic displays:
REVIEW 5.4%
SHORT 62.9%
LONG 1.2%
FIELDS 2.1%
PERIODICALS 0.5%
COMMENTS 0.0%
Other 27.9%
2.1.1 Article Text
___________________
DISPLAY TEXT commands 10,839
TEXT included with CONTINUOUS, PRINT, CAPTURE, or SLOW 406
displays or when any of these paging options is set.
TEXT included with MAIL commands 2,015
SET DISPLAY TEXT commands 0
2.2 Newspaper Articles Database Statistics
___________________________________________
Median session length (minutes:seconds) 5:00
Average session length (minutes:seconds) 10:09
Longest session recorded (minutes:seconds) 500:09
Average number of searches completed per session 2.4
Retrievals per search - median 4.0
Retrievals per search - average 2636.2
Retrievals per search - standard deviation 42483
Percent of searches completed with 0 results 34.8%
Percent of searches entered that are long 2.1%
Percent of long searches completed
(includes partial results) 55.8%
Commands entered, by type, excluding errors:
Total Percentage
__________ __________
FIND 3,901 32.5%
DISPLAY (excluding automatic displays) 3,034 25.3%
HELP 578 4.8%
EXPLAIN 385 3.2%
SET/RESET 805 6.7%
SHOW 92 0.8%
ADD ON (AND, OR, AND NOT) 264 2.2%
LOGON or LOGOFF 2,020 16.9%
COMMENT 1 0.0%
SAVE 309 2.6%
USE 3 0.0%
OTHER 593 4.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 259 6.3% 119 45.9% 31 241.5 586.5
TITLE WORD 941 22.9% 292 31.0% 15 259.6 1298.7
EXACT TITLE 137 3.3% 89 65.0% 2 28.9 70.3
JOURNAL 71 1.7% 34 47.9% 11,255 257582 371765
EXACT JOURNAL 63 1.5% 19 30.2% 64 1364.0 3271.4
SUBJECT 1,105 26.9% 444 40.2% 26 514.0 2221.7
EXACT SUBJECT 56 1.4% 31 55.4% 88 1405.8 2835.8
KEYWORD 1,294 31.5% 363 28.1% 22 710.3 4037.8
SUBFILE 0 0.0% 0 0.0% 0 0.0 0.0
PUBLICATION TYPE 6 0.1% 3 50.0% 24,353 16237.3 14056.7
DATE 110 2.7% 12 10.9% 18 970.4 8018.3
ADDED 6 0.1% 3 50.0% 2 16.0 24.2
PERIODICAL 13 0.3% 4 30.8% 30 711.8 1761.2
EXACT PE 4 0.1% 1 25.0% 2 28.0 45.9
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 48 1.2% 4 8.3% 22 204.3 297.2
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 254 6.6% 59 23.2% 23 986.4 6110.0
Single 3,600 93.4% 1,298 36.1% 21 4606.9 56691.8
DISPLAY commands, by type, excluding automatic displays:
REVIEW 3.4%
SHORT 48.4%
LONG 3.7%
FIELDS 1.7%
PERIODICALS 0.3%
COMMENTS 0.0%
Other 42.5%
2.3 Error, EXPLAIN and HELP statistics (MAGS, COMP, & NEWS)
_______________________________________ ____________________
Percent of commands that contained errors 12.5%
Ten most frequent errors:
1. First word of command is invalid 35.4%
2. NS command - no next screen 24.9%
3. FIND command with invalid index name 11.1%
4. PS command - no previous screen 5.1%
5. DISPLAY command contains invalid word 4.0%
6. Valid command at an inappropriate time 2.4%
7. Search term missing from search command 2.0%
8. MAIL command issued w/o email address 1.3%
9. DISPLAY command - no FIND results 0.9%
10. DISPLAY command-record numbers too large 0.7%
11. All others 12.2%
Ten most frequent EXPLAIN requests:
1. GUIDE 20.7%
2. LOCATE (ARTICLE DBS) 20.4%
3. FIND 9.6%
4. COMMANDS 7.4%
5. INDEXES 5.4%
6. Unrecognized term 4.8%
7. MAGS DATABASE 4.3%
8. MAIL 3.5%
9. DISPLAYS (IAC DBS) 3.4%
10. ADDON SEARCH 2.6%
11. All others 17.9%
Ten most frequent HELP situations:
1. Help requested from SET DB command 22.1%
2. First word of command is invalid 17.5%
3. FIND command with invalid index name 9.2%
4. FIND command with zero results 6.6%
5. DISPLAY command-complete in one screen 6.3%
6. DISPLAY command-first of >1 screen 5.2%
7. DISPLAY command - middle of >1 screen 4.9%
8. FIND command retrieves >1 book 3.9%
9. NS command - no next screen 2.9%
10. PS command - no previous screen 2.3%
11. All others 19.0%
Ten most frequent SHOW requests:
1. SEARCH 39.0%
2. HISTORY 31.8%
3. MAIL STATUS 9.9%
4. SYSTEM NEWS 3.6%
5. GLOSSARY 3.5%
6. IAC NEWS 2.9%
7. MAIL SETTINGS 2.9%
8. SETTINGS (IAC DBS) 1.9%
9. LIBRARY NEWS 0.6%
10. SYSTEM2 NEWS 0.5%
11. All others 3.4%