Represents a set of functions and methods that other developers can use to access the functionality within another application.
Considered an efficient way of processing, asynchronous processing allows operations to perform in parallel.
Process of verifying the identity for both the sender and receiver of a message. Once the user has been validated, they are considered authenticated.
Process of storing data into a cache object until it is needed again. The cache object is an in-memory representation of the data that can serve as the data source for Web page and Microsoft Windows form objects.
Contains metadata about objects found in a SQL Server instance.
If an error occurs while within a try block, the execution control is transferred to the catch block adjacent to the try block.
A database object that can be applied to columns to enforce domain integrity.
Represents a unique, read-only identifier that is used to identify an object. In the windows registry, the CLSID is used to identify a specific program.
An index whose leaf level is the actual data page of the table.
A database object that can be applied to tables to enforce different types of data integrity.
Used with online analytical processing (OLAP), data cubes are multidimensional structures built from one or more tables in a relational database(s).
A component of structured query language (SQL) used to create and delete databases and database objects such as tables and indexes.
Process of moving data from a single server to one or more different data repositories. This can be vertical, in which data from a single table is split into multiple tables, or horizontal, in which the number of rows in a table are restricted and partitioned by one or more columns.
Refers to the logical name of an open database connectivity (ODBC) data source. The data source name identifies connection information and the correct driver to utilize.
Necessary for resolving conflicts in peer-to-peer replication, data stewardship involves assigning an owner to data that resides on multiple servers and creating rules for how the data should be updated.
Structure that is used to store large amounts of data in a format that is easily accessible. Typically, data is stored in a multidimensional format in which users can drill down into the data.
Occurs when multiple connections that hold locks are waiting for locks to be released that are held by the other transactions, that is, the transactions are waiting for each other to release locks.
A collection of attributes used to describe the data within an OLAP cube. Dimensions are helpful to users trying to browse data within a cube.
When discussing transaction isolation levels, a dirty read has occurred if data that has not yet been committed by one transaction is read by another transaction.
This type of query is used to retrieve data from multiple heterogeneous data sources using the OLE DB data provider.