1 .\" Copyright (c) 1990, 1993
2 .\" The Regents of the University of California. All rights reserved.
4 .\" Redistribution and use in source and binary forms, with or without
5 .\" modification, are permitted provided that the following conditions
7 .\" 1. Redistributions of source code must retain the above copyright
8 .\" notice, this list of conditions and the following disclaimer.
9 .\" 2. Redistributions in binary form must reproduce the above copyright
10 .\" notice, this list of conditions and the following disclaimer in the
11 .\" documentation and/or other materials provided with the distribution.
12 .\" 3. All advertising materials mentioning features or use of this software
13 .\" must display the following acknowledgement:
14 .\" This product includes software developed by the University of
15 .\" California, Berkeley and its contributors.
16 .\" 4. Neither the name of the University nor the names of its contributors
17 .\" may be used to endorse or promote products derived from this software
18 .\" without specific prior written permission.
20 .\" THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
21 .\" ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
22 .\" IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
23 .\" ARE DISCLAIMED. IN NO EVENT SHALL THE REGENTS OR CONTRIBUTORS BE LIABLE
24 .\" FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
25 .\" DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
26 .\" OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
27 .\" HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
28 .\" LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
29 .\" OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
32 .\" @(#)recno.3 8.5 (Berkeley) 8/18/94
34 .\" Japanese Version Copyright (c) 1999 Shouichi Saito
35 .\" all rights reserved.
36 .\" Translated Mon Jul 26 12:18:39 JST 1999
37 .\" by Shouichi Saito <ss236rx@ymg.urban.ne.jp>
38 .\" Proofed Tue Aug 19 1999 by NAKANO Takeo <nakano@apm.seikei.ac.jp>
40 .\"WORD: access method ¥¢¥¯¥»¥¹¥á¥½¥Ã¥É
41 .\"WORD: pad character Ëä¤áʸ»ú
42 .TH RECNO 3 1994-08-18 "" "Linux Programmer's Manual"
45 recno \- ¥ì¥³¡¼¥ÉÈÖ¹æ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ø¤Î¥¢¥¯¥»¥¹¥á¥½¥Ã¥É
49 #include <sys/types.h>
56 ¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¥Õ¥¡¥¤¥ë¤ËÂФ¹¤ë¥é¥¤¥Ö¥é¥ê¥¤¥ó¥¿¡¼¥Õ¥§¡¼¥¹¤Ç¤¢¤ë¡£
57 ¥µ¥Ý¡¼¥È¤µ¤ì¤Æ¤¤¤ë¥Õ¥¡¥¤¥ë¥Õ¥©¡¼¥Þ¥Ã¥È¤Î°ì¤Ä¤Ë¡¢
58 ¥ì¥³¡¼¥ÉÈÖ¹æ¥Õ¥¡¥¤¥ë (record number file: recno file) ¤¬¤¢¤ë¡£
59 ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ø¤Î¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¤Ë´Ø¤¹¤ë°ìÈÌŪ¤Êµ½Ò¤Ï
62 ¤³¤Î¥Þ¥Ë¥å¥¢¥ë¥Ú¡¼¥¸¤Ç¤Ï recno ÆÃͤξðÊó¤Ë¤Ä¤¤¤Æ¤Î¤ßµ½Ò¤¹¤ë¡£
64 ¥ì¥³¡¼¥ÉÈÖ¹æ¥Ç¡¼¥¿¹½Â¤¤Ï¡¢¥Õ¥é¥Ã¥È¤Ê¥Õ¥¡¥¤¥ë·Á¼°¤Ë³ÊǼ¤µ¤ì¤¿
65 ²ÄÊÑĹ/¸ÇÄêĹ¥ì¥³¡¼¥É¤«¤é¤Ê¤ê¡¢ÏÀÍý¥ì¥³¡¼¥ÉÈÖ¹æ¤Ç¥¢¥¯¥»¥¹¤µ¤ì¤ë¡£
66 ¥ì¥³¡¼¥ÉÈÖ¹æ 5 ¤¬¤¢¤ì¤Ð¡¢¥ì¥³¡¼¥ÉÈÖ¹æ 1 ¤«¤é 4 ¤â¸ºß¤¹¤ë¡£
67 ¥ì¥³¡¼¥ÉÈÖ¹æ 1 ¤òºï½ü¤¹¤ë¤È¡¢¥ì¥³¡¼¥ÉÈÖ¹æ 5 ¤Ï 4 ¤ËÉÕ¤±Âؤ¨¤é¤ì¡¢
68 ¥«¡¼¥½¥ë¤â°ÜÆ°¤¹¤ë¡£¥ì¥³¡¼¥ÉÈÖ¹æ 1 °Ê¹ß¤Î¤â¤Î¤Ï°ì¤Ä·«¤ê¾å¤¬¤ë¤ï¤±¤Ç¤¢¤ë¡£
71 ¤Ç»È¤¦ recno ¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¤ËÆÃͤΥǡ¼¥¿¹½Â¤ÂΤϡ¢
73 ¥¤¥ó¥¯¥ë¡¼¥É¥Õ¥¡¥¤¥ë¤Ç¼¡¤Î¤è¤¦¤ËÄêµÁ¤µ¤ì¤Æ¤¤¤ë¡£
79 unsigned int cachesize;
89 ¤³¤Î¹½Â¤ÂΤÎÍ×ÁǤò°Ê²¼¤Ë¼¨¤¹¡£
93 °Ê²¼¤ÎÃͤΤ¤¤º¤ì¤«¤«¡¢¤³¤ì¤é¤ÎÏÀÍýϤǻØÄꤵ¤ì¤ë¡£
97 ¥ì¥³¡¼¥ÉŤ¬¸ÇÄê¤Ç¤¢¤ê¡¢¥Ð¥¤¥È¶èÀÚ¤ê¤Ç¤Ï¤Ê¤¤¡£
100 ¤Ï¥ì¥³¡¼¥É¤ÎŤµ¤ò»ØÄꤹ¤ë¡£¤Þ¤¿¡¢Í×ÁÇ
102 ¤ÏËä¤áʸ»ú (pad character) ¤ò»ØÄꤹ¤ë¡£
103 ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÆþ¤ì¤é¤ì¤¿¥ì¥³¡¼¥É¤ÎÆâ
105 ¥Ð¥¤¥È¤ËËþ¤¿¤Ê¤¤¤â¤Î¤Ç¤Ï¡¢»Ä¤ê¤ÎÉôʬ¤ËËä¤áʸ»ú¤¬¼«Æ°Åª¤ËÆþ¤ë¡£
109 ¤Ç»ØÄꤵ¤ì¤¿¥¤¥ó¥¿¡¼¥Õ¥§¥¤¥¹¤Ç¤Ï¡¢¥·¡¼¥±¥ó¥·¥ã¥ë¤Ê¥ì¥³¡¼¥É¼èÆÀ¤Ï
110 ¸Æ¤Ó½Ð¤·¥¡¼¤È¥Ç¡¼¥¿¹½Â¤ÂΤÎξÊý¤òËä¤á¤Æ¤¤¤¯¡£
112 ¥Õ¥é¥°¤¬»ØÄꤵ¤ì¤Æ¤¤¤ë¤È¡¢¥¡¼¹½Â¤ÂΤòËä¤á¤ë¤Î¤Ë
114 ¥ë¡¼¥Á¥ó¤òɬÍפȤ·¤Ê¤¤¡£
115 ¤³¤ì¤òÍѤ¤¤ì¤Ð¡¢¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤¬¥Õ¥¡¥¤¥ë¤Î½ª¤ê¤ÎÊý¤ò¼èÆÀ¤¹¤ëºÝ¤Ë¡¢
116 ¤½¤ÎÅÓÃæ¤Î¥ì¥³¡¼¥É¤òÆɤޤʤ¯¤Æ¤âºÑ¤à»ö¤Ë¤Ê¤ë¡£
119 ¤³¤Î¥Õ¥é¥°¤ò»ØÄꤹ¤ë¤È¡¢
122 ¥ª¥ê¥¸¥Ê¥ë¥Õ¥¡¥¤¥ë¤«¤éÊѹ¹¤µ¤ì¤Æ¤¤¤Ê¤¤¥ì¥³¡¼¥É¤òÆɤàÂå¤ï¤ê¤Ë¡¢
123 ¥Õ¥¡¥¤¥ë¤Î snapshot ¤òÍѤ¤¤ë¡£
127 ÁÛÄꤵ¤ì¤ë¥á¥â¥ê¥¥ã¥Ã¥·¥å¤ÎºÇÂ祵¥¤¥º (¥Ð¥¤¥Èñ°Ì)¡£
130 »²¹Í¤Ç¤¢¤ê¡¢¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¤Ï¤³¤ÎÃͤò±Û¤¨¤¿¥á¥â¥ê¤Î
131 ³ä¤êÅö¤Æ¤ËÀ®¸ù¤¹¤ë¤³¤È¤â¤¢¤ë¡£
133 ¤¬ 0 (¤¢¤ë¤¤¤Ï»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤) ¤Î¾ì¹ç¡¢¥Ç¥Õ¥©¥ë¥È¤Î¥¥ã¥Ã¥·¥å¤¬»È¤ï¤ì¤ë¡£
136 recno ¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¤Ï¡¢¼«¿È¤Î¥ì¥³¡¼¥É¤Î¥³¥Ô¡¼¤ò¥á¥â¥êÆâÉô¤Ë
137 btree ¤ÇÊݸ¤·¤Æ¤¤¤ë¡£
138 ¤³¤ÎÃͤϡ¢¤½¤Î btree Ãæ¤Î¥Î¡¼¥É¤ËÂФ·¤ÆÍѤ¤¤é¤ì¤ë
139 ¥Ú¡¼¥¸¥µ¥¤¥º (¥Ð¥¤¥Èñ°Ì) ¤Ç¤¢¤ë¡£
141 ¤¬ 0 (¤¢¤ë¤¤¤Ï»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤) ¤Î¾ì¹ç¡¢
142 ¥Õ¥¡¥¤¥ë¥·¥¹¥Æ¥à¤Î I/O ¥Ö¥í¥Ã¥¯¥µ¥¤¥º¤ò´ð¤Ë¤·¤Æ
143 ¥Ú¡¼¥¸¥µ¥¤¥º¤¬·è¤á¤é¤ì¤ë¡£
149 ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë³ÊǼ¤µ¤ì¤Æ¤¤¤ë¥á¥¿¥Ç¡¼¥¿¤ÎÀ°¿ôÃͤΥХ¤¥È¥ª¡¼¥À¡¼¡£
150 ¤³¤Î¿ô»ú¤Ï¡¢½ç½ø¤òÀ°¿ô¤Çɽ¤·¤¿¤â¤Î¤Ç¤¢¤ë¡£
151 Î㤨¤Ð¥Ó¥Ã¥°¥¨¥ó¥Ç¥£¥¢¥ó¤Ê¤é¡¢¤³¤Î¿ôÃÍ¤Ï 4,321 ¤È¤Ê¤ë¡£
153 ¤¬ 0 (»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤) ¤Î¾ì¹ç¡¢¸½ºß¤Î¥Û¥¹¥È
154 ¤Ç»È¤ï¤ì¤Æ¤¤¤ë¥Ð¥¤¥È¥ª¡¼¥À¡¼¤¬»È¤ï¤ì¤ë¡£
157 ¸ÇÄê¥ì¥³¡¼¥ÉŤÎŤµ¡£
160 ²ÄÊѥ쥳¡¼¥ÉŤˤª¤¤¤Æ¡¢
161 ¥ì¥³¡¼¥É¤Î½ª¤ê¤ò¼¨¤¹¶èÀÚ¤ê¥Ð¥¤¥È (¶èÀÚ¤êʸ»ú) ¤Ç¤¢¤ë¡£
162 ¸ÇÄê¥ì¥³¡¼¥ÉŤǤÏËä¤áʸ»ú¤È¤·¤Æ»È¤ï¤ì¤ë¡£
163 Ãͤ¬»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤¤È¡¢
164 ²ÄÊѥ쥳¡¼¥ÉĹ¤Î¥ì¥³¡¼¥É¤Î½ª¤ê¤Ë¤Ï²þ¹Ô ("\en") ¤¬»È¤ï¤ì¤ë¡£
165 ¸ÇÄê¥ì¥³¡¼¥ÉĹ¤Î¥ì¥³¡¼¥É¤Ï¶õÇò (space) ¤ÇËä¤á¤é¤ì¤ë¡£
168 recno ¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¤Ï¡¢
169 ¼«¿È¤Î¥ì¥³¡¼¥É¤Î¥³¥Ô¡¼¤ò¥á¥â¥êÆâÉô¤Ç btree ¤ËÊݸ¤·¤Æ¤¤¤ë¡£
171 ¤¬ NULL ¤Ç¤Ê¤¤¾ì¹ç¡¢¤³¤ì¤Ï btree ¥Õ¥¡¥¤¥ë̾
174 ¤¹¤ë»þ¤Ë»ØÄꤹ¤ë¥Õ¥¡¥¤¥ë̾) ¤ò»ØÄꤹ¤ë¡£
177 ¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¤Ç»È¤ï¤ì¤ë¥¡¼/¥Ç¡¼¥¿ÂФΥǡ¼¥¿Éôʬ¤Ï¡¢
178 ¾¤Î¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¤ÈƱ¤¸¤Ç¤¢¤ë¡£
179 ¤·¤«¤·¥¡¼¤Ï°Û¤Ê¤Ã¤Æ¤¤¤ë¡£
184 ·¿¤Î¡¢¥á¥â¥ê°ÌÃ֤ؤΥݥ¤¥ó¥¿¤Ç¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¡£
188 ¥¤¥ó¥¯¥ë¡¼¥É¥Õ¥¡¥¤¥ë¤ÇÄêµÁ¤µ¤ì¤Æ¤¤¤ë¡£
189 ¤³¤Î·¿¤ÏÄ̾¤½¤Î¼ÂÁõ¤ÇÍøÍѲÄǽ¤ÊºÇÂç¤ÎÉä¹æ̵¤·À°¿ô¤Ç¤¢¤ë¡£
192 ¥Õ¥£¡¼¥ë¥É¤Ï¤½¤Î·¿¤Î¥µ¥¤¥º¤È¤Ê¤ë¡£
194 recno ¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¤Î¥Õ¥¡¥¤¥ë¤Ë´ØÏ¢¤Å¤±¤é¤ì¤ë
195 ¥á¥¿¥Ç¡¼¥¿¤Ï¸ºß¤Ç¤¤Ê¤¤¤«¤é¡¢
196 ¥Ç¥Õ¥©¥ë¥ÈÃÍ (¸ÇÄê¥ì¥³¡¼¥ÉĹ¤ä¥»¥Ñ¥ì¡¼¥¿Ê¸»ú¤Ê¤É)
197 ¤ËÂФ¹¤ëÊѹ¹¤Ï¥Õ¥¡¥¤¥ë¤ò³«¤¯Ëè¤ËÌÀ¼¨Åª¤Ë»ØÄꤷ¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¡£
200 ¤Ç»ØÄꤵ¤ì¤¿¥¤¥ó¥¿¡¼¥Õ¥§¥¤¥¹¤Ç¤Ï¡¢
202 ¥¤¥ó¥¿¡¼¥Õ¥§¥¤¥¹¤ò»È¤Ã¤Æ¿·¤·¤¤¥ì¥³¡¼¥É¤òºîÀ®¤¹¤ë¤È¤¤Ë¡¢
203 »ØÄꤷ¤¿¥ì¥³¡¼¥ÉÈֹ椬¥Ç¡¼¥¿¥Ù¡¼¥¹Ãæ¤Ë¸ºß¤·¤Æ¤¤¤ëºÇÂç¥ì¥³¡¼¥ÉÈÖ¹æ¤è¤ê
205 ¶õ¤Î¥ì¥³¡¼¥É¤¬Æ±»þ¤Ë¤Ç¤¤Æ¤·¤Þ¤¦¡£
208 ¥¢¥¯¥»¥¹¥á¥½¥Ã¥É¥ë¡¼¥Á¥ó¤Ï¼ºÇÔ¤¹¤ë¤È
210 ¤Ç»ØÄꤵ¤ì¤Æ¤¤¤ë¥¨¥é¡¼¤Ë±þ¤¸¤¿
217 ¸ÇÄêĹ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¥ì¥³¡¼¥É¤òÄɲ乤ë¤È¤¡¢¥Ç¡¼¥¿¤¬Ä¹¤¹¤®¤¿¡£
219 ¥Ð¥¤¥È¥ª¡¼¥À¡¼¤È¤·¤Æ¤Ï¥Ó¥Ã¥°¥¨¥ó¥Ç¥£¥¢¥ó¤È¥ê¥È¥ë¥¨¥ó¥Ç¥£¥¢¥ó¤Î¤ß¤¬
227 .IR "Document Processing in a Relational Database System" ,
228 Michael Stonebraker, Heidi Stettner, Joseph Kalash, Antonin Guttman,
229 Nadene Lynn, Memorandum No. UCB/ERL M82/32, May 1982.