BI and Data Warehousing Definitions
-
A
AlwaysOn Availability Groups
AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together.
-
C
columnstore index
A columnstore index is a type of index used to store, manage and retrieve data stored in a columnar format in a database.
-
D
data mining
Data mining is the process of sorting through large data sets to identify patterns and establish relationships to solve problems through data analysis.
-
data preprocessing
Data preprocessing describes any type of processing performed on raw data to prepare it for another processing procedure.
-
database (DB)
A database is a collection of information that is organized so that it can be easily accessed, managed and updated.
-
DSTP (Data Space Transfer Protocol)
DSTP (Data Space Transfer Protocol) is a protocol that is used to index and retrieve data from a number of databases, files, and other data structures using a key that can find all the related data about a particular object across all of the data.
-
F
FileMaker (FMP)
FileMaker (or its latest version, FileMaker Pro) is a relational database application known for being easy to use and for its ability to serve Web pages dynamically without requiring the use of additional third-party applications.
-
G
GIS (geographic information system)
A GIS (geographic information system) enables you to envision the geographic aspects of a body of data.
-
H
hybrid online analytical processing (HOLAP or Hybrid OLAP)
Hybrid online analytical processing (HOLAP) is a combination of relational OLAP (ROLAP) and multidimensional OLAP (usually referred to simply as OLAP).
-
I
intelligent database
An intelligent database is a full-text database that employs artficial intelligence (AI), interacting with users to ensure that returned items (hits) contain the most relevant information possible. This is in contrast to a traditional database, which is searchable only by keywords and verbatim phrases connected by Boolean operations such as AND, OR, and NOT. Intelligent database technology is in its infancy, and is evolving as AI becomes more advanced.
-
M
meta
Metadata is a description of data.
-
Microsoft GeoFlow
Microsoft GeoFlow is a three-dimensional data visualization mapping tool for Microsoft Excel.
-
Microsoft PowerPivot
PowerPivot is a free Microsoft Excel tool that increases the capabilities of Excel's pre-existing pivot table tool by allowing users to import data from multiple sources.
-
Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)
Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW) is a pre-built data warehouse appliance that includes Microsoft SQL Server database software, third-party server hardware and networking components.
-
Microsoft SSIS (SQL Server Integration Services)
Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database.