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
database (DB)
A database is a collection of information that is organized so that it can be easily accessed, managed and updated.
-
M
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.
-
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.