Database
a database tool can measure query execution time
Query Analyzer
a model that ensures and updates in order to across all
replicas.
Inearizability
A UML diagram best captures the structure of a system
Class Diagram
a property in the CAP theorem that must be compromised when
prioritizing consistency and partition tolerance
Availability
is a distributed database strategy that reduces latency by
storing copies of the same data in multiple locations.
Data Replication
modeling technique is most suitable for depicting workflows
or processes
Activity Diagram
a query optimization technique focuses on filtering rows
as early as possible
Predicate Pushdown
illustrates the organization of software components
Component Diagram
is a fragmentation which involves splitting tables into
subsets based on their attributes
Vertical Fragmentation
refers to the number of instances an entity can be associated with
Multiplicity
the logical query transformation
B Tree Index
an operation benefits most from indexing in SQL
Join
databases is finding the least expensive execution
plan
cost-based optimization
physical copy of data for faster query performance
Materialized View
SQL is transforming SQL statements into more efficient
equivalents
Query Rewriting
distributed databases is storing related data near the
processing nodes
Data Locality
indexing strategy is best suited for distributed databases with a large volume of range queries
Partition Aware B-Tree indexes