Databases Reference
In-Depth Information
case, the improved performance comes at the cost of the additional disk storage
needed to keep the query result.
SELF-CHECK
•
Describe the basic information needed to create a table.
•
Describe the basic information needed to create an index.
•
Describe the basic information needed to create a view.
SUMMARY
This chapter takes a close look at some final physical design issues and the basic
implementation process. It introduced additional design requirements. You were
also introduced to the types of utilities available for object creation. You learned
about data integrity and performance optimization needs. You also saw how to
create basic tables, indexes, and views.
KEY TERMS
Application data requirements
ASCII
Batch
Check constraint
Constraint
CREATE INDEX command
CREATE TABLE command
CREATE VIEW command
Data type
Data volatility
Data volume assessment
Default constraint
Denormalization
Domain integrity
Entity integrity
Fully qualified object name
Globally unique identifier (GUID)
Horizontal partitioning
Nullability
Policy integrity
Referential integrity
Response time
Scaling out
Scaling up
Search attribute
Selectivity
Throughput
Trigger
Unique constraint
Unicode
Vertical partitioning
Virtual desktop
