SUBJECT: DATABASE DESIGN AND MANAGEMENT Review the application description provi
ID: 3758770 • Letter: S
Question
SUBJECT: DATABASE DESIGN AND MANAGEMENT
Review the application description provided in each minicase. Answer the questions about hardware resources requirements.
Case #1
You are designing a database application. You plan to use SQL Server 2005 as the backend database. Server and client applications will be written using .NET Framework programming languages. The user interface and all reporting functions will be created as part of the client application.
The application will need to process several thousand transactions each day. Optimized performance during data retrieval and data update is critical to the application. A significant part of the data retrieval requirement includes several static look-up tables shared by different application components. The database must be backed up nightly to a file server located on the same network. You must ensure that these backups run at the same time every night.
1. Which components would be most critical this application? (2pts)
· Data engine
Report writer
Forms generator
Query processor
2. What should you expect most of the available memory buffers to contain during normal processing? (3pts)
3. Is processor speed important to this application? Why? (2pts)
4. What kind of procedure would you use to ensure that backups run as needed? Record your answer below. (3pts)
Case #2
You installed a database management system on a computer that meets the minimum installation requirements. The primary application involves data collection, retrieving data from automated sensors, and writing to the database tables. Based on the sensor sample rates, the application should never need to process more than one update at a time. The database is projected to eventually need to hold several million table rows. The data is critical, so the possibility of data loss must be minimized and the possibility of recovery after a failure must be maximized. Hardware and software costs on the collection database server must be kept to a minimum, investing in only those components key to meeting critical requirements.
Periodically, a separate application will retrieve all data from the collection database and copy the data to a separate online application processing (OLAP) decision support database for analysis and reporting. OLAP databases are used for this purpose and optimized for decision support data operation requirements. Data transfer will occur during scheduled maintenance periods when the sensors are taken offline so the activity does not interfere with data collection. Any existing data on the OLAP database will be overwritten by the process. The hardware platform for the OLAP database will not be purchased until after you can estimate its hardware resource requirements.
1. Which of the following would be key requirements in your collection database application design for normal operations?
· Read performance
· Write performance
· User interface
· Fault tolerant storage
· Report generation
2. Which of the following would be key requirements in your OLAP database application design for normal operations?
Read performance
Write performance
User interface
Fault tolerant storage
Report generation
3. Of processor, memory, and hard disk, which current hardware resource is LEAST likely to meet the long-term requirements for collection database? Explain your reasoning.
4. Will the OLAP database meet your recovery requirements for the collection database? Why or why not? If not, describe (in general terms) how these requirements could be met.
SUBJECT: DATABASE DESIGN AND MANAGEMENT
Explanation / Answer
Case #1
1) Query processor
2) Database creates server processes to handle the requests of user processes connected to the instance. In some situations when the application and Oracle Database operate on the same computer, it is possible to combine the user process and corresponding server process into a single process to reduce system overhead. However, when the application and Oracle Database operate on different computers, a user process always communicates with Oracle Database through a separate server process.
The database writer process writes the contents of buffers to datafiles. The processes are responsible for writing modified buffers in the database buffer cache to disk. Although one database writer process is adequate for most systems, you can configure additional processes to improve write performance if your system modifies data heavily. These additional processes are not useful on uniprocessor systems.
3) Yes,processor speed important to this application because application will need to process several thousand transactions each day. Optimized performance during data retrieval and data update is critical to the application.
4) It stresses the importance of incorporating into the backup and recovery strategy to safeguard your investment. A backup and recovery factors involved in the development of a backup and recovery strategy.
Backup is a process used to make a copy of the contents of database files and log files. The database files consist of a database root file, log file, mirror log file, and other database files called dbspaces.
Recovery is a sequence of tasks performed to restore a database to some point in time. Recovery is performed when either a hardware or media failure occurs. Hardware failure is a physical component failure in your computer, such as a disk drive, controller card, or power supply. Media failure is a failure of the actual physical medium that is storing the data. If a hardware failure occurs, such as a power supply malfunction, the data becomes unavailable. Once the faulty component is replaced, the data is accessible again. If a media failure occurs, such as bad sectors forming on the disk, the component cannot simply be replaced because the actual storage media has been corrupted. You must have backups on secondary storage to be able to recover from these failures.
Before you begin recovery, it is a good practice to back up the failing database. Backing up the failing database preserves the situation, provides a safe location so files are not accidentally overwritten, and if unexpected errors occur during the recovery process, Sybase Technical Support may request that you forward these files to them.
Case#2
1) Report generation
2) Write performance
3) Of processor is LEAST likely to meet the long-term requirements for collection database.The long term scheduler executes much less frequently.minutes may separate the creation of one new process and the next. The long term scheduler controls the degree of multiprogramming.
Because of the longer interval between executions, the long term scheduler can afford to take more time to decide which process should be selected for execution. so as per long term requirement Of processor is LEAST likely to meet .
4) Backup requires taking the server running Team Foundation Server offline for the period of time the backup takes to ensure a consistent backup. OLAP database that must be backed up.High availability is the measurement of a system’s ability to remain accessible in the event of a system component failure. Generally,It's implemented by building in multiple levels of fault tolerance and/or load balancing capabilities into a system.
Below reuirement meet for OLAP
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.