Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the difference between data entries and data records?

Tags:

database

I was looking through my lecture notes, and came across this slide. I am confused what a data entry vs a data record. I know the data record is the entire tuple, but I am unsure about the data entry.

enter image description here

like image 616
Sam Avatar asked Nov 26 '15 05:11

Sam


1 Answers

Data records is a complete row of your database stored somewhere in the filesystem.

Data entries only stores the columns that you specified in the index. Data entries usually keep a pointer to the data record in the filesystem where the record resides

like image 106
Faiz Halde Avatar answered Nov 15 '22 18:11

Faiz Halde