You take a new job as a database administrator at an organization that has a globally distributed database. You are asked to analyze the performance of the database. As part of your analysis, you discover that all processing for regional monthly sales reports is being conducted at the corporate headquarters location. Operations are categorized by five regions: Eastern United States, Western United States, Canada, South America, and Mexico. Data for each region are kept on a server located at the regional headquarters. What would you try to improve the time needed to create the monthly sales reports?
The Solution to the Problem
As a database administrator, ideal answers for this circumstance will depend on a more complex understanding of the definite circumstance and the RDBMS (Relational DataBase Management System). Yet, there are following few conceivable outcomes focused around ordinary Oracle situations:
Duplicate the information on the company machine, exploiting Oracle’s information reserving competencies. The information will then turn into a neighborhood corporate example, permitting extra preparation of the information past processing the provincial month-to-month deals to report without extra loads on the system. If it is essential, the information's depiction could be invigorated at decided ahead of time interims. Previews could be booked at off-top burden times.
Create outline tables at every local site that hold the condensed information important to set up the month to month provincial deals reports at corporate base camp. This methodology would enormously decrease the system load, as just the synopsis tables might need to be transmitted. This alternative does not utilize the information for other preparation conceivable from the past methodology.
Because the reports are territorial, move the preparing of the reports out to the local workplaces. This methodology might kill any system load issues happening as an aftereffect of the existing techniques. Nonetheless, this methodology will raise programming administration issues unless the organization can deal with the product used to generate the reports halfway.
Moving to a three-level customer/server, structural planning may additionally be a probability. At that point, the reporting programming could live on the center level, and the product administration issues intrinsic in the past methodology could be enormously diminished.
See Also: MDM Chapter 11 Problem and Excercise 17
Post a Comment