/t/sirsi/Unicorn/Searchdb/KUNI/form.db is the description of the database. It has a definition for every
paragraph in the database and what the search and display qualities should be.
If you view the form.db file you'll notice that paragraphs relate to entries in
the keyword index policy.
info.db (in the same directory) is a compiled version of the form file.
txt0.db and txt1.db are the actual bibliographic records. These contain the
text of every document in the database.
dict.db (in the /t/...KUNI directory also) is an alphabetical dictionary of every searchable word in all documents. When you issue a search statement, the term(s) are checked against the dictionary file. Also includes number of occurrences of the term and number of documents (records) with the term. Each entry in this file contains a pointer to the inverted files (inv0, inv1, inv2).
inv0.db and inv1.db and inv2.db are the inverted keyword indexes -- essentially a linked list of the locations of every word in every document (for every word in the dictionary). They contain the document, paragraph, sentence, and word position of every word in the database; these files are consulted when you perform a multi-search term. Single term searches only consult dict.db because number of occurrences and number of documents that contain the term are already in the dictionary file.
stat.db keeps track of changes to the database.
txix.db is a list of every document in the database. For every document there is a pointer to the actual text stored in the text files (txt0, txt1)
heading1.idx through heading8.idx are the browse indexes.
The marc0.fil file is the actual file of MARC records.
Question: Is catalog.dat an Informix database? What do I mean by "The .dat file
is the fixed record catalog (not MARC)"?
/load1/sirsi/Unicorn/Database
total 2022416
drwx------- 2 sirsi sirsi 512 Apr 23 1996 .
drwx------- 3 sirsi sirsi 512 Jun 06 2001 ..
-rw-------- 1 sirsi sirsi 305270784 Apr 04 13:49 callnums.dat
-rw-------- 1 sirsi sirsi 445009920 Apr 04 13:49 callnums.idx
-rw-------- 1 sirsi sirsi 225183744 Apr 04 14:09 items.dat
-rw-------- 1 sirsi sirsi 59595776 Apr 04 14:09 items.idx
/load3/sirsi/Unicorn/Database
total 2573584
drwx------- 2 sirsi sirsi 512 Jun 09 1997 .
drwx------- 3 sirsi sirsi 512 Mar 06 1996 ..
-rw-------- 1 sirsi sirsi 5695488 Apr 04 14:30 marc0.dat
-rw-------- 1 sirsi sirsi 1270765247 Apr 04 14:30 marc0.fil
-rw-------- 1 sirsi sirsi 41008128 Apr 04 14:30 marc0.idx
These are the ved records. marc0.fil is the file of actual MARC
records - over 1 GB
/load4/sirsi/Unicorn/Database
total 4295848
drwx------- 9 sirsi sirsi 4608 Apr 21 2001 .
drwx------- 3 sirsi sirsi 512 Jun 06 2001 ..
drwx------- 2 sirsi sirsi 36352 Apr 04 14:25 Authedit
drwx------- 2 sirsi sirsi 512 Apr 04 07:53 Authwork
drwx------- 2 sirsi sirsi 126464 Apr 04 14:32 Browse
drwx------- 2 sirsi sirsi 795648 Apr 04 14:32 Edit
drwx------- 4 sirsi sirsi 512 Apr 04 14:33 Immediate
drwx------- 2 sirsi sirsi 512 Jan 24 1996 Mail
drwx------- 2 sirsi sirsi 1024 Apr 04 03:52 Work
These are the data files and browse
indexes for staff functions:
-rw-------- 1 sirsi sirsi 32768 Apr 04 11:11 address.dat
-rw-------- 1 sirsi sirsi 963288 Apr 04 11:11 address.fil
-rw-------- 1 sirsi sirsi 113664 Apr 04 11:11 address.idx
-rw-------- 1 sirsi sirsi 156372992 Apr 04 14:25 authindex.dat
-rw-------- 1 sirsi sirsi 145538048 Apr 04 14:25 authindex.idx
-rw-------- 1 sirsi sirsi 187462656 Apr 04 14:25 authority.dat
-rw-------- 1 sirsi sirsi 40057856 Apr 04 14:25 authority.idx
-rw-------- 1 sirsi sirsi 12789760 Apr 04 14:25 authorved.dat
-rw-------- 1 sirsi sirsi 385547986 Apr 04 14:25 authorved.fil
-rw-------- 1 sirsi sirsi 50695168 Apr 04 14:25 authorved.idx
-rw-------- 1 sirsi sirsi 2048 Apr 04 13:29 authxinfo.dat
-rw-------- 1 sirsi sirsi 20969846 Apr 04 14:25 authxinfo.fil
-rw-------- 1 sirsi sirsi 10240 Apr 04 13:29 authxinfo.idx
-rw-------- 1 sirsi sirsi 34510848 Apr 04 14:30 bills.dat
-rw-------- 1 sirsi sirsi 11139072 Apr 04 14:30 bills.idx
-rw-------- 1 sirsi sirsi 0 Nov 25 1998 booking_98.dat
-rw-------- 1 sirsi sirsi 8192 Aug 17 2000 booking_98.idx
-rw-------- 1 sirsi sirsi 0 Aug 17 2000 bookings.dat
-rw-------- 1 sirsi sirsi 8192 Aug 17 2000 bookings.idx
-rw-------- 1 sirsi sirsi 448512 Oct 31 16:12 bound.dat
-rw-------- 1 sirsi sirsi 293888 Oct 31 16:12 bound.idx
-rw-------- 1 sirsi sirsi 0 Nov 25 1998 calendars.dat
-rw-------- 1 sirsi sirsi 3072 Nov 25 1998 calendars.idx
-rw-------- 1 sirsi sirsi 525312 Mar 28 11:39 cancel.dat
-rw-------- 1 sirsi sirsi 172032 Mar 28 11:39 cancel.idx
-rw-------- 1 sirsi sirsi 0 Jan 24 1996 catacnt.dat
-rw-------- 1 sirsi sirsi 3072 Jan 24 1996 catacnt.idx
-rw-------- 1 sirsi sirsi 164280320 Apr 04 14:34 catalog.dat
-rw-------- 1 sirsi sirsi 35296256 Apr 04 14:34 catalog.idx
The .dat file is the fixed record catalog (not MARC)
-rw-------- 1 sirsi sirsi 5765120 Apr 04 14:33 charges.dat
-rw-------- 1 sirsi sirsi 4743168 Apr 04 14:33 charges.idx
-rw-------- 1 sirsi sirsi 67555328 Aug 16 2000 checkin_98.dat
-rw-------- 1 sirsi sirsi 14453760 Aug 16 2000 checkin_98.idx
-rw-------- 1 sirsi sirsi 924672 Apr 02 12:14 claims.dat
-rw-------- 1 sirsi sirsi 288768 Apr 02 12:14 claims.idx
-rw-------- 1 sirsi sirsi 2246656 Apr 04 11:54 comments.dat
-rw-------- 1 sirsi sirsi 69387150 Apr 04 11:54 comments.fil
-rw-------- 1 sirsi sirsi 8495104 Apr 04 11:54 comments.idx
-rw-------- 1 sirsi sirsi 2246656 Aug 17 2000 comments_98.dat
-rw-------- 1 sirsi sirsi 69387150 Aug 17 2000 comments_98.fil
-rw-------- 1 sirsi sirsi 8495104 Aug 17 2000 comments_98.idx
-rw-------- 1 sirsi sirsi 0 Nov 15 1996 content.dat
-rw-------- 1 sirsi sirsi 10240 Nov 15 1996 content.idx
-rw-------- 1 sirsi sirsi 0 May 01 1997 courses.dat
-rw-------- 1 sirsi sirsi 5120 May 01 1997 courses.idx
-rw-------- 1 sirsi sirsi 0 May 01 1997 coursexinf.dat
-rw-------- 1 sirsi sirsi 1 May 01 1997 coursexinf.fil
-rw-------- 1 sirsi sirsi 4096 May 01 1997 coursexinf.idx
-rw-------- 1 sirsi sirsi 3405 Dec 22 1998 cvt.log
-rw-------- 1 sirsi sirsi 60411 Dec 22 1998 cvt.out
-rwx------- 1 sirsi sirsi 258508 Dec 22 1998 cvtserctl_9
-rw-------- 1 sirsi sirsi 19003392 Apr 04 12:06 distributi.dat
-rw-------- 1 sirsi sirsi 14587904 Apr 04 12:06 distributi.idx
-rw-------- 1 sirsi sirsi 372736 Apr 04 13:29 extendedin.dat
-rw-------- 1 sirsi sirsi 20571702 Apr 04 13:29 extendedin.fil
-rw-------- 1 sirsi sirsi 1268736 Apr 04 13:29 extendedin.idx
-rw-------- 1 sirsi sirsi 386048 Apr 04 12:06 fundcyc.dat
-rw-------- 1 sirsi sirsi 75776 Apr 04 12:06 fundcyc.idx
-rw-------- 1 sirsi sirsi 19025920 Apr 04 12:06 fundings.dat
-rw-------- 1 sirsi sirsi 6606848 Apr 04 12:06 fundings.idx
-rw-------- 1 sirsi sirsi 222208 Apr 02 21:22 funds.dat
-rw-------- 1 sirsi sirsi 69632 Apr 02 21:22 funds.idx
-rw-------- 1 sirsi sirsi 0 Feb 24 2000 holditems.dat
-rw-------- 1 sirsi sirsi 3072 Feb 24 2000 holditems.idx
-rw-------- 1 sirsi sirsi 285696 Apr 04 14:26 holds.dat
-rw-------- 1 sirsi sirsi 726016 Apr 04 14:26 holds.idx
-rw-------- 1 sirsi sirsi 145408 Nov 25 1998 holds_81.dat
-rw-------- 1 sirsi sirsi 613376 Nov 25 1998 holds_81.idx
-rw-------- 1 sirsi sirsi 14027776 Apr 04 13:29 invlines.dat
-rw-------- 1 sirsi sirsi 6596608 Apr 04 13:29 invlines.idx
-rw-------- 1 sirsi sirsi 6754304 Apr 02 15:46 invlinks.dat
-rw-------- 1 sirsi sirsi 4613120 Apr 02 15:46 invlinks.idx
-rw-------- 1 sirsi sirsi 2655232 Apr 04 13:29 invoices.dat
-rw-------- 1 sirsi sirsi 1676288 Apr 04 13:29 invoices.idx
-rw-------- 1 sirsi sirsi 0 Jan 24 1996 itemacnt.dat
-rw-------- 1 sirsi sirsi 4096 Jan 24 1996 itemacnt.idx
-rw-------- 1 sirsi sirsi 10240 Nov 15 1996 link.dat
-rw-------- 1 sirsi sirsi 5120 Nov 15 1996 link.idx
-rw-------- 1 sirsi sirsi 7897 Apr 11 1997 load4file
-rw-------- 1 sirsi sirsi 0 Aug 17 2000 locks.dat
-rw-------- 1 sirsi sirsi 3072 Aug 17 2000 locks.idx
-rw-------- 1 sirsi sirsi 0 Apr 12 1996 mailindex.dat
-rw-------- 1 sirsi sirsi 4096 Apr 12 1996 mailindex.idx
-rw-------- 1 sirsi sirsi 7900160 Dec 22 1998 o_serctl.dat
-rw-------- 1 sirsi sirsi 2271232 Dec 22 1998 o_serctl.idx
-rw-------- 1 sirsi sirsi 0 Nov 25 1998 orchhist.dat
-rw-------- 1 sirsi sirsi 7168 Nov 25 1998 orchhist.idx
-rw-------- 1 sirsi sirsi 0 Nov 25 1998 orchint.dat
-rw-------- 1 sirsi sirsi 5120 Nov 25 1998 orchint.idx
-rw-------- 1 sirsi sirsi 0 Nov 25 1998 orchuser.dat
-rw-------- 1 sirsi sirsi 4096 Nov 25 1998 orchuser.idx
-rw-------- 1 sirsi sirsi 49486848 Apr 04 14:32 orderlines.dat
-rw-------- 1 sirsi sirsi 18653184 Apr 04 14:32 orderlines.idx
-rw-------- 1 sirsi sirsi 25084928 Apr 04 12:06 orders.dat
-rw-------- 1 sirsi sirsi 12951552 Apr 04 12:06 orders.idx
-rw-------- 1 sirsi sirsi 83911680 Apr 04 14:34 prediction.dat
-rw-------- 1 sirsi sirsi 44239872 Apr 04 14:34 prediction.idx
-rw-------- 1 sirsi sirsi 0 Nov 15 1996 query.dat
-rw-------- 1 sirsi sirsi 5120 Nov 15 1996 query.idx
-rw-------- 1 sirsi sirsi 33884160 Apr 04 14:34 receipt.dat
-rw-------- 1 sirsi sirsi 9462784 Apr 04 14:34 receipt.idx
-rw-------- 1 sirsi sirsi 3072 Mar 20 14:51 requests.dat
-rw-------- 1 sirsi sirsi 8192 Mar 20 14:51 requests.idx
-rw-------- 1 sirsi sirsi 1024 Mar 20 14:51 requestved.dat
-rw-------- 1 sirsi sirsi 1107 Mar 20 14:51 requestved.fil
-rw-------- 1 sirsi sirsi 5120 Mar 20 14:51 requestved.idx
-rw-------- 1 sirsi sirsi 0 May 01 1997 resctl.dat
-rw-------- 1 sirsi sirsi 4096 May 01 1997 resctl.idx
-rw-------- 1 sirsi sirsi 0 Apr 12 1996 resctl71.dat
-rw-------- 1 sirsi sirsi 3072 Apr 12 1996 resctl71.idx
-rw-------- 1 sirsi sirsi 0 May 01 1997 resctlcopy.dat
-rw-------- 1 sirsi sirsi 1 May 01 1997 resctlcopy.fil
-rw-------- 1 sirsi sirsi 4096 May 01 1997 resctlcopy.idx
-rw-------- 1 sirsi sirsi 0 May 01 1997 resctlxinf.dat
-rw-------- 1 sirsi sirsi 1 May 01 1997 resctlxinf.fil
-rw-------- 1 sirsi sirsi 4096 May 01 1997 resctlxinf.idx
-rw-------- 1 sirsi sirsi 0 May 01 1997 reserves.dat
-rw-------- 1 sirsi sirsi 5120 May 01 1997 reserves.idx
-rw-------- 1 sirsi sirsi 0 Apr 12 1996 reserves71.dat
-rw-------- 1 sirsi sirsi 5120 Apr 12 1996 reserves71.idx
-rw-------- 1 sirsi sirsi 0 Apr 12 1996 restrctved.dat
-rw-------- 1 sirsi sirsi 1 Apr 12 1996 restrctved.fil
-rw-------- 1 sirsi sirsi 4096 Apr 12 1996 restrctved.idx
-rw-------- 1 sirsi sirsi 0 Apr 12 1996 restrict.dat
-rw-------- 1 sirsi sirsi 3072 Apr 12 1996 restrict.idx
-rw-------- 1 sirsi sirsi 0 Apr 12 1996 review.dat
-rw-------- 1 sirsi sirsi 5120 Apr 12 1996 review.idx
-rw-------- 1 sirsi sirsi 0 Apr 12 1996 revise.dat
-rw-------- 1 sirsi sirsi 3072 Apr 12 1996 revise.idx
-rw-------- 1 sirsi sirsi 0 Apr 12 1996 reviseved.dat
-rw-------- 1 sirsi sirsi 1 Apr 12 1996 reviseved.fil
-rw-------- 1 sirsi sirsi 4096 Apr 12 1996 reviseved.idx
-rw-------- 1 sirsi sirsi 1024 Jan 17 11:43 routing.dat
-rw-------- 1 sirsi sirsi 6144 Jan 17 11:43 routing.idx
-rw-------- 1 sirsi sirsi 0 May 01 1997 rsrvbrws.dat
-rw-------- 1 sirsi sirsi 5120 May 01 1997 rsrvbrws.idx
-rw-------- 1 sirsi sirsi 63488 Apr 04 12:06 segments.dat
-rw-------- 1 sirsi sirsi 7929486 Apr 04 12:06 segments.fil
-rw-------- 1 sirsi sirsi 210944 Apr 04 12:06 segments.idx
-rw-------- 1 sirsi sirsi 4727808 Apr 04 14:29 serclaim.dat
-rw-------- 1 sirsi sirsi 503808 Apr 04 14:29 serclaim.idx
-rw-------- 1 sirsi sirsi 27975680 Apr 04 14:34 serctl.dat
-rw-------- 1 sirsi sirsi 2790400 Apr 04 14:34 serctl.idx
-rw-------- 1 sirsi sirsi 72129 Dec 22 1998 serctl.keys
-rw-------- 1 sirsi sirsi 8867840 Aug 16 2000 serctl_98.dat
-rw-------- 1 sirsi sirsi 2964480 Aug 17 2000 serctl_98.idx
-rw-------- 1 sirsi sirsi 41984 Apr 04 13:16 serctlxinf.dat
-rw-------- 1 sirsi sirsi 1983508 Apr 04 14:29 serctlxinf.fil
-rw-------- 1 sirsi sirsi 150528 Apr 04 13:16 serctlxinf.idx
-rw-------- 1 sirsi sirsi 2720768 Apr 04 14:34 serdist.dat
-rw-------- 1 sirsi sirsi 2608128 Apr 04 14:34 serdist.idx
-rw-------- 1 sirsi sirsi 0 Nov 15 1996 set.dat
-rw-------- 1 sirsi sirsi 5120 Nov 15 1996 set.idx
-rw-------- 1 sirsi sirsi 0 Nov 15 1996 setved.dat
-rw-------- 1 sirsi sirsi 1 Nov 15 1996 setved.fil
-rw-------- 1 sirsi sirsi 4096 Nov 15 1996 setved.idx
-rwx------- 1 sirsi sirsi 2858 Dec 22 1998 ucap.cvtserctl
-rw-------- 1 sirsi sirsi 0 Jan 24 1996 useracnt.dat
-rw-------- 1 sirsi sirsi 3072 Jan 24 1996 useracnt.idx
-rw-------- 1 sirsi sirsi 0 Aug 17 2000 userpasswd.dat
-rw-------- 1 sirsi sirsi 3072 Aug 17 2000 userpasswd.idx
-rw-------- 1 sirsi sirsi 26520576 Apr 04 14:33 users.dat
-rw-------- 1 sirsi sirsi 15137792 Apr 04 14:33 users.idx
-rw-------- 1 sirsi sirsi 765952 Apr 04 14:33 userxinfo.dat
-rw-------- 1 sirsi sirsi 40125947 Apr 04 14:33 userxinfo.fil
-rw-------- 1 sirsi sirsi 5977088 Apr 04 14:33 userxinfo.idx
-rw-------- 1 sirsi sirsi 92946432 Apr 30 1997 v71_auth.dat
-rw-------- 1 sirsi sirsi 34262016 May 01 1997 v71_auth.idx
-rw-------- 1 sirsi sirsi 3175424 Apr 04 14:24 vendorcyc.dat
-rw-------- 1 sirsi sirsi 278528 Apr 04 14:24 vendorcyc.idx
-rw-------- 1 sirsi sirsi 1220608 Apr 04 14:24 vendors.dat
-rw-------- 1 sirsi sirsi 452608 Apr 04 14:24 vendors.idx
-rw-------- 1 sirsi sirsi 381952 Apr 30 1997 vendors_71.dat
-rw-------- 1 sirsi sirsi 144384 May 01 1997 vendors_71.idx
/t/sirsi/Unicorn/Database
total 3817872
drwx------- 2 sirsi sirsi 512 Apr 19 2001 .
drwx------- 4 sirsi sirsi 512 Apr 14 1997 ..
Browse indexes:
-rw-------- 1 sirsi sirsi 127982592 Apr 03 19:58 heading1.dat
-rw-------- 1 sirsi sirsi 34406400 Apr 03 19:58 heading1.idx
Author index
-rw-------- 1 sirsi sirsi 286328832 Apr 03 19:56 heading2.dat
-rw-------- 1 sirsi sirsi 144413696 Apr 03 19:56 heading2.idx
Title index
-rw-------- 1 sirsi sirsi 237670400 Apr 03 19:58 heading3.dat
-rw-------- 1 sirsi sirsi 74394624 Apr 03 19:58 heading3.idx
Subject index
-rw-------- 1 sirsi sirsi 85380096 Apr 03 19:53 heading4.dat
-rw-------- 1 sirsi sirsi 17126400 Apr 03 19:53 heading4.idx
Series index
-rw-------- 1 sirsi sirsi 17377280 Apr 03 18:39 heading5.dat
-rw-------- 1 sirsi sirsi 6355968 Apr 03 18:39 heading5.idx
Periodical title index
-rw-------- 1 sirsi sirsi 9791488 Apr 03 18:38 heading6.dat
-rw-------- 1 sirsi sirsi 2582528 Apr 03 18:38 heading6.idx
MESH index
-rw-------- 1 sirsi sirsi 174080 Apr 03 18:35 heading7.dat
-rw-------- 1 sirsi sirsi 77824 Apr 03 18:35 heading7.idx
090 for Reserve course index
-rw-------- 1 sirsi sirsi 489313280 Apr 03 19:58 heading8.dat
-rw-------- 1 sirsi sirsi 198857728 Apr 03 19:58 heading8.idx
General consolidated browse index
-rw-------- 1 sirsi sirsi 445440 Apr 03 19:58 headingved.dat
-rw-------- 1 sirsi sirsi 219628040 Apr 03 19:58 headingved.fil
-rw-------- 1 sirsi sirsi 1498112 Apr 03 19:58 headingved.idx
/v/sirsi/Unicorn/Searchdb/KUNI
total 1678608
drwx------- 2 sirsi sirsi 512 Apr 03 05:16 .
drwx------- 3 sirsi sirsi 512 Jul 19 1996 ..
-rw-rw----- 1 sirsi sirsi 859419366 Apr 04 03:52 inv0.db
inv0.db and inv1.db are the inverted word position keyword indexes
over 1 GB in total
/w/sirsi/Unicorn/Searchdb/KUNI
total 158480
drwx------- 2 sirsi sirsi 512 Apr 03 05:16 .
drwx------- 3 sirsi sirsi 512 Oct 03 1996 ..
-rw-rw----- 1 sirsi sirsi 81069618 Apr 04 03:52 inv1.db
/x/sirsi/Unicorn/Searchdb/KUNI
total 16
drwx------- 2 sirsi sirsi 512 Apr 03 05:16 .
drwx------- 4 sirsi sirsi 512 Feb 09 1996 ..
-rw-rw----- 1 sirsi sirsi 0 Apr 03 03:45 inv2.db
/y/sirsi/Unicorn/Searchdb/KUNI
total 1660176
drwx------- 2 sirsi sirsi 512 Apr 21 2001 .
drwx------- 4 sirsi sirsi 512 Feb 09 1996 ..
-rw-rw----- 1 sirsi sirsi 850000031 Apr 22 2001 txt0.db
/z/sirsi/Unicorn/Searchdb/KUNI
total 2081040
drwx------- 2 sirsi sirsi 512 Apr 04 03:52 .
drwx------- 5 sirsi sirsi 512 Sep 25 1996 ..
-rw-rw----- 1 sirsi sirsi 1065435094 Apr 04 03:51 txt1.db
txt0.db and txt1.db are the actual BRS records - almost 2 GB
This page last updated by Linda Pearce, April 8, 2002