Pro T-SQL 2008 Programmer's Guide

Appendix C. Glossary

ACID

This is an acronym for atomicity, consistency, isolation, durability. These four concepts of transactional data stores, including SQL databases, ensure data integrity.

Adjacency list model

This is the representation of all arcs or edges of a graph as a list. In SQL, this is often implemented as a self-referential table in which each row maintains a pointer to its parent node in the graph.

ADO.NET Data Services

Also known as "Project Astoria," ADO.NET Data Services provides middle-tier support for accessing SQL Server databases through REST-style queries and entity data models (EDMs).

Anchor query

This is the nonrecursive query specified in the body of a CTE.

Application programming interface (API)

This is a well-defined interface ...