Practical Database Design and Tuning. Hardware Raid San Nas Software Hashing B Trees Optimization . Disk Storage Devices. Parallelizing Disk Access using RAID Technology. Secondary storage technology must take steps to keep up in performance and reliability with processor technology.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Different raid organizations were defined based on different combinations of the two factors of granularity of data interleaving (striping) and pattern used to compute redundant information.
Different raid organizations are being used under different situations
Advantages of SANs are:
There are numerous methods for collision resolution, including the following:
- Fixed number of buckets M is a problem if the number of records in the file grows or shrinks.
- Ordered access on the hash key is quite inefficient (requires sorting the records).
Dynamic and Extendible Hashing Techniques
Implementing the SELECT Operation (cont.):
Search Methods for Simple Selection:
Implementing the JOIN Operation
Use Common Sense
First do the WHERE conditions in the various tables and then do the JOIN
Use DISTINCT if possible before the join
In the FROM statement think about the order to select the tables, it might make it faster
Cost Components for Query Execution
Factors that Influence Physical Database Design
Analyzing the database queries and transactions
For each query, the following information is needed.
Factors that Influence Physical Database Design (cont.)
Analyzing the expected frequency of invocation of queries and transactions
20 % queries are made 80 % of the time
Physical Database Design Decisions
Size of individual tables
Number of distinct values in a column
The number of times a particular query or transaction is submitted/executed in an interval of time
The times required for different phases of query and transaction processing
Statistics obtained from monitoring:
I/O and device performance statistics
Query/transaction processing statistics
Locking/logging related statistics
Index statisticsKnow your Data (sample size it)