Databases Reference
In-Depth Information
Repeatable read
Transaction isolation level that prevents dirty reads and nonrepeatable
reads by not reading uncommitted data and not allowing changes to data read by the
transaction.
Replication
Means by which a database server updates one or more destination data-
base servers.
Report writer
DBMS component responsible for designing and processing reports.
Reporting database
A decision support database designed to support report generation.
Response time
The delay from the time that the request is made (such as when the
Enter key is pressed) to execute a query until the result appears on the screen.
Response time
The elapsed time required for a Web server's response to display in
the client's browser.
Result set
Rows and columns returned by a SELECT command.
Role
In SQL Server, login or data user groups with defined permissions.
Roll forward
A recovery process that updates database tables based on committed
transactions in the transaction log.
Rollback
The process of backing out the changes made by an unsuccessful transaction
so that they are not written to the hard disk.
Sa account
SQL Server administrator account.
Scalable
Term describing a solution that can grow to meet business needs.
Scaling out
The process of partitioning data and a database application across multiple
distributed database servers.
Scaling up
The process of upgrading the database hardware platform by improving
the processor, memory, disk subsystem, or other hardware resources.
Schema
Metadata used to describe database objects.
Schema binding
Prevents you from making any changes to the structure of the base
tables, such as adding columns or changing column data types.
Script
A set of executable statements saved together as a file.
Search argument
Logical and conditional operators used to filter the rows processed
by a command.
Search attribute
A value used to retrieve particular records.
Second normal form
Every nonkey attribute must be fully functionally dependent on
the entire key.
Secondary index
Additional database indexes (other than the primary index).
Secondary storage
Nonvolatile data storage such as disk and tape drives.
Securable
Server or database object over which you have control over permission
assignments.
Security context
The security default for a connection based on the security princi-
pal's assigned rights and permissions.
