T
TableDatabase component in which data is stored in a record-oriented manner. One of the basic elements of a relational database
Table joinLink 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 databaseThe database into which data is loaded
Target groups InmonThe 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 – ExplorersIn 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 – FarmersThis 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 – MinersThis 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 – TouristsThis 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 dataTime-dependent data. A data warehouse contains only time-dependent data. Data has a so-called timestamp and will never be overwritten.
Top downGeneral 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 lightingTerm 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 modelA dimensional schedule to record instantaneous measurement of a specific date time. An example of this is the sales transaction of a product.
Transaction processingTerm that refers to the processing of the transaction data within a transaction system.
Transactional dataThese are transaction data that are stored in a transaction system (transactional system).
Transactional systemThis 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.).
TransformTransformation 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.
TransformersRules that are drawn up for transforming data.
Transition dataData consisting of both primitive and derived characteristics. These data are usually important for the management of an organization
TriggerA trigger ensures that a process, for example loading the data warehouse, is started. Often in the form of a trigger file.
Trigger fileOften an empty text file that ensures that the next process can start. Usually used as a signal that files are ready to be processed.
TuningAdjusting systems to optimize performance. For example, tuning a database to ensure that complex queries are processed as quickly as possible.
TupleA set of data consisting of one or more data types and is analogous to a record in a database.