Glossary of technical terms
-
i.e., Application Programming Interface; a set of functions made available to interact and integrate with a software application or system
-
Represents the quantity of data read, transformed and loaded into a destination at one time
-
A sequence of characters that specifies information about a data source and how to connect to it
-
When a server is taking too long to reply to a data request made from another device
-
A multidimensional structure containing aggregated and calculated data that can be viewed in different ways (through slices) for a better understanding of the collected data
-
An angle through which the Measures are analyzed
-
i.e., Extract, Transform and Load; processes by which you can perform tasks within a database; Extract (i.e., read) consists of collecting data from one or more sources; Transform consists of converting extracted data into the correct format through tables to be processed in the data warehouse; Load (i.e., store) consists of writing the converted data into the destination database
-
Contains information about its associated Data Model and can be used to execute scripts using given parameters
-
A numeric field whose values can be measured, e.g., Sales Total, Costs, Margins, Quantities, etc.
-
A subsection of data within the Cube; defined by a set of Dimension elements
-
Key that identifies the field used in the incremental load
-
i.e., Uniform Resource Identifier; a string (i.e., sequence) of characters that unambiguously identifies a particular resource
-
Presents data in different formats that are easy to read, such as Worksheets and many types of Graphs.
A
B
C
D
E
I
M
S
T
U
V