INSIGHTCLOPEDIA

Contributions welcome!

T

Table

Database component in which data is stored in a record-oriented manner. One of the basic elements of a relational database

Table join

Link between two or more tables for data merge tactical data warehouse development. This stands for the total process from selecting a focus area within an organization up to and including the implementation of a data warehouse. It includes things like data modeling, architecture definition, development and filling the data warehouse.

Target database

The database into which data is loaded

Target groups Inmon

The target group is an important element within the information request. Who uses the information arising from Business Intelligence and gets to work with it. Bill Inmon divides the target groups into four different types:

Target groups Inmon – Explorers

In addition to insight into what is happening, the “explorers” also want to know how, when and why. This characterization therefore goes deeper into all actual events. This group would like to look at the information or indicators obtained from different angles.

Target groups Inmon – Farmers

This is a target group classification that often has a fixed and predictable information requirement. There is usually no need for sudden insight into information. Managers and stable internal departments often fall under this classification. This target group often benefits from a weekly or monthly report. However, it must be regularly checked whether this pattern of need is still valid.

Target groups Inmon – Miners

This characterization goes even deeper into the matter than the “explorers” and deals with complex issues. They use historical data and analyze it in order to ultimately make a decision.

Target groups Inmon – Tourists

This target group classification is equal to the information needs of the “farmers”, only they want to be able to access this information at any time of the day. So they are figuratively traveling through the information and are often busy drawing up an annual plan or adapting to a business process

Time variant data

Time-dependent data. A data warehouse contains only time-dependent data. Data has a so-called timestamp and will never be overwritten.

Top down

General term used for the approach to an approach. Within data warehousing this means first building a data warehouse and then building one or more data marts. The opposite of ‘bottom-up’.

Total cost of ownership (TCO)

The total (expected) costs associated with the implementation of a solution or system. Clearly goes further than just the investment, costs for management, maintenance, etc. are also included.

Total quality management (TQM)

TQM stands for Total Quality Management, or in Dutch: Integrated Quality Management. TQM is a business philosophy, in which it means that everything an organization does should be aimed at satisfying all stakeholders in the most efficient way possible. TQM can best be made concrete on the basis of a scheme. The scheme below is used at both European and …

Traffic lighting

Term used for an indicator on a dashboard application; in this case a traffic light that indicates whether something is going well (green), is about to go wrong (orange) or is going wrong (red).

Transaction grain model

A dimensional schedule to record instantaneous measurement of a specific date time. An example of this is the sales transaction of a product.

Transaction processing

Term that refers to the processing of the transaction data within a transaction system.

Transactional data

These are transaction data that are stored in a transaction system (transactional system).

Transactional system

This is an information or production system designed for recording daily business data. These systems are designed for capturing huge amounts of data, but not for analyzing that data (als een POS, ERP, CRM etc.).

Transform

Transformation is the processing of data. This includes filtering data, merging data or aggregating data. Transformation is the process that occurs after data is loaded from a source and before data is loaded into the data warehouse. The location where the transformation takes place is the staging area.

Transformers

Rules that are drawn up for transforming data.

Transition data

Data consisting of both primitive and derived characteristics. These data are usually important for the management of an organization

Trigger

A trigger ensures that a process, for example loading the data warehouse, is started. Often in the form of a trigger file.

Trigger file

Often an empty text file that ensures that the next process can start. Usually used as a signal that files are ready to be processed.

Tuning

Adjusting systems to optimize performance. For example, tuning a database to ensure that complex queries are processed as quickly as possible.

Tuple

A set of data consisting of one or more data types and is analogous to a record in a database.