Expressions for batched searching of sequential and hierarchical files
- 1 March 1985
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 10 (1) , 97-106
- https://doi.org/10.1145/3148.3326
Abstract
Batching yields significant savings in access costs in sequential, tree structured, and random files. A direct and simple expression is developed for computing the average number of records/pages accessed to satisfy a batched query of a sequential tile. The advantages of batching for sequential and random files are discussed. A direct equation is provided for the number of nodes accessed in unhatched queries of hierarchical files. An exact recursive expression is developed for node accesses in batched queries of hierarchical files. In addition to the recursive relationship, good, closed-form upper- and lower-bound approximations are provided for the case of batched queries of hierarchical files.Keywords
This publication has 10 references indexed in Scilit:
- Approximating block accesses in database organizationsInformation Processing Letters, 1984
- A MATHEMATICAL PROGRAMMING APPROACH TO THE SELECTION OF ACCESS PATHS FOR LARGE MULTIUSER DATA BASESDecision Sciences, 1983
- A unifying model of physical databasesACM Transactions on Database Systems, 1982
- Estimating block accesses and number of records in file managementCommunications of the ACM, 1982
- A Practical Approach to Selecting Record Access PathsACM Computing Surveys, 1977
- Approximating block accesses in database organizationsCommunications of the ACM, 1977
- An attribute based model for database access cost analysisACM Transactions on Database Systems, 1977
- Batched searching of sequential and tree structured filesACM Transactions on Database Systems, 1976
- Analysis and performance of inverted data base structuresCommunications of the ACM, 1975
- A formal system for information retrieval from filesCommunications of the ACM, 1970