MBN News | The Independent Business Blogging Community

MBN News: Business Intelligence | Databases | BigData

MBN International: English Flag Bulgarian Flag

29 Members | ~1,500 Unique Visitors with ~3,500 Visits Last Month | Last Update: 20 Nov 2018 | Google PageRank 5 (PR5)

MBN Most Popular

MBN Latest

Now Blogging » Business Intelligence (BI)

Business Intelligence Dictionary: Table Field and Table Tuple | NSBI

|
<a href='http://morningbiznews.com/en/search/table'>table</a>, <a href='http://morningbiznews.com/en/search/field'>field</a>, <a href='http://morningbiznews.com/en/search/column'>column</a>, <a href='http://morningbiznews.com/en/search/tuple'>tuple</a>, <a href='http://morningbiznews.com/en/search/row'>row</a>, <a href='http://morningbiznews.com/en/search/nsbi-dict'>nsbi-dict</a>

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).