A
ACID
For a unit of work to qualify as a transaction, it must exhibit four characteristics: atomicity, consistency, isolation, and durability.action
A user-initiated operation upon a selected cube or portion of a cube. The operation can launch an application with the selected item as a parameter or retrieve information about the selected item.active statement
A SQL statement that has been executed but whose result set has not yet been canceled or fully processed.ActiveX Data Objects (ADO)
An easy-to-use application programming interface (API) that wraps OLE DB for use in languages such as Visual Basic, Visual Basic for Applications, Active Server Pages, and Microsoft Internet Explorer Visual Basic Scripting.ad hoc connector name
The OPENROWSET function in the FROM clause of a query that allows all connection information for an external server and data source to be issued every time the data must be accessed.add-in
A custom extension (written in any language that supports the Component Object Model, or COM usually Visual Basic) that interacts with Analysis Manager and provides specific functionality. Add-ins are registered with the Analysis Add-In Manager. They are called by the Analysis Add-In Manager in response to user actions in the user interface.ADO
See ActiveX Data Objects (ADO).aggregate function
A function that performs a calculation on a column in a set of rows and returns a single value.aggregate query
A query (SQL statement) that summarizes information from multiple rows by including an aggregate function such as SUM or AVG.aggregation
A table or structure that contains precalculated data for a cube. An aggregation is also a collection of objects that makes a whole. An aggregation can be a concrete or conceptual set of whole-part relationships among objects.aggregation prefix
A string that is combined with a system-defined ID to create a unique name for a partition's aggregation table.aggregation wrapper
A wrapper that encapsulates a COM object within another COM object.alert
A user-defined response to a SQL Server event. Alerts can either execute a defined task or send an e-mail or pager message to a specified operator.alias
An alternative name for a table or column in expressions that is often used to shorten the name for subsequent reference in code to prevent possible ambiguous references or to provide a more descriptive name in the query output. An alias can also be an alternative name for a server.aliasing
To allow the name of an object, property, or relationship to be reused in a new context while keeping all other attributes constant.
American National Standards Institute (ANSI)
An organization of American industry and business groups that develops trade and communication standards for the United States. Through membership in the International Organization for Standardization (ISO) and the International Electrotechnical Commission (IEC), ANSI coordinates American standards with corresponding international standards.Analysis server
The server component of Analysis Services that is specifically designed to create and maintain multidimensional data structures and provide multidimensional data in response to client queries.annotational property
A property that is maintained by Meta Data Services as string data that can be attached to any repository object that exposes the IAnnotationalProps interface.anonymous subscription
An anonymous subscription is a type of pull subscription for which detailed information about the subscription and the Subscriber is not stored.ANSI
See American National Standards Institute (ANSI).API
See application programming interface (API).API server cursor
A server cursor built to support the cursor functions of an application programming interface (API) such as ODBC, OLE DB, ADO, and DB-Library. An application does not usually request a server cursor directly; rather, it calls the cursor functions of the API. The SQL Server interface for that API implements a server cursor if that is the best way to support the requested cursor functionality. See also server cursor.application programming interface (API)
A set of routines available in an application, such as ADO, for use by software programmers when designing an application interface.application role
A SQL Server role created to support the security needs of an application.archive file
The .CAB file created by archiving an Analysis Services database.article
An object specified for replication. An article is a component in a publication and can be a table, specified columns (using a column filter), specified rows (using a row filter), a stored procedure or view definition, the execution of a stored procedure, a view, an indexed view, or a user- defined function.atomic
A condition in which either all or none of the transaction data modifications are performed.atomicity
A state where all data modifications are performed, or none are performed; an atomic unit of work. Atomicity is one of the required characteristics for a transaction.attribute
In data mining, a single characteristic of a case. Attributes are used to provide information about a case. For example, weight can be an attribute of a case that involves shipping containers. See also case.authentication
The process of validating that the user who is attempting to connect to SQL Server is authorized to do so. See also SQL Server Authentication.authorization
The operation that verifies the permissions and access rights granted to a user.automatic recovery
Recovery that occurs every time SQL Server is restarted. Automatic recovery protects your database if there is a system failure.autonomy
The independence that one site has from other sites when performing modifications to data.availability
A measure of how often a system is running and available to users.
AVG
A SQL function to calculate the average of an expression.axis
A set of tuples. Each tuple is a vector of members. A set of axes defines the coordinates of a multidimensional data set. See also slice, tuple.