E-P


estimated query cost

Estimated query cost is a metric used to measure query performance.

extended markup language (XML)

Simple and flexible text format used to represent data. XML was designed by the World Wide Web Consortium (W3C).

federation

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.

foreign key constraint

A database object that enforces data reference integrity between (or within) tables.

mining model

Built from a mining structure, the mining model applies an algorithm to the data and processes it so that predictions can be made.

mining structure

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.

named instances

Represent additional instances of SQL Server; used to uniquely identify the instance.

network library

Set of dynamic link library (DLL) files that support a particular network protocol and allow you to pass data across the network through packets.

network protocol

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.

non-clustered index

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.

non-trusted constraints

Constraints that are not guaranteed to have verified the data integrity for all rows in a table.

normalization

Logical design process in which data is separated into multiple, related tables. The process allows databases to perform optimally.

object linking and embedding (OLE DB)

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.

online analytical processing (OLAP)

Process whereby raw data is stored in a multidimensional format so that it can be analyzed easily by decision-makers.

open database connectivity (ODBC)

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.

performance baseline

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.

phantom read

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.

primary key constraint

A database object that enforces value uniqueness for one or more columns in a table. Used to enforce entity integrity.

proxy code

Code used to call a Web service. The proxy represents a local object with the same interface as the Web service itself.

pseudo code

Used to represent actual code as real English. This simplifies the code and makes it easier to read.




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net