Suppose you are asked to evaluate a DBMS in terms of lock granularity and the different locking levels. Create a simple database environment in which these features would be important.
Answer to relevant QuestionsWhat DBMS component is responsible for concurrency control? How is this feature used to resolve conflicts?If indexes are so important, why not index every column in every table? (Include a brief discussion of the role played by data sparsity.)What indexes should you create? Write the required SQL commands.What type of database I/O operations will likely be used by the query?Multiple requests accessing multiple remote databases, Figure D12.3 Multiple requests, Multiple RemoteDBMSes
Post your question