If possible, determine the buffer-management strategy used by the operating system running on your local computer system, and what mechanisms it provides to control replacement of pages. Discuss how the control on replacement that it provides would be useful for the implementation of database systems.
Answer to relevant QuestionsIn the sequential file organization, why is an overflow block used even if there is, at the moment, only one overflow record?Explain why a physical OID must contain more information than a pointer to a physical storage location.Is it possible in general to have two primary indices on the same relation for different search keys? Explain your answer. Suppose that we are using extendable hashing on a file that contains records with the following search-key values: 2, 3, 5, 7, 11, 17, 19, 23, 29, 31 Show the extendable hash structure for this file if the hash function is ...Why is it not desirable to force users to make an explicit choice of a queryprocessing strategy? Are there cases in which it is desirable for users to be aware of the costs of competing query-processing strategies? Explain ...
Post your question