INSIGHTCLOPEDIA

Contributions welcome!

A

Access monitoring

Measuring query activity, query results and accessing data in general. The measurement data is used to optimize the database and to monitor the distribution of data.

Access Path

In relational database management system (RDBMS) terminology, Access path refers to the path chosen by the system to retrieve data after executing a Structured Query Language (SQL) request.

Activity Based Costing

Activity Based Costing. An accounting strategy in which indirect costs are allocated to products and customers through activities (cost drivers). By determining the cost price per unit for each activity, it can be calculated which products / customers cost a lot and which are low. With ABC one can ultimately answer the following questions: • Which customers yield the most …

Ad-hoc query

A query is a question that you ask in a database in the form of an SQL statement. Ad hoc queries are often a question that is asked once to the database. They are therefore not included in the fixed set of reports or queries

Ad-hoc reporting

The ability to create reports of any composition at any time. To this end, the necessary data must be available and the tools set up accordingly. It usually concerns one-off reports that are not included in a set of standard reports.

Administrative data (AD)

The data in the Datawarehouse that is used by the Datawarehouse administrator to manage the Data Warehouse, for example user profiles and transaction history.

Aggregated data

Aggregated data is the data resulting from applying a process to combine data elements from different sources. The aggregated data is usually collected collectively or in concise form.

Aggregation

Collection of data, calculated from detailed data. An aggregation is usually a summation, count or average of the underlying detailed data.

Aggregation funtions

Aggregation functions are Count, Addition, Calculate Average, Minimum, and Maximum.

Algorithms

An algorithm is a prescription, made up of one or more steps, with all the actions that must be performed in sequence to arrive at the desired end result from a given initial situation.

Ambition levels of BI

to even make completely new processes inside and outside the organization as new business models

Analysis

Collective term for research. Collection of, for example, a system description, data, user requirements, etc. A thorough analysis is required to arrive at effective BI solutions. Analysis must be approached pragmatically. It serves a purpose and should not become the goal itself.

Append

Quickly adding rows of data to tables. There is no check to determine whether the record to be inserted is not already present in the table. See also: ‘insert’, where this check is performed.

Array

Indexed arrangement of data of the same type in one or more dimensions.

Attribute

A field that displays a property or characteristic of an object. An object can be a table, report, view, record, data entity, etc.

Attribute Class

Insignificant undividable unit of information that represents a relevant property of an entity class. The organization wants to record this information, eg Name, Telephone number, Color, Date. An entity class always has attribute types. There is always at least one (combination of) attributes identifying