An on-line transaction processing site hasexperienced performance issues.The response time of Database queriesretrieving read-only data was unacceptable,which resulted into slower response time.In addition, the application server was notmanaging database connection resourcesefficiently, which caused waste of DBconnection resources. This problem hasoccurred as DB connections were notchecked back when done.Finally, the operations team needs a mean toenable continuous monitoring of Web,Application and DB servers for run-timeissues in order to be able to preventiveactions as required.Identify three architectural patterns toaddress these situation, while explaining howeach of the patterns will be operating to solvethese situations?1.2.3.

Architectural patterns An architectural pattern is a schema for software systems, provides…

Answered: Identify three architectural patterns…

Identify three architectural patterns to address these situation, while explaining how each of the patterns will be operating to solve these situations?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Briefly explain in your own words, SDLC and how does it relate to Methodologies as applied in…

A: The Software Development Life Cycle (SDLC) refers to a methodology with clearly defined processes…

Q: Recognize the difference between distributed and centralised architectural patterns. Critically…

A: Intro Distributed architectural patterns work on a single logical data network, which is being…

Q: I need help for Architectural Mapping for car rental system that will provides a complete mapping…

A: SoftwareStructureElementTypes Relations Useful ForQuality…

Q: Subject Name: Software Enginnering Q1. Suggest an appropriate Structural model for a organization of…

A: A description of the software architecture is the result of this design process. Architectural…

Q: Discuss the importance of software architecture and patterns in the development of Information…

A: let us see the answer:- Introduction:- Engineers face many of the same issues over and over again…

Q: The Level of design to determine characteristics of the current state of the design called System…

A: GIVEN: The Level of design to determine characteristics of the current state of the design called…

Q: ng used to guarantee that legacy systems conti

A: Approach is being used to guarantee that legacy systems continue to evolve in the future

Q: ese designs in terms of cohesion, and what mi

A: Wrong with these designs in terms of cohesion

Q: Distinguish between distributed architectural patterns and their benefits and drawbacks

A: Patterns of distributed architecture: Distributed architecture patterns are made up of numerous…

Q: combination are there?

A: In architectural design, we work with three different types of planes: Aerial Plane The overhead…

Q: 4. Explain difference between coupling and cohesion? Which is desirable? Justify your answer. 5.…

A: Cohesion: Cohesion is a measure of how well a module works together. It's the intra-module notion.…

Q: The goal of Trace Requirements is to ensure that requirements and designs at different levels are…

A: The following solutions are

Q: discuss why processes must be repeatable and measurable in order to improve them? \

A: Processes are made so as to make the a work easier.

Q: Suggest an appropriate Structural model for a organization of the system for Mental Health care.…

A: Structural measures of quality refer to the resources and capacity of a delivery system to deliver…

Q: Prepare the software architecture diagram for the following enterprise solution booking.com In your…

A: Because these are so large, they have a lot of user traffic that needs to be handled. As a result,…

Q: A) How systems integration is defined on technical basis, elaborate your point of view? b) It is…

A: A. System integration is the process of transferring the components of sub systems to the one…

Q: Which architectural pattern is suited to applications in which data is generated by one component…

A: MVC architectural pattern is the best suited for the applications in which data gets generated by…

Q: 2.1 What is software architecture?Why is architecture important?What is Architectural Description…

A: Software architecture Software architecture refers to the core constructs of the software framework…

Q: briefly describe the features and advantages of a façade architectural pattern.

A: The facade pattern (or façade pattern) is a software design pattern commonly used with…

Q: As you build the framework, describe the problems that may develop and then evaluate the…

A: In the following phases, we will investigate the obstacles that must be overcome while creating an…

Q: Select one architectural style and apply it to a system of your choosing?

A: Answer: In software design, a pattern structure (architectural pattern) is a standard, repeatable…

Q: Cohesion-wise, what is wrong with these designs and what might be done to enhance them?

A: Introduction: Cohesion refers to the degree to which the components inside a module belong together…

Q: The problems and difficulties faced by stakeholders are mirrored in the FEAF's six sub-architecture…

A: Given: There are six sub architecture domains in all. The Government Performance and Reform Act, the…

Q: "Integration testing is a total waste of time," your supervisor asserts. Integration testing is…

A: Introduction: Let's begin with a clear explanation of what we mean. An integration test examines…

Q: Explain why design conflicts might arise when designing an architecture for which both availability…

A: Design conflicts might arise when designing an architecture for which both availability and security…

Q: 42. Phase that establish design representations that serve as basis for RAD's construction activity…

A: Please see the next step for solution.

Q: The problems and difficulties faced by stakeholders are mirrored in the FEAE's six sub-architecture…

A: Given: There are six sub architecture domains in all. Paperwork Reduction Act Clinger-Cohen Act…

Q: Use principle component analysis to decrease the feature space from two to one dimension. Complete…

A: Intro Task : Given the 2-D data. The task is to convert into 1-D data using PCA.

