Glossary


A-D

application programming interface (API)

Represents a set of functions and methods that other developers can use to access the functionality within another application.

asynchronous processing

Considered an efficient way of processing, asynchronous processing allows operations to perform in parallel.

authentication

Process of verifying the identity for both the sender and receiver of a message. Once the user has been validated, they are considered authenticated.

caching

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.

catalog view

Contains metadata about objects found in a SQL Server instance.

catch

If an error occurs while within a try block, the execution control is transferred to the catch block adjacent to the try block.

check constraint

A database object that can be applied to columns to enforce domain integrity.

class identifier (CLSID)

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.

clustered index

An index whose leaf level is the actual data page of the table.

constraint

A database object that can be applied to tables to enforce different types of data integrity.

cubes

Used with online analytical processing (OLAP), data cubes are multidimensional structures built from one or more tables in a relational database(s).

data definition language (DDL)

A component of structured query language (SQL) used to create and delete databases and database objects such as tables and indexes.

data partitioning

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.

data source name (DSN)

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.

data stewardship

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.

data warehousing database

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.

deadlock

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.

dimensions

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.

dirty row

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.

distributed queries

This type of query is used to retrieve data from multiple heterogeneous data sources using the OLE DB data provider.




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