Estimated query cost is a metric used to measure query performance.
Simple and flexible text format used to represent data. XML was designed by the World Wide Web Consortium (W3C).
Represents a group of servers that cooperate in order to share data that is dispersed among those servers. The purpose of a federation is to share the load of an application across multiple servers.
A database object that enforces data reference integrity between (or within) tables.
Built from a mining structure, the mining model applies an algorithm to the data and processes it so that predictions can be made.
Used to describe that data from which a mining model will be built. This data can come from one or more relational or multidimensional data sources.
Represent additional instances of SQL Server; used to uniquely identify the instance.
Set of dynamic link library (DLL) files that support a particular network protocol and allow you to pass data across the network through packets.
Represents a set of rules used to facilitate communication between applications across a network. The rules can specify how the applications perform authentication, detect errors, and send messages to each other.
An index whose leaf level stores only the columns included in the index (key columns and included columns) and holds pointers to the rows in the actual table.
Constraints that are not guaranteed to have verified the data integrity for all rows in a table.
Logical design process in which data is separated into multiple, related tables. The process allows databases to perform optimally.
Interface designed by Microsoft to efficiently access diverse data sources. OLE DB consists of several COM interfaces, which enable data providers to access each data source.
Process whereby raw data is stored in a multidimensional format so that it can be analyzed easily by decision-makers.
Interface used to provide access to data sources that provide an ODBC driver. The driver is a software file that provides instructions for how to access the data source.
Represents a chart or log that is used to mark an application when it was performing satisfactorily. This baseline can be compared to logs captured when the application is performing poorly to identify the problem area.
A phantom read (or phantom row) describes the occurrence of data returned by a statement in a transaction which was not returned by an earlier statement (with the same WHERE clause) within the same transaction.
A database object that enforces value uniqueness for one or more columns in a table. Used to enforce entity integrity.
Code used to call a Web service. The proxy represents a local object with the same interface as the Web service itself.
Used to represent actual code as real English. This simplifies the code and makes it easier to read.