Discuss how each recommended database system architecture

Assignment Help Computer Engineering

Reference no: EM133626790

Question: You work as a database developer for an online consumer feedback organization. With the significant impact of online reviews on the success of consumer products and organizations, there has been a flurry of inauthentic reviews. Your organization helps businesses get direct and authentic feedback from users through the use of their online portal. It does not pay users of their client's products to write reviews or provide feedback, but it has made significant investments in making its online portal a fun and entertaining experience for users.

Five years ago, 97% of the consumer feedback received was text-based. Today, only 27% of its consumer feedback is text-based, with the majority being short videos. Additionally, six months ago, your organization signed its two largest clients and has since seen a 129% increase in user feedback. The organization expects these trends to continue.

It has also seen its current database system availability decrease every year for the last four years and experienced an embarrassing 12-hour outage three months ago. There has also been a decrease in database performance, with users complaining about the time it takes to upload videos.

The current database system was designed eight years ago for very different business and data models. You have been asked to design a new database architecture. As the first step in this process, you need to creat a comparison table that identifies issues with the current database system and examines how different new database architectures would resolve those issues.

Your comparison table should do the following:

Summarize at least 4 database performance issues or database design issues for your organization.
Recommend at least 3 new database system architecture designs that you think could perform better for your organization.
Discuss how each recommended database system architecture will resolve the identified database issues.

Reference no: EM133626790

Questions Cloud

Adult and child cpr - aed : Adult and Child CPR, AED, Hands Only CPRthe videos and content in this section and complete the assignment items

Identify the risk factors that impact the family dynamics : Select one of the models to discuss and then identify the risk factors that impact the family dynamics, parent, and/or child.

Discuss the pros and cons of the product-solution designed : The product can be catastrophe bond, parametric-trigger or multi-trigger insurance or the combination of all the tools that might fit the need to your answer.

What are the familys strengths or protective factors : What are the family's strengths or protective factors? How would you feel if these parents were friends of yours? What might you have done?

Discuss how each recommended database system architecture : Summarize at least 4 database performance issues or database design issues for your organization. Recommend at least 3 new database system architecture designs

Create a new table named large_ports : Create a new table, named LARGE_PORTS, using the existing PORT table as your source. A large port is defined as any port with more than 25 docks

Identify three pros and cons to counseling in community : Identify three pros and three cons to counseling in the community or home and explain your reasoning.

How do you find an external ip address attempting : How do you find an external IP address attempting to communicate with the firewall that comes back as malicious when using an open sourse intelligence to like

Identify the type of mitigation : The parts you've ordered might not arrive on time - or at all for that matter. Give a mitigation solution and identify the type of mitigation.

User Account

All Pages