Sample Header Ad - 728x90

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