Describe an efficient way to search for and retrieve


Suppose that several secondary indexes exist on non-key fields of a file, implemented using option 3 of Section 18.1.3; for example, we could have secondary indexes on the fields Department_code, Job_code, and Salary of the EMPLOYEE file of Exercise 18.18. Describe an efficient way to search for and retrieve records satisfying a complex selection condition on these fields, such as (Department_code = 5 AND Job_code = 12 AND Salary = 50,000), using the record pointers in the indirection level.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Describe an efficient way to search for and retrieve
Reference No:- TGS01399715

Expected delivery within 24 Hours