Q: What are the reasons of failure of ERP Implementations ? (Select the least appropriate answer) a.…

A: let us see the answer:-

Q: ustify your choice for adopting a variety of architectural patterns while designing a large system's…

A: The answer is

Q: Provide a description of the process of prototyping in relation to the establishing of requirements.…

A: Explanation: Prototyping is described as the process of creating prototypes of any application,…

Q: Which architectural pattern is best for systems with one component producing data and another…

A: The MVC design pattern is best suited for systems where one component generates data that is then…

Q: Which architectural pattern is the best suitable for systems in which one component generates data…

A: Let's see the solution :

Q: Compare the three architectural evaluation methods stating their requirements, drawbacks, benefits,…

A: Architecture evaluations can be acted in at least one phases of the software advancement process.…

Q: A stage in which individual components are integrated and ensured that they are error-free to meet…

A: Required: A stage in which individual components are integrated and ensured that they are error-free…

Q: Which architectural pattern is suited to applications in which data is generated by one component…

A: MVC architecture pattern is most suited for applications in which data is generated by one component…

Q: identify all entities of system?

A: Entities of a system An entity is a real world thing that can be identified distinctly like a…

Q: What is Architectural Description and decisions?

A: A set of decisions related to the design of architecture of a software is known as architectural…

Q: What are the fundamental distinctions between backward and forward integration, and what sorts of…

A: Backward integration means when a company unites with suppliers to get the supply of raw material to…

Q: Think about an ATM and its functionality. If you were creating a functional model for an ATM, what…

A: The ATM machine provides the following operations to the customer: Checking Balance Deposit Funds…

Q: List two non-functional requirements which recommend the layered architecture to a system. Provide…

A: Answer :- The non-functionality requirements are not directly involved in the system implementation…

Q: State the type of communication you would adopt under the following headings in an architectural…

A: 1. Persistent- Synchronous communication 2. Synchronicity- digital communication 3.…

Q: Question 2 With reference to Question 1, identify an architectural pattern which can suit the…

A: 2. 1.Offload the database â€“ stay away from the database as much as possible. That means donâ€™t…

Q: Suggest Structural model for a organization of the system for Mental Health care. What Architectural…

Q: Which architectural style is optimal for systems in which one component generates data while another…

A: INTRODUCTION The architectural architecture of a classic data vaulting college is most similar to…

Q: Discuss the Prototyping model used for SDLC? Mention when should such model be applied? Define…

A: The prototype may be an operating model of a software package with some restricted practicality. The…

Q: which architectural patern is suited to the applications in which data is generated by one component…

A: MVC architecture pattern is most suited for applications in which data is generated by one component…

Question

An on-line transaction processing site has
experienced performance issues.
The response time of Database queries
retrieving read-only data was unacceptable,
which resulted into slower response time.
In addition, the application server was not
managing database connection resources
efficiently, which caused waste of DB
connection resources. This problem has
occurred as DB connections were not
checked back when done.
Finally, the operations team needs a mean to
enable continuous monitoring of Web,
Application and DB servers for run-time
issues in order to be able to preventive
actions as required.
Identify three architectural patterns to
address these situation, while explaining how
each of the patterns will be operating to solve
these situations?
1.
2.
3.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Database systems are often made up of processes (also known as threads) that interact with shared memory resources to communicate with one another.What, if any, restrictions are placed on access to the shared memory space?Is two-phase locking the most acceptable strategy for serialising access to data structures in shared memory? Your answer should be backed up by logic.
What is the Big O category of the database execution time? If there's just one more task, I'll do it. In a single operation, how many deletions occur? Even if it were to be used in the context of a single commercial, it would be irrelevant. In direct response to a single Internet search?
In terms of performance tuning, how do buffer management strategies influence database response times?
In contrast to file-system implementers, database-system implementers have given far greater attention to the ACID characteristics. What may be the reason behind this?
Think about the snapshot isolation-based database system used by an airline. Can you provide an instance of a non-serializable execution that the airline is prepared to accept in exchange for a higher overall performance?
What Big O category does the database's execution time fall under? If it's only one more thing, I'll do it. How many deletions may be performed within a single operation? It makes no difference if it will be used for a single advertisement or several advertisements. As a direct result of a single web search?
Evaluate different strategies for handling failures and recovery in a distributed database environment.
It takes the vigilant watch of a supervisor in order to keep a database in good shape. The question is, what precisely does this entail? What does a normal day look like for a database administrator?
It's recommended that you begin with a database that is administered by a flight service and makes use of "snapshot isolation" to get the most out of this illustration. What if the airline's improved overall performance was not due to a serializable execution, but rather to a non-serializable one?
What is the Big O categorization of the execution time for constructing the database? Of a single insertion? Of a single removal? Of a single add? Of a single search?
An airline that uses snapshot isolation in its database management system is a good example. What non-serializable executions is the airline willing to put up with in order to improve overall performance?
What are some of the hazards that a server database migration project could entail?