Primary File Organization in DBMS - Files of ordered records (sorted files)
0
votes
1
answer
118
views
"Fundamental of Database Systems", 3rd ed. by Elmasri and Navathe, page 136 says:
"We can physically order the records of a file on disk based on the values of one of their fields [...]"
How could this "physical ordering" possibly enforced, especially with regard to fragmentation? Most databases use system calls to store their data in the file system of the OS, only very few are capable of doing raw i/o.
Asked by keezar
(33 rep)
Mar 3, 2022, 09:31 PM
Last activity: Mar 3, 2022, 10:28 PM
Last activity: Mar 3, 2022, 10:28 PM