"Optimization for Transactional Processing" Please respond to the following:
Databases can grow in data structure and data capacity throughout time. At certain times, it is necessary to perform optimization techniques in order to ensure optimal performance of the database.
Evaluate at least two methods that can be used to optimize database components such as queries, reports SQL transaction processing, and data consumption.
Provide a real-world example that explains how these methods would help an organization process a large number of online transactions within a short time span.
Suggest at least two SQL optimization techniques that can be used to enhance the data access turnaround time and transaction processing time. Provide examples to support your response.
Assess the database statistics that could be used in order to measure database performance. Provide a real-world example that demonstrates how this information would enable businesses to accurately scale its data processing requirements.
Classmates:
Databases can grow in data structure and data capacity throughout time. At certain times, it is necessary to perform optimization techniques in order to ensure optimal performance of the database.
Evaluate at least two methods that can be used to optimize database components such as queries, reports SQL transaction processing, and data consumption. Provide a real-world example that explains how these methods would help an organization process a large number of online transactions within a short time span.
Two method that can be used to optimize database components such as queries, reports, SQL transaction, and processing and data consumption would be the speed.
It improves page load including page download weight such as image. JavaScript and CSS, network latency, server load for the websites. They will help load the speed since a busy database can affect the server. Also, meaning parts that do not use the database are very fast running queries could start to slow down.
Suggest at least two SQL optimization techniques that can be used to enhance the data access turnaround time and transaction processing time. Provide examples to support your response.
Two SQL optimization techniques that can be used to enhance the data access would be to apply to some advanced indexing technique and create indexes on XML columns. Users might have written application code to select a result set from the database to do a calculation for each row in the result set to produce the ultimate information for the output.
Another optimization technique is User Defined Functions (UDF) that helps create the function to make sure that the function is deterministic.
Assess the database statistics that could be used in order to measure database performance. Provide a real-world example that demonstrates how this information would enable businesses to accurately scale its data processing requirements.
Time model statistics and active session history statistics ate the database statistics that could be used in order to measure database measurement. Time model statistics identifies quantiative effects about specific actions on database like operation and passing.
Active session history statistics is connected to database and waits for the event that does not belong to the idle wait class for an active session. In real world, oracle database samples session stores the sampled data in a circular buffer for global area.