Business Intelligence Dictionary: Table Field and Table Tuple | NSBI
We are now diving into the Database building blocks - fields and tuples.
Table Field | Definition
A table field represents a characteristic of the subject to which it belongs to. Commonly table fields are simply referred to as "columns". The relational database theory also assigns some special kinds of fields such as indexes, keys (primary keys, foreign keys, surrogate keys), dimensions and facts, etc.
Table Field | Example
Let's consider the following database example. We are inputting employee information into an operational database. We create a table "Employee" - this is the subject of the table. Each employee has a "Name" - this is a table field that is normally visualized as a separate column in a database table.
Table Tuple | Definition
NSBI Dictionary defines a table tuple as an ordered set of field values that represent a single unique instance of the subject. Commonly table tuples are simply referred to as "rows".
Table Tuple | Example
Let's continue the table field example. Each employee not only has a "Name" but also a "Position" in the organization. The set of "Name" and "Position" is now forming a table tuple that is simply a row inside a table.
NSBI Tutorials aim to make Business Intelligence (BI) and Data Warehousing (DWH) attractive to non-technical people as well as to those who are now entering the field and are excited by the numerous ways data is changing our world. NSBI Tutorials are written and delivered by Nick Shopov, (BI Software Developer & DWH Consultant).