In the final project for this course, you will imagine that you are an IT busine

Question

In the final project for this course, you will imagine that you are an IT business analyst intern at Sharpe Style in the scenario provided and have been asked by the owner to research options for improving the business’s performance through the use of technology. Specifically, the owner wants to expand the business’s retail presence into online sales and ensure a positive customer experience by incorporating intelligent systems into the website. You will create a business report for business owner Mary Sharpe that analyzes the business’s stated and anticipated technology and information system requirements, compares and contrasts different technology solutions available, and provides suggestions on technology opportunities that would support the business venture. You should explain in detail how the different options could help grow the business and/or improve operational efficiency and client satisfaction, using real-world examples and references to support the suggestions. You should also keep in mind that the business owner is not a technology specialist. Consequently, you should use nontechnical language in crafting the business report and remember that the owner may not always know what technology is needed to carry out a particular option or how much it costs. Prompt: For Milestone Two, you will be assessing the database needs and options for Sharpe Style. After looking at how the SDLC applies to your final project, a good next step is looking at the data. Think small and see where your requirements take you. Remember that Mary is worried about how she will keep track of her inventory when she migrates into online sales. You will be using the Milestone Two section of the template to complete this assignment. Refer to the Sharpe Style scenario for details on the current state of the company and the business owner’s goals. Based on what you have learned in Module Three, assess the type of database technology the company will need to support new online services. Once you have established the company’s needs, you should research the available options. Present a minimum of two. Keep in mind that Mary Sharpe is looking for an inexpensive and easy-to-implement solution. What are the pros and cons of each option? For this assignment, find a real-world example of what has or has not worked for another company. Talk about how this example informs the options you will present to Mary Sharpe. Make sure you site your source(s) appropriately. Remember that you are an intern and are not expected to make suggestions that encompass a deep level of technical detail. You are expected to provide a highlevel view of what would be required to help your business owner make an informed decision regarding database needs for online services. Use the Milestone Two section of the template and submit the template to your instructor for feedback and grading. Remember to incorporate instructor feedback before your final submission in Module Seven. Specifically, the following critical elements must be addressed: II. Database Needs and Options: Use this section of your report to assess the business’s database needs with respect to the proposed expansion into online sales, and lay out possible solutions for meeting the needs you identified. Specifically, you should address the following: A. What type of database technology will the company need to support the new online services? Explain your answer. For example, how will the company keep track of inventory and customer information for sales in the retail versus the online store? Will two separate databases be needed? Will the company need to integrate its database(s) with other software to serve intelligent functions such as inventory tracking, order tracking, or payments? B. Weigh the pros and cons of different solutions for addressing database needs in general terms. Justify your response. For example, will the option require migrating data to a new system? Will it require a different server setup? Is the cost of the solution outweighed by the potential benefits in terms of improving efficiency and increasing sales? To illustrate your point(s), you may want to include real-world examples of what has or has not worked for other companies.

Explanation / Answer

Based on the requirements : There are two separate use cases:

Data Storage - keep track of the inventory (Warehouse RDBMS type of DBs )

Data retrieval - Online users. (OLTP / NoSQL dbs)

Capabilities Needed NoSQL WareHouse Applicance OLTP Peform; Fetch fast . Quick data retrieval *MPP overhead - not suited for sub-second query response Performance issues on large data sets. { Workarounds like hints for improving performance may adversely impact with new releases/patch.} Process Large volume of Data Supports processing high volume of data.   (inserts) are efficiently processed even at large volumes. but updates and deletes are expensive Data load is comparatively slower, it is not a pure MPP. Also overheads due locking and latching. Support complex queries. Range Queries often have performance issues Complex queries over large data sets are easily handled, Aggregates results, quickly Performance issues on large data sets. MPP support Yes Yes Partial support. Not a true MPP Programming language Support Native Drivers: Java
PHP
Ruby
C#
Python
JavaScript
Haskell
Perl
C++
Erlang Native Drivers:
    PHP
    Perl
    Python
    Ruby
    C
    C++
    C#
    Java
    Erlang Native Drivers: Java                        PHP
    Perl
    Python
    Ruby
    C
    C++
    Pro C Export/data extract option available The enduser should use java or other languages to consume data. (API calls
JavaScript, REST) Can export data in different formats. Yes Fault tolerance ; How durable writes are in the case of power failures, partitions, and other failure scenarios ? Depend fundamentally on sharding data across large numbers of hosts, they are particularly prone to failures. - Lost updates frequent patch releases- impacts availability Yes Administration Efforts Medium Lot of admin activities. - No support for delta backup , you can only backup a full table.
- No support for "point in time" recovery.
- No support for a schema/database wide consistent recovery (you can only backup/recover a complete table) Requires lots of admin and maintenance activities. (Statistics, Index maintenance, Backups)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.