ALL RIGHTS RESERVED.
CSE 512 Midterm Exam Study Guide.
Levels of Abstraction - answer✔Views: How the user sees the data
Conceptual: Defines logical structure
Physical: Describes files and indexes used
Data Independence - answer✔Applications ask a process to query for them
Atomicity - answer✔Either all actions or no actions in a transaction must complete
DBMS Players - answer✔End Users
Vendors
Programmers
Admin
Scientist
What does scalability improve? - answer✔More users
More data
Latency
Transparency - answer✔A distributed system should be perceived as a whole by both user and
application programmer
Completeness - answer✔Each data item can be found in some fragment
Reconstruction - answer✔There should exist some relational operator that reconstructs the
original table
Disjointness - answer✔If some data item exists in one fragment, it should exist in no other
fragment
Derived Horizontal Fragmentation - answer✔Fragment a table based on the fragment of
another table i.e. equijoin EMP with Pay1 and Pay2
1|Page