Abstract
In information retrieval systems storage occupancy is in general disregarded to take advantage in running time; in an environment in which retrieval time is not a primary requirement (this is the case of Data Base Machines), transposed files become a very interesting structure; in fact they allow a considerable space saving with respect to fast access structures, such as inverted files. But transposed files, in most cases, are not practicable, as theyare to be searched by a sequential scanning.
In this paper a structure is defined to implement transposed files, called 2-B tree, which is a sort of two-dimensionalB-tree, and avoid sequential scanning; search in a trasposed file stored as a 2-B tree in π memory pages is 0 (π1/2), while insertion and deletion are 0 (logπ). Moreover, 2-B tree organization can achieve an improvement in storage requirements up to 42% with respect to inverted file organization.
Similar content being viewed by others
Bibliografia
J. M. Babad,A record and file partitioning model, Comm. ACM (1)20, (1977), 22–31.
D. S. Batory,On searching transposed files, ACM Trans. Database Syst. (4),4 (1979), 531–544.
R, Bayer—E. Mc Creight,Organization and maintenance of large ordered indexes, Acta Informatica, (2),3 (1972), 1733–189.
J. L. Bentley,Multidimensional binary search trees used for associative searching, Comm. ACM (9),18, (1975), 509–517.
M. W. Blasgen—K. P. Eswaren,Storage and access in relational databases, IBM Syst. J. (4)16, (1977), 363–377.
M. J. Eisner—D. G. Severance,Mathematical tecniques for efficient record segmentation in large shared databases, J. ACM (4)23, (1976), 619–635.
R. A. Finkel—J. L. Bentley,Quad trees: a data structure for retrieval on composite key, Acta Inform. (1)4, (1974), 1–9.
A. Gambacorta,Organizzazione di files nell'ambiente dei disk-controllers, Tesi di Laurea, Università di Pisa, (1981).
D. K. Hsiao,Database computers, Advances in Computers,19 Academic Press (1980).
D. E. Knuth,The art of computer programming,3:Searching and sorting, Adson Wesley, Reading Ma (1973).
S. T., March—D. G. Severance,The determination of efficient record segmentation and blocking factors for shared data files, ACM Trans. Database Syst.2,3 (1977), 279–296.
G. Wiederhold,Database design, McGraw-Hill, New York, 1977.
A. C. Yao,On random 2–3 trees, Acta Inform. 9 (1978), 159–170.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Gambacorta, A., Leoni, G. Una struttura bidimensionale per la memorizzazione dei file trasposti. Calcolo 19, 397–414 (1982). https://doi.org/10.1007/BF02575768
Received:
Issue Date:
DOI: https://doi.org/10.1007/BF02575768