Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why is a database table called a table?

Tags:

database

I've pondered the question and the most reasonable metaphor I've located is:

a table is a surface on which items are placed

This seems a little broad, but maybe that was all of the thought put into the naming of the concept. I've also searched Google and Wikipedia a bit and have not found a record of the inception of the term.

like image 761
Patrick Klingemann Avatar asked May 21 '12 17:05

Patrick Klingemann


People also ask

Why are data tables called tables?

Graphic meaning the relation to furniture (table: "you can see the subjects on the table"). Or in a spreadsheet's case: a lot of numbers and text spreaded in the sheet(s) of paper.

What does the term table mean in a database?

Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.

What is called table?

A table is an arrangement of information or data, typically in rows and columns, or possibly in a more complex structure. Tables are widely used in communication, research, and data analysis.

Where did the word table come from?

Middle EnglishFrom a combination of Old French table and Old English tabele, tabul, tablu, tabule, tabula, both from Latin tabula.


2 Answers

Table is a word with more than one meaning. In this case, a table is a sort of chart, with information arranged in rows.

Wikipedia says:

"Historical relationship to furniture

In medieval counting houses, the tables were covered with a piece of checkered cloth, to count money. Exchequer is an archaic term for the English institution which accounted for money owed to the monarch. Thus the checkerboard tables of stacks of coins are a concrete realization of this information."

like image 167
Neil Forrester Avatar answered Oct 20 '22 08:10

Neil Forrester


Here's a quote from etymology online: "The meaning "arrangement of numbers or other figures for convenience" is recorded from late 14c. (e.g. table of contents, mid-15c.)."

This isn't very helpful but... People tend to name things and phenomena. Why? So we can differentiate one thing from another. (This is just a quick generalization.)

Table (and spreadsheet) are great graphic terms to imply a collection of items/stuff in sight. Graphic meaning the relation to furniture (table: "you can see the subjects on the table"). Or in a spreadsheet's case: a lot of numbers and text spreaded in the sheet(s) of paper.

These are just a couple of point of views from a non-native English speaker. Cheap answer to the original why question would be: because someone named it as a table and others agreed. It's a good term IMHO...

like image 32
ZZ-bb Avatar answered Oct 20 '22 06:10

ZZ-bb