Pro T-SQL 2012 Programmer's Guide, Third Edition

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 ...