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 is a relational database application in which an individual may design -- and easily share on the Internet -- a database file by starting with a blank document or implementing ready-made and customizable templates.
-
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.
-
MOLAP (multidimensional online analytical processing)
MOLAP (multidimensional online analytical processing) is online analytical processing (OLAP) that indexes directly into a multidimensional database.
-
P
pivot table
A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report.
-
S
spatial data
Spatial data, also known as geospatial data, is information about a physical object that can be represented by numerical values in a geographic coordinate system.
-
U
U-SQL
U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments.
-
Universal Data Access (UDA)
Universal Data Access (UDA) is Microsoft's model or framework for a single uniform application program interface to different software makers' databases, both relational and nonrelational